SQL Querying for Beginners Tutorial

SQL Querying for Beginners Tutorial

Learnit Training via YouTube Direct link

Start

1 of 27

1 of 27

Start

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. 1 Start
  2. 2 Introduction
  3. 3 Introduction to SQL
  4. 4 Installing SQL Server
  5. 5 SQL Keyword Command Language and Hierarchy
  6. 6 Connecting to a SQL Database
  7. 7 Creating and Saving a Query
  8. 8 Using One or More Query Conditions
  9. 9 Applying AND OR Operators
  10. 10 NULL NOT NULL
  11. 11 Range of Values
  12. 12 Querying Data Using Wildcard Characters
  13. 13 Formatting Column Headings with Aliases
  14. 14 Formatting Query Data Results
  15. 15 Performing Date Calculations - DateDifDateAdd
  16. 16 Summarizing Data Using Aggregate Functions AVG COUNT SUM min max
  17. 17 Manipulating Text Results with String Functions CONCAT_SUBSTR
  18. 18 Sorting Data Order BY and GROUPBY
  19. 19 RANK and HAVING
  20. 20 Mathematical Financial Expressions
  21. 21 PIVOT
  22. 22 JOIN
  23. 23 Union ALL
  24. 24 Except Clause
  25. 25 Sub Queries
  26. 26 Exports
  27. 27 Conclusion

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.