Back to Courses

Databases – Introduction to SQL

Duration

4 hours

Overview

Audience

This course is suitable for IT professionals who will be working with, or retrieving data from, an enterprise database system.

Prerequisites

Successful completion of the Interskill Databases – Introduction to Databases and Database Managers, course, or equivalent knowledge.

Objectives

After completing this course, the student will be able to:

  • Identify SQL statements used to select database data
  • Code predicates to restrict data selection
  • Perform arithmetic calculations
  • Code Scalar and Aggregate Functions
  • Group data
  • Sort output
  • Insert new data into a database
  • Delete and update existing database data

Course Content

Introduction to SQL

The need for SQL
SQL Variations
SQL Sub-languages
Selecting Data from Tables
Using the WHERE Clause when Selecting Data
Specifying Operators
Subqueries
Pattern Matching
Handling NULL Values
Arithmetic Calculations

Reading and Processing Data

Scalar Functions
Numeric Functions
IF Function
Information Functions
User-defined Functions
Handling Dates and Times
String Functions
Aggregate Functions
MIN and MAX Functions
COUNT Function
GROUP BY and HAVING Clauses
Sorting Data Using the ORDER BY Clause

Updating Data With SQL

Adding Data to a Table Using the INSERT Statement
Using the MERGE Statement to Insert Data
LOAD DATA Statement
Removing Data Using the DELETE Statement
Modifying Data Using the UPDATE Statement

Databases – Introduction to SQL Mastery Test