 |
|
Duration : 40 Hours |
| Course Description |
PHP & MySQL are two of the most popular open source technologies to emerge during the past decade. PHP is a powerful language for writing server-side Web applications. MySQL is the world's most popular open source database. Together, these two technologies provide you a powerful platform for building database-driven Web applications. Our PHP & MySQL training course teaches attendees everything they need to build data-driven Web sites using PHP & MySQL successfully. |
| |
| Prerequisites |
Basically LAMP is a set of software that enables you to create a web application that's dynamic and stable. Participants should have ability to hand-code HTML. Having exposure to CSS and Basic Programming would be beneficial. |
| |
| PHP Training Objectives: |
To teach attendees the PHP programming skills they need to successfully build interactive, data-driven sites To teach students enough MySQL database skills to build the databases that will power their sites |
| |
UNIT 1: Acquaintance with Linux
Installation of RedHat Enterprise Linux Advance Server 5 and Fedora 8
Planning a Linux Installation
Pre-Installation Planning
Hardware Requirements
Partioning Requirements
Dual Booting with Windows Operating System |
| |
UNIT 2: Browsing the File System
Explain the Filesystem Hierarchy Standard (FHS) UNIX is one big directory!
Explore the Linux file system (ext, ext3)
Important directories
- /etc, /boot, /var, /srv, /proc, /tmp, /lib, /usr/lib, /usr/local/lib, /bin,
/sbin, /usr/bin, /usr/sbin
Partitions (/, /var, /usr and /boot) and Virtual Memory (SWAP)
Relative and Absolute Pathnames
X Usage Basics:
- Switching between virtual consoles and the graphical environment
- Elements of the X Window System
- Starting the X server |
| |
UNIT 3: Running Basic commands, Getting Help and Text Editors
Common BASH Shell commands - Command Line Interface (CLI)
w, wall, watch, whereis, which, who - Important w commands
Familiar with the many help resources in RHEL
Explore usage of finding and searching user-tools (find, locate)
Demonstrate typical usage of vi/vim ASCII text editors |
| |
UNIT 4: BASH shell navigation
Types of Shell in Linux
History, editing, completion, shortcuts
Basic BASH shell navigation & PATH
variable manipulation(set,unset,env,export,etc.)S
Introduction to Bourne Again Shell (BASH) - Globes/environment
Input (STDIN), output (STDOUT) and standard error (STDERR) redirection
Pipes
Command chaining |
| |
UNIT 5: System Monitoring & Process Management
Process creation: fork and exec
Demonstrate usage of system monitoring tools (uptime, free, top,
ps, pstree, pidof - explore process lists
Statistics on the virtual memory system: vmstat
Process Priority: nice and renice
Managing Background Process: jobs, fg, bg, Ctrl Z
Usage of killing process: kill |
| |
UNIT 6: File Ownership & Permissions
Explain UNIX/Linux file security & permissions rules & concepts
- Symbolic Way: (-rwxrwxrwx)
- Octal Way: (777)
Setting Permissions with chmod |
| |
UNIT 7:User and Group Administration
User Administration\Management
Group Administration
Changing User and Group Ownership: chown, chgrp
User and group creation & management concepts - passwd,
shadow,group,gshadow files
Password aging under Linux: chage
User profile implementation logic and concepts –
(Bash profile/etc/skel/aliases/PATH/etc.)
Usage: FTP / Telnet / SSH
Service Management |
| |
UNIT 8: Apache Web Server Administration
Discuss Apache server's features and concepts
Examine Apache - Red Hat HTTPD CONF hierarchy
Examine various configuration files
Configure IP-based Virtual Hosts
Configure Name-based Virtual Hosts
Restrict access to content based on IPs and subnets
Configure .htacess file with directives
Implement Basic and digest authentication schemes
Implement Apache logging system per virtual host |
| |
UNIT 9: Starting with PHP
Overview on HTML/CSS & forms
What is PHP
Data Flow
Scripting Vs. Viewing
Your First PHP Script
Embedding PHP with HTML |
| |
UNIT 10: Absolute Basics
PHP Variables & Operators
More Complex Operators & Logical Operators
'If' and Conditional Operators |
| |
UNIT 11: PHP programming fundamentals
Using 'else' and 'elseif'
Multiple Choices: 'switchcasebreak'
Concise Conditionals: '?'
The 'For' Loop
'while' and 'do..while' loops
'break' and 'exit' |
| |
UNIT 12: Data
Introduction to Arrays
Playing with Arrays:
Referencing
Sorting
Multidimensional
Joining
Splitting
Strings functions |
| |
UNIT 13: Starting with MYSQL
What is a relational database?
Accessing MYSQL - the command line
Configuring Users in MYSQL
Creating Databases and Tables
MYSQL Data Types - Numeric Types
MYSQL Data Types - Date Types
MYSQL Data Types - String Types
EXAMPLE: Creating A Table Statement
Basic MYSQL commands – INSERT, SELECT and UPDATE
Basic MYSQL commands - DELETE and DROP |
| |
UNIT 14: Using MYSQL with PHP
Connecting to the Database
Choosing a database
Querying a database
Retrieving results
Useful MySQL functions in PHP
Setting Up phpMyAdmin
Using phpMyAdmin |
| |
UNIT 15: Interacting With The User
A Simple HTML Form
Taking User Input from Forms via PHP
Handling Email
Validating an Email Address
File and Directory Access in PHP |
| |
UNIT 16: Sessions and Users
A Simple Login System
Sessions
Cookies
Logging a User
Logging out
Registering a User |
| |
UNIT 17: Security
Encryption
Session Security |
| |
UNIT 18: Error Capture
I/O Issues
Exception handling in PHP |
