Postgraduate Diploma in PHP & MySQL via Online Distance Learning

Enrolment date: 22 September 2017

Benefiting from over 30 years’ experience, Fitzwilliam Institute’s Online Postgraduate Diploma in PHP&MySQL course features:

  • Comprehensive modules covering all aspects of PHP&MySQL: HTML/XHTML, HTML Commands, HTML Documents, HTML Tables, Cascading Style Sheets (CSS), Java Script and Control Statements, Functions, Arrays and Loops, String Functions and Date and Time Functions, Flow Control Functions, Object Oriented Programming, and many more.
  • Interactive course expert support, advice and guidance from leading industry professionals. Always ready to help or answer any questions you might have throughout the course, all of Fitzwilliam Institute’s course experts are top industry professionals with many years of successful experience. Our Postgraduate Diploma in PHP&MySQL contains the core and vital industry key skillset and, on completion, all of our students are industry-ready.
  • Real life PHP&MySQL briefs. Fitzwilliam Institute’s Postgraduate Diploma in PHP&MySQL offers practical and specific skills that can be applied in real world situations. You will gain exposure to invaluable toolkits and resources and prepare real life PHP&MySQL project briefs, which will enable you to improve your work portfolio.
  • Flexible online learning. Fitzwilliam Institute’s Diploma in PHP&MySQL course can be completed in your own time, from the comfort of your own home, to suit your lifestyle. You will have full access to online resources and subject expert support for two calendar years. However, you can complete the course in as little as 1 year, by dedicating 6-8 hours of study per week.
  • PHP&MySQL Jobs, Networking and Volunteer Opportunities. Benefiting from over 30 years of industry experience, we are extremely well placed within the industry. Employers are always looking for Fitzwilliam Institute’s students and alumni. Fitzwilliam Institute’s website features a comprehensive jobs and volunteer opportunities section.

Introduction to Computers and the Internet

Computer Organization, Machine Languages, Assembly Languages and High-Level Languages, History of the Internet and World Wide Web, World Wide Web Consortium (W3C), Web, Personal, Distributed and Client/Server Computing, Hardware Trends, Object Technology, JavaScript: Object-Based Scripting for the Web, Browser Portability, Software Technologies.

Web Browser Basics: Internet Explorer and Firefox

Introduction to the Internet Explorer and Firefox Web Browsers, Connecting to the Internet, Internet Explorer and Firefox Features, Customizing Browser Settings, Searching the Internet, Keeping Track of Your Favourite Sites, File Transfer Protocol (FTP), Online Help, Other Web Browsers.

Understanding Web 2.0

What Is Web?, Search, Content Networks, User-Generated Content, Blogging, Social Networking, Social Media, Tagging, Social Bookmarking, Software Development, Rich Internet Applications (RIAs), Web Services, Mashups, Widgets and Gadgets, Location-Based Services, XML, RSS, Atom, JSON and VoIP, Web Monetization Models, Web Business Models, Future of the Web, Where to Go for More Web, Information, Web Bibliography, Web Glossary.

HTML/XHTML

Editing XHTML, First XHTML Example, W3C XHTML Validation Service, Headings, Linking, Images, Special Characters and Horizontal Rules, Lists, Tables, Forms, Internal Linking, meta Elements, non-displaying comment.

HTML Commands

Common HTML tags & styles , Horizontal lines ,Anchors, Links & URLs ,Ordered lists and plain lists, Re-formatting text ,Tables & Embedded tables ,Background images , Working with Images ,Graphic file formats, Defines the document type

HTML Documents

Building a document header ,Placing a banner and a contact button ,Laying out a main menu ,Creating a layout template: main body ,Creating a layout template: sidebar area ,Creating a layout template, Building a main home page: main body content ,Building a main home page: sidebar content , Creating a page with a menu, graphics, and formatted links , Creating a page containing an ordered list .

HTML TABLES

