286 Courses in Cardiff delivered Online

Get ready for an exceptional online learning experience with the Coding (C++, Python, JavaScript & IT) bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. This Coding (C++, Python, JavaScript & IT) is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Coding package has something for everyone. As part of the Coding (C++, Python, JavaScript & IT) package, you will receive complimentary PDF certificates for all courses in Coding bundle at no extra cost. Equip yourself with the Coding bundle to confidently navigate your career path or personal development journey. Enroll in our Coding bundle today and start growing your career! This Coding Bundle Comprises the Following CPD Accredited Courses: Course 01: Introduction to Coding With HTML, CSS, & Javascript Course 02: C++ Development: The Complete Coding Guide Course 03: Python Programming: Beginner To Expert Course 04: Learn Ethical Hacking From A-Z: Beginner To Expert Course 05: Bash Scripting, Linux and Shell Programming Course 06: JavaScript Project - Game Development with JS Course 07: R Programming for Data Science Course 08: Secure Programming of Web Applications Course 09: Advanced Diploma in PHP Web Development with MySQL, GitHub & Heroku Course 10: The Complete Front-End Web Development Course! Course 11: The Complete MySQL Server from Scratch: Bootcamp Course 12: Cyber Security Awareness Training Course 13: Cloud Computing / CompTIA Cloud+ (CV0-002) Course 14: CompTIA A+ (220-1001) Course 15: Building Your Own Computer Course 16: Computer Networks Security from Scratch to Advanced Course 17: IT Administration and Networking Course 18: Encryption Course 19: Advance Windows 10 Troubleshooting for IT HelpDesk Course 20: Microsoft Excel Complete Course Learning Outcome: By completing the Coding (C++, Python, JavaScript & IT) course, you will: Gain comprehensive insights into multiple fields. Foster critical thinking and problem-solving skills across various disciplines. Understand industry trends and best practices through the Coding Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with the Coding Bundle. Build a strong knowledge base in your chosen course via the Coding Bundle. Benefit from the flexibility and convenience of online learning. With the Coding package, validate your learning with a CPD certificate. Each course in the Coding (C++, Python, JavaScript & IT) bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with Coding (C++, Python, JavaScript & IT), a rich anthology of 15 diverse courses. Each course in the Coding bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. ThisCoding (C++, Python, JavaScript & IT) bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Coding (C++, Python, JavaScript & IT) bundle offers you the flexibility and convenience to learn at your own pace. Make the Coding package your trusted companion in your lifelong learning journey. CPD 215 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Coding (C++, Python, JavaScript & IT) bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Requirements Without any formal requirements, you can delightfully enrol this Coding (C++, Python, JavaScript & IT) course. Career path Our Coding (C++, Python, JavaScript & IT) bundle will prepare you for a range of careers, including: Software Developer Full-Stack Web Developer IT Solutions Architect Data Analyst Systems Programmer Application Developer Software Engineer Game Developer Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

JavaScript can interface with the Document Object Model and help make webpage elements come to life! Interact with web users through event listeners to make your web pages respond to users and code. This practical course will help you build modern, interactive, and dynamic web pages. You need to have previous experience with JavaScript and HTML to get started.

