Cynosure Knowledge Solutions

SQL

Introduction to Databases
Introduction to different Database Models
DBMS & RDBMS
Introduction to relational model
Introduction to SQL
DRL
Select statement
projection
selection
Distinct keyword
Operators
SQL Functions
Pseudo-columns
Order the table data
Aliases
SET Operators
Joins
Sub-Queries
DML
Insert
Update
Delete
Merge
DDL
Data types in SQL
Create
Alter [ add/modify/drop]
Truncate
Drop
Rename
Constraints
Need of Constraints
Types of constraints
Domain Constraints
Integrity Constraints
Referencial Integrity Constraints
Applying constraints at different levels
Altering constraints
Enabling / Disabling constraints
Droping Constraints
DataBase Objects
Table
View
Sequence
Synonym
Index
Cluster

PL-SQL

Introduction to PL-SQL
Differences between SQL & PL-SQL
Features of PL-SQL
PL-SQL Block
Architecture of PL-SQL block
Data Types
Writing PL-SQL Blocks
Conditional Statements
Fetching the records from the database
PL-SQL Attributes
%type
%rowtype
Exception Handling
Cursors
Cursor types
Implicit cursors
Explicit cursors
Cursor Attributes
Stored Procedures
Procedures
Functions
Performing DML operations in sub programs
Packages
Developing packages
Access the members from the packages
Triggers
DML triggers
Trigger Types
DataBase triggers