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, Annie’s Quizzes, LAB, Q & A and Quick Recap.

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, POSIX regular expressions, predefined character ranges, Regexp POSIX functions, PERL style regular expressions, Regexp PERL compatible functions, Date and time functions,Built-in functions, file inclusion, file manipulations, exception handling, bugs debugging, Annie’s Quizzes, LAB, Q & A and Quick Recap.

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, Annie’s Quizzes, LAB, Q & A and Quick Recap.

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 Annie’s Quizzes, LAB, Q & A and Quick Recap.

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, Annie’s Quizzes, Q & A,Quick Recap.

MVC Infrastructure Basics & Introduction to CakePHP

Learning Objectives – In this module we will learn the MVC terminology, advantages of MVC. We will learn how to install and configure CakePHP on top of existing PHP apache web server we will also see CakePHP 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 CakePHP, CakePHP folder structure, File naming conventions, Important config file (core.php, database.php), Annie’s Quizzes, Q & A, Quick Recap.

CakePHP 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 CakePHP 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 layouts, Annie’s Quizzes, Q & A, Quick Recap.

Models and Database Interaction in CakePHP

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 CakePHP models, Change database dynamically using the definitions in database.php config file, Annie’s Quizzes, Q & A, Quick Recap.

Creating Dynamic Forms using CakePHP Html Helpers

Learning Objectives – In this module, we will learn about how to generate forms using CakePHP 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 CakePHP html helper, Form validation using Model validation definitions, Create, retrieve and delete cookies, Create, retrieve and delete session variables, File handling in CakePHP (create, delete, read files), CakePHP Global variables and their use, Annie’s Quizzes, Q & A, Quick Recap

Using MVC & CakePHP to develop a website

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

Topics –

Project 1: Create basic HTML registration form using CakePHP helpers. Post data to database and send an email

Project 2: The main aim of the project is to develop an online website, which will cover details about institutes, courses and student information using CakePHP

1. Create a basic layout for the website.

2. Add/Edit/View/Delete institute details

3. Add/Edit/View/Delete course details

4. Add/Edit/View/Delete student information

What is the eligibility criterion to enroll in our courses?

Our courses can be pursued by individuals from multiple educational i.e. from begineers & professional backgrounds both can pursue the program. This course is suitable for those who already have understanding of Web, HTML and MySQL.

Can you share more course details like duration of session and the class schedules? Could you also share details on the mode of instruction-is it virtual or classroom training?

Our program has been specifically designed for Web Developers who wants to become working professionals and is available over weekends in regular mode or in weekened only . Each session is of 2 to 3 hours each. The detail course structure is available in curriculum. We provide online training program which is available worldwide.

In case of online training, is it pre recorded?

The training is live in nature and generally we put maximum 6 candidates on each class. We provide live based online trainining and We provide pre- recorded video file of your class. It is extremely important for us that all the professionals receive real time training for better learning & development.

Is it certified? / Do you provide certifications?

Yes. There is an evaluation process one has to undergo to get PHP & MYSQL MVC Framework Certification. The certification is well recognized in the industry and accepted all over. The program is in fact a result of rigorous industry feedback.

Why BSAI Academy? / Why should I enroll in your program?

It is industry oriented training. The program is a result of collaboration of subject matter experts & industry professionals. The program focuses on help you build your analytics & intelligence tools knowledge right from the basic conceptual parts to advanced application based hands on learning. The entire training is to make you working professional and includes case studies as well. It is an end to end solution.

What if I miss a session?

We provide recorded video recorded file of your class through which you can follow your missing class by watching videos.

What if I have doubts post a particular session?

We expect the tutees/students to write to us with the necessary doubts and schedule a session based on mutual availably. You can give us a CALL at +99841221510 OR email at info@bsaiacademy.com

What if I want to attend an entire session again?

You can. Revisiting a entire session is chargeable and depends up on the ongoing schedule and availability of our instructor/tutors.

What is the training methodology? Is it conceptual / hands on? Are there any projects / case studies?

The aim over here is to have industry ready professionals. The training program is a combination of conceptual understanding of the basics and hands on understanding of advanced concepts. The entire training is lab based and is delivered via projects & case studies from multiple business domains / verticals to give you an overall exposure in to the analytics industry.

Do I need to have an IT / Computer Science / Engineering background to do the program?

No. The training module is developed to help you learn right from the basics to advanced knowledge. Having an IT / Computer Science / Engineering background can be an added advantage to help your grasp faster. However Course is open to working professionals, recent graduates & students. Previous programming experience is not required for this Training.

Do I need to have an Economics / Mathematics / Statistics background to do the program?

No. The training module is developed to help you learn right from the basics to advanced knowledge. We start right from mean, media, mode etc. Having an Economics / Mathematics / Statistics background can be an added advantage to help your grasp faster. However the program doesn’t require you to have such knowledge.

Do I need to do all the modules? Is the program sufficient for me to pursue a career in to Analytics?

Yes. The program is a result of collaboration of subject matter experts & industry professionals based on industry feedback and research. A combination of all these modules is suggested for you to make a successful & highly rewarding career in this highly growth oriented sector. The program is more than sufficient to help you get that break and pursue your dream career.

Do you provide with the software?

No, this cannot be provided as we need to comply with the various corporate policies governing restricted use of all software. We are not authorized to distribute the same.There is provision for students to follow our tutor/instructor for enviroment setup. Our tutor/instructor will guide you on this.

Is flexi payment option available?

Yes, there is provision to pay in installments.

Are there any discounts?

At current there is no discount but however in future, we might bring Special Offer on the course . Visit our website frequently.

Is it feasible to attend a demo session before enrollment?

Unfortunately participation in a live class without enrollment is not possible. However, We can provide you the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in the class.

PHP & MySQL with MVC Frameworks

The entire training course content is in line with the certification program and helps you clear PHP Certification Exam with ease and get the best jobs in the top MNCs. As part of this training you will be working on real time projects and assignments that have immense implications in the real world industry scenario thus helping you fast track your career effortlessly.

At the end of this training program there will be a exam that helps you score better marks in certification exam.

For Certification

• Attend one complete batch
• Successful completion and evaluation of any one of the given projects
• Required 85% score from the exam