Learn how to style HTML components with CSS3 to build websites and web pages that are visually appealing from beginning to end. Those who want to learn CSS should take this course.

Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now Tired of browsing and searching for a Linux course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed. This Linux Bundle Consists of the following Premium courses: Course 01: Learn Linux in 5 Days Course 02: Linux Security and Hardening Course 03: Ethical Hacking with Kali Linux Course 04: Cyber Security Incident Handling and Incident Response Course 05: Network Security Level 2 Course 06: CompTIA Networking - Level 4 Course 07: Encryption Course 08: Complete Web Application Penetration Testing & Security Course 09: Data Analytics Course 10: Data Center Training Essentials: General Introduction Course 11: Python Programming for Everybody Course 12: Learning Computers and Internet Level 2 Course 13: Windows 10 Pro Complete Training Course 14: Essential IT Skills Level 3 Curriculum of Bundle Course 01: Learn Linux in 5 Days Unit 01: Overview Course Overview Unit 02: Day 1 Background and Introduction Linux Distributions Installing VirtualBox on Windows Installing VirtualBox on Mac Installing Linux Using an Image for VirtualBox VirtualBox Troubleshooting Tips When to Install Linux from Scratch Installing CentOS from Scratch / CentOS Manual Installation Process Getting Connected Connect Directly Unit 03: Day 2 The Linux Directory Structure The Shell Basic Linux Commands Teach Yourself to Fish Working with Directories Listing Files and Understanding LS Output Unit 04: Day 3 File and Directory Permissions Explained - Part One File and Directory Permissions Explained - Part Two View Files and the Nano Editor Editing Files in Vi Editing Files with Emacs Finding Files and Directories Graphical Editors Unit 05: Day 4 Deleting, Copying, Moving, and Renaming Files Wildcards - Part One Wildcards - Part Two Input, Output, and Redirection Comparing Files Searching in Files and Using Pipes Transferring and Copying Files over the Network Customizing the Shell Prompt Shell Aliases Unit 06: Day 5 Environment Variables Processes and Job Control Scheduling Repeated Jobs with Cron Switching Users and Running Commands as Others Shell History and Tab Completion Installing Software on RPM Based Linux Distros: RedHat, CentOS, AlmaLinux, Rocky Installing Software on Debian Based Linux Distros: Debian, Ubuntu, Kali Linux Conclusion - Congratulations and Thank You! Unit 07: Addendum - Connecting to a Linux Virtual Machine over the Network Connecting to a Linux Virtual Machine over the Network Unit 08: Bonus Bonus - Installing NGINX, MySQL, PHP, and WordPress on Ubuntu How will I get my Certificate? After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course ) Hard Copy Certificate: Free (For The Title Course ) CPD 190 CPD hours / points Accredited by CPD Quality Standards Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included P.S. The delivery charge inside the UK is £3.99, and the international students have to pay £9.99.

14 in 1 Bundle only at £100 Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now Web Design is essential to bringing a website to life and creating the experience you want for your end-users. Currently, the web is everywhere, and the demand for web designers continues to grow with the surge in smart devices and internet technologies. On top of that, the web design service industry revenue is predicted to reach £560.9 million by 2022. Accordingly, if you want to secure yourself in an in-demand and rewarding career path, then this Web Design bundle could be the perfect choice for you! In addition, with the Web Design bundle, to help you showcase your expertise in Modern Web Designing, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These Modern Web Designing - Level 2 certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Bundle Consists of the following Premium courses: Course 01: Modern Web Designing - Level 2 Course 02: Web Design in Affinity Designer Course 03: Diploma in Animation Design Course 04: Advanced Diploma in User Experience UI/UX Design Course 05: Ionic & Angular JS: Principles Of Mobile and Web Development Course 06: Social Media Website Development Using Wordpress Course 07: Create Website for Accounting Business Course 08: Landing Page Design and Conversion Rate Optimisation Course 09: HTML Web Development for Beginners Course 10: Ultimate PHP & MySQL Web Development Course & OOP Coding Course 11: Diploma in PHP Web Development Course 12: Cyber Security Incident Handling and Incident Response Course 13: Functional Skills IT Course 14: Decision Making and Critical Thinking Enrol now in Modern Web Designing Training to advance your career, and use the premium study materials from Apex Learning. Course Curriculum Course 01: Modern Web Designing - Level 2 Module: 01 1.1 Intro 1.2 Install the Tools and Get Started Module: 02 2.1 Intro to HTML 2.2 What is HTML 2.3 Start a New HTML File & Use Tags 2.4 Header Tags And much more... Module: 03 3.1 CSS Intro 3.2 Add CSS Styles 3.3 Classes and IDs 3.4 Borders 3.5 Sizing And much more... Module: 04 4.1 Intro to Bootstrap 4.2 Install Bootstrap 4.3 Indenting and Containers 4.4 The Grid System And much more... Module: 05 5.1 Landing Page Intro 5.2 Sketch Your Landing Page 5.3 The Top Section And much more... Module: 06 6.1 Business Site Intro 6.2 Sketch Up 6.3 Using Fancy Font Logo And much more... Module: 07 7.1 Intro 7.2 Portfolio Sketch And much more... Module: 08 8.1 Hosting 8.2 Bluehost And much more... Course 02: Web Design in Affinity Designer Introduction The Fundamentals Top 10 principles of good web design How to choose the right colours to design stunning websites Typography in web design And much more... How will I get my Certificate? After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) CPD 160 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Modern Web Designing Training bundle. Requirements Our Modern Web Designing Training course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Modern Web Designing Training expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included P.S. The delivery charge inside the UK is £3.99, and the international students have to pay £9.99.

