وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

در حال حاضر محصولی در سبد خرید شما وجود ندارد.

رمز خود را فراموش کرده اید؟
وب سایت تخصصی شرکت فرین
خانه » فروشگاه » Complete Guide to Advanced SQL Server

Complete Guide to Advanced SQL Server

سرفصل های دوره

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.


01 - Introduction
  • 01 - Dive deep into SQL Server
  • 02 - What you should know
  • 03 - Getting the most from the exercise files

    • 02 - 1. Create Views of the Data
  • 01 - Program databases with SQL Server
  • 02 - Save a query as a view object
  • 03 - Explore existing views
  • 04 - SCHEMABINDING a view
  • 05 - Leverage view objects with indexes

    • 03 - 2. Create User-Defined Functions
  • 01 - Deterministic vs. nondeterministic functions
  • 02 - Scalar-valued user-defined functions
  • 03 - IF ELSE and CASE statements
  • 04 - Table-valued user-defined functions
  • 05 - Challenge Create a function
  • 06 - Solution Create a function

    • 04 - 3. Work with Stored Procedures
  • 01 - Write and execute a stored procedure
  • 02 - Stored procedure input parameters
  • 03 - Stored procedure output parameters
  • 04 - Create a database trigger
  • 05 - Challenge Use function in a stored procedure
  • 06 - Solution Use function in a stored procedure

    • 05 - 4. Create Transactions
  • 01 - Ensure data consistency with transactions
  • 02 - Create a transaction
  • 03 - Transaction savepoints
  • 04 - Automatically roll back transactions
  • 05 - Challenge Create a transaction
  • 06 - Solution Create a transaction

    • 06 - 5. Implement Error Handling
  • 01 - What is error handling
  • 02 - Capture errors with TRY and CATCH
  • 03 - Generate errors with THROW
  • 04 - Manage transaction control
  • 05 - Challenge Add error handling to a stored procedure
  • 06 - Solution Add error handling to a stored procedure

    • 07 - 6. Data Type Conversions and NULLs
  • 01 - Implicit data type conversions
  • 02 - Understand NULL values
  • 03 - The ISNULL function
  • 04 - Merge rows with COALESCE

    • 08 - 7. Trigger Fundamentals
  • 01 - Automate SQL Server with triggers
  • 02 - What are SQL Server triggers
  • 03 - Two triggers types INSTEAD OF and AFTER
  • 04 - Create a trigger to print a message
  • 05 - Timestamp a table modification
  • 06 - Firing INSTEAD OF triggers
  • 07 - Challenge Create a trigger
  • 08 - Solution Create a trigger

    • 09 - 8. Work with Modified Data
  • 01 - Read values modified by a trigger
  • 02 - Using the inserted logical table
  • 03 - Using the deleted logical table

    • 10 - 9. Database- and Server-Level Triggers
  • 01 - Triggers on CREATE, ALTER, or DROP
  • 02 - Rollback database modifications
  • 03 - Reading the EVENTDATA() XML
  • 04 - Writing data from the EVENTDATA() function
  • 05 - Challenge Create a DDL trigger
  • 06 - Solution Create a DDL trigger

    • 11 - 10. Trigger Management
  • 01 - View all triggers in a database
  • 02 - Enable and disable triggers
  • 03 - Disable nested triggers
  • 04 - Recursive triggers
  • 05 - Reorder trigger execution

    • 12 - 11. Project Managing Inventory
  • 01 - Creating triggers to maintain inventory
  • 02 - Counting shipments received
  • 03 - Subtract items sold
  • 04 - Reorder items when low

    • 13 - 12. SQL Server Ledger Core Concepts
  • 01 - Protect your data with SQL Server Ledger
  • 02 - What is SQL Server Ledger
  • 03 - Ledger tables and ledger databases
  • 04 - Capture the database state in the digest

    • 14 - 13. Add Ledger Features to Existing Databases
  • 01 - Create updatable ledger tables
  • 02 - Create append-only ledger tables
  • 03 - Move existing data into a ledger table

    • 15 - 14. Create a New Ledger Database
  • 01 - Use T-SQL to create a ledger database
  • 02 - Enable ledger in Azure SQL Database

    • 16 - 15. Auditing a Database Protected by Ledger
  • 01 - Manage the ledger digest
  • 02 - Verify ledger integrity
  • 03 - Detect unauthorized data modifications
  • 04 - Recover a compromised database

    • 17 - 16. Get Started with Machine Learning Services
  • 01 - Analyze SQL Server data with Python
  • 02 - What is machine learning services
  • 03 - Install ML services for Python
  • 04 - Enable script execution in SQL Server
  • 05 - Use variables in Python
  • 06 - Create a Python while loop

    • 18 - 17. Write Python Scripts for SQL Server
  • 01 - Import a dataset from SQL Server
  • 02 - Manipulate a DataFrame
  • 03 - Output a result set to SQL Server
  • 04 - Python syntax pitfalls
  • 05 - Challenge Import a DataFrame
  • 06 - Solution Import a DataFrame

    • 19 - 18. Python Package Modules and Libraries
  • 01 - The Anaconda open-source packages
  • 02 - Functions in the revoscalepy package
  • 03 - Model, train, and score with microsoftml
  • 04 - Produce graphics with Matplotlib
  • 05 - Get descriptive statistics with pandas
  • 06 - Challenge Sample a DataFrame
  • 07 - Solution Sample a DataFrame

    • 20 - 19. Processing Tabular Data
  • 01 - Return values with indexes and series
  • 02 - Convert a series to a DataFrame
  • 03 - Add multiple series to a DataFrame
  • 04 - Include the index in a DataFrame
  • 05 - Slice a DataFrame to series
  • 06 - Challenge Import and process data
  • 07 - Solution Import and process data

    • 21 - 20. Create a SQL Stored Procedure
  • 01 - Create a Python stored procedure
  • 02 - Parameterize the procedure
  • 03 - Challenge Write a stored procedure
  • 04 - Solution Write a stored procedure

    • 22 - 21. Create an External Data Science Client
  • 01 - Install MLS on a standalone server
  • 02 - Add development tools to the client
  • 03 - Work with Jupyter Notebooks

    • 23 - 22. Final Project
  • 01 - GameScore database final project setup
  • 02 - Create a trigger to add points to player records
  • 03 - Calculate global score with custom function
  • 04 - Write a stored procedure Part 1
  • 05 - Write a stored procedure Part 2
  • 06 - Add error handling and test the system Part 1
  • 07 - Add error handling and test the system Part 2

    • 24 - Conclusion
  • 01 - Next steps
    • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 42052
    حجم: 1255 مگابایت
    مدت زمان: 508 دقیقه
    تاریخ انتشار: ۲۱ آذر ۱۴۰۳
    دسته بندی محصول
    LinkedIn Learning (Lynda)
    LinkedIn Learning (Lynda)
    مشاهده دوره های LinkedIn Learning (Lynda)
    دیگر آموزش های این مدرس
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید