MySQL Web Development

by Calgary Learning Institute Claim Listing

PHP and MySQL The Web Development course is designed for professionals with basic knowledge of HTML and work experience in programming in a modern programming language who have not necessarily programmed for the web or used a relational database.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Calgary Learning Institute Logo

img Duration

Please Enquire

Course Details

PHP and MySQL The Web Development course is designed for professionals with basic knowledge of HTML and work experience in programming in a modern programming language who have not necessarily programmed for the web or used a relational database.

The course trains you on the topics of web development such as using arrays, storing and retrieving data, object-oriented PHP, advanced MySQL administration and programming, web applications, internationalization and localization, and many more.

 

Lesson 1: Introduction

  • Why You Should Read This Book

  • What You Will Learn from This Book

  • What Is PHP?

  • What Is MySQL?

  • Why Use PHP and MySQL?

  • Some of PHP's Strengths

  • Key Features of PHP 7

  • Some of MySQL's Strengths

  • What Is New in MySQL (8.x)?

  • How Is This Book Organized?

  • Finally

 

Lessons 2: PHP Crash Course

  • Before You Begin: Accessing PHP

  • Creating a Sample Application: Bob's Auto Parts

  • Embedding PHP in HTML

  • Adding Dynamic Content

  • Accessing Form Variables

  • Understanding Identifiers

  • Examining Variable Types

  • Declaring and Using Constants

  • Understanding Variable Scope

  • Using Operators

  • Working Out the Form Totals

  • Understanding Precedence and Associativity

  • Using Variable Handling Functions

  • Making Decisions with Conditionals

  • Repeating Actions Through Iteration

  • Breaking Out of a Control Structure or Script

  • Employing Alternative Control Structure Syntax

  • Using declare

  • Next

  • Programming Exercises

 

Lessons 3: Storing and Retrieving Data

  • Saving Data for Later

  • Storing and Retrieving Bob's Orders

  • Processing Files

  • Opening a File

  • Writing to a File

  • Closing a File

  • Reading from a File

  • Using Other File Functions

  • Locking Files

  • A Better Way: Databases

  • Further Reading

  • Next

  • Programming Exercises

 

Lesson 4: Using Arrays

  • What Is an Array?

  • Numerically Indexed Arrays

  • Arrays with Different Indices

  • Array Operators

  • Multidimensional Arrays

  • Sorting Arrays

  • Sorting Multidimensional Arrays

  • Reordering Arrays

  • Loading Arrays from Files

  • Performing Other Array Manipulations

  • Further Reading

  • Next

  • Programming Exercises

 

Lessons 5: String Manipulation and Regular Expressions

  • Creating a Sample Application: Smart Form Mail

  • Formatting Strings

  • Joining and Splitting Strings with String Functions

  • Comparing Strings

  • Matching and Replacing Substrings with String Functions

  • Introducing Regular Expressions

  • Finding Substrings with Regular Expressions

  • Replacing Substrings with Regular Expressions

  • Splitting Strings with Regular Expressions

  • Further Reading

  • Next

  • Programming Exercises

 

Lessons 6: Reusing Code and Writing Functions

  • The Advantages of Reusing Code

  • Using require() and include()

  • Using Functions in PHP

  • Defining Your Own Functions

  • Examining Basic Function Structure

  • Using Parameters

  • Understanding Scope

  • Passing by Reference Versus Passing by Value

  • Using the return Keyword

  • Implementing Recursion

  • Further Reading

  • Next

  • Programming Exercises

 

Lessons 7: Object-Oriented PHP

  • Understanding Object-Oriented Concepts

  • Creating Classes, Attributes, and Operations in PHP

  • Instantiating Classes

  • Using Class Attributes

  • Calling Class Operations

  • Controlling Access with private and public

  • Writing Accessor Functions

  • Implementing Inheritance in PHP

  • Using Traits

  • Designing Classes

  • Writing the Code for Your Class

  • Understanding Advanced Object-Oriented Functionality in PHP

  • Next

  • Programming Exercises

 

Lessons 8: Error and Exception Handling

  • Exception Handling Concepts

  • The Exception Class

  • User-Defined Exceptions

  • Exceptions in Bob's Auto Parts

  • Exceptions and PHP's Other Error Handling Mechanisms

  • Further Reading

  • Next

  • Programming Exercises

 

