CodeBirdy
Welcome
Login / Register

SQL For Beginners. Learn Basics Of SQL In 1 Hour

Thanks! Share it with your friends!

URL

You disliked this video. Thanks for the feedback!

Sorry, only registred users can create playlists.
URL


Added by Alex Madjeski in SQL
134 Views

Description

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

Post your comment

Sign in or sign up to post comments.

Comments

Be the first to comment
RSS