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.YOU MIGHT ALSO LIKE
Rating 4.5 of 10 users
(10)
