Get in Touch
 Duration 14 hours

Course Outline

Relational database models

  • Relational database architecture
  • Application of relational operators

Data acquisition

  • Standards for constructing SQL queries
  • SELECT statement syntax
  • Retrieval of all columns
  • Queries involving arithmetic calculations
  • Column aliasing
  • Use of literals
  • String concatenation

Result set restriction

  • Utilization of the WHERE clause
  • Comparison operators
  • LIKE condition logic
  • BETWEEN ... AND conditions
  • IS NULL condition handling
  • IN condition application
  • Logical operators
  • Complex conditions within the WHERE clause
  • Operator precedence rules
  • Use of the DISTINCT clause

Data sorting

  • Implementation of the ORDER BY clause
  • Sorting by multiple columns or expressions

SQL functions

  • Distinction between single-row and multi-row functions
  • Text, numeric, and date functions
  • Data type conversion functions
  • Nested function usage
  • Handling of NULL values

Data aggregation via grouping functions

  • Overview of grouping functions
  • Treatment of NULL values in grouping functions
  • Data grouping using the GROUP BY clause
  • Grouping by multiple columns
  • Filtering grouped results with the HAVING clause

Retrieving data from multiple tables

  • Categories of joins
  • Table aliasing
  • Join conditions within the WHERE clause
  • INNER JOIN implementation
  • External joins: LEFT and RIGHT
  • Cartesian product concept

Subqueries

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

Set operators

  • UNION operator usage
  • INTERSECT operator usage
  • EXCEPT operator usage

Data modification: Insert, update, and delete

  • INSERT command syntax
  • UPDATE command syntax
  • DELETE command syntax

Transactions

Requirements

  • General computer literacy
  • Familiarity with operating system environments

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories