PHP + MySQL Backend Develompent

Learn to create dynamic websites, web applications, and web services using PHP and MySQL

Course Objectives / Goals

PHP Language Syntax
You will learn how to use PHP to specify the logic of your application. You will also learn how to use the language to handle forms/user inputs, perform file-system operations, connect to databases and much more.
Architecture of Back-end Applications
You will learn the basic principles behind backend applications. You will learn concepts such as router, controller, data model, templating and how to use them in your PHP applications
API Development
An API (Application programming Interface) is a means to allow other applications to communicate with your server application securely. Eg. When a user sends a message on Whatsapp, the app sends it to the server application for processing through the server's API
MySQL
You will learn how to use MySQL database systems to power your apps; how to connect your app to a MySQL DB. You will also learn various SQL queries for fetching, saving andmanipulating data
Principles of Database Design
Designing a database involves determining the data that must be stored, how different data interrelate, and coming up with a structure for storing the data. The database designer must also optimize the database for efficient storage and retrieving of data

Requirements

Computer

No programming knowledge required

Internet connection if you don't have the offline kit

This course will teach you how to use PHP/MySQL to create web applications ranging from dynamic web pages to multi-tier applications with APIs (Application Programming Interface). Wewill be taking a hands-on approach by building 3 main projects as we learn:

  1. A PHP powered websit with custom CMS(Content Management System)
  2. The backend of a simple PHP forum with multiple users
  3. RESTful API for a mobile application

If the jargons make you think this course is for sophisticated developers alone, then you are mistaken. It is rather meant for absolute beginners with no programming background. You can still learn a lot even if you have significant programming experience

PHP & MySQL

PHP(PHP Hypertext Preprocessor) is a widely-used scripting/programming language that is suited for web development. It is very useful for creating both dynamic web pages and sophisticated web applications

MySQL is a popular RDBMS (Relational Database Management System). An RDBMS allows developers to use an english-like language called SQL to perform database operations such as storing, modifying, and deleting data. You don't need to care about where or how data is stored, retrieved, or how to ensure your data is corruption free. The RDBMS takes care of all that for you