SQL - DataBase Course

Training/Coaching/Tuition by TTA (Talhunt Training Academy) Chennai View Contact

Request Info

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

TTA (Talhunt Training Academy)

TTA, an Initiative of Talhunt Nextgen Education Pvt Ltd, is one of the fastest growing professional talent development company for the Information technology sector. TTA is promoted & managed by Industry experts with more than 10 years of rich experience. Since its inception in 2008, TTA has successfully skilled more than 4000 professionals and has a corporate partner network of more than 75 companies.

TTA provides Industry centric, employability related training in a wide range of platforms in to software development & Remote Infrastructure domains such as JAVA, J2EE, .NET, SOFTWARE TESTING,PHP & MYSQL, ORACLE, SQL, CCNA, CCNP, HARDWARE & NETWORKING, RED HAT LINUX, IBM-AIX, SOLARIS, CLOUD COMPUTING, ITIL.

Our Vision

To be recognized as the most preferred training service provider through continuous improvement driven by the integrity, teamwork, and innovation of TALHUNT people.

Our Mission

"We continually strive for excellence in our services and we stand by our values to keep our customers happy."

Our Values

• Integrity

• Professionalism

• Innovation

• Excellence

• Dignity