Home About Courses Schedule Services Webinars Contact Search

Cross Platform SQL Essentials

SEE SCHEDULE

Duration: 2 Days

Method: Instructor led, Hands-on workshops

Price: $1125.00

Course Code: SQ1000



View Related Video

Audience

Programmers, Analysts, Database Administrators, and IT Managers who are exposed to, or are required to perform the activities associated with data stored in a relational database such as DB2, Oracle or SQL Server.

Description

Come prepared to master Structured Query Language (SQL) across multiple database platforms in this fast paced and hands-on course. The course begins with a discussion of relational concepts and terminology and quickly moves into a very practical discussion of data retrieval and manipulation using SQL. Each topic is reinforced with hands-on workshops.Examples and workshops are provided for the following platforms with discussion of the relevant differences: DB2 for z/OS, DB2 for Linux, Unix & Windows, Oracle Database, and Microsoft SQL Server

Objectives

Upon successful completion of this course, the student will be able to:

  • Describe the overall purpose of, and the approaches to manipulating data in a database management system.
  • Describe the major objects used for data manipulation.
  • Translate and code business problems in Structured Query Language.
  • State the internal approaches utilized for accessing data.

Prerequisites

None

Topics

  1. Relational Database Concepts
    • The Relational Model
    • Domains
    • Integrity and Relationships
    • Structured Query Language (SQL)
    • Unknown Values (NULL)
    • Basic Datatypes
  2. Basic Data Retrieval
    • SELECT Statement
    • Using SELECT
    • Projecting Columns Onto the Result
    • Basic Predicates
    • Expressions in the SELECT Clause
    • Expressions in the WHERE clause
  3. Intermediate Data Manipulation
    • Compound Conditions
    • Other WHERE Clause Operators
      • BETWEEN
      • IN
      • LIKE
      • IS NULL
    • Using DISTINCT
    • ORDER BY Clause
  4. Built-in Functions
    • Working with Datatypes and Casting
    • Functions Involving NULLs
    • CASE Statements
  5. Aggregation
    • SUM, AVG, MIN, MAX & COUNT Functions
    • Grouping Results with GROUP BY
    • Filtering Groups with HAVING
  6. Joins
    • Inner Equi-Join
    • Join Classification
    • Cartesian Products
    • Inner Joins of More than 2 Tables
  7. Data Modification
    • INSERT
    • UPDATE
    • DELETE
    • COMMIT and ROLLBACK