PHP & MYSQL APP DEVELOPEMENT

Course Details

Smart-IQ education is designed to train and place graduates who are IT job aspirents completed their graduation prior to 2017 and looking to cover the gap.We provide you real time project experience and place you into IT companies.

Most of the students who are unable to get placement through the campus recruitment come to Bangalore in search of their dream IT job.With little information on how the IT industry works,they complete the latest trending courses,complete the certification and try job in IT companies.Certification will not help to solve the real time issues that the companies are looking at.However most of them get rejected in the interviews due to lack of expericnce on working on real time projects.Eveunually they end up doing some irrelavent job not related to their specilozation to earn the livelihood and they loose theri carrier path.

Smart IQ training methods and customized courses promise 100% employability, not just course completion. Our training method prepares its candidates as per latest and advanced technology requirements. Once candidates are given a thorough understanding of theory and hands on sessions, they are asked to work on real time projects mentored by senior developers executing real time projects.

All these steps make sure that whatever candidates learn in the classroom gets converted in practical knowledge and stays with them forever. They are trained to work on real time environments so that when they join big and reputed companies they find it very easy to adapt themselves in the high pressure environment.

Apart from working on candidate’s technical skills, Smart IQ team also works on interview skills, communication skills, CV writing skills and presentation skills. Just before sending them for the interviews, candidates are further screened for technical & soft skills, improvements are suggested if any gaps are identified. These facilities make sure that candidates are not only technically competent, but are presentable as well and qualify the interview at the first go.

PHP is a server-side scripting language designed primarily for web development but also used as a general-purpose programming language. PHP originally stood for Personal Home Page, but it now stands for the recursive acronym PHP: Hypertext Preprocessor. PHP code may be embedded into HTML code, or it can be used in combination with various web template systems, web content management systems and web frameworks. PHP code is usually processed by a PHP interpreter implemented as a module in the web server or as a Common Gateway Interface (CGI) executable. The web server combines the results of the interpreted and executed PHP code, which may be any type of data, including images, with the generated web page. PHP code may also be executed with a command-line interface (CLI) and can be used to implement standalone graphical applications.

Course bjectives

Learn HTML,CSS, javascript, Ajax &Jquery.

Understand PHP fundamentals.

Learn Session handling using PHP.

Learn and build MVC Applications using Codeigniter.

Learn to build web-services using PHP.

Learn how to develop professional web applications using PHP & MySQL

Pre-requisites

There is no pre-requisite. However, having a programming background with HTML/SQL and some familiarity with Databases

PHP Basics and Conditional Logic

Learning Objectives - In this module, we will understand what PHP &MySQL is and why it is so popular. You will learn PHP basics, installation setup, data types, arrays and decision making statements.

Topics - PHP introduction, Environment setup in different platforms, Script syntax, How to declare variable and data types, Constants, Arrays, Strings, Web concepts, Decision making statements, loop types, operators ,arrays,session & cookies.

Functions and Error Handling

Learning Objectives - In this module, we will learn about the functions. Next, we will learn about how to send mails using PHP. In addition, we will learn regular expressions, predefined functions and its uses. We will also understand how to manipulate with system files, error handling and debugging.

Topics - What is Functions , Creating PHP functions, PHP functions with parameters, Argument by reference, setting default values for function parameters, dynamic function calls, PHP mails, how to send text mail, how to send html emails , how to send attachments with emails, regular expressions.

Object Oriented Programming

Learning Objectives - In this module, we will learn how to define classes, how to create object for the class and how to invoke methods and functions. Next, we will learn the object oriented functionalities like inheritance, method overriding, interfaces, constants, Access Specifiers and abstract classes.

Topics - What is Object Oriented Concepts, Defining classes, Creating Objects, Member functions, Constructor and Destructor, Inheritance, Function overriding, Access Specifiers- private, public and protected members, Interfaces, Constants, Abstract Classes, Static keyword, Final keyword, calling parent constructors.

MySQL Installation and Basics

Learning Objectives - In this Module, We will discuss what is database and database terminology. Then we will see how to install MySQL in our system. We will see how to connect with MySQL. Then we will discuss about syntax, database creation and create tables inside database and database manipulations like add, edit, and delete.

Topics - Database Introduction, MySQL installation on various platforms, MySQL connection, Database creation, Database Manipulations- Add, Edit, Retrieve and Delete. Table creation and table manipulations- Add Edit, Retrieve and Delete.

Advance Queries and Data Manipulation using PHP

Learning Objectives - In this module, we will learn advanced queries and SQL injection concepts. We will discuss about Like clause, how to sort values, how to fetch using joins, how to handle NULL values, Regular expressions, Transactions and alter command. We will also discuss Indexes of the table, temporary tables and clone tables. Then we will see duplicate tables and SQL Injection. We will learn how to retrieve and manipulate data using PHP.

Topics- LIKE clause, Sorting, Joins, Handling NULL Values, Regular Expressions, Transactions, ALTER Command, Indexes, Temporary Tables, Clone Tables, Database, Information, Sequences, Handling Duplicates, SQL Injections, Select, insert, update and delete using PHP script.

MVC Infrastructure Basics & Introduction to CodeigniterPHP

Learning Objectives - In this module we will learn the MVC terminology, advantages of MVC. We will learn how to install and configure CodeigniterPHP on top of existing PHP apache web server we will also see CodeigniterPHP folder structure and important configuration.

Topics - Introduction to MVC, What are Model-View-Controller, Why use framework in the project (conventional vs. MVC project), Installation of CodeigniterPHP, CodeigniterPHP folder structure, File naming conventions, Important config file (core.php, database.php),

Codeigniter PHP Controller, Views and Layout

Learning Objectives - In this module we will learn how to create controllers and views. We will learn how URLs are mapped to the controllers and views. We will learn how the controller and view interacts and exchanges data between them.

Topics - Application flow - How Controller and view interacts/ exchanges data, What are CodeigniterPHP helpers?, Most commonly used helpers like Form, HTML, Session, Cookie etc, Create a controller and how URLs mapped to controller and views, Create views and layout.

Models and Database Interaction in CodeigniterPHP

Learning Objectives - In this module we will learn models in detail. How to define models, use it for database access and manipulation. How to use basic SQL queries in models.

Topics - Models: What are models and how they interact with database?, Accessing and manipulating table data using find, save, update methods of the model, Joining tables, conditions, conditions other than =(LIKE, BETWEEN,), order by in CodeigniterPHP models, Change database dynamically using the definitions in database.php config file.

Creating Dynamic Forms using CodeigniterPHP Html Helpers

Learning Objectives - In this module, we will learn about how to generate forms using CodeigniterPHP html helper, validate forms using model definitions, difference between get and post methods, cookies , uses of cookies, how to set and retrieve cookies, what is sessions, how to start and destroy sessions, automatically start sessions and use sessions without cookies, file uploading and predefined variables.

Topics - Introduction to basic html form, get, post methods, Generate form elements like input boxes, dropdowns, radio buttons, and links using CodeigniterPHP html helper, Form validation using Model validation definitions, Create, retrieve and delete cookies, Create, retrieve and delete session variables, File handling in CodeigniterPHP (create, delete, read files), CodeigniterPHP Global variables and their use.

Using MVC & CodeigniterPHP to develop a website

Learning Objectives - In this module we will see some other frameworks available in PHP like Zend, Cake, Laravel. We will see the comparison between the frameworks. We will also discuss the project details.

Once you are successfully through the projects (Reviewed by a Codefrux expert), you will be awarded with Codefrux’s Php training certificate. This certification has industry recognition and we are the preferred training partner for many MNCs

Small sample projects will be provided or the students can work on their own ideas

FAQ

For your practical work, we will help you setup XAMPP server in your System. This will be a local access for you. The required installation guide will be given guide to you in course period.
Yes we do for that you have to drop down to our company and additional details shall be discussed here.
This is a simple scripting language and thus there is no need for any knowledge in Java. And if you have basic knowledge about HTML CSS and JAVASCRIPTS it add on to your fast learning.
You can pay by Credit Card, Debit Card or NetBanking from all the leading banks. We also have Installation options available.
You can give us a CALL at +91 8065639331/+91-80-41714862/63 (US Tollfree Number) OR email at contact@codefruxtechnology.com.