SQL

Outline:

Basic

Lesson 1: Executing a Simple Query

Topic A: Connect to the SQL Database

Topic B: Query a Database

Topic C: Save a Query

Topic D: Modify and Execute a Saved Query

Lesson 2: Performing a Conditional Search

Topic A: Search Using One or More Conditions

Topic B: Search for a Range of Values and NULL Values

Topic C: Search Data Based on Patterns

Lesson 3: Working with Functions

Topic A: Perform Date Calculations

Topic B: Calculate Data Using Aggregate Functions

Topic C: Manipulate String Values

Lesson 4: Organizing Data

Topic A: Sort Data

Topic B: Rank Data

Topic C: Group Data

Topic D: Filter Grouped Data

Topic E: Summarize Grouped Data

Topic F: Use PIVOT and UNPIVOT Operators

Lesson 5: Retrieving Data from Multiple Tables

Topic A: Combine the Results of Two Queries

Topic B: Compare the Results of Two Queries

Topic C: Retrieve Data by Joining Tables

Lesson 6: Exporting Query Results

Topic A: Generate a Text File

Topic B: Generate an XML File

Advanced

Lesson 1: Querying with unions and advanced joins

Topic A: Querying multiple tables with unions

Topic B: Advanced Joins

Topic C: Calculating with COMPUTE

Lesson 2: Querying with subqueries

Topic A: Subqueries

Lesson 3: Adding data

Topic A: Inserting data

Topic B: SELECT INTO

Lesson 4: Updating and removing data

Topic A: Updating records

Topic B: Deleting records

Topic C: Deleting the contents of tables

Lesson 5: Manipulating tables and views

Topic A: Creating tables

Topic B: Modifying tables

Topic C: Deleting tables

Topic D: Adding and removing views

Lesson 6: Manipulating indexes

Topic A: Adding and removing indexes

Lesson 7: Ensuring data integrity with transactions

Topic A: Transactions

Lesson 8: Creating databases

Topic A: Creating a database with SQL

Topic B: Deleting a database

Price: $495.00
Submit Booking Request