SQL and Relational Databases 101

Description

In this course, you will learn:

• Understand the fundamentals of the SQL language and relational databases. You will begin by learning about the relational model and its principles and restrictions.
• By the end of this course, you will have learnt and applied the five fundamental SQL statements, some advanced SQL syntax, and join statements.
• This is not the conventional textbook introduction. You aren't merely learning from lectures.
• At the conclusion of each module, there are assignments, hands-on activities, review questions, and a final exam. You will receive a certificate upon successfully completing this course. So, lets get started!

Syllabus:

1. SQL and Relational Databases 101

• Introduction to SQL and Relational Databases
• Information and Data Models
• Types of Relationships
• Mapping Entities to Tables
• Relational Model Concepts

2. Relational Model Constraints and Data Objects

• Relational Model Constraints Introduction
• Relational Model Constraints Advanced

3. Data Definition Language (DDL) and Data Manipulation Language (DML)

• CREATE TABLE statement
• INSERT statement
• SELECT statement
• UPDATE and DELETE statements

4. Advanced SQL

• String Patterns, Ranges, and Sets
• Sorting Result Sets
• Grouping Result Sets

5. Working with multiple tables

• Join Overview
• Inner Join
• Outer Join

Show more