Databases Exam Preparation

R3,270.00

Prepare for your Database certification exam with our online short course. Build a strong foundation in Databases and develop entry-level IT skills. Test your knowledge and skills in a simulated environment to ensure readiness for the certification exam. Enroll now for comprehensive exam preparation.

 

This online short course consists of five modules. The course objectives are:

  • Database Design
    • Given a scenario, design tables for storing data
    • Given a scenario, identify the appropriate primary key
    • Given a scenario, choose data types to meet requirements
    • Given a scenario, design relationships between tables
    • Normalise a database
    • Given a scenario, identify data protection measures
  • Database Object Management using DDL
    • Construct and analyse queries that create, alter, and drop tables
    • Construct and analyse queries that create, alter, and drop views
    • Construct and analyse stored procedures and functions
    • Given a scenario, choose between clustered and non-clustered indexes
  • Data Retrieval
    • Construct and analyse queries that select data
    • Construct and analyse queries that sort and filter data
    • Construct and analyse queries that aggregate data
  • Data Manipulation using DML
    • Construct and analyse INSERT statements
    • Construct and analyse UPDATE statements
    • Construct and analyse DELETE statements
  • Troubleshooting
    • Troubleshoot data object management query failures
COURSE DURATION:

As you work through your course material in your own free time, you can pace your studies and determine how quickly you want to progress. As a standard measure, you will have access to the online student portal for a period of 12 months from your date of registration.

COURSE START DATES:

You can start studying this course at any time of the year as soon as you have completed your registration, you can get started. There are no specific registration dates!

COURSE INFORMATION:

This online short course consists of five modules. The course objectives are:

  • Database Design
    • Given a scenario, design tables for storing data
    • Given a scenario, identify the appropriate primary key
    • Given a scenario, choose data types to meet requirements
    • Given a scenario, design relationships between tables
    • Normalise a database
    • Given a scenario, identify data protection measures
  • Database Object Management using DDL
    • Construct and analyse queries that create, alter, and drop tables
    • Construct and analyse queries that create, alter, and drop views
    • Construct and analyse stored procedures and functions
    • Given a scenario, choose between clustered and non-clustered indexes
  • Data Retrieval
    • Construct and analyse queries that select data
    • Construct and analyse queries that sort and filter data
    • Construct and analyse queries that aggregate data
  • Data Manipulation using DML
    • Construct and analyse INSERT statements
    • Construct and analyse UPDATE statements
    • Construct and analyse DELETE statements
  • Troubleshooting
    • Troubleshoot data object management query failures
ASSESSMENT:

Your knowledge and skills will be tested by means of online performance-based assessments and practice questions. These tools will help prepare you for the certification exam by testing your ability to apply your knowledge.

COURSE EXIT OUTCOMES:

Once you have completed this online short course you should be adequately prepared to take the Databases certification exam via Certiport.

This certification forms part of the Information Technology Specialist program.

Enquire Now

We use cookies to give you the best possible browsing experience. By continuing to browse this website you agree to the terms outlined in our Privacy Notice.