Course Outline

Relational database models

  • The structure of a relational database
  • Connection types of tables
  • The normalization and denormalization database
  • Database Management System (RDBMS)

Relational Operators

Characteristics of declarative SQL language SQL Syntax Division language DQL, DML, DDL, DCL Language DQL (Data Query Language)

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

Data Modification Language

  • Inserting rows (INSERT clause)
  • Inserting via query
  • Updating rows (UPDATE)
  • Removing rows (DELETE)

Data Definition Language

  • Create, change of ownership, remove tables (CREATE, ALTER, DROP) Creating tables by asking (CREATE TABLE .... AS SELECT ...)


  • Options NULL and NOT NULL
  • CONSTRAINT clause
  • Condition PRIMARY KEY
  • Condition UNIQUE
  • Condition FOREIGN KEY
  • DEFAULT clause



Language DCL

  • Granting and revoking permissions (GRANT, REVOKE)
  • Roles
  • Creating Users
  • sequences
  • Synonyms
  • The views (perspective)


  • Computer skills
  • Knowledge of any operating system
  14 Hours


Related Courses

SQL in Microsoft Access

  14 hours

Microsoft Access - download the data

  14 hours

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

  14 hours

SQL in SQL Server

  14 hours

Transact SQL Basic

  14 hours

Transact SQL Advanced

  7 hours

SQL Fundamentals

  14 hours

SQL Advanced in MySQL

  7 hours


  14 hours

ORACLE PL/SQL Fundamentals

  21 hours

ORACLE SQL Fundamentals

  14 hours

Oracle SQL for beginners

  21 hours

Oracle SQL Advanced

  14 hours

Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012

  21 hours

Developing Applications with Oracle Application Express (APEX)

  21 hours