PHP with MySQL

Duration: 
3 days
Codes: 
PHMY,PHP

Overview

If you're looking to build a solid foundation in your development career, this course is an ideal place to begin. MySQL for Beginners will introduce you to the fundamentals of relational databases and SQL through hands-on exercises.Learn To:Install the MySQL server.Describe the features and benefits of MySQL.Describe the basics of relational databases.

Audience

Every new and existing web developer who wishes to gain the knowledge needed to begin to build dynamic web sites and web applications using PHP and MySQL. No previous programming experience is assumed

Skills Gained

To provide the skills needed to create and alter a MySQL database and query and modify data held within such a database.

Prerequisites

  • Basic computer literacy is required
  • Previous experience with any command-line program
  • Knowledge of database concepts

Course Outline

  • Understand the features and benefits of MySQL
  • Install and start the MySQL server
  • Understand the basics of relational databases
  • Understand the SQL and MySQL languages
  • Understand Data/Column types with regard to efficient database design
  • View a database design structure and content
  • Create a database design using an efficient structure
  • Extract basic database information using the SELECT command
  • Troubleshoot syntax and understand typical warnings and errors
  • Delete or modify a database, and table row data
  • Group query data with aggregation
  • Connect data from multiple table rows using JOIN
  • Perform nested sub-queries
  • Use simple functions (String, Date, Numerical)
  • Describe MySQL connectors, their major features and differences
  • Understand MySQL storage engines, transactions and features of the common engines

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Onsite
Onsite3 1500 £1500 2019-05-19