70-461 Session 1: Querying Microsoft SQL Server 2012/2014

Phillip Burton

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
31 Lessons (3h 38m)
    • 1. Introduction

      2:23
    • 2. Curriculum

      8:54
    • 3. Downloading SQL Server

      7:22
    • 4. Installing SQL Server

      7:07
    • 5. Opening SQL Server

      3:01
    • 6. Looking at SQL Server Management Studio

      4:45
    • 7. Create a database

      1:41
    • 8. Creating our first queries

      6:08
    • 9. Creating a table - first pass using GUI

      2:10
    • 10. Creating a table - first pass using T-SQL

      2:58
    • 11. Entering data using the GUI

      2:30
    • 12. Entering data using T-SQL

      4:48
    • 13. Retrieving data

      4:33
    • 14. Deleting the data, then the table

      3:08
    • 15. Creating an Employee table

      4:27
    • 16. Creating temporary variables

      11:45
    • 17. Integer numbers

      7:47
    • 18. Non-integer numbers

      15:09
    • 19. Mathematical functions

      12:38
    • 20. Converting between number types

      8:41
    • 21. Strings

      15:43
    • 22. String Functions - extraction

      7:15
    • 23. NULL - an introduction

      9:17
    • 24. Joining two strings or a string and number together

      11:49
    • 25. Joining a string to a number

      8:46
    • 26. Date data types

      7:45
    • 27. Setting dates and Date extraction

      6:23
    • 28. Today's date, and more date functions

      7:49
    • 29. Date offset

      9:47
    • 30. Converting from dates to strings

      9:53
    • 31. End of Session 1

      1:46