ESAMI Offices
 
 
 

Short Courses

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 - Nov 2018

Venue: ESAMI Headquarters, Arusha, TANZANIA  
Learning Duration:  3 Weeks 
Starting: 5 Nov 2018  Ending: 23 Nov 2018
Fees: 2200 USD
Payment Details: To cover tuition and training materials only.

COURSE OVERVIEW

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.

 

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.

 

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.

 

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:  2018-11-05-3-10-1946

Apply Online

PROGRAMME ANNOUNCEMENTS

ESAMI DOCTORAL & DEGREE PROGRAMMES

14 May 2018
    BUSINESS SCHOOL CALENDAR FOR 2018   ESAMI Business School is inviting applications for its degree programmes scheduled to commence as below.   S/N VEN...
View More
 

Short Courses Calendar

bullet

CENTERS

bullet

DOWNLOADS

 
 
 
facebook   twitter