Informatiklab

Course Fee

15000 TK 12000 TK

Lectures : 37


Language : Bangla

Skill Level : Beginner

Duration : 4 months

(2 hours a day, 2 days a week)
TAKE THIS COURSE

Teacher Info

Monjurul

Monjurul Islam

Entrepreneur

As an entrepreneur, freelancer, teacher and open source contributor, I have experienced in PHP more than 11 years in building small and enterprise web applications. Beside PHP, I also plays with Zend, Codeigniter, WordPress, Javascript and Java. I love to help, contribute and meet new people.

Learn PHP with MySql ( Beginner to Advanced )

  • Duration
    37 class - 74 Hours

  • Categories
    Development

  • 0.0 (0)

As a basic and advanced php programming course for both novice and advanced learner, our goal is to provide you such kinds of training that enable you to stay the compititative job market without facing any hazard .

It is a well-established fact now that for any company to flourish it needs to have its presence on the digital platform. While social media can be the right place to attract some attention but it does not establish a brand image of that company without a proper website and software. As a result of this businesses are hiring the web developer to meet their expectation thorough the word. So, development platform has become the buzzard of modern technology and PHP is an invaluable tool to help web developers build powerful websites and software. Despite how PHP powerful it is, few web developers know how to use PHP to its full potential, which is where our Ultimate PHP Training Bundle comes in.

*** Every lecture has Quiz and Assignment
*** Every course has Communication/Spoken English classes

What Will I Learn?

  • By the end of the course, you will have a solid knowledge of PHP
  • Learn how to use object, method, return data from a method
  • Discover database ( mysql ) in details
  • Learn how to develop project from scratch both oop & procedural coding
  • How to debug PHP code
  • Discover the basics & advanced feature of PHP
  • Runtime error handling using PHP exception handling mechanism
  • Learn how to do string manipulation

Software Taught

XAMPP, Netbeans, PhpStorm, Sublime Text

Curriculum

  • 37 Lectures
  • 74:00

LECTURE 1.1

PHP Basic:1

  • Development environment setup
  • Variable & Constants
  • PHP output printing

LECTURE 1.2

PHP Basic:2

  • Increment and Decrement operator
  • Magic with printf function
  • Discussion on Sprintf
  • Operation & Statement

LECTURE 1.3

PHP Basic:3

    Ternary operator & nested Ternary operator

  • Switch case & some examples
  • PHP operator precedence
  • Alternative syntax for Control statement

LECTURE 1.4

PHP Basic:4

  • Discussion on PHP loop
  • Some examples on Loop
  • Smart Coding Vs. Dump Coding
  • Multiple stepping on for loop
  • Continue, break, goto within loop

LECTURE 2.1

Function

  • Introduction to function
  • Function parameter & type hints
  • Parameter default value & optional value
  • Functions unlimited arguments & return type fixing

LECTURE 2.2

Function

  • Divide functions into smaller ones
  • Recursion & Recursive function
  • Fibonacci number print using recursive function
  • Variable scope in PHP
  • Argument checking for validation

LECTURE 3.1

Array

  • Introduction to array
  • Array manipulation
  • Associative array in details
  • Flesh out the document.Convert string to array and array to string

LECTURE 3.2

Array

  • Multidimental , nested array & sorting
  • Copy by value & copy by reference
  • Remove data from associative array
  • Array slicing & merging
  • Indexed , associative array sorting & searching

LECTURE 3.3

Array

  • Difference & intersection on associative & index array
  • Utility functions in array (map , merge, slice , filter etc. )
  • List function for accessing data into variable from array
  • Usage on range & stepping in function
  • Array shuffle & random number

LECTURE 4.1

String

  • How to write string in PHP & ASCII Code
  • Usage of Implode & Explode
  • String reversing
  • Breaking string into smaller and search
  • Breaking string into smaller and search
  • Convert new line to html cha

LECTURE 5.1

Session & Cookie

  • Introduction to Session & Cookie
  • Making session & working on session data
  • User authentication & hash using PHP
  • Basic role management
  • Session scope & storage
  • Details on Cookie

