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

Phillip Burton

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

      2:23
    • Curriculum

      8:54
    • Downloading SQL Server

      7:22
    • Installing SQL Server

      7:07
    • Opening SQL Server

      3:01
    • Looking at SQL Server Management Studio

      4:45
    • Create a database

      1:41
    • Creating our first queries

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

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

      2:58
    • Entering data using the GUI

      2:30
    • Entering data using T-SQL

      4:48
    • Retrieving data

      4:33
    • Deleting the data, then the table

      3:08
    • Creating an Employee table

      4:27
    • Creating temporary variables

      11:45
    • Integer numbers

      7:47
    • Non-integer numbers

      15:09
    • Mathematical functions

      12:38
    • Converting between number types

      8:41
    • Strings

      15:43
    • String Functions - extraction

      7:15
    • NULL - an introduction

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

      11:49
    • Joining a string to a number

      8:46
    • Date data types

      7:45
    • Setting dates and Date extraction

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

      7:49
    • Date offset

      9:47
    • Converting from dates to strings

      9:53
    • End of Session 1

      1:46