RelationalDBDesign
prev next
  Course navigation
 
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.
The SQL Database Engine is the core service for storing, processing, and extracting data. The SQL Database Engine provides access and rapid transaction processing to meet the requirements of applications.
The SQL Database Engine can be used to create relational databases for online transaction processing or online analytical processing data.
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.
This hands-on class focuses on retrieving information from your systems in a way that is 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