Courses

Understand in-depth the concepts of MongoDB and apply them. Become a MongoDB Database Architect. Apply for MongoDB jobs. What you'll learn: Understand what is MongoDB and its applicationPrepare for MongoDB CertificationIntroduction, Installation, Configuration of MongoDBCRUD Operations (Create, Read, Update, Delete, Insert)Data Modeling and Model Tree StructureOn-demand Materialized Views, Capped Collections, Text SearchDatabase References, Write Concern, AggregationOperators - Query Projection, Comparison, LogicalOperators - Evaluation, Array, UpdateUpdate Documents, Field Update Operator, Array Update Operator, Bitwise Update OperatorIntroduction to mongo Shellmongo Shell Methods - Collection Methods, Cursor and Database Methods, Bulk Operation MethodsIndexes and StorageReplication and Deploying the ReplicationShardingAdministering MongoDBInterview QuestionsPractical Demo A warm welcome to the MongoDB course by Uplatz. MongoDB is a very popular NoSQL database that is fast and scalable. When scalability and speed are required, this database shines. It is a document database which imposes very little and has drivers for many programming languages. MongoDB is a general purpose, document-based, distributed database built for modern application developers and for the cloud era. Uplatz provides practical training on MongoDB with focus on real-world scenarios and examples. This MongoDB training course will get you familiar with this unique database and arm you with the essential skills to start using mongo to power your software application. This course will teach you how to get mongo running, manipulate and query data, index for speed, and arm you with the essential skills required to start using Mongo.As table-based databases struggle to cope with an ever-growing variety of data, this MongoDB training course will show you how its document-oriented nature will allow you to quickly build highly scalable applications. You will gain the skills to develop, administer, secure, and scale MongoDB-based applications, and acquire low-cost, data-driven applications with MongoDB as the back-end database.This MongoDB course is designed to give delegates experience of installing and using the MongoDB database. It introduces delegates to the concept of a document-oriented database, then shows how to set up MongoDB for use. Delegates use the built-in shell and various APIs to build a database access application and manipulate data. We also investigate optimising queries using indexes and aggregating data with MongoDB functions.The course ends with some popular interview questions that you will face in a MongoDB database developer/architect/DBA job role. MongoDB Course Curriculum Introduction to NoSQL Architecture with MongoDBWhat Is MongoDB?Downloading the required SoftwareInstallation and ConfigurationMongoDB AdvantagesMongoDB Data ModellingMongoDB Tools, Collection and DocumentsConfiguration FilesTouring the File StructureSecuring the Installation CRUD and the MongoDB ShellIntroduction to CRUDIntroduction to the MongoDB APICreating a Database, Collection and Documents Data Modelling and Schema DesignMongoDB Database ReferencesModel Tree StructuresMongoDB Analyzing QueriesMongoDB Atomic OperationsMongoDB Map ReduceMongoDB Text SearchMongoDB Regular ExpressionMongoDB Capped CollectionsData StorageWorking with DatatypesCollectionsDocument DatatypesCreating _id Fields Querying DataDatabases and CollectionsQuerying CollectionsWorking with OperatorsReferencing a DatabaseQuerying Dates Manipulating DataInserting Data into CollectionsUpdatesDeletesAtomic OperationsRemoving DataCapped Collections High Performance OptionsCreating IndexesManipulating Index BehaviourIndex PropertiesSpecialised Index TypesReplicationSharding Aggregation FrameworkAggregating ResultsSingle Purpose FunctionsThe Aggregation PipelineDate Aggregation Operators IndexingIndexing and AggregationIndexing, query profiling and the query optimizerGeospatial IndexesIndex types, Index PropertiesMongoDB Advanced IndexingMongoDB Indexing LimitationsAggregation Introduction ReplicationReplication ConceptFailover & Recovery AdministrationMongoDB Deployment and Cluster setupMongoDB GridFSTrident SpoutWorking with Replica SetsMongoDB ShardingMongoDB Create Backup Using an APIIntroducing DriversJavaPHPRubyPython MongoDB Course ObjectivesDevelop highly scalable and cost-efficient applications with MongoDBBuild efficient MongoDB data models for enterprise-scale applicationsEnhance performance with indexing and shardingManage consistency with write concern and read preferenceProcess data and compute results with aggregation pipelines and MapReduceBy the end of the MongoDBtraining, the students will be able to:Install and setup the MongoDB databaseUse the MongoDB shell to access the databaseCreate, retrieve, update and delete dataUse aggregation queriesAppreciate the APIs used to interface with MongoDBUnderstand the document based structure of the databaseUse an API to develop applicationsOptimise queries with indexesDocument based data modellingCreate document collectionsCRUD operations with the Mongo shellAggregation pipelinesMongoDB transactionsMongoDB access using programming languagesCreate indexes

Learn the basics of building databases in a platform agnostic way so you can continue on to other platforms later. Explore database setup, servers, GUIs, tables, objects, and more.

