SQL Scripting Fundamentals Training

Increase your marketability as a web developer, programmer, or database administrator with our SQL training.

In this SQL training class, you'll master the skill of writing correct and effective SQL (Structured Query Language) statements that manipulate and retrieve data from your database. Once you know SQL, you can use it to interact with most major databases, such as MS Access, Oracle, Microsoft SQL Server, and MySQL.


  • Experience with a desktop database such as Filemaker or MS Access

Create and Execute a Simple Query

  • Connect to a server that contains a database
  • Use fundamental techniques to query a database
  • Compose and execute a simple SQL statement to retrieve data
  • Save a query for future use and modify existing queries

Perform a Conditional Search to Retrieve Data that Fits Specific Criteria

  • Add criteria to a SELECT statement to perform more sophisticated queries
  • Work with various types of operators to define a condition
  • Search for patterns within large tables of data

Work with Functions to Perform Calculations on Data

  • Use date functions to perform calculations on columns that contain date and time input
  • Utilize aggregate functions on a collection of values to return a single, summarizing value
  • Eliminate duplicated values with the DISTINCT keyword
  • Manipulate string values with functions to effectively extract alphanumberic information

Sort and Organize Data to Obtain a Desired Output

  • Organize data in a query result to help you identify required information
  • Rank data based on pre-defined criteria
  • Group data that belongs to specific category and filter through this data by applying conditions
  • Use CUBE and ROLLUP operators with the GROUP BY clause to display summary rows
  • Rearrange related columns and values in query output with relational operators

Retrieve Data from Multiple Tables and Exporting Date in Other Formats

  • Combine the result of two queries and generate the results in a single, unified set
  • Join tables to retrieve data from two or more tables based on a condition
  • Provide users with data in formats they can access with other applications or tools
  • Export data in XML and text formats

Subqueries for Advanced Querying

  • Search for information without a specified search value with subqueries
  • Write queries to compare a single known value against a list of unknown values
  • Display rows from a table based on the presence of rows from another table
  • Correlate outer queries so that they execute before subqueries
  • Group data returned by a subquery based on a single or a set of specific values
  • Use multiples levels of inner queries for complicated data reporting

Modify and Manipulate Table Data

  • Learn how to insert rows into tables to add information
  • Modify and delete rows from tables to update information
  • Track changes to data by modifying table structure
  • Add checks and conditions to table structure to ensure data integrity
  • Backup tables to avoid data loss and delete tables to conserve space

Create and Work with Views

  • Pinpoint information by creating views to display specific columns and/or records
  • Insert, modify, and delete rows in a table while using a view
  • Assign aliases to columns included in a view for more efficient complex queries
  • Modify view structure by adding or deleting columns, or delete a view altogether

Use Indices to Optimize Query Performance

  • Create an index to access specific information contained in a table
  • Mark the beginning and end of transations for easy roll-back
  • Commit transations to confirm that you wish to save changes

SQL training is offered at four locations: