Web Development

Variables and Operators

• Simple Addition
• Fun with Text
• Combining Text and Number Favourite Language,
• Again What is a Variable?
• Your Name
• Let's make a difference
• Numbers in Variables
• Changing Variable Values
• More on Assignment
• Equality
• What's Your Type?
• Empty Cans, Empty Variables
• Increment Operator
• Adding Numbers,
• Again Another Addition Operator

Dive into Strings

• What are Strings
• Combining Strings
• Length of a string
• Selecting Characters
• Substrings
• Change to Upper Case
• What is your Index?
• Reversing a String
• What's the Secret?

Functions

• Simple Addition Function
• Division Problem
• Capitalize the first letter
• Capitalize Names
• Square a Number
• Sum of Squares Area of Triangle
• Just Came to Say Hello
• Global Variables

Control Structures

• Max of Two
• Best of Three
• Doesn't JavaScript Rock?
• Are you Chuck Norris?
• Find the Number
• Five Letter Palindrome
• FizzBuzz
• Nested If Else Statements

Loops & Arrays

• Add Them up
• Sum Odd Numbers
• Auto Correct, kind of
• Comparing Strings
• Word Count
• Pushing Arrays
• Every Other One
• First and Last
• Reverse Swapping
• Range
• Words
• If and Only if
• Delete Free E-mails

JavaScript Summary

• Getting started
• Running Code
• Types
• Operators
• Conditional Code
• Loops
• Reserved Words
• Arrays
• Objects
• Functions
• Testing Type
• The “This” Keyword
• Scope
• Closure

jQuery

• How jQuery Works
• Additional jQuery Support
• $ vs $()
• $ (document ).ready()
• Avoiding conflicts with other libraries
• Attributes
• Selecting Elements
• Working with Selections
• Manipulating Elements
• The jQuery Object
• Traversing
• CSS, Styling & Dimensions
• Data Methods
• Utility Methods
• Iterating over jQuery and non-jQuery Objects
• Using jQuery's .index() function
jQuery Event Basics
• Event Helpers
• Introducing Events
• Handling Events
• Inside the Event Handling Function
• Understanding Even Delegation
• Triggering Event
• Handlers
• History of jQuery Events
• Introducing Custom Events
• jQuery Event Extensions

Ajax

• Key Concepts
• jQuery's Ajax related methods
• Ajax and forms
• Working with JSONP
• Ajax Events

Plugins

• Finding & Evaluating Plugins
• How to create a basic Plugin
• Advanced Plugin Concepts
• Writing Stateful Plugins with the jQuery
• UI Widget Factory
• Append outside of Loops
• Cache Length during Loops
• Detach elements to work with them
• Don't act on Absent Elements
• Optimise Selectors
• Use Stylesheets for changing CSS on many elements
• Don't treat jQuery as a black box

Code Organisation

• Code Organisation Concepts
• Beware Anonymous functions
• Keep things DRY
• Feature & Browser Detection
• jQuery Deferreds Deferreds
• examples

jQuery UI

• Getting started with jQuery UI
• How jQuery UI works
• Theming jQuery UI
• i) Using jQuery UI themeroller
• ii) jQuery UI CSS Framework API
• iii) How to write a Theme
•  
• Widget Factory
• Extending Widgets with the Widget Factory
• Widget Method Invocation
• Why use the widget factory
• How to use the widget factory

Effects

• Introduction to Events
• Custom Effects with .animate()
• Queue & Dequeue Explained
• The uses of jQuery .queue()
• and .dequeue()

PHP Basics

• How PHP Works
• The php.ini file
• Basic PHP Syntax
• PHP Tags
• PHP Statement and Whitespace
• Comments
• PHP Functions
• Hello World!
• Variables
• Variable Types
• Variable Names (Identifiers)
• Type Strength
• Hello Variables!
• Variable Scope
• Superglobals
• Constants
• Variable-Testing and Manipulation Functions
• PHP Operators programming in Industry
• Creating Dynamic Pages
• Single Quotes vs. Double Quotes
• Hello World
Conditional Processing
• If conditions
• Loops
• While
• Do.............While
• For
• Break and Continue

• Enumerated Arrays
• Initialising Arrays
• Appending to an Array
• Reading from Arrays
• Looping through Arrays
• Associative Arrays
• Initialising Associative Arrays
• Reading from Associative Arrays
• Looping through Associative Arrays
• Superglobal Arrays
• Two-dimensional Arrays
• Reading from Two-dimensional Arrays
• Looping through Two-dimensional Arrays
• Array Manipulation Functions
• Require
• Require once
• Auto prepend file and auto append file
• User Functions
• Defining and calling functions
• Default Values
• Variable Scope
• By reference vs. By Value
• Form Processing
• Code Organisation
• Sessions Configuring Sessions
• Session Functions
• Mail()
• Shortcomings of mail()
• PHPMailer

MySql

• Introduction to the Northwind Database
• Some Basics
• Comments
• Whitespace and Semi-colons
• Case Sensitivity
• SELECTing All columns in All Rows
• SELECTing specific columns
• Sorting Records
• The Where clause and Operator Symbols
• The WHERE clause and Operator Words
• Checking Multiple conditions
• Subqueries
• Joins
• Table Aliases
• Multi-table Joins
• Outer Joins
• Unions
• UNION ALL
• UNION Rules
• INSERT
• UPDATE
• DELETE
• Querying a Database
• MySQL Overview
• MySQL Methods and Properties
• Inserting and Updating Records
• MySQL Prepared Statements