Define a Table, Declares a Table Body Segment, Define A Table Data Cell, Define a Multiline Text Input Area Within a Form, Define a Table Footer Segment, Define a Table Header Cell, Define a Table Head Segment, Define The HTML Document Title, Define a Table Row, Render Text In A Non-Proportionally Spaced Font As In a Teletype.

Cascading Style Sheets™ (CSS)

Inline Styles, Embedded Style Sheets, Conflicting Styles, Linking External Style Sheets, Positioning, Elements, Backgrounds, Element Dimensions, Box Model and Text Flow, Media Types, Building a CSS Drop-Down Menu, User Style Sheets, CSS 3.

JavaScript

Simple Program: Displaying a Line of Text in a Web Page, Modifying Our First Program, Obtaining User Input with prompt Dialogs, Dynamic Web Page, Adding Integers, Memory Concepts, Arithmetic, Decision Making: Equality and Relational Operators.

JavaScript: Control Statements I

Algorithms, Pseudocode, Control Structures, if Selection Statement, if…else Selection Statement, while Repetition Statement, Formulating Algorithms: Counter-Controlled Repetition, Formulating Algorithms: Sentinel-Controlled Repetition, Formulating Algorithms: Nested Control Statements, Assignment Operators, Increment and Decrement Operators.

JavaScript: Control Statements II

Essentials of Counter-Controlled Repetition, for Repetition Statement, Examples Using the for Statement, switch Multiple-Selection Statement, do…while Repetition Statement, break and continue Statements, Labelled break and continue Statements, Logical Operators, Summary of Structured Programming.

JavaScript: Functions

Program Modules in JavaScript, Programmer-Defined Functions, Function Definitions, Random Number Generation, Example: Game of Chance, Another Example: Random Image Generator, Scope Rules, JavaScript Global Functions, Recursion, Recursion vs. Iteration.

JavaScript: Arrays

Arrays, Declaring and Allocating Arrays, Examples Using Arrays, Random Image Generator Using Arrays, References and Reference Parameters, Passing Arrays to Functions, Sorting Arrays, Searching Arrays: Linear Search and Binary Search, Multidimensional Arrays, Building an Online Quiz.

JavaScript: Objects

Introduction to Object Technology, Math Object, String Object, Fundamentals of Characters and Strings, Methods of the String Object, Character-Processing Methods, Searching Methods, Splitting Strings and Obtaining Substrings, XHTML Markup Methods, Date Object, Boolean and Number Objects, document Object, window Object, Using Cookies, Using JSON to Represent Objects.

Document Object Model (DOM): Objects and Collections

Introduction, Modelling a Document: DOM Nodes and Trees, Traversing and Modifying a DOM Tree, DOM Collections, Dynamic Styles, Summary of the DOM Objects and Collections.

JavaScript: Events

Registering Event Handlers, Event onload, Event onmousemove, the event Object and this Rollovers with onmouseover and onmouseout, Form Processing with onfocus and onblur, More Form Processing with onsubmit and onreset, Event Bubbling, More Events.

PHP Fundamentals

PHP language, programming on the Web Server, installing, configuring and running Apache, checking security settings, safe mode.PHP Basics: Syntax, anatomy of a PHP script, data types, variables, constants, operators, control structures, errors and error management. Embedding PHP in Web Pages

Strings and Patterns

String basics, using strings as arrays, comparing, searching and replacing strings, formatting strings, quantifiers, matching and extracting strings, parsing Fixed-Width field data records, storing binary data in strings.

Conditions and Functions

Basic syntax, returning values, variable scope, passing arguments, variable-length, argument lists, passing arguments by reference. Functions Calling a Function, Defining a Function, Variable Scope, Function Parameters, Return Values, Variable Functions , Anonymous Functions.

Loops and Arrays

Counting with the for Loop, using a while Loop, array basics, array operations, array iteration, sorting arrays, arrays as stacks, queues and sets, using arrays in forms.

Object Oriented Programming in PHP

OOP Fundamentals, class methods and properties, constants, static methods and properties, interfaces & abstract classes, controlling object serialization, instantiating an object dynamically.

