• Skip to main content
  • Skip to primary navigation
Federal Solutions
Contact Us:       [email protected]       (512) 794-8440

Microassist

Menu Responsive

Search

  • Accessibility
    • Accessibility Audits
    • VPAT Consulting Services
    • Accessibility Remediation
    • Accessible PDF and Document Remediation Services
    • Accessible Website and Application Development
    • Accessible Digital Learning
    • Compliance for Digital Learning
    • Accessibility Training
    • Accessibility in the News
  • Custom Training
    • Accessible E-Learning
    • Managed Learning Services: Training Support for Business
    • Training Staff Augmentation Services
    • Learning Management System
    • Learning Translation and Localization
    • Examples of Our Work
    • The Learning Dispatch (Blog)
  • Classes
    • Course List
    • Course Schedule
    • Classroom Rental
    • Security Awareness Training
    • Classes FAQ
    • Software Tips (Blog)
  • About
    • Government Solutions
    • Newsletter Subscriptions
    • Career Opportunities
    • News and Media
    • Blogs
    • Team
  • Open Search Field

Databases and Big Data

SQL 2008: Advanced

Course Overview

You will work with advanced queries to manipulate and index tables. You will also create transactions so that you can choose to save or cancel data entry process.

To find out when this course is being offered next, please refer to our Course Schedule.

Course Length

1 day

Course Price

$425 (U.S.)

Register for Class


Target Audience

Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology.

Course Prerequisites

To ensure your success, we recommend you first take the following Element K courses, or have equivalent skills and knowledge:

  • SQL: Fundamentals of Querying (Fourth Edition)

Learning Outcomes / Objectives

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.

Download Course Registration Form


Topic List

Lesson 1: Using Subqueries to Perform Advanced Querying
Topic 1A: Search Based on Unknown Values
Topic 1B: Compare a Value with Unknown Values
Topic 1C: Search Based on the Existence of Records
Topic 1D: Generate Output Using Correlated Subqueries
Topic 1E: Filter Grouped Data Within Subqueries
Topic 1F: Perform Multiple-Level Subqueries

Lesson 2: Manipulating Table Data
Topic 2A: Insert Data
Topic 2B: Modify and Delete Data

Lesson 3: Manipulating the Table Structure
Topic 3A: Create a Table
Topic 3B: Create a Table with Constraints
Topic 3C: Add and Drop Table Columns
Topic 3D: Add and Drop Constraints
Topic 3E: Modify the Column Definition
Topic 3F: Back Up Tables
Topic 3G: Delete Tables

Lesson 4: Working with Views
Topic 4A: Create a View
Topic 4B: Manipulate Data in Views
Topic 4C: Create Aliases
Topic 4D: Modify and Drop Views

Lesson 5: Indexing Data
Topic 5A: Create Indices
Topic 5B: Drop Indices

Lesson 6: Managing Transactions
Topic 6A: Create Transactions
Topic 6B: Commit Transactions

Appendix A: Structure of the Bookstore Database

Footer

Microassist

As one of Central Texas’s most experienced software education centers, a primary training vendor for the State of Texas, and a Microsoft Certified Solution Partner, Microassist has successfully worked with clients in fields ranging from advertising, real estate, law and politics to state and government agencies.

Quick Links

Government Solutions

Accessibility in the News

Learning Dispatch (Blog)

Lexis-Nexis Mealey’s® Commentaries

Classroom Course Schedule

Digital Accessibility Blog

Contact Us

Microassist, Inc.

8500 Shoal Creek
Building 4, Suite 225

Austin, Texas 78757

Tel: (512) 794-8440
Fax: (512) 794-8742

Email: [email protected] MORE

Back to Top
Copyright 2021 Microassist. All Rights Reserved.
  • Privacy
  • Accessibility Statement
  • Site Map
  • Contact Us
International Association of Accessibility Professionals (IAAP) Member
Microassist on Facebook
Microassist on Twitter
Microassist on Linked In
Microassist on Youtube
MENU
  • Accessibility
    • Accessibility Audits
    • VPAT Consulting Services
    • Accessibility Remediation
    • Accessible PDF and Document Remediation Services
    • Accessible Website and Application Development
    • Accessible Digital Learning
    • Compliance for Digital Learning
    • Accessibility Training
    • Accessibility in the News
  • Custom Training
    • Accessible E-Learning
    • Managed Learning Services: Training Support for Business
    • Training Staff Augmentation Services
    • Learning Management System
    • Learning Translation and Localization
    • Examples of Our Work
    • The Learning Dispatch (Blog)
  • Classes
    • Course List
    • Course Schedule
    • Classroom Rental
    • Security Awareness Training
    • Classes FAQ
    • Software Tips (Blog)
  • About
    • Government Solutions
    • Newsletter Subscriptions
    • Career Opportunities
    • News and Media
    • Blogs
    • Team