PHP and MySQL with MVC Frameworks Certification Training
Access Duration - 365 Days
Awarded By Edureka
Guided Learning Hours (20)
Course Material
Self-study Online
4.5( 2 REVIEWS )
129 STUDENTS
What Will I Learn?
Gain an introduction to the basics of web technology
Master the concepts of PHP and MySQL
Learn the concepts of MVC architecture
Learn how to use MVC framework and implement PHP on a website
Learn to work with PHP text mails
Overview
The PHP and MySQL with MVC Frameworks Certification Training is designed to provide learners with an understanding of how to use PHP and MySQL with the MVC framework to develop powerful database driven websites. The course will focus on PHP and MySQL installation and configuration. PHP and MySQL are popular open-source techniques that are used when developing websites. If you wish to take your career in web development to the next level, this is a great course to get started on.
PHP and MySQL with MVC Frameworks Certification Training will provide a wealth of knowledge on easily maintainable database sites. Learners will receive an in-depth training on how to upload files to a server, manipulate system files, test and debug an application, use and create functions and successfully achieve PHP skills.
PHP and MySQL with MVC Frameworks Certification Training will teach learners to work with data validation and regular expressions. Qualifying in this course will set you in the right direction, giving you the opportunity to open the door to new and exciting job roles in web technology.
Why You Should Consider Taking this Course at Global Edulink?
Global Edulink is a leading online provider for several accrediting bodies, and provides learners the opportunity to take this exclusive course awarded by Edureka. At Global Edulink, we give our fullest attention to our learners’ needs and ensure they have the necessary information required to proceed with the Course. Learners who register will be given excellent support, discounts for future purchases and be eligible for a TOTUM Discount card and Student ID card with amazing offers and access to retail stores, the library, cinemas, gym memberships and their favourite restaurants.
- Access Duration
- Who is this Course for?
- Entry Requirement
- Method of Assessment
- Certification
- Awarding Body
- Career Path & Progression
The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course. The course is self-paced and you can complete it in stages, revisiting the lessons at any time.
This course is recommended for individuals, who want to learn PHP and MySQL with MVC framework,
- Web Developers
- Learners should be over the age of 16, and have a basic understanding of English, ICT and numeracy.
- A sound educational background is recommended
- Basic knowledge in HTML is recommended
In order to complete the Course PHP and MySQL with MVC Frameworks Certification Training, learners will have to submit an assignment. The assignment will demonstrate your familiarity with the particular subject and will test your ability to apply it in a real-world scenario.
Upon the successful completion of the course, you will be awarded the PHP and MySQL with MVC Frameworks Certification Training by Edureka.
Edureka is a pioneer in online learning and an agency that has frequently and consistently collaborated with educational and academic institutes. It guarantees expert commitment and is dedicated to learners taking their courses. Edureka is internationally recognised and takes learners a step closer to a leading career in the IT industry.
PHP and MySQL with MVC Frameworks Certification Training will improve your candidature for a number of jobs in web management. You can study further courses in the same field and enhance your academic expertise, and add this as a valuable skillset on your resume. Your skills will be recognised by leading organisations that give you the opportunity to land a well-paying job in web technology. Given below are job titles you can compete for, along with the average UK salary per annum according to https://www.glassdoor.com.
- Web Developers - £50,000 (Approximately)
Key Features
Gain an Accredited UK Qualification
Access to Excellent Quality Study Materials
Personalised Learning Experience
Support by Phone, Live Chat, and Email
Eligible for TOTUM Discount Card
UK Register of Learning Providers Reg No : 10053842Course Curriculum
| 1: PHP Basics and Conditional Logic | |||
| PHP introduction | |||
| Environment setup in different platforms | |||
| Script syntax | |||
| How to declare variable and data types | |||
| Constants | |||
| Arrays | |||
| Strings | |||
| Web concepts | |||
| Decision making statements | |||
| loop types | |||
| operators | |||
| Annie’s Quizzes | |||
| LAB | |||
| Q & A and Quick Recap | |||
| 2: Functions and Error Handling | |||
| What is Functions | |||
| Creating PHP functions | |||
| PHP functions with parameters | |||
| Argument by reference | |||
| setting default values for function parameters | |||
| dynamic function calls | |||
| PHP mails | |||
| how to send text mail | |||
| how to send html emails | |||
| how to send attachments with emails | |||
| Regular Expressions | |||
| POSIX regular expressions | |||
| predefined character ranges | |||
| Regexp POSIX functions | |||
| PERL style regular expressions | |||
| Regexp PERL compatible functions | |||
| Date and time functions,Built-in functions | |||
| file inclusion | |||
| file manipulations | |||
| exception handling | |||
| bugs debugging | |||
| Annie’s Quizzes | |||
| LAB | |||
| Q & A and Quick Recap. | |||
| 3: Object Oriented Programming | |||
| What is Object Oriented Concepts | |||
| Defining classes | |||
| Creating Objects | |||
| Member functions | |||
| Constructor and Destructor | |||
| Inheritance | |||
| Function overriding | |||
| Access Specifiers- private | |||
| public and protected members | |||
| Interfaces | |||
| Constants | |||
| Abstract Classes | |||
| Static keyword | |||
| Final keyword | |||
| calling parent constructors | |||
| Annie’s Quizzes | |||
| LAB | |||
| Q & A and Quick Recap | |||
| 4: MySQL Installation and Basics | |||
| Database Introduction | |||
| MySQL installation on various platforms | |||
| MySQL connection | |||
| Database creation | |||
| Database Manipulations- Add | |||
| Edit | |||
| Retrieve and Delete | |||
| Table creation and table manipulations- Add Edit | |||
| Retrieve and Delete Annie’s Quizzes | |||
| LAB | |||
| Q & A and Quick Recap. | |||
| 5: Advance Queries and Data Manipulation using PHP | |||
| LIKE clause | |||
| Sorting | |||
| Joins | |||
| Handling NULL Values | |||
| Regular Expressions | |||
| Transactions | |||
| ALTER Command | |||
| Indexes | |||
| Temporary Tables | |||
| Clone Tables | |||
| Database | |||
| Information | |||
| Sequences | |||
| Handling Duplicates | |||
| SQL Injections | |||
| Select | |||
| insert | |||
| update and delete using PHP script | |||
| Annie’s Quizzes | |||
| Q & A | |||
| Q & A and Quick Recap. | |||
| 6: MVC Infrastructure Basics & Introduction to CakePHP | |||
| Introduction to MVC | |||
| What are Model-View-Controller | |||
| Why use framework in the project (conventional vs. MVC project) | |||
| Installation of CakePHP | |||
| CakePHP folder structure | |||
| File naming conventions | |||
| Important config file (core.php, database.php) | |||
| Annie’s Quizzes | |||
| Q & A | |||
| Quick Recap | |||
| 7: CakePHP Controller, Views and Layout | |||
| Application flow – How Controller and view interacts/ exchanges data | |||
| What are CakePHP helpers? | |||
| Most commonly used helpers like Form | |||
| HTML | |||
| Session | |||
| Cookie etc | |||
| Create a controller and how URLs mapped to controller and views | |||
| Create views and layouts | |||
| Annie’s Quizzes | |||
| Q & A | |||
| Quick Recap | |||
| 8: Models and Database Interaction in CakePHP | |||
| Models: What are models and how they interact with database? | |||
| Accessing and manipulating table data using find | |||
| save | |||
| update methods of the model | |||
| Joining tables | |||
| conditions | |||
| conditions other than =(LIKE, BETWEEN,) | |||
| order by in CakePHP models | |||
| Change database dynamically using the definitions in database | |||
| php config file | |||
| Annie’s Quizzes | |||
| Q & A | |||
| Quick Recap | |||
| 9: Creating Dynamic Forms using CakePHP Html Helpers | |||
| Introduction to basic html form | |||
| get | |||
| post methods | |||
| Generate form elements like input boxes | |||
| dropdowns | |||
| radio buttons | |||
| links using CakePHP html helper | |||
| Form validation using Model validation definitions | |||
| Create retrieve and delete cookies | |||
| Create retrieve and delete session variables | |||
| File handling in CakePHP (create, delete, read files) | |||
| CakePHP Global variables and their use | |||
| Annie’s Quizzes | |||
| Q & A | |||
| retrieve and delete cookies | |||
| Quick Recap | |||
| 10: Using MVC & CakePHP to develop a website | |||
| Project 1: Create basic HTML registration form using CakePHP helpers. Post data to database and send an email | |||
| Project 2: The main aim of the project is to develop an online website, which will cover details about institutes, courses and student information using CakePHP | |||
| Create a basic layout for the website. | |||
| Add/Edit/View/Delete institute details | |||
| Add/Edit/View/Delete course details | |||
| Add/Edit/View/Delete student information | |||
Bret King
The course was structured well. The video series was enjoyable and I learned a lot.
Aaren Griffiths
The content focused firmly on how to build powerful database-drive websites and maintain them. I gained an in-depth knowledge on creating dynamic and robust websites.