Get in Touch
 Duration 14 hours

Course Outline

Relational database models

  • Architecture of relational databases
  • Relational operators

Data retrieval

  • Conventions for constructing SQL queries
  • SELECT statement syntax
  • Retrieving all columns
  • Queries involving arithmetic operations
  • Column aliases
  • Use of literals
  • String concatenation

Filtering results

  • The WHERE clause
  • Comparison operators
  • The LIKE condition
  • The BETWEEN ... AND condition
  • The IS NULL condition
  • The IN condition
  • Logical operators
  • Combining multiple conditions within the WHERE clause
  • Operator precedence
  • The DISTINCT clause

Data sorting

  • The ORDER BY clause
  • Sorting based on multiple columns or expressions

SQL Functions

  • Distinguishing between single-row and multi-row functions
  • Text, numeric, and date functions
  • Data type conversion functions
  • Nesting functions
  • Managing NULL values

Aggregating data with grouping functions

  • Aggregation functions
  • Behavior of grouping functions with NULL values
  • Forming data groups using the GROUP BY clause
  • Grouping by multiple columns
  • Filtering grouped results with the HAVING clause

Querying multiple tables

  • Various types of joins
  • Table aliases
  • Defining joins within the WHERE clause
  • INNER JOIN (Inner join)
  • Outer joins: LEFT and RIGHT
  • Cartesian product

Subqueries

  • Incorporating subqueries into SELECT statements
  • Single-row and multi-row subqueries
  • Operators for single-row subqueries
  • Operators for multi-row subqueries: IN, ALL, ANY

Set operators

  • UNION operator
  • INTERSECT operator
  • EXCEPT operator

Data modification: Insert, update, and delete

  • The INSERT statement
  • The UPDATE statement
  • The DELETE statement

Transactions

Requirements

  • Basic computer proficiency
  • Familiarity with any operating system

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
  • Flexible Schedule: Dates and times adapted to your team's agenda.
  • Format: Online (live), In-company (at your offices), or Hybrid.
Investment

Price per private group, online live training, starting from 2900 € + VAT*

Contact us for an exact quote and to hear our latest promotions

Testimonials (1)

Upcoming Courses

Related Categories