Spreadsheet chaos? Sorted. This Microsoft Excel: 8 in 1 Premium Courses Bundle goes far beyond basic number crunching. You’ll explore not just Excel, but also the full Microsoft Office suite—Word, PowerPoint, Outlook, Access, Project—plus Power BI and SQL for those ready to flirt with data like it’s the office gossip. Whether you're spreadsheet shy or pivot table proud, this bundle keeps things tidy, stylish and fully functional. The content takes you through formulas, formatting, business reporting, data visualisation, and database management with clear, structured learning. No fluff, no filler—just focused skills that help you navigate office software with the confidence of someone who actually knows what they're doing. Upgrade your workflow one formula at a time. Learning Outcomes: Build and manage Excel spreadsheets with confidence and clarity. Create professional documents and reports using MS Word. Deliver sharp, engaging slides with MS PowerPoint tools. Handle email, tasks and calendars using MS Outlook efficiently. Analyse data using Power BI and basic SQL queries. Organise databases using Access and manage projects in MS Project. Who is this Course For: Professionals handling spreadsheets and reports on a regular basis. Office staff looking to improve Microsoft Office fluency. Admins managing communication, scheduling and document creation. Individuals working in finance, HR or operations roles. Data beginners who want to explore Power BI and SQL basics. Project coordinators managing deadlines and resource tracking. Job seekers looking to polish their office software knowledge. Anyone who thinks “VLOOKUP” sounds like tech wizardry. Career Path: Data Entry Clerk – £21,000 average salary Office Administrator – £24,500 average salary Business Analyst Assistant – £28,000 average salary Project Coordinator – £32,000 average salary Junior Data Analyst – £30,500 average salary Executive Assistant – £33,000 average salary
Duration 5 Days 30 CPD hours This course is intended for Ideal candidates include network professionals who are looking to build their foundational knowledge of the ClearPass product portfolio. Overview After you successfully complete this course, expect to be able to: Ability to setup ClearPass as a AAA server Demonstrate Configuration Guest, OnGurad, Onboard and Profiling features Integrate with External AD Server Understand Monitoring and Reporting Demonstrate Scaling and deployment of best practices Configure AAA services for both wired and wireless networks Demonstrate the configuration of Aruba Downloadable User Roles. Demonstrate the configuration of Dynamic Segmentation with Aruba switches. This course prepares participants with foundational skills in Network Access Control using the ClearPass product portfolio. This 5-day classroom session includes both instructional modules and labs to teach participants about the major features of the ClearPass portfolio. Participants will learn how to setup ClearPass as an AAA server, and configure the Policy Manager, Guest, OnGuard and Onboard feature sets. In addition, this course covers integration with external Active Directory servers, Monitoring and Reporting, as well as deployment best practices. The student will gain insight into configuring authentication with ClearPass on both wired and wireless networks. Intro to ClearPass BYOD High Level Overview Posture and Profiling Guest and Onboard ClearPass for AAA Policy Service Rules Authentication Authorization and Roles Enforcement Policy and Profiles Authentication and Security Concepts Authentication Types Servers Radius COA Active Directory Certificates Intro to NAD NAD Devices Adding NAD to ClearPass Network Device Groups Network Device Attributes Aruba Controller as NAD Aruba Switch Aruba Instant Monitoring and Troubleshooting Monitoring Troubleshooting Logging Policy Simulation ClearPass Insight Insight Dashboard Insight Reports Insight Alerts Insight Search Insight Administration Insight Replication Active Directory Adding AD as Auth Source Joining AD domain Using AD services External Authentication Multiple AD domains LDAP Static Host Lists SQL Database External Radius Server Guest Guest Account creation Web Login pages Guest Service configuration Self-registration pages Configuring NADS for Guest Guest Manager Deep Dive Web Login Deep Dive Sponsor Approval MAC Caching Onboard Intro to Onboard Basic Onboard Setup Onboard Deepdive Single SSID Onboarding Dual SSID Onboarding Profiling Intro to Profiling Endpoint Analysis Deep Dive Posture Intro to Posture Posture Deployment Options OnGuard Agent Health Collection OnGuard workflow 802.1x with Posture using Persistent/dissolvable agent OnGuard web Login Monitoring and Updates Operation and Admin Users Operations Admin Users Clustering and Redundancy Clustering Redundancy LAB Licensing ClearPass Licensing Base License Applications ClearPass Exchange Intro Examples General HTTP Palo Alto Firewall Configuration Case Study Objectives Discussion Advanced Labs Overview Wired Port Authentication 802.1X for access layer switch ports Profiling on Wired Network Configuration of Dynamic Segmentation Aruba Downloadable User Roles Downloadable User Role Enforcement in ClearPass Aruba Controller/Gateway configuration Aruba Switch configuration Troubleshooting
The Data Science (Business and Management) Mini Bundle offers a clever mix of technical and soft skills. You’ll explore core data topics like analysis, Python programming, and SQL—paired with public speaking and communication skills that actually help you talk to people about all that data. This isn’t just about numbers—it’s about knowing what to say when someone asks, “What do these numbers mean?” Whether you’re presenting to a team or querying a database, this course helps you communicate with confidence and clarity while building your technical toolkit for business roles. Learning Outcomes: Analyse datasets using structured, goal-based methods. Write Python code to organise, clean and process information. Understand SQL queries to access and filter relevant data. Present findings clearly using confident verbal communication. Improve workplace discussions through stronger communication habits. Combine data insights with thoughtful business reasoning. Who Is This Course For: Data beginners looking to speak clearly in business meetings. Business analysts needing stronger coding and tech fluency. Professionals handling large datasets and regular reports. Team members presenting technical updates or data reviews. Career changers entering data-focused business environments. Admins juggling between spreadsheets and project discussions. Managers wanting a sharper grasp on data and delivery. Curious learners improving both tech skills and communication. Career Path: Business Analyst – £42,000/year Data Communications Officer – £36,000/year Business Intelligence Assistant – £38,000/year SQL Analyst – £40,000/year Python Data Assistant – £39,000/year Public Speaking Coach (Business Focus) – £34,000/year
The Data Analyst Mini Bundle equips learners with core skills in data analysis and management, including courses on data entry, SQL, Python programming, and Microsoft Access. This bundle is ideal for anyone interested in entering the field of data analytics or enhancing their ability to handle and interpret data effectively. The curriculum focuses on key tools and techniques for collecting, organising, and analysing data. Learners gain a solid foundation in programming languages and software widely used in data roles, enabling confident application of data skills in various industries. Learning Outcomes: Understand data entry methods and accuracy requirements. Learn SQL for managing and querying databases effectively. Study Python basics for data analysis and automation tasks. Explore Microsoft Access for database management and reporting. Develop skills to clean and interpret data sets accurately. Apply analytical thinking to solve data-related problems. Who Is This Course For: Aspiring data analysts wanting to learn key technical tools. Office staff managing data and database tasks. IT professionals looking to expand data analysis skills. Students preparing for careers in data science or analytics. Business professionals aiming to interpret data confidently. Freelancers handling data collection and reporting duties. Individuals interested in programming for data applications. Anyone seeking an online introduction to data analytics. Career Path: Data Analyst – £28,000 to £45,000 SQL Developer – £30,000 to £48,000 Business Intelligence Analyst – £32,000 to £50,000 Data Entry Specialist – £18,000 to £25,000 Python Developer (Data Focus) – £35,000 to £55,000 Database Administrator – £30,000 to £48,000
Course Overview Learn about the functions of Microsoft Azure from this AZ-900 | Microsoft Azure Fundamentals Full Course course. The course will give you a clear understanding of the basics of Microsoft Azure and how you can use this cloud platform to grow and strengthen your online existence. In this AZ-900 | Microsoft Azure Fundamentals Full Course course, you will learn about the tools and basic functions of Microsoft Azure. You will be familiarized with the core Azure services, security, privacy and compliance policies. This course will teach you how you can secure your website and account using multi-factor authentication and protect data from hackers. This course will also help you to understand the supports Azure can offer you and get the best suitable one for you. Microsoft Azure is one of the most popular and safe cloud platforms. This AZ-900 | Microsoft Azure Fundamentals Full Course course will teach you the functions of Microsoft Azure from scratch. You don't need any prior knowledge or technical background to understand the lessons of this course. Learning Outcomes familiarize with the fundamentals of cloud services Understand the benefits of using cloud services Learn about the differences between capital expenditure and operational expenditure Be able to compare and contrast the IAAS, PAAS and SAAS service Learn about different cloud models and how they work Understand the core Azure architectural components Learn about the solutions you will get from Azure Learn about the management tools of Azure Get to know about the security and private privacy protocols of Microsoft Azure Understand how Azure identity services work Familiarize with role-based access control system Understand the policies and compliance standards in Azure Who is this course for? This comprehensive AZ-900 | Microsoft Azure Fundamentals Full Course is ideal for those who want to learn more about the functions of Microsoft Azure. You will learn about the application of Microsoft Azure and the career prospect from this course. 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 AZ-900 | Microsoft Azure Fundamentals Full Course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Managers Managing Directors Management Executives Data Security Officers Programmers Microsoft Azure Developers Technicians Computer Operators Cloud Engineers Cloud Data Consultants Azure Consultants Data Scientists Course Introduction Introduction 00:04:00 Module 1 : Cloud Concepts What is Cloud Computing - I 00:05:00 What is Cloud Computing - II 00:06:00 Benefits of Cloud Computing 00:09:00 Key Concepts and Terminology 00:06:00 Economies of Scale 00:01:00 CapEx Vs OpEx 00:03:00 Cloud Models : What is Public Cloud 00:02:00 Cloud Models : Characteristics of Public Cloud 00:02:00 Cloud Models : What is Private Cloud 00:01:00 Cloud Models : Characteristics of Private Cloud 00:01:00 Cloud Models : Hybrid Cloud 00:01:00 Cloud Models : Characteristics of Hybrid Cloud 00:01:00 Review and What Next!! 00:01:00 What is IAAS 00:04:00 Use Cases of IAAS 00:02:00 What is PAAS ? 00:02:00 Use Cases of PAAS 00:04:00 What is SAAS ? 00:02:00 Cloud Models : Shared Responsibility Model 00:09:00 Module 2 : Core Azure Services Introduction 00:01:00 Azure Regions 00:01:00 Special Azure regions 00:01:00 Region pairs 00:01:00 Feature Availability Region Wise 00:01:00 Availability Zones 00:01:00 Availability Sets 00:02:00 What are Resource Groups? 00:02:00 Azure Resource Manager 00:01:00 What Next!! - Azure Core Services and Products 00:02:00 What is Azure Compute 00:01:00 Azure Virtual Machines - Audiocast Only 00:01:00 Azure Virtual Machines I - LAB 00:15:00 Azure Virtual Machines II - LAB 00:01:00 Azure Virtual Machines III - LAB 00:02:00 Azure Virtual Machines IV - LAB 00:04:00 Azure Virtual Machines V - LAB 00:03:00 Azure Virtual Machines VI - LAB 00:03:00 What are Containers? 00:04:00 Containers ( LAB Activity ) 00:07:00 Containers VS Virtual Machines 00:04:00 What Are Virtual Networks 00:01:00 Virtual Networks - LAB 00:15:00 Azure Load Balancer 00:01:00 VPN Gateway 00:01:00 Azure Application Gateway - I 00:02:00 Azure Application Gateway - II 00:01:00 Azure Content Delivery Networks (CDN's) 00:02:00 How CDN works ? 00:03:00 Azure CDN - Lab Activity 00:07:00 Azure Storage Services 00:01:00 Structured Data 00:01:00 Semi Structured Data 00:01:00 Unstructured Data 00:01:00 Azure Storage Account - Types 00:03:00 Azure Storage Account - Blob - Lab Activity - I 00:07:00 Azure Storage Account - Blog - Lab Activity - II 00:07:00 Azure Storage Account - Blob - Lab Activity - III 00:16:00 Azure Storage Account - Blog - Lab Activity - IV 00:09:00 Azure Storage Account - Blob - Lab Activity - V 00:04:00 Azure Storage Account - Blob - Lab Activity - VI 00:07:00 Azure Database Services 00:02:00 Azure SQL - Lab Demo 00:09:00 Azure MarketPlace 00:02:00 What is Internet of Things ( IOT ) - Intro 00:01:00 IOT Hub 00:01:00 IOT Hub Demo 00:09:00 Azure Big Data and Analytics 00:01:00 Azure SQL Data Warehouse 00:01:00 Azure HDInsights 00:01:00 Azure Data Lake Analytics 00:01:00 Machine Learning 00:02:00 Azure Machine Learning Services and Studio 00:02:00 What is Server less Computing ? 00:02:00 The concept of DevOps 00:03:00 Azure Management Tools 00:01:00 Creating Resources with Powershell - Lab Activity 00:05:00 Creating Resources with Azure CLI - Lab Activity 00:07:00 Provision Resources using Cloud Shell - Lab Activity 00:05:00 Deployment with JSON - Lab Activity 00:08:00 Azure Advisor 00:01:00 Module 2 : What did we learn 00:01:00 Module 3 Security, Privacy, Compliance and Trust What to expect in Module 3 00:01:00 Azure Firewalls 00:02:00 Azure Firewall - Lab Activity - notes 00:02:00 Azure Firewall - Lab Activity 00:19:00 Azure DDOS 00:02:00 Network Security Groups 00:03:00 Application Security Groups 00:02:00 Which Network Security Solution to choose from ? 00:04:00 AuthZ and AuthN 00:01:00 Azure Active Directory 00:02:00 Multi Factor Authentication 00:03:00 Azure Security Center 00:02:00 Azure Security center - LAB activity 00:08:00 Azure Key Vault 00:02:00 Azure Information Protection 00:02:00 Azure Advanced Threat Protection 00:04:00 What is Azure Policy 00:03:00 Azure Policy - Lab Activity 00:06:00 Azure Role Based Access Control ( RBAC ) 00:02:00 Azure Role Based Access Control ( RBAC ) - Lab Activity 00:07:00 Azure Locks 00:01:00 Azure Locks - Lab Activity 00:02:00 Azure Blueprints 00:01:00 Subscription Governance 00:02:00 Azure Tags 00:03:00 Azure Monitoring 00:02:00 Azure Monitor- Lab Activity 00:03:00 Azure Service Health 00:01:00 Monitoring Applications and Services 00:04:00 Compliance Terms and Requirements 00:02:00 Microsoft Privacy Statement 00:01:00 Microsoft Trust Center 00:01:00 Service Trust Portal 00:01:00 Azure Government Services 00:02:00 Azure Germany Services 00:01:00 Azure China 21Vianet 00:02:00 Module 4 : Azure Pricing and Support Module 4 Introduction : What tÌ¥o expect in this module 00:02:00 Azure Subscriptions 00:06:00 What are Management Groups 00:01:00 Purchase Azure Product & Services : Available Options 00:01:00 Usage Metrics 00:01:00 Factors Affecting Costs 00:02:00 The concept of Zones for Billing 00:02:00 Azure Pricing Calculator 00:04:00 Azure Total Cost of Ownership ( TCO ) 00:02:00 Ways to Minimize Costs in Azure 00:04:00 Azure Cost Management 00:02:00 Azure Support Plans 00:03:00 Alternative Support Options 00:02:00 Service Level Agreements ( SLA's ) 00:03:00 Composite SLA's 00:03:00 Improving Application SLA's 00:04:00 Public and Preview Features 00:01:00 Providing Feedback 00:01:00 General Availability 00:01:00 Azure Updates , Announcements and Roadmaps 00:01:00 Course Conclusion Course Conclusion 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
The Data Science: Data Analyst Mini Bundle is made for those who prefer evidence over guesswork. With key topics including Data Analysis, SQL, Python, Project Management, and MS Excel, this collection gives you a balanced mix of logic, organisation, and data literacy—all without trying to teach you twenty things at once. Whether you're managing a project or wrangling a CSV file, this course bundle is your sensible step toward making decisions based on something more reliable than a hunch. It’s suitable for career starters, team members, or those just trying to figure out what on earth a pivot table actually does. Learning Outcomes: Understand how to analyse and interpret structured data sets. Use SQL for database queries and data manipulation tasks. Write Python code to simplify and clean large datasets. Work efficiently with Excel for data calculation and graphs. Apply data knowledge in structured project workflows. Improve confidence in working with numbers and logic. Who Is This Course For: Aspiring analysts looking for a strong entry-level foundation. Team members working with spreadsheets and basic datasets. Managers wanting to understand what the analysts are saying. Graduates targeting data-related office positions. Freelancers exploring tech-focused client projects. Job seekers needing stronger data confidence and skill sets. People who enjoy patterns, statistics, or tidy spreadsheets. Anyone who’s been told to “check the numbers” again. Career Path: Junior Data Analyst – £30,000/year Python Programmer – £40,000/year SQL Data Developer – £42,000/year Project Analyst – £35,000/year Excel Data Specialist – £32,000/year Data Administrator – £34,000/year
This Microsoft Power BI course will help you become a Power BI expert. It'll enhance your skills by offering you comprehensive knowledge on Power BI Desktop and Power BI Online, and unleash the capabilities of Power BI to perform a comprehensive analysis of data from multiple sources and present the data using the perfect visualization.
Duration 3 Days 18 CPD hours This course is intended for This course is intended for: Database architects Database administrators Database developers Data analysts and scientists Overview This course is designed to teach you how to: Discuss the core concepts of data warehousing, and the intersection between data warehousing and big data solutions Launch an Amazon Redshift cluster and use the components, features, and functionality to implement a data warehouse in the cloud Use other AWS data and analytic services, such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3, to contribute to the data warehousing solution Architect the data warehouse Identify performance issues, optimize queries, and tune the database for better performance Use Amazon Redshift Spectrum to analyze data directly from an Amazon S3 bucket Use Amazon QuickSight to perform data analysis and visualization tasks against the data warehouse Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. This course demonstrates how to collect, store, and prepare data for the data warehouse by using other AWS services such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3. Additionally, this course demonstrates how to use Amazon QuickSight to perform analysis on your data Module 1: Introduction to Data Warehousing Relational databases Data warehousing concepts The intersection of data warehousing and big data Overview of data management in AWS Hands-on lab 1: Introduction to Amazon Redshift Module 2: Introduction to Amazon Redshift Conceptual overview Real-world use cases Hands-on lab 2: Launching an Amazon Redshift cluster Module 3: Launching clusters Building the cluster Connecting to the cluster Controlling access Database security Load data Hands-on lab 3: Optimizing database schemas Module 4: Designing the database schema Schemas and data types Columnar compression Data distribution styles Data sorting methods Module 5: Identifying data sources Data sources overview Amazon S3 Amazon DynamoDB Amazon EMR Amazon Kinesis Data Firehose AWS Lambda Database Loader for Amazon Redshift Hands-on lab 4: Loading real-time data into an Amazon Redshift database Module 6: Loading data Preparing Data Loading data using COPY Data Warehousing on AWS AWS Classroom Training Concurrent write operations Troubleshooting load issues Hands-on lab 5: Loading data with the COPY command Module 7: Writing queries and tuning for performance Amazon Redshift SQL User-Defined Functions (UDFs) Factors that affect query performance The EXPLAIN command and query plans Workload Management (WLM) Hands-on lab 6: Configuring workload management Module 8: Amazon Redshift Spectrum Amazon Redshift Spectrum Configuring data for Amazon Redshift Spectrum Amazon Redshift Spectrum Queries Hands-on lab 7: Using Amazon Redshift Spectrum Module 9: Maintaining clusters Audit logging Performance monitoring Events and notifications Lab 8: Auditing and monitoring clusters Resizing clusters Backing up and restoring clusters Resource tagging and limits and constraints Hands-on lab 9: Backing up, restoring and resizing clusters Module 10: Analyzing and visualizing data Power of visualizations Building dashboards Amazon QuickSight editions and feature
IT Cyber Security Engineer – Job Ready Programme Enrol in Our IT Cyber Security Engineer – Job Ready Programme with Career Support! Gain access to 3,000+ online courses and earn Free Certificates to showcase your skills and boost your career potential. Step into the high-demand world of cyber security with a comprehensive programme designed for the UK job market. Master critical areas like penetration testing, secure cloud architecture, AI-powered threat detection, and GDPR compliance—skills that can lead to roles earning up to £95,000 a year. As UK businesses face £27 billion in cybercrime losses annually, the demand for skilled IT Cyber Security Engineers has never been greater. Whether you're changing careers or upskilling, this course equips you with in-demand expertise in threat intelligence, cryptography, and secure coding. Become the digital defence every company needs. Start your journey toward a resilient and rewarding career in cyber security today. Professional Diploma in IT Cyber Security Engineer – 25 Core Courses – Course 01: Cyber Security Online Course: DOSS and DDOS – Course 02: Cyber Security Training: Incident Handling & Response – Course 03: Security Threat Management – Course 04: Certified Information Security Manager (CISM) – Course 05: Certified Information Systems Security Professional (CISSP) – Course 06: CompTIA Advanced Security Practitioner (CASP) – Course 07: Computer Network Security Complete Training – Course 08: CyberSec First Responder: Threat Detection and Response [QLS Level 7] – Course 09: Bash Scripting and Shell Programming for Beginners – Course 10: Ethical Hacking Masterclass – Course 11: CompTIA PenTest+ Ethical Hacking Course – Course 12: BlackArch Linux: Ethical Hacking and Penetration Testing – Course 13: Ultimate Linux Security and Hardening Training – Course 14: The Complete Python Hacking Course: Beginner to Advanced! – Course 15: SQL Database Basics – Course 16: CompTIA Network+ Certification (N10-008) – Course 17: CompTIA A+ Core 1 (220-1101) Course – Course 18: CompTIA A+ Core 2 (220-1102) Course – Course 19: CompTIA Security+ (SY0-601) – Course 20: CompTIA Cloud+ CV0-002 Course – Course 21: Cisco CCENT/CCNA Interconnecting Cisco Networking Devices Part 1 – Course 22: Cisco CCNA Interconnecting Cisco Networking Devices Part 2 (ICND2) Training – Course 23: Cisco ASA Firewall Training with Step-by-Step Lab Workbook – Course 24: FortiGate Firewall Training Step-by-Step Lab Workbook – Course 25: Palo Alto Firewall Training with Step-by-Step Lab Workbook Job Readiness & Career Development Training (Complementary) – Course 01: Career Development Training – Course 02: Effective CV Writing – Course 03: CV Writing and Interview Tricks – Course 04: Ace the Interview – Interview Prep That Makes a Difference – Course 05: Job Search Skills – Course 06: Effective Communication Skills for Professionals – Course 07: Boost Your Confidence, Assertiveness – Course 08: Body Language Secrets – Course 09: Coaching and Mentoring – Course 10: Presentation Skills – Present like a Pro – Course 11: Public Speaking Course – Course 12: Project Management Training – Course 13: Leadership & Management – Course 14: Negotiation and Agreement Training – Course 15: Workplace Equality & Diversity – Course 16: Professional Development and Personal Well-being – Course 17: Emotional Intelligence and Human Behaviour – Course 18: Time Management: Step By Step Training – Course 19: Cross-Cultural Awareness – Course 20: Productivity Boosting – Course 21: Critical Thinking & Problem Solving – Course 22: Perfect LinkedIn Profile Creation – Course 23: Resume Writing Skills & Job Search With LinkedIn – Course 24: Email Writing – Course 25: Learn Microsoft Word, PowerPoint & Outlook In 90 Minutes!
Overview This comprehensive course on Ruby on Rails 5 - Become a Professional Developer will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Ruby on Rails 5 - Become a Professional Developer comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Ruby on Rails 5 - Become a Professional Developer. It is available to all students, of all academic backgrounds. Requirements Our Ruby on Rails 5 - Become a Professional Developer is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 23 sections • 225 lectures • 16:47:00 total length •Course Introduction: 00:06:00 •The Application We're Going to Build: 00:09:00 •Section Introduction gg: 00:01:00 •Introduction to the Command Line Interface in Mac and Linux: 00:10:00 •Installing the X-Code Command Line Tools for Mac: 00:02:00 •Installing Git for Source Code Version Control: 00:03:00 •How to install Homebrew on a Mac: 00:04:00 •Installing GPG Security Systems on a Mac: 00:02:00 •Guide to RVM for Ruby Management: 00:09:00 •Configuring RubyGems and Installing Rails: 00:07:00 •Installing the Postgres Database on a Mac: 00:05:00 •Installing and Working with the Sublime Text Editor: 00:17:00 •Deep Dive into the Command Line - Part 1 of 2: 00:14:00 •Deep Dive into the Command Line - Part 2 of 2: 00:12:00 •PC Environment Setup: Installing Virtual Box: 00:03:00 •Guide to Installing Ubuntu Linux in VirtualBox: 00:10:00 •How to Reboot a Linux Virtual Machine from Terminal: 00:02:00 •Installing Desktop Applications and Ubuntu Navigation Tips and Tricks: 00:09:00 •How to Sign Up for a GitHub Account: 00:03:00 •How to install Git on Linux and Connect to GitHub via SSH: 00:20:00 •How to Securely Install Node and NPM on Linux via NVM: 00:09:00 •Installing the Heroku CLI and the Full Deployment Lifecycle: 00:14:00 •How to install and Work with Sublime Text in Linux: 00:08:00 •PC Setup: Guide for Ruby on Rails and Postgres on Linux - Part 1 of 2: 00:10:00 •PC Setup: Guide for Ruby on Rails and Postgres on Linux - Part 2 of 2: 00:15:00 •Fixing the Role Does Not Exist Error: 00:05:00 •Section Introduction ee: 00:01:00 •Signing Up for a Project Management Account: 00:03:00 •Managing the Project Management Dashboard: 00:08:00 •Importing Project Management Tasks into Pivotal Tracker: 00:01:00 •Creating a Rails Application: 00:11:00 •Generating a Blog for the Portfolio Application Using Rails Scaffolds: 00:11:00 •Analyzing the Rails Process: Index and Show Actions: 00:12:00 •Analyzing the Rails Process: New, Create, Update, Edit, and Destroy Actions: 00:14:00 •Analyzing the Rails Process: Routing with Resources: 00:07:00 •Rails File System Overview: 00:13:00 •Updating the Project Management Dashboard: 00:01:00 •Deep Dive: Analyzing the Application Generator - Part 1: 00:12:00 •Deep Dive: Analyzing the Application Generator - Part 2: 00:17:00 •Section Introduction bb: 00:02:00 •How to Sign Up for a Github Account: 00:03:00 •Generating SSH Keys to Securely Communicate with Github: 00:04:00 •Guide to GitHub: 00:12:00 •How to Update a .gitignore File to Securely Store Secret Credentials: 00:11:00 •Guide to the Markdown Syntax: 00:10:00 •Updating the Git Sprint in the Project Management Dashboard: 00:01:00 •Deep Dive: Analyzing Version Control and Git - Part 1: 00:18:00 •Deep Dive: Analyzing Version Control and Git - Part 2: 00:13:00 •Section Introduction aa: 00:01:00 •Guide to the Rails Controller Generator to Build Pages Part 1: 00:16:00 •Guide to the Rails Controller Generator to Build Pages Part 2: 00:05:00 •Guide to the Rails Model Generator to Build out Data Specific Features: 00:17:00 •Guide to the Rails Model Generator for Building Out the Portfolio Feature: 00:10:00 •Deep Dive: Analyze Rails Generators and How to Customize a Generator - Part 1: 00:15:00 •Deep Dive: Analyze Rails Generators and How to Customize a Generator - Part 2: 00:11:00 •Section Introduction SS: 00:02:00 •Building out a Seeds File for Generating Dynamic Sample Data: 00:15:00 •Implement an Index Action from Scratch in Rails: 00:12:00 •Build the New and Create Functionality from Scratch in Rails: 00:20:00 •Implement the Ability to Edit Database Records from Scratch in Rails: 00:13:00 •How to Use the Link to Method in Rails for Creating Dynamic Links: 00:13:00 •How to Implement the Show Action from Scratch in Rails: 00:12:00 •Building the Ability to Delete Items in Rails: 00:15:00 •How to Implement Custom Routes for Pages in Rails: 00:09:00 •How to Override the Rails Resources Routes for the Show Action: 00:07:00 •How to Implement Permalinks in a Rails Application - Part 1: 00:17:00 •How to Implement Permalinks in a Rails Application - Part 2: 00:05:00 •How to Use Enums in Rails to Manage Data Stages: 00:13:00 •How to Implement a Custom Action in Rails via a Button Click - Part 1: 00:12:00 •How to Implement a Custom Action in Rails via a Button Click - Part 2: 00:10:00 •Updating the Project Management Dashboard and Performing a Pull Request: 00:05:00 •Deep Dive: Rails Routing and Data Flow - Part 1: 00:13:00 •Deep Dive: Rails Routing and Data Flow - Part 2: 00:13:00 •Deep Dive: Rails Routing and Data Flow - Part 3: 00:16:00 •Section Introduction RR: 00:01:00 •Implementing Data Validations in Rails 5: 00:12:00 •Guide to Data Relationships in Rails: 00:16:00 •How to Implement Custom Scopes in Rails 5: 00:16:00 •How to Set Default Values in Rails 5: 00:13:00 •How to Use Concerns in Rails 5: 00:13:00 •Building an Additional Parent/Child Relationship in Rails 5: 00:10:00 •Rails 5 Complex Forms: Configuring Nested Attributes in the Model: 00:17:00 •Rails 5 Complex Forms: Configuring Nested Attributes in the Form: 00:17:00 •Deep Dive: Working with SQL and ActiveRecord in Rails 5 - Part 1: 00:16:00 •Deep Dive: Working with SQL and ActiveRecord in Rails 5 - Part 2: 00:14:00 •Deep Dive: Working with SQL and ActiveRecord in Rails 5 - Part 3: 00:15:00 •Section Introduction QQ: 00:01:00 •How to Install Devise in Rails 5: 00:08:00 •Using Devise to Implement Registrations and Login Functionality: 00:18:00 •Building Custom Routes for Authentication Pages with Devise in Rails 5: 00:03:00 •Enable Users to Logout and Dynamically Render View Content in Rails 5: 00:07:00 •How to Add Custom Attributes to a Devise Based Authentication System: 00:15:00 •How to Use Controller Concerns in Rails 5 for Devise Custom Attributes: 00:15:00 •Integrate Virtual Attributes to Extract First and Last Name Data from a User: 00:17:00 •Deep Dive: Using BCrypt to Implement Encryption in Ruby: 00:19:00 •Section Introduction PP: 00:01:00 •Rails Data Flow Review and Working with Params: 00:14:00 •Using Rails Sessions to Share Data between Pages: 00:19:00 •Refactoring the Session Tracker into a Controller Concern: 00:07:00 •Working with Strong Params in a Rails 5 Controller: 00:13:00 •Deep Dive: Building a Guest User Feature in Rails - Part 1: 00:14:00 •Deep Dive: Building a Guest User Feature in Rails - Part 2: 00:18:00 •Section Introduction OO: 00:03:00 •How to Customize the Rails Master Layout File - Part 1: 00:15:00 •How to Customize the Rails Master Layout File - Part 2: 00:09:00 •Guide to Using Multiple Layout Files in Rails 5: 00:14:00 •Introduction to Rendering Collections via Partials in Rails 5: 00:09:00 •Introduction to Partials in Rails 5: 00:08:00 •How to Send Data to Partials to Generate Custom Behavior in Rails 5: 00:15:00 •Guide to View Helpers in Rails 5: 00:17:00 •How to Use the Rails Content Tag Helper to Auto Generate HTML Code: 00:15:00 •Introduction to Rendering Collections via Partials in Rails 5: 00:09:00 •Guide to Manually Configuring Partials to Work with Collections in Rails: 00:07:00 •Guide to Helpful ActionView Helper Methods in Rails 5: 00:15:00 •Deep Dive: Tips and Tricks to Working with ActionView in Rails 5 - Part 1: 00:12:00 •Deep Dive: Tips and Tricks to Working with ActionView in Rails 5 - Part 2: 00:15:00 •Section Introduction NN: 00:01:00 •How to Utilize Puts Debugging in Rails: 00:08:00 •Guide to Byebug in Rails 5: 00:09:00 •Guide to Debugging with Pry in Rails 5: 00:19:00 •Proper Way to Implement Error Management in a Rails Application - Part 1: 00:15:00 •Proper Way to Implement Error Management in a Rails Application - Part 2: 00:06:00 •Section Introduction MM: 00:01:00 •How to Install Bootstrap 4 into a Rails 5 Application - Part 1: 00:10:00 •How to Install Bootstrap 4 into a Rails 5 Application - Part 2: 00:12:00 •Section Strategy for Building a Custom RubyGem: 00:11:00 •How to Build a RubyGem from Scratch - Part 1: 00:06:00 •How to Build a RubyGem from Scratch - Part 2: 00:15:00 •Section Introduction hh: 00:02:00 •Introduction to Authorization and How to Install the Petergate Gem: 00:08:00 •How to Add Roles to the User Model in Rails 5: 00:05:00 •Guide to Implementing Petergate in Rails 5 Application - Part 1: 00:15:00 •Guide to Implementing Petergate in Rails 5 Application - Part 2: 00:12:00 •Workplace Facilities: 00:35:00 •Portfolio Design Planning for Layout Specific Styles: 00:09:00 •Implementing the Initial Homepage Design in Rails 5 with Bootstrap 4: 00:09:00 •Building a Navigation Partial for the Master Application Layout with Bootstrap: 00:11:00 •Implement a Footer Along with Adding Method Arguments to a Rails View Helper: 00:14:00 •How to Embed a Google Map into a Rails Application: 00:06:00 •Guide to Updating the Styles for the Devise Edit Account Page in Rails: 00:16:00 •How to Override Default Bootstrap Styles for Text Alignment in the Card Class: 00:06:00 •Implementing Styles for the Devise Registration Page with Bootstrap 4: 00:14:00 •How to Design the Login and Password Pages with Bootstrap 4 Form Styles: 00:15:00 •How to Set Default Values for View Helper Method Arguments in Rails 5: 00:04:00 •Integrating a Different Design for a Separate Blog Layout in Rails 5: 00:04:00 •How to Use Bootstrap 4 to Add a Custom Nav Bar to a Blog Layout in Rails: 00:07:00 •Customizing the Design for the Blog Index Page with Bootstrap 4: 00:19:00 •Guide to Adding Styles to the Blog Show and Form Pages with Bootstrap 4: 00:12:00 •Implementing Partials, Pagination, and Font Awesome Icons - Part 1: 00:23:00 •Implementing Partials, Pagination, and Font Awesome Icons - Part 2: 00:23:00 •Initial Design for the Portfolio Index Page with Bootstrap 4: 00:17:00 •Integrating the Portfolio Animated Navigation Slider, Footer, and Index: 00:14:00 •Using the Bootstrap 4 Grid Layout to Style the Portfolio Show Page in Rails: 00:06:00 •Implementing Bootstrap 4 Forms for the Portfolio Form Pages: 00:13:00 •How to Build a View Helper to Dynamically Generate a Nav Bar - Part 1: 00:20:00 •How to Build a View Helper to Dynamically Generate a Nav Bar - Part 2: 00:19:00 •Deep Dive: Rails Asset Pipeline Part 1: 00:01:00 •Deep Dive: Rails Asset Pipeline Part 2: 00:19:00 •Section Introduction LL: 00:01:00 •How to Integrate a Position Attribute and Custom Scope in Rails: 00:12:00 •Installing the jQuery UI and html5sortable JavaScript Libraries in Rails 5: 00:09:00 •Initial Implementation of Drag and Drop Interface in Rails 5: 00:13:00 •Implementing Drag and Drop Functionality into a Ruby on Rails 5 App Part 1: 00:18:00 •Implementing Drag and Drop Functionality into a Ruby on Rails 5 App Part 2: 00:11:00 •Implementing Authorization Rules for Drag and Drop Feature with Petergate: 00:07:00 •Deep Dive: jQuery CoffeeScript in Rails: 00:19:00 •Section Introduction jj: 00:01:00 •Introduction to Using Images and the Rails Asset Pipeline: 00:12:00 •How to Set a Full Size Video Background in Rails with Bootstrap 4: 00:08:00 •Deep Dive: Installing and Configuring Carrierwave for Image Uploads in Rails 5: 00:20:00 •Deep Dive: Integrating Connection to AWS S3 for File Hosting with Carrierwave: 00:14:00 •Implementing File Upload Button Styles and Refactoring Placeholder - Part 1: 00:06:00 •Implementing File Upload Button Styles and Refactoring Placeholder - Part 2: 00:19:00 •Section Introduction ii: 00:01:00 •Difference Between form_form and form_tag in Rails - Part 1: 00:15:00 •Difference Between form_form and form_tag in Rails - Part 2: 00:16:00 •How to Integrate Cocoon in Rails 5 for jQuery Nested Forms: 00:20:00 •Guide to Integrating Alerts that Automatically Fade Away in Rails 5: 00:15:00 •Refactoring Alert Notifications to Use a Shared View Helper in Rails: 00:13:00 •Deep Dive: How to Build an HTML Form from Scratch the Works with Rails: 00:17:00 •Section Introduction ff: 00:03:00 •Integrating the Twitter Gem to Pull in Tweets in Rails 5: 00:20:00 •How to Render Tweets on a Rails View Page: 00:07:00 •Building a Parser View Helper Method to Make Twitter Links Clickable in Rails: 00:15:00 •Customizing the Styles for the Tech News Page with Bootstrap 4: 00:07:00 •Section Introduction cc: 00:01:00 •Running the Comment Generator and Installing the NoSQL Redis Database in Rails 5: 00:18:00 •Building the Comment Form and Required Controller Actions - Part 1: 00:14:00 •Building the Comment Form and Required Controller Actions - Part 2: 00:08:00 •Refactoring the Comment Form into a Partial and Implementing Data Validations: 00:05:00 •Building the jQuery Functions for Processing Comments - Part 1: 00:19:00 •Building the jQuery Functions for Processing Comments - Part 2: 00:05:00 •How to Create a Broadcast with ActionCable in Rails 5: 00:14:00 •Guide to Implementing Live Data Updates in a Rails 5 Application - Part 1: 00:15:00 •Guide to Implementing Live Data Updates in a Rails 5 Application - Part 2: 00:06:00 •Styling the Comment Section and Implementing Gravatar Based Thumbnails in Rails: 00:16:00 •Section Introduction dd: 00:01:00 •Planning Final Project Updates and Assignment: 00:11:00 •Building a Scope to Show the Most Recent Blog Posts and Hiding Draft Posts: 00:09:00 •Hiding the Show Page for Blogs in Draft Mode in Rails 5: 00:04:00 •How to Add a Drop Down Form Element in Rails 5 for Parent/Child Relationships: 00:09:00 •Using the Controller Generator to Build the Topic Features - Part 1: 00:10:00 •Using the Controller Generator to Build the Topic Features - Part 2: 00:11:00 •How to Build a Widget for the Blog to Render Topics in Rails 5: 00:17:00 •How to Implement Radio Buttons in a Rails Form to Update Enum Values: 00:09:00 •Guide to Integrating Markdown and Syntax Highlighting in a Rails 5 Application: 00:13:00 •Integrating Breadcrumbs and Icons for the Blog Show Pages: 00:12:00 •Building a Partial for Managing Admin Actions for Blog Posts: 00:15:00 •How to Implement a Responsive Navigation Bar with Bootstrap 4: 00:11:00 •Updating the Source/Session Tracking System for the New Layouts: 00:14:00 •How to Integrate a Favicon in Rails 5: 00:08:00 •Implementing Responsive Image Components for the Portfolio Layout: 00:06:00 •Adding Card Styles to the About and Contact Pages: 00:09:00 •How to Implement Collapsable Content Components in a Rails 5 Application: 00:09:00 •How to Integrate Bootstrap Progress Bars in a Rails Application: 00:13:00 •How to Integrate Custom Fonts in a Rails 5 Application: 00:17:00 •Updating the Seeds File in Rails: 00:07:00 •Signing Up for and Creating a New Heroku Application: 00:04:00 •How to Deploy a Rails 5 Application to Heroku: 00:13:00 •Working with the Rails Console on Heroku: 00:11:00 •Installing Redis on Heroku for ActionCable Commenting Feature: 00:04:00 •Configuring Action Cable to Work on Heroku: 00:11:00 •How to Implement the Typed.js Library into a Rails 5 Application: 00:12:00 •How to Install and Configure Webpack, Yarn, and jQuery into a Rails 5.1+ App: 00:19:00 •How to Work with Encrypted Credentials in Rails 5.2+: 00:24:00