This course aims to teach learners the fundamentals of SQL in just 60 minutes. By the end of the course, students will understand what SQL is, its importance, its syntax, and how to use it for data manipulation in relational database systems. The course covers creating databases and tables, altering them, inserting, selecting, updating, and deleting data. Students will also learn about joins, aggregate functions, and grouping data. The teaching method involves a fast-paced tutorial with practical examples and exercises. This course is intended for beginners or anyone looking to quickly grasp the basics of SQL.
Overview
Syllabus
[] - Intro
[] - SQL Syntax
[] - Create Database
[] - Drop Database
[] - Use Database
[] - Create Table
[] - Alter Table
[] - Drop Table
[] - Create Table Part 2
[] - Band Table
[] - Not Null
[] - Primary Key/ID/Auto Increment
[] - Album Table
[] - Foreign Key/Table Relationships
[] - Insert Into
[] - Select
[] - Limit
[] - Specific Columns
[] - As/Alias Columns
[] - Order By
[] - Insert Into Part 2
[] - Distinct Select
[] - Update
[] - Where
[] - Less Than
[] - Like String Filter
[] - Or
[] - And
[] - Between
[] - Is Null
[] - Delete
[] - Join
[] - Inner/Left/Right Comparison
[] - Aggregate Functions
[] - Group By
[] - Combined With Join
[] - Alias Tables
[] - Having vs Where
Taught by
Web Dev Simplified
