Home | About Us | Courses | Schedules | Our Clients | News and Events | Contact Us | Careers  
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
      •

     
    Home | About Us | Courses | Schedules | Our Clients | News and Events | Contact Us
     

      to top
    © 2004-2018 Verhoef Training. All Rights Reserved.


    This Site Tracked by OneStat.com