This course investigates how web applications connect with databases to implement features like user registration, posting messages, etc. Web applications exist to allow interaction and content creation that is served to others, as opposed to websites, which are simply one-dimensional static pages.
CSA: The Computer Science Association of South Africa is a professional body formed in partnership with Google to promote, protect, and advance Computer Science and software development education in the country.
MICT SETA: The MICT SETA partners with industry, Universities and TVET colleges (both public and private) in the delivery of respective learning programmes in its endeavour to address identified scarce skills. Its commitment to expand and improve provision of skills development for SMMEs and rural communities will contribute towards addressing the requisite skills immeasurably.
To read reviews from our students, click here
This course is designed for students who have taken one of Hyperion's beginner courses, or have equivalent experience (6 - 12 month programming experience)
Databases are crucial for the function of any major web application. Think of a web application that a retail chain like Pick n’ Pay might use to keep track of stock information. The database that stores the data to be used by the managers is actually the most important thing about such a web application. Information such as suppliers and when they can deliver a certain produce, perhaps the GPS positions of delivery trucks, the current prices of stock, the stock currently held in inventory by the various stores in neighbourhoods, malls, and hypermarkets; must all be stored somewhere. The web site that may be used to view and manipulate this data is just a human friendly interface to the technology that is at the core of the system.
In this course, we are going to focus on the database as the core of a business application. Most courses on dynamic web development approach this subject from the perspective of the programming language used to build dynamic web applications. We’re going to focus on the database, exploring the space where the scripting language PHP is used to interact with a database.
We place a major focus on working the the database directly through SQL statements. We will build a database and interact with it through a terminal to give you a hands on and well grounded understanding of the practical side of databases. However, we also place an emphasis on the theoretical understanding of databases, as we do in all our courses, to give you well rounded experience and the knowledge you need to design and implement your own database from scratch.
This course is studied in the context of a major running application which we will build with each task along the course. The project is a school management system for a fictitious high school. We will implement features such as:
- User registration
- Levels of authorisation - learner, teacher, HOD, headmaster
- Adding students to classes
- Recording marks
- Learner behaviour reports
This project anchors all the our lessons as we delve into the specifics of creating these features. We will learn about security, session management, and object oriented programming in the context of our large project, which allows you to see how these technologies are actually applied in an authentic real world problem.
|Access to all course content|
Get paired with a 1:1 mentor
(learn how it works)
Career guidance and job
Tailored marking on your
code within 6 hours
Weekly video calls with mentor
On-demand priority live chat
with your mentor
$899 3 months up-front
Our courses are designed to help you learn programming skills through practice. Here are the practical projects you'll complete with the help of a mentor as part of this course:
Establishing the Link
We reintroduce the PHP language and quickly clear up all the concepts we should know at this stage. We then delve into how we can set up web servers using PHP to begin creating websites, utilising the power of MySQL to effectively and practically store and retrieve permanent data from our code, culminating in a project to create our very own functional website.
Rounding the Edges
We start learning how to improve the structure of our databases and code behind our website, allowing us to extract more useful information out of our database tables, and use common statements with even greater ease. We also look at creating a more dynamic, engrossing experience for our users by allowing them to register on our websites, and use all these skills in another project to build an even more advanced website.
Not sure which course to take or have a question? Get in touch with our course consultant who are happy to advise.
Dynamic web development is an exciting field. Our most loved social applications like Twitter and Instagram are example of applications that are developed using By taking this course you will equip yourself to develop applications like these.
Prior programming experience requirements
- You’re required to complete the PHP programming essentials course prior to enrollment into Certified Database Developer
- You are motivated to learn and apply your mind to more complex tasks in programming.
- You have no problems communicating fluently in English.
- Sound programming skills
- Experience with back-end scripting language. PHP is preferred
Equipment and Technologies
- Access to a computer and a broadband internet connection.*
- We will be using a text editor to write scripts, and a terminal to interface with MySQL and Apache, so no special requirements are needed except for those required by these applications above
- An email address where course content and other important course information can be delivered.
*The use of Dropbox means you’re not required to be always online while taking this MicroDegree. Even if you don’t have internet - perhaps due to some loadshedding - you can still access your Dropbox folder and continue to edit/update files. As soon as you have internet again, your Dropbox will sync with your trainer and he or she will see your changes. Dropbox and our own website is also available on everything from Blackberry to Apple tablets - so you will be able to learn while on the move.
Hyperion is happy to work with your employer to support them paying for your enrolment of this course.
Most companies have budgets for employee training - just ask your HR department or manager!
We offer discounted and tailored training programmes for corporate teams.