SQL Querying Advanced

Who should attend

This course is targeted at individuals who have foundational SQL skills, and are looking to learn how to implement advanced SQL querying techniques. As a prerequisite to this course, students should have:

  • Basic computing skills
  • Foundational SQL skills
  • Familiarity with concepts related to database structure and terminology
Team Pass by Learnit

SQL Querying Advanced

From $0
Two, 2-hour Modules (9am - 11:30am PT)

The SQL Querying Advanced course is designed to teach students how to identify and use advanced SQL querying techniques. Specifically, you will learn how to manipulate and index tables, as well as how to modify the structure of a table, including inserting, updating, and deleting data. Students will also learn how to index tables to optimize query performance.

Course ID
L0167
Available times
No items found.
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am

Course Outline

Module 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

Module 2: Manipulating Table Data

  • Insert Data Modify and Delete Data

Module 3: Manipulating The Table Structure

  • Create a Table
  • Create a Table with Constraints
  • Modify a Table's Structure
  • Back Up Tables
  • Delete Tables

Module 4: Working With Views

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

Module 5: Indexing Data

  • Create Indexes Drop Indexes

Module 6: Managing Transactions 

  • Create Transactions Commit Transactions

 

Skills covered

No items found.