Course Duration in Hours
30
30
Introduction to SQL
Writing SQL SELECT Statements
Restricting and Sorting Data
aggregate function
Using Sub queries to Solve Queries
Using Single-Row Functions to Customize Output
Reporting Aggregated Data Using the Group Functions
Displaying Data from Multiple Tables
Using Sub queries to Solve Queries
Using the SET Operators
Manipulating Data
Using DDL Statements to Create and Manage Tables
Manipulating Large Data Sets
Using Sub queries to Solve Queries
Controlling User Access
Creating Other Schema Objects
Generating Reports by Grouping Related Data
Managing Data in Different Time Zones
Searching Data Using Advanced Sub queries
Hierarchical Retrieval
Regular Expression Support
Introduction to PL/SQL
Writing Control Structures
Working with Composite Data Types
Using Explicit Cursors
Cursors and Records
Creating Stored Procedures
Creating Stored Functions
Creating Packages
Dynamic SQL
Creating Triggers
Types of triggers
Applications for Triggers
Adminsitration of sql server
creating users
eQuadriga Finishing School, Amman Nagar (Tiruchirappalli),Tiruchirappalli,IN