GnuGroup India

Course: PHP/MySQL 1 : Introduction to Database Programming.

Duration : 40Hrs

Technical Requirements: As long as you have a web browser and internet connection, you can take this course from anywhere in the world.

Software: The course provided for you will contain all your lessons, projects, quizzes, account files, editors, and programming tools necessary to build your skills from beginning to end, even beyond coursework. In addition, you'll be provided with a MySQL account that can be accessed through the iway or, if you prefer, any normal SSH program. No other software is needed.

Instructor: You will have one instructor throughout the course who will evaluate your projects and quizzes, hand them back for improvement when necessary, and coach you throughout your skills advancement.

Book: All required course materials and software are included online within the Learning iway Within a week of enrolling, you'll receive the free book Learning Mysql.

Certificates: Completion of this course counts toward the PHP/Mysql Applications Programming Certificate.

iway: Life long account on the iway, where you can download reference material and ebooks for life.
One Domain, 1GB web space, 2 Email id's @ your domains free as per policy.

Fees: Rs 8000/-

Prerequisites: HTML and CSS and Basic PHP, or equivalent skills in HTML and PHP. This course is meant for the beginning or intermediate programmer.

Topics: Creating Databases and Tables, Inserting Information, Retrieving Information, Searching, Summarizing, Application Development using PHP, etc.

Syllabus:

• -- Introduction

  • How to Learn using 100% practical Course

  • Understanding the iway

  • MySQL Syntax

  • Databases and Permissions

  • The Command Line

   

• -- Creating Tables

  • Creating and Checking Tables

  • Inserting Values into Tables

  • Retrieving Data from Tables

   

• -- Searching Through Tables

  • Exploring the "where" Keyword

  • The "like" Selector

  • Updating and Deleting Data

   

• -- Managing Tables

  • Altering Tables

  • Renaming Tables

  • Deleting Tables

   

• -- Managing Table Entries

  • Optimizing with Indexes and Keys

  • Auto_increment and Primary Keys

   

• -- Relational Databases

  • What is a Relational Database?

  • Inner Joins

  • Outer Joins

  • Aliases

   

• -- Managing Query Results

  • Group By

  • Preventing Duplicate Results

  • Searching and Counting Within Groups

  • Renaming Results

  • Ordering Results

  • Limiting Results

   

• -- Database Programming with PHP

  • The PHP/MySQL Relationship

  • Connecting to a Database in PHP

  • Executing SQL Commands

  • Delimiting Queries

   

• -- Project Address/Address Book, Part 1

  • Project Description

  • Table Layout

  • Table Creation

   

• -- Project Address/Address Book, Part 2

  • Starting with the HTML Form

  • Storing the Data into SQL through PHP

  • Breaking Down addentry.php

   

• -- Project Address/Address Book, Part 3

  • Construction of viewbook.php

   

• -- Advanced SQL Syntax, Part 1

  • Date and Time Functions

   

• -- Advanced SQL Syntax, Part 2

  • Math Functions

   

• -- Advanced SQL Syntax, Part 3

  • String and Character Functions

   

• Live project from the client