Online Training on PHP & My SQL @maxmunus technology , india
Online Training on PHP & My SQL @MaxMunus by Industry Leading Professionals
· 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.
Learning Objectives — In this module, we will learn about how to handle forms, validate forms, 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 — What is Form, Form Validation, Submit methods, Cookies, Anatomy of a cookie, Setting cookies, Accessing cookies, deleting cookies, What is sessions, starting a session, destroying a session, turn on auto session, session without cookies, file uploading, predefined variables,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 Concepts
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 Introduction and MySQL Basics
Learning Objectives — 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.
· Data Manipulation
Learning Objectives — In this module, we will see how to manipulate data with PHP. We can manipulate data through PHP script and command prompt. In this section, we will discuss both the ways of manipulations.
Topics — Insert Query using PHP script and Command Prompt, Select query using PHP script and command prompt, Update query using PHP script and command prompt, Delete query using PHP and command prompt, fetching using where clause,Annie’s Quizzes, LAB, Q & A and Quick Recap.
· Advanced Queries & SQL Injection
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.
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, Annie’s Quizzes, Q & A and Quick Recap.
· Backup & Recovery Methods
Learning Objectives — In this module, we see how to backup databases. Then we will see how to recovery database.
Topics — Database Export, Export using OUTFILE, Export table as RAW Data, Exporting contents in SQL format, copying database to another host, Database Import, Import with LOAD DATA method, import with mysql import, handling quotes and special characters.
For more details kindly feel free to contact with us
Name :: Madhurima Bose
Email — email@example.com
Skype — madhu_maxmunus
Contact No. -+91–9066268701
Company Website –http://www.maxmunus.com