Course details
A good database does not just happen. The structure of its contents must be carefully designed. Even a good Database Management system will perform poorly if it is designed badly. This course offers an introduction to database concepts, including coverage of QBE and SQL, and focuses on good design and data administration.
Additional Requirement
Standard PC Requirements
INTEC College recommends the following requirements for a standard PC setup. If additional hardware or software is required, you will find this information listed with the specific course information.
- Personal computer with minimum 1GHz (x86) or 1.4GHz (x64) processor (2GHz or faster recommended).
- 1 GB of RAM or more (4 GB recommended; 8 GB enables you to host all the virtual machines specified for all the practice exercises).
- 15 GB free hard-disk space (60 GB recommended; 80 GB enables you to host all the virtual machines specified for all the practice exercises).
- DVD-ROM drive or DVD-Writer drive.
- Super VGA (1,024 x 768) or higher resolution video adapter and monitor.
- Keyboard and Microsoft mouse or compatible pointing device.
Course Outcomes
Students will develop the skills needed to design, create and administer databases and use SQL to insert, retrieve and change data in their databases, using Microsoft Access. For students developing careers in database administration or database management, this introductory-level course will prepare them for the more advanced Data Administration course, which includes Microsoft's industrial strength database system SQL Server 2010, and the Microsoft Examination in SQL Server 2010 Administration.
Course Content
- Introduction to Database Management
- Introduction to QBE and Relational Algebra
- The Relational Model 2: SQL
- The Relational Model 3: Advanced Topics
- Database Design 1: Normalisation
- Database Design 1: Methodology
- DBMS Functions
- Database Administration
- Databse Management Approaches
Course Location
About Intec College
INTEC College offers the widest range of distance learning courses covering many disciplines from business to creative studies.
INTEC College is one of the South African market leaders in Further Education and Training via distance learning.
INTEC is a modern South African college with a solid track record spanning more than 100 years. With its proud history, INTEC still remains relevant and continues to meet the cultural and academic needs of today’s student.
See all Intec College coursesIT, Computing and Technology Related Questions
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Certified MapReduce Professional VskillsAED 180Duration: 1 To 2 Months
- Diploma in IT Communications John AcademyAED 93
AED 1,396Duration: Upto 19 Hours - AED 10,898Duration: 12 Weeks Live virtual classroom
