App and Web Development - PHP, MySQL och Drupal – Open Source Development

Curriculum

Part 1: PHP

Introduction

• Introduction to dynamic websites
• What is PHP and Apache?
• Server Side vs. Client Side Scripting
• What is MySQL Database?
• Why choose PHP and MySQL
• Installing PHP, MySQL, phpMyAdmin, Apache web server

PHP Programming

• PHP Syntax
• Hello world String
• PHP variables, data types and operators
• Conditional statements using If, else and Switch
• Creating numeric and associative Arrays
• Array() Construct
• PHP For and While Loops
• Server Side Includes (SSI)

PHP Functions

• Defining your own PHP functions
• Functions Parameters
• Function return value
• Calling a function
• PHP Built-in Functions
• PHP Date and String functions

HTML Forms and PHP

• What is Form
• Form action and method
• How to send, capture and display form data
• URL Parameters

PHP Global Variables

• POST and GET
• Cookies
• Session

Part 2: MySQL

MySQL Database

• Database concepts and RDBMS (Relational Database Management Systems)
• Introduction to SQL (Structured Query Language)
• Creating ERD (Entity Relationship Diagram)
• Understanding phpMyAdmin
• What are MySQL data types
• Creating and Editing Database and Tables
• Primary and foreign key
• Inserting Data in tables
• Updating, deleting, selecting and searching for data using SWL Wild cards
• Using group functions
• MySQL built-in functions
• Using table joins

Create Dynamic Pages using PHP and MySQL

• Connect PHP with MySQL
• Insert web page data into database
• Update data from web pages
• View dynamic data and delete data on web pages

How to setup a website development project

• Project, Folder and File Structure
• Database design

Projects in PHP and MySQL Course

Project 1: Build a Contact us Email Form

• Create Form on web page
• Accept data
• Mail function

Project 2: Build a Login system

• Create a login page and connect a login page to database
• Validate login data
• Creating a restricted area

Project 3: Build an online shop backend CMS

• Database for shopping cart website
• Add and delete product pages and images
• View and update products
• View customers
• View online orders

Project 4: Create an E-commerce shopping cart website

• E-commerce website design
• Create a home page
• Build a product search
• Display e-commerce catalogue
• Create a basket page
• Remove, add and update the basket page
• Customer checkout

Drupal Course Content:

Introduction

• Introduction to CMS
• What is Drupal
• Role of HTML

Roles and User Accounts

• Changing Your account settings
• Roles and User Accounts
• Set-up New User Accounts

Contents Management

• Content Types
• Finding and Editing Content
• Editing Options
• Taxonomies - Organising content
• Input FormatRevision Information
• File Attachments
• Configure comment settings for a content type
• Authoring information
• Content publishing options

Article Management

• Creating An Article

Setting Up Forums

• Create a Forum and Forum Container
• Settings

Using Books

• Create and Manage a Book and Book Outline
• Add a 'Child' Page

Using CK Editor

• Editing Content
• Cutting and Pasting - will Drupal pick up formatting if text is c + straight from Microsoft Word?
• Styling Text
• Adding Links and Images

Site Structure Overview

• Learn about structure of a Drupal site
• Regions, Blocks and Menus
• Images and resources library - how can images and resources be organised and easily accessed?
• Image resizing - is it possible to do this in the CMS?
• Homepage - what content can be featured here? Is it customisable?
• Search - how does the search work on the public facing website?
• Creating meta data

Drupal Installation

• Downloading Drupal
• How to upload your site to a hosting server
• Finding a web host for your site
• Reserve a domain name (website name)
• Installing Drupal on your Web Space

Drupal Templates

• Adding a pre-existing site theme to Drupal
• Creating and adding your own site template to Drupal
• Free vs premium Drupal themes

Drupal Modules

• What is Modules?
• Where to find Drupal Modules
• Downloading, Installing and Activating Modules

Drupal Core Modules

• Access statistics and logging
• Advanced search
• Blogs, books, comments, forums, and polls
• Descriptive URLs
• Multi-level menu system
• Multi-site support
• Multi-user content creation and editing
• RSS feed and feed aggregator
• User profiles

DrupalDistributions

• What is Distributions and where to find them?
• Downloading and installing Distributions
• Activating Distributions

Managing Media in Drupal

• Uploading Images
• Image Formatting
• Managing the Media Library
• Adding Video to your website
• Adding Audio

SEO for your Drupal website

• What is Search Engine Optimization (SEO)
• On and off page SEO
• Tools for SEO
• H1 and other headings
• Titles and Meta tags
• SEO friendly URL
• Optimising Images
• XML Sitemap
• Sitemap submission

Drupal Views, CCK and Panels

• Creating catalogue of services and products
• Create advanced content views using filters and argument
• Create contact form
• Drupal Content Construction Kit
• Create complex content types
• Visually design website.
• Drag and drop layout manager