FTP request

Useful software, how to access manipulate and change files on the server. Free hosting providers.

Working with Files

Creating or opening a local file, opening a remote file, reading from standard input, reading a file into a string, reading a file into an array, examining file access modifiers, examining file access modifiers, reading and creating configuration files, reading and writing compressed files, working with formatted text.

PHP Session Handling Features

Using PHP’s session handling features, PHP Cookie handling.

Handling Date & Time in PHP

Inserting Code in Your Script, Including files, Storing include files, Setting up include directories, Creating Reusable Code (Functions), Defining functions, Using variables in functions, Passing values to a function, Returning a value from a function, Using built-in functions.

Security and Encryption

Global Variables and Form Data, Filenames, File Uploads, File Permissions, Concealing PHP Libraries, PHP Code, Shell Commands, Security, .Concepts and practices, preventing session fixation, protecting against form spoofing, avoiding Cross-Site scripting, storing passwords, encrypting and decrypting data, storing encrypted data in a file or database, detecting SSL, sharing encrypted data with another web site, encrypting email with GPG.

Troubleshooting a Script

Missing Semicolons, Not Enough Equal Signs, Misspelled Variable Names, Missing Dollar Signs, Troubling Quotes, Invisible Output, Numbered Arrays, Including PHP Statements.

Functions

Basic Select, Limit, union and aggregate functions, Subqueries and joins ,Date, time and other functions

Database Programming

Relational databases and SQL, SQL data types, creating databases and tables, creating indices and relationships, dropping objects, adding and manipulating data, SQL joins, transactions, working with a database via phpMyAdmin.

PHPMYADMIN

Administrate Database, SQL joins, transactions, working with a database via phpMyAdmin.

Accessing Databases with PHP

Retrieving data in an HTML table, getting field names, viewing and selecting records, editing the record, generating variables.

Advanced SQL and MySQL

Database Design, Performing Joins, Grouping Selected Results, Creating Indexes, Using Different Table Types, Performing FULLTEXT Searches.

MYSQL Statements and clauses

Insert Statements, Replace Statements, Update Statements, Select Statements, Delete Statements, Alter Database, Alter Table, Alter View, Drop Statements

String Functions

Return number of characters in argument , Return the character for each integer passed , Return string at index number, Perform full-text search, Synonym for UPPER(), Remove trailing spaces, Reverse the characters in a string.

Date and Time Functions

Add time values (intervals) to a date value, Convert from one timezone to another , Synonyms for CURDATE(),Subtract two dates, Format UNIX timestamp as a date , Return the number of months between periods, Return the date argument converted to days, Return the year.

Mathematical and Aggregate Functions

Return the absolute value, Return the arc cosine, Return the arc tangent of the two arguments, Return the value of pi, Return the argument raised to the specified power, Return the sign of the argument, Return the sine of the argument, Truncate to specified number of decimal places, Compute a cyclic redundancy check value, Return the base-10 logarithm of the argument, Return the base-2 logarithm of the argument, Return the natural logarithm of the first argument.

Flow Control Functions

MySQL supports the IF, CASE, ITERATE, LEAVE LOOP, WHILE, and REPEAT constructs for flow control within stored programs. It also supports RETURN within stored functions. Many of these constructs contain other statements, as indicated by the grammar specifications in the following sections. Such constructs may be nested. For example, an IF statement might contain a WHILE loop, which itself contains a CASE statement.

PHP API - using functions built into PHP with MySQL

Returns the number of affected rows in the previous MySQL operation, Turns on or off auto-committing database modifications, Changes the user of the specified database connection, Returns the default character set for the database connection, Closes a previously opened database connection, Commits the current transaction, Fetches a result row as an associative, a numeric array, or both, Returns the number of columns for the most recent query.

XML and Web Programming

Code libraries, template systems, error handling, session tracking, registering new users, parsing XML with DOM, extracting information using XPath transforming XML with XSLT, setting XSLT parameters from PHP, mapping XML schema data types to PHP classes, integrating with JavaScript, converting plain text to HTML and HTML to plain text.

