SQL Querying for Beginners Tutorial
243.2 هزار بار بازدید -
3 سال پیش
-
SQL Querying for Beginners TutorialJoin
SQL Querying for Beginners Tutorial
Join Learnit Anytime for ad-free training and certificates:
https://www.learnitanytime.com
Exercise Files: https://bit.ly/3n5sr0G
SQL Express Download Link:
https://www.microsoft.com/en-us/Downl...
Northwindsql Download Link:
https://github.com/Microsoft/sql-serv...
For Private Group Trainings please visit:
https://www.learnit.com/private-group...
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
Join Learnit Anytime for ad-free training and certificates:
https://www.learnitanytime.com
Exercise Files: https://bit.ly/3n5sr0G
SQL Express Download Link:
https://www.microsoft.com/en-us/Downl...
Northwindsql Download Link:
https://github.com/Microsoft/sql-serv...
For Private Group Trainings please visit:
https://www.learnit.com/private-group...
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
3 سال پیش
در تاریخ 1400/10/17 منتشر شده
است.
243,229
بـار بازدید شده