Lessons 9: Designing Your Web Database

  • Relational Database Concepts

  • Designing Your Web Database

  • Web Database Architecture

  • Further Reading

  • Next

 

Lessons 10: Creating Your Web Database

  • Using the MySQL Monitor

  • Logging In to MySQL

  • Creating Databases and Users

  • Setting Up Users and Privileges

  • Introducing MySQL's Privilege System

  • Setting Up a User for the Web

  • Using the Right Database

  • Creating Database Tables

  • Understanding MySQL Identifiers

  • Choosing Column Data Types

  • Further Reading

  • Next

  • Programming Exercises

 

Lessons 11: Working with Your MySQL Database

  • What Is SQL?

  • Inserting Data into the Database

  • Retrieving Data from the Database

  • Updating Records in the Database

  • Altering Tables After Creation

  • Deleting Records from the Database

  • Dropping Tables

  • Dropping a Whole Database

  • Further Reading

  • Next

  • Programming Exercises

 

Lessons 12: Accessing Your MySQL Database from the Web with PHP

  • How Web Database Architectures Work

  • Querying a Database from the Web

  • Putting New Information in the Database

  • Using Other PHP-Database Interfaces

  • Further Reading

  • Next

  • Programming Exercises

 

Lessons 13: Advanced MySQL Administration

  • Understanding the Privilege System in Detail

  • Making Your MySQL Database Secure

  • Getting More Information About Databases

  • Optimizing Your Database

  • Backing Up Your MySQL Database

  • Restoring Your MySQL Database

  • Implementing Replication

  • Further Reading

  • Next

  • Programming Exercises

 

Lessons 14: Advanced MySQL Programming

  • The LOAD DATA INFILE Statement

  • Storage Engines

  • Transactions

  • Foreign Keys

  • Stored Procedures

  • Triggers

  • Further Reading

  • Next

  • Programming Exercises

 

Lessons 15: Web Application Security Risks

  • Identifying the Threats We Face

  • Understanding Who We're Dealing With

  • Next

 

Lessons 16: Building a Secure Web Application

  • Strategies for Dealing with Security

  • Securing Your Code

  • Securing Your Web Server and PHP

  • Database Server Security

  • Protecting the Network

  • Computer and Operating System Security

  • Disaster Planning

  • Next

  • Programming Exercises

 

Lessons 17: Implementing Authentication Methods with PHP

  • Identifying Visitors

  • Implementing Access Control

  • Using Basic Authentication

  • Using Basic Authentication in PHP

  • Using Basic Authentication with Apache's .htaccess Files

  • Creating Your Own Custom Authentication

  • Further Reading

  • Next

  • Programming Exercises

 

Lessons 18: Interacting with the File System and the Server

  • Uploading Files

  • Using Directory Functions

  • Interacting with the File System

  • Using Program Execution Functions

  • Interacting with the Environment: getenv() and putenv()

  • Further Reading

  • Next

  • Programming Exercises

 

Lessons 19: Using Network and Protocol Functions

  • Examining Available Protocols

  • Sending and Reading Email

  • Using Data from Other Websites

  • Using Network Lookup Functions

  • Backing Up or Mirroring a File

  • Further Reading

  • Next

  • Programming Exercises

 

Lessons 20: Managing the Date and Time

  • Getting the Date and Time from PHP

  • Converting Between PHP and MySQL Date Formats

  • Calculating Dates in PHP

  • Calculating Dates in MySQL

  • Using Microseconds

  • Using the Calendar Functions

  • Further Reading

  • Next

  • Programming Exercises

 

Lessons 21: Internationalization and Localization

  • Localization Is More than Translation

  • Understanding Character Sets

  • Creating a Basic Localizable Page Structure

  • Using gettext() in an Internationalized Application

  • Further Reading

  • Next

  • Programming Exercises

 

Lesson 22: Generating Images

  • Setting Up Image Support in PHP

  • Understanding Image Formats

  • Creating Images

  • Using Automatically Generated Images in Other Pages

  • Using Text and Fonts to Create Images

  • Drawing Figures and Graphing Data

  • Using Other Image Functions

  • Next

  • Programming Exercises

 

