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

DB :: SQL Introduction

"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
» SQL Fundamentals
» DB2 Fundamentals

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
1 day   *   Basic   *   Lecture and Labs

Course Summary:
The SQL Introduction course covers the basics of the SQL language as used in relational database management systems. This is a generic course with the objective to provide students with the base skills needed to use the SQL language.

Target Audience:
Anyone who will be using SQL to extract data from 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 student should be able to:

  • Understand the basic structure of a Relational Database
  • Create simple tables using SQL
  • Insert, update and delete data from a database using SQL
  • Selectively extract and sort data from a database
  • Use aggregate functions to summarise data
  • Create SQL queries across multiple tables

    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 basics
      - Tables, records and field
      - Primary and foreign keys
  • Using the SQL language:
      - Creating database and table structures
      - Inserting data into tables
      - Modifying table data
      - The basic SELECT statement
      - Data filtering with the WHERE clause
      - Sorting selected data with the ORDER BY clause
      - Arithmetic, comparison and logical operators
      - Aggregate functions: SUM, AVERAGE, MAX, MIN and COUNT

    Last modified: 01-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