Crescent Career Center
Career Training

Course Details

SQL Querying Fundamentals - Part 2



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