Description
About this Course
Become a backend web engineer and get your hands dirty with SQL & PHP - the core technologies of the dynamic web. PHP is used by 76% of all websites and that includes giants such as Facebook, Slack and Wordpress. From small eCommerce websites to comprehensive ERP systems, PHP is at the core of an open-source stack that powers modern enterprise. Paired with MySQL or MariaDB, developers have a 100% open-source stack with which to develop applications from scratch. PHP is used by a large number of frameworks including WordPress and Laravel, meaning PHP knowledge lets you develop, optimise and customise these popular platforms.
This study programme starts with a database-development module, where you will learn about different database models and then focus on relational (and object-relational) databases, including creating the database, adding data, queries and optimisation. You then start your PHP journey in the PHP Foundations module, where you will learn object-oriented programming using the latest version of PHP. You will be able to create dynamic database-driven websites and learn how to create all of the components required in the modern web. Finally, you will round off with the PHP Advanced module - where you will master PHP. You will learn and implement design patterns, understand optimisation, learn how to create REST web services and use PHP frameworks.
Throughout this programme, we will be focusing on best practices such as version control with Git and using Docker to create a repeatable development environment.
The Website Developer study programme is an MQF Level 5 Award (5 ECTS) titled ‘VET Award for Web Development with MySQL and PHP’ by the National Commission for Further & Higher Education. This continues to confirm the relevance of the MySuccess industry-designed study programmes. |
Course Outline
- Databases overview
- Data Definition Language (DDL)
- Working with queries - Retrieving Data
- Modifying data in a table
- Using SQL functions in queries
- Working with multi-table queries (Joins)
- Implementing data integrity
- Using databases for software applications
- Language Basics
- Syntax, Quotes
- Comments
- Data Types
- Working with Variables
- Numbers
- Constants
- Variables
- Strings
- Arrays
- Control Flow
- Operators
- Conditionals
- Loops
- Functional Programming
- Functions
- Libraries
- Advanced Arrays
- File Handling
- Building Web Applications
- Brief Introduction to Server Communications
- Sessions & Cookies
- Security
- Persistence with Relational Databases:
- Brief Introduction to MySQL/MariaDB Database as it relates to Web Sites
- Elements of Object-Oriented Design
- Classes & Objects
- Inheritance
- Polymorphism
- Design Patterns (Singleton, MVC and others)
- Web Services
- Introduction to Web Services
- Consuming REST Web Services / APIs
- Creating a REST Web Service / API
- PHP Ecosystem
- Using Composer
- Using an Autoloader
- Templating with Twig
- PHP Frameworks
- Overview of PHP Frameworks
- Creating a Website with Laravel
- Welcome to Git
- Introduction to Version Control
- Git & GitHub
- Setting Up an Environment
- Committing Code
- Using the Git CLI
- Using Visual Studio Code Git Tools
- Git Remote
- Cloning a Repository
- Working with a Remote Repository
- Fetching Changes
- Further Git
- Working with Branches
- Merging Branches
- Resolving Merge Conflicts
Final Project & Certification
Upon completing this course, you'll be working on a practical application project which will allow you to put what you've learned in the course to the test. The project is graded out of 100, with a 50% grade required for successful completion. You will have a period of 3 months to submit this project, starting from the final lesson of your class. Upon successfully completing this project, you'll receive an industry-recognized professional certificate to share with your network and showcase all that you've learned. |
Funding
Students successfully completing the Website Developer study programme can apply for the Get Qualified Scheme which will enable them to benefit from a tax credit of 70% of the costs incurred (i.e. €910 will be refunded back for this course). For further details and assistance on how to apply for this scheme, kindly contact us for an appointment. |
Pay Monthly
Thanks to ICE Malta’s Easy Payment Scheme, you can design an interest-free monthly payment plan to cover your tuition. No banks involved. Discover more. |
Course Details
MODE OF STUDY
PARTTIME - Online Live
DELIVERY METHOD
Live Demonstrations & Hands-on Projects
ENTRY REQUIREMENTS
- Good Knowledge of English
- Completed Website Designer Associate Course or have equivalent basic knowledge in Front-End Web Technologies (HTML, CSS)
ONLINE CLASS REQUIREMENTS
Mac or Windows PC
WebCam
Stable Internet Connection
NEXT STEPS
DURATION
60 hours (20 Lessons of 3 Hours)
DAY(S)
Monday & Wednesday
TIME
6.00PM till 9.00PM
STARTING DATE
Monday 15th July 2024
END DATE
Wednesday 25th September 2024
WHAT'S INCLUDED
- Live Training by a Zend Certified Engineer
- Detailed Educator Courseware
- Final Project Review & Grading
- 6-Months Post-Course Educator Email Support
- 7-Day Lesson Playback (Rewatch On-Demand) NEW
- Git for Version Control Short Course (On-Demand) BONUS
Price: € 1300
€
Become a backend web engineer and get your hands dirty with SQL & PHP - the core technologies of the dynamic web. PHP is used by 76% of all websites and that includes giants such as Facebook, Slack and Wordpress. From small eCommerce websites to comprehensive ERP systems, PHP is at the core of an open-source stack that powers modern enterprise. Paired with MySQL or MariaDB, developers have a 100% open-source stack with which to develop applications from scratch. PHP is used by a large number of frameworks including WordPress and Laravel, meaning PHP knowledge lets you develop, optimise and customise these popular platforms.
This study programme starts with a database-development module, where you will learn about different database models and then focus on relational (and object-relational) databases, including creating the database, adding data, queries and optimisation. You then start your PHP journey in the PHP Foundations module, where you will learn object-oriented programming using the latest version of PHP. You will be able to create dynamic database-driven websites and learn how to create all of the components required in the modern web. Finally, you will round off with the PHP Advanced module - where you will master PHP. You will learn and implement design patterns, understand optimisation, learn how to create REST web services and use PHP frameworks.
Throughout this programme, we will be focusing on best practices such as version control with Git and using Docker to create a repeatable development environment.
The Website Developer study programme is an MQF Level 5 Award (5 ECTS) titled ‘VET Award for Web Development with MySQL and PHP’ by the National Commission for Further & Higher Education. This continues to confirm the relevance of the MySuccess industry-designed study programmes. |
- Databases overview
- Data Definition Language (DDL)
- Working with queries - Retrieving Data
- Modifying data in a table
- Using SQL functions in queries
- Working with multi-table queries (Joins)
- Implementing data integrity
- Using databases for software applications
- Language Basics
- Syntax, Quotes
- Comments
- Data Types
- Working with Variables
- Numbers
- Constants
- Variables
- Strings
- Arrays
- Control Flow
- Operators
- Conditionals
- Loops
- Functional Programming
- Functions
- Libraries
- Advanced Arrays
- File Handling
- Building Web Applications
- Brief Introduction to Server Communications
- Sessions & Cookies
- Security
- Persistence with Relational Databases:
- Brief Introduction to MySQL/MariaDB Database as it relates to Web Sites
- Elements of Object-Oriented Design
- Classes & Objects
- Inheritance
- Polymorphism
- Design Patterns (Singleton, MVC and others)
- Web Services
- Introduction to Web Services
- Consuming REST Web Services / APIs
- Creating a REST Web Service / API
- PHP Ecosystem
- Using Composer
- Using an Autoloader
- Templating with Twig
- PHP Frameworks
- Overview of PHP Frameworks
- Creating a Website with Laravel
- Welcome to Git
- Introduction to Version Control
- Git & GitHub
- Setting Up an Environment
- Committing Code
- Using the Git CLI
- Using Visual Studio Code Git Tools
- Git Remote
- Cloning a Repository
- Working with a Remote Repository
- Fetching Changes
- Further Git
- Working with Branches
- Merging Branches
- Resolving Merge Conflicts
Upon completing this course, you'll be working on a practical application project which will allow you to put what you've learned in the course to the test. The project is graded out of 100, with a 50% grade required for successful completion. You will have a period of 3 months to submit this project, starting from the final lesson of your class. Upon successfully completing this project, you'll receive an industry-recognized professional certificate to share with your network and showcase all that you've learned. |
Students successfully completing the Website Developer study programme can apply for the Get Qualified Scheme which will enable them to benefit from a tax credit of 70% of the costs incurred (i.e. €910 will be refunded back for this course). For further details and assistance on how to apply for this scheme, kindly contact us for an appointment. |
Pay Monthly
Thanks to ICE Malta’s Easy Payment Scheme, you can design an interest-free monthly payment plan to cover your tuition. No banks involved. Discover more. |
MODE OF STUDY
PARTTIME - Online Live
DELIVERY METHOD
Live Demonstrations & Hands-on Projects
ENTRY REQUIREMENTS
- Good Knowledge of English
- Completed Website Designer Associate Course or have equivalent basic knowledge in Front-End Web Technologies (HTML, CSS)
ONLINE CLASS REQUIREMENTS
Mac or Windows PC
WebCam
Stable Internet Connection
NEXT STEPS
DURATION
60 hours (20 Lessons of 3 Hours)
DAY(S)
Monday & Wednesday
TIME
6.00PM till 9.00PM
STARTING DATE
Monday 15th July 2024
END DATE
Wednesday 25th September 2024
WHAT'S INCLUDED
- Live Training by a Zend Certified Engineer
- Detailed Educator Courseware
- Final Project Review & Grading
- 6-Months Post-Course Educator Email Support
- 7-Day Lesson Playback (Rewatch On-Demand) NEW
- Git for Version Control Short Course (On-Demand) BONUS
Price: € 1300
€