Home / Courses / Software Development & Programming / SQL Standard Intensive Training

SQL Standard Intensive Training

Name: SQL Standard Intensive Training
Availability: InStock
Rating: 4.6 (5878 reviews)

In this training you will learn everything you need to know and be able to query your database on the basis of standard SQL-3.

4.6 out of 5 rating
Last updated : 23/07/2026
English

Available as Instructor Led Training, Live Online & In Person at your Offices or Ours.

Enquire Now

Download Overview

Duration:

16.00 hours

13.0 CPD hours

Overview:

In this training you will learn everything you need to know and be able to query your database on the basis of standard SQL-3.

Description:

1. basic terms of relational databases

- Database
- Table (entities, attributes)
- Data types (value ranges)
- primary, foreign key
- Relations
- Data consistency, referential integrity
- View
- Index
2. basics about SQL

- History
- Application (basic concept)
- SQL Properties
- SQL Syntaxdiagram
- Naming conventions for objects
3. data retrieval, data evaluation and manipulation (DML)

- SELECT
- Simple queries
- Constant columns, calculated columns, aliases
- DISTINCT
- ORDER BY
- TOP
- WHERE
- Aggregate functions
- GROUP BY / HAVING
- JOIN (INNER, OUTER, FULL, Self, Cross)
- Subqueries
- UNION
- SELECT INTO
4. add data

- INSERT (VALUES, SELECT)
- UPDATE
- DELETE
5. data definition language (DDL)

- CREATE DATABASE
- CREATE TABLE
- Constraints (PRIMARY- , FOREIGN KEY, UNIQUE )
- DROP TABLE
- CREATE VIEW
- ALTER VIEW
- DROP VIEW
- CREATE PROCEDURE
6. data control language (DCL)

- Transaction Management
- COMMIT & ROLLBACK
- GRANT & REVOKE

Available Delivery Options for SQL Standard Intensive Training

Live Instructor Led Classroom Online (Live Online)
Traditional Instructor Led Classroom training (TILT/ILT)
Delivery at your offices in United Kingdom
Private dedicated course for your staff

How many CPD hours does SQL Standard Intensive Training provide?

The 2 day SQL Standard Intensive Training course gives you up to 13.0 CPD hours/structured learning hours.

Who is the correct audience for SQL Standard Intensive Training?

Developers, analysts, businessmen and other interested persons who want to work with an SQL-capable database or create applications using the SQL possibilities of the database system. People who want to get well-founded information about SQL, its possibilities, limitations and meaning.

Do you provide training for SQL Standard Intensive Training?

Yes, we provide corporate training, dedicated training and closed classes for SQL Standard Intensive Training. This can take place anywhere in United Kingdom including London, Manchester, Birmingham, Edinburgh or live online.

What is the duration of SQL Standard Intensive Training?

The SQL Standard Intensive Training training takes place over 2 day(s), with each day lasting approximately 16.00 hours including breaks.

What other terms do people search for?

Popular related searches include: SQL Standard Intensive Training, SQL, SQL02

Why are Nexus Human the best provider for SQL Standard Intensive Training?

Nexus Human are recognised as one of the best training companies. Our trainers have won awards including Small Firms Best Trainer, national training partner of the year for Ireland, and global top 30 instructor awards in 2012, 2019 and 2021.

Is there a discount code for SQL Standard Intensive Training?

Yes, the discount code PENPAL5 is currently available for SQL Standard Intensive Training training. Only one discount code can be used per booking.

DURATION 16.00 Hours

No scheduled classes available at this time.

Training Insurance Included!

When you organise training, we understand that there is a risk that some people may fall ill, become unavailable.

To mitigate the risk we include training insurance for each delegate enrolled on our public schedule, they are welcome to sit on the same Public class within 6 months at no charge, if the case arises.