SQL Basics Tutorial for Beginners (Practice SQL Queries) HD

SQL Basics Tutorial for Beginners is made to help you learn SQL the right way. Video also includes Practice SQL Queries which can be downloaded from my blog (link mentioned below). This is a complete SQL Tutorial covering all the SQL Basics including how to write simple SQL Queries. This Basic SQL Tutorial is aimed at beginners who are new to SQL programming language or are just exploring an easy programming language to get started. This SQL Tutorial for Beginners not only explains the concept of SQL but also go through all the different types of queries that can be written using the basic SQL concepts. Timestamps: 00:00 Intro 01:42 What is SQL 03:14 Different types of SQL Commands 03:36 What is Data Definition Language (DDL) 04:46 What is Data Type in SQL 06:11 What are Constraints in SQL 08:33 What is Data Manipulation Language (DML) 09:40 Practice SQL Commands (DDL, DML) 21:10 What is Data Query Language (DQL) 23:13 Practice simple SQL Queries 25:18 Operators in SQL (Comparison Operators, Arithmetic Operators, Logical Operators) 34:48 Case Statement in SQL 36:15 Different ways to write queries in SQL 42:30 UNION and UNION ALL Operators in SQL 47:18 GROUP BY Statement in SQL 56:10 Sub Queries in SQL 58:55 Aggregate Functions in SQL (AVG, MIN, MAX, COUNT, SUM) 01:01:56 SQL Joins (Inner Join, Left Join, Right Join, Full Outer Join) At 70 minutes this video tries to cover all of the Basic SQL concepts and SQL Queries which are required to get started with SQL. We cover the following: 1. Introduction to SQL • Why is it important to learn SQL. 2. What is SQL? 3. SQL Commands • DDL (Data Definition Language) i. CREATE Table ii. ALTER Table iii. DROP Table iv. TRUNCATE Table • DML (Data Manipulation Language) i. INSERT ii. UPDATE iii. DELETE • DCL (Data Control Language) i. GRANT ii. REVOKE • TCL (Transaction Control Language) i. COMMIT ii. ROLLBACK iii. SAVEPOINT • DQL (Data Query Language) i. SELECT 4. Different SELECT Query functionalities: • SQL Operators i. Logical Operators ii. Comparison Operators iii. Arithmetic Operators • CASE Statement • Two ways of writing SQL Queries i. Using comma separator ii. Using JOIN • UNION & UNION ALL Operators • GROUP BY Statement i. HAVING Clause • Subquery • Aggregate Functions i. COUNT ii. AVG iii. MIN iv. MAX v. SUM • SQL JOINS i. INNER JOIN ii. OUTER JOIN 1. LEFT OUTER JOIN 2. RIGHT OUTER JOIN 3. FULL OUTER JOI