SQL - DataBase Course

SQL Introduction

SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database.

SQL Application

SQL is a standard language for accessing databases. It will teach you how to use SQL to access and manipulate data in: MySQL, SQL Server, Access, Oracle, Sybase, DB2, and other database systems.

Course syllabus

SQL Basics

Statements, names (table & column names), data types, constants(numeric, string, date & time, symbolic constants), expressions, built-in functions, missing data (Null values)

Simple queries

The Select statement , query results, simple queries, duplicate rows, row selection, search conditions, sorting query results, rules for single table query processing.

Multi-table queries

Simple joins , Non equi-joins, SQL considerations for multi table queries (table aliases, qualified column names, all column selections , self joins), multi table query performance, the structure of the join (table multiplication, rules for multi-table query processing), outer joins.

Summary Queries

Column functions, grouped queries, group search conditions. Sub queries & query expressions : Using sub queries, sub query search conditions, sub queries & joins, nested sub queries, correlated sub queries, sub queries in the Having clause, advanced queries in SQL.

Database updates

Adding data to the database, deleting data from the database, modifying data in the database

Data integrity

Meaning of data integrity, required data, simple validity checking (column check constraints, domains), entity integrity (other uniqueness constraints, uniqueness & Null values), referential integrity (referential integrity problems, delete & update rules, cascaded deletes & updates, referential cycles, foreign keys & Null values), trigger advantages & disadvantages, triggers & SQL standards.

Transaction Processing

Meaning (COMMIT, ROLLBACK), transaction log,transaction & multi user processing, locking (locking levels, shared & exclusive locks, deadlocks, advanced locking techniques)

Creating a database

DDL, creating database, table definitions, constraint definition, aliases & synonyms, indexes, managing other database objects, database structures (single database architecture, multi- database architecture, multi-location database architecture)

Views

Meaning, creating a view (horizontal, vertical, row/column subset,grouped, joined views), updating a view, dropping a view

SQL security

SQL security concepts (user-ids, security objects, privileges), views & SQL security, granting privileges, revoking privileges

Training Highlights

• Trainer with work experience in IT companies

• State of art infrastructure facility

• Placement assistance for all trainees