Get in Touch
 Duration 21 hours

Course Outline

Relational database models

  • Architecture of relational database systems
  • Establishing relationships between tables
  • Database normalization and denormalization processes
  • Application of relational operators

Data retrieval

  • Standards for constructing SQL queries
  • Syntax for the SELECT statement
  • Retrieving all columns from a table
  • Executing arithmetic operations within queries
  • Assigning aliases to columns
  • Utilizing literals in queries
  • Using the concatenation operator

Filtering results

  • Application of the WHERE clause
  • Using comparison operators
  • Employing the LIKE condition
  • Using the BETWEEN ... AND syntax
  • Checking for NULL values with IS NULL
  • Using the IN condition
  • Applying Boolean operators AND, OR, and NOT
  • Combining multiple conditions in the WHERE clause
  • Operator precedence rules
  • Eliminating duplicates with the DISTINCT clause

Sorting Data

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

SQL functions

  • Distinguishing between single-row and multi-row functions
  • Characteristics of text, numeric, and date functions
  • Explicit and implicit data type conversion
  • Using conversion functions
  • Nesting functions within queries
  • Testing function performance using the dual table
  • Retrieving the current date with the SYSDATE function
  • Managing NULL values within functions

Aggregating data via grouping

  • Application of aggregation functions
  • Treatment of NULL values by aggregation functions
  • Creating data groups using the GROUP BY clause
  • Grouping by multiple columns
  • Filtering aggregated results with the HAVING clause

Retrieving data from multiple tables

  • Types of table joins
  • Using the NATURAL JOIN statement
  • Assigning aliases to tables
  • Performing joins within the WHERE clause
  • Using the INNER JOIN statement
  • Using LEFT, RIGHT, and FULL OUTER JOIN statements
  • Understanding the Cartesian product

Subqueries

  • Positioning subqueries within the SELECT command
  • Distinguishing between single-row and multi-row subqueries
  • Operators for single-row subqueries
  • Applying grouping within subqueries
  • Operators for multi-row subqueries (IN, ALL, ANY)
  • Treatment of NULL values within subqueries

Set operations

  • Using the UNION operator
  • Using the UNION ALL operator
  • Using the INTERSECT operator
  • Using the MINUS operator

Inserting, updating, and deleting data

  • Using the INSERT statement
  • Copying data from another table
  • Using the UPDATE statement
  • Using the DELETE statement
  • Using the TRUNCATE statement

Transactions

  • Managing data changes with COMMIT, ROLLBACK, and SAVEPOINT

Data Definition Language (DDL) commands

  • Primary database objects
  • Standards for naming database objects
  • Creating tables
  • Available data types for columns
  • Using the DEFAULT option
  • Defining NULL and NOT NULL constraints

Managing tables

  • Enforcing referential integrity via CHECK, PRIMARY KEY, FOREIGN KEY, and UNIQUE constraints
  • Creating tables based on query results
  • Dropping tables using DROP TABLE
  • Inspecting table structure with the DESCRIBE command

Additional schema objects

  • Managing sequences
  • Creating synonyms
  • Defining views

Requirements

  • Basic computer literacy
  • Familiarity with standard operating systems

Number of participants


Price per participant

Testimonials (6)

Upcoming Courses

Related Categories