Get in Touch
 Duration 14 hours

Course Outline

Relational database models

  • Understanding the structure of a relational database
  • Relational operators

Retrieving data

  • Best practices for writing SQL queries
  • SELECT statement syntax
  • Selecting all columns
  • Performing arithmetic operations in queries
  • Column aliases
  • Literals
  • String concatenation

Limiting result sets

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

Sorting data

  • The ORDER BY clause
  • Sorting by multiple columns or expressions

SQL functions

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

Data aggregation using grouping functions

  • Overview of grouping functions
  • How grouping functions handle NULL values
  • Creating data groups with the GROUP BY clause
  • Grouping by multiple columns
  • Filtering grouped results with the HAVING clause

Retrieving data from multiple tables

  • Types of joins
  • Table aliases
  • Defining joins within the WHERE clause
  • INNER JOIN
  • External merges: LEFT and RIGHT joins
  • The Cartesian product

Subqueries

  • Using subqueries within the SELECT command
  • Single-row and multi-row subqueries
  • Operators for single-row subqueries
  • Operators for multi-row subqueries: IN, ALL, and ANY

Set operators

  • The UNION operator
  • The INTERSECT operator
  • The EXCEPT operator

Inserting, updating, and deleting data

  • The INSERT command
  • The UPDATE command
  • The DELETE command

Transactions

Requirements

  • Basic computer literacy
  • General knowledge of any operating system

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customised 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 £3200 + VAT*

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

Testimonials (3)

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories