Complete Guide to Advanced SQL Server

Focused View

Adam Wilbert

8:27:19

0 View

01 - Introduction

01 - Dive deep into SQL Server.mp4

00:35

02 - What you should know.mp4

02:03

03 - Getting the most from the exercise files.mp4

03:40

02 - 1. Create Views of the Data

01 - Program databases with SQL Server.mp4

02:07

02 - Save a query as a view object.mp4

05:44

03 - Explore existing views.mp4

04:08

04 - SCHEMABINDING a view.mp4

06:32

05 - Leverage view objects with indexes.mp4

06:01

03 - 2. Create User-Defined Functions

01 - Deterministic vs. nondeterministic functions.mp4

06:04

02 - Scalar-valued user-defined functions.mp4

06:42

03 - IF ELSE and CASE statements.mp4

05:18

04 - Table-valued user-defined functions.mp4

04:45

05 - Challenge Create a function.mp4

01:06

06 - Solution Create a function.mp4

09:28

04 - 3. Work with Stored Procedures

01 - Write and execute a stored procedure.mp4

07:43

02 - Stored procedure input parameters.mp4

07:38

03 - Stored procedure output parameters.mp4

03:38

04 - Create a database trigger.mp4

03:37

05 - Challenge Use function in a stored procedure.mp4

01:25

06 - Solution Use function in a stored procedure.mp4

07:43

05 - 4. Create Transactions

01 - Ensure data consistency with transactions.mp4

03:04

02 - Create a transaction.mp4

04:42

03 - Transaction savepoints.mp4

03:46

04 - Automatically roll back transactions.mp4

04:44

05 - Challenge Create a transaction.mp4

01:10

06 - Solution Create a transaction.mp4

08:50

06 - 5. Implement Error Handling

01 - What is error handling.mp4

01:52

02 - Capture errors with TRY and CATCH.mp4

04:54

03 - Generate errors with THROW.mp4

04:12

04 - Manage transaction control.mp4

04:04

05 - Challenge Add error handling to a stored procedure.mp4

01:12

06 - Solution Add error handling to a stored procedure.mp4

12:12

07 - 6. Data Type Conversions and NULLs

01 - Implicit data type conversions.mp4

05:19

02 - Understand NULL values.mp4

03:35

03 - The ISNULL function.mp4

04:44

04 - Merge rows with COALESCE.mp4

06:14

08 - 7. Trigger Fundamentals

01 - Automate SQL Server with triggers.mp4

01:48

02 - What are SQL Server triggers.mp4

03:37

03 - Two triggers types INSTEAD OF and AFTER.mp4

02:34

04 - Create a trigger to print a message.mp4

06:17

05 - Timestamp a table modification.mp4

05:31

06 - Firing INSTEAD OF triggers.mp4

03:23

07 - Challenge Create a trigger.mp4

00:58

08 - Solution Create a trigger.mp4

07:10

09 - 8. Work with Modified Data

01 - Read values modified by a trigger.mp4

03:32

02 - Using the inserted logical table.mp4

05:58

03 - Using the deleted logical table.mp4

03:50

10 - 9. Database- and Server-Level Triggers

01 - Triggers on CREATE, ALTER, or DROP.mp4

02:47

02 - Rollback database modifications.mp4

03:36

03 - Reading the EVENTDATA() XML.mp4

02:05

04 - Writing data from the EVENTDATA() function.mp4

03:22

05 - Challenge Create a DDL trigger.mp4

00:55

06 - Solution Create a DDL trigger.mp4

07:57

11 - 10. Trigger Management

01 - View all triggers in a database.mp4

04:27

02 - Enable and disable triggers.mp4

02:41

03 - Disable nested triggers.mp4

04:19

04 - Recursive triggers.mp4

03:56

05 - Reorder trigger execution.mp4

03:15

12 - 11. Project Managing Inventory

01 - Creating triggers to maintain inventory.mp4

02:07

02 - Counting shipments received.mp4

04:09

03 - Subtract items sold.mp4

03:33

04 - Reorder items when low.mp4

03:34

13 - 12. SQL Server Ledger Core Concepts

01 - Protect your data with SQL Server Ledger.mp4

