Install ML services for Python - SQL Server Tutorial

Contents

• Introduction Introduction

  • Dive deep into SQL Server

    35s
  • What you should know

    2m 3s
  • (Locked)
    Getting the most from the exercise files

    3m 40s
• 1.1 Create Views of the Data 1.1 Create Views of the Data

  • Program databases with SQL Server

    2m 7s
  • (Locked)
    Save a query as a view object

    5m 44s
  • (Locked)
    Explore existing views

    4m 8s
  • (Locked)
    SCHEMABINDING a view

    6m 32s
  • (Locked)
    Leverage view objects with indexes

    6m 1s
• 1.2 Create User-Defined Functions 1.2 Create User-Defined Functions

  • Deterministic vs. nondeterministic functions

    6m 4s
  • (Locked)
    Scalar-valued user-defined functions

    6m 42s
  • (Locked)
    IF ELSE and CASE statements

    5m 18s
  • (Locked)
    Table-valued user-defined functions

    4m 45s
  • (Locked)
    Challenge: Create a function

    1m 6s
  • (Locked)
    Solution: Create a function

    9m 28s
• 1.3 Work with Stored Procedures 1.3 Work with Stored Procedures

  • Write and execute a stored procedure

    7m 43s
  • (Locked)
    Stored procedure input parameters

    7m 38s
  • (Locked)
    Stored procedure output parameters

    3m 38s
  • (Locked)
    Create a database trigger

    3m 37s
  • (Locked)
    Challenge: Use function in a stored procedure

    1m 25s
  • (Locked)
    Solution: Use function in a stored procedure

    7m 43s
• 1.4 Create Transactions 1.4 Create Transactions

  • (Locked)
    Ensure data consistency with transactions

    3m 4s
  • (Locked)
    Create a transaction

    4m 42s
  • (Locked)
    Transaction savepoints

    3m 46s
  • (Locked)
    Automatically roll back transactions

    4m 44s
  • (Locked)
    Challenge: Create a transaction

    1m 10s
  • (Locked)
    Solution: Create a transaction

    8m 50s
• 1.5 Implement Error Handling 1.5 Implement Error Handling

  • (Locked)
    What is error handling?

    1m 52s
  • (Locked)
    Capture errors with TRY and CATCH

    4m 54s
  • (Locked)
    Generate errors with THROW

    4m 12s
  • (Locked)
    Manage transaction control

    4m 4s
  • (Locked)
    Challenge: Add error handling to a stored procedure

    1m 12s
  • (Locked)
    Solution: Add error handling to a stored procedure

    12m 12s
• 1.6 Data Type Conversions and NULLs 1.6 Data Type Conversions and NULLs

  • (Locked)
    Implicit data type conversions

    5m 19s
  • (Locked)
    Understand NULL values

    3m 35s
  • (Locked)
    The ISNULL function

    4m 44s
  • (Locked)
    Merge rows with COALESCE

    6m 14s
• 2.1 Trigger Fundamentals 2.1 Trigger Fundamentals

  • Automate SQL Server with triggers

    1m 48s
  • (Locked)
    What are SQL Server triggers?

    3m 37s
  • (Locked)
    Two triggers types: INSTEAD OF and AFTER

    2m 34s
  • (Locked)
    Create a trigger to print a message

    6m 17s
  • Timestamp a table modification

    5m 31s
  • (Locked)
    Firing INSTEAD OF triggers

    3m 23s
  • (Locked)
    Challenge: Create a trigger

    58s
  • (Locked)
    Solution: Create a trigger

    7m 10s
• 2.2 Work with Modified Data 2.2 Work with Modified Data

  • (Locked)
    Read values modified by a trigger

    3m 32s
  • (Locked)
    Using the inserted logical table

    5m 58s
  • (Locked)
    Using the deleted logical table

    3m 50s
• 2.3 Database- and Server-Level Triggers 2.3 Database- and Server-Level Triggers

  • (Locked)
    Triggers on CREATE, ALTER, or DROP

    2m 47s
  • (Locked)
    Rollback database modifications

    3m 36s
  • (Locked)
    Reading the EVENTDATA() XML

    2m 5s
  • (Locked)
    Writing data from the EVENTDATA() function

    3m 22s
  • (Locked)
    Challenge: Create a DDL trigger

    55s
  • (Locked)
    Solution: Create a DDL trigger

    7m 57s
• 2.4 Trigger Management 2.4 Trigger Management

  • (Locked)
    View all triggers in a database

    4m 27s
  • (Locked)
    Enable and disable triggers

    2m 41s
  • (Locked)
    Disable nested triggers

    4m 19s
  • (Locked)
    Recursive triggers

    3m 56s
  • (Locked)
    Reorder trigger execution

    3m 15s
