Everywhere, from tiny businesses to major corporations, needs people skilled in SQL. In light of this, our online training course has been developed to help you succeed by equipping you with all the necessary skills. The importance of mastering SQL increases if you're looking for your first job in the data industry. You will learn about topics such as SQL fundamentals, data wrangling, SQL analysis, AB testing, distributed computing with Apache Spark, Delta Lake, and more through four increasingly more challenging SQL projects with data science applications. These subjects will equip you with the skills necessary to use SQL creatively for data analysis and exploration, write queries quickly, produce datasets for data analysis, conduct feature engineering, integrate SQL with other data analysis and machine learning toolsets, and work with unstructured data. This Specialisation is designed for a learner with little or no prior coding expertise who wants to become proficient with SQL queries. Experts have meticulously planned out the curriculum for the SQL Skills Training course with years of expertise. As a result, you will find it simple to learn the course material. Learning outcome After finishing the course, you'll Learn to utilise the tools for view creation Become familiar with updating columns and indexed views Be able to test and debug Be able to search a database using SQL Become more familiar with inline table-valued functions Learn the fundamentals of transactions and multiple statements Why Prefer US? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standards-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support *** Course Curriculum *** SQL Programming Course Module 01: Course Introduction Introduction Course Curriculum Overview Overview of Databases Module 02: SQL Environment Setup MySQL Installation MySQL Workbench Installation Connecting to MySQL using Console Module 03: SQL Statement Basics Overview of Challenges SQL Statement Basic SELECT Statement SELECT DISTINCT Column AS Statement COUNT built-in Method usage SELECT WHERE Clause - Part One SELECT WHERE Clause - Part Two Statement Basic Limit Clause Statement Using BETWEEN with Same Column Data How to Apply IN Operator Wildcard Characters with LIKE and ILIKE Module 04: GROUP BY Statements Overview of GROUP BY Aggregation function SUM() Aggregation MIN() and MAX() GROUP BY - One GROUP BY - Two HAVING Clause Module 05: JOINS Overview of JOINS Introduction to JOINS AS Statement table INNER Joins FULL Outer Join LEFT Outer JOIN RIGHT JOIN Union Module 06: Advanced SQL Commands / Statements Timestamps EXTRACT from timestamp Mathematical Functions String Functions SUBQUERY Module 07: Creating Database and Tables Basic of Database and Tables Data Types Primary key and Foreign key Create Table in SQL Script Insert Update Delete Alter Table Drop-Table NOT NULL Constraint UNIQUE Constraint Module 08: Databases and Tables Creating a Database backup 10a Overview of Databases and Tables 10c Restoring a Database CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course can be helpful for anyone working in the SQL fields, whether self-employed or employed, regardless of their career level. Requirements You will not need any prior background or expertise to enrol in this course. Career path The vocation of SQL Skills Training moves very quickly but pays well. This position provides unparalleled satisfaction. This is your opportunity to learn more and start changing things. Query Language Developer Server Database Manager Python Developer Technical Consultant Project Implementation Manager Software Developer (SQL) Certificates Certificate of completion Digital certificate - £10
Course Overview How would you like to one day be able to play a game that you yourself designed? If this sounds like the ultimate gamer's dream to you, then enrol in this Online Game Design Course today and turn your vision into a reality! This course is specially designed to teach you the very fundamentals of game creation, complete with training on how to develop games using 2D and 3D software. It covers everything you need to know to become a successful Game Designer, including an overview of the principles of game modification, and the tools you'll need as a game designer. Not only that, but with step-by-step training, you'll learn how to create games for social sites, providing you with a range of in-demand skills to rise to the top of the industry in no time. Learn from the experts and turn your passion for gaming into a full-time profession. Start designing the games you've always dreamed of and learn the principles of game creation from the experts! What You Will Learn In this Online Game Design Course, you will learn about the principles of designing games, with training in 2D and 3D game creation software. It is designed to help you familiarise with the role of a Game Designer, equipping you with the necessary skills to get a head start in your career. An Introduction to Game Creation An Overview of Essential Tools for Game Design 2D Game Creation Software 3D Game Creation Software How To Create a Game on a Social Site An Overview of the Gaming Industry The Role and Responsibilities of a Game Designer The Principles of Game Modification Why You Should Choose This Course From iStudy Study at your own pace Full Tutor support on weekdays (Monday - Friday) Fully compatible with any device Free Printable PDF Certificate immediately after completion No prior qualifications are needed to take this course No hidden fees or exam charges CPD Qualification Standards and IAO accredited Efficient exam system, assessment, and instant results Our customer support team is always ready to help you Gain professional skills and better earning potential Certification After completing the course you'll receive a free printable CPD accredited PDF certificate. Hard Copy certificate is also available, and you can get one for just £9! Accreditation This course is accredited by Continuing Professional Development (CPD). It is a recognised independent accreditation service. Enrol today and learn something new with iStudy. You'll find a full breakdown of the course curriculum down below, take a look and see just how much this course offers. We're sure you'll be satisfied with this course. Game Development Course Introduction To Game Creation 01:00:00 Essential Tools 01:00:00 Basics of Game Design 01:00:00 2D Game Creation Software 01:00:00 3D Game Creation Software 01:00:00 3D Game Creation 00:30:00 Game Modification 01:00:00 How To Create a Game on a Social Site 00:30:00 Wrapping Up 00:15:00 Additional Study Material 2D Game 00:00:00 Beginning Game Development with Python and Pygame 00:00:00 Game Development XNA GameStudio 00:00:00 Mock Exam Mock Exam-Game Design Course- 2D & 3D 00:20:00 Final Exam Final Exam-Game Design Course- 2D & 3D 00:20:00
A carefully structured advanced-level course on Apache Spark 3 to help you clear your job interviews. This course covers advanced topics and concepts that are part of the Databricks Spark certification exam. Boost your skills in Spark 3 architecture and memory management.
Duration 4 Days 24 CPD hours This course is intended for DevOps engineers Integration engineers Network and software architects Network engineers Software engineers System administrators Overview After completing this course, you should be able to: Describe network and IT convergence Describe Cisco NSO architecture Describe Linux Configure Cisco NSO Set up access control to Cisco NSO system Describe Cisco NSO Integration Options Explain version control systems and basic git concepts Describe the purpose of continuous integration and continuous delivery Implement Cisco NSO high availability Describe scalable system management Describe software development methodologies Describe service maintenance Perform NED upgrades Use Cisco NSO for managing services and their associated device configurations Describe Cisco NSO change management Explain service problem management Use Cisco NSO for service monitoring and compliance reporting Describe Cisco NSO inventory management Describe Cisco NSO use cases The Cisco Network Services Orchestrator (NSO) Administration and DevOps (NSO303) v4.0 course continues the learning journey of the NSO Essentials for Programmers and Network Architects (NSO201) v4.0 and NSO Advanced for Python Programmers (NSO300) v4.0 courses by introducing you to the system administration and DevOps focusing on NSO; the robust bridge linking network automation and orchestration tools, examining the development, operation, and administration task functions. You will learn how to set up, configure, deploy, and maintain a Cisco Network Services Orchestrator solution, and learn best practices for using DevOps. The examples shown in this course demonstrate real-world scenarios to prepare you for deployment and management of new or existing NSO instances. The course guides you through the setup of a production ready NSO instances using system installation with access control settings, the deployment of NSO in Docker containers, and introduces modern DevOps concepts and tools such as Git and Continuous Delivery/Continuous Deployment (CI/CD). You will learn how to migrate CDM devices, how to build NETCONF NEDs from the NSO CLI, how to handle NSO Alarms, and many more features that benefit you in your journey with Cisco NSO. Course Outline Introducing Network and IT Convergence Introducing Cisco NSO Architecture Introducing Linux Explaining Cisco NSO Setup Exploring Access Control Describing Integration Options Explaining Version Control System Describing Continuous Integration and Continuous Delivery Introducing Scalability and High Availability Describing Scalable System Management Describing Software Development Methodologies Introducing Service Maintenance Performing Network Element Driver (NED) Upgrades Introducing Configuration Management Describing Change Management Explaining Service Problem Management Explaining Service Monitoring and Compliance Reporting Introducing Inventory Management Describing Cisco NSO Use Cases
Are you ready to embark on an enlightening journey of wisdom with the HTML bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - HTML, Coding, CSS, & Javascript (A-Z). Delve into eight immersive CPD Accredited courses, each a standalone course: Course 01: Basic HTML 5 Course 02: Coding with HTML, CSS, & Javascript Course 03: C++ Programming Certificate Course Course 04: Intermediate Python Coding Course 05: HTML Web Development Crash Course Course 06: Web Design for Beginners: Build Websites in HTML & CSS Course 07: Create a Responsive HTML Email Template Course 08: Coding Essentials - Javascript, ASP. Net, C# - Bonus HTML Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the HTML, Coding, CSS, & Javascript (A-Z) bundle illuminate your path to wisdom. The HTML, Coding, CSS, & Javascript (A-Z) bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the HTML, Coding, CSS, & Javascript (A-Z) package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the HTML bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the HTML, Coding, CSS, & Javascript (A-Z) community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the HTML bundle. Establish robust bases across each course nestled within the HTML bundle. Decipher intricate concepts through the articulate content of the HTML bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the HTML bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The HTML bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the HTML bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The HTML bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the HTML bundle allows learners to make meaningful contributions to their chosen fields. Embark on the HTML journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the HTML bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the HTML bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hard copy Transcript - £9.99
Duration 4 Days 24 CPD hours This course is intended for This course is appropriate for developers and administrators who intend to use HBase. Overview Skills learned on the course include:The use cases and usage occasions for HBase, Hadoop, and RDBMSUsing the HBase shell to directly manipulate HBase tablesDesigning optimal HBase schemas for efficient data storage and recoveryHow to connect to HBase using the Java API, configure the HBase cluster, and administer an HBase clusterBest practices for identifying and resolving performance bottlenecks Cloudera University?s four-day training course for Apache HBase enables participants to store and access massive quantities of multi-structured data and perform hundreds of thousands of operations per second. Introduction to Hadoop & HBase What Is Big Data? Introducing Hadoop Hadoop Components What Is HBase? Why Use HBase? Strengths of HBase HBase in Production Weaknesses of HBase HBase Tables HBase Concepts HBase Table Fundamentals Thinking About Table Design The HBase Shell Creating Tables with the HBase Shell Working with Tables Working with Table Data HBase Architecture Fundamentals HBase Regions HBase Cluster Architecture HBase and HDFS Data Locality HBase Schema Design General Design Considerations Application-Centric Design Designing HBase Row Keys Other HBase Table Features Basic Data Access with the HBase API Options to Access HBase Data Creating and Deleting HBase Tables Retrieving Data with Get Retrieving Data with Scan Inserting and Updating Data Deleting Data More Advanced HBase API Features Filtering Scans Best Practices HBase Coprocessors HBase on the Cluster How HBase Uses HDFS Compactions and Splits HBase Reads & Writes How HBase Writes Data How HBase Reads Data Block Caches for Reading HBase Performance Tuning Column Family Considerations Schema Design Considerations Configuring for Caching Dealing with Time Series and Sequential Data Pre-Splitting Regions HBase Administration and Cluster Management HBase Daemons ZooKeeper Considerations HBase High Availability Using the HBase Balancer Fixing Tables with hbck HBase Security HBase Replication & Backup HBase Replication HBase Backup MapReduce and HBase Clusters Using Hive & Impala with HBase Using Hive and Impala with HBase Appendix A: Accessing Data with Python and Thrift Thrift Usage Working with Tables Getting and Putting Data Scanning Data Deleting Data Counters Filters Appendix B: OpenTSDB
Description: Game Development is the creation of video games which is done by game developers. A game developer can be one person or a large company. To become a game developer, you need to learn the skills and knowledge about video games and how to make one. Many of game developers chose to become one because they are gamers themselves. To become a game development expert, you need to learn both the basics skills and special skills of game development. This course will help you to master the right skills to become successful in the growing game development industry. Who is the course for? Game makers or developers who want to improve their game development skills. People who have an interest in game development and software 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. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, 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 hard copy 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 recognised 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: The Advanced Game Development Course would be beneficial for the following careers: Animator Assistant Producer Audio Engineer Creative Director Game Designer Game Developer Game Programmer Games Artist Product Manager Software Developer. Gaming Basics Introduction 00:30:00 Understanding Consoles 01:00:00 Using Your Computer 01:00:00 Using Your Phone 01:00:00 Using the Internet 00:30:00 Where to Find Free Software 01:00:00 Understanding Accessories Dealing with Drugs 00:30:00 Wrapping Up 00:15:00 Developing Games Introduction To Game Creation 00:30:00 Essential Tools 01:00:00 Basics of Game Design 01:00:00 2D Game Creation Software 01:00:00 3D Game Creation Software 01:00:00 3D Game Creation 00:30:00 Game Modification 01:00:00 How To Create a Game on a Social Site 00:30:00 Testing Games Introduction to Game Testing 01:00:00 Two Rules of Game Testing 01:00:00 How to Put a Resume Together 01:00:00 How give Examples During Job Interview 00:30:00 Contacting Game Developers 01:00:00 Use the Correct Search Keywords 00:30:00 Wrapping Up 00:15:00 Additional Supporting Materials 2D Game 00:00:00 Beginning Game Development with Python and Pygame 00:00:00 Game Development XNA GameStudio 00:00:00 Game QA & Testing 00:00:00 Game Testing Changers 00:00:00 Become A Game Tester 00:00:00 Mock Exam Mock Exam - Advanced Game Development Course 00:20:00 Final Exam Final Exam - Advanced Game Development Course 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00
Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Big Data Analytics with PySpark Power BI and MongoDB Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Big Data Analytics with PySpark Power BI and MongoDB Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Big Data Analytics with PySpark Power BI and MongoDB Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Big Data Analytics with PySpark Power BI and MongoDB Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Big Data Analytics with PySpark Power BI and MongoDB? Unlimited access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Big Data Analytics with PySpark Power BI and MongoDB there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Big Data Analytics with PySpark Power BI and MongoDB course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skills. Prerequisites This Big Data Analytics with PySpark Power BI and MongoDB does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Big Data Analytics with PySpark Power BI and MongoDB was made by professionals and it is compatible with all PCs, Macs, tablets, and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Big Data Analytics with PySpark Power BI and MongoDB is a great way for you to gain multiple skills from the comfort of your home. Section 01: Introduction Introduction 00:10:00 Section 02: Setup and Installations Python Installation 00:03:00 Installing Apache Spark 00:12:00 Installing Java (Optional) 00:05:00 Testing Apache Spark Installation 00:06:00 Installing MongoDB 00:04:00 Installing NoSQL Booster for MongoDB 00:07:00 Section 03: Data Processing with PySpark and MongoDB Integrating PySpark with Jupyter Notebook 00:05:00 Data Extraction 00:19:00 Data Transformation 00:15:00 Loading Data into MongoDB 00:13:00 Section 04: Machine Learning with PySpark and MLlib Data Pre-processing 00:19:00 Building the Predictive Model 00:12:00 Creating the Prediction Dataset 00:08:00 Section 05: Creating the Data Pipeline Scripts Installing Visual Studio Code 00:03:00 Creating the PySpark ETL Script 00:22:00 Creating the Machine Learning Script 00:24:00 Section 06: Tableau Data Visualization Installing Tableau 00:03:00 Installing MongoDB ODBC Drivers 00:03:00 Creating a System DSN for MongoDB 00:04:00 Loading the Data Sources 00:04:00 Creating a Geo Map 00:11:00 Creating a Bar Chart 00:03:00 Creating a Magnitude Chart 00:07:00 Creating a Table Plot 00:06:00 Creating a Dashboard 00:07:00 Source Code Source Code and Notebook
This course is perfect for the beginner but also delves into building a SAS Model and intermediate topics. Learn SAS Data Step, SQL Step, Macros, SAS Model Building, Predictive Analytics, SAS and ML. If you are using SAS Enterprise Guide and want to learn how to code/program instead of using the point-and-click interface, this course is ideal!
Do you want to master the essential mathematical skills for data science and machine learning? Do you want to learn how to apply statistics and probability to real-world problems and scenarios? If yes, then this course is for you! In this course, you will learn the advanced concepts and techniques of statistics and probability that are widely used in data science and machine learning. You will learn how to describe and analyse data using descriptive statistics, distributions, and probability theory. You will also learn how to perform hypothesis testing, regressions, ANOVA, and machine learning algorithms to make predictions and inferences from data. You will gain hands-on experience with practical exercises and projects using Python and R. Learning Outcomes By the end of this course, you will be able to: Apply descriptive statistics, distributions, and probability theory to summarise and visualise data Perform hypothesis testing, regressions, ANOVA, and machine learning algorithms to make predictions and inferences from data Use Python and R to implement statistical and machine learning methods Interpret and communicate the results of your analysis using appropriate metrics and visualisations Solve real-world problems and scenarios using statistics and probability Why choose this Advanced Diploma in Statistics & Probability for Data Science & Machine Learning at QLS Level 7 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Advanced Diploma in Statistics & Probability for Data Science & Machine Learning at QLS Level 7 course for? This course is for anyone who wants to learn the advanced concepts and techniques of statistics and probability for data science and machine learning. This course is suitable for: Data scientists, machine learning engineers, and analysts who want to enhance their skills and knowledge Students and researchers who want to learn the mathematical foundations of data science and machine learning Professionals and managers who want to understand and apply data-driven decision making Hobbyists and enthusiasts who want to explore and learn from data Anyone who loves statistics and probability and wants to challenge themselves Career path Data Scientist (£35,000 - £55,000) Machine Learning Engineer (£40,000 - £60,000) Statistician (£35,000 - £55,000) Data Analyst (£40,000 - £60,000) Business Intelligence Analyst (£45,000 - £65,000) Senior Data Analyst (£50,000 - £70,000) Prerequisites This Advanced Diploma in Statistics & Probability for Data Science & Machine Learning at QLS Level 7 does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Advanced Diploma in Statistics & Probability for Data Science & Machine Learning at QLS Level 7 was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £135 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Section 01: Let's get started Welcome! 00:02:00 What will you learn in this course? 00:06:00 How can you get the most out of it? 00:06:00 Section 02: Descriptive statistics Intro 00:03:00 Mean 00:06:00 Median 00:05:00 Mode 00:04:00 Mean or Median? 00:08:00 Skewness 00:08:00 Practice: Skewness 00:01:00 Solution: Skewness 00:03:00 Range & IQR 00:10:00 Sample vs. Population 00:05:00 Variance & Standard deviation 00:11:00 Impact of Scaling & Shifting 00:19:00 Statistical moments 00:06:00 Section 03: Distributions What is a distribution? 00:10:00 Normal distribution 00:09:00 Z-Scores 00:13:00 Practice: Normal distribution 00:04:00 Solution: Normal distribution 00:07:00 Section 04: Probability theory Intro 00:01:00 Probability Basics 00:10:00 Calculating simple Probabilities 00:05:00 Practice: Simple Probabilities 00:01:00 Quick solution: Simple Probabilities 00:01:00 Detailed solution: Simple Probabilities 00:06:00 Rule of addition 00:13:00 Practice: Rule of addition 00:02:00 Quick solution: Rule of addition 00:01:00 Detailed solution: Rule of addition 00:07:00 Rule of multiplication 00:11:00 Practice: Rule of multiplication 00:01:00 Solution: Rule of multiplication 00:03:00 Bayes Theorem 00:10:00 Bayes Theorem - Practical example 00:07:00 Expected value 00:11:00 Practice: Expected value 00:01:00 Solution: Expected value 00:03:00 Law of Large Numbers 00:08:00 Central Limit Theorem - Theory 00:10:00 Central Limit Theorem - Intuition 00:08:00 Central Limit Theorem - Challenge 00:11:00 Central Limit Theorem - Exercise 00:02:00 Central Limit Theorem - Solution 00:14:00 Binomial distribution 00:16:00 Poisson distribution 00:17:00 Real life problems 00:15:00 Section 05: Hypothesis testing Intro 00:01:00 What is a hypothesis? 00:19:00 Significance level and p-value 00:06:00 Type I and Type II errors 00:05:00 Confidence intervals and margin of error 00:15:00 Excursion: Calculating sample size & power 00:11:00 Performing the hypothesis test 00:20:00 Practice: Hypothesis test 00:01:00 Solution: Hypothesis test 00:06:00 T-test and t-distribution 00:13:00 Proportion testing 00:10:00 Important p-z pairs 00:08:00 Section 06: Regressions Intro 00:02:00 Linear Regression 00:11:00 Correlation coefficient 00:10:00 Practice: Correlation 00:02:00 Solution: Correlation 00:08:00 Practice: Linear Regression 00:01:00 Solution: Linear Regression 00:07:00 Residual, MSE & MAE 00:08:00 Practice: MSE & MAE 00:01:00 Solution: MSE & MAE 00:03:00 Coefficient of determination 00:12:00 Root Mean Square Error 00:06:00 Practice: RMSE 00:01:00 Solution: RMSE 00:02:00 Section 07: Advanced regression & machine learning algorithms Multiple Linear Regression 00:16:00 Overfitting 00:05:00 Polynomial Regression 00:13:00 Logistic Regression 00:09:00 Decision Trees 00:21:00 Regression Trees 00:14:00 Random Forests 00:13:00 Dealing with missing data 00:10:00 Section 08: ANOVA (Analysis of Variance) ANOVA - Basics & Assumptions 00:06:00 One-way ANOVA 00:12:00 F-Distribution 00:10:00 Two-way ANOVA - Sum of Squares 00:16:00 Two-way ANOVA - F-ratio & conclusions 00:11:00 Section 09: Wrap up Wrap up 00:01:00 Assignment Assignment - Statistics & Probability for Data Science & Machine Learning 00:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00