MySQL Training in Chennai

Best MySQL Training in Chennai

MySQL Training Syllabus

MySQL Basics

  • MySQL introduction
  • Creating a database
  • Creating a database table
  • CRUD in MySQL
  • Populating a MySQL database
  • Relational database tables
  • Populating the relational table

Using PHP to Access MySQL

  • Database APIs in PHP
  • Connecting to MySQL with PHP
  • Retrieving data from MySQL
  • Working with retrieved data
  • Creating records with PHP
  • Updating and deleting records with PHP
  • SQL injection
  • Escaping strings for MySQL
  • Introducing prepared statements

Building a Content Management System (CMS)

  • Blueprinting the application
  • Building the CMS database
  • Establishing your work area
  • Creating and styling the first page
  • Making page assets reusable
  • Connecting the application to the database

Using Site Navigation to Choose Content

  • Adding pages to the navigation subjects
  • Refactoring the navigation
  • Selecting pages from the navigation
  • Highlighting the current page
  • Moving the navigation to a function

Application CRUD

  • Finding a subject in the database
  • Refactoring the page selection
  • Creating a new subject form
  • Processing form values and adding subjects
  • Passing data in the session
  • Validating form values
  • Creating an edit subject form
  • Using single-page submission
  • Deleting a subject
  • Cleaning up
  • Assignment: Pages CRUD
  • Assignment results: Pages CRUD

Building the Public Area

  • The public appearance
  • Using a context for conditional code
  • Adding a default subject behaviour
  • The public content area
  • Protecting page visibility

Regulating Page Access

  • User authentication overview
  • Admin CRUD
  • Encrypting passwords
  • Salting passwords
  • Adding password encryption to CMS
  • New PHP password functions
  • Creating a login system
  • Checking for authorization
  • Creating a logout page

Advanced PHP Techniques

  • Using variable variables
  • Applying more array functions
  • Building dates and times: Epoch/Unix
  • Formatting dates and times: Strings and SQL
  • Setting server and request variables
  • Establishing global and static variable scope
  • Making a reference assignment
  • Using references as function arguments
  • Using references as function return values

Introduction to Object-Oriented Programming (OOP)

  • Introducing the concept and basics of OOP
  • Defining classes
  • Defining class methods
  • Instantiating a class
  • Referencing an instance
  • Defining class properties

OOP in Practice

  • Understanding class inheritance
  • Setting access modifiers
  • Using setters and getters
  • Working with the static modifier
  • Reviewing the scope resolution operator
  • Referencing the Parent class
  • Using constructors and destructors
  • Cloning objects
  • Comparing objects

Working with Files and Directories

  • File system basics
  • Understanding file permissions
  • Setting file permissions
  • PHP permissions
  • Accessing files
  • Writing to files
  • Deleting files
  • Moving the file pointer
  • Reading files
  • Examining file details
  • Working with directories
  • Viewing directory content

Sending Emails

  • Configuring PHP for email
  • Sending email with mail()
  • Using headers
  • Reviewing SMTP
  • Using PHPMailer

Call us today and see how
you can give a new life to your career.

Contact Now