AJAX and PHP

Ajax allows for rich-internet applications that mimic the responsiveness and complex user interfaces typically associated with desktop applications. Moving applications to the web browser opens many possibilities, including the ability to save user data, connecting with other users for collaboration and sharing, and making deployment and using the application easier since web browsers are standard-issue with most computers regardless of operating system.

PHP FRAMEWORKS

Main Frameworks, Why to use Frameworks, Understanding WMC requests.

PROJECT BRIEFS

PHP Blog

A client has approached you and proposed that you create a fully functional blogging site. You are required to create a corresponding database for this project. You are also required to enable group news to be uploaded and separated by category and date, and display them in the user friendly page.

PHP Content Management System

A client has approached you and requested that you create a content management system for a website. You are required to create a Database, and admin functionality that allows creation, editing, publishing, organizing and managing of content of a website.

PHP Shopping cart

A client has approached you and asked you to create a shopping cart for their site. You must create a database and allow functionality for users to purchase items from the website. You will be required to create a link between PayPal & the site through the shopping cart.

PHP Social networking

A client has approached you and requested that you create a social networking site. You are given the task of creating the Database, and functionality for users to interact on your website. You must allow the users of this site to post comments, upload avatar photos, etc.

Fully interactive E-Commerce site with Management Tools

A client has requested you create a fully interactive Ecommerce website. You must create the information Database and set up the Administrative system behind the website, Creating the Public Template, The site’s Product Catalog, The Shopping Cart, Order records.

METHODS OF LEARNING

Online Lecture Modules, Subject Expert Feedback Sessions after each Module, practical case studies, end of module assignments. etc.

SUBJECT EXPERTS

Full support is available from our subject experts by email at the end of each module and an ongoing basis during the course

WHO SHOULD APPLY

Anyone who wishes to develop a career in Web Development, PHP & MySQL. Selection is based on consultation. Please contact us by phone to arrange.

POSSIBLE CAREERS

Computer Programmer, Software Developer, Java Developer, Software engineer, Software Test, Software Design, IT consultant, Software Trainer.

QUALIFICATIONS

Successful candidates are awarded the Postgraduate Diploma in PHP and MySQL at Pass, Credit or Distinction level. The Postgraduate Diploma is awarded by the Institute of Commercial Management.

APPLICATION PROCESS

Selection is based on telephone consultation. Please contact us by phone or email to arrange a Consultation today!

On successful completion of this course you will receive a Postgraduate level qualification that is certified and awarded by the ICM (Institute of Commercial Management).

The Institute of Commercial Management was founded in 1979 and is one of the leading Professional Examination and Certification Bodies in the world today. Fitzwilliam Institute have developed and provided practical skills training courses in liaison with the Institute of Commercial Management qualifications and certifications framework for over 25 years. The Institute of Commercial Management certifications and continual professional development training awards are recognised throughout Europe, the USA, Canada, Australia, South Africa and Asia in a total of 140 countries, by leading industries, bodies and professions.

next start date: 22nd September 2017

Duration: You will have full access to online resources and subject expert support for two calendar years. However, you can complete the course in as little as 1 year, by dedicating 6-8 hours of study per week.

Course Fees: 1995.00 EUR

To secure your place on the course the full fee is required. All fees must be paid in full before the course begins. Please note, the full course fees are inclusive of all course materials and certification costs.

Enrolment intake is strictly limited on this course. Early application is advised. Places are allocated on a first come first served basis.

Fitzwilliam Institute closes on Bank Holidays and for a number of days at Christmas and New Year. Fitzwilliam Institute reserves the right to postpone, cancel or alter courses without notice or to change any of the details in this brochure. Fees are not refundable unless the course is cancelled by Fitzwilliam Institute. Distance Learning courses are provided by Fitzwilliam Institute BGLS Ltd.

Year on year, we have the pleasure of training students from top Ireland and international companies. See where our most recent students come from and find out what they have to say.