Learn SQL In 60 Minutes
In this video we will cover everything you need to know about SQL in only 60 minutes. We will cover what SQL is, why SQL is important, what SQL is used for, the syntax of SQL, and multiple examples of SQL. SQL is the standard language for interacting with and manipulating data in a relational database system, and is one of the most important concepts you can learn in programming. It allows you to create, read, update, and delete data which is something nearly every application will need to do.
IMPORTANT: Exercises Worksheet Repository:
How to Install MySQL:
Outline:
[00:00] – Intro
[05:10] – SQL Syntax
[07:30] – Create Database
[09:20] – Drop Database
[10:34] – Use Database
[11:22] – Create Table
[13:01] – Alter Table
[14:47] – Drop Table
[15:08] – Create Table (Part 2)
[15:35] – Band Table
[15:55] – Not Null
[16:10] – Primary Key/ID/Auto Increment
[18:40] – Album Table
[20:05] – Foreign Key/Table Relationships
[23:05] – Insert Into
[25:40] – Select
[26:27] – Limit
[26:52] – Specific Columns
[27:18] – As/Alias Columns
[28:20] – Order By
[29:24] – Insert Into (Part 2)
[32:04] – Distinct Select
[33:07] – Update
[33:40] – Where
[33:15] – Less Than
[33:55] – Like String Filter
[37:26] – Or
[38:04] – And
[38:40] – Between
[39:20] – Is Null
[39:46] – Delete
[41:00] – Join
[43:25] – Inner/Left/Right Comparison
[46:42] – Aggregate Functions
[48:05] – Group By
[50:40] – Combined With Join
[51:15] – Alias Tables
[53:57] – Having vs Where
Learn X in Y Minutes Playlist:
Twitter:
GitHub:
CodePen:
#SQL #LearnSQL #MySQL
#Learn #SQL #Minutes
learn sql
webdevsimplified,learn sql,learn sql in 1 hour,learn sql in 60 minutes,learn sql fast,learn sql for beginners,learn mysql,how to learn sql,how to learn sql quickly,how to learn sql fast,sql for beginners,sql for beginners tutorial,sql for beginners course,free sql course,free sql course for beginners,learn sql queries,learn sql queries step by step,how to write queries in sql,sql tutorial,sql tutorial for beginners,sql explained,sql in one video,sql