LECTURE 6.1

File

  • How to read data from file and write
  • Is_writeable & file_get_contents
  • Open file in different mode

LECTURE 7.1

Date & Time

  • PHP time, Microtime & Benchmarking
  • Date & time format & GMT
  • Date parsing & find difference

LECTURE 8.1

Error & Exception

  • Introduction on Error setting & reporting
  • Error log in a file
  • Custom & Fatal error handler
  • Backtracking
  • Custom Exception

LECTURE 9.1

MAILING

  • Text mail
  • Html mail
  • Mail with attachment
  • Smtp mail setting

LECTURE 10.1

Database

  • Sql SELECT Statement
  • Sql INSERT INTO Statement
  • Sql UPDATE Statement
  • Sql Delete Statement

LECTURE 10.2

Database

  • Relationship & Foreign key
  • Join , Inner , Left , Right, Join
  • Union & Union all
  • Phpmyadmin GUI

LECTURE 10.3

Database

  • Sub query in Select
  • Insert into with Sub query
  • sub query with update
  • Truncate table command
  • Wildcard operator
  • Database import & Export

LECTURE 10.4

Database

  • Alias for Column & Table
  • Aggregate Function
  • Group by statement
  • Having Clause
  • Create View
  • Insert data into view
  • Sql ucase , lcase , mid, length, round , now function

LECTURE 11.1

File System & Directory

  • Introduction on file system & directory
  • Directory & Folder making & deletion
  • Delete file & folder recursively

LECTURE 11.2

File System & Directory

  • File & Folder Permission
  • Viewing content by Directory Iterator
  • Pathinfo() & glob()
  • Copy file from one directory to another

LECTURE 13.1

OOP Foundation

  • Introduction to OOP
  • Class , Object, Method & Property
  • Magic Method

LECTURE 13.2

OOP Foundation

  • Public & Private method and Property
  • How to write a Real life Class
  • Parent and Child Scope

LECTURE 13.3

OOP Foundation

  • Introduction to Inheritance
  • Abstract Class & Method
  • Final keyword in Inheritance

LECTURE 13.4

OOP Foundation

  • Introduction to Interface
  • Constant
  • Countable Interface

LECTURE 13.5

OOP Foundation

  • Object Cloning
  • Object to Sting Conversion
  • Discussion on early & late bindings

LECTURE 13.6

OOP Foundation

  • __isset & __unset
  • __call & callStatic
  • Class file autolaoding

LECTURE 13.7

OOP Foundation

  • Introduction to Namespace
  • Details on Namespace
  • File arranging using namespace

LECTURE 13.8

OOP Foundation

  • OOP vs. Procedural coding
  • When use OOP and Procedural coding ?
  • Details on PHP.INI

LECTURE 14.1

Advanced OOP

  • Method calling from Class using Method Chaining
  • Inversion of Control & Dependency Injection
  • Introduction on solid Principle

LECTURE 14.2

Advanced OOP

  • Single responsibility Principe
  • Open Closed Principle
  • Liskov Substitution Principle

LECTURE 14.3

Advanced OOP

  • Interface Segregation Principle
  • Dependency Inversion Principle
  • OOP Concept

LECTURE 14.4

Advanced OOP

  • Introduction to traits
  • Importance of traits & usages of multiple traits
  • Method order & Precedence on Traits
  • Trait alias & Conflict resonation
  • Abstract, Static method & Properties

LECTURE 14.5

Advanced OOP

  • Introduction to Design Pattern
  • Singleton & Adaptor Pattern
  • Decorator & Factory pattern

LECTURE 14.6

Advanced OOP

  • Abstract Pattern
  • Facet Pattern
  • Bridge Pattern
  • Strategy Pattern

LECTURE 14.7

Advanced OOP

  • Introduction to Database
  • Details on Mysql table & Phpmyadmin
  • Create & Drop database
  • Table creation & in details

Career Support

After course completion, students can get jobs as:


  • PHP Programmer
  • Software Engineer
  • Web Developer