***Limited Time Exclusive Bundle*** Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now Tired of browsing and searching for a Web & Graphic Designing course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Web & Graphic Designing bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Web & Graphic Designing course that will enhance your skills and prepare you for the competitive job market. Also, our experts are available for answering your queries on Web & Graphic Designing and help you along your learning journey. Advanced audio-visual learning modules of these Web & Graphic Designing courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Web & Graphic Designing, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Web & Graphic Designing Bundle Consists of the following Premium courses: Course 01: Modern Web Designing - Level 2 Course 02: Level 2 Adobe Graphics Design Course Course 03: Web Design in Affinity Designer Course 04: Diploma in Animation Design Course 05: Advanced Diploma in User Experience UI/UX Design Course 07: Graphic and Logo Design Course 08: Ultimate PHP & MySQL Web Development Course & OOP Coding Course 09: Social Media Website Development Using Wordpress Course 10: Create Website for Accounting Business Course 11: Landing Page Design and Conversion Rate Optimisation Course 12: HTML Web Development for Beginners Course 13: Front End Web Development Diploma Course 14: Diploma in PHP Web Development Course 15: WebGL 2D/3D Programming and Graphics Rendering Enrol now in Web & Graphic Designing to advance your career, and use the premium study materials from Apex Learning. How will I get my Certificate? After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Web & Graphic Designing expertise and essential knowledge, which will assist you in reaching your goal. Curriculum of Bundle Course 01: Modern Web Designing - Level 2 Module: 01 1.1 Intro 1.2 Install the Tools and Get Started Module: 02 2.1 Intro to HTML 2.2 What is HTML 2.3 Start a New HTML File & Use Tags 2.4 Header Tags 2.5 Edit Text 2.6 Links 2.7 Images 2.8 Lists 2.9 Challenge 2.10 HTML Outro Module: 03 3.1 CSS Intro 3.2 Add CSS Styles 3.3 Classes and IDs 3.4 Borders 3.5 Sizing 3.6 Padding and Margin 3.7 Text Styles 3.8 DIVs 3.9 Postioning 3.10 Hover 3.11 Easily Center Elements 3.12 Fonts 3.13 Challenge 3.14 CSS Outro Module: 04 4.1 Intro to Bootstrap 4.2 Install Bootstrap 4.3 Indenting and Containers 4.4 The Grid System 4.5 Images 4.6 Buttons 4.7 Challenge 4.8 Bootstrap Outro Module: 05 5.1 Landing Page Intro 5.2 Sketch Your Landing Page 5.3 The Top Section 5.4 Polish the Top Section 5.5 Adding Images 5.6 The Main Points Section 5.7 Collecting Emails With an Opt-In Form 5.8 Challenge 5.9 Landing Page Outro Module: 06 6.1 Business Site Intro 6.2 Sketch Up 6.3 Using Fancy Font Logo 6.4 Carousel Basics 6.5 Carousel Extras 6.6 Text on Images 6.7 Phone Number Icon 6.8 Google Maps 6.9 Font Awesome 6.10 Challenge 6.11 Business Site Outro Module: 07 7.1 Intro 7.2 Portfolio Sketch 7.3 Jumbotron 7.4 Nav Bar 7.5 Panels 7.6 Challenge 7.7 Portfolio Outre Module: 08 8.1 Hosting 8.2 Bluehost 8.3 Uploading 8.4 Tips 8.5 Hosting Outro And much more... CPD 170 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Web & Graphic Designing bundle. Requirements Our Web & Graphic Designing course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Web & Graphic Designing expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included P.S. The delivery charge inside the UK is £3.99, and the international students have to pay £9.99.

Embark on a digital crafting odyssey, diving into the intricate world of web creation with our 'PHP Web Development with MySQL; GitHub & Heroku' course. Visualise your first step into this digital tapestry with the 'Introduction' unit, an inviting prelude that demystifies the realm of server-side scripting. As learners unfurl the sails of their developmental journey, they'll configure their coding environment, laying the robust groundwork for a future in web architecture. Advancing into the heart of PHP, our syllabus navigates through the crucial syntax and fundamentals that form the bedrock of dynamic website construction. Engage with the creation of interactive forms, delve into database manipulation using MySQL, and master user authentication processes. This course promises a transformative learning expedition, from first principles to deploying live web applications, all while ensuring each participant garners the confidence to stitch together the seams of secure, responsive online experiences. Learning Outcomes Comprehend PHP fundamentals and create robust web applications. Configure environments for PHP development with precision. Integrate MySQL databases for dynamic content management. Construct and handle secure PHP forms for data collection. Implement user authentication to safeguard web applications. Why choose this PHP Web Development with MySQL; GitHub & Heroku course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this PHP Web Development with MySQL; GitHub & Heroku course for? Novices embarking on web development careers. Technologists eager to learn server-side scripting. Data managers focusing on MySQL database integration. Coders looking to understand PHP in web applications. Developers aiming to utilise GitHub and Heroku for deployment. Career path Web Developer: £25,000 - £50,000 PHP Developer: £24,000 - £45,000 MySQL Database Administrator: £30,000 - £60,000 User Authentication Specialist: £35,000 - £55,000 Back-End Developer: £28,000 - £53,000 DevOps Engineer: £40,000 - £70,000 Prerequisites This PHP Web Development with MySQL; GitHub & Heroku does not require you to have any prior qualifications or experience. You can just enrol and start learning.This PHP Web Development with MySQL; GitHub & Heroku was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Unit 01: Introduction Introduction 00:06:00 Unit 02: Environment Configuration Module 01: Setup a PHP Environment using XAMPP 00:16:00 Module 02: Install Composer Package Manager 00:03:00 Module 03: Visual Studio Code - Web Development Add ons 00:12:00 Module 04: Create a GitHub Account 00:13:00 Module 05: Create a Heroku Account 00:08:00 Unit 03: PHP Basics and Syntax Module 01: How PHP Works 00:29:00 Module 02: IFELSE Statements 00:19:00 Module 03: Switch Statements 00:09:00 Module 04: FOR Loop 00:10:00 Module 05: WHILE AND DOWHILE Loops 00:14:00 Module 06: PHP Arrays and Manipulation 00:13:00 Module 07: String Manipulation Functions 00:28:00 Module 08: Date and Time Manipulation Functions 00:15:00 Module 09: User Defined Functions 00:22:00 Module 10: PHP Include and Require 00:22:00 Module 11: PHP Website Layout - With Bootstrap 00:23:00 Module 12: Add Project to Github 00:08:00 Module 13: Publish Website to Heroku 00:20:00 Unit 04: PHP Forms and MySQL and User Authentication Module 01: Project and Website Setup 00:21:00 Module 02: Create a Bootstrap 4 Form 00:28:00 Module 03: PHP Form - $_GET Action 00:23:00 Module 04: PHP Form - $_POST Action 00:11:00 Module 05: Design Database with phpMyAdmin 00:19:00 Module 06: Connect to Database using PHP PDO 00:18:00 Module 07: Save Records to Database 00:38:00 Module 08: View Database Records 00:36:00 Module 09: View One Record's Details 00:28:00 Module 10: Update Database Records 00:34:00 Module 11: Delete Database Records 00:11:00 Module 12: Final Touches: Form Validation, Error Messages, Success Messages 00:17:00 Module 13: Create Heroku App and Remote Database 00:21:00 Module 14: Setup Authentication Tables in Database 00:20:00 Module 15: Setup Login and Authentication 00:29:00 Module 16: Control User Access 00:08:00 Module 17: Sending Confirmation Emails 00:31:00 Module 18: Upload Profile Pictures 00:31:00 Module 19: Final Touches 00:14:00 Resources Resources - PHP Web Development w/ MySQL GitHub & Heroku 00:00:00 Assignment Assignment - PHP Web Development with MySQL; GitHub & Heroku 00:00:00

