ESAMI Offices
 
 
 
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:  2 weeks 
Starting: 25 Oct 2021  Ending: 5 Nov 2021
Fees: 1500 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 troubleshooting 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:  2021-10-25-3-10-2951

Apply Online

PROGRAMME ANNOUNCEMENTS

ESAMI COURSES RUNNING IN DUBAI FROM JUNE - AUGUST, 2021

18 May 2021
    PROGRAMME TITLE START DATE END DATE DURATION Building Strategic Agility: The Leadership Paradigm 14 June 18 June 1 week Proj...

2021 ESAMI BUSINESS SCHOOL ACTIVITY CALENDAR

26 Jan 2021
    2021 ESAMI BUSINESS SCHOOL ACTIVITY CALENDAR PROGRAMME STARTING DATES S/N VENUE PROGRAMME STARTING DATE INTAKE 44 EVENING ...
View More
 

Short Courses Calendar

bullet

CENTERS

bullet

DOWNLOADS

 
 
 
facebook   twitter