Need Tutorials on mySQL and PHPAdmin

Backend Development
1

My web host is IONOS. My subscription includes hosting databases. They support PHPAdmin and MySQL. And, now I’ve told you everything I know about databases (well, almost). I have created text document that describes data elements in my page designs along with some booleans and control variables. I’m to the point that I need to learn how to open my databases, maintain them (ie, add/change/delete structures). Once I figure that out I can create the data tables. When I have some tables created, I can begin to work on adding data to the tables. To get to that point I have identified 3 major goals:

  1. Understand how MySQL and PHP work together to manage data
  2. Learn enough PHPAdmin and MySQL to get started.
  3. Create tables with a few entries to use for testing and learning.

Can anyone point me to tutorials on SQL and PHP? I need raw noob lessons. I know a tiny bit about normalizing db’s; so I have a concept in mind for what tables I need to create to get started. I need to fill in the gaps

2

OK. I found that there is a tutorial here on relational databases (170 lesson modules). Instructions for getting started are these:


This is one of the required projects to earn your certification. For this project, you will build a database of celestial bodies using PostgreSQL.

This course runs in a virtual Linux machine using Gitpod. Follow these instructions to start the course:

    Create a GitHub account if you don't have one
    Click the start button below
    Login to Gitpod with your GitHub account if you aren't already
    Once the virtual Linux machine is finished loading, start the CodeRoad extension by:
        Clicking the "hamburger" menu near the top left of the VSCode window,
        Going to the "View" menu,
        Clicking on the "Command Palette" option,
        and running the "CodeRoad: Start" command
    Follow the instructions in CodeRoad to complete the course

I have a github account with several repos, but I couldn’t find instructions on github, or searching the web, that tell me how to login to GitPod.

Can anyone help?

3

Hi @ahraitch

Here is a Gitpod guide.

Happy coding

1 Like