Autoplay
Autocomplete
Previous Chapter
Complete and Continue
SQL Querying Basics
Exercise Files - Download Before Starting the Course
Exercise Files
Course
Introduction (0:09)
Introduction to SQL (3:57)
Installing SQL Server (3:59)
SQL Keyword Command Language and Hierarchy (5:08)
Connecting to a SQL Database (9:09)
Creating and Saving a Query (9:58)
Using One or More Query Conditions (7:53)
Applying AND OR Operators (6:11)
NULL NOT NULL (2:40)
Range of Values (8:36)
Querying Data Using Wildcard Characters (6:43)
Formatting Column Headings with Aliases (5:17)
Formatting Query Data Results (4:03)
Performing Date Calculations - DateDifDateAdd (8:29)
Summarizing Data Using Aggregate Functions AVG COUNT SUM min max (7:47)
Manipulating Text Results with String Functions CONCAT_SUBSTR (7:40)
Sorting Data Order BY and GROUPBY (8:17)
RANK and HAVING (5:58)
Mathematical Financial Expressions (6:01)
PIVOT (9:02)
JOIN (13:02)
Union ALL (5:59)
Except Clause (1:55)
Sub Queries (12:16)
Exports (3:23)
Conclusion (0:45)
Manipulating Text Results with String Functions CONCAT_SUBSTR
Chapter content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock