Upon completion of this course, the participant will be an Powerfull client -server application useing the programming tools and custom controls,OLE,DDL,OBjectoriented program features.
Graduated / Undergraduate interested in pursuing a career in computer programming / application developer / software professional who are currently working in DBMS environment
Upon completion of this course the participant will be able to creat powerfull client - server application using the programming tools and custom controls,OLE,DDE,object oriented program features.
3 MONTHS
COURSE COVERAGE
MY-SQL
client / Server Concepts - Relational Model - Data Definition using SQL-Modifiy Tables
Using ALTER TABLE Queries
add a column, add an Index, Add a Pray Key INSERT
and DELETE queries - UPDATE queries - Using Select
queries SELECT, WHERE, LIMIT,
ORDER BY: GROUP
Join - Constraints and indexes - Views - Expressions
-Grouping - Using Functions - Math Functions, Compare
String value, work wih Dates
JOIN and Subqueries - advanced - MySQL Query Processing - Database
Management, Stored Procedures, Triggers,etc...
VISUVAL BASIC 6.0
Controls - User Controls - Properties and Events - Conto!
Statement and Loops - Procedures and Functions
Error
handling - Creating Instances of Objects - Menu Editors -
MDI Appicatons - Sequential - Random and Binary Files
handing
Data Manager - ODBC OLEDB -Data controls
and SQL - ActiveX - DAO - RDO - ADO - Data Report - DHTML
PROJECT
Student will develop Client Server projects like Hotel
Management System
Patient care System, Front Office
Management, etc, with Visual Basic as frontend and SQL server
as back-end.
Tihs will give them the experience they
need to develop any client server project independently.