BLOGCATALOG
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.
COURSE CATALOG

SQL Querying: Advanced

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

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
COURSE CATALOG
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.