PHP-MySQL Training

  • PHP Mysql

    Smiley face

    SQL SERVER Generically, any database management system (DBMS) that can respond to queries from client machines formatted in the SQL language. When capitalized, the term generally refers to either of two database management products from Sybase and Microsoft. Both companies offer client-server DBMS products called SQL Server.
    SQL Server is a Microsoft product used to manage and store information. Technically, SQL Server is a “relational database management system” (RDMS). Broken apart, this term means two things. First, that data stored inside SQL Server will be housed in a “relational database”, and second, that SQL Server is an entire “management system”, not just a database. SQL itself stands for Structured Query Language. This is the language used to manage and administer the database server.

  • Course Content

    Duration : 2 Months | Classes: Mon-Fri, 1 Hr/day

    • Module 1: PHP Programming Concepts

      • Basic PHP
      • Introduction to PHP and MySQL.
      • Setup of PHP Environment (Xampp).
      • PHP.INI Configuration.
      • Directives in PHP.ini.
      • Error Types in PHP.
      • PHP Syntax.
      • Data Types.
      • PHP Variables.
      • Variable Scopes.
      • Super Globals.
      • $_GET.
      • $_POST.
      • $_REQUEST.
      • $_FILES.
      • $_SESSION.
      • $_COOKIES.
      • $_SERVER.
      • Operators in PHP.
      • Conditional Statements.
      • Loops.
      • Advanced PHP
      • What is Function?.
      • Creating Userdefined functions.
      • Function Libraries.
      • General, Include, Header & Predefine Functions.
      • String, Hash & Array Functions.
      • File Upload Function.
      • Mail Function (Text / HTML Mail).
      • Date Time Functions.
      • Session Functions.
      • Cookie Functions.
      • PEAR Package.
      • Object Oriented PHP.
      • What is OOP?
      • Class and Objects.
      • Properties, Constants & Methods.
      • Constructors and Destructors.
      • Property Scopes & Method Scopes.
      • Inheritance.
      • Abstract Class.
      • Example of OOP.
    • Module 2 : MySQL & PHPmyAdmin

      • Introduction to PHP & DBMS
      • Introduction to DBMS & RDBMS.
      • E-R Database Model.
      • Tables, Records, and Fields.
      • MySQL Command-Line.
      • PHP MyAdmin.
      • Creating Databases, Fields & Tables.
      • Database Engines.
      • Data types in MySQL.
      • Primary / Foreign & Unique Keys.
      • Insert, Delete, Update & View Records.
      • Drop Database / Tables.
      • Backup / Restore.
      • Connecting to Live Server.
      • SQL Concepts
      • Basics of SQL & SQL Syntax.
      • CRUD Operations & Insert Command.
      • Retrieving data from Database.
      • Retrieving data with specific criteria.
      • Retrieving data from multiple tables (JOINS).
      • Retrieving data in specific order.
      • Grouping of data.
      • Updating & Deleting records.
      • Alter table structure.
      • Summary & Sub Queries.
      • Dropping tables and database.
      • Integration of PHP with MySQL
      • PHP MySQL Integration.
      • MySQL Functions.
      • Creating a database connection.
      • Selecting the DB.
      • Inserting data in database.
      • Inserting data with a File.
      • Retrieving all records.
      • Retrieving specific record.
      • Retrieving data with pagination.
      • Retrieving data in specific order.
      • Searching the records.
      • Editing Records.
      • Deleting the records.
      • PHP with Ajax.
      • XMLHttpRequest Object.
      • Ajax Methods and Properties.
      • Ajax Login.
      • Retrieving Data with Ajax.

    Unique Features

    • Real Time Training with experienced, qualified and friendly trainers
    • Job Oriented training will help you in companies.
    • Free PD Class & Placement Offer for various courses.
    • Fully WiFi enabled Campus and Class Rooms.
    • Weekend Batch Facility for working persons.
  • Scope and Opportunities

    Finding a job in the computer field is a good decision. Computing is a field that will always be in demand and it is a field that you can continue to grow and move up inside your company. There are so many different positions you can find in the Office administration and Management. Careers in Office/MIS can range from entry level positions to executive level. After completing Advanced MS-Ofice Course various career option for the candidates are below:
      • Computer Operator
      • Accounting Assistant
      • Office Assistant
      • Accounting Clerk
      • DEO
      • Junior MIS
      • MIS Executive
      • Backend Process
      • CCE in Back Office Process
      • Govt sector jobs