Course Detail

Course Description

SQL & PL/SQL Course / Training Content

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

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.