347 Computing Skills courses

Overview This comprehensive course on CompTIA IT Fundamentals ITF+ (FCO-U61) will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This CompTIA IT Fundamentals ITF+ (FCO-U61) 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 CompTIA IT Fundamentals ITF+ (FCO-U61). It is available to all students, of all academic backgrounds. Requirements Our CompTIA IT Fundamentals ITF+ (FCO-U61) 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 15 sections • 64 lectures • 04:55:00 total length •Introduction to IT Fundamentals: 00:03:00 •The Case for Computer Literacy: 00:03:00 •Features Common to Every Computing Device: 00:02:00 •Common General-Purpose Computing Devices: 00:02:00 •Networks of Computing Devices: 00:04:00 •Remotely-Accessed Computer Systems: 00:04:00 •Specialized Computer Systems: 00:02:00 •Specialty I/O Devices: 00:01:00 •CPUs: 00:03:00 •Passive and Active Cooling: 00:03:00 •RAM and Active Memory: 00:05:00 •Motherboards: 00:03:00 •Power Supplies: 00:03:00 •AMA - Ask Me Anything about System Hardware: 00:07:00 •Ports and Connectors: 00:03:00 •General Use I/O Devices: 00:02:00 •AMA - Ask Me Anything about I/O, Ports and Peripherals: 00:07:00 •Basics of Binary: 00:04:00 •Storage Technologies: 00:04:00 •Mass Storage Variation: 00:03:00 •AMA - Ask Me Anything about Data Storage and Sharing: 00:07:00 •Operating System Functions: 00:04:00 •Operating System Interfaces: 00:05:00 •AMA - Ask Me Anything about Understanding OS's: 00:05:00 •Preparing the Work Area: 00:02:00 •Setting up a Desktop PC: 00:01:00 •Completing PC Setup: 00:04:00 •AMA - Ask Me Anything about Setting up and Configuring a PC: 00:09:00 •Personalizing a Tablet: 00:08:00 •AMA - Ask Me Anything about Mobile Devices Part 1: 00:07:00 •AMA - Ask Me Anything about Mobile Devices Part 2: 00:07:00 •File Management Tools: 00:02:00 •File Manipulation: 00:06:00 •Backups: 00:03:00 •AMA - Ask Me Anything about Managing Files: 00:08:00 •Walking Survey of Applications: 00:03:00 •Managing Applications: 00:03:00 •Applications and Extensions: 00:04:00 •AMA - Ask Me Anything about Working with Applications: 00:07:00 •Wi-Fi Setup: 00:06:00 •Going High Speed: 00:03:00 •Setting Up and Sharing Printers: 00:05:00 •AMA - Ask Me Anything about Networks and Internet Connectivity Part 1: 00:07:00 •AMA - Ask Me Anything about Networks and Internet Connectivity Part 2: 00:05:00 •Physical Security: 00:05:00 •Dealing with Malware: 00:03:00 •Password Management: 00:03:00 •Clickworthy: 00:03:00 •Perils of Public Internet: 00:02:00 •AMA - Ask Me Anything about IT Threat Mitigation Part 1: 00:07:00 •AMA - Ask Me Anything about IT Threat Mitigation Part 2: 00:08:00 •Power Management: 00:02:00 •Cleaning and Maintaining Computers: 00:02:00 •Trash it or Stash it?: 00:02:00 •AMA - Ask Me Anything about Computer Maintenance and Management: 00:11:00 •Troubleshooting 101: 00:03:00 •AMA - Ask Me Anything about Troubleshooting Computers Part 1: 00:10:00 •AMA - Ask Me Anything about Troubleshooting Computers Part 2: 00:11:00 •Introduction to Databases: 00:06:00 •Database Details: 00:06:00 •AMA - Ask Me Anything about Databases: 00:06:00 •Introduction to Programming: 00:04:00 •Programming with a PBJ Sandwich: 00:08:00 •AMA - Ask Me Anything about Programming: 00:04:00

Overview This comprehensive course on SQL NoSQL Big Data and Hadoop will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This SQL NoSQL Big Data and Hadoop 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? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this SQL NoSQL Big Data and Hadoop. It is available to all students, of all academic backgrounds. Requirements Our SQL NoSQL Big Data and Hadoop 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 14 sections • 130 lectures • 22:34:00 total length •Introduction: 00:07:00 •Building a Data-driven Organization - Introduction: 00:04:00 •Data Engineering: 00:06:00 •Learning Environment & Course Material: 00:04:00 •Movielens Dataset: 00:03:00 •Introduction to Relational Databases: 00:09:00 •SQL: 00:05:00 •Movielens Relational Model: 00:15:00 •Movielens Relational Model: Normalization vs Denormalization: 00:16:00 •MySQL: 00:05:00 •Movielens in MySQL: Database import: 00:06:00 •OLTP in RDBMS: CRUD Applications: 00:17:00 •Indexes: 00:16:00 •Data Warehousing: 00:15:00 •Analytical Processing: 00:17:00 •Transaction Logs: 00:06:00 •Relational Databases - Wrap Up: 00:03:00 •Distributed Databases: 00:07:00 •CAP Theorem: 00:10:00 •BASE: 00:07:00 •Other Classifications: 00:07:00 •Introduction to KV Stores: 00:02:00 •Redis: 00:04:00 •Install Redis: 00:07:00 •Time Complexity of Algorithm: 00:05:00 •Data Structures in Redis : Key & String: 00:20:00 •Data Structures in Redis II : Hash & List: 00:18:00 •Data structures in Redis III : Set & Sorted Set: 00:21:00 •Data structures in Redis IV : Geo & HyperLogLog: 00:11:00 •Data structures in Redis V : Pubsub & Transaction: 00:08:00 •Modelling Movielens in Redis: 00:11:00 •Redis Example in Application: 00:29:00 •KV Stores: Wrap Up: 00:02:00 •Introduction to Document-Oriented Databases: 00:05:00 •MongoDB: 00:04:00 •MongoDB Installation: 00:02:00 •Movielens in MongoDB: 00:13:00 •Movielens in MongoDB: Normalization vs Denormalization: 00:11:00 •Movielens in MongoDB: Implementation: 00:10:00 •CRUD Operations in MongoDB: 00:13:00 •Indexes: 00:16:00 •MongoDB Aggregation Query - MapReduce function: 00:09:00 •MongoDB Aggregation Query - Aggregation Framework: 00:16:00 •Demo: MySQL vs MongoDB. Modeling with Spark: 00:02:00 •Document Stores: Wrap Up: 00:03:00 •Introduction to Search Engine Stores: 00:05:00 •Elasticsearch: 00:09:00 •Basic Terms Concepts and Description: 00:13:00 •Movielens in Elastisearch: 00:12:00 •CRUD in Elasticsearch: 00:15:00 •Search Queries in Elasticsearch: 00:23:00 •Aggregation Queries in Elasticsearch: 00:23:00 •The Elastic Stack (ELK): 00:12:00 •Use case: UFO Sighting in ElasticSearch: 00:29:00 •Search Engines: Wrap Up: 00:04:00 •Introduction to Columnar databases: 00:06:00 •HBase: 00:07:00 •HBase Architecture: 00:09:00 •HBase Installation: 00:09:00 •Apache Zookeeper: 00:06:00 •Movielens Data in HBase: 00:17:00 •Performing CRUD in HBase: 00:24:00 •SQL on HBase - Apache Phoenix: 00:14:00 •SQL on HBase - Apache Phoenix - Movielens: 00:10:00 •Demo : GeoLife GPS Trajectories: 00:02:00 •Wide Column Store: Wrap Up: 00:05:00 •Introduction to Time Series: 00:09:00 •InfluxDB: 00:03:00 •InfluxDB Installation: 00:07:00 •InfluxDB Data Model: 00:07:00 •Data manipulation in InfluxDB: 00:17:00 •TICK Stack I: 00:12:00 •TICK Stack II: 00:23:00 •Time Series Databases: Wrap Up: 00:04:00 •Introduction to Graph Databases: 00:05:00 •Modelling in Graph: 00:14:00 •Modelling Movielens as a Graph: 00:10:00 •Neo4J: 00:04:00 •Neo4J installation: 00:08:00 •Cypher: 00:12:00 •Cypher II: 00:19:00 •Movielens in Neo4J: Data Import: 00:17:00 •Movielens in Neo4J: Spring Application: 00:12:00 •Data Analysis in Graph Databases: 00:05:00 •Examples of Graph Algorithms in Neo4J: 00:18:00 •Graph Databases: Wrap Up: 00:07:00 •Introduction to Big Data With Apache Hadoop: 00:06:00 •Big Data Storage in Hadoop (HDFS): 00:16:00 •Big Data Processing : YARN: 00:11:00 •Installation: 00:13:00 •Data Processing in Hadoop (MapReduce): 00:14:00 •Examples in MapReduce: 00:25:00 •Data Processing in Hadoop (Pig): 00:12:00 •Examples in Pig: 00:21:00 •Data Processing in Hadoop (Spark): 00:23:00 •Examples in Spark: 00:23:00 •Data Analytics with Apache Spark: 00:09:00 •Data Compression: 00:06:00 •Data serialization and storage formats: 00:20:00 •Hadoop: Wrap Up: 00:07:00 •Introduction Big Data SQL Engines: 00:03:00 •Apache Hive: 00:10:00 •Apache Hive : Demonstration: 00:20:00 •MPP SQL-on-Hadoop: Introduction: 00:03:00 •Impala: 00:06:00 •Impala : Demonstration: 00:18:00 •PrestoDB: 00:13:00 •PrestoDB : Demonstration: 00:14:00 •SQL-on-Hadoop: Wrap Up: 00:02:00 •Data Architectures: 00:05:00 •Introduction to Distributed Commit Logs: 00:07:00 •Apache Kafka: 00:03:00 •Confluent Platform Installation: 00:10:00 •Data Modeling in Kafka I: 00:13:00 •Data Modeling in Kafka II: 00:15:00 •Data Generation for Testing: 00:09:00 •Use case: Toll fee Collection: 00:04:00 •Stream processing: 00:11:00 •Stream Processing II with Stream + Connect APIs: 00:19:00 •Example: Kafka Streams: 00:15:00 •KSQL : Streaming Processing in SQL: 00:04:00 •KSQL: Example: 00:14:00 •Demonstration: NYC Taxi and Fares: 00:01:00 •Streaming: Wrap Up: 00:02:00 •Database Polyglot: 00:04:00 •Extending your knowledge: 00:08:00 •Data Visualization: 00:11:00 •Building a Data-driven Organization - Conclusion: 00:07:00 •Conclusion: 00:03:00 •Assignment -SQL NoSQL Big Data and Hadoop: 00:00:00

Overview This comprehensive course on Functional Skills Maths - Level 1 (Updated 2022) will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Functional Skills Maths - Level 1 (Updated 2022) 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 Functional Skills Maths - Level 1 (Updated 2022). It is available to all students, of all academic backgrounds. Requirements Our Functional Skills Maths - Level 1 (Updated 2022) 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 24 sections • 114 lectures • 11:37:00 total length •Lecture 1: Introduction Video: 00:02:00 •Lecture 2: Quick Guide: 00:01:00 •Lecture 1: Read & Write Large Numbers Part 1: 00:08:00 •Lecture 2: Read & Write Large Numbers Part 2: 00:13:00 •Lecture 3: Compare and Order Large Numbers: 00:12:00 •Downloadable Resources: 00:00:00 •Lecture 1: Why do you Round off a Number?: 00:03:00 •Lecture 2: Rounding off techniques: 00:07:00 •Lecture 3: Practice Problems Part 1: 00:09:00 •Lecture 4: Practice Problems Part 2: 00:08:00 •Lecture 5: Rounding to Significant Figures: 00:15:00 •Downloadable Resources: 00:00:00 •Lecture 1: Number System: 00:07:00 •Lecture 2: Integers and Ordering of Integers: 00:08:00 •Lecture 3: Addition and Subtractions of Integers: 00:10:00 •Lecture 4: Operations on Integers: 00:06:00 •Lecture 5: Multiplication and Division of Integers: 00:07:00 •Downloadable Resources: 00:00:00 •Lecture 1: Factors and Multiples Basics: 00:07:00 •Lecture 2: Divisibility tests for 2,3,4,5,6: 00:07:00 •Lecture 3: Divisibility tests for 7,8,9,10,11: 00:11:00 •Lecture 4: Prime Factorisation: 00:13:00 •Lecture 5: Highest Common Factor HCF: 00:13:00 •Lecture 6: HCF - Division Method: 00:10:00 •Lecture 7: Least Common Multiple LCM: 00:14:00 •Downloadable Resources: 00:00:00 •Lecture 1: Classification of Fractions: 00:09:00 •Lecture 2: Convert mixed to improper and improper to mixed fractions: 00:05:00 •Lecture 3: Equivalent Fractions: 00:07:00 •Lecture 4: Comparing Fractions after converting to like fractions: 00:09:00 •Lecture 5: Reducing a fraction to the lowest term: 00:05:00 •Lecture 6: Addition & Subtraction of fractions: 00:09:00 •Lecture 7: Multiplication and Division of Fractions: 00:11:00 •Lecture 8: Find Fractions of whole number quantities or measurements: 00:08:00 •Downloadable Resources: 00:00:00 •Lecture 1: Expanded form of Decimals: 00:08:00 •Lecture 2: Expanded form to Decimal form: 00:03:00 •Lecture 3: Writing fractions to Decimals: 00:04:00 •Lecture 4: Converting Decimals to a fraction: 00:05:00 •Lecture 5: Like & Unlike Decimals: 00:04:00 •Lecture 6: Comparing & Ordering Decimal Numbers: 00:09:00 •Lecture 7: Addition and Subtraction of Decimals: 00:06:00 •Lecture 8: Multiplication of Decimals: 00:07:00 •Lecture 9: Division of Decimals: 00:06:00 •Downloadable Resources: 00:00:00 •Lecture 1: Multiply whole numbers and decimals by 10,100 & 1000: 00:09:00 •Lecture 2: Divide whole numbers and decimals by 10,100 & 1000: 00:05:00 •Downloadable Resources: 00:00:00 •Lecture 1: Squaring of one-digit and two-digit numbers: 00:06:00 •Lecture 1: Simple Formula in words for one step or two steps operations: 00:09:00 •Downloadable Resources: 00:00:00 •Lecture 1: Intro to the metric system: 00:09:00 •Lecture 2: Length, Mass & Capacity: 00:10:00 •Lecture 3: Length, Mass & Capacity Addition & Subtraction: 00:05:00 •Lecture 1: Converting 12-hour time to a 24-hour time: 00:04:00 •Lecture 2: Converting 24-hour time to a 12-hour time: 00:05:00 •Lecture 3: Conversion to different units of Time: 00:09:00 •Lecture 4: Addition with Time: 00:08:00 •Lecture 5: Subtraction with Time: 00:08:00 •Lecture 6: Multiplication with Time: 00:07:00 •Lecture 7: Division with Time: 00:06:00 •Lecture 8: Finding Time interval between given timings Part 1: 00:05:00 •Lecture 9: Finding Time interval between given timings Part 2: 00:10:00 •Lecture 10: Past Paper problem Q1: 00:02:00 •Lecture 11: Past Paper problem Q2: 00:02:00 •Lecture 12: Past Paper problem Q3: 00:05:00 •Lecture 13: Past Paper problem Q4: 00:03:00 •Lecture 14: Past Paper problem Q5: 00:02:00 •Lecture 1: Order of Operations - PEMDAS: 00:10:00 •Lecture 2: Practice Problems on - PEMDAS: 00:05:00 •Downloadable Resources: 00:00:00 •Lecture 1: Estimation and approximation: 00:07:00 •Lecture 2: Estimation using Fractions and Decimals: 00:03:00 •Lecture 1: Simple Ratio and Direct Proportion Part 1: 00:09:00 •Lecture 2: Simple Ratio and Direct Proportion Part 2: 00:04:00 •Lecture 3: Simple Ratio and Direct Proportion Part 3: 00:04:00 •Lecture 1: Scale Drawing: 00:06:00 •Lecture 1: What is the meaning of Percentage?: 00:02:00 •Lecture 2: Percentage to Fraction: 00:07:00 •Lecture 3: Percentage of a quantity and conversation to Decimal: 00:05:00 •Lecture 4: Expressing one Quantity as a Percentage of another Quantity: 00:07:00 •Lecture 5: Calculate Percentages of amounts, increase, decrease by 5,10,15%: 00:11:00 •Lecture 1: Calculate simple interest in multiples of 5% on amounts of money: 00:11:00 •Lecture 2: Calculate discounts in multiples of 5% on amounts of money: 00:08:00 •Downloadable Resources: 00:00:00 •Lecture 1: Problems based on Money: 00:06:00 •Downloadable Resources: 00:00:00 •Lecture 1: What is statistics?: 00:04:00 •Lecture 2: Representation of discrete data in Tables: 00:11:00 •Lecture 3: One-way Tables: 00:03:00 •Lecture 4: Two-way Tables: 00:04:00 •Lecture 5: Grouping of a discrete data Part 1: 00:05:00 •Lecture 6: Grouping of a discrete data Part 2: 00:04:00 •Lecture 7: Represent discrete data in Bar Charts (Graphs)Part 1: 00:08:00 •Lecture 8: Represent discrete data in Bar Charts (Graphs)Part 2: 00:07:00 •Lecture 9: Pie Charts (Circle graphs) Part 1: 00:08:00 •Lecture 10: Pie Charts (Circle graphs) Part 2: 00:05:00 •Lecture 11: Pie Charts (Circle graphs) Part 3: 00:08:00 •Lecture 12: Mean & Range: 00:09:00 •Downloadable Resources: 00:00:00 •Lecture 1: Probability on a scale from 0 to 1: 00:12:00 •Lecture 2: Probabilities of simple events Part 1: 00:03:00 •Lecture 3: Probabilities of simple events Part 2: 00:06:00 •Downloadable Resources: 00:00:00 •Lecture 1: Lines & Angles: 00:08:00 •Lecture 2: Introduction to Triangles: 00:05:00 •Lecture 3: Polygons: 00:05:00 •Lecture 4: More 2D Figures: 00:07:00 •Lecture 5: Line symmetry: 00:05:00 •Lecture 1: Area & Perimeter Part 1: 00:08:00 •Lecture 2: Area & Perimeter Part 2: 00:06:00 •Lecture 3: Area & Perimeter Part 3: 00:08:00 •Downloadable Resources: 00:00:00 •Lecture 1: Calculation of the volumes & Surface Area of cubes and cuboids: 00:08:00

Overview This comprehensive course on CompTIA A+ (220-1002) will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This CompTIA A+ (220-1002) 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 CompTIA A+ (220-1002). It is available to all students, of all academic backgrounds. Requirements Our CompTIA A+ (220-1002) 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 Course Curriculum 22 sections • 106 lectures • 14:51:00 total length •CompTIA A+ 2019 Core 2 (220-1002) Course Introduction: 00:02:00 •What is the CompTIA A+: 00:02:00 •Why Get A+ Certified?: 00:03:00 •What is on the CompTIA A+ Core 2 (220-1002) Exam?: 00:04:00 •How to Pass the CompTIA A+ Exam: 00:04:00 •How to use this Video Course: 00:03:00 •Professional Communication Part 1: 00:06:00 •Professional Communication Part 2: 00:07:00 •Physical Safety: 00:07:00 •What is an Operating System?: 00:09:00 •Users and Super Users: 00:05:00 •Why Windows?: 00:08:00 •Windows Editions and Versions: 00:12:00 •Touring the macOS: 00:06:00 •Touring Linux: 00:08:00 •32-Bit vs. 64-Bit Processing: 00:12:00 •Virtual Memory: 00:06:00 •Power Protection: 00:10:00 •Understanding Partitioning: 00:04:00 •MBR Partitioning: 00:12:00 •GPT Partitioning: 00:09:00 •Understanding File Systems: 00:12:00 •Popular File Systems: 00:07:00 •Formatting in Action: 00:11:00 •Dynamic Disks: 00:09:00 •Software RAID in Storage Spaces: 00:10:00 •Encrypting Mass Storage: 00:09:00 •Boot from Everything: 00:12:00 •Installing Windows: 00:12:00 •Post-Installation Tasks: 00:12:00 •Windows Installation options: 00:07:00 •What is the Registry?: 00:11:00 •Processes: 00:07:00 •Services: 00:04:00 •Your Windows Toolset: 00:08:00 •Windows 7 Task Manager: 00:09:00 •Windows 10 Task Manager: 00:06:00 •Information and Configuration Tools: 00:11:00 •Performance Monitor: 00:12:00 •Event Viewer: 00:07:00 •Tools for Programmers: 00:08:00 •Introduction to Users and Groups: 00:06:00 •Managing Users and Groups: 00:12:00 •NTFS Permissions: 00:08:00 •Linux and macOS Permissions: 00:05:00 •File Explorer: 00:14:00 •Sharing Resources: 00:11:00 •Security Policies: 00:08:00 •Patch Management: 00:11:00 •Working with Disks: 00:06:00 •Working with Applications: 00:07:00 •System Restore: 00:05:00 •Backing up Your Files: 00:07:00 •Task Scheduler: 00:07:00 •Understanding the CLI: 00:11:00 •Navigating the CLI: 00:14:00 •Working with Folders: 00:07:00 •Working with Files: 00:11:00 •Working with Drives: 00:13:00 •Super Copy Commands: 00:09:00 •Advanced Windows Command Line: 00:08:00 •Advanced Linux Commands: 00:13:00 •Command-Line Permissions: 00:08:00 •Introduction to Scripting: 00:10:00 •Interpreted Languages: 00:12:00 •Windows Recovery Environment: 00:05:00 •Advanced Windows Startup Options: 00:07:00 •Troubleshooting Boot Problems: 00:10:00 •Troubleshooting at the GUI: 00:11:00 •Troubleshooting Applications: 00:07:00 •Kernel Panic: 00:05:00 •Resolutions and Aspect Ratios: 00:06:00 •Multiple Monitors: 00:05:00 •Network Card Troubleshooting: 00:09:00 •Working with Connections: 00:09:00 •Working with Workgroups: 00:08:00 •Working with Active Directory: 00:14:00 •Windows Sharing with Mac and LInux: 00:07:00 •Net Command: 00:04:00 •Firewall Configuration: 00:11:00 •Windows Firewall: 00:08:00 •Port Forwarding: 00:07:00 •Wireless Encryption: 00:11:00 •Enterprise Wireless: 00:16:00 •Telnet and SSH: 00:07:00 •Remote Desktop Connections: 00:06:00 •The World Wide Web: 00:09:00 •Troubleshooting Internet Connections: 00:07:00 •Power Management: 00:11:00 •Mobile Device Security: 00:08:00 •Mobile Security Troubleshooting: 00:06:00 •Mobile Device Troubleshooting: 00:10:00 •Threats: 00:10:00 •Physical Security: 00:08:00 •Passwords and Authentication: 00:14:00 •Malware: 00:14:00 •Anti-Malware: 00:11:00 •Social Engineering: 00:06:00 •Licensing: 00:10:00 •Incident Response: 00:05:00 •Environmental Controls: 00:06:00 •Documents You Need to Know: 00:09:00 •Data You Need to Know: 00:04:00 •Change Management: 00:06:00 •The Zen of Backup: 00:11:00 •Recycling and Data Destruction: 00:07:00

Overview Having a foundational understanding of IT components is essential. Did you know that by 2023, an estimated 2.5 million new IT positions will be available globally? The CompTIA A+ (220-1001) course offers a comprehensive dive into the world of computer technology.  Designed to shape the professionals of tomorrow, this course meticulously covers the gamut of fundamental IT knowledge. Ranging from RAM technology to the vast world of cloud computing, the curriculum is structured to foster a comprehensive understanding. With modules such as 'Inside the PC' and 'Understanding Virtualization', learners will be adept at navigating the complex terrains of the modern IT environment. Ready to steer your career into the future of IT? Enrol now and become a part of the technological revolution! 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 CompTIA A+ (220-1001). It is available to all students, of all academic backgrounds. Requirements Our CompTIA A+ (220-1001) 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 24 sections • 132 lectures • 17:30:00 total length •CompTIA A+ 2019 Core 1 (220-1001) Course Introduction: 00:02:00 •What is the CompTIA A+?: 00:02:00 •Why Get A+ Certified?: 00:03:00 •What is on the CompTIA A+ Core 1 (220-1001) Exam?: 00:09:00 •How to Pass the A+ Exam: 00:04:00 •How to Use This Video Course: 00:03:00 •Tools of the Trade: 00:06:00 •Troubleshooting Theory: 00:10:00 •Primary PC Connections: 00:05:00 •External Connections: 00:11:00 •Inside the PC: 00:08:00 •What is a Computer?: 00:07:00 •What is a CPU?: 00:15:00 •CPU Speeds and Cores: 00:12:00 •Caching: 00:07:00 •CPU Sockets: 00:12:00 •Installing a CPU: 00:11:00 •Liquid Cooling: 00:04:00 •RAM Technology: 00:11:00 •RAM Capacity: 00:08:00 •RAM Features: 00:07:00 •Installing RAM: 00:07:00 •What is the BIOS?: 00:06:00 •POST: 00:09:00 •System Setup: 00:09:00 •Troubleshooting Firmware: 00:12:00 •Form Factors: 00:06:00 •Chipsets: 00:05:00 •Touring the Motherboard: 00:14:00 •Touring the Case: 00:07:00 •Installing a Motherboard: 00:09:00 •The Power Supply: 00:09:00 •Mounting a Power Supply: 00:05:00 •Choosing a Power Supply: 00:08:00 •Cooling Your PC: 00:11:00 •Troubleshooting Power Supplies: 00:09:00 •Troubleshooting Core Components: 00:14:00 •Introduction to Mass Storage: 00:13:00 •Magnetic Disk Drives: 00:08:00 •Solid State Drives: 00:08:00 •SCSI: 00:03:00 •Boot Order: 00:07:00 •New Installation - First Drive: 00:05:00 •RAID: 00:11:00 •Hardware RAID: 00:07:00 •Mass Storage Troubleshooting: 00:08:00 •Optical Media: 00:10:00 •USB Standards: 00:10:00 •Understanding USB: 00:11:00 •Configuring USB: 00:07:00 •Thunder and Lightning: 00:06:00 •Keyboards and Mice: 00:08:00 •Sight and Sound: 00:07:00 •Readers and Scanners: 00:08:00 •Using Expansion Cards: 00:08:00 •The Right PC for the Job: 00:13:00 •Monitor Technologies: 00:08:00 •LCD Breakdown: 00:04:00 •Graphics Cards and Connections: 00:13:00 •Installing a Graphics Card: 00:07:00 •Projectors: 00:05:00 •Troubleshooting Monitors: 00:06:00 •Introduction to Networking: 00:08:00 •Hubs vs. Switches: 00:05:00 •Hexadecimal: 00:07:00 •WANs and Routers: 00:09:00 •Cables and Connectors: 00:11:00 •Crimping Cables: 00:10:00 •Structured Cabling: 00:11:00 •Introduction to TCP/IP: 00:14:00 •Network IDs and Subnet Masks: 00:05:00 •Special IP Addresses: 00:09:00 •NAT: 00:07:00 •Dynamic IP Addressing: 00:10:00 •IPv6: 00:07:00 •Port Numbers: 00:12:00 •TCP, UDP, and ICMP: 00:06:00 •Understanding DNS: 00:09:00 •Working with DNS: 00:07:00 •Windows Naming: 00:08:00 •Routers: 00:12:00 •Basic Router Configuration: 00:12:00 •Advanced Router Configuration: 00:06:00 •VLANs: 00:07:00 •Network Troubleshooting: 00:05:00 •Wireless Network Hardware: 00:11:00 •Wi-Fi Standards: 00:10:00 •Basic WAP Setup: 00:11:00 •Connecting to a Wi-Fi Network: 00:09:00 •It's a Huge Mesh: 00:04:00 •Beyond Wi-Fi: 00:07:00 •Troubleshooting Wireless Connections: 00:07:00 •Beyond the LAN: 00:03:00 •Internet Tiers: 00:06:00 •Dial-up Connections: 00:08:00 •Broadband Connections: 00:10:00 •Firewalls and Servers: 00:06:00 •FTP: 00:07:00 •E-Mail: 00:08:00 •Proxy Servers: 00:06:00 •Virtual Private Networks (VPNs): 00:08:00 •Internet of Things (IoT): 00:04:00 •Understanding Virtualization: 00:10:00 •Your First Virtual Machine: 00:11:00 •Advanced Virtualization Setup: 00:10:00 •Cloud Computing: 00:08:00 •Cloud Ownership: 00:03:00 •Cloud-Based Applications: 00:06:00 •Laptop Features: 00:08:00 •Laptop Hardware Troubleshooting - The Tools: 00:05:00 •Laptop Hardware - Core Hardware: 00:04:00 •Laptop Hardware - CPU and Motherboard: 00:07:00 •Touring Your Laptop Display: 00:04:00 •What is a Mobile Device?: 00:09:00 •Mobile Connections: 00:10:00 •Touring Android: 00:10:00 •Touring iOS: 00:08:00 •Virtual Reality: 00:03:00 •Maintaining Mobile Devices: 00:11:00 •Mobile Devices and E-mail: 00:10:00 •Mobile Synchronization: 00:08:00 •Laser Printers: 00:13:00 •Inkjet Printers: 00:08:00 •Impact Printers: 00:04:00 •Thermal Printers: 00:04:00 •Installing a Local Printer: 00:14:00 •Sharing Printers: 00:08:00 •Installing Wireless and Cloud Printers: 00:10:00 •Troubleshooting Printers: 00:10:00 •3D Printing: 00:07:00 •Dealing with Threats: 00:07:00 •Assignment - CompTIA A+ (220-1001): 00:00:00

Overview Windows 10 and Its seamless functioning is vital to the smooth operation of countless industries. That's where the Complete Windows 10 Troubleshooting for IT HelpDesk course comes into play, armed with a skill set that makes them indispensable. Recent industry reports have highlighted that the demand for IT support specialists is rising and soaring. The financial rewards are equally impressive, with an average annual salary range of £35,000 to £50,000 in the UK alone.Now, enter the "Complete Windows 10 Troubleshooting for IT HelpDesk" course, your passport to becoming a Windows 10 maestro. This meticulously designed course curriculum covers every nook and cranny of Windows 10 troubleshooting. From the basics of installation and configuration to tackling intricate issues and supercharging system performance, this course is your secret weapon for an illustrious IT career.Enroll Now and Master Windows 10 Troubleshooting for a Rewarding IT Career! 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 Complete Windows 10 Troubleshooting for IT HelpDesk. It is available to all students, of all academic backgrounds. Requirements Our Complete Windows 10 Troubleshooting for IT HelpDesk is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 10 sections • 46 lectures • 02:51:00 total length •Introduction: 00:02:00 •Install Hyper-V on Local System: 00:02:00 •Create Virtual Machine (VM): 00:02:00 •Download Free Evaluation Windows 10 Image: 00:02:00 •Installing Windows 10: 00:06:00 •Make USB Bootable with GUI Tool: 00:07:00 •Make USB Bootable with Command (CLI Tool): 00:05:00 •Access Boot Menu: 00:03:00 •Hyper-V Interface Overview: 00:05:00 •Increase Disk and Memory of Virtual Machine: 00:07:00 •Use of Snapshot (Time Saving): 00:03:00 •Fix Stuck Windows Service: 00:11:00 •Fix 'Not Responding' Application or Desktop Error: 00:03:00 •Logoff Another User from Local System: 00:03:00 •Logoff user Remotely through PowerShell: 00:02:00 •Delay in Replication of Assigned Permission on Client: 00:03:00 •Fix Domain Trust issue without Re-joining & Reboot: 00:05:00 •Monitor CPU, Memory & HDD Utilization (Task Manager & Resource Monitor): 00:06:00 •Find & Kill High Utilization Process: 00:02:00 •Check Recently System Uptime and Reboot: 00:03:00 •Uninstall Unwanted Applications: 00:03:00 •Run Disk Cleanup (Remove Not Required System Files): 00:06:00 •Deep Cleaning Through TreeSize Free Tool: 00:06:00 •Disable Startup Applications (Speed Up Booting Time): 00:02:00 •Disable Unwanted Startup Services (MSCONFIG): 00:03:00 •Module Introduction: 00:02:00 •Create Virtual Machine for Server 2019: 00:02:00 •Install Windows Server 2019: 00:03:00 •Rename System Name: 00:02:00 •Server Manager Introduction: 00:02:00 •Install Active Directory Role: 00:03:00 •Promote Active Directory Domain Controller: 00:06:00 •Set Static IP Address: 00:03:00 •Active Directory Users and Computers (ADUC): 00:04:00 •Active Directory Administrative Center (ADAC): 00:03:00 •Create Active Directory User: 00:06:00 •Join System in Active Directory Domain: 00:04:00 •Computer Account Introduction & Solution: 00:05:00 •Info about Default Quota for Rejoining System: 00:02:00 •Check Password Expiration and Account Status: 00:02:00 •Recycle Bin Settings: 00:02:00 •Cleanup Recycle Bin Data of Multiple Users Profile (Advance): 00:08:00 •Close Locked Open Files on File Server: 00:06:00 •How to Fix Filename Is Too Long Issue: 00:04:00 •Resources: 00:00:00 •Assignment - Complete Windows 10 Troubleshooting for IT HelpDesk: 00:00:00

