Database Design & Administration

Database Design & Administration - Skills Certificate

Databases are essential in our modern world and remain a mystery to most people, but they are easy to use if you know just a few things. Students are taught the latest skills needed by today’s computer support professionals. Demonstrate your broad skill sets in SQL server administration and building enterprise-scale data solutions on premises and in cloud environments and given skills in database installation, maintenance, configuration and provisioning tasks.

What You Will Learn:

Manage data with Transact_SQL

Querying data

Program databases by using Transact_SQL

Manage data access and auditing

Manage backup and restore databases

Manage high availability and disaster recover

Introduction to languages, applications and programming used to design and maintain business databases

The use of structured query language (SQL)

To write programs with packages, debugging procedures, triggers and database structures using SQL

Skill set including designing and implementing normalised databases using database reports and creating forms and tables

Course information

Entry Requirements:

Computer Literacy (CAT), Grade 10 or National Certificate (vocational) L2; or equivalent

Methodology:

Lecture-based classes
Virtual classroom available
Hands-on learning environment
Practical application programs

Curriculum:

Querying data with Transact-SQL
Developing SQL databases
Administering a SQL database infrastructure
Provisioning SQL database

Duration:

12 months

Career opportunities:

Database Developer
Database Administrator
Data Scientist
Big Data Architect
Database Designer
Data Analyst
Database Engineer

On completion: The student will receive an ATTI Database Design & Administration Skills Certificate.

ATTI ACCREDITATION

Full accreditation by MICT SETA. Accreditation Number: ACC/2010/04/817

ICB PROVIDER ACCREDDITATION NUMBER: 300723

Database Design & Administration