About this course
SQL is the language you use to interact with a database management system. The SQL Fundamentals course will teach you how to create tables, insert data and update data using SQL. The main focus is on learning how to find the data that you need by creating queries.
Please note that the course is not specific to any particular database system.
What others say
Why you want to attend
You should attend the SQL Fundamentals course if:- You often have to extract data from a system that matches some conditions.
- You need to use SQL to interact with a database from inside another application.
- You need to test data in a database.
- You want a faster and better way to query data than having thousands of rows in a spreadsheet.
What you need to know first
It will help if you have some understanding of relational databases, or have worked with data from a database, before you attend the SQL Fundamentals course, but it is not essential.Price and duration
Price: R8,400.00 excluding VAT per delegate.This price includes everything that you need:
- All course material, provided in an electronic format.
- An attendance certificate after the course, in PDF format.
The SQL Fundamentals course is presented virtually. Find out more about our virtual training and how it works.
Please check the course schedule for the next available date.
How to book
It’s so easy to book for the SQL Fundamentals course. Just email us at info@incusdata.com. You can send us a purchase order, or fill in our course enrolment form. After we have received your booking, we will confirm that you are booked, and we’ll send you an invoice.Detailed course contents
Database Fundamentals
- Introduction to databases and SQL.
- Tables, records, and fields.
- Relationships.
- Entity integrity: Primary keys.
- Referential integrity: Foreign keys.
- The concept of normalisation.
Data Definition Commands
- Creating the database.
- Creating table structures.
- Data types.
- Creating primary keys.
- Creating foreign keys.
Data Management Commands
- Inserting data into tables.
- Saving table contents.
- Updating table data.
- Deleting data from tables.
The SELECT Statement
- Listing all rows and columns.
- Restricting columns.
- Using column aliases.
- Using the WHERE clause to restrict rows.
- Using the WHERE clause in UPDATE and DELETE commands.
Operators
- Arithmetic, comparison, assignment and logical operators.
- Special SQL operators: BETWEEN, IN.
- The LIKE operator and wildcard characters.
- The IS NULL operator.
- Operator precedence.
Sorting, Functions and Groups
- The DISTINCT keyword.
- Sorting data: the ORDER BY clause.
- Expressions in the ORDER BY clause.
- Aggregate functions: SUM, AVERAGE, MAX, MIN and COUNT.
- Grouping data in queries.
- Essential SQL functions for string manipulation.
- The EXTRACT function for date manipulation.
Queries With Multiple Tables
- Creating sub-queries.
- Subqueries that return a single value.
- Subqueries that return multiple values.
- Using table aliases.
- Creating an INNER JOIN.
- Joins with row conditions.