SQL Querying for Beginners Tutorial
SQL Querying for Beginners Tutorial
Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join
Exercise Files: https://bit.ly/3n5sr0G
SQL Express Download Link:
https://www.microsoft.com/en-us/Download/details.aspx?id=101064
Northwindsql Link:
https://raw.githubusercontent.com/microsoft/sql-server-samples/master/samples/databases/northwind-pubs/instnwnd.sql
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.
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com
Exercise Files: https://bit.ly/3n5sr0G
SQL Express Download Link:
https://www.microsoft.com/en-us/Download/details.aspx?id=101064
Northwindsql Download Link:
https://github.com/Microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs
If you are having issues with the Northwind DB pleases delete lines 24 and 25 and execute.
For Private Group Trainings please visit:
https://www.learnit.com/private-group-classes-workshops
Join Offsite for our online community of teachers and peers:
https://www.offsitebylearnit.com
Manuals: https://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.
Видео SQL Querying for Beginners Tutorial канала Learnit Training
Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join
Exercise Files: https://bit.ly/3n5sr0G
SQL Express Download Link:
https://www.microsoft.com/en-us/Download/details.aspx?id=101064
Northwindsql Link:
https://raw.githubusercontent.com/microsoft/sql-server-samples/master/samples/databases/northwind-pubs/instnwnd.sql
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.
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com
Exercise Files: https://bit.ly/3n5sr0G
SQL Express Download Link:
https://www.microsoft.com/en-us/Download/details.aspx?id=101064
Northwindsql Download Link:
https://github.com/Microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs
If you are having issues with the Northwind DB pleases delete lines 24 and 25 and execute.
For Private Group Trainings please visit:
https://www.learnit.com/private-group-classes-workshops
Join Offsite for our online community of teachers and peers:
https://www.offsitebylearnit.com
Manuals: https://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.
Видео SQL Querying for Beginners Tutorial канала Learnit Training
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Microsoft 365 Basics Excel and PowerPoint TutorialMicrosoft 365 Basics Outlook and Teams TutorialThe Learnit Minute - Select Word to Right #Word #ShortsThe Learnit Minute - Move to Next Cell in Row #Word #ShortsThe Learnit Minute - Bold #Word #ShortsThe Learnit Minute - YIELD Function #Excel #ShortsThe Learnit Minute - YEARFRAC Function #Excel #ShortsGoogle Forms Advanced TutorialThe Learnit Minute - VDB Function #Excel #ShortsThe Learnit Minute - VARPA Function #Excel #ShortsGmail Basics TutorialPython Basics Full Course Tutorial (3+ Hours)Tableau Basics Full Course Tutorial (6+ Hours)Google Slides Full Course TutorialTableau Basics Expert TutorialGoogle Docs Full Course Tutorial (3+ Hours)Which Tool When: Teams, SharePoint, and OneDrive - Live ClassTableau Basics Advanced TutorialThe Learnit Minute - SUMSQ Function #Excel #ShortsVisio 2021 Full Course TutorialThe Learnit Minute - STDEYX Function #Excel #Shorts