Overview This comprehensive course on Functional Skills IT will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Functional Skills IT 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 Functional Skills IT. It is available to all students, of all academic backgrounds. Requirements Our Functional Skills IT 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 15 sections • 64 lectures • 04:55:00 total length •Introduction to IT Fundamentals: 00:03:00 •The Case for Computer Literacy: 00:03:00 •Features Common to Every Computing Device: 00:02:00 •Common General-Purpose Computing Devices: 00:02:00 •Networks of Computing Devices: 00:04:00 •Remotely-Accessed Computer Systems: 00:04:00 •Specialized Computer Systems: 00:02:00 •Specialty I/O Devices: 00:01:00 •CPUs: 00:03:00 •Passive and Active Cooling: 00:03:00 •RAM and Active Memory: 00:05:00 •Motherboards: 00:03:00 •Power Supplies: 00:03:00 •AMA - Ask Me Anything about System Hardware: 00:07:00 •Ports and Connectors: 00:03:00 •General Use I/O Devices: 00:02:00 •AMA - Ask Me Anything about I/O, Ports and Peripherals: 00:07:00 •Basics of Binary: 00:04:00 •Storage Technologies: 00:04:00 •Mass Storage Variation: 00:03:00 •AMA - Ask Me Anything about Data Storage and Sharing: 00:07:00 •Operating System Functions: 00:04:00 •Operating System Interfaces: 00:05:00 •AMA - Ask Me Anything about Understanding OS's: 00:05:00 •Preparing the Work Area: 00:02:00 •Setting up a Desktop PC: 00:01:00 •Completing PC Setup: 00:04:00 •AMA - Ask Me Anything about Setting up and Configuring a PC: 00:09:00 •Personalizing a Tablet: 00:08:00 •AMA - Ask Me Anything about Mobile Devices Part 1: 00:07:00 •AMA - Ask Me Anything about Mobile Devices Part 2: 00:07:00 •File Management Tools: 00:02:00 •File Manipulation: 00:06:00 •Backups: 00:03:00 •AMA - Ask Me Anything about Managing Files: 00:08:00 •Walking Survey of Applications: 00:03:00 •Managing Applications: 00:03:00 •Applications and Extensions: 00:04:00 •AMA - Ask Me Anything about Working with Applications: 00:07:00 •Wi-Fi Setup: 00:06:00 •Going High Speed: 00:03:00 •Setting Up and Sharing Printers: 00:05:00 •AMA - Ask Me Anything about Networks and Internet Connectivity Part 1: 00:07:00 •AMA - Ask Me Anything about Networks and Internet Connectivity Part 2: 00:05:00 •Physical Security: 00:05:00 •Dealing with Malware: 00:03:00 •Password Management: 00:03:00 •Clickworthy: 00:03:00 •Perils of Public Internet: 00:02:00 •AMA - Ask Me Anything about IT Threat Mitigation Part 1: 00:07:00 •AMA - Ask Me Anything about IT Threat Mitigation Part 2: 00:08:00 •Power Management: 00:02:00 •Cleaning and Maintaining Computers: 00:02:00 •Trash it or Stash it?: 00:02:00 •AMA - Ask Me Anything about Computer Maintenance and Management: 00:11:00 •Troubleshooting 101: 00:03:00 •AMA - Ask Me Anything about Troubleshooting Computers Part 1: 00:10:00 •AMA - Ask Me Anything about Troubleshooting Computers Part 2: 00:11:00 •Introduction to Databases: 00:06:00 •Database Details: 00:06:00 •AMA - Ask Me Anything about Databases: 00:06:00 •Introduction to Programming: 00:04:00 •Programming with a PBJ Sandwich: 00:08:00 •AMA - Ask Me Anything about Programming: 00:04:00

Overview Acquire the language of databases with this SQL Programming Complete Bundlecourse. In this data-driven world, data is used to make strategies, find solutions and do a thousand other tasks. Businesses across the world are using big and related data, which makes a basic knowledge of SQL a remarkable skill not only for data scientists but for everyone. This SQL Programming Complete Bundlecourse will teach you the language of databases, SQL, and help you gain proficiency in SQL tools. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this SQL Programming Complete Bundle. It is available to all students, of all academic backgrounds. Requirements Our SQL Programming Complete Bundle is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 9 sections • 53 lectures • 07:50:00 total length •Introduction: 00:04:00 •Course Curriculum Overview: 00:05:00 •Overview of Databases: 00:10:00 •MySQL Installation: 00:16:00 •MySQL Workbench Installation: 00:09:00 •Connecting to MySQL using Console: 00:09:00 •Overview of Challenges: 00:04:00 •SQL Statement Basic: 00:16:00 •SELECT Statement: 00:09:00 •SELECT DISTINCT: 00:05:00 •Column AS Statement: 00:12:00 •COUNT built-in Method usage: 00:11:00 •SELECT WHERE Clause - Part One: 00:05:00 •SELECT WHERE Clause - Part Two: 00:11:00 •SQL Statement Basic: 00:16:00 •SQL Limit Clause Statement: 00:09:00 •SQL Using BETWEEN with Same Column Data: 00:11:00 •How to Apply IN Operator: 00:11:00 •Wildcard Characters with LIKE and ILIKE: 00:11:00 •Overview of GROUP BY: 00:06:00 •Aggregation function SUM(): 00:09:00 •Aggregation MIN() and MAX(): 00:05:00 •GROUP BY - One: 00:09:00 •GROUP BY - Two: 00:12:00 •HAVING Clause: 00:05:00 •Overview of JOINS: 00:04:00 •Introduction to JOINS: 00:04:00 •AS Statement table: 00:03:00 •INNER Joins: 00:14:00 •FULL Outer Join: 00:11:00 •LEFT Outer JOIN: 00:08:00 •RIGHT JOIN: 00:08:00 •Union: 00:07:00 •Timestamps: 00:12:00 •EXTRACT from timestamp: 00:10:00 •Mathematical Functions: 00:12:00 •String Functions: 00:22:00 •SUBQUERY: 00:13:00 •Basic of Database and Tables: 00:06:00 •DataTypes: 00:10:00 •Primarykey and Foreignkey: 00:06:00 •Create Table in SQL Script: 00:13:00 •Insert: 00:11:00 •Update: 00:07:00 •Delete: 00:04:00 •Alter Table: 00:09:00 •Drop Table: 00:05:00 •NOT NULL Constraint: 00:08:00 •UNIQUE Constraint: 00:09:00 •Creating a Database backup: 00:12:00 •10a Overview of Databases and Tables: 00:05:00 •10c Restoring a Database: 00:07:00 •Assignment - SQL Programming Complete Bundle: 00:00:00

