BLOG
CATALOG
Menu
Paperless workplace idea, e-signing, electronic signature, document management. Businessman signs an electronic document on a digital document on a virtual notebook screen using a stylus pen.
a stack of orange and white books with text overlay of different training topics related to the professional workforce.
Browse hundreds of training topics to elevate team performance.
a laptop and phone with course training text on the screen.

Learn about PTR’s interactive course workbook for different learning styles.

Professional African-American woman training instructor smiling with overlay text.

PTR instructors are experts at delivering engaging, professional training.

SQL Querying : Advanced Training Course

Formats ⟩  Live Virtual: 4 hrs./1 Day  |  In-Person: 6 hrs./1 Day

In this course, you will learn advanced techniques, such as writing nested queries, using JOINs to combine data, summarizing query results, using advanced filtering, and using views to simplify repetitive tasks. You will also learn how to perform common database administration tasks like duplicating tables, modifying table structures, inserting, updating, or deleting data, and indexing tables to optimize query performance.

Course Prerequisite:SQL Querying: Fundamentals

Learning Objectives »

  • Use nested queries to generate query output
  • Manipulate table data by inserting, updating, and deleting records in a table
  • Manipulate table structure
  • Create and modify views and manipulate data
  • Create indexes on table columns
  • Roll back a transaction and commit a transaction

Course Agenda

Using Nexted Queries

  1. Search Based on Values from a Subquery
  2. Compare Values from a Subquery
  3. Search Based on the Existence of Records
  4. Use Correlated Subqueries
  5. Filter Grouped Data Within Subqueries
  6. Perform Multiple-Level Subqueries

Manipulating Table Data

  1. Insert Rows
  2. Modify and Delete Data

Manipulating Table Structure

  1. Create a Table
  2. Create a Table with Constraints
  3. Modify a Table's Structure
  4. Delete Tables

Working with Views

  1. Create a View
  2. Manipulate Data in Views
  3. Modify and Delete Views

Indexing Data

  1. Create Indexes
  2. Drop Indexes

Managing Transactions

  1. Define Transactions
  2. Commit Transactions

Exporting Query Results

  1. Generate a Text File
  2. Generate an XML File
Paperless workplace idea, e-signing, electronic signature, document management. Businessman signs an electronic document on a digital document on a virtual notebook screen using a stylus pen.

SQL Querying : Advanced Training Course

Formats ⟩  Live Virtual: 4 hrs./1 Day  |  In-Person: 6 hrs./1 Day

In this course, you will learn advanced techniques, such as writing nested queries, using JOINs to combine data, summarizing query results, using advanced filtering, and using views to simplify repetitive tasks. You will also learn how to perform common database administration tasks like duplicating tables, modifying table structures, inserting, updating, or deleting data, and indexing tables to optimize query performance.

Course Prerequisite:SQL Querying: Fundamentals

Learning Objectives »

  • Use nested queries to generate query output
  • Manipulate table data by inserting, updating, and deleting records in a table
  • Manipulate table structure
  • Create and modify views and manipulate data
  • Create indexes on table columns
  • Roll back a transaction and commit a transaction

Course Agenda

Using Nexted Queries

  1. Search Based on Values from a Subquery
  2. Compare Values from a Subquery
  3. Search Based on the Existence of Records
  4. Use Correlated Subqueries
  5. Filter Grouped Data Within Subqueries
  6. Perform Multiple-Level Subqueries

Manipulating Table Data

  1. Insert Rows
  2. Modify and Delete Data

Manipulating Table Structure

  1. Create a Table
  2. Create a Table with Constraints
  3. Modify a Table's Structure
  4. Delete Tables

Working with Views

  1. Create a View
  2. Manipulate Data in Views
  3. Modify and Delete Views

Indexing Data

  1. Create Indexes
  2. Drop Indexes

Managing Transactions

  1. Define Transactions
  2. Commit Transactions

Exporting Query Results

  1. Generate a Text File
  2. Generate an XML File
PTR Training uses 'cookies' to improve your website experience. View our Privacy Policy for details. By continuing, you agree to accept and adhere to our Terms of Use.