SQL is a special-purpose programming language designed for managing data in a relational database, and is used by a huge number of apps and organizations. Watch this Video to learn basics of SQL.
This Video covers below topics about SQL.
0:01 What is SQL?
2:07 Creating a Table and Inserting Data
5:52 Querying The Table
8:03 Aggregating Data
11:24 Queries with AND OR
15:59 Querying IN subqueries
21:22 Restricting Grouped Results with HAVING
25:52 Calculating results with CASE
31:51 JOINing tables
37:15 Joining related tables with left outer joins
41:21 Changing Rows with UPDATE and DELETE
45:54 ALTERing tables after creation
49:51 Joining tables to themselves with self joins
53:50 Combining multiple joins
By watching this Video we can learn how to use #SQL to store, query, and manipulate data.
And, you can watch the original interactive talk-through on Khan Academy, where you can pause and edit the code and see the code in better resolution at https://www.khanacademy.org/computing/computer-programming/sql or learn SQL from http://www.w3schools.com/sql/sql_intro.asp
I created this video with the YouTube Video Editor (http://www.youtube.com/editor) with creative commons permission videos provided by Khan Academy Computer Science
Subscribe to our YouTube channel at http://www.youtube.com/subscription_center?add_user=qualitypointtech
Buy T-Shirts and other Merchandise at https://shop.spreadshirt.com/QualityPointTech/
language
1436618695
2015-07-11 12:44:55
57:13
UCYl4FEoRuAv9G2v0cid5VnA
Rajamanickam Antonimuthu
5707
127
source
