SQL for Administrators

Course Description :

This SQL training course is designed for candidates new to writing SQL queries using MySQL running on a MS Windows or Linux Platform. The SQL learned in this course is standard to all modern databases, but MySQL will be used in class tutorials. Any syntax and functionality specific to MySQL will be pointed out.

Intended for :

Anyone who requires a practical hands-on overview of Structured Query Language.

Prerequisites :

You need to have a basic understanding of Databases, also a familiarity with computers and data processing. You will be taken step by step through all the features of SQL. You must enjoy writing small scripts, both at home and in our training room.

Course Details :

Click on image for Start Dates, Duration and Fees

Major Benefits : At the end of the course you will know:

Relational Database Basics.
Simple SQL SELECTs.
Advanced SQL SELECTs.
Subqueries, Joins and Unions.
Conditional Processing with CASE.
How to Insert, Update and Delete Records.
How to Create and Modify Tables.
Views & Stored Procedures

Course Details

Course Delivery :

Platform configuration : Choice of Linux or MS Windows 7
We can also deliver the course at your office and demonstrate on your local systems if required, also, you may bring along your own laptop or use the computers at our office. All courses will be delivered by a mature experienced teacher.

Next course starts - Click here for Timetable & Fees

E-mail for more information