Designing Websites & Web-Based Apps using HTML, CSS, JavaScript & MySQL

Designing Websites & Web-Based Apps using HTML, CSS, JavaScript & MySQL workshop introduces participants to HTML5/CSS3/JavaScript/MySQL programming skills, necessary in creating websites, web-based applications and services. This workshop focuses on using HTML5/CSS3/JavaScript/MySQL to implement programming logic, define and use variables, perform looping and branching, develop user interfaces, capture and validate user input, store data, and create well-structured applications.

CONTENT

Implement and Manipulate Document Structures and Objects

• Create the document structure by using HTML
• Write code that interacts with UI controls
• Apply styling to HTML elements programmatically
• Implement HTML5 APIs
• Establish the scope of objects and variables
• Create and implement objects and methods

Implement Program Flow

• Implement program flow
• Raise and handle an event
• Implement exception handling
• Implement asynchronous programming
• Create a web worker process

Access and Secure Data

• Validate user input by using HTML5 elements
• Validate user input by using JavaScript
• Consume data
• Serialize, deserialize, and transmit data

Use CSS3 in Applications

• Style HTML text properties
• Style HTML box properties
• Create a flexible content layout
• Create an animated and adaptive UI
• Find elements by using CSS selectors and jQuery
• Structure a CSS file by using CSS selectors

Introduction to MySQL

• MySQL Basics
• Summary of Database Terms
• Accessing MySQL via Command Line
• Indexes
• MySQL Functions
• Accessing MySQL via phpMyAdmin

Mastering MySQL

• Database Design
• Normalization
• Relationships
• Transactions
• Using EXPLAIN
• Backing Up and Restoring

Accessing MySQL using PHP

• Querying a MySQL Database with PHP
• A Practical Example
• Practical MySQL