Course Outline

RDBMS (Relational DataBase Management System)

Relational Operators

SQL as Declarative Language

SQL Syntax

SQL Sublanguages DQL, DML, DDL, DCL

DQL (Data Query Language) in Detail

  • SELECT clause
  • Column aliases
  • Table aliases
  • Date types and Date functions
  • Group function
  • Table joins
  • JOIN clause
  • UNION operator
  • Nested queries
  • Correlated subqueries

DML (Data Manipulation Language) Overview

  • Inserting rows (INSERT)
  • Inserting rows using subquery
  • Updating rows (UPDATE)
  • Deleting rows (DELETE)

DDL (Data Definition Language) Overview

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

CONSTRAINTS Overview

  • NULL i NOT NULL
  • CONSTRAINT clause
  • ENUM type
  • SET type
  • PRIMARY KEY
  • UNIQUE
  • FOREIGN KEY
  • DEFAULT clause

Transactions Overview

  • COMMIT
  • ROLLBACK
  • SAVEPOINT
  • Implicit and explicit rollbacks and commits

SQL Dialects Overview

  • MySQL
  • Microsoft Access and SQL Server
  • Oracle and PostgreSQL

Requirements

Basic computer skills.

  14 Hours
 

Testimonials

Related Courses

Developing Applications with Oracle Application Express (APEX)

  21 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

SQL in MySQL

  14 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