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.
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 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.
|