Introduction to Databases

Introduction to the program provides a preview of the course and outlines the structure of the content. It delves into the day-to-day work of a database engineer and introduces the concept of databases and their relevance. You will also gain insights into Structured Query Language (SQL), its usage, and advantages.

• Gain insight into the day-to-day work of a database engineer
• Understand the concept and relevance of databases
• Learn about the usage and advantages of Structured Query Language (SQL)

The Create, Read, Update, and Delete (CRUD) Operations module covers numeric and string data types, default values, and various SQL statements such as CREATE, INSERT, SELECT, UPDATE, and DELETE. You will also engage in self-review exercises and knowledge checks related to these operations.

• Understand numeric and string data types
• Learn about default values and various SQL statements
• Engage in self-review exercises and knowledge checks for practice

SQL Operators and Sorting and Filtering Data module delves into SQL arithmetic and comparison operators, the ORDER BY and WHERE clauses, and the SELECT DISTINCT clause. You will explore various examples and engage in self-review exercises and knowledge checks to reinforce your understanding.

• Explore SQL arithmetic and comparison operators
• Understand the usage of ORDER BY and WHERE clauses
• Learn about the SELECT DISTINCT clause and engage in self-review exercises

The Database Design module covers database schema, relationships, keys, and database normalization. You will explore entity relationship diagrams, keys in depth, and engage in self-review exercises and knowledge checks to solidify your understanding of database design principles.

• Understand database schema, relationships, and keys
• Explore entity relationship diagrams and database normalization
• Engage in self-review exercises and knowledge checks for practice

The Graded Assessment module provides a recap of the course, prepares you for the final graded quiz assessment, and offers guidance on next steps after completing the course. You will also have the opportunity to reflect on your experience working with databases.

• Recap the course content and prepare for the final graded quiz assessment
• Receive guidance on next steps after completing the course
• Reflect on your experience working with databases