Course Content
-
Introduction
-
OOP in PHP
-
SQL
- Introduction to SQL
- Introduction to RDBMS
- Basic syntax
- SQL and NO-SQL databases
- introduction to mysql database and tools
- Creating database and table
- Select statement in SQL
- Select distinct statement in SQL
- Where Clause in SQL
- SQL And, OR, not operators
- Order by keyword in SQL
- Insert statement in SQL
- NULL values in SQL
- Update statement in SQL
- Delete statement in SQL
- IN operator in SQL
- SQL Alias
- Between operator in SQL
- Min,Max,Sum,Count,Avg in SQL
- Like in SQL
- Introduction to join and creating the second tables
- Inner Join in SQL
- left join in SQL
- Group by in SQL
- Having clause in SQL
- OOP in PHP introduction to subquery in SQL
- OOP in PHP creating the Databases
- OOP in PHP creating the tables in SQL
- OOP in PHP alter Columns in SQL
- OOP in PHP SQL constraints in SQL
- OOP in PHP conclusion of SQL
-
CodeIgniter 3]
- Codeignitre 3 introduction and course requirements
- Codeignitre downloading and installing
- Codeignitre folder Structure and application flow chart
- Codeignitre introduction to MVC(Model View Controller)
- Codeignitre working with controllers
- Codeignitre working with Views
- Codeignitre working with model
- Codeignitre URL Structure
- Codeignitre what are helpers and URL helper
- Codeignitre form helpers
- Codeignitre input class
- Codeignitre CAPTCHA helper and download helper
- Codeignitre HTML helper
- Codeignitre alternate PHP Syntax for View Files and PHP Style Guide
- Codeignitre String,Text,typography helpers
- Codeignitre inflector helper
- Codeignitre introduction to Libraries and Benchmarking class
- Codeignitre calendaring library
- Codeignitre shopping Cart library
- Codeignitre encrypt class and encryption library
- Codeignitre introduction to autoload.php
- Codeignitre upload library
- Codeignitre form validation
- Codeignitre session library
- Codeignitre introduction to database and ORM and setting database
- Codeignitre creating our first table adding some
- Codeignitre select(), from(), where() and get_where()
- Codeignitre select_min(),select_max(),select_avg(),select_sum()
- Codeignitre where_in(), like(), Or_like() in Query builder
- Codeignitre order_by() limit() offset()
- Codeignitre insert()
- Codeignitre update() and delete using Query Builder
- Codeignitre introduction To query helper and overview of database section
- Codeignitre create another table and joining theme
- Codeignitre chaining in query builder
- Codeignitre CRUD operation to insert
- Codeignitre showing all the records to the user_admin
- Codeignitre edit Record in CRUD section
- Codeignitre deleting students
- Codeignitre why we beak our HTML content into multiple views
- Codeignitre adding CSS and JS files and what about Plugins
- Codeignitre adding Bootstrap 4 inside our project
- Codeignitre creating Signup form