Home / Courses / Software Development & Programming / Introduction to SQL Programming Basics (TTSQL002)

Introduction to SQL Programming Basics (TTSQL002)

Name: Introduction to SQL Programming Basics (TTSQL002)
Availability: InStock
Rating: 4.6 (5878 reviews)

Introduction to SQL Programming is a three-day, hands-on course that will provide you with a solid understanding of SQL programming, providing you with the tools, techniques, and insights required to excel in database management and analysis.

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:

24.00 hours

19.5 CPD hours

Overview:

Description:

SQL, or Structured Query Language, serves as the backbone of modern data management and manipulation. Understanding its principles allows technical professionals to create, maintain, and interrogate databases, giving them the power to make data-driven decisions that can shape the success of their organizations. From e-commerce platforms to complex inventory systems, SQL is the key to managing big data and transforming it into actionable insights.
Geared for experienced technical professionals, Introduction to SQL Programming is a three-day, hands-on course that will provide you with a solid understanding of SQL programming, providing you with the tools, techniques, and insights required to excel in database management and analysis.
Throughout the course, you'll learn how to handle data challenges with creativity and precision, learning how to extract, analyze, and interpret large datasets. This includes developing abilities to craft, interpret, and optimize SQL queries, analyze data, and implement effective database solutions, leading to informed, data-driven decision-making. You'll explore relational design principles, entity relationship diagrams, and the creation of efficient data models to represent complex relationships within data. The course also covers how to construct, interpret, and optimize SQL queries, including the use of functions, joins, subqueries, and advanced analytical techniques.
Through extensive lab work, you'll gain the foundational knowledge and practical skills required to tackle various data challenges with confidence and creativity. You'll exit the course equipped with the SQL knowledge and skills needed to craft, interpret, and optimize SQL queries, analyze data, and implement effective database solutions, leading to informed, data-driven decision-making within your organization.

Course Outline:

