Improve your SQL skills Quickly with our
Step-by-Step Training Method

SQL Express

Inquire Now

Our SQL Express course is designed for people who have a basic understanding of how databases work. We will take you from an introduction of database concepts to the more advanced levels of being able to perform complex queries on multiple databases.

This training is based on ANSI SQL which is generic SQL. All vendors of SQL base their platform on ANSI SQL, Including Microsoft, Oracle, MySQL etc.

Our training is delivered through our On-line 24/7 training platform.

SQL Express - Course Modules and Objectives:

Introduction

  • Describe the basics of database structure
  • Explain how to use SQL to interact with most database applications
  • Use the SELECT statement to retrieve data
  • Explain the sorting options available when using the ORDER BY clause

Filtering Data

  • Use the WHERE clause in a SELECT statement
  • Use the AND, OR, IN, and NOT operators in a WHERE clause
  • Use the LIKE operator in a WHERE clause
  • Use wildcards to create search patterns

Calculations and Functions

  • Concatenate fields in your queries
  • Perform mathematical calculations in your queries
  • Use text and numeric functions in your queries
  • Use date and time functions in your queries

Summarizing Data

  • Explain the purpose of the SQL aggregate functions
  • Use the SUM() and COUNT() functions
  • Use the AVG(), MAX(), and MIN() functions
  • Use aggregate functions for advanced operations

Groups and Queries

  • Create data groups using the GROUP BY clause
  • Sort and filter grouped data
  • Understand and filter subqueries
  • Use subqueries as calculated fields
  • Create combined queries using UNION

Joins

  • Query multiple tables using a join
  • Use table aliases in your queries
  • Perform inner, outer, self, and natural joins
  • Use aggregate functions with joins

Data and Tables

  • Insert rows of data into a database table
  • Copy data from one table to another
  • Update and delete data from a database table
  • Create database tables
  • Modify and delete database tables

Views and Stored Procedures

  • Explain the makeup of views
  • Use views to simplify joins
  • Use views to reformat retrieved data
  • Use filtering and calculated fields within your views
  • Explain the use of stored procedures
  • Execute stored procedures
  • Describe some of the features involved in creating stored procedures

Transaction Processing and Cursors

  • Explain how transaction processing works in SQL code
  • Control transactions
  • Explain how cursors are used to save SQL results
  • Declare and use cursors in your SQL code

Advanced SQL Functions

  • Explain the use of database constraints
  • Define primary and foreign keys
  • Describe the use of unique and check constraints
  • Explain the function of database indexes
  • Describe the function of triggers
  • Identify the tools used in database security

Other Training Benefits

  • Specialised Teacher Support - You will have support for all your questions
  • Hands on skills - Software simulations in real world scenarios
  • Exam preparation - We don't send you to the exam unless we know you will get a high mark.
  • Cost effective - You don't have to break your budget to get started
  • Flexibility - You don't have to take time off work or disrupt your schedule

Take the next step now!

Register for more information and receive FREE of charge our e-book
"11 Breakthrough strategies for Interview Success"

Register Now