SQL Query Basics & Fundamentals

Details

SQL, or Structured Query Language, is the universal standard for communicating with relational databases, enabling users to store, manage, and retrieve data efficiently. This comprehensive course provides a step-by-step introduction to SQL language, starting with the fundamentals of SQL and progressing to more advanced topics such as joins and complex queries.

Designed to cater to a wide range of database systems, including MySQL, Microsoft SQL Server, PostgreSQL, and Oracle, the course equips participants with essential SQL query basics and practical skills needed to interact seamlessly with various platforms. Whether you are a beginner aiming to build a strong foundation or an experienced professional looking to refine your database management capabilities, this course offers hands-on training in SQL for beginners, ensuring you can confidently apply SQL in real-world scenarios.

This course will teach you everything you need to know, from SQL language basics to advanced joins. SQL for the following databases is covered:

Microsoft SQL Server
MySQL
PostgreSQL
Oracle

Delivery Methods

Delivery Method	Duration
Classroom Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm. Classroom	3 Days	Get a Quote
e-Learning This independent, online, guided course is delivered via the Moodle Learner Management System web interface and includes videos, quizzes, exercise files and other downloadable resources. Work through the material in your own time. You have 1 year to complete the course. Download your certificate when done. Limited interaction with a facilitator is provided by telephone, email, and instant messaging on Moodle. Face-to-face appointments can be booked separately. e-Learning	18 hours	Get a Quote	Book Now
Live Virtual Training This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office. Live Virtual Training	3 Days	Get a Quote

Discounts Available

Save up to 10% by booking and paying 10 business days before the course.

Brochure:

Information may change without notice.

Introduction Video

Customer Testimonials

Alexander Forbes Group Services (Pty) Ltd

The trainer facilitated the course at an excellent pace, thank you so much Lawrence for the knowledge that you have imparted with us.

Audience

Report Writers (anyone required to produce reports from a relational database)
Web developers wanting to add database interaction to their web sites.
Programmers who quickly wants to add SQL to their skills set.
The hobbyist who wants to begin creating SQL scripts for upload to their own ISP.
Students, and to those seeking a career in computing, who need a fundamental understanding of database administration with SQL.

Pre-Requisites

Above average computer literacy
If you are bringing along your own laptop and you are using Microsoft SQL Server, it will be helpful to pre-install the database server and client software. Please call for assistance or arrive at least one hour before on the first day of the course so we can help you with the

Course Outline / Curriculum

What is SQL
Relational Databases
Terminology
SQL and Standards
SQL Implementations
Client - Server
SQL Syntax
Comments
- Single-line comments
- Multi-line comments
SELECT Statements
- Overview of SELECT
- Selecting One Field
- Selecting Multiple Fields
- Using a Wild Card
- Calculations
  - Oracle's DUAL table
  - Column Aliases
Data Types
- Character Types
  - CHAR
  - VARCHAR
- Numeric Types
  - Integers
  - DECIMAL or NUMERIC
  - NUMBER
- Datetime Types
  - DATE
  - TIME
  - DATETIME
  - DATE
  - TIMESTAMP
Sorting Results
Limiting rows
Using WHERE
- Comparison Operators
  - BETWEEN
  - IN
  - IS NULL
  - Comparing one column to another
- Using AND/OR and NOT
- Using LIKE
Functions
- String Functions
  - LEN
  - CONCAT
    - Concatenation Operator
  - SUBSTRING
  - REPLACE
- Conversion Functions
  - CAST
- Numeric Functions
  - ROUND
  - FLOOR
  - CEILING
- Date Functions
  - Getting the current date and time
  - Formatting a date and time
  - Extracting a part of a date
  - Calculating the difference between dates
  - Adding an interval to a date
  - Oracle Date comparisons
- Aggregate
- DISTINCT
Grouping
Filtering Using HAVING
Joins
- INNER JOIN
- Implicit INNER JOIN syntax
- Using table aliases in joins
- The USING statement
- Joining Multiple Tables
- Self Joins
- Outer Joins
  - LEFT OUTER JOIN
  - RIGHT OUTER JOIN
  - FULL OUTER JOIN
Set Operators
- UNION
- UNION ALL
- INTERSECT
- EXCEPT or MINUS
SELECT summary
Subqueries
Creating Structures
- CREATE DATABASE
- CREATE SCHEMA
- CREATE USER
- CREATE TABLE
  - Field Modifiers
    - Auto Increment
  - Table Level Constraints
    - Primary Key Table Constraints
    - Foreign Key Table Constraints
    - Check Table Constraints
    - Unique Table Constraints
- CREATE TABLE AS SELECT
- SELECT INTO
Views
Drop Queries
ALTER TABLE
- Adding a column to a table
- Deleting a column from a table
- Modifying a column in a table
- Renaming a column in a table
- Renaming a table
Insert Queries
- Bulk Insert
- INSERT INTO SELECT
Update Queries
- Update Joins
DELETE and TRUNCATE
Indexes
- Guidelines to using Indexes
- Creating Indexes
- Dropping Indexes
Transactions
- ROLLBACK Example
- Savepoints
- COMMIT Example
Database Design
- Conceptual Model
- Define the Information Required
- Normalization
- Divide Data into Tables
- Assigning Primary and Foreign Keys
  - Keys
  - Table Relationships
    - Many to one
    - One to one
    - Many to many
  - Iterate
- Entity Relationship Diagrams

Schedule Dates and Booking

You can enrol at any time for this course.

Book Now

Submit Enquiry

Name

Email

Telephone

Query