• 2.5 Project: Managing Inventory 2.5 Project: Managing Inventory

  • (Locked)
    Creating triggers to maintain inventory

    2m 7s
  • (Locked)
    Counting shipments received

    4m 9s
  • (Locked)
    Subtract items sold

    3m 33s
  • (Locked)
    Reorder items when low

    3m 34s
• 3.1 SQL Server Ledger Core Concepts 3.1 SQL Server Ledger Core Concepts

  • Protect your data with SQL Server Ledger

    1m 16s
  • (Locked)
    What is SQL Server Ledger?

    3m 17s
  • (Locked)
    Ledger tables and ledger databases

    4m 33s
  • (Locked)
    Capture the database state in the digest

    4m 24s
• 3.2 Add Ledger Features to Existing Databases 3.2 Add Ledger Features to Existing Databases

  • (Locked)
    Create updatable ledger tables

    6m 22s
  • (Locked)
    Create append-only ledger tables

    3m 45s
  • (Locked)
    Move existing data into a ledger table

    4m 17s
• 3.3 Create a New Ledger Database 3.3 Create a New Ledger Database

  • (Locked)
    Use T-SQL to create a ledger database

    3m 40s
  • (Locked)
    Enable ledger in Azure SQL Database

    4m
• 3.4 Auditing a Database Protected by Ledger 3.4 Auditing a Database Protected by Ledger

  • (Locked)
    Manage the ledger digest

    4m 30s
  • (Locked)
    Verify ledger integrity

    3m 23s
  • (Locked)
    Detect unauthorized data modifications

    5m 52s
  • (Locked)
    Recover a compromised database

    4m 30s
• 4.1 Get Started with Machine Learning Services 4.1 Get Started with Machine Learning Services

  • Analyze SQL Server data with Python

    1m 32s
  • What is machine learning services?

    3m 50s
  • (Locked)
    Install ML services for Python

    8m 4s
  • (Locked)
    Enable script execution in SQL Server

    4m 49s
  • (Locked)
    Use variables in Python

    5m 22s
  • (Locked)
    Create a Python while loop

    5m 3s
• 4.2 Write Python Scripts for SQL Server 4.2 Write Python Scripts for SQL Server

  • (Locked)
    Import a dataset from SQL Server

    3m 2s
  • Manipulate a DataFrame

    6m 7s
  • (Locked)
    Output a result set to SQL Server

    3m 41s
  • (Locked)
    Python syntax pitfalls

    6m 58s
  • (Locked)
    Challenge: Import a DataFrame

    1m 13s
  • (Locked)
    Solution: Import a DataFrame

    7m 41s
• 4.3 Python Package Modules and Libraries 4.3 Python Package Modules and Libraries

  • (Locked)
    The Anaconda open-source packages

    7m 27s
  • (Locked)
    Functions in the revoscalepy package

    1m 48s
  • (Locked)
    Model, train, and score with microsoftml

    1m 16s
  • (Locked)
    Produce graphics with Matplotlib

    7m 53s
  • (Locked)
    Get descriptive statistics with pandas

    7m 45s
  • (Locked)
    Challenge: Sample a DataFrame

    1m 12s
  • (Locked)
    Solution: Sample a DataFrame

    5m 21s
• 4.4 Processing Tabular Data 4.4 Processing Tabular Data

  • (Locked)
    Return values with indexes and series

    6m 8s
  • (Locked)
    Convert a series to a DataFrame

    4m 40s
  • (Locked)
    Add multiple series to a DataFrame

    3m 12s
  • (Locked)
    Include the index in a DataFrame

    4m 44s
  • (Locked)
    Slice a DataFrame to series

    4m 23s
  • (Locked)
    Challenge: Import and process data

    52s
  • (Locked)
    Solution: Import and process data

    6m 44s
• 4.5 Create a SQL Stored Procedure 4.5 Create a SQL Stored Procedure

  • (Locked)
    Create a Python stored procedure

    3m 20s
  • (Locked)
    Parameterize the procedure

    4m 20s
  • (Locked)
    Challenge: Write a stored procedure

    47s
  • (Locked)
    Solution: Write a stored procedure

    3m 16s
• 4.6 Create an External Data Science Client 4.6 Create an External Data Science Client

  • (Locked)
    Install MLS on a standalone server

    5m 58s
  • (Locked)
    Add development tools to the client

    3m 30s
  • (Locked)
    Work with Jupyter Notebooks

    6m 13s
• 5.1 Final Project 5.1 Final Project

  • GameScore database final project setup

    2m 38s
  • (Locked)
    Create a trigger to add points to player records

    6m 30s
  • (Locked)
    Calculate global score with custom function

    4m 7s
  • (Locked)
    Write a stored procedure: Part 1

    6m 19s
  • (Locked)
    Write a stored procedure: Part 2

    4m 44s
  • (Locked)
    Add error handling and test the system: Part 1

    6m 14s
  • (Locked)
    Add error handling and test the system: Part 2

    5m 52s
• Conclusion Conclusion

  • (Locked)
    Next steps

    1m 3s