SQL Advanced Querying Training in Denver & Phoenix

What’s included – a $950 value with:

  • Face-to-face, live interactive class
  • Retake – allows you to retake the entire class if you need a refresher within 6 months
  • Lunch & Learn session – choose from different topics to learn something new in the future
  • Hard copy training manual – to take notes and take with you for future reference
  • Just Tips Newsletter subscription – for ongoing monthly tips to help you learn even more!

Take SQL queries even father and learn how to restructure and index tables. Learn how to manipulate the data in the tables using advanced queries.

Class Price: $450

Training Class Goal

Students will create advanced SQL queries to manipulate and index tables.

Prerequisites

SQL Querying Fundamentals.

Topics Covered

  • Create a Simple Table
  • Create a Table with Constraints
  • Add and Drop Table Columns
  • Add and Drop Constraints
  • Modify the Column Definition
  • Back Up Tables
  • Delete Tables

Working with Views

  • Create a View
  • Manipulate Data in Views
  • Create Aliases
  • Modify and Drop Views

Indexing Data

  • Create Indices
  • Drop Indices

Managing Transactions

  • Create Transactions
  • Commit Transactions

Advanced Querying Using Subqueries

  • Search Based on an Unknown Value
  • Search Based on Multiple 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 Data
  • Delete Data

Request More Information

  • Class Retakes

    If you need to retake a class you've already attended, you're welcome to take it for free up to 6 months later......Read more

  • Hands-on Learning

    We take pride in making our classes engaging and interactive because we feel hands-on learning......Read more

  • Customized Training

    When we train privately, materials may be developed to fit better the company, organization, or students......Read more

  • Individual Attention

    Because we limit our computer training classes to only 12 students and average around half......Read more

  • Live Training

    Get the most from your training investment by working with a live training instructor......Read more

  • Small Class Sizes

    Our computer training center holds only 12 students, and that’s how we like it......Read more