What you should know - SQL Server Tutorial

Contents

• Introduction Introduction

  • Transform your powerful data with SQL Server 2019

    1m 6s
  • What you should know

    20s
• 1. Get Started with SQL Server 1. Get Started with SQL Server

  • (Locked)
    What is SQL Server?

    5m 4s
  • Understand the editions of SQL Server

    4m 7s
  • (Locked)
    Install SQL Server

    4m 32s
• 2. Work with the Server 2. Work with the Server

  • Configure and start the server

    4m 19s
  • (Locked)
    Log into the server

    6m 16s
  • (Locked)
    Locate SQL Server documentation

    2m 11s
• 3. SQL Server Management Studio 3. SQL Server Management Studio

  • (Locked)
    Tour the SSMS interface

    6m 26s
  • (Locked)
    Install a sample database

    4m 18s
  • (Locked)
    Create a new database on the server

    3m 21s
  • (Locked)
    Understand SQL data types

    2m 25s
  • (Locked)
    Create a data table

    6m 39s
  • (Locked)
    Join tables together with keys

    5m 23s
• 4. Write Transact-SQL Commands 4. Write Transact-SQL Commands

  • (Locked)
    Create a SELECT statement

    4m 59s
  • (Locked)
    Use functions to calculate values

    5m 23s
  • (Locked)
    Write an UPDATE statement

    2m 39s
  • (Locked)
    Add data with an INSERT statement

    4m 34s
  • (Locked)
    Create a view of the data

    4m 33s
• Conclusion Conclusion

  • (Locked)
    Next steps

    56s