Working with Microsoft Azure SQL: Using Transact-SQL for Queries & Transactions

Azure    |    Intermediate
  • 11 videos | 1h 28m 42s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 11 users Rating 4.7 of 11 users (11)
Transact-SQL (T-SQL) is a powerful query language that applies to all databases with a SQL engine. It can be used to run a variety of different operations against Azure SQL Database. Through this course, learn about the Transact-SQL language and how to query data, create table partitions, and launch transactions against Azure SQL Database. Discover how to load CSV file data into a new Azure SQL Database table and query and execute aggregations on that data. Next, learn how to implement and validate table partitioning, use Transact-SQL to define and execute transactions, and use rollbacks and savepoints. Finally, practice setting isolation levels for transactions. After course completion, you'll be able to use Transact-SQL to query data and launch transactions for Azure SQL Database.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Create a database table and populate it with the contents of a csv file
    Execute aggregation queries in transact-sql (t-sql) and view estimated counts
    Implement and validate table partitioning
    Execute a query with and without a transaction
    Manually roll back transactions and view the results
  • Roll back parts of a transaction using savepoints
    Create nested transactions and use try/catch blocks
    Use the read committed and uncommitted isolation levels
    Use the repeatable read isolation level with transactions
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 2m 37s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 10m 25s
    During this video, discover how to create a database table and populate it with the contents of a CSV file. FREE ACCESS
  • Locked
    3.  Executing Aggregation Queries in Transact-SQL
    7m 41s
    Find out how to execute aggregation queries in Transact-SQL (T-SQL) and view estimated counts. FREE ACCESS
  • Locked
    4.  Partitioning Tables in Azure SQL Database
    12m 17s
    In this video, you will learn how to implement and validate table partitioning. FREE ACCESS
  • Locked
    5.  Executing Statements within Transactions
    9m
    Discover how to execute a query with and without a transaction. FREE ACCESS
  • Locked
    6.  Handling Errors in Transactions
    7m 23s
    In this video, learn how to manually roll back transactions and view the results. FREE ACCESS
  • Locked
    7.  Rolling Back to Savepoints
    6m 8s
    After completing this video, you will be able to roll back parts of a transaction using savepoints. FREE ACCESS
  • Locked
    8.  Creating Nested Transactions and Try/Catch Blocks
    11m 51s
    Learn how to create nested transactions and use try/catch blocks. FREE ACCESS
  • Locked
    9.  Setting Transaction Isolation Levels
    9m 18s
    Upon completion of this video, you will be able to use the READ COMMITTED and UNCOMMITTED isolation levels. FREE ACCESS
  • Locked
    10.  Using the REPEATABLE READ Isolation Level
    9m
    In this video, find out how to use the REPEATABLE READ isolation level with transactions. FREE ACCESS
  • Locked
    11.  Course Summary
    3m 4s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 4.6 of 645 users Rating 4.6 of 645 users (645)
Rating 4.5 of 10 users Rating 4.5 of 10 users (10)
Rating 4.8 of 42 users Rating 4.8 of 42 users (42)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 296 users Rating 4.6 of 296 users (296)
Rating 4.7 of 29 users Rating 4.7 of 29 users (29)
Rating 4.4 of 7 users Rating 4.4 of 7 users (7)