Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Relational database models
- The structure of a relational database
- Relational operators
Download the data
- Rules for writing SQL queries
- The syntax for the SELECT
- Selecting all columns
- Inquiries from arithmetic operations
- Aliases columns
- Literals
- Concatenation
Restrict results
- The WHERE clause
- The comparison operators.
- LIKE Condition
- Prerequisite BETWEEN ... AND
- IS NULL condition
- IN condition.
- Logical operators
- Many of the conditions in the WHERE clause
- The order of operators
- DISTINCT clause
Sorting Data
- The ORDER BY clause
- Sorting by multiple columns or expressions
SQL Functions
- The differences between the functions of single and multi-rows
- Functions text, numeric, date,
- Conversion functions
- Nesting functions
- Handling of NULL values
Aggregating data using the grouping function
- Grouping functions
- How grouping functions treat NULL values
- Create groups of data - the GROUP BY clause
- Grouping multiple columns
- Reducing the function result grouping - the HAVING clause
Retrieving data from multiple tables
- Types of joins
- Aliases tables
- Joins in the WHERE clause
- INNER JOIN Inner join
- External Merge LEFT, RIGHT
- Cartesian product
Subqueries
- Place subqueries in the SELECT command
- Subqueries single and multi-lineage
- Operators Subqueries single-line
- Operators Subqueries multi-IN, ALL, ANY
Collective operators
- UNION operator
- INTERSECT operator
- EXCEPT operator
Insert, update, and delete data
- INSERT command
- UPDATE command
- DELETE command
Transactions
Requirements
- Computer literacy
- Knowledge of any operating system
14 Hours
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from £3800 online delivery, based on a group of 2 delegates, £1200 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
Testimonials (5)
analytical functions
khusboo dassani - Tech Northwest Skillnet
Course - SQL Advanced
The training materials.
Mona Dobre - DB Global Technology
Course - SQL Advanced level for Analysts
They way the instructor teaches is very informative and effective especially on the 2nd day when topics are a bit advanced.
Aynanie Kiram - Aarki, Inc.
Course - SQL DATABASE MANAGEMENT AND DESIGN - Bespoke
The Trainer Subject Knowledge
Rares Serea - eMAG IT Research
Course - Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems
The trainer, he was knowledgeable, engaging, and easy to learn from. He encouraged a lot of hands-on learning.
