Working with Microsoft Azure SQL: Using Transact-SQL for Queries & Transactions
Azure
| Intermediate
- 11 videos | 1h 28m 42s
- Includes Assessment
- Earns a Badge
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 37sIn this video, we will discover the key concepts covered in this course. FREE ACCESS
-
10m 25sDuring this video, discover how to create a database table and populate it with the contents of a CSV file. FREE ACCESS
-
3. Executing Aggregation Queries in Transact-SQL7m 41sFind out how to execute aggregation queries in Transact-SQL (T-SQL) and view estimated counts. FREE ACCESS
-
4. Partitioning Tables in Azure SQL Database12m 17sIn this video, you will learn how to implement and validate table partitioning. FREE ACCESS
-
5. Executing Statements within Transactions9mDiscover how to execute a query with and without a transaction. FREE ACCESS
-
6. Handling Errors in Transactions7m 23sIn this video, learn how to manually roll back transactions and view the results. FREE ACCESS
-
7. Rolling Back to Savepoints6m 8sAfter completing this video, you will be able to roll back parts of a transaction using savepoints. FREE ACCESS
-
8. Creating Nested Transactions and Try/Catch Blocks11m 51sLearn how to create nested transactions and use try/catch blocks. FREE ACCESS
-
9. Setting Transaction Isolation Levels9m 18sUpon completion of this video, you will be able to use the READ COMMITTED and UNCOMMITTED isolation levels. FREE ACCESS
-
10. Using the REPEATABLE READ Isolation Level9mIn this video, find out how to use the REPEATABLE READ isolation level with transactions. FREE ACCESS
-
11. Course Summary3m 4sIn 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.
