SQL Training

SQL stands for Structured Query Language It is used to storing, manipulating and retrieving data in database. SQL statements are used to perform tasks on database such as insertion, deletion, update, create and drop. In the data driven world everyone need insights to form strategy, marketing and other operations. SQL is a basic skills that everyone should know.

Course Content:

• Introduction
• Introduction of SQL
• What is RDBMS?
• Data Definition Commands
• Advanced Data Definition Commands (SQL ALTER Statement)
• Data Manipulation Commands
• SQL Advanced
• SQL Set Operator
• SQL UNION
• SQL UNION ALL
• SQL INTERSECT
• SQL MINUS
   
• SQL Create View
• SQL Drop View
• SQL Create Sequences
• SQL Drop Sequences
• SQL Cloning Tables
• SQL Subqueries
• Subquery with SELECT Statement
• Subquery with INSERT Statement
• Subquery with UPDATE Statement
• Subquery with DELETE Statement
• SQL EXISTS Operator
• SQL Functions
• SQL String Functions
• SQL Date & Time Functions
• SQL Math Functions