Basic RDBMS Principles
Relational design principles
Accessing data through a structured query language
Entity relationship diagrams
Data Domains
Null values
Indexes
Views
Denormalization
Data Model Review
The SQL Language and Tools
Using SQL*Plus
Why Use SQL*Plus When Other Tools Are Available
Starting SQL*Plus
EZConnect
SQL Commands
PL/SQL Commands
SQL*Plus Commands
The COLUMN Command
The HEADING Clause
The FORMAT Clause
The NOPRINT Clause
The NULL Clause
The CLEAR Clause
Predefined define variables
LOGIN.SQL
Command history
Copy and paste in SQL*Plus
Entering SQL commands
Entering PL/SQL commands
Entering SQL*Plus commands
Default output from SQL*Plus
Entering Queries
What about PL/SQL
Using SQL Developer
Choosing a SQL Developer version
Configuring connections
Creating A Basic Connection
Creating A TNS Connection
Connecting
Configuring preferences
Using SQL Developer
The Columns Tab
The Data Tab
The Constraints Tab
The Grants Tab
The Statistics Tab
Other Tabs
Queries In SQL Developer
Query Builder
Accessing Objects Owned By Other Users
The Actions Pulldown Menu
Differences between SQL Developer and SQL*Plus
Reporting Commands Missing In SQL Developer
General Commands Missing In SQL Developer
Data Dictionary report
User Defined reports
Using scripts in SQL Developer
SQL Query Basics
Understanding the data dictionary
Exporting Key Data Dictionary Information
The Dictionary View
Components of a SELECT Statement
The SELECT Clause
The FROM Clause
The WHERE Clause
The GROUP BY Clause
The HAVING Clause
The ORDER BY Clause
The START WITH And CONNECT BY Clauses
The FOR UPDATE Clause
Set Operators
Column Aliases
Fully Qualifying Tables and Columns
Table Aliases
Using DISTINCT and ALL in SELECT statements
WHERE and ORDER BY
WHERE clause basics
Comparison operators
Literals and Constants in SQL
Simple pattern matching
Logical operations
The DUAL table
Arithmetic operations
Expressions in SQL
Character operators
Pseudo columns
Order by clause basics
Ordering Nulls
Accent and case sensitive sorts
Sampling data
WHERE and ORDER BY in SQL Developer
All, Any, Some
Functions
The basics of functions
Number functions
Character functions
Date functions
Conversion functions
Other functions
Large object functions
Error functions
The RR format mode;
Leveraging your knowledge
ANSI 92 JOINS
Basics of ANSI 92 Joins
Using Query Builder with multiple tables
Table Aliases
Outer joins
Outer Joins In Query Builder
Set operators
Self-referential joins
Non-Equijoins
ANSI 99 Joins
Changes with ANSI99
CROSS Join
NATURAL Join
JOIN USING
JOIN ON
LEFT / RIGHT OUTER JOIN
FULL OUTER JOIN
GROUP BY and HAVING
Introduction to GROUP functions Limiting Rows
Including NULL
Using DISTINCT With Group Functions
GROUP function requirements
The HAVING clause
Other GROUP function rules
Using Query Builder with GROUP clauses
ROLLUP and CUBE
The Grouping function
Grouping Sets
Subqueries
Why use subqueries
WHERE clause subqueries
FROM clause subqueries
HAVING clause subqueries
CORRELATED subqueries
SCALAR subqueries
DML and subqueries
EXISTS subqueries
Hierarchical queries
TOP N AND BOTTOM N queries
Creating subqueries using Query Builder
Regular Expressions
Available Regular Expressions
Regular Expression Operators
Character Classes
Pattern matching options
REGEX_LIKE
REGEXP_SUBSTR
REGEXP_INSTR
REGEXP_REPLACE
REGEXP_COUNT
Analytics
The WITH clause
Reporting aggregate functions
Analytical functions
User-Defined bucket histograms
The MODEL clause
PIVOT and UNPIVOT
Temporal validity
More Analytics
RANKING functions
RANK
DENSE_RANK
CUME_DIST
PERCENT_RANK
ROW_NUMBER
Windowing aggregate functions
RATIO_TO_REPORT
LAG / LEAD
Linear Regression functions
Inverse Percentile functions
Hypothetical ranking functions
Pattern Matching

Available Delivery Options for Introduction to SQL Programming Basics (TTSQL002)

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 Introduction to SQL Programming Basics (TTSQL002) provide?

The 3 day Introduction to SQL Programming Basics (TTSQL002) course gives you up to 19.5 CPD hours/structured learning hours.

Who is the correct audience for Introduction to SQL Programming Basics (TTSQL002)?

Basic Computer Literacy: Familiarity with operating systems, file management, and general computer navigation to ensure a smooth transition into learning SQL tools and environments.
-Understanding of Fundamental Data Concepts: A grasp of basic data concepts like tables, records, and fields would aid in understanding relational databases and how SQL operates within them.
-Basic technical background: Although specific prior scripting experience isn't required to attend, we recommend that you have a background in IT or other technical topics or skills

Do you provide training for Introduction to SQL Programming Basics (TTSQL002)?

Yes, we provide corporate training, dedicated training and closed classes for Introduction to SQL Programming Basics (TTSQL002). This can take place anywhere in United Kingdom including London, Manchester, Birmingham, Edinburgh or live online.

What is the duration of Introduction to SQL Programming Basics (TTSQL002)?

The Introduction to SQL Programming Basics (TTSQL002) training takes place over 3 day(s), with each day lasting approximately 24.00 hours including breaks.

What other terms do people search for?

Why are Nexus Human the best provider for Introduction to SQL Programming Basics (TTSQL002)?

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 Introduction to SQL Programming Basics (TTSQL002)?

Yes, the discount code PENPAL5 is currently available for Introduction to SQL Programming Basics (TTSQL002) training. Only one discount code can be used per booking.

DURATION 1 Day

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.