Get in Touch
 Duration 21 hours

Course Outline

Relational Database Models

  • Understanding the structure of a relational database
  • Different types of table connections
  • Database normalization and denormalization
  • Relational operators

Extracting Data

  • Best practices for writing SQL queries
  • SELECT statement syntax
  • Retrieving all columns
  • Performing arithmetic operations within queries
  • Using column aliases
  • Working with literals
  • The concatenation operator

Filtering Results

  • The WHERE clause
  • Comparison operators
  • The LIKE condition
  • The BETWEEN ... AND prerequisite
  • The IS NULL condition
  • The IN condition
  • Boolean operators: AND, OR, and NOT
  • Combining multiple conditions in the WHERE clause
  • Operator precedence and ordering
  • The DISTINCT clause

Sorting Data

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

SQL Functions

  • Differences between single-line and multi-line functions
  • Text, numeric, and date functions
  • Explicit and implicit data conversion
  • Conversion functions
  • Nesting functions
  • Viewing function performance using the dual table
  • The SYSDATE function for retrieving the current date
  • Handling NULL values

Aggregating Data with Grouping

  • Grouping functions
  • How grouping functions treat NULL values
  • Creating data groups with the GROUP BY clause
  • Grouping across multiple columns
  • Filtering grouped results with the HAVING clause

Retrieving Data from Multiple Tables

  • Types of join connectors
  • Using NATURAL JOIN
  • Table aliases
  • Performing joins within the WHERE clause
  • INNER JOIN
  • External joins: LEFT, RIGHT, and FULL OUTER JOIN
  • The Cartesian product

Subqueries

  • Placing subqueries within the SELECT command
  • Single-row and multi-row subqueries
  • Operators for single-row subqueries
  • Grouping features within subqueries
  • Operators for multi-row subqueries: IN, ALL, ANY
  • How NULL values are treated in subqueries

Set Operators

  • The UNION operator
  • The UNION ALL operator
  • The INTERSECT operator
  • The MINUS operator

Inserting, Updating, and Deleting Data

  • The INSERT command
  • Copying data from another table
  • The UPDATE command
  • The DELETE command
  • The TRUNCATE command

Transactions

  • Using COMMIT, ROLLBACK, and SAVEPOINT commands

DDL Commands

  • Key database objects
  • Object naming conventions
  • Creating tables
  • Available data types for columns
  • The DEFAULT option
  • NULL and NOT NULL constraints

Managing Tables

  • Referential integrity: CHECK, PRIMARY KEY, FOREIGN KEY, and UNIQUE constraints
  • Creating a table from a query
  • Dropping a table with DROP TABLE
  • The DESCRIBE command

Other Schema Objects

  • Sequences
  • Synonyms
  • Views

Requirements

  • Basic computer literacy
  • Familiarity with 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 £4800 + VAT*

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

Testimonials (6)

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories