Best Php with MySql Programming Course

Php With MySql Course Content

We at Aonlinetraining offer interactive online courses (e-learning) for Php With MySql.

Learn Php With MySql Online, interactive training program beginining right from the basics of coding. Book a Free Demo Class Now

Students for Php With MySql requires 30 hours to Study / Complete the course


Php With MySql Course Content

PHP
MySql

Php Module 1: PHP With MySQl Module1: Working with PHP

  • Getting Started with PHP-Variables

Php Module 2: Assigning Simple Variables Within a Script

  • Delimiting strings
  • Assigning arrays within a script
  • Assigning two-dimensional arrays in a script

Php Module 3: Accessing Variables Passed from the Browser

  • HTML forms variables
  • Passing arrays
  • Cookies
  • Sessions

Php Module 4: Testing Variables

  • isset()
  • empty()
  • is_null()
  • is_int()
  • is_double()
  • is_string()
  • is_array()
  • is_bool()
  • is_object()
  • is_resource()
  • is_scalar()
  • gettype()

Php Module 5: Changing Variable Types

  • Variable Variables

Php Module 6: Control Structures

  • The if Statement
    • Determining true or false in PHP
    • Comparison operators
    • Logical operators
    • Complex if statement
    • if…else statements
    • if…elseif statements
  • switch…case
    • Loops
    • White…
    • do…while
    • for
    • foreach
    • continue and break

Php Module 7: PHP’s Built-in Functions

  • Function Basics
  • Arguments
  • Return values

Php Module 8: Function Documentation

  • Important PHP Functions
  • String handling functions

Php Module 9: Writing Organized and Readable Code

  • Indenting
  • Code blocks
  • Function calls
  • SQL statements

Php Module 10: Includes

  • Include() and Require()
  • Include_once() and Require_once()

Php Module 11: User-Defined Functions

  • Function basics
  • Returning values
  • Using a variable number of arguments
  • Variable scope

Php Module 12: Object-Oriented Programming

  • Classes, Continued
  • Object cloning
  • Destructors
  • Exceptions

MySql Module 1: Why use a Relational Database?

Blasted Anomalies

  • The update anomaly
  • The delete anomaly
  • The insert anomaly

MySql Module 2: Normalization

  • First normal form
  • Second normal form
  • Third normal form

MySql Module 3: Types of Relationships

  • The one-to-many relationship
  • The one-to-one relationship
  • The many-to-many relationship

MySql Module 4: Advanced Database Concepts

  • Referential integrity
  • Transactions
  • Stored procedures

MySql Module 5: The Structured query Language for Creating and Altering Tables

Essential Definitions

  • Null Values
  • Indexes

MySql Module 6: The create database Statement

MySql Module 7: The use database Statement

MySql Module 8: The create table Statement

MySql Module 9: Column Types

  • String column types
  • Numeric column types
  • Date and time types

MySql Module 10: Creating Indexes

MySql Module 11: Table Types

  • MyISAM InnoDB Tables
  • Berkeley DB
  • Heap

MySql Module 12: The alter table Statement

  • Changing a table name
  • Adding columns
  • Dropping columns
  • Adding indexes
  • Dropping indexes
  • Changing column definitions

MySql Module 13: Using the show Command

  • show databases
  • show tables
  • show columns
  • show index
  • show table status
  • show create table

MySql Module 14: GUI Tools for Manipulating MySQL Tables and Data

  • Using phpMyAdmin

MySql Module 15: The Structured Query Language for Inserting, Editing, and Selecting Data

  • The insert Statement
  • The update Statement
  • The delete Statement
  • The replace Statement

MySql Module 16: The Basic select Statement

  • The Where clause
  • order by
  • limit
  • group by and aggregate functions

MySql Module 17: Joining Tables

  • The two-table join (equi-join)
  • The multi-table join
  • The outer join
  • The self join
  • Unions
  • Correlated subqueries