prev next prev next

Course navigation
Module 1


Lesson 1 Course introduction

  What are the characteristics of SQL Database Engines?
SQL databases tend to be mysterious when it comes to the information that is stored within them.
It is likely that you have a number of applications that put information into your various SQL database engines.
From this information set, you need to be able to retrieve meaningful information and that is where this course comes in.

SQL Database Engines

This hands-on class focuses on retrieving information from your systems in a way that is much more insightful in terms of getting
  1. what you need from the system,
  2. working with multiple tables, and
  3. doing it easily.

Course goals
In this course, we will cover:
  1. Advanced uses of the SELECT statement
  2. The DISTINCT keyword
  3. Views
  4. String, arithmetic, and date functions

Course navigation