MySQL Level 1 for Computing Science teachers

Most dynamic web sites use data stored and accessed from a database. One of the most widely used database technologies is MySQL. Knowing the basics of MySQL will enable you to use MySQL to build simple data-driven web pages and sites. Having some knowledge of the basics of MySQL is also useful for those who want understand and be able to knowledgeably talk about data-driven web applications, content management systems and cloud based computing.

This one day course will introduce MySQL along with the PHP code necessary to connect to databases, query them and process the data.

Course aims

  • To develop Computing teachers knowledge, skills and confidence in MySQL.
  • To provide an opportunity for teachers to explore, discuss and practice workable methods of teaching and using MySQL in the classroom

Who this course is for

  • Computing Science teacher, teaching web design and development.
  • You are delivering, developing and planning Higher and Advanced Higher Computing Science courses.
  • You're a complete beginners with no piror knowledge of MySQL or server-side database managment systems.
  • You would like to up-date your MySQL skills to use contemporary APIs for connection and access to your databases
  • You'd like a refresher on MySQL coding.
You want to go on to learn CSS, Javascript or PHP and need a firm foundation of HTML.

What you need to know

It is vital that you have knowledge of basic HTML before attending this course.

Whilst not necessary, a basic uderstanding of relational databases would be useful

This course makes use of PHP to connect to, query and display the results from MySQL databases. For this reason you must have knowledge of and competence in basic PHP coding.

Knowledge and skills needed to undertake this course

This course builds on topics and skills developed in one or more lower level courses.

It is vital that you have either attended the course(s) listed below or that you are confident that you are comfortable and competenent in the topics and skills it covers.

We want you to get the best from your time on our course and making sure you are attending a course at a suitable level is important for you and for the others on the course.

Please click the link and view the course details. If you are in any doubt about whether you are at the right level to do this course then please don't hesitate to contact us for further information

Courses that provide the necessary skills:

Content summary

Below is an overview of the topics covered in the course.

  • What is MySQL
  • Introduction to data driven dynamic web sites
  • Basic MySQL database design
  • Creating a basic database in MySQL
  • Creating connections to MySQL databases using PHP code
  • Creating simple queries to access information
  • Creating simple queries to modify data
  • Processing and displaying query results on web pag­es using PHP and HTML
  • Basic data driven web page projects

Course content in detail

  • MySQL- What is MySQL
  • Database Driven Web Sites- introduction to database driven web sites
  • Database Design– basic database design
    • Tables, fields and primary keys
  • Creating MySQL databases– how to create data­bases using phpMyAdmin interface
    • Setting up the course databases
  • Database Connections
    • How to connect to a MySQL database
    • PHP code to create connection
    • IDE techniques for working with databases
  • MySQL Queries - creating simple queries to access information
    • Select
    • Where
    • Order By
  • MySQL Queries - simple queries to modify data
  • Database CRUD
    • Create
    • Read
    • Update
    • Delete
  • Displaying Data
    • using PHP and HTML to display data on web pages
  • Basic data driven web page projects