MySQL, PostgreSQL and MongoDB Database Design Masterclass

Course Overview

• Course Title: MySQL, PostgreSQL and MongoDB Database Design Masterclass
• Instructor: George Steve
• Target Audience:
  • Aspiring Database Administrators
  • Backend Developers
  • Data Analysts and Engineers
  • Students and Tech Enthusiasts interested in database management and design
  • Professionals looking to expand their knowledge of SQL and NoSQL databases
• Prerequisites:
  • Basic knowledge of programming concepts is helpful but not required.
  • A computer with an internet connection to download necessary software and tools.
  • Willingness to learn and explore the world of database management.

Curriculum Highlights

• Key Topics Covered:
  • Database Setup and Fundamentals
  • SQL Database Design
  • NoSQL Database Design with MongoDB
  • Advanced Database Management
• Key Skills Learned:
  • Download, install, and configure MySQL, PostgreSQL, and MongoDB with Compass and Mongosh.
  • Create databases, tables, and define data constraints in MySQL and PostgreSQL.
  • Use SQL statements to insert, select, update, and delete data.
  • Implement advanced SQL features like JOINS, ORDER BY, LIMIT, UNION, SELF JOIN, and VIEWS.
  • Apply indexing and subqueries to optimize data management.
  • Set up MongoDB, work with Compass and Shell, and integrate with Visual Studio Code.
  • Design MongoDB collections and documents, manage arrays and embedded documents.
  • Execute operations like sorting, updating, deleting, and creating one-to-one reference relations.
  • Learn auto-commit, rollback, current date/time functions, logical operators, wildcards, and ordered insertions.

Course Format

• Duration: 12.5 hours on-demand video
• Format: Self-paced online course
• Resources:
  • 1 article
  • 35 downloadable resources
  • Access on mobile and TV
  • Certificate of completion