Diploma: Microsoft Software
Analyst Track A
Program Pre-requisites: Required
to have experience in windows environment and basic concepts of programming,
networking, or databases.
Program Objectives: Students completing the program
should have the necessary skills to become employed as an entry-level
e-commerce web developer, database developer and administrator, or a
programmer, mostly in the Microsoft environment.
Topics covered are as follow:
Implementing and Supporting Microsoft
Windows 2000: Panning. Installation and Configuration. Managing
Resources. Connectivity. Monitoring and Optimization. Troubleshooting.
Microsoft SQL Server 2000 DBA
and Development: The course covers introduction to Microsoft
SQL server 2000 features, the SQL enterprise manager, SQL security manager,
SQL transfer manager, SQL administrator, object manager, isql and ISQL/w,
system procedures, using the SQL enterprise manager to build your server,
creating login Ids and usernames, backup devices, database devices,
creating databases and database objects. The course covers creating
groups of servers, checking space utilization, managing transaction
logs, setting database options, using SQL enterprise manager to generate
SQL scripts. Replication, Stored Procedures, Views, Triggers, rules,
defaults, constraints, and user-defined data types, error codes, performance
tuning and optimization.
Next Page More
on Track 'A'