Course Outline

Relational database models

  • Relational operators
  • Characteristics of declarative SQL language
  • SQL syntax
  • Division language DQL, DML, DDL, DCL

Data Query Language

  • SELECT queries.
  • Aliases columns of tables
  • Service date (DATE types, display functions, formatting)
  • Group Features
  • Combining internal and external tables (JOIN clause)
  • UNION operator
  • Nested Subqueries (the WHERE clause, the table name, column name)
  • Correlated subqueries

Data Modification Language

  • Inserting rows (INSERT clause)
  • Inserting rows by request
  • Variation of the rows (UPDATE)
  • Delete rows (DELETE)

Data Definition Language

  • Creating, altering and dropping objects (CREATE, ALTER, DROP)
  • Creating tables using subquery (CREATE TABLE .... AS SELECT...)

Requirements

  • Computer literacy
  • Knowledge of any operating system
  7 Hours
 

Number of participants


Starts

Ends


Dates are subject to availability and take place between 9:30 am and 4:30 pm.
Open Training Courses require 5+ participants.

Testimonials (1)

Related Courses

Related Categories