INTEC Introduction to Databases Certificate

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