Mastering Website Development with Advanced PHP,MYSQL and Framework
Course Duration: 120 Hours (40 Classes)
Course Fee: 25,000 Taka
Course Overview
Introduction, Development Environment Setup for HTML & CSS
- Why Website Development
- Overview of this Course
- Why PHP-MySQL?
- IDE and Tools
- Installing Dreamweaver CS3
- Your First Basic HTML Page
Development Environment for PHP
- Static vs. Dynamic Web Sites
- Dynamic Content from Databases
- Developing Dynamic Internet Applications
- Client-Side Scripting vs. Server-Side Scripting
- Overview of PHP Advantages and Capabilities
- PHP vs. ASP
Part 1: HTML and CSS
HTML Basics
- What is HTML
- HTML Tags (Head, Body and Title)
- HTML Headings
- HTML Paragraphs
- HTML Links
- HTML Images
- HTML Line Breaks
- HTML TABLE
- HTML Lists
- HTML Unordered Lists
- HTML Ordered Lists
- HTML Definition Lists
- HTML Forms and Input
- HTML Marquee Tag
CSS Basics
- 1. Database Design
- 2. Content Design
- 3. Simple UI Design
- 4. Login Panel
- 5. Admin Panel Functionality
- 6. Student Panel Functionality
- 7. View Student’s Information
- CSS Introduction
- CSS Syntax
- CSS Id & Class
- CSS How To
- Styling Backgrounds
- Styling Text
- Styling Fonts
- Styling Links
- Styling Lists
- Styling Tables
- CSS Box Model
- CSS Border
- CSS Outline
- CSS Margin and
- CSS Padding
Project 1: Template Design with HTML and CSS
- How to start Template Design
- Horizontal and Vertical Div Concept
- Basic Layout Design
- Box Coloring to understand the divs
- Formatting and Styles
Part 2: Bootstrap
Overview, Getting Started
- What is bootstrap
- CDN for Bootstrap and jQuery
- Bootstrap Theory: Is Bootstrap For All Devices?
- How Bootstrap Works
- Download and Install Bootstrap and jQuery manuaaly
Working with the Bootstrap Grid
- Understanding Bootstrap containers
- Working with rows
- Creating columns
- Using multiple column classes
- Resetting columns
- Offsetting columns
- Nesting columns
Exploring Basic Bootstrap CSS Classes
- Styling headings and body copy
- Analyzing inline text styles
- Using blockquotes
- Working with list styles
- Styling code
Adding Other CSS Styles
- Working with Bootstrap buttons
- Exploring table styles
- Adding image classes
- Understanding Bootstrap helper classes
- Using responsive utilities
Styling Forms
- Creating a basic form
- Formatting radio and checkbox controls
- Using inline forms
- Styling a horizontal form
- Using validation styles
- Using input groups
- Using icons
Navigation Components
- Creating a dropdown
- Using button groups
- Understanding the Bootstrap nav component
- Adding content to the navbar
- Collapsing your navigation
- Using breadcrumbs and pagination styles
Media Components
- Creating a Jumbotron and page header
- working with labels and badges
- Using the thumbnail style
- Adding media styles
Content Containers
- Styling list groups
- Working with panels
- Using wells
Using JavaScript Components
- Creating a carousel
- Creating modals
- Controlling tabs with JavaScript
Project 2: Landing page design with Bootstrap (PortFolio Project)
- Creating Navigation and Home Area
- Creating My Work Area
- Creating About Area
- Creating Contact Area
Part 3: Overview of PHP, Development Environment for PHP Overview
- Static vs. Dynamic Web Sites
- Dynamic Content from Databases
- Developing Dynamic Internet Applications
- Client-Side Scripting vs. Server-Side Scripting
- Overview of PHP Advantages and Capabilities
- PHP vs. ASP
Development Environment
- Softwares, IDE and Tools
- XAMMP installation in windows
- Installing and Configuring PHP
- Testing the Environment
PHP Language Structure and Programming Basics
- Basic PHP Syntax
- PHP Tags
- PHP Statements and Whitespace
- Comments
- Hello World!
Part 4: PHP Programming
- Variables (Global, Local)
- Data Types
- Operators and Expressions
- Constants
- Control Statements (Loops, IF ELSE, While, Switch)
- Working With Functions
- PHP build in Functions
- Working with Arrays
- String Manipulation
- Working with Objects
- Working with Date Time
- Include
- Parameter Passing
Part 5: Advance PHP
- Working with Forms
- Creating a Simple Input Form
- POST and GET Method
- Accessing Form Input with User-Defined Arrays
- Combining HTML and PHP Code on a Single Page
- Using Hidden Fields to Save State Redirecting the User
- Sending Mail on Form Submission
- Creating the Form
- Simple Login Form
- Basic Registration Form
- Form Validation (Normal)
- Working with Files, Images
- Single File Uploads, Multiple File Uploads
- Cookies and Session
Part 6: MySQL Database Programming with PHP
- MySQL Basics and Database Programming
- Understanding Database Design Process
- Importance of Good Database Design
- Types of Table Relationships
- Understanding Normalization
- Following the Design Process
- Learning Basic SQL Commands
- Creating a Connection with the MySQL Server
- Using the INSERT Command
- Using the SELECT Command
- Using WHERE in Your Queries
- Selecting from Multiple Tables
- Using the UPDATE Command to Modify Records
- Using the REPLACE Command
- Using the DELETE Command
- Frequently Used String Functions in MySQL
- Using Date and Time Functions in MySQL
- Min, Max, Add, Subtract
Project 3: Insert, Update, Delete Form
Project 4: Creating a Simple Discussion Forum
Project 5: Creating an Online Address Book
Part 7: jQuery and others
jQuery Plugins
- Dialog
- Accordion
- Sortable
- Autocomplete
- Datepicker
- Progress bar
- Tabs
jQuery Image Galleries (How to Use)
Ajax Form Validation Examples
Pagination Examples
Part 8: Working with CMS (WordPress)
- About WordPress
- Installing WordPress
- WordPress Themes
- Managing Post and Pages
- Working with Menus
- Working with Media Files
- How to install plugins
- WordPress Settings
- The Appearance Tab
- Host your WordPress Site
Project 6: Create an ecommerce website (using wordpress)
Project 7: Student Management System
Project Description: You need to design and create a website that will show you the list of students in the
front page. You can see student’s list information category wise. You also need to create an admin panel for
inserting student’s information. There will be two types of user: admin and user. Admin can change all users’
information and a specific user can change only his information.
What you need to do:
Part 9: PHP Framework – Laravel
Overview,Getting Started
What is laravel
Use of laravel
Installing Laravel
Routing
Basics
Route Parameters
Views
Basics Of Blade
Passing Data To Views
Conditionals And Loops
Extending Views
HTML Builder
Forms
GET And POST Requests
Form Builder
Database
Connecting To The DB
Raw SQL
Query Builder
Project 8 – Fundraising Website
Setting Up The DB
Adding Projects
MVC And REST Theory
MVC
REST
Controllers
Basic Controllers
RESTful Controllers
Resource Controllers
project 9: Sending mail with PHP
Create a contact Form
ccHow send message in email
Advanced Database
Migrations
Schema Builder
Seeding
Models
Eloquent Part 1
Eloquent Part 2
Relationships
Miscellaneous
Filters
Validation
The Artisan File And 404s
- Overview,Getting Started
- What is laravel
- Use of laravel
- Installing Laravel
- Basics
- Route Parameters
- Basics Of Blade
- Passing Data To Views
- Conditionals And Loops
- Extending Views
- HTML Builder
- GET And POST Requests
- Form Builder
- Connecting To The DB
- Raw SQL
- Query Builder
- Setting Up The DB
- Adding Projects
- MVC
- REST
- Basic Controllers
- RESTful Controllers
- Resource Controllers
- Create a contact Form
ccHow send message in email
- Migrations
- Schema Builder
- Seeding
- Models
- Eloquent Part 1
- Eloquent Part 2
- Relationships
- Filters
- Validation
- The Artisan File And 404s
Project 10 – Registration And Login System
- Setting Up The Resource
- Registration
- Profile Pages
- Allowing Updates And Deletes
- Handling Authentication
Part 10: cPanel Basics and Uploading your site to Live Server
- What is cPanel
- Installing Filezilla
- Uploading your site to live server
- Exporting your database from local site
- Importing your database to live server
- cPanel Functionality
Final Project: Create an Ecommerce Website (Using Framework)
Project Description: You need to design and create a website that will show you the list of categorized Products in the
front page. You can see Product’s list information category wise. You also need to create an admin panel for
inserting Product’s information. There will be two types of user: admin and user. Admin can change all product’s
information.
What you need to do:
1. Database Design
2. Content Design
3. UI Design with Bootstrap
4. Login Panel
5. Admin Panel Functionality
6. User Panel Functionality
7. View product’s Information
eBooks
We will provide you 100+ web development eBooks and we will suggest you only 3 or 4 of those to follow.
Video Tutorials
We will provide you the following video tutorials to be a Master in Web Development. All of these are paid tutorials. If you directly buy these from their website, it will cost at least 500 dollar (appx 40, 000 taka). We will provide you these tutorials after finishing the course at free of cost.
1. HTML Essential Training 2012 (lynda)
2. CSS For Developers (lynda)
3. PHP with MySQL essential Training (lynda)
4. PHP Training Videos (DevelopPHP)
5. Photoshop for web Developers (lynda)
6. WordPress Essential Training (lynda)
7. WordPress Template Design (lynda)
8. Joomla Essential Training (lynda)
9. Javascript Essential Training (lynda- on request)