Verhoef  Training

DB :: SQL Fundamentals

"Going the extra mile with ICT"

PO Box 2466, Cape Town 8000, South Africa
tel: 0861-102017 • fax: +27 21 856-0042 • e-mail: training@verhoef.co.za

Related Courses
» DB2 Fundamentals
» DB2-SQL Application Programming

Curricula Info
» MVS - z/OS - z/VM
» DB2 - SQL
» CICS TS
» IBM MQ
» Programming
» UNIX - Linux
» Networking
» Web Technologies
» Business Skills

Resources
» IBM Support
» IBM Redbooks
» Mainframe Month
» Mainframes.com
» z/Journal
» CIO Magazine
» Search390.com
» Linux Links
» XML Writer

Links
» CICS Central
» Programmer's Heaven
» Develoment Guru
» COBOL Centre
» COBOL User Groups
» REXXLA Home
» XML.com

Verhoef Sites:
» Verhoef USA
» Verhoef UK

 

Curriculum Description | Curriculum Roadmap | Curriculum Schedule | Course Enrolment

3 days   *   Intermediate   *   Lecture and Labs

Course Summary:
In this course, you'll master the skills of writing correct and effective SQL (Structured Query Language) statements that manipulate and retrieve data from your database. Once you know SQL, you can use it to interact with most major relational databases, such as IBM DB2, Oracle, Microsoft SQL Server, and MySQL.

Target Audience:
Anyone who will be using SQL to manipulate data stored in a Relational Database Management System.

Recommended Prerequisites:
An understanding of Computer System fundamentals. No prior exposure to SQL is necessary.

Course Objectives:
After completing this course, the delegate should be able to:

Discuss basic relational database concepts:
    a. tables, columns, rows and keys
    b. inserting, modifying and deleting table data
    c. referential integrity
    d. data normalization

Exhibit SQL knowledge and literacy

Develop and use SQL at various levels

Discuss SQL performance related practices to their code

Apply knowledge with relevant practical exercises

Assessments are done throughout the course in the form of practical assignments that the delegates are required to complete as part of the course content.

Key Topics:

Relational Database System essentials

Using SQL to create and populate Databases and Tables

SQL as the cornerstone of database activity

Identify the purpose of the clauses in the SELECT statement

Using various filtering predicates to restrict output

Using the SQL built-in Functions

Sort and organize data to obtain a desired output

Modify and manipulate Table data

Using Subqueries

Using JOIN and UNION to retrieve data from multiple tables

Using CASE and Summary Tables

Using Common Table Expressions

Create and work with Views

Using Indices and other Performance considerations

Last modified: 03-Sep-2018

Site Map

 Home
  |
  •-- About Us
  |----Our Mission
  |----BEE Strategy
  |----Complaints
  |----Careers
  |----PAIA manual
  •-- Courses
  •-- Schedules
  •-- Our Clients
  •-- News and Events
  •-- Contact Us
  •-- Your Privacy
  |
  •-- MVS - z/OS - z/VM
  |----Roadmaps
  |----Schedule
  |
  •-- DB2 - SQL
  |----Roadmaps
  |----Schedule
  |
  •-- CICS TS
  |----Roadmaps
  |----Schedule
  |
  •-- IBM MQ
  |----Roadmaps
  |----Schedule
  |
  •-- Programming
  |----Roadmaps
  |----Schedule
  |
  •-- UNIX - Linux
  |----Roadmaps
  |----Schedule
  |
  •-- Networking
  |----Roadmaps
  |----Schedule
  |
  •-- Web Technologies
  |----Roadmaps
  |----Schedule
  |
  •-- Business Skills
  |----Roadmaps
  |----Schedule
  •