Lesson 23: Using Session Control in PHP

  • What is session control?

  • Understanding Basic Session Functionality

  • Implementing Simple Sessions

  • Creating a Simple Session Example

  • Configuring Session Control

  • Implementing Authentication with Session Control

  • Next

  • Programming Exercises

 

Lesson 24: Integrating JavaScript and PHP

  • Understanding AJAX

  • A Brief Introduction to jQuery

  • Using jQuery in Web Applications

  • Using jQuery and AJAX with PHP

  • Further Reading

  • Next

  • Programming Exercises

 

Lesson 25: Other Useful Features

  • Evaluating Strings: eval()

  • Terminating Execution: die() and exit()

  • Serializing Variables and Objects

  • Getting Information About the PHP Environment

  • Temporarily Altering the Runtime Environment

  • Highlighting Source Code

  • Using PHP on the Command Line

  • Next

  • Programming Exercises

 

Lesson 26: Using PHP and MySQL for Large Projects

  • Applying Software Engineering to Web Development

  • Planning and Running a Web Application Project

  • Reusing Code

  • Writing Maintainable Code

  • Implementing Version Control

  • Choosing a Development Environment

  • Documenting Your Projects

  • Prototyping

  • Separating Logic and Content

  • Optimizing Code

  • Testing

  • Further Reading

  • Next

 

Lesson 27: Debugging and Logging

  • Programming Errors

  • Variable Debugging Aid

  • Error Reporting Levels

  • Altering the Error Reporting Settings

  • Triggering Your Own Errors

  • Logging Errors Gracefully

  • Logging Errors to a Log File

  • Next

 

Lesson 28: Building User Authentication and Personalization

  • Solution Components

  • Solution Overview

  • Implementing the Database

  • Implementing the Basic Site

  • Implementing User Authentication

  • Implementing Bookmark Storage and Retrieval

  • Implementing Recommendations

  • Considering Possible Extensions

 

Lessons 29: Building a Web-Based Email Service with Laravel Part I

  • Introducing Laravel

 

Lessons 30: Building a Web-Based Email Service with Laravel Part II

  • Building a Simple IMAP Client using Laravel

  • Pulling it All Together to Build a Web-based Email Client

  • Conclusion

 

Lessons 31: Social Media Integration Sharing and Authentication

  • Web Service Authentication with OAuth

  • Conclusion

 

Lessons 32: Building a Shopping Cart

  • Solution Components

  • Solution Overview

  • Implementing the Database

  • Implementing the Online Catalog

  • Implementing the Shopping Cart

  • Implementing Payment

  • Implementing an Administration Interface

  • Extending the Project

 

Lessons 33: Installing Apache, PHP, and MySQL

  • Installing Apache, PHP, and MySQL Under UNIX

  • Installing Apache, PHP, and MySQL for Windows and Mac OS X Using All-in-One Installation Packages

  • Installing PEAR

  • Installing PHP with Other Web Servers

  • Calgary Branch

    3025 12 St NE #130, Calgary

Check out more MySQL courses in Canada

Formation SETC Logo

PLSQL Training

Our training covers basic and advanced PLSQL, PLSQL programming, triggers, cursors, sequences, packages, stored procedures and functions, date and time management, string manipulation and more Again. 

by Formation SETC [Claim Listing ]
Le Wagon Logo

SQL

Learn how to manage large datasets and analyze real data using the standard data management language.

by Le Wagon [Claim Listing ]
NAIT (Northern Alberta Institute of Technology) Logo

SQL Introduction (CCTB111)

SQL is the standard language used to communicate with relational database management systems (RDBMS). Graduates of this course will manage data through SQL constructs such as CREATE Database, CREATE Table, CONSTRAINT, and INSERT statements.

by NAIT (Northern Alberta Institute of Technology) [Claim Listing ]
SETC Training Logo

SQL Server Training

The SQL Server courses at SETC Training Ottawa teach you how to install and configure SQL Server databases to offer enterprise-grade database services

by SETC Training [Claim Listing ]
Eliquo Training Logo

MySQL

MySQL is one of the simplest ways for you to store, manipulate and retrieve large amounts of different types of data. Let us show you the core aspects of the language including how to create a MySQL database, write SQL statements and integrate it with programming languages.

by Eliquo Training [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy