SQL Querying for Beginners Tutorial

Показать описание

SQL Querying for Beginners Tutorial

Get Ad-Free Training by becoming a member today!

SQL Express Download Link:

Northwindsql Link:

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:

For Private Group Trainings please visit:

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.

Рекомендации по теме

Комментарии

To anyone unable to see the Northwind Database on the left side of the screen:

(i) Rigth click on the folder "Databases" -> "New Database..."
(ii) On "Database name" write Northwind and click OK
(iii) Click "New Query", paste and execute the script

Thanks lolo for the great tip!

LearnitTraining

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

sepegden

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

mortonwakeland

WOW What a best instructor! this is the most comprehensible SQL tutorial I have came across so far !✅✅✅

ThekisoPhume

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.

wintermorillo

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 :)

dkorobchenko

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.

searchformeaning

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

kensimba

Great instructor! Thank you so much for this course, Christina. Your guidance has been invaluable and truly appreciated

omkarchogale

Guys, the instructor here is awesome. Her explanations on sql concepts are excellent. She made me develop a strong desire for sql. Its often been confusing all along in years past.

For the first time i saw there is a fine line separating sql from php though they both go together in my choice of programming. For the first time i wrote sql statements and ran them on the phpmyadmin environment and also saw a button that can help me generate the php code of sql.

Madam, i can't thank you enough. You are a 5 star GENERAL in the teaching of sql. You made it less frustrating and less intimidating. This is what a teacher looks like. Thank you again ma, i had to come back here after a week to give you this feedback, review and to subscribe to your channel. God bless you richly with more wisdom.

samnako

i love it! looking forward intermediate and advanced sessions as well. thankyou so much for the open upload of such quality content <3

shnuiiwithdoublei

Very great SQL course and very specific. Thanks for sharing.

terrychen

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

epm