Our PHP & MySQL training program provides the executive data to the students WHO want to get the certification in it both PHP & MySQL are the products that are wide employed in several applications and can be used freely.

PHP Course Syllabus

Introduction of Web & PHP

• What is PHP?
• The history of PHP
• Why choose PHP?
• Installation overview

First Steps

• Embedding PHP code on a page
• Outputting dynamic text
• The operational trail
• Inserting code comments

Exploring Data Types

• Variables
• Strings
• String functions
• Numbers part one: Integers
• Numbers part two: Floating points
• Arrays
• Associative arrays
• Array functions
• Booleans
• NULL and empty
• Type juggling and casting
• Constants

Control Structures: Logical Expressions

• If statements
• Else and elseif statements
• Logical operators
• Switch statements

Control Structures: Loops

• While loops
• For loops
• For each loops
• Continue
• Break
• Understanding array pointers

User-Defined Functions

• Defining functions
• Function arguments
• Returning values from a function
• Multiple return values
• Scope and global variables
• Setting default argument values

Debugging

• Common problems
• Warnings and errors
• Debugging and troubleshooting

Building Web Pages with PHP

• Links and URLs
• Using GET values
• Encoding GET values
• Encoding for HTML
• Including and requiring files
• Modifying headers
• Page redirection
• Output buffering

Working with Forms and Form Data

• Building forms
• Detecting form submissions
• Single-page form processing
• Validating form values
• Problems with validation logic
• Displaying validation errors
• Custom validation functions
• Single-page form with validations

Working with Cookies and Sessions

• Working with cookies
• Setting cookie values
• Reading cookie values
• Unsetting cookie values
• Working with sessions

MySQL Basics

• MySQL introduction
• Creating a database
• Creating a database table
• CRUD in MySQL
• Populating a MySQL database
• Relational database tables
• Populating the relational table

Using PHP to Access MySQL

• Database APIs in PHP
• Connecting to MySQL with PHP
• Retrieving data from MySQL
• Working with retrieved data
• Creating records with PHP
• Updating and deleting records with PHP
• SQL injection
• Escaping strings for MySQL
• Introducing prepared statements

Building a Content Management System (CMS)

• Blueprinting the application
• Building the CMS database
• Establishing your work area
• Creating and styling the first page
• Making page assets reusable
• Connecting the application to the database

Using Site Navigation to Choose Content

• Adding pages to the navigation subjects
• Refactoring the navigation
• Selecting pages from the navigation
• Highlighting the current page
• Moving the navigation to a function

Application CRUD

• Finding a subject in the database
• Refactoring the page selection
• Creating a new subject form
• Processing form values and adding subjects
• Passing data in the session
• Validating form values
• Creating an edit subject form
• Using single-page submission
• Deleting a subject
• Cleaning up
• Assignment: Pages CRUD
• Assignment results: Pages CRUD

Building the Public Area

• The public appearance
• Using a context for conditional code
• Adding a default subject behavior.
• The public content area
• Protecting page visibility

Regulating Page Access

• User authentication overview
• Admin CRUD
• Encrypting passwords
• Salting passwords
• Adding password encryption to CMS
• New PHP password functions
• Creating a login system
• Checking for authorization
• Creating a logout page

Advanced PHP Techniques

• Using variable variables
• Applying more array functions
• Building dates and times: Epoch/Unix
• Formatting dates and times: Strings and SQL
• Setting server and request variables
• Establishing global and static variable scope
• Making a reference assignment
• Using references as function arguments
• Using references as function return values

Introduction to Object-Oriented Programming (OOP)

• Introducing the concept and basics of OOP
• Defining classes
• Defining class methods
• Instantiating a class
• Referencing an instance
• Defining class properties

OOP in Practice

• Understanding class inheritance
• Setting access modifiers
• Using setters and getters
• Working with the static modifier
• Reviewing the scope resolution operator
• Referencing the Parent class
• Using constructors and destructors
• Cloning objects
• Comparing objects

Working with Files and Directories

• File system basics
• Understanding file permissions
• Setting file permissions
• PHP permissions
• Accessing files
• Writing to files
• Deleting files
• Moving the file pointer
• Reading files
• Examining file details
• Working with directories
• Viewing directory content

Sending Emails

• Configuring PHP for email
• Sending email with mail()
• Using headers
• Reviewing SMTP
• Using PHPMailer

For more details click here

Our PHP & MySQL training program provides the executive data to the students WHO want to get the certification in it both PHP & MySQL are the products that are wide employed in several applications and can be used freely.

• Some of the example of the famous sites using My SQL are Facebook and Digg.
• MySQL islight-weight, reliable and may connect with multi-Client Program.
• MySQL isassociate open supply information, and is totally 
  

MySQL Course Syllabus

Theory, Terminology and Concepts

• Client/Server Concepts
• Database and Database Objects

Data Definition using SQL

