Courses Offered: SCJP SCWCD Design patterns EJB CORE JAVA AJAX Adv. Java XML STRUTS Web services SPRING HIBERNATE  

       

PHP with MY SQL Course Details
 

Subcribe and Access : 3000+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..

Batch Date: July 25 th @ 4PM

Faculty: Mr. Kanakaiah

Duration: 1 Month

Fee:  2000/- INR+ Reg Fee 100/-

Location : S.R Nagar, Hyderabad.

Venue :
DURGA SOFTWARE SOLUTIONS at S.R Nagar
Canara bank building 2nd floor,
near S. R Nagar Ploce Station,
Hyderabad-500038. 
Contact no: 97 03 08 96 96, 80 96 96 96 96.

Syllabus:

WEB technology’s PHP ,HTML ,MYSQL

1. Introduction to PHP  

  • PHP Script  
  • Operators
  • Arithmetic operators
  • Assignment operators
  • Comparison operators
  • Logical operators
  • Conditional and Looping
  • If and else statements
  • Switch Statements
  • While
  • Do..while
  • For
  • Foreach
  • Functions 
  • Passing Parameters to Functions
  • Functions within Functions
  • Pass by references
  • Scope of the Variables

Classes and Objects 

  • HTML Styles
  • Links
  • Images
  • Tables
  • Lists
  • HTML Forms
  • HTML Frames
  • CASCADING STYLE SHEETS(css)

JAVA SCRIPT

  • Introduction
  • Data Types
  • Variables
  • Operators
  • Control & Condition Statements
  • Arrays
  • Functions
  • Event Handlers
  • Form Validations             

Web servers-OVERVIEW
Application Development MVC MODEL

 MYSQL

  • RDBMS overview
  • Introduction to Mysql Database
  • What is a Database?
  • Why Use a Database?
  • Helpful Tool – phpMyAdmin.
  • Creating Your First Database
Mysql   localhost
  • What is a class
  • What is a objects
  • Extends
  • The Keyword Final  
  • abstract classes
  • Interfaces
  • Exceptions
  • Working with Forms
  • Creating Forms
  • Post and Get Operations
  • Creating Cookie
  • Advanced PHP Topics 
  • Require
  • Include
  • Constructor
  • Destructors
  • Patterns
  • Magic Methods

  HTML

  • Basic HTML

Text Formatting Tags

  • Database Creation
  • DDL
  • DML
  • DRL
  • Mysql data types
  • MySQL Tables
  • Create Table MySQL
  • PRIMARY KEY
  • Foreign key
  • MySQL Insert
  • Inserting Data Into Your Table

MySQL Query

  • Using MySQL SELECT & FROM
  • Usage Query WHERE With Wildcard
  • Sorting a MySQL Query - ORDER BY
  • Like operator in mysql
  • Update
  • Delete
  • MySQL GROUP BY - Aggregate Functions
  • COUNT
  • SUM
  • AVG
  • MIN
  • MAX
  • MySQL – Formats
  • Time – Formats
  • Index on tables
  • MySQL Join Table Setup
  • Views
  • Cursors
  • Functions
  • Mysql stored procedures
  • Triggers
PHP with MYSQL