established 1985
Benefiting from over 30 years’ experience, Fitzwilliam Institute’s Online Diploma in PHP&MySQL course features:
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. 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.
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.
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.
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 .
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.
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.
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. 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.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.
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. 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,..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.
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. 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.
Basic Select, Limit, union and aggregate functions, Subqueries and joins ,Date, time and other 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. 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.
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.
OOP Fundamentals, class methods and properties, constants, static methods and properties, interfaces & abstract classes, controlling object serialization, instantiating an object dynamically.
Using PHP’s session handling features, PHP Cookie handling. 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.
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
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. Retrieving data in an HTML table, getting field names, viewing and selecting records, editing the record, generating variables.
Administrate Database, SQL joins, transactions, working with a database via phpMyAdmin. Insert Statements, Replace Statements, Update Statements, Select Statements, Delete Statements, Alter Database, Alter Table, Alter View, Drop Statements.
You are required to create and design a shopping cart for a website that has a main focus on online sales
On successful completion of this course you will receive a Diploma 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.
Duration: You will have full access to online resources and subject expert support for one calendar year. However, you can complete the course in as little as 4 - 6 months, by dedicating 6-8 hours of study per week.
Course Fees: 995.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.