YoVDO

Learn SQL in 60 Minutes

Offered By: Web Dev Simplified via YouTube

Tags

SQL Courses Relational Databases Courses Data Manipulation Courses Aggregate Functions Courses

Course Description

Overview

Master SQL fundamentals in this comprehensive 56-minute video tutorial. Explore the importance and applications of SQL, delve into its syntax, and work through multiple practical examples. Cover essential concepts including database creation and manipulation, table management, data insertion and retrieval, filtering with WHERE clauses, JOINs, aggregate functions, and advanced grouping techniques. Gain hands-on experience with exercises from the provided GitHub repository and learn how to install MySQL. Perfect for beginners and those looking to solidify their SQL knowledge, this tutorial equips you with the skills to effectively interact with and manipulate data in relational database systems.

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

Related Courses

Introduction to Databases
Meta via Coursera
Web Development
Udacity
Introduction to Data Science
University of Washington via Coursera
Datenmanagement mit SQL
openHPI
Sabermetrics 101: Introduction to Baseball Analytics
Boston University via edX