01:16

02 - What is SQL Server Ledger.mp4

03:17

03 - Ledger tables and ledger databases.mp4

04:33

04 - Capture the database state in the digest.mp4

04:24

14 - 13. Add Ledger Features to Existing Databases

01 - Create updatable ledger tables.mp4

06:22

02 - Create append-only ledger tables.mp4

03:45

03 - Move existing data into a ledger table.mp4

04:17

15 - 14. Create a New Ledger Database

01 - Use T-SQL to create a ledger database.mp4

03:40

02 - Enable ledger in Azure SQL Database.mp4

04:00

16 - 15. Auditing a Database Protected by Ledger

01 - Manage the ledger digest.mp4

04:30

02 - Verify ledger integrity.mp4

03:23

03 - Detect unauthorized data modifications.mp4

05:52

04 - Recover a compromised database.mp4

04:30

17 - 16. Get Started with Machine Learning Services

01 - Analyze SQL Server data with Python.mp4

01:32

02 - What is machine learning services.mp4

03:50

03 - Install ML services for Python.mp4

08:04

04 - Enable script execution in SQL Server.mp4

04:49

05 - Use variables in Python.mp4

05:22

06 - Create a Python while loop.mp4

05:03

18 - 17. Write Python Scripts for SQL Server

01 - Import a dataset from SQL Server.mp4

03:02

02 - Manipulate a DataFrame.mp4

06:07

03 - Output a result set to SQL Server.mp4

03:41

04 - Python syntax pitfalls.mp4

06:58

05 - Challenge Import a DataFrame.mp4

01:13

06 - Solution Import a DataFrame.mp4

07:41

19 - 18. Python Package Modules and Libraries

01 - The Anaconda open-source packages.mp4

07:27

02 - Functions in the revoscalepy package.mp4

01:48

03 - Model, train, and score with microsoftml.mp4

01:16

04 - Produce graphics with Matplotlib.mp4

07:53

05 - Get descriptive statistics with pandas.mp4

07:45

06 - Challenge Sample a DataFrame.mp4

01:12

07 - Solution Sample a DataFrame.mp4

05:21

20 - 19. Processing Tabular Data

01 - Return values with indexes and series.mp4

06:08

02 - Convert a series to a DataFrame.mp4

04:40

03 - Add multiple series to a DataFrame.mp4

03:12

04 - Include the index in a DataFrame.mp4

04:44

05 - Slice a DataFrame to series.mp4

04:23

06 - Challenge Import and process data.mp4

00:52

07 - Solution Import and process data.mp4

06:44

21 - 20. Create a SQL Stored Procedure

01 - Create a Python stored procedure.mp4

03:20

02 - Parameterize the procedure.mp4

04:20

03 - Challenge Write a stored procedure.mp4

00:47

04 - Solution Write a stored procedure.mp4

03:16

22 - 21. Create an External Data Science Client

01 - Install MLS on a standalone server.mp4

05:58

02 - Add development tools to the client.mp4

03:30

03 - Work with Jupyter Notebooks.mp4

06:13

23 - 22. Final Project

01 - GameScore database final project setup.mp4

02:38

02 - Create a trigger to add points to player records.mp4

06:30

03 - Calculate global score with custom function.mp4

04:07

04 - Write a stored procedure Part 1.mp4

06:19

05 - Write a stored procedure Part 2.mp4

04:44

06 - Add error handling and test the system Part 1.mp4

06:14

07 - Add error handling and test the system Part 2.mp4

05:52

24 - Conclusion

01 - Next steps.mp4

01:03

Description

Looking to upskill as a programmer with Microsoft SQL Server? Join instructor Adam Wilbert in this hands-on, interactive, skills-development course, as he shows you how to master advanced SQL Server skills such as programming databases with T-SQL, SQL Server database triggers, SQL Server ledger, SQL Server machine learning services with Python, tabular data processing with DataFrame, and more. Along the way, be sure to test out your new skills in the exercise challenges at the end of each section. This course concludes with a final capstone project where you get to apply your newly acquired knowledge to a real-world SQL Server database.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft SQL

Adam Wilbert

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.