SQL Querying for Beginners Tutorial
232,101
Published 2022-01-07
Get Ad-Free Training by becoming a member today!
youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join
Exercise Files: bit.ly/3n5sr0G
SQL Express Download Link:
www.microsoft.com/en-us/Download/details.aspx?id=1…
Northwindsql Link:
raw.githubusercontent.com/microsoft/sql-server-sam…
Northwind Alternate: bit.ly/3sIvodn
If you are having issues with the Northwind DB pleases delete lines 24 and 25 and execute.
Who it's for: This course has been designed for individuals who wish to learn how to use SQL to query databases and extract information.
What it is: SQL stands for Structured Query Language. It’s a common language for gathering, organizing, and exporting data stored in relational databases.
What you'll learn: In this course, you’ll learn basic SQL usage and terminology, as well as how to execute simple queries and queries using criteria conditions. Next, you’ll learn how to summarize, organize, and export valuable query data and results.
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
www.learnitanytime.com/
Exercise Files: bit.ly/3n5sr0G
SQL Express Download Link:
www.microsoft.com/en-us/Download/details.aspx?id=1…
Northwindsql Download Link:
github.com/Microsoft/sql-server-samples/tree/maste…
If you are having issues with the Northwind DB pleases delete lines 24 and 25 and execute.
For Private Group Trainings please visit:
www.learnit.com/private-group-classes-workshops
Manuals: bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Introduction 0:03
Introduction to SQL 0:30
Installing SQL Server 4:27
SQL Keyword Command Language and Hierarchy 8:26
Connecting to a SQL Database 13:35
Creating and Saving a Query 22:44
Using One or More Query Conditions 32:43
Applying AND OR Operators 40:36
NULL NOT NULL 46:48
Range of Values 49:28
Querying Data Using Wildcard Characters 58:04
Formatting Column Headings with Aliases 1:04:48
Formatting Query Data Results 1:10:06
Performing Date Calculations - DateDifDateAdd 1:14:10
Summarizing Data Using Aggregate Functions AVG COUNT SUM min max 1:22:39
Manipulating Text Results with String Functions CONCAT_SUBSTR 1:30:26
Sorting Data Order BY and GROUPBY 1:38:07
RANK and HAVING 1:46:24
Mathematical Financial Expressions 1:52:23
PIVOT 1:58:24
JOIN 2:07:27
Union ALL 2:20:30
Except Clause 2:26:30
Sub Queries 2:28:25
Exports 2:40:41
Conclusion 2:44:04
#SQL #Query
(C) 2022 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
All Comments (21)
-
If you are having issues downloading the northwind file please use this online practice lab: www.sql-practice.com/
-
This instructor is probably the best I've seen so far. This course was at the right pace, and the right subject matter and has been such a great help. Thanks so much
-
OMG - perfect diction! Thank you Christina!! Some of the folks on here I cannot understand for they speak about 10,000 mph! Best and thank you for your time! Mort
-
We can't wait for more advanced tutorials by your state-of-the-art tutors like captain Dan McAllister ( the man with a gorgeously coarse voice),Sean Bugler (eloquent man), ma'am Chelsea Dohman (a sweetheart s voice), etc. They made me a programmer. God bless learnit
-
Very good video for a refresher! I was able to quickly pick up from where I left when I began learning SQL. Thank you for such a great content. You're awesome.
-
Thank you very much for making this tutorial, it really helped me out! Many tutorials out there just can't compete with your level of quality. Can't wait for intermediate and advanced tutorials! I hope they will be in the foreseeable future :)
-
Cant Wait for your full SQL course!!! so exited!!! 🤩🤩🤩
-
WOW What a best instructor! this is the most comprehensible SQL tutorial I have came across so far !✅✅✅
-
i love it! looking forward intermediate and advanced sessions as well. thankyou so much for the open upload of such quality content <3
-
Excellent instructor. Crystal clear explanation! Please add SQL queries intermediate, advanced, expert and database design with her. Dan McAllister also was an amazing instructor. Keep up the good work.
-
Very great SQL course and very specific. Thanks for sharing.
-
You guys make such good courses. I could learn anything explained by you.
-
Pretty neat, simple, and well-explained! Thanks for this tutorial! It helps me a lot!
-
Incredibly well done, I wish you could zoom in a bit when working in the query editor but really great job. Thank you very much
-
This is an incredible tutorial. I'm at the 1:57:00 mark and have already learned so much. Well done on teaching this!
-
Excellent,although very basic. Looking forward to your intermediate and advanced level of sql server tutorial 👍👍
-
Thank you for providing an excellent tutorial, pitched at exactly the right level for me ! I am now able to construct and execute my own enquiries at work without pestering the IT dept. every time
-
I watched a full, 3 minutes long advertisement as a simple way to support this marvelous channel:-;
-
Greattt, especially for me who is self-taught because I got a job as an IT Consultant DBA Now I have become proficient in MSSQL queries. But there are still some that I don't fully understand. This content has really helped me a lot. If I may request, I want to see the content of always on replication
-
Very clear lecture and easy to follow, thank you ! 👍
