Complete Web Development With PHP/MYSQL
This is a training course that includes in-depth understanding of PHP and MySQL in order to create websites and apps that match the exacting standards of today’s business enterprises. You will learn how to seamlessly work between the web interface and the back-end and connect them for stellar results. You will also learn advanced PHP concepts and MySQL databases.
- PHP and MySQL installation and configuration
- Using logical expression and loops for coding
- Deploying PHP in-built functions and writing custom functions
- Designing dynamic web page content
- Working with forms and deploying cookies for storing data
- Connecting MySQL with PHP
- Fundamentals of CRUD
- Developing and editing database records
- MySQL for Developers and Database Administrators
- Advanced Stored Procedures in MySQL
| HTML Introduction | HTML Form Attributes | HTML Formatting Elements |
|---|---|---|
| • HTML Introduction • Elements • Tags • Text • Formatting • Attributes • Text Links • Comments • Lists • Images • Image Links • Tabless |
• Form • Input • Text Fields • Password • Reset • Submit • Checkboxes • Radio • Select • Hidden Fields • Upload • Textareas • Special Tags |
• Body • Meta • Style • Div • Layouts • Entities • Scripts • Formatting Tags • Bold • Paragraphs • Headings • Line Breaks, Horizontal Rule • Code • Color Codes, Color Chart |
| CSS Introduction | CSS 3 Advance Features |
|---|---|
| • CSS Introduction • CSS Syntax • CSS Id amp;Class • CSS How • CSS Styling • Styling Backgrounds • Styling Text • Styling Fonts • Styling Links • Styling Lists • Styling Tables • CSS Border • CSS Margin • CSS Padding |
• CSS Advanced • CSS Grouping/Nesting • CSS Dimension • CSS Display • CSS Positioning • CSS Floating • CSS Align • CSS Navigation Bar • CSS Image Gallery • CSS Image Opacity • CSS Image Sprites • CSS Media Types • CSS Attribute Selectors |
| Javascript Baiscs | Javascript Advance |
|---|---|
| • Javascript Introduction • What is JavaScript? • Pre Requirements • Creating a JavaScript file • Tools Required • Basics of Javascript • Structure of a JavaScript Code • DataTypes, Variables & Operators • Looping & Conditional Statements • Functions • Arrays • Numbers • Strings • Dates • Objects |
• DOM (Document object model) • What is DOM? • Element Nodes • Getting Element Nodes • Events & Listeners • Events Overview • Responding to Mouse Events • Form Events • Timers • Debugging Javascripts • Smarter Forms • Javascript Libraries • Libraries Overview • JQuery |
| MySql |
|---|
| • Theory, Terminology and Concepts • Client/Server Concepts • Database and Database Objects • Data Definition using SQL • Databases • Data Types • Tables • Constraints & Indexes • Basic Data Manipulation using SQL • Recurring SQL Constructs • Adding, Modifying, Deleting, Searching Data • Advanced Data Manipulation using SQL • Expressions • Grouping and Aggregate Functions • Joining Tables • Transaction Concepts • Tools for Import/Export |
| PHP Installation and Introduction | PHP Basics | PHP Advance Features |
|---|---|---|
| • PHP Introduction • Introduction PHP and MySQL • Benefits of using PHP MySQL • Setup of PHP Environment • Testing the Page • PHP Programming Concepts • Write your First PHP Program |
• PHP Data Types • Variables in PHP • Array in PHP • Super Global Variables • Operators in PHP • Conditional Statements • Loops (For, While, Do While, Foreach) • PHP Functions • Using Functions in PHP |
• User defined Functions • Predefined Functions • Common Functions • String Functions • File Functions • Date Functions • Session in PHP • Cookies in PHP • Hash Function • Mail Function • Database connection with MySQL |
- We make Sure that each topic must cover in depth.
- Practical Demostration of Each Topic.
- Test on Every Weekend
- Provide Notes so that Student do not need to write much.
- Live project at Course End.