Laravel & MySql with API Training

Module 1:  Introduction of Laravel PHP Framework

• Installing Laravel
• Artisan CLI ( command-line interface )
• Laravel Directory Structure
• Configuring a new Laravel project

Module 2:  Setting up a sample project ' Hello World '

• Basic routing
• Call a controller method from a route
• Passing variables from controllers to views

Module 3:  Laravel Blade Template

• Template inheritance
• Master layout
• Extending the master layout
• Displaying variables
• Blade conditional statements
• Blade Loops
• Executing PHP functions in blade
• Displaying Your Views
• Creating and using a basic views
• Loading a view into another view/nested views
• Adding assets
• Integrating with Bootstrap

Module 4: Introduction to MYSQL

• What is Database?
• Understanding an RDBMS
• Understanding Tables, Record & Fields
• SQL Language

Module 5: Basic SQL Queries

• Create Database & Table
• Drop Database & Table
• Insert Record
• Select Record
• Deleting Record
• Modifying Record
• WHERE Clause

Module 6: Advanced SQL Queries

• Using Operators
• Sorting Records
• Eliminating Duplicates
• Grouping Records, Having Clause  
• Joining Tables
• Sub queries
• Using Table And Column Aliases

Module  7: Migrations

• Introduction
• Requirements for running migrations
• Artisan migration command
• Migration structure
• How to create a table using a migration
• Laravel migration rollback
• Database seeding
• Migrations for our project database

Module 8: Using Forms and Gathering Input

• Creating contact us form
• Validating user input
• Sending email
• Creating a file uploader
• Validating a file uploader
• Creating a custom error message

Module 9: Creating a registration & user login form

• Create user register and login system
• Authenticating Your Application
• Adding Custom Fields to Registration Form
• Creating user profile page

Module 10: Using Controllers and Routes for URLs and APIs

• Introduction
• Creating a basic controller
• Creating a route using a closure
• Making the controller Restful
• Using route groups
• Building a Restful API with routes

Module 11: Eloquent ORM ( Storing and Using Data ) 

• Eloquent ORM Models
• Naming conventions
• Table name and primary keys
• Timestamps
• Eloquent ORM INSERT, READ , UPDATE , DELETE
• Using models in controllers
• Displaying data from models in views

Module 12: Creating and Using Composer Packages 

• Introduction
• Downloading and installing packages
• Using a basic Shopping Cart package in our project

Module 13: Using Ajax and jQuery 

• Introduction
• Getting data from another page
• Setting up a controller to return JSON data
• Creating an Jquery,AJAX comment system

Module 14: Security & Session 

• Using Security
• Sessions Effective

Module 15: Live Project

At the end of module all students get the expertise to develop an industry standard Laravel application. So, at this stage, we assign live project works to the students.