SQL Basics Tutorial for Beginners Practice SQL Queries

YOUR LINK HERE:

http://youtube.com/watch?v=Hl4NZB1XR9c

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 JOIN • In this video, I am using PostgreSQL to practice and execute the SQL commands and SQL Queries. However the SQL syntax and SQL concepts are applicable to any other Relational Database or RDBMS (Relational Database Management System). • Download Link: • Download the SQL Scripts (DDL, DML and all SELECT Queries) from here: • https://techtfq.com/blog/sql-basics-t... • From this link click on: • 1) “Download DDL DML” button to download a “.sql” file which has all the Create table and Insert Table scripts to create required tables and to insert meaningful data into it. • 2) “Download SELECT Queries” button to download another “.sql” file which contains all the SELECT Queries which we practiced in this video. • My Blog: • https://techtfq.com • Where you can find useful blog related to SQL, Database and many more in near future. • Reference Links: • If you wish to know more about SQL then I suggest going through the below links: • PostgreSQL All supported Data Types: • https://www.postgresql.org/docs/9.5/d... • PostgreSQL Tutorial blog: • https://www.postgresqltutorial.com/ • SQL Tutorial blog: • https://www.w3schools.com/sql/default... • 🔴 WATCH MORE VIDEOS HERE 👇 • ✅ SQL Tutorial - Basic concepts: • • SQL Tutorial - Basic concepts • ✅ SQL Tutorial - Intermediate concepts: • • SQL Tutorial - Intermediate concepts • ✅ SQL Tutorial - Advance concepts: • • SQL Tutorial - Advance concepts • ✅ Practice Solving Basic SQL Queries: • • Practice Solving BASIC SQL Queries • ✅ Practice Solving Intermediate SQL Queries: • • Practice Solving INTERMEDIATE SQL Que... • ✅ Practice Solving Complex SQL Queries: • • Practice Solving COMPLEX SQL Queries • ✅ SQL Course, SQL Training Platform Recommendations: • • SQL Course / Training

#############################

New on site