Database Classes

Database Classes

Looking to learn about MySQL or relational databases, or to improve your MySQL query knowledge? Our MySQL Database training course is a tutorial-style class aimed at people looking to learn more (or simply to learn!) about databases – from setting them up on your PC, to running queries and complex joins.

We study and use the extremely popular MySQL database in the class, as it is so prevalent in today’s IT, and is free to use and install. The MySQL syntax you will learn in this class is extremely similar to all other SQL languages, such as MSSQL, PostgreSQL and Oracle.

Course Details

This is a 4 hour course, and covers everything from an introduction to databases in general, through to the writing of complex MySQL queries. Our tutor has worked in software development for over 14 years, as well as working as an IT tutor and instructor, which helps to create a compelling and interesting class, with an excellent opportunity for questions and answers from someone with a deep knowledge of databases.

The course content is as follows:

1. Databases overview and introduction
2. SQL SELECT Statements
3. SQL Functions
4. INSERT, UPDATE and DELETE Statements
5. GROUP BY Statements
6. Inner and Outer Joins
7. Database Views
8. SQL Sub-Queries
9. REGEXP and Find and Replace
10. Data Backups and Dumps
11. Importing Data From Excel
12. Database Indexes

When, Where and Course Fee

Please get in touch with paul@sitespeed.ie, or call Paul today on 085 8257151) to find out dates of next class. We usually limit class size to 8 people, so to to guarantee your place get in contact as soon as you can. Course fee is a very competitive €130.

The class is usually held in our offices in Blanchardstown, but if you wish we also offer the course on a 1:1 basis online (live using Skype), at a time that suits you – call Paul today (085 8257151) to book your slot.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>