MY-SQL
MY SQL
Introduction
1.Evolution of Database Systems
2.RDBMS- A Brief
3.Normalization
4.E-Codd Rules
5.Oracle Tools
a.Management Studio
b.Object Explorer
c.Query Analyzer
d.Correlated Queries
e.Joins
f.Top Clause
5.Working with views
6.Working With Indexes
7.Identity Column
8.Handling Transactions
a. Roll Back
b. Commit
c. Save Points
SQL
1.Working with Tables
2.Working With Constraints
3.DML Operations
a.Selection / Retrieval
b.Insertion
c.Deletion
d.Updating
4.Select Statement –Exclusive
a.Where Clause & Operators
b.Group by, Having & Order By Clauses
c.Sub Queries
Transact SQL
1.Basic programming Constructs
2.Function
3.Procedures
4.Triggers
5.Diagrams
Database Operations
6.Basic Programming & Constructs
7.Function
8.Procedures
9.Data Base Back Up
10.Restoring Database
Test Your Knowledge with our OnLine Exam