Home About Courses Schedule Services Webinars Contact Search

SQL Essentials (Cross Platform)

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, SQL Server or PostgreSQL.

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, Microsoft SQL Server, and PostgreSQL. Differences between the RDBMSs are highlighted throughout the material and especially the SQL workshops. The workshops may be performed on any of the above platforms. Students will leave with the ability to code queries involving simple to intermediate complexity.

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 by a relational database for data manipulation.
  • Translate and code business problems in Structured Query Language.

Prerequisites

None

Topics

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