SQL

Module: 01 Introduction to SQL and Installation

What is SQL

Need of SQL

RDBMS (Relational Database Management System) Significance

Difference between SQL and file storage

Benefits of SQL storage

How to use command line interface

How to use IDE (Integrated Development Environment)

How to start writing query as beginner

Module: 02 DDL (Data Definitions Language) Commands and Start SQL as Beginner Level

Create database

Data Types

Create Table

Delete database

Alter database

Constraints and Types of Constraints

Introduction to View

Differentiate between Table and View

Need of Normalization

Normalization Implementation

Module: 03 DML (Data Manipulation Language) and TCL (Transaction control language) Commands

Insert command and applications

Delete command and applications

Update command and applications

Commit and rollback

Bulk insert

Bulk update

Specific record insert operation

Specific record update operation

Specific record delete operation

Differentiate between delete, drop and truncate

Usage of where clause

Usage of different type of operators

Module: 04 Frequently used Operates and Clauses in SQL

Insert – As- Select Statement

Select Statement

Select with Sorting

Select with where clause

Wildcard

CASE Expression and usage

Module: 05 Joins and multi table handling

How to create relationship between multiple tables using primary-key and foreign key relation

Self-Join Inner to retrieve data from tables

Join Left to retrieve data from tables

Join Right to retrieve data from tables

Join Cross Join to retrieve data from tables

<!--[endif]-->

Module: 06 Functions usage in SQL and frequently used Clauses

Data type specific functions in SQL

Generic functions in SQL

Build-in functions in SQL

Group by clause

Having clause

Order by clause

Logical Functions

Aggregate Functions

String Functions

Date Functions

Logical Functions

Module: 07 Advance SQL (PL/SQL)

Need of PL (Procedural Language)

Benefits of PL

Procedural Language and SQL Integration

Need of Stored Procedure

Need of Functions

Differentiate between Function and Stored Procedure

Need of Triggers

Types of Triggers

How to create Triggers

How to execute Stored Procedures with parameters

Module: 08 Real time best practices in Project

Common query writing standards in Projects

Naming standards

Code review strategy

Real time nested query examples

Query optimization and importance in project

Performance Tuning and importance in Project

Project build on SQL and PL/SQL.