Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Jul 11, 2015
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. Buy SQL Books from Amazon at http://amzn.to/2tQcrXf 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.