Embark on a comprehensive journey into the world of MySQL with a focus on its applications in Data Science and Analytics. This course is structured to take you from the fundamentals to advanced topics in MySQL Server. Covering SQL basics, data manipulation and definition, control and analytic functions, and database management, you'll acquire the essential skills for harnessing MySQL's power in data-driven decision-making. Learning Outcomes: Establish a strong foundation in SQL and MySQL. Set up and configure SQL Server for efficient data handling. Master SQL's Data Manipulation, Definition, and Control Language. Create and optimize SQL queries for data analysis. Perform advanced data analytics using SQL. Understand the power of GROUP BY and JOIN statements. Implement data constraints and views for data integrity and security. Develop proficiency in stored procedures, data import/export, and database backup/restore. Why buy this Learn MySQL from Scratch for Data Science and Analytics?  Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Learn MySQL from Scratch for Data Science and Analytics you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Learn MySQL from Scratch for Data Science and Analytics course is ideal for Aspiring Data Scientists and Analysts. Database Administrators and Developers. Students and professionals seeking to enter the field of Data Science. Anyone looking to enhance their SQL and MySQL skills for data-related roles. Prerequisites This Learn MySQL from Scratch for Data Science and Analytics was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Data Analyst: £25,000 - £50,000 per year. Database Administrator: £30,000 - £60,000 per year. SQL Developer: £30,000 - £60,000 per year. Data Scientist: £40,000 - £80,000 per year. Business Intelligence Analyst: £35,000 - £65,000 per year. Course Curriculum Learn MySQL from Scratch for Data Science and Analytics Section 01: Getting Started Introduction 00:02:00 How to get course requirements 00:01:00 Getting started on Windows, Linux or Mac 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 What is Source Code? 00:09:00 Section 02: SQL Server setting up Section Introduction 00:01:00 MySQL Server Installation 00:14:00 Connect MySQL Server Instance 00:06:00 MySQL Workbench overview 00:11:00 Download and Restore Sample Database 00:08:00 Section 03: SQL Database basics Section Introduction 00:01:00 Overview of Databases 00:09:00 Creating Database 00:07:00 SQL Data Types 00:04:00 Column Data Types on Workbench 00:07:00 Creating Table 00:04:00 Overview of Primary and Foreign Key 00:03:00 Primary Key 00:06:00 Foreign Key 00:12:00 Creating Temporary tables 00:12:00 EER - Enhanced Entity Relationship Diagrams 00:04:00 Section 04: SQL DML (Data Manipulation Language) Section Introduction 00:01:00 Insert statement 00:07:00 Update statement 00:06:00 Delete statement 00:03:00 Section 05: SQL DDL (Data Definition Language) Section Introduction 00:01:00 CREATE table statement 00:08:00 DROP statement 00:03:00 ALTER statement 00:05:00 TRUNCATE statement 00:03:00 COMMENT in query 00:02:00 RENAME table 00:03:00 Section 06: SQL DCL (Data Control Language) Create Database user 00:03:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 07: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:03:00 SELECT DISTINCT 00:02:00 SELECT with column headings 00:01:00 Column AS statement 00:02:00 DASHBOARD Analytics 00:06:00 Section 08: Filtering Data rows SELECT WHERE Clause - theory 00:03:00 SELECT WHERE Clause - practical 00:06:00 Section 09: Aggregate functions for Data Analysis Sum() 00:06:00 Min()-Max() 00:03:00 Section 10: SQL Data Analyticstatements Order By statement 00:05:00 SELECT TOP 3 records 00:02:00 BETWEEN command 00:06:00 IN operator 00:03:00 Search Data usingLIKE cards 00:05:00 Section 11: SQL Group by statement Section Introduction 00:01:00 Group by - theory 00:04:00 Data Analytics with Group By 00:04:00 HAVING statement 00:03:00 Section 12: JOINS Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:07:00 Left outer join 00:02:00 Right outer join 00:02:00 Union 00:03:00 CERTESIAN Product or Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 13: SQL Constraints Section introduction 00:01:00 Check constraint 00:09:00 NOT NULL constraint 00:03:00 UNIQUE constraint 00:06:00 Section 14: Views Creating Views 00:03:00 Data Analytic Views from multiple tables 00:03:00 Section 15: Advanced SQL Functions Section Introduction 00:01:00 Timestamp 00:03:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:03:00 String functions3 00:07:00 Advanced functions 00:04:00 Sub Queries 00:03:00 SELECT with calculations 00:05:00 Section 16: SQL Stored procedures Create stored procedure 00:06:00 Stored procedure with parameter 00:03:00 Drop Procedure 00:01:00 Section 17: Import & Export data Section Introduction 00:01:00 Import .csv file 00:04:00 Export Data to .csv file 00:02:00 Section 18: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:02:00 Restoring Database backup 00:02:00

