SQL Querying Advanced

SQL Querying Advanced

495.00
Date:
Delivery Method:
Time:
Quantity:
Purchase Now

GSA Checkout → GSA

Course ID: B3901

Duration: 1 Day 

Location: Flex - San Francisco or Live Online | Click here to schedule private course.

Overview:

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.

+ 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.

+ 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

 

+ Prerequisites

As a prerequisite to this course, students should have:

  • Basic computing skills
  • Foundational SQL skills
  • Familiarity with concepts related to database structure and terminology

+ Certifications

N/A

+ SQL Server Training