SQL training
Learn ICT provides training for users of SQL - the Structured Query Language for Databases. Whether you use:
- Oracle
- Microsoft SQL Server
- PostgreSQL
- MySQL
- Access
- IBM DB2
We can provide a custom course delivered on your platform of choice.
Our training is for database users, ie people who need to be able to extract data from the database. While it is not specifically Database Administrator or Database Developer training, we have had many people in these roles attend and found much benefit in the course. It can be delivered at Intoductory or Advanced levels with topics from the following list:
- Introduction to databases and the Relational Database Model.
- SQL Basics
- Retrieving data with SELECT
- Sorting Data with ORDER BY
- Filtering rows with WHERE
- Logical operators - AND, OR, NOT
- Handling nulls
- Operators and Functions
- Summarizing and Grouping Data
- Joining Tables - Inner, Outer and Self joins
- Subqueries, - simple, correlated and exists
- Insert, Update and Delete
- Manipulating Tables - creating, altering and dropping
- Indexes
- Views
- Transactions
We can provide training onsite or offsite - we regularly provide SQL training in Brisbane, and are happy to travel to also provide SQL training in Sydney, Melbourne or other cities.
Please Contact Us for more information.