Course Overview Do you want to familiarize with various programming structure and build your career as a software engineer? Then this course is perfect for you. Learn how you can use HTML CSS my SQL GitHub XAMPP and Heroku from this Modern PHP/MYSQL/ GitHub & Heroku Tutorial course and boost your programming skill in no time. This Modern PHP/MYSQL/ GitHub & Heroku Tutorial course will teach you the function of different platforms of web development. You will learn about PHP, bootstrap, MySQL, GitHub and Heroku. The lessons will help you understand programming structures from scratch and explore different areas of web development. The activities of the course will help you to practice the knowledge you learn and enhance your skill. You'll be able to work and create sample websites with the lectures.  You'll receive certifications after completing the course. This course can be a stepping stone for you to enhance your skill and be a professional web developer. Learning Outcomes Understand how XAMPP works Familiarize with the role of PHP in web-based programs Setup Apache server and PHP environment using XAMPP server Learn how to use GitHub Be able to build data-driven and dynamic web applications Learn how to deploy web applications using Heroku Learn the basics of bootstrap 4 Who is this course for? This course is a complete package of the database, PHP, Bootstrap and GitHub. This is ideal for anyone who wants to learn software designing and its steps. The course will teach you the necessary skills and knowledge you need for software development from scratch. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path Modern PHP/MYSQL/ GitHub & Heroku Tutorial Course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Web Developers Web Designers Software Developers PHP Developers App Designers Unit 01: Introduction Introduction 00:06:00 Unit 02: Environment Configuration Module 01: Setup a PHP Environment using XAMPP 00:16:00 Module 02: Install Composer Package Manager 00:03:00 Module 03: Visual Studio Code - Web Development Add ons 00:12:00 Module 04: Create a GitHub Account 00:13:00 Module 05: Create a Heroku Account 00:08:00 Unit 03: PHP Basics and Syntax Module 01: How PHP Works 00:29:00 Module 02: IFELSE Statements 00:19:00 Module 03: Switch Statements 00:09:00 Module 04: FOR Loop 00:10:00 Module 05: WHILE AND DOWHILE Loops 00:14:00 Module 06: PHP Arrays and Manipulation 00:13:00 Module 07: String Manipulation Functions 00:28:00 Module 08: Date and Time Manipulation Functions 00:15:00 Module 09: User Defined Functions 00:22:00 Module 10: PHP Include and Require 00:22:00 Module 11: PHP Website Layout - With Bootstra 00:23:00 Module 12: Add Project to Github 00:08:00 Module 13: Publish Website to Heroku 00:20:00 Unit 04: PHP Forms and MySQL and User Authentication Module 01: Project and Website Setup 00:21:00 Module 02: Create a Bootstrap 4 Form 00:28:00 Module 03: PHP Form - $_GET Action 00:23:00 Module 04: PHP Form - $_POST Action 00:11:00 Module 05: Design Database with phpMyAdmin 00:19:00 Module 06: Connect to Database using PHP PDO 00:18:00 Module 07: Save Records to Database 00:38:00 Module 08: View Database Records 00:36:00 Module 09: View One Record's Details 00:28:00 Module 10: Update Database Records 00:34:00 Module 11: Delete Database Records 00:11:00 Module 12: Final Touches: Form Validation, Error Messages, Success Messages 00:17:00 Module 13: Create Heroku App and Remote Database 00:21:00 Module 14: Setup Authentication Tables in Database 00:20:00 Module 15: Setup Login and Authentication 00:29:00 Module 16: Control User Access 00:08:00 Module 17: Sending Confirmation Emails 00:31:00 Module 18: Upload Profile Pictures 00:31:00 Module 19: Final Touches 00:14:00 Resources Resources - Modern PHP/MYSQL/ GitHub & Heroku Tutorial 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

