Proudly serving the D.C. metro
area for over 25 years.


Softek Services, Inc.
1156 15th Street, NW, Suite 100
Washington, DC 20005
(202) 747-5000

Computer Training Software Consulting Database Programming

Get tips on our Facebook Find us on Google+ Tweet Us Read Reviews on Yelp Softek on Linkedin

  • Instructor-led Training Instructor-led Training
  • Join a Public Class Join a Public Class
  • Private Group Classes Private Group Classes
  • Transition Classes Transition Classes
  • Virtual Training Virtual Training
  • Customization & Documentation Customization & Documentation
  • Web and Database Development Web and Database Development
  • We Have Classrooms We Have Classrooms
     

SQL: Advanced Querying

1 Day, 9:00-4:00, 6 Hours

This instructor-led, hands-on course, will teach you how to work with advanced queries to manipulate and index tables, create views, and create transactions that save or cancel data entry.  You will learn how 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

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

Manipulating Table Data

  • Insert Data
  • Modify and Delete Data

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

 

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

Appendix A: Structure of the Bookstore Database

View Upcoming Schedule or Register for a Class

Is this the right course for you? Please contact our office at (202) 747-5000 if you have any questions.

Back to Agenda

Investment

Public Class

$400 per student

View Schedule or Register

Why choose Softek?

  • Live, in-person training
  • Instructors with 10+ years of experience
  • Detailed training guide
  • Certificate of completion
  • Money-back guarantee