Completed
Union ALL
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
SQL Querying for Beginners Tutorial
Automatically move to the next video in the Classroom when playback concludes
- 1 Start
- 2 Introduction
- 3 Introduction to SQL
- 4 Installing SQL Server
- 5 SQL Keyword Command Language and Hierarchy
- 6 Connecting to a SQL Database
- 7 Creating and Saving a Query
- 8 Using One or More Query Conditions
- 9 Applying AND OR Operators
- 10 NULL NOT NULL
- 11 Range of Values
- 12 Querying Data Using Wildcard Characters
- 13 Formatting Column Headings with Aliases
- 14 Formatting Query Data Results
- 15 Performing Date Calculations - DateDifDateAdd
- 16 Summarizing Data Using Aggregate Functions AVG COUNT SUM min max
- 17 Manipulating Text Results with String Functions CONCAT_SUBSTR
- 18 Sorting Data Order BY and GROUPBY
- 19 RANK and HAVING
- 20 Mathematical Financial Expressions
- 21 PIVOT
- 22 JOIN
- 23 Union ALL
- 24 Except Clause
- 25 Sub Queries
- 26 Exports
- 27 Conclusion
