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...)

CONSTRAINTS

  • Options NULL and NOT NULL
  • CONSTRAINT clause
  • ENUM type
  • type SET
  • PRIMARY KEY condition
  • UNIQUE condition
  • FOREIGN KEY condition
  • DEFAULT clause

Transactions

  • The command COMMIT, ROLLBACK, SAVEPOINT

Requirements

  • Computer literacy
  • Knowledge of any operating system
  14 Hours
 

Testimonials

Related Courses

SQL Fundamentals

  14 hours

SQL Advanced in MySQL

  7 hours

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

  14 hours

SQL in SQL Server

  14 hours

SQL in Microsoft Access

  14 hours

ORACLE PL/SQL Fundamentals

  21 hours

ORACLE SQL Fundamentals

  14 hours

Transact SQL Basic

  14 hours

Transact SQL Advanced

  7 hours

Oracle SQL Language

  14 hours

Oracle SQL for beginners

  21 hours

Oracle SQL Advanced

  14 hours

Microsoft Access - download the data

  14 hours

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

  21 hours

SQL language in MSSQL

  14 hours