SQL Querying Fundamentals - Part 2
1 DAYS
Description:
In this course you will learn how to identify and use advanced querying techniques.
Using Subqueries to Perform Advanced Querying
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
Manipulating Table Data
Insert Data
Modify and Delete Data
Manipulating the Table Structure
Create a Table
Create a Table with Constraints
Modify a Table's Structure
Back Up Tables
Delete Tables
Working with Views
Create a View
Manipulate Data in Views
Create Aliases
Modify and Delete Views
Indexing Data
Create Indexes
Drop Indexes
Managing Transactions
Create Transactions
Commit Transactions