SQL Querying Training

SQL Querying Advanced Training

Course Duration: 1 Day

This Course Covers Version(s): N/A


Available Delivery Methods

In this SQL Querying Advanced Training course, students will learn how to use subqueries; how to insert, modify and delete data using a SQL statement; how to create, backup and delete tables and how to work with views, indexes and transactions.

Upon successful completion of this course, students will be able to:

  • Use subqueries to generate query output
  • Manipulate table data by inserting and updating records in a table and deleting records from a table
  • Manipulate the table structure
  • Create views, manipulate data through views, modify the view structure, and drop views
  • Create indices on table columns and drop inefficient indices
  • Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction
  1. 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
  2. Manipulating Table Data
    • Insert Data
    • Modify and Delete Data
  3. Manipulating the Table Structure
    • Create a Table
    • Create a Table with Constraints
    • Add and Drop Table Columns
    • Add and Drop Constraints
    • Modify the Column Definition
    • Back Up Tables
    • Delete Tables
  4. Working with Views
    • Create a View
    • Manipulate Data in Views
    • Create Aliases
    • Modify and Drop Views
  5. Indexing Data
    • Create Indices
    • Drop Indices
  6. Managing Transactions
    • Create Transactions
    • Commit Transactions

Students should have attended or be familiar with the topics covered in the SQL Querying Introduction Training course.

Live, Instructor-Led Online Class for INDIVIDUALS

$325.00


  • Open Enrollment Class for Individuals
  • Live Class with an Instructor
  • Six Months of Instructor Email Support
  • Hands-on Exercises and Student Labs
  • Classes Never Cancelled Due to Low Enrollment
  • Money-back Guarantee
Click here to load this Caspio Online Database.

Live, Instructor-Led Online or Onsite Class for GROUPS

Contact Us For Quote


  • For Private Groups as small as 2 people
  • Live, Instructor-led Online or Onsite Class for your group.
  • Hands-on Exercises and Student Labs
  • Customizable
  • Six Months of Email Support After Class
  • Money-back Guarantee
Click here to load this Caspio Online Database.