In today's digital age, web design and development are at the heart of creating engaging online experiences. The Web Design and Web Development course offers you the perfect opportunity to gain valuable knowledge and skills to build and maintain websites. Whether you are interested in creating sleek, user-friendly designs or coding dynamic websites, this course is designed to help you grasp the essential tools and techniques needed for success. As websites evolve, so does the demand for innovative and functional designs, and this course helps you stay ahead of the curve by offering a solid understanding of both design principles and coding practices. The world of web design and development continues to grow as businesses increasingly turn to online platforms to connect with customers. By learning the foundations of web design, HTML, CSS, JavaScript, and more, you'll be able to develop a range of websites, from basic landing pages to sophisticated online stores. You'll also be introduced to web development frameworks that can streamline your workflow and increase efficiency. This course provides everything you need to develop an online presence that meets the demands of modern users, ensuring that you're well-equipped for an exciting career in the tech industry. Key Features: CPD Certified 10 Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Web Design and WordPress Training Module 01: Web Design Module 02: Requirements to take this course Module 03: Organizing your Web Design Project Module 04: Gathering project information from client Module 05: Sketching, Wireframing, Atomic Design & 8point Grid system Module 06: Style Guides, colors and typographics scales Module 07: Designing for Desktop/Large View (Wstudio Web Design Project) Module 08: Planning Responsive Web Design Module 09: Designing for Tablet/Medium View (Wstudio Web Design Project) Module 10: Designing for Mobile/Small View (Wstudio Web Design Project) Module 11: Designing for Developers Module 12: Prototyping with Invision app Module 13: SVGs and Icon Fonts in Web Design Module 14: WordPress Training Module 15: Introduction & installing WordPress Module 16: WordPress page builder Familiarization Module 17: WordPress home page Design & development Module 18: WordPress About Us page Design & development Module 19: WordPress Contact Us & blog page design & development Module 20: WordPress Responsive website & publishing website Module 21: Free Plugins to mimic the Elementor Pro Module 22: Exporting & importing our Elementor pages Module 23: Creating Our WordPress ecommerce store Module 24: WordPress website customization Module 25: WordPress Website Backup, official email & more Advanced Diploma in PHP Web Development Module 01: Introduction Module 02: Environment Configuration Module 03: PHP Basics and Syntax Module 04: PHP Forms and MySQL and User Authentication ________________________________________________________________________ Complete Career Guide for Web Design and Web Development (A to Z) This isn't just a course; it's your ticket to thriving in the sector and your roadmap to the Web Design. In addition to mastering the essentials of Web Design, you'll also gain valuable skills in CV writing, job searching, communication, leadership, and project management. These 9 complementary courses are designed to empower you at every stage of your journey. Stand out in your career, from crafting a winning CV to excelling in interviews. Develop the leadership skills to inspire your team and efficiently manage projects. This holistic approach ensures you're not just job-ready but career-ready. Enrol today, and let's build your success story together in Web Design. Your dream career starts here! List of career guide courses included in Web Design and Web Development With Complete Career Guide: Course 01: Professional CV Writing and Job Searching Course 02: Communication Skills Training Course 03: Career Development Training Course 04: Time Management Course 05: Returning to Work Training Course 06: Level 3 Diploma in Project Management Course 07: Leadership Skills Course 08: Body Language Course 09: Interview and Recruitment ________________________________________________________________________ Learning Outcomes: Gain proficiency in web design principles and techniques. Develop effective project organization and client communication skills. Master the use of sketching, wireframing, and the 8-point grid system. Make typographic scales, style guides, and integrated graphic elements. Demonstrate expertise in responsive web design for various devices. Acquire practical knowledge in WordPress installation, customization, and e-commerce. ________________________________________________________________________ Accreditation All of our courses, including thiscourse, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Course, you will immediately be sent your digital certificates. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we recommend renewing them every 12 months. Assessment At the end of the courses, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals aspiring to become skilled web designers and developers. Those seeking comprehensive WordPress training for website creation. Creative professionals aiming to enhance their design and development skills. Beginners in web design and development looking for a structured course. entrepreneurs who want to take charge of the material and layout of their website. Career path Web Designer - £25K to 35K/year. Front-end Developer - £30K to 40K/year. WordPress Developer - £28K to 38K/year. UI/UX Designer - £32K to 42K/year. E-commerce Developer - £35K to 45K/year. Certificates 10 CPD Accredited e-Certificates Digital certificate - Included 10 CPD Accredited Hard Copy Certificates Hard copy certificate - Included