skip to navigation skip to content

Theme: Databases

Show:
Show only:

7 matching courses


Access 2016: Creating a Simple Database Thu 23 May 2019   09:30 Finished

This is an introduction to the popular database package Microsoft Access. The course is aimed at those who have never used the package before or have just started using it. There is an Access Fast Track course that is a shortened version of this course for those who learn at a faster pace.

Access 2016: Fast Track Introduction Thu 9 May 2019   09:00 Finished

This is a fast paced and shortened version of the 2-session Access 2016: Creating a Simple Database course and thus is more suitable for those who are quick learners. This course will be taught using Access 2016 on PCs (Windows 7).

Access 2016: Further Use Thu 4 Jul 2019   09:30 Finished

This course is intended for those already using Microsoft Access 2016 who wish to explore more advanced queries and forms. Those who have attended the Access 2016: Creating a Simple Database course will find this follows on seamlessly from where that course left off - but be prepared for a harder challenge. Part of the course explores relational database design concepts for simple databases. The remainder focuses on more advanced queries and forms. The second session is optional for you to either work through and consolidate the course material, or to receive support on your own project.

MySQL: Implementing a Relational Database Design Thu 2 May 2019   14:00 Finished

This beginners course equips you with the skills to implement a relational database design entity relationship diagram (ERD) into a MySQL database. Please be prepared for a fast paced course, but the materials provided can be used for consolidation after the course.

This is a fee-based online course for Oracle: Database Design and SQL.

In the first half of Oracle’s Database Design and Programming with SQL course you will learn to analyse complex business scenarios and create a data model - a conceptual representation of an organization’s information. In the second section you will implement your database design by creating a physical database using SQL, an industry-standard database programming language.

Completion of this course prepares you close to being ready to sit the external exam Oracle Database 11g: SQL Fundamentals I 1Z0-051. Read more about this exam.

This is a fee-based online course for Oracle: Database Programming with PL/SQL. If you are unfamiliar with the Oracle online course environment it is strongly recommended that you attend the Oracle Academy: Database Design & SQL, and Database Programming in PL/SQL Induction to the Online Environment course.

This course covers Oracle's PL/SQL, a procedural language extension to SQL. You will learn procedural logic constructs such as variables, constraints, conditional statements and iterative controls.

This online course prepares you toward the external exams:

  • Oracle Database 11g: Program with PL/SQL Exam Number: 1Z0-144 Read more about this exam and its associated fee.
  • Program with PL/SQL Exam Number: 1Z0-147 Read more about this exam and its associated fee.
Relational Database Design Tue 30 Apr 2019   09:00 Finished

This course gives a simple introduction to organizing your data in a relational database. It aims to explain the arranging of your data. It does not deal with specific relational databases systems such as Access, Oracle or SQL Server, or the technical tools that you would or could use to set up your database. The course aims to provide you with enough information to sit down and design your database, regardless of the database product that you intend to use. Exercises will be done on paper, without using computers.

[Back to top]