SQL Basics Tutorial for Beginners (Practice SQL Queries)

Channel	Publish Date	Thumbnail & View Count	Download Video
	Publish Date not found	0 Views	View on YouTube Download Video

The SQL Basics Tutorial for Beginners is designed to help you learn SQL properly.
The video also includes practice SQL queries which can be downloaded from my blog (link provided below).

This is a complete SQL tutorial that covers all the SQL basics including how to create simple SQL queries. This basic SQL tutorial is aimed at beginners who are new to the SQL programming language or want to try a simple programming language to get started.

This SQL tutorial for beginners not only explains the concept of SQL but also covers all the different types of queries that can be written using the basic SQL concepts.

Time stamp:
00:00 Introduction
01:42 What is SQL
03:14 Different types of SQL commands
03:36 What is Data Definition Language (DDL)
04:46 What is the 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 Subqueries 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)

This 70-minute video attempts to cover all the basic SQL concepts and SQL queries needed to get started with SQL.

We cover:
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 allow
ii. REVOCATION
• TCL (Transaction Control Language)
I. COMMIT
ii. ROLLBACK
iii. STORAGE POINT
• DQL (Data Query Language)
I choose
4. Various SELECT query functions:
• SQL operators
i. Logical operators
ii. Comparison operators
Arithmetic operators
• CASE statement
• Two ways to write SQL queries
i. Using a comma as a separator
ii. Using JOIN
• UNION and UNION-ALL operators
• GROUP BY statement
i. HAVING clause
• Subquery
• Aggregate functions
I count
Average
3. At least
MAXIMUM
vs. SUM
• SQL JOINS
i. Inner Join
ii. OUTER JOIN
1. LEFT OUTER JOIN
2. RIGHT OUTER JOIN
3. FULL OUTER JOIN

In this video, I use PostgreSQL to practice and execute the SQL commands and SQL queries. However, the SQL syntax and SQL concepts are also applicable to any other relational database or RDBMS (Relational Database Management System).

Download link:
Download the SQL scripts (DDL, DML and all SELECT queries) here:

https://techtfq.com/blog/sql-basics-tutorial-for-beginners

Click on this link:
1) Click on the “Download DDL & DML” button to download a “.sql” file containing all the create and insert table scripts to create the required tables and insert meaningful data into them.
2) Download SELECT Queries button to download another .sql file containing all the SELECT queries we practiced in this video.

My blog:
https://techtfq.com

Here you will soon find useful blogs about SQL, databases and much more.

Reference links:
If you want to learn more about SQL, I recommend you go through the following links:

PostgreSQL All supported data types:
https://www.postgresql.org/docs/9.5/datatype.html

PostgreSQL Tutorial Blog:
https://www.postgresqltutorial.com/

SQL Tutorial Blog:
https://www.w3schools.com/sql/default.asp