01:02:23 Hours On demand videos
1 Lessons
Full lifetime access
Access on mobile and tv
none
A crash course in SQL. How to write SQL from scratch in 1 hour.
In this video I show you how to write SQL using SQL Server and SQL Server Management Studio. We go through Creating a Database, Creating Tables, Inserting, Updating, Deleting, Selecting, Grouping, Summing, Indexing, Joining, and every basic you need to get starting writing SQL.
TABLE OF CONTENTS
Skip Intro/Discuss Management Studio 3:27
Create Database 5:10
Create Table 7:26
Insert Data 10:29
Select Statement 17:43
Where Clause 19:00
Update Statement 22:25
Delete Statement 24:33
Adding Comments 27:41
Adding Columns 29:33
Drop Table 32:38
Add Primary Key 33:17
Create Products Table 36:00
Create Orders Table 38:54
Foreign Keys 45:37
Joins 50:30
Functions/Group By 56:50
Our goal is to help people with a free platform to learn online. Come and learn on Zversity. We do not charge a fee or anything here. This is a free university made for us all. Happy learning!
666 Courses
384 Students
9 Reviews
Average rating