Back end development involves structures and tasks that the user does not see –– namely, servers, databases and data analysis.
Back end developers typically rely on PHP, Python, Ruby, Java and Node.js. They should also have a solid understanding of one or two other languages, as well as proficiency in using databases like SQL Server, Oracle and MySQL.
Compared to the front end, back end development requires more critical thinking in order to design systems that help the user interact with the webpage. Back end developers should know where data is stored, the security of storage, how to debug and test a website and how to add features without affecting functionality and scale.
– Setting up a local development environment (XAMPP, WAMP, or MAMP)
– Working with PhpMyAdmin
– Writing and executing your first PHP script
– Basic PHP syntax and variables
– Control structures: if, else, elseif, switch
– Loops: while, do-while, for, foreach
– Handling user input from HTML forms
– PHP superglobals: $_GET and $_POST
- Introduction to PHP functions
- Creating and using custom functions
- Working with PHP built-in functions
- PHP data types and operators
- Introduction to PHP arrays and array functions
- Handling form data validation and processing
- File handling in PHP: reading from and writing to files
- Managing user sessions and cookies
- Introduction to working with databases (MySQL)
- Connecting to a MySQL database using PHP
- Executing SQL queries with PHP
- Retrieving data from the database: SELECT queries
- Inserting, updating, and deleting data: INSERT, UPDATE, DELETE queries
- Basic security practices for PHP applications
- Error handling and debugging techniques in PHP
-Introduction to databases and database management systems
- Overview of MySQL and its features
- Installing MySQL server and client
- Getting started with MySQL Workbench
- Understanding relational databases and data modeling concepts
- Creating and managing databases in MySQL
- Creating tables and defining columns with different data types
- Modifying tables using ALTER statements
- Retrieving data from tables using SELECT statements
- Filtering data with WHERE clause
- Performing basic mathematical and string operations in queries
- Aggregating data using GROUP BY and aggregate functions (COUNT, SUM, AVG, etc.)
- Modifying data in tables using INSERT, UPDATE, and DELETE statements
- Optimizing queries using EXPLAIN and query optimization techniques
- Importing and exporting data using MySQL utilitie
- Creating user-defined functions and calling them in queries
- Introduction to database normalization and its importance
- Refactoring database schema for normalization
- Introduction to database indexing and its benefits
- Analyzing query execution plans and optimizing indexes
- Introduction to advanced topics in MySQL (replication, clustering, etc.)
- Integrating MySQL with other programming languages (PHP)
- Integrating MySQL with other programming languages (PHP)
And lots more
-Build a Standard Personal Portfolio
-Build Multiple Pages Company Website
-HR Management System
-Build an E-commerce website
-Build simple student management system
You can now learn from your Home or offices with our Instructor-Led live online, interactive training on ICT and computer skills. Live Online classes feature all the same benefits of live instructor interaction while saving on travel time and cost. You can also have your classes recorded, which you can watch again for revision. All online classes include practical hands-on – all you need is internet access
Enrol Now
