SQL Querying for Beginners Tutorial
SQL Querying for Beginners Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnskillsdaily
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com
Exercise Files: https://tinyurl.com/3ubesynm
SQL Express Download Link:
https://www.microsoft.com/en-us/Downl...
Northwindsql Link:
https://raw.githubusercontent.com/mic...
Northwind Alternate: https://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.
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
Learnit is no longer associated with this channel/video.
(C) 2025 Bomberry Productions
Any illegal reproduction of this content will result in immediate legal action.
Auf dieser Seite können Sie das Online-Video SQL Querying for Beginners Tutorial mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Learn Skills Daily 01 Januar 1970 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 319,549 Mal angesehen und es wurde von 4.9 tausend den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
