Adobe Photoshop CS6

Course: PHP, MySQL, and JavaScript

Course Description
PHP is the web�s most popular server-side scripting language and is widely used in creating websites. In this course, you will learn the very basics of website creation with HTML to the most advanced dynamic website building with PHP, MySQL and JavaScript technologies including advanced PHP securities. This is an industry designed training content that will help you to get through the proper knowledge on how to build a web application from the scratch.

Class and Lab Hours: 180 (90 Theory, 90 Lab)

Pre-requisites: Basic knowledge of HTML5/CSS3.

Course Objectives:
Upon completion of the course, trainees/students will be able to:
  1. Write effective, efficient PHP scripts
  2. Embed PHP scripts in HTML pages to create dynamic web pages
  3. Manipulate data from web page forms
  4. Track users as they navigate your site with cookies and other PHP features
  5. Structure PHP code using user-defined functions and external libraries
  6. Develop database-enabled Web applications using MySQL
  7. Develop AJAX-powered interactive and dynamic websites
Major Instructional Areas
  1. Customizing the interface and workspace
  2. Creating effects
  3. Working with nested sequences and multi-camera editing
  4. Adding titles and transitions
  5. Managing metadata
  6. Optimizing the output quality
Evaluation: There will be one exam that every trainee/student must pass with 75% marks or more score to get a certificate of completion from TIET.

Suggested Learning Approach
In this course, you will study individually or within a group of your peers. As you work on the course deliverables, you are encouraged to share ideas with your peers and instructor, work collaboratively on projects and team assignments, raise critical questions, and provide constructive feedback.

Detailed Course Outline

 Unit Heading   Unit Topics
Module - 1: PHP and MySQL
1. Introduction to Dynamic Web Content
  • HTTP and HTML: Berners-Lee�s Basics
  • The Benefits of PHP, MySQL, and JavaScript
  • The Apache Web Server
  • About Open Source
2. Setting Up a Development Server
  • What Is WAMP, MAMP, or LAMP?
  • Installing WAMP on Windows
  • Working Remotely
  • Using Program Editor
  • Using IDE
3. Getting Started with PHP
  • Basic HTML Syntax
  • Basic PHP Syntax
  • Using FTP
  • Testing Your Script
  • Sending Text to the Browser
  • Using the PHP Manual
  • Sending HTML to the Browser
  • Adding Comments to Scripts
  • Basic Debugging Steps
4. Variables
  • What are Variables?
  • Variable Syntax
  • Types of Variables
  • Variable Values
  • Understanding Quotation Marks
5. HTML Forms and PHP
  • Creating a Simple Form
  • Choosing a Form Method
  • Receiving Form Data in PHP
  • Displaying Errors
  • Error Reporting
  • Manually Sending Data to a Page
6. Using Numbers
  • Creating the Form
  • Performing Arithmetic
  • Formatting Numbers
  • Understanding Precedence
  • Incrementing and Decrementing a Number
  • Creating Random Numbers
7. Using Strings
  • Creating the HTML Form
  • Concatenating Strings
  • Handling Newlines
  • HTML and PHP
  • Encoding and Decoding Strings
  • Finding Substrings
  • Replacing Parts of a String
8. Control Structures
  • Creating the HTML Form
  • The if Conditional
  • Validation Functions
  • Using else
  • More Operators
  • Using elseif
  • The Switch Conditional
  • The for Loop
9. Using Arrays
  • What is an Array?
  • Creating an Array
  • Adding Items to an Array
  • Accessing Array Elements
  • Creating Multidimensional Arrays
  • Sorting Arrays
  • Transforming Between Strings and Arrays
  • Creating an Array from a Form
10. Creating Web Applications
  • Creating Templates
  • Using External Files
  • Using Constants
  • Working with the Date and Time
  • Handling HTML Forms with PHP, Revisited
  • Making Forms Sticky
  • Sending Email
  • Output Buffering
  • Manipulating HTTP Headers
11. Cookies and Sessions
  • What are Cookies?
  • Creating Cookies
  • Reading from Cookies
  • Adding Parameters to a Cookie
  • Deleting a Cookie
  • What are Sessions?
  • Creating a Session
  • Accessing Session Variables
  • Deleting a Session
12. Creating Functions
  • Creating and Using Simple Functions
  • Creating and Calling Functions That Take Arguments
  • Setting Default Argument Values
  • Creating and Using Functions That Return a Value
  • Understanding Variable Scope
13. Files and Directories
  • File Permissions
  • Writing to files
  • Locking Files
  • Reading from Files
  • Handling File Uploads
  • Navigating Directories
  • Creating Directories
  • Reading Files Incrementally
Module - 2: MySQL
14. Intro to Databases
  • Introduction to SQL
  • Connecting to MySQL
  • MySQL Error Handling
  • Creating and Selecting a Database
  • Creating a Table
  • Inserting Data into a Database
  • Securing Query Data
  • Retrieving Data from a Database
  • Deleting Data in a Database
  • Updating Data in a Database
15. Mastering MySQL
  • Database Design
  • Normalization
  • Relationships
  • Transactions
  • Using EXPLAIN
  • Backing Up and Restoring
16. Accessing MySQL Using PHP
  • A Practical Example
  • Practical MySQL
Module - 3: JavaScript
17. Exploring JavaScript
  • JavaScript and HTML Text
  • Using Comments
  • Semicolons
  • Variables
  • Operators
  • Variable Typing
  • Functions
  • Global Variables
  • The Document Object Model
18. Expressions and Control Flow in JavaScript
  • Expressions
  • Operators
  • The with Statement
  • Using onError
  • Using try...catch
  • Conditionals
  • Looping
  • Explicit Casting
19. JavaScript Functions, Objects, and Arrays
  • JavaScript Functions
  • JavaScript Objects
  • JavaScript Arrays
20. JavaScript and PHP Validation and Error Handling
  • Validating User Input with JavaScript
  • Regular Expressions
  • Redisplaying a Form After PHP Validation
21. Using Ajax
  • What is Ajax?
  • Using XMLHttpRequest
22. Using YUI for Ajax and More
  • Choosing a Framework
  • Using YUI
  • Other Uses for YUI
23. Project - 1
  • Develop a full-scale "Quotes" Web application from scratch
24. Project - 2
  • Designing a Social Networking Site

Every trainee/student will make a portfolio (Binder) that will contain the following in the order listed:
  • Training completion certificate given to student by TIET
  • Course syllabus
  • All assignments (Tutorials and Exercises)
  • Tests/Exams taken by the student
  • Any project done in the class
  • A short summary by the student about how this training session has helped him/her
  • Membership certificate of "Emerging Technologies Club" with student's picture.
  • Class picture with the instructor
  © CADSoft Technologies,Unit No. 256, 2nd Floor, B2, Spaze iTech Park, Sec-49, Sohna Road, Gurgaon, Haryana 122001  
Call us!
Get Social with us!

To Subscribe for monthly Newsletter, please click here