MySQL and PHP for Dynamic Websites

This course is for people who wish to develop the knowledge and skills to create and maintain dynamic data driven websites.  It’s for those who are already proficient in building and maintaining static websites using HTML and CSS and who want to bring their website development skills to the next level.  Participants will learn how to develop applications in PHP and use MySQL to create dynamic web applications that incorporate efficient and secure database management and content retrieval.  They will also get the opportunity to use Drupal and WordPress content management systems to create dynamic websites

Course Modules.

    • Induction – The planned outcomes and conditions attached to attendance on the course; good safety, health and hygiene practices; the basic principles involved in environmental issues; and the meaning of equal opportunities. 
    • MySQL Relational Databases – ORACLE – Install and run MySQL relational database management systems on a Windows platform.  Design, in accordance with recognised norms, a relational database.  Query and alter databases using structured query language (SQL) and use advanced MySQL features for data retrieval.  Interpret and troubleshoot error statements, and use relational databases in a web environment.For further information on MySQL visit http://education.oracle.com
    • PHP Server Side Scripting W3C – Identify the key concepts of computer programming such as: variables, arrays, loops, conditional statements, operators, functions and objects.  Use HTML and PHP server-side scripting language to hand code web pages, allowing for password protected login areas of websites and dynamic content. Edit and code structures used in content management systems (CMS) and e-commerce shopping carts. Explore Drupal and WordPress content management systems for creating dynamic websites. For further information on PHP visit www.w3schools.com
    • Career Planning and Work Experience – plan and achieve realistic employment goals. Work independently, while under general supervision, in an organisation or specific vocational context related to developing and maintaining dynamic websites and carry out vocationally related tasks over a period of time.

 

A combination of training methods is used to deliver this course. These include instructions, presentations, demonstrations, lectures, supervised practice, practical work training, discussion groups, one-to-one supported training, and giving and receiving feedback. Participants are required to actively participate in the learning process and to engage in course work outside of normal course hours when required. They must complete a number of projects and assignments throughout the course and keep up-to-date records of their progress. A number of methods are used to assess the participants’ progress and for certification purposes. These include assignments, theory exams, practical exams, learner records and skills demonstrations.

 

  • Have a genuine interest in creating and maintaining dynamic websites and can state the vocational benefits of participating in the course
  • Reached the statutory school leaving age.
  • Leaving Certificate standard of education or equivalent or progression from a web design course.
  • Proficiency in HTML (HyperText Markup Language) and CSS (Cascading Style Sheets) is essential.
  • An aptitude for computer programming is essential.
  • Good numerical and literacy skills are essential.
  • An analytical approach to problem solving and decision making is desirable.
  • Good verbal and written communication skills are desirable.
  • Good interpersonal skills are desirable.

Participants who successfully complete this course will seek employment in companies that specialise in creating and maintaining websites, in the IT departments of large companies that create and maintain their own websites, and as self-employed website developers.