Learning Microsoft SQL Server 2022

Contents

• Introduction Introduction

  • Get to know SQL Server 2022

    35s
  • What you should know

    36s
  • (Locked)
    Explore the code challenge environment

    2m 5s
• 1. Getting Started 1. Getting Started

  • What is SQL Server?

    5m 38s
  • Understand the editions of SQL Server

    5m 30s
  • (Locked)
    Installing SQL Server

    4m 35s
• 2. Working with the Server 2. Working with the Server

  • (Locked)
    Configure and start the server

    3m 57s
  • (Locked)
    Log into the server

    3m 48s
  • (Locked)
    Enable the system administrator (SA) account

    4m 8s
• 3. SQL Server Management Studio 3. SQL Server Management Studio

  • (Locked)
    Tour the SSMS interface

    7m 53s
  • (Locked)
    Install a sample database

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

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

    3m 19s
  • (Locked)
    Create a data table

    7m 6s
  • (Locked)
    Import data from a file

    3m 42s
• 4. Write Transact-SQL Commands 4. Write Transact-SQL Commands

  • (Locked)
    Create a SELECT statement

    6m 15s
  • (Locked)
    Use functions to calculate values

    7m 16s
  • (Locked)
    Join data from multiple tables

    4m 54s
  • (Locked)
    Write an UPDATE statement

    4m 37s
  • (Locked)
    Add data with an INSERT statement

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

    7m 42s
  • (Locked)
    Solution: Select data from a table

    2m 47s
  • (Locked)
    Solution: Join related tables with a query

    3m 11s
  • (Locked)
    Solution: Use functions to calculate values

    4m 49s
  • (Locked)
    Solution: Update the data stored in a table

    6m 30s
• Conclusion Conclusion

  • (Locked)
    Next steps

    1m 5s