Course Overview: Are you ready to embark on a journey into SQL Programming? Unlock the power of data manipulation and database management with the SQL Programming Masterclass. This comprehensive course is meticulously designed throughout this masterclass to provide you with an in-depth understanding of SQL, starting from the basics and progressing to advanced topics. You will explore SQL data types, filtering and sorting data, working with functions, handle NULL values, and even diving into complex SQL concepts like joins, unions, etc. With a course duration of carefully crafted lessons, this Masterclass ensures you grasp SQL's nuances and develop the proficiency to apply these skills effectively.By the end of the SQL Programming Masterclass, you will be prepared to navigate the world of databases confidently. Enrol in this course today and start your journey! Key Features of the Course: CPD certificate upon completion 24/7 learning assistance and support Who is This Course For? This course is perfect for individuals seeking to enhance their data management and analysis skills. Whether you're a data analyst, database administrator, software developer, or professional looking to upskill, this course will empower you to harness the power of SQL programming. Prior programming experience is not mandatory, making it accessible to beginners and intermediate learners. What You Will Learn: Foundations of SQL programming: Learn the basics of SQL, database management systems, and the tools used in this course, such as PostgreSQL and SQLectron. Data manipulation: Master the art of extracting, filtering, and sorting data based on specific requirements using various SQL keywords and operators. Advanced querying techniques: Dive deeper into SQL programming by exploring functions, grouping and aggregating data, and using advanced query techniques. Data conversion and manipulation: Discover how to convert data types, concatenate strings, manipulate characters and numbers, and utilise case statements for more sophisticated queries. Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Data modification: Learn how to insert, update, and delete records in a database, as well as manage table structures and constraints.Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Views and schemas: Explore the concepts of views and schemas, and learn how to create and use them to organise and present data effectively. Why Enrol in This Course: Top-reviewed course: Join thousands of satisfied learners who have praised this course for its clear explanations, comprehensive content, and examples. Recently updated curriculum: Benefit from the most up-to-date information and industry best practices in SQL programming. In-demand skills: SQL programming is a highly sought-after skill in today's job market, opening up numerous career opportunities across industries. Requirements: No prior programming experience is required. All you need is a computer with an internet connection and a willingness to learn. Career Path: Upon completing the SQL Programming Masterclass, you'll have the knowledge and skills for various career paths, including: Data Analyst - Average UK salary: £35,000 per year Database Administrator - Average UK salary: £40,000 per year Business Intelligence Analyst - Average UK salary: £45,000 per year SQL Developer - Average UK salary: £40,000 per year Data Engineer - Average UK salary: £55,000 per year Software Developer - Average UK salary: £45,000 per year Data Scientist - Average UK salary: £60,000 per year Certification: Upon completing the Hygiene and Infection Control CPD Level 4 course, you will receive a CPD certificate. It demonstrates your commitment to maintaining the highest standards of hygiene and infection control. Course Curriculum 17 sections • 117 lectures • 10:47:00 total length •Introduction: 00:01:00 •Tools Used in This Course: 00:01:00 •Download PostgreSQL: 00:02:00 •Install PostgreSQL: 00:03:00 •Download SQLectron: 00:02:00 •Install SQLectron: 00:01:00 •Connect to PostgreSQL - Credentials: 00:01:00 •Connect to PostgreSQL Using SQLectron: 00:02:00 •Import Course Data Using SQLectron: 00:02:00 •FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data: 00:08:00 •Check Imported Data: 00:06:00 •What is a Database?: 00:01:00 •SQL Data Types: 00:02:00 •Finally Some Fun! Extracting Data Based on Requirements: 00:01:00 •Filtering Data using WHERE Keyword: 00:08:00 •Filter Data by Range Using BETWEEN: 00:03:00 •Filter Data by Set of Values Using IN: 00:03:00 •Filter Data by Date: 00:05:00 •More Filtering by Date: 00:03:00 •Another Query Filtering by Date: 00:01:00 •Filter Data by Strings: 00:04:00 •More Filtering by Strings: 00:05:00 •More Filtering by Strings 2: 00:10:00 •More Filtering by Strings 3: 00:02:00 •How to Ignore Caps when Filtering by String: 00:04:00 •AND Operator: 00:10:00 •OR Operator: 00:12:00 •NOT Operator: 00:09:00 •AND, OR & NOT Operators: Which Has the Highest Priority?: 00:06:00 •Basic Math Operations: 00:06:00 •Modulo Operator: 00:04:00 •Calculate The Net Salary for Employees: 00:06:00 •Filter Data with Math Equations: 00:03:00 •Concatenate Strings with '||' Operator: 00:06:00 •Concatenate Strings with Numbers: 00:02:00 •Give Your Report Fields A Cool Name: 00:04:00 •A Report for Payroll: 00:07:00 •Order Records by Column: 00:06:00 •Order Records by Multiple Columns: 00:12:00 •How Alias Names Cannot Be Used with WHERE: 00:02:00 •LIMIT Record Count Fetched by Your Query: 00:08:00 •Fetch A Field's Unique Values Using DISTINCT: 00:03:00 •Using DISTINCT Keyword with Multiple Columns: 00:06:00 •What is a NULL Value Anyway?: 00:05:00 •Build More Sophisticated Queries with CASE Statements: 00:10:00 •Your Knowledge So Far Under A Great Test: 00:09:00 •Let Me Introduce You to Functions: 00:04:00 •SUM Function: 00:04:00 •AVG (Average) Function: 00:04:00 •COUNT Function: 00:07:00 •MIN & MAX Functions: 00:04:00 •How To Count Your Field's Unique Values: 00:04:00 •GROUP BY Clause: Use Functions with Dimensions: 00:06:00 •GROUP BY More Than One Dimension: 00:05:00 •Now For Some Tough Workout: 00:09:00 •Filter By Aggregate Functions with HAVING Clause: 00:08:00 •Character Functions - UPPER, LOWER & INITCAP: 00:08:00 •Character Functions - CONCAT & LENGTH: 00:10:00 •Character Functions - LPAD & RPAD: 00:13:00 •Character Functions - TRIM: 00:04:00 •Character Functions - REPLACE: 00:09:00 •Character Functions - SUBSTR: 00:10:00 •Number Functions - MOD & ROUND: 00:11:00 •Number Functions - TRUNC: 00:07:00 •Selectception: A Select Query inside another Select Query!: 00:06:00 •Auto Data Conversion in SQL: 00:11:00 •Cast Date to Character: 00:10:00 •Cast Number to Character: 00:09:00 •Cast Timestamp to Character: 00:07:00 •Cast Character to Number: 00:08:00 •Cast Character to Date & Timestamp: 00:09:00 •UNION: 00:03:00 •UNION ALL: 00:02:00 •Important Note about Combining Queries: 00:02:00 •INTERSECT: 00:01:00 •EXCEPT: 00:01:00 •Employees & Departments Tables Revised: 00:03:00 •Entity Relationship Diagram (ERD): 00:09:00 •Cartesian Join: 00:09:00 •Table Aliases with Joins: 00:07:00 •Why I Don't Recommend Cartesian Joins: 00:08:00 •Inner Join: 00:06:00 •In-Depth Look into Join Types in SQL: 00:03:00 •Outer Join - Right, Left & Full: 00:08:00 •INSERT a New Record to a Table: 00:09:00 •Insert Without Specifying Column Names: 00:09:00 •UPDATE a Record's Field Values: 00:07:00 •CAUTION! How an UPDATE Query Can Go Wrong: 00:04:00 •Update a Record Using Single-Row Functions: 00:04:00 •A Good Exercise: Extract Employee's Email Address: 00:02:00 •Solution: Extract Employee's Email Address: 00:13:00 •DELETE a Table's Record: 00:06:00 •Insert Records with Nested Select Queries: 00:06:00 •SQL Data Types Revised: 00:13:00 •Bookstore Data Set: Let's Move It to Database: 00:04:00 •Create Your First Table!: 00:08:00 •Insert Data to Your New Table: 00:08:00 •Change Column Data Type: 00:07:00 •Rename Column: 00:04:00 •Add a New Column to Table: 00:04:00 •Constraints in SQL: 00:01:00 •Primary Keys: 00:14:00 •NOT NULL Constraint: 00:05:00 •UNIQUE Constraint: 00:04:00 •DEFAULT Constraint: 00:04:00 •Foreign Keys: 00:08:00 •Use Foreign Keys with Joins - Books & Publishers: 00:06:00 •Foreign Keys - Properties: 00:06:00 •Drop Column: 00:01:00 •DROP Table: 00:01:00 •Create a New Table with Select Statement: 00:05:00 •A Trick to Create an Empty Table with Select Statement: 00:03:00 •Insert New Records Using Select Statement: 00:06:00 •Views: 00:03:00 •Schemas: 00:02:00 •Create & Use Schemas: 00:04:00 •Resources - SQL Programming Masterclass: 00:00:00

