Short Course: Information Communication Technology
The ICT programme has been widely acclaimed as one of the most competitive programmes in the region.
The programme covers specializations in the areas of Hardware, Software and Design in addition to equipping
the student with a wide range of skills and knowledge necessary for any Information Technology professional.
Course Title: Database Administration using SQL Server
Venue: ESAMI Headquarters, Arusha, TANZANIA
Learning Duration: 4 weeks
Starting: 1 May 2017 Ending: 26 May 2017
Fees: 2800 USD
Payment Details: to cover tuition and training materials only.
The overall objective of the course is to facilitate participants on how to use SQL
Server product features and tools related to administration of a database. This course covers database design and the use of database management systems for applications. Participants will learn technical skills required to write basic Transact-SQL queries for Microsoft SQL Server. This course is the foundation for all SQL Server-related disciplines: Database Administration, Database Development and Business Intelligence.
HOW PARTICIPANTS WILL BENEFIT
At the end of the course participants will be able to:
Plan, Install and configure the Database Software;
Describe the databases, the physical structure of databases and their related configuration options;
Create and process databases and tables;
Secure SQL Server and implement policy-based management backup, recovery and restore databases and individual files:
Perform database monitoring, maintenance and trouble shooting problems.
WHO SHOULD ATTEND?
Database Administrators and individuals who perform database administration and maintenance as their primary area of responsibility or working in environments where databases play a key role in their primary job.
Introduction to SQL Server and its tool set;
Systems preparation, installation & configuration of SQL server;
Creating and processing database and tables;
Fundamentals of SQL Server, stored procedures, views and triggers;