Utilizing the right Azure database service can be daunting given the large number of options. In this course, Microsoft Azure Solutions Architect: Design for Databases, you’ll learn to identify the right database to meet all requirements. First, you’ll explore key types of data organization and database offerings in Azure. Next, you’ll discover Azure SQL Database deployment options and capabilities. Finally, you’ll learn how to use capabilities to ensure required encryption levels both at rest and in transit. When you’re finished with this course, you’ll have the skills and knowledge of database services in Azure needed to meet database needs using Azure options.

Learn to create, manage, and secure databases with SQL Server and essential DBA tools. Large datasets containing mission-critical data that's designed to be accessed at scale and in large volumes require careful planning and execution. In this course, Database Administration: Creating and Managing Databases, you will be introduced to the concepts and hands-on tools you'll need to design and build a relational database using MySQL. You'll explore key design topics like how to choose a schema and how to select the right storage engine and character set. When you're done, you'll be comfortable setting up a relational database for your own environment.

This course is intended to give architects, engineers, and developers the skills required to help enterprise customers architect, plan, execute, and test database migration projects. Through a combination of presentations, demos, and hands-on labs participants move databases to Google Cloud while taking advantage of various services. This course covers how to move on-premises, enterprise databases like SQL Server to Google Cloud (Compute Engine and Cloud SQL) and Oracle to Google Cloud bare metal.

This course is intended to give architects, engineers, and developers the skills required to help enterprise customers architect, plan, execute, and test database migration projects. Through a combination of presentations, demos, and hands-on labs participants move databases to Google Cloud while taking advantage of various services. This course covers how to move on-premises, enterprise databases like SQL Server to Google Cloud (Compute Engine and Cloud SQL) and Oracle to Google Cloud bare metal.

This course is intended to give architects, engineers, and developers the skills required to help enterprise customers architect, plan, execute, and test database migration projects. Through a combination of presentations, demos, and hands-on labs participants move databases to Google Cloud while taking advantage of various services. This course covers how to move on-premises, enterprise databases like SQL Server to Google Cloud (Compute Engine and Cloud SQL) and Oracle to Google Cloud bare metal.

This course is intended to give architects, engineers, and developers the skills required to help enterprise customers architect, plan, execute, and test database migration projects. Through a combination of presentations, demos, and hands-on labs participants move databases to Google Cloud while taking advantage of various services. This course covers how to move on-premises, enterprise databases like SQL Server to Google Cloud (Compute Engine and Cloud SQL) and Oracle to Google Cloud bare metal.

This course is intended to give architects, engineers, and developers the skills required to help enterprise customers architect, plan, execute, and test database migration projects. Through a combination of presentations, demos, and hands-on labs participants move databases to Google Cloud while taking advantage of various services. This course covers how to move on-premises, enterprise databases like SQL Server to Google Cloud (Compute Engine and Cloud SQL) and Oracle to Google Cloud bare metal.

If you want to successfully migrate databases into the AWS cloud, then this course is for you. By viewing this course, you will learn the skills needed to manage and troubleshoot migrations using the AWS Database Migration Service (DMS). At the core of migrating databases into the AWS cloud is a thorough knowledge of the AWS Database Migration Service (DMS). In this course, Migrating Databases with AWS Database Migration Service, you’ll learn how to migrate databases from on-premise into the AWS cloud. First, you’ll discover how to configure and deploy replication servers that you will use to manage your database migration. Next, you’ll explore DMS tasks - tasks that sit at the heart of your migration. Finally, you’ll learn how to monitor and troubleshoot your database migrations. When you’re finished with this course, you’ll have a foundational knowledge of database migrations that will help you as you move forward to successfully migrate your production databases into AWS.

The Microsoft cloud includes a powerful data platform. This course will teach you how to configure and implement NoSQL databases in Azure. The Microsoft Azure Architect Technologies exam is for aspiring Solution Architects that want to take their cloud career to the next level. In this course, Microsoft Azure Solutions Architect: Implement a NoSQL Databases Strategy, you’ll learn to provision NoSQL databases in Microsoft Azure. First, you’ll explore storage account tables. Next, you’ll discover how to select the appropriate Cosmos DB APIs. Finally, you’ll learn how to set up replicas in Cosmos DB. When you’re finished with this course, you’ll have the skills and knowledge of NoSQL databases in Microsoft Azure needed to implement and manage data platforms.

Databases are pervasive in corporations, government agencies and almost any organization across the globe. A number of jobs work solely with databases, like Database Administrator, Database Developer and Database Architect. Numerous other in-demand occupations also need to have database skills, including Software Engineers, Data Scientists and Cybersecurity Engineers. For many decades, organizations have been using Relational Databases. But recently, a new type of database has begun to emerge, NoSQL Databases, adding complexity for professionals seeking to learn how to use database management systems. In this program, you will learn all aspects needed to work as a Database Administrator and Architect and will learn key database skills beneficial in other occupations. The program covers both Relational Databases and NoSQL Databases. It also covers how to create your own databases and how to interact with the data within them.

Explore the concept of database guardrails and their crucial role in modern software development in this hour-long conference talk. Discover why traditional test suites fall short in capturing database-related issues and learn how to integrate database guardrails into your software development lifecycle (SDLC) for improved reliability and performance. Delve into the power of OpenTelemetry for enhancing the entire development process, from validating scalable data access queries to preventing database downtime during deployments. Gain insights on implementing automated observability and troubleshooting across all layers of the tech stack. Walk away with key takeaways on improving SDLC with database guardrails, practical applications of OpenTelemetry, and achieving automated observability in the data access layer.