Overview This comprehensive course on R Programming for Data Science will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This R Programming for Data Science 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 R Programming for Data Science. It is available to all students, of all academic backgrounds. Requirements Our R Programming for Data Science 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 23 sections • 129 lectures • 06:25:00 total length •Introduction to Data Science: 00:01:00 •Data Science: Career of the Future: 00:04:00 •What is Data Science?: 00:02:00 •Data Science as a Process: 00:02:00 •Data Science Toolbox: 00:03:00 •Data Science Process Explained: 00:05:00 •What's Next?: 00:01:00 •Engine and coding environment: 00:03:00 •Installing R and RStudio: 00:04:00 •RStudio: A quick tour: 00:04:00 •Arithmetic with R: 00:03:00 •Variable assignment: 00:04:00 •Basic data types in R: 00:03:00 •Creating a vector: 00:05:00 •Naming a vector: 00:04:00 •Vector selection: 00:06:00 •Selection by comparison: 00:04:00 •What's a Matrix?: 00:02:00 •Analyzing Matrices: 00:03:00 •Naming a Matrix: 00:05:00 •Adding columns and rows to a matrix: 00:06:00 •Selection of matrix elements: 00:03:00 •Arithmetic with matrices: 00:07:00 •Additional Materials: 00:00:00 •What's a Factor?: 00:02:00 •Categorical Variables and Factor Levels: 00:04:00 •Summarizing a Factor: 00:01:00 •Ordered Factors: 00:05:00 •What's a Data Frame?: 00:03:00 •Creating Data Frames: 00:20:00 •Selection of Data Frame elements: 00:03:00 •Conditional selection: 00:03:00 •Sorting a Data Frame: 00:03:00 •Additional Materials: 00:00:00 •Why would you need lists?: 00:01:00 •Creating a List: 00:06:00 •Selecting elements from a list: 00:03:00 •Adding more data to the list: 00:02:00 •Additional Materials: 00:00:00 •Equality: 00:03:00 •Greater and Less Than: 00:03:00 •Compare Vectors: 00:03:00 •Compare Matrices: 00:02:00 •Additional Materials: 00:00:00 •AND, OR, NOT Operators: 00:04:00 •Logical operators with vectors and matrices: 00:04:00 •Reverse the result: (!): 00:01:00 •Relational and Logical Operators together: 00:06:00 •Additional Materials: 00:00:00 •The IF statement: 00:04:00 •IFELSE: 00:03:00 •The ELSEIF statement: 00:05:00 •Full Exercise: 00:03:00 •Additional Materials: 00:00:00 •Write a While loop: 00:04:00 •Looping with more conditions: 00:04:00 •Break: stop the While Loop: 00:04:00 •What's a For loop?: 00:02:00 •Loop over a vector: 00:02:00 •Loop over a list: 00:03:00 •Loop over a matrix: 00:04:00 •For loop with conditionals: 00:01:00 •Using Next and Break with For loop: 00:03:00 •Additional Materials: 00:00:00 •What is a Function?: 00:02:00 •Arguments matching: 00:03:00 •Required and Optional Arguments: 00:03:00 •Nested functions: 00:02:00 •Writing own functions: 00:03:00 •Functions with no arguments: 00:02:00 •Defining default arguments in functions: 00:04:00 •Function scoping: 00:02:00 •Control flow in functions: 00:03:00 •Additional Materials: 00:00:00 •Installing R Packages: 00:01:00 •Loading R Packages: 00:04:00 •Different ways to load a package: 00:02:00 •Additional Materials: 00:00:00 •What is lapply and when is used?: 00:04:00 •Use lapply with user-defined functions: 00:03:00 •lapply and anonymous functions: 00:01:00 •Use lapply with additional arguments: 00:04:00 •Additional Materials: 00:00:00 •What is sapply?: 00:02:00 •How to use sapply: 00:02:00 •sapply with your own function: 00:02:00 •sapply with a function returning a vector: 00:02:00 •When can't sapply simplify?: 00:02:00 •What is vapply and why is it used?: 00:04:00 •Additional Materials: 00:00:00 •Mathematical functions: 00:05:00 •Data Utilities: 00:08:00 •Additional Materials: 00:00:00 •grepl & grep: 00:04:00 •Metacharacters: 00:05:00 •sub & gsub: 00:02:00 •More metacharacters: 00:04:00 •Additional Materials: 00:00:00 •Today and Now: 00:02:00 •Create and format dates: 00:06:00 •Create and format times: 00:03:00 •Calculations with Dates: 00:03:00 •Calculations with Times: 00:07:00 •Additional Materials: 00:00:00 •Get and set current directory: 00:04:00 •Get data from the web: 00:04:00 •Loading flat files: 00:03:00 •Loading Excel files: 00:05:00 •Additional Materials: 00:00:00 •Base plotting system: 00:03:00 •Base plots: Histograms: 00:03:00 •Base plots: Scatterplots: 00:05:00 •Base plots: Regression Line: 00:03:00 •Base plots: Boxplot: 00:03:00 •Introduction to dplyr package: 00:04:00 •Using the pipe operator (%>%): 00:02:00 •Columns component: select(): 00:05:00 •Columns component: rename() and rename_with(): 00:02:00 •Columns component: mutate(): 00:02:00 •Columns component: relocate(): 00:02:00 •Rows component: filter(): 00:01:00 •Rows component: slice(): 00:04:00 •Rows component: arrange(): 00:01:00 •Rows component: rowwise(): 00:02:00 •Grouping of rows: summarise(): 00:03:00 •Grouping of rows: across(): 00:02:00 •COVID-19 Analysis Task: 00:08:00 •Additional Materials: 00:00:00 •Assignment - R Programming for Data Science: 00:00:00