ESAMI Offices
 
 
 

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.

TOPICS INCLUDE

  • Relational databases;
  • 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;
  • Database administrative tasks and processes;
  • Database management: integrity and security.

Course No:  2017-05-01-3-10-1663

Apply Online

PROGRAMME ANNOUNCEMENTS

BUSINESS SCHOOL NEW INTAKE DATES FOR 2017

8 Feb 2017
The following are the 2017 intake dates for the Business School DBA/PhD COMMENCEMENT DATES S...
View More
 

Short Courses Calendar

bullet

CENTERS

bullet

DOWNLOADS

 
 
 
facebook   twitter