Week - 1 |
Client / Server-based database program and the establishment of the working environment tools |
Week - 2 |
Client / Server database record, maintenance, backup, conversions and user definitions. |
Week - 3 |
Standard data manipulation language (SQL - DML). |
Week - 4 |
Standard data definition language (SQL - DDL) |
Week - 5 |
Advanced SQL programming (T-SQL). Operators, Data Types, Variables |
Week - 6 |
Decision and Loop Control Statements |
Week - 7 |
Jobs (Transactions). Cursors (cursors). |
Week - 8 |
Functions. Stored Procedures (Stored Prosedures). Triggers (Triggers). |
Week - 9 |
Debugging (exception handling) codes. |
Week - 10 |
Client / server interface for the database (Forms) design. |
Week - 11 |
Interface with the program connect to the database using SQL and advanced |
Week - 12 |
Generate reports. |