Microsoft Data & Power BI
SQL Querying Fundamentals Part 2
Take SQL further in one day: write subqueries, insert, update and delete data, change table structure, and create views and indexes.
1 dayFoundation6 modules
About this course
Take SQL further in one day: write subqueries, insert, update and delete data, change table structure, and create views and indexes.
What you'll learn
- Writing subqueries and multi-level subqueries
- Inserting, updating, and deleting data in tables
- Creating and modifying table structures and constraints
- Creating views and performing data operations through views
- Creating and managing indices for optimized performance
- Using transactions to manage changes with commit and rollback
Curriculum
6 modules
- Search Based on Unknown Values
- Compare a Value with Unknown Values
- Search Based on the Existence of Records
- Generate Output Using Correlated Subqueries
- Filter Grouped Data Within Subqueries
- Perform Multiple-Level Subqueries
- Insert Data
- Modify and Delete Data
- Create a Simple Table
- Create a Table with Constraints
- Add or Drop Table Columns
- Add or Drop Constraints
- Modify the Column Definition
- Back Up Tables
- Delete Tables
- Create a View
- Manipulate Data in Views
- Create Aliases
- Modify and Drop Views
- Create Indices
- Drop Indices
- Create Transactions
- Commit Transactions
Who it's for
SQL users who know the basics.
Before you start
- SQL Querying Fundamentals - Part 1
Related courses
More in Microsoft Data & Power BI →Foundation
55315 Introduction to SQL Databases
Microsoft Data & Power BI
View course →IntermediateDP-080T00
DP-080T00 Query and modify data with Transact-SQL
Microsoft Data & Power BI
View course →Intermediate
Querying Data with Transact-SQL 55366
Microsoft Data & Power BI
View course →Intermediate
55128 Writing Reports with Report Builder and SSRS Level 2
Microsoft Data & Power BI
View course →Intermediate
55232 Writing Analytical Queries for Business Intelligence
Microsoft Data & Power BI
View course →Intermediate55353
Administering a SQL Database Infrastructure (55353)
Microsoft Data & Power BI
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.