Explore the evolution of database management and the concept of database guardrails in this conference talk from Conf42 JavaScript 2023. Delve into the complexities of modern database systems, including challenges with slow queries, schema changes, indexing, and ORM issues. Learn about monitoring and observability techniques, with a focus on OpenTelemetry and Jaeger. Discover how database guardrails can proactively address common problems by providing context, analyzing queries, and integrating with source code and pull requests. Gain insights into executing SQL queries and implementing effective database management strategies to enhance developer productivity and system reliability.

Explore a paradigm shift in database development and maintenance through this 46-minute talk. Delve into the current industry challenges, including inadequate prevention of bad code deployment, lack of effective observability and monitoring tools, and unreliable troubleshooting methods. Discover the concept of database guardrails as a novel approach to address these issues. Learn how this new paradigm can empower developers to take ownership of database solutions and navigate the complexities of modern database management more effectively.

This course will teach you the database management skills to prepare you for the data management portion of the Microsoft Azure Solutions Architect (AZ-303) certification exam. The AZ-303 certification examines the skills required to implement, configure and manage Azure SQL database solutions. In this course, Microsoft Azure Solutions Architect: Implement an Azure SQL Databases Strategy, you’ll learn the Azure SQL Database management skills addressed on the AZ-303 exam. First, you’ll explore configuring Azure SQL database settings and how to implement Azure SQL Database managed instances. Then, you’ll examine how to configure redundancy and high availability options for an Azure SQL database. Finally, you’ll learn how to Publish on-premise databases to Azure. When you’re finished with this course, you’ll have the skills and knowledge required to implement an Azure SQL Databases strategy, along with a familiarity of the topics needed to prepare for certification.

Welcome to the third course in the AWS Certified Solutions Architect – Associate certification track, Storage, Databases, and Migration for Associate AWS Solutions Architects.This course will focus on AWS storage, databases, and migration, and it will help to prepare you to take the AWS Certified Solutions Architect – Associate (SAA-C02) exam, and has been developed to provide you with the requisite knowledge to not only pass the AWS CSA-A certification exam but also gain the hands-on experience required to become a qualified AWS Solutions Architect working in a real-world environment.

AWS: Databases and Migration is the seventh course of Exam Prep (SAP-C02): AWS Certified Solutions Architect - Professional Specialization. In this course, learners will explore Amazon RDS, covering Multi-AZ and Read Replica deployments, failover simulations, and comparisons with self-managed EC2 databases. The course also examines Data warehousing with Amazon Redshift and in-memory caching with Amazon ElastiCache. A significant portion focuses on Amazon DynamoDB, covering table creation, indexes (LSI & GSI), capacity, consistency, transactions, Streams, and DAX. Finally, the course addresses migration strategies using AWS Migration Hub, Application Discovery Service, and Schema Conversion Tool. This course facilitates learners with approximately 3:00-3:30 Hours of Video lectures that provide both Theory and Hands-On knowledge. Also, Graded and Ungraded Quizzes are provided with every module to test learners' ability. Module 1: Relational Databases in AWS Module 2: Non-Relational Databases and Migration in AWS This course is designed for professionals seeking to demonstrate a comprehensive understanding of core AWS database services, including relational, NoSQL, caching, and data warehousing solutions. Understanding these services and essential migration tools is crucial for effectively building, deploying, and migrating applications and data on the AWS platform. - Senior Solutions Architects - Enterprise Architects - Cloud Infrastructure Architects - Senior DevOps Engineers By the end of the course, learners will be able to: - Learn use cases of RDS, Aurora, Redshift, ElastiCache, and DynamoDB. - Deploy Multi-AZ setups, read replicas, and DynamoDB indexes. - Understand AWS migration tools: Migration Hub and SCT.

Master database fundamentals in this comprehensive 97-minute video covering everything from basic database concepts to advanced topics in modern database management. Start with core definitions of databases, DBMS, and RDBMS before exploring popular database systems including MySQL, PostgreSQL, Oracle SQL, and NoSQL solutions like MongoDB. Get hands-on installation guidance for various database systems while learning key differences between SQL and NoSQL approaches. Discover emerging technologies like vector databases, their use cases, and advantages. Through detailed explanations of data models, DBMS advantages, and practical demonstrations, develop a strong foundation in database management that spans traditional relational databases to cutting-edge vector database solutions.

Explore the concept of database guardrails in this 45-minute Platform Engineering webinar. Learn how to prevent bad code from reaching production, monitor databases effectively, and automatically troubleshoot issues. Discover why typical test suites fall short in capturing database-related problems and why a new approach is necessary. Delve into using OpenTelemetry to enhance the entire software development lifecycle. Gain insights on validating data access for scalable queries, ensuring database stability during deployments, and implementing automated root cause analysis for database issues. Master the art of building database guardrails using OpenTelemetry, designing efficient database execution plans, and automating observability and troubleshooting for your data layer.