Login in to your cpanel and just look around – no need to do anything yet – but click and explore.  Just don’t change anything and then save it!  Yet…

phpMyAdmin is one of the most common tools used to manage MySQL databases. Most web hosting companies provide it as part of their service for you to created, manage and delete databases. Generally, you can access phpMyAdmin via the Control Panel – cpanel for short – of your web server. It is a free, browser…

Before we get started with this course – you need your own database to learn with.  So, you get to have your own website!!  Read this page to do these steps: Pick a domain name.  Developing an app – try to find one that matches that. Need some ideas?  Use your name, nickname, favorite hobby,…

We want to create a simple student directory that includes this data: Member First Name Member Last Name Current Class Class Day of Week Class Time Date Class Begins Date Class Ends Max Number of Students Past Classes Home Phone Number Mobile Phone Number Email Address Let’s assume a few things: Members can take more…

What is Database Normalization? Database Normalization is a technique of organizing the data in the database by structuring tables so that: No duplicate or redundant data is stored. This helps to save storage space and make your app run more efficiently. All data dependencies are logical and make sense No data integrity problems called “anomalies”…

A database consists of multiple tables which are made up of rows and columns of data – looks an awful lot like a spreadsheet, right?   Here is a sample table in database: But something very important makes it so much more useful than a spreadsheet.  The ability to have relationships between tables and to perform…