• Databases
• Data Types
• Tables
• Constraints and Indexes
• Views

Basic Data Manipulation using SQL

• Recurring SQL Constructs
• Adding data
• Modifying data
• Removing data
• Searching data

Advanced Data Manipulation using SQL

• Expressions
• Grouping and Aggregate Functions
• Joining Tables

Transactions

• Transaction Concepts
• SQL for working with Transaction

Import/Export

• Tools for Import/Export
• SQL for Import/Export

For more details click here

MAGENTO

Magento is open source and it is mostly used ecommerce application that was launched on March thirty one, 2008. it was developed by Varien (now Magento Inc) with facilitate from the programmers among the open supply community however is closely-held alone by Magento Inc. Exavion Technology provides Magento coaching in step with the present demand of IT trade.

It uses the Entity-attribute-value(EAV) information model to store information. Magento may be a terribly powerful and quick growing ecommerce script, created by Varien. it's associate degree ASCII text file platform which uses Zend PHP and MySQL databases. Magento offers nice flexibility through its standard design. Magento is totally scalable and includes a wide selection of management choices that its users appreciate.

Magento may be a feature-rich eCommerce platform designed on ASCII text file technology that gives on-line merchants with unprecedented flexibility and management over the planning, content and practicality of their eCommerce store. Magento's intuitive administration interface options powerful promoting.

Search engine improvement and catalog-management tools to present merchants the facility to make sites that are tailored to their distinctive business wants. Designed to be fully scalable and backed by Varien's support network, Magento offers corporations the last word eCommerce resolution.

1.Basics

• General OOP and MVC concepts
• Event-driven architecture
• Magento module-based architecture
• Magento directory structure/naming conventions/code pools/namespaces/module structure
• Configuration XML
• Factory and functional class groups
• Class overrides
• Event observer Page 6 v.021811
• Request Flow
• Application initialization
• Front controller
• URL rewrites
• Request routing
• Modules initialization
• Design and layout initialization
• Structure of block templates
• Flushing data (output)

2. Rendering

• Template structure
• Blocks
• Design layout SML schema, CMS content directives

3.Working with Database in Magneto

• Models resource and collections
• Magneto Object Relational Mapping
• Write, install and upgrade scripts using set up resources

4.Entity-Attribute-Value model

• Model concepts
• EAV entity
• Load and Save
• Attributes management

5.Admin HTML

• Common structure/architecture
• Form and Grid Widgets
• System configuration XML and configuration scope
• ACL (permissions)
• Enabling and configuring extensions

For more details click here

Behind each programing language, a correct framework carries lots of importance to steer to develop a sturdy and ascendible application. A wrong approach throughout the planning part might result to developing a faulty system. it's so a correct framework became greatly essential as some extent of thought once designing a project.

These days’ most of the web site uses a framework and therefore the one that gets highest acceptance is for its flexibility. CodeIgniter – one amongst the foremost wide used and accepted frameworks for server-side scripting was launched in 2006. AN ASCII text file framework, CodeIgniter has attained name from net developers worldwide.

It is imperative that the common eligibility to enter as an internet technologist of late is to own data in an exceedingly framework and so gaining correct data is extremely a lot of essential. employing a framework at its fullest will ease lots of programming task and makes the work a lot of economical and straightforward to handle. The skilled course on PHP CodeIgniter helps to know the usage and application of the framework.

Owing to the huge nature of the framework, the course can cowl from preliminary to the advanced level of its usage. Candidates having AN exposure on PHP can extremely like this course. The trade intimate concerned in conducting the course can facilitate a candidate gain a powerful foothold on the correct usage of the framework of its application in an exceedingly skilled circuit. Besides the theoretical sessions, the active expertise with CodeIgniter also will facilitate to know the myriad of options within the framework and therefore the reason of its success as a framework.

CodeIgniter

1.Starting CodeIgniter

• Overview & Installation
• Directory Structure and App architecture
• Configuring Code Igniter

2.Code Igniter & MVC

• Intro to MVC
• Routing in CI
• Controller in CI
• Views in CI
• Adding JS and CSS

3.Code Igniter & Database

• Working with Database
• Models in CI
• Server side Validation

4. Code Igniter Mini Project

• A basic CRUD Application

5. Libraries , Error & File Handling

• Helper Libraries & common Functions
• Error Handling
• File Handling

6. Sessions, Cookies & Email

• Session Management, Flashdata and Tempdata
• Cookie Management
• Email

7. Caching & Security

• Page Caching / Redirection
• Security (Concerns and Prevention Methods)

8. Code Igniter Advanced Project

• Make your own task management (to-do) application

For more details click here

Chapter 1: Marketing Introduction

• What is Marketing
• Difference in Marketing & Advertising
• Outbound & Inbound Marketing

Chapter 2: Digital Marketing Introduction

• What is Digital Marketing
• Difference between Digital & Offline Marketing
• Why Digital Marketing is now a Necessity
• Growth in Digital Marketing

Chapter 3: Introduction to SEO

• What is a Search Engine?
• How do Search Engines increase sales.
• Understanding SERP
• Search Engine Algorithm
• Understanding Panda, Penguin, Hummingbird & Mobile Update
• What is White Hat SEO
• What is Black Hat SEO
• What is Grey Hat SEO

Chapter 4: Keyword Research & Analysis

• Types of Keywords
• Keyword Analysis Tools
• Keyword Generation Tools
• Competition Analysis
• Finalising the Keywords

Chapter 5: Introduction to On-page Optimisation

• What is Onpage Optimisation
• Why Onpage Optimisation is Important
• Best Practices in Onpage
• SEO Tool setup on website
• HTML Tags
• Site Structure
• Meta Tags
• Header Tag, Title Tag  & Description Tag Optimisation

Chapter 6: OFF Page Optimisation

• Introduction to Offpage Optimisation
• Impact of offpage on SERP
• Search Engine Submission
• Directory Submission
• Article Submission
• Press Release Submission
• Social Bookmarking
• Classified Submissions
• Blog Commenting
• Q&A Submissions
• Follow v/s No Follow Links
• Social Media Links
• Backlink Analysis Tools
• Google Position Monitoring Tool

Chapter 7: Google Analytics

• Why Google Analytics is important
• Installing Analytics on our site
• Generating the tracking code
• Audience Reports
• Bounce Rate Monitoring
• Demographic Reports

Chapter 8 : Google Webmaster Tools

• Why Google Webmaster Tools
• How to Add a site to Google Webmaster Tools
• Site Verification Process
• Site Access to users
• Submitting XML Sitemaps
• Links to Website
• Internal Links
• Crawl Stats & Indexing Status
• Crawl Errors
• Removing URL’s from Google’s Index
• HTML Suggestions
• Google Page Speed Insights

Chapter 9: Introduction to Social Media

• What is Social Media
• What is Social Media Marketing
• What is Social Media Optimisation
• Advantages of Social Media
• How to Attract users on Social Media

Chapter 10: Facebook Marketing

• Why Facebook
• Ad Formats on Facebook
• Fan page Creation 
• Types of Fan pages
• Fan page Internal Targeting Setup
• Fan page Posting
• Scheduling Content
• Focusing on Engagement
• Fan page Insights
• Facebook Desktop Newsfeed Ads & Right Column Ads
• Facebook Mobile Ads
• Bidding Format
• Payment Formats
• Ad monitoring
• Use of Free Techniques
• Instagram Ads

Chapter 11: LinkedIn Marketing

• Why LinkedIn
• LinkedIn PPC Ads
• LinkedIn Company Page
• LinkedIn Groups
• LinkedIn Profile updation

Chapter 12: Twitter Marketing

• Why Twitter Ads
• Composing best tweet
• Use of Hash Tags
• Increasing the followers through Content Marketing Tools

Chapter 13:Email Marketing

• What is Email Marketing
• Types of Email Campaigns
• Use of Verified Data
• Data Acquisition Process
• How to hit the inbox
• Email Template Creation
• Email Tracking & Reporting

Chapter 14: Search Engine Marketing(SEM)

• Introduction to SEM
• Benefits of SEM
• SEM v/s SEO
• Introduction to Google Adwords
• Account Setup
• Adwords Interface
• Billing Setup
• Account Access Levels
• Adwords Terminology
• Structure of Adwords

Chapter 15: Campaigns Setup

• Types of Campaigns
• Search & Display
• Location Settings, Language Settings & Device Settings
• Bidding Strategy & Ad Scheduling
• Ad Rotation &  Frequency Capping

Chapter 16:Adgroups & Keywords Setup

• Adgroup Structure
• Types of Keywords
• Broad Match
• Exact Match
• Broad Match Modifier
• Phrase Match
• Negative Match
• Keyword Planner Tool
• Ad Preview Tool

Chapter 17: Understanding Adwords Bidding

• Adwords Auction
• What is Adrank
• What is Quality Score
• How is Quality Score assessed?

Chapter 18: Ad Formats & Guidelines

• Structure of Ad
• Types of Ad Positions
• Character limit
• Landing Page Quality
• Guidelines for Ad Creation
• Ad Extensions
• What are Ad Extensions
• Location
• Sitelinks
• Phone Number
• Reviews
• APP
• Call Extensions

Chapter 19: Display Ads

• Setting a Display Ad Campaign
• CPC v/s CPM Campaigns
• Types of Targeting
• Contextual Targeting & Audience Targeting
• Keyword Targeting
• Topic Targeting
• Placement Targeting
• Interest Targeting
• Demographic Targeting

Chapter 20: Additional Inputs

• How to get projects
• Freelancing process
• Service charges for all campaigns
• Assistance for Google adwords & Analytics exam

For more details click here