A beginners guide to SQL commands and Database Design. Learn it through quick and easy steps.
What you will learn
Understand how to the design the database schema.
Learn SQL commands along with key insights about the logic behind the command.
Design queries, apply aggregations and combine information from multiple tables.
English
language
Content
Getting Started
Course Overview
MySQL Installation Guide
Introduction & Terminology
Getting started with basic commands
Script
Quiz
Basic DML
Projecting required columns through Query
Script
Insert data into the table
Script
Inserting multiple records
Script
Quiz
Arranging the data before display
Script
Filtering Data
Script
Quiz
Updating and Delete
Script
Quiz
Designing the Tables/Relations
Primary Constraints
Script
Identity Column
Script
Primary Key
Script
Need for splitting data into multiple tables
Referential Integrity
Script
Relationship and Cardinality
Script
Constraints over multiple columns
Script
Quiz
Query Design
Aggregate functions
Script
Grouping and applying aggregate functions
Script
Filtering groups
Script
Memorising queries 2
Quiz
Joins Introduction
Script
Inner and Outer Joins
Script
Subqueries
Script
Correlated Subqueries
Script
Quiz
Problem Set
Example Social App Schema Design
Schema Design – Part 1
Schema Design – Part 2
Schema Design – Part 3
Schema Design – Part 4
Social App Schema – Part 5
Script
Solutions to Problems in the Script
Other essential topics
ALTER command
Views
Index
Transactions
Quiz
Source
Scripts
What’s next?
Bonus Lecture: OFFER Coupons for my other courses