Structured Query Language (SQL) basics | learn SQL | A step-by-step guide to SQL
In this video we will cover the fundamentals of Structured Query Language commonly known as SQL. This is a step-by-step guide on how to learn SQL. We will cover SQL's fundamentals such as Logical Query Processing and Entity Relationship Diagram (ERD) that will help us learn SQL and write efficient queries. This video will serve as a foundation. Also, we will cover the concepts in order so this will serve as a guide for you to build on your SQL skills.
Link to medium article on this topic: https://blog.devgenius.io/a-beginners...
Few SQL practice questions:
Provide data for all customers whose commute distance is 0-1 Miles?
Provide data for all customers who own less than one car? And with a commute distance of 0-1 Miles?
How many unique customers does Adventure Works have?
Subscribe to our channel:
/ haqnawaz
---------------------------------------------
Follow me on social media!
GitHub: https://github.com/hnawaz007
Instagram: / bi_insights_inc
LinkedIn: / haq-nawaz
---------------------------------------------
#SQL #SQLServer #Database
Topics covered in this video:
0:00 - Introduction to SQL
1:23 - Logical Query Processing
5:44 - Entity Relationship Diagram (ERD)
7:35 - SQL with practical examples (scenario 1)
11:39 - Scenario 2 - Solve problem with SQL
12:27 - Scenario 3 - refine SQL query