Duration 3 Days 18 CPD hours This course is intended for This introductory-level course is for experienced application developers new to MongoDB. Overview This course is approximately 50% hands-on lab to lecture ratio, combining engaging expert lessons, demos and group discussions with real-world, skills-focused machine-based labs and exercises. Working in a hands-on learning environment, guided by our expert team, you'll explore: Storage Basics MongoDB Document Model MongoDB Setup CRUD: Basics through Advanced Concepts Performance: Basics through Advanced Concepts Aggregation: Basics through Advanced Concepts Replication: Basics through Advanced Concepts Sharding: Basics through Advanced Concepts Schema Design Security Basics, Authentication & Authorization Application Development and Drivers Geared for experienced developers, Introduction to MongoDB for Developers is a comprehensive course that provides you with hands-on experience with the MongoDB query language, aggregation framework, data modeling, indexes, drivers, basic performance tuning, high availability and scaling. Throughout the course, you?ll explore the MongoDB Atlas database environment in detail, gaining job-ready skills you can put right to work after class. Storage Basics What is a Storage Engine? WiredTiger Storage Engine In-Memory Storage Engine Encrypted Storage Engine MongoDB Document Model JSON and BSON MongoDB Data Types MongoDB Setup Atlas Setup / Local MongoDB Setup CRUD Basics Insert Command Find Command Query Operators Remove Command Updating Documents CRUD Advanced Bulk Writes Retryable Writes Find and Modify Transactions Performance Basics Indexes Aggregation Basics Aggregation Pipeline Concepts Aggregation Pipeline Stages Aggregation Pipeline Expressions Aggregation Advanced $lookup stage $graphLookup stage $expr operator Faceted Search Type Conversions Advanced Expression Operators Date Expression Operators Expression Variables Aggregation Pipeline Optimizations Aggregation in a Sharded Cluster Replication Basics MongoDB Replica Sets Replica Set Use Cases Replication Mechanics Replication Advanced Using Write Concern to Tune Durability Semantics Using Read Concern to Tune Read Isolation Using Read Preference Replica Set Tag Sets Sharding Basics Sharding Concepts When to Shard What is a Shard Key? Zoned Sharding / MongoDB Atlas Global Clusters Sharding Advanced Components of a Sharded Cluster Sharding Mechanics Choosing a Good Shard Key Schema Design Schema Design Core Concepts Common Patterns Security Basics Authentication & Authorization Network Encryption Encryption at Rest Auditing
Duration 2 Days 12 CPD hours This course is intended for This is an advanced course for DBAs and technical individuals who plan, implement, and maintain Db2 11.1 databases Overview This course is designed to teach you how to: Perform advanced monitoring using the Db2 administrative views and routines in SQL queries. Manage the disk space assigned in Database Managed Storage (DMS) and Automatic Storage table spaces, including the activities of the rebalancer. Use SQL queries and Db2 commands to check the high water mark on table spaces and to monitor the rebalance operation. Utilize the REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces using database or tablespace backup images. Plan and execute the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases. Create incremental database or tablespace level backups to reduce backup processing and backup image storage requirements. Implement automatic storage management for table spaces and storage groups or enable automatic resize options for DMS managed table spaces to reduce administration requirements and complexity. Describe the various types of database memory including buffer pools, sort memory, lock memory and utility processing memory. Adjust database or Db2 instance configuration options to improve application performance or processing efficiency. Implement Db2 Self Tuning Memory management for specific database memory areas. This course is designed to teach you how to Perform advanced monitoring using the Db2 administrative views and routines in SQL queries. Manage the disk space assigned in Database Managed Storage (DMS) and Automatic Storage table spaces, including the activities of the rebalancer. Use SQL queries and Db2 commands to check the high water mark on table spaces and to monitor the rebalance operation. Utilize the REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces using database or tablespace backup images. Plan and execute the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases. Create incremental database or tablespace level backups to reduce backup processing and backup image storage requirements. Implement automatic storage management for table spaces and storage groups or enable automatic resize options for DMS managed table spaces to reduce administration requirements and complexity. Describe the various types of database memory including buffer pools, sort memory, lock memory and utility processing memory. Adjust database or Db2 instance configuration options to improve application performance or processing efficiency. Implement Db2 Self Tuning Memory management for specific database memory areas. Course Outline Advanced Monitoring Db2 Table Space Management Db2 Database Memory Management Database rebuild supportDb2 database and tablespace relocation Db2 Incremental Backup Additional course details: Nexus Humans CL464G IBM Db2 11.1 Advanced Database Administration training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the CL464G IBM Db2 11.1 Advanced Database Administration course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
Duration 2 Days 12 CPD hours This course is intended for This is an advanced course for DBAs and technical individuals who plan, implement, and maintain Db2 11.1 databases Overview Please refer to course overview This course is designed to teach you how to:Perform advanced monitoring using the Db2 administrative views and routines in SQL queries.Manage the disk space assigned in Database Managed Storage (DMS) and Automatic Storage table spaces, including the activities of the rebalancer.Use SQL queries and Db2 commands to check the high water mark on table spaces and to monitor the rebalance operation.Utilize the REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces using database or tablespace backup images.Plan and execute the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases.Create incremental database or tablespace level backups to reduce backup processing and backup image storage requirements.Implement automatic storage management for table spaces and storage groups or enable automatic resize options for DMS managed table spaces to reduce administration requirements and complexity.Describe the various types of database memory including buffer pools, sort memory, lock memory and utility processing memory.Adjust database or Db2 instance configuration options to improve application performance or processing efficiency.Implement Db2 Self Tuning Memory management for specific database memory areas. Advanced MonitoringDb2 Table Space ManagementDb2 Database Memory ManagementDatabase rebuild supportDb2 database and tablespace relocationDb2 Incremental Backup
Time for you to talk, explore and work through challenges you are facing... I help individuals find / reconnect with their passion & purpose, so they get up & do what they love! Giving people direction, self-confidence and belief to do the thing they want to do... Through 1:1 coaching, I create a space that supports people to explore and find solutions; giving clarity, confidence and energy to move forwards. If you feel stuck in your life or career, frustrated or unsure of how to move forwards, don't know what you want to do next... that's ok - we can work through your challenges at your pace over a series of coaching sessions that works for your time and budget.
This course enables providers and their staff to develop an understanding of the responsibilities and duties around the Mental Capacity Act 2005 (MCA). This essential training is for workers involved in the care, treatment and support of adults who may lack capacity in making life decisions. This training offers vital support for social care providers, so they comply with the Mental Capacity Act and Care Quality Commission requirements and promote human rights.
This course provides both underpinning knowledge of stoma care and practical techniques to deliver person centred support for someone who requires stoma care.
This course explores Autism and the current body of thinking and knowledge around Autistic Spectrum Disorders. This enables learners to consider how to adapt their practice with useful strategies to better support an individual with autism.
This course provides attendees with the knowledge required to assess and care for service users with dysphagia.
This CPD-certified course aims to get you thinking about children of parents with a mental illness and ways in which you could support them in your role.
This course will explore what we mean when we say someone has asthma