471 Courses

Register on the CompTIA A+ (220-1002) today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The CompTIA A+ (220-1002) is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The CompTIA A+ (220-1002) Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the CompTIA A+ (220-1002), all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16.  Course Content Section 01: All About the CompTIA A+ 2019 Core 2 Exam 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 Section 02: Safety and Professionalism Professional Communication Part 1 00:06:00 Professional Communication Part 2 00:07:00 Physical Safety 00:07:00 Section 03: The Visible Computer 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 Section 04: CPUs 32-Bit vs. 64-Bit Processing 00:12:00 Section 05: RAM Virtual Memory 00:06:00 Section 06: Power Supply Power Protection 00:10:00 Section 07: Implementing Mass Storage 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 Section 08: Building a PC Boot from Everything 00:12:00 Installing Windows 00:12:00 Post-Installation Tasks 00:12:00 Windows Installation options 00:07:00 Section 09: Windows under the Hood 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 Section 10: Users, Groups, and Permissions 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 Section 11: Maintaining and Optimizing Operating Systems 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 Section 12: Working with the Command-Line Interface 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 Section 13: Troubleshooting Operating Systems 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 Section 14: Display Technologies Resolutions and Aspect Ratios 00:06:00 Multiple Monitors 00:05:00 Section 15: Essentials of Networking Network Card Troubleshooting 00:09:00 Section 16: Local Area Networking 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 Section 17: Wireless Networking Wireless Encryption 00:11:00 Enterprise Wireless 00:16:00 Section 18: The Internet 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 Section 19: Portable Computing Power Management 00:11:00 Section 20: Care and Feeding of Mobile Devices Mobile Device Security 00:08:00 Mobile Security Troubleshooting 00:06:00 Mobile Device Troubleshooting 00:10:00 Section 21: Securing Computers 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 Section 22: Operational Procedures 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

Follow your dreams by enrolling on the Financial Planning and Cashflow Management course today and develop the experience, skills and knowledge you need to enhance your professional development. Financial Planning and Cashflow Management will help you arm yourself with the qualities you need to work towards your dream job. Study the Financial Planning and Cashflow Management training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Financial Planning and Cashflow Management course will allow you to enhance your CV, impress potential employers, and stand out from the crowd. This Financial Planning and Cashflow Management course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Financial Planning and Cashflow Management course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Financial Planning and Cashflow Management course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Financial Planning and Cashflow Management course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Financial Planning and Cashflow Management course. The Financial Planning and Cashflow Management course is designed by industry experts and is tailored to help you learn new skills with ease. The Financial Planning and Cashflow Management is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Financial Planning and Cashflow Management when it suits you. Access the Financial Planning and Cashflow Management course modules from any internet-enabled device, including computers, tablets, and smartphones. The Financial Planning and Cashflow Management course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Financial Planning and Cashflow Management now and start learning instantly! What You Get Out Of Studying Financial Planning and Cashflow Management With Janets Free PDF certificate upon successful completion of the Financial Planning and Cashflow Management Full one-year access to Financial Planning and Cashflow Management Course materials Instant assessment results with the Financial Planning and Cashflow Management No hidden fees with the Financial Planning and Cashflow Management Full tutor support available from Monday to Friday with the Financial Planning and Cashflow Management Study the Financial Planning and Cashflow Management at your own pace Benefit from instant feedback through mock exams and multiple-choice assessments Gain a complete understanding of Financial Planning and Cashflow Management Accessible, informative modules taught by expert instructors Get 24/7 help or advice from our email and live chat teams with the Financial Planning and Cashflow Management Study the Financial Planning and Cashflow Management in your own time through your computer, tablet or mobile device Improve your chance of gaining professional skills and better earning potential by completing the Financial Planning and Cashflow Management Description  The Financial Planning and Cashflow Management training course is delivered through Janets' online learning platform. Access the Financial Planning and Cashflow Management content from any internet-enabled device whenever or wherever you want to. The Financial Planning and Cashflow Management course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment  To successfully complete the Financial Planning and Cashflow Management course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Financial Planning and Cashflow Management course. After successfully passing the Financial Planning and Cashflow Management course exam, you will be able to apply for a CPD-accredited certificate as proof of your Financial Planning and Cashflow Management qualification. Certification All students who successfully complete the Financial Planning and Cashflow Management course can instantly download their digital certificate. You can also purchase a hard copy of the Financial Planning and Cashflow Management course certificate, which will be delivered by post for £9.99. Who Is This Course For: The Financial Planning and Cashflow Management is ideal for those who already work in this sector or are an aspiring professional. This Financial Planning and Cashflow Management course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The Financial Planning and Cashflow Management is open to all students and has no formal entry requirements. To study the Financial Planning and Cashflow Management course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The Financial Planning and Cashflow Management is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Financial Planning and Cashflow Management and gain an industry-recognised qualification that will help you excel in finding your ideal job. Course Content Personal Finance Calculations Calculating Your Net Worth 00:01:00 Calculating Your Real Hourly Wage 00:02:00 Expenses for Life Energy 00:02:00 Calculating a Monthly Budgeting 00:05:00 Saving for Retirement Paying Off Debt 00:02:00 Build an Emergency Fund 00:02:00 Personal Savings 00:04:00 401K Basics 00:03:00 Asset Allocation 00:04:00 Investment Strategies 00:03:00 Advice on Financial Advisors 00:01:00 3h-Questions-About-Investing 00:15:00 Building Credit to Buy a Home FICO Score 00:09:00 Starting Credit 00:03:00 Increasing Credit Score 00:02:00 Owning vs. Renting 00:02:00 Types of Mortages 00:03:00 Personal Finance Guides for Beginners Advice to Teenagers 00:04:00 Guide to Buying a Car 00:05:00 Cashflow Management Forecasting 00:20:00 What is Cashflow? 00:20:00 Planning and Management9 00:10:00 Planning Part 2 00:12:00 Where it can go Wrong 00:09:00 Personal Cashflow Analysis 00:05:00 Personal Cashflow Analysis my Numbers Story 00:06:00 Debt 00:10:00 Budgets and Money Management Finance Jeopardy 00:15:00 The Fundamentals of Finance 00:15:00 The Basics of Budgeting 00:15:00 Parts of a Budget 00:15:00 The Budgeting Process 00:30:00 Budgeting Tips and Tricks 00:15:00 Monitoring and Managing Budgets 00:15:00 Crunching the Numbers 00:15:00 Getting Your Budget Approved 00:15:00 Comparing Investment Opportunities 00:15:00 ISO 9001:2008 00:15:00 Directing the Peerless Data Corporation 00:30:00 Assessment Assignment - Financial Planning and Cashflow Management 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

What you will learn from this course? Gain comprehensive knowledge about corporate finance Understand the core competencies and principles of corporate finance Explore the various areas of corporate finance Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert financial manager or financial analyst Course Highlights Course Type: Self-paced online course Duration: 1 to 2 hours Tutor Support: Full tutor support is included Customer Support: 24/7 customer support is available Principles of Business Marketing and Finance Program Course Master the skills you need to propel your career forward in corporate finance. This course will equip you with the essential knowledge and skillset that will make you a confident financial manager or financial analyst and take your career to the next level. This comprehensive principles of business marketing and finance program course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this principles of business course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This principles of business at QLS Level 5 course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. This comprehensive course will teach you the theory of effective corporate finance practice and equip you with the essential skills, confidence and competence to assist you in the corporate finance industry. You'll gain a solid understanding of the core competencies required to drive a successful career in corporate finance. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for financial manager or financial analyst or for people who are aspiring to specialise in corporate finance. Enrol in this principles of business marketing and finance program course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive principles of business marketing and finance program course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this corporate finance can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This principles of business marketing and finance program course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This principles of business marketing and finance program course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This principles of business marketing and finance program course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Study Plex Subscription Study plex also provides a subscription option that allows you unlimited access to more than 700+ CPD courses for learning. You only need to spend £79 to take advantage of this fantastic offer, and you'll get an unlimited subscription for a full year. Additionally, you can cancel your membership from your account at any time by getting in touch with our friendly and devoted customer care team. Visit our subscriptions page for more details if you're interested. Why you should train with Study Plex? At Study Plex, you will have the chance to build social, technical and personal skills through a combination of extensive subjects tailored according to your interest. Along with receiving comprehensive knowledge and transferable skills, there are even more reasons o be involved with us, which include: Incredible Customer Support: We offer active customer service in the form of live chat, which you can access 24/7 Expert Tutor Support: You'll have access to our devoted and dedicated tutor support with all of our courses whenever you need it. Price Justified by Quality: We ensure that you will have the best experience possible for the price you are paying for the course. Money-back Guarantee: We provide a money-back guarantee if you are not satisfied with the course's quality. There is a 14-day time limit on this option (according to the terms and conditions). Instalment Facility: If your course costs more than £50, you can pay in three instalments using the instalment option. Satisfaction Guarantee: Our courses are designed to meet your demands and expectations by all means. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction Introduction 00:22:00 Financial Statements Financial Statements 00:33:00 Ratio Analysis Introduction 00:07:00 Liquidity Ratios 00:14:00 Operating Efficiency Ratios 00:17:00 Leverage Ratios 00:13:00 Return on Equity 00:10:00 Time Value of Money Introduction 00:04:00 Calculator Tutorial 00:14:00 Future Value 00:29:00 Present Value 00:26:00 Annuities and Cash Flows 00:52:00 Practice Questions 00:35:00 Loan Amortization 00:20:00 Capital Budgeting Introduction 00:05:00 Payback Method 00:23:00 Payback Using Excel 00:08:00 Net Present Value - Internal Rate of Return - Profitability Index 00:21:00 Cash Flows Cash Flows Budgeting Steps 00:23:00 Capital Rationing 00:16:00 Cash Flow Examples 00:18:00 More Examples 00:24:00 Risk and Return Introduction 00:02:00 Inflation and Return 00:21:00 Risk 00:17:00 Diversification 00:14:00 Pricing Risk - Capital Asset Pricing Model 00:11:00 Bonds Introduction 00:17:00 Valuation 00:14:00 Yield to Maturity 00:08:00 Examples 00:11:00 Stocks Introduction 00:08:00 Preferred Stocks 00:15:00 Common Stocks 00:16:00 Cost of Capital Introduction 00:07:00 Cost of Debt 00:13:00 Cost of Preferred Stocks 00:03:00 Cost of Equity 00:05:00 Weighted Average Cost of Capital 00:05:00 Capital Structure Introduction 00:09:00 Proposition 1 00:10:00 Proposition 2 00:07:00 Proposition 3 00:14:00 Capital Markets Capital Markets 00:19:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Feedback Feedback 00:00:00

Discover the power of data science and machine learning with Python! Learn essential techniques, algorithms, and tools to analyze data, build predictive models, and unlock insights. Dive into hands-on projects, from data manipulation to advanced machine learning applications. Elevate your skills and unleash the potential of Python for data-driven decision-making.

Overview Mastering data science skills and expertise can open new doors of opportunities for you in a wide range of fields. Learn the fundamentals and develop a solid grasp of Python data science with the comprehensive Data Science with Python course. This course is designed to assist you in securing a valuable skill set and boosting your career. This course will provide you with quality training on the fundamentals of data analysis with Python. From the step-by-step learning process, you will learn the techniques of setting up the system. Then the course will teach you Python data structure and functions. You will receive detailed lessons on NumPy, Matplotlib, and Pandas. Furthermore, you will develop the skills for Algorithm Evaluation Techniques, visualising datasets and much more. After completing the course you will receive a certificate of achievement. This certificate will help you create an impressive resume. So join today! 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? This course Data Science with Python course is ideal for beginners in data science. It will help them develop a solid grasp of Python and help them pursue their dream career in the field of data science. Requirements The students will not require any formal qualifications or previous experience to enrol in this course. Anyone can learn from the course anytime from anywhere through smart devices like laptops, tabs, PC, and smartphones with stable internet connections. They can complete the course according to their preferable pace so, there is no need to rush. Career Path This course will equip you with valuable knowledge and effective skills in this area. After completing the course, you will be able to explore career opportunities in the fields such as Data Analyst Data Scientist Data Manager Business Analyst And much more! Course Curriculum 90 sections • 90 lectures • 10:19:00 total length •Course Overview & Table of Contents: 00:09:00 •Introduction to Machine Learning - Part 1 - Concepts , Definitions and Types: 00:05:00 •Introduction to Machine Learning - Part 2 - Classifications and Applications: 00:06:00 •System and Environment preparation - Part 1: 00:04:00 •System and Environment preparation - Part 2: 00:06:00 •Learn Basics of python - Assignment 1: 00:10:00 •Learn Basics of python - Assignment 2: 00:09:00 •Learn Basics of python - Functions: 00:04:00 •Learn Basics of python - Data Structures: 00:12:00 •Learn Basics of NumPy - NumPy Array: 00:06:00 •Learn Basics of NumPy - NumPy Data: 00:08:00 •Learn Basics of NumPy - NumPy Arithmetic: 00:04:00 •Learn Basics of Matplotlib: 00:07:00 •Learn Basics of Pandas - Part 1: 00:06:00 •Learn Basics of Pandas - Part 2: 00:07:00 •Understanding the CSV data file: 00:09:00 •Load and Read CSV data file using Python Standard Library: 00:09:00 •Load and Read CSV data file using NumPy: 00:04:00 •Load and Read CSV data file using Pandas: 00:05:00 •Dataset Summary - Peek, Dimensions and Data Types: 00:09:00 •Dataset Summary - Class Distribution and Data Summary: 00:09:00 •Dataset Summary - Explaining Correlation: 00:11:00 •Dataset Summary - Explaining Skewness - Gaussian and Normal Curve: 00:07:00 •Dataset Visualization - Using Histograms: 00:07:00 •Dataset Visualization - Using Density Plots: 00:06:00 •Dataset Visualization - Box and Whisker Plots: 00:05:00 •Multivariate Dataset Visualization - Correlation Plots: 00:08:00 •Multivariate Dataset Visualization - Scatter Plots: 00:05:00 •Data Preparation (Pre-Processing) - Introduction: 00:09:00 •Data Preparation - Re-scaling Data - Part 1: 00:09:00 •Data Preparation - Re-scaling Data - Part 2: 00:09:00 •Data Preparation - Standardizing Data - Part 1: 00:07:00 •Data Preparation - Standardizing Data - Part 2: 00:04:00 •Data Preparation - Normalizing Data: 00:08:00 •Data Preparation - Binarizing Data: 00:06:00 •Feature Selection - Introduction: 00:07:00 •Feature Selection - Uni-variate Part 1 - Chi-Squared Test: 00:09:00 •Feature Selection - Uni-variate Part 2 - Chi-Squared Test: 00:10:00 •Feature Selection - Recursive Feature Elimination: 00:11:00 •Feature Selection - Principal Component Analysis (PCA): 00:09:00 •Feature Selection - Feature Importance: 00:06:00 •Refresher Session - The Mechanism of Re-sampling, Training and Testing: 00:12:00 •Algorithm Evaluation Techniques - Introduction: 00:07:00 •Algorithm Evaluation Techniques - Train and Test Set: 00:11:00 •Algorithm Evaluation Techniques - K-Fold Cross Validation: 00:09:00 •Algorithm Evaluation Techniques - Leave One Out Cross Validation: 00:05:00 •Algorithm Evaluation Techniques - Repeated Random Test-Train Splits: 00:07:00 •Algorithm Evaluation Metrics - Introduction: 00:09:00 •Algorithm Evaluation Metrics - Classification Accuracy: 00:08:00 •Algorithm Evaluation Metrics - Log Loss: 00:03:00 •Algorithm Evaluation Metrics - Area Under ROC Curve: 00:06:00 •Algorithm Evaluation Metrics - Confusion Matrix: 00:10:00 •Algorithm Evaluation Metrics - Classification Report: 00:04:00 •Algorithm Evaluation Metrics - Mean Absolute Error - Dataset Introduction: 00:06:00 •Algorithm Evaluation Metrics - Mean Absolute Error: 00:07:00 •Algorithm Evaluation Metrics - Mean Square Error: 00:03:00 •Algorithm Evaluation Metrics - R Squared: 00:04:00 •Classification Algorithm Spot Check - Logistic Regression: 00:12:00 •Classification Algorithm Spot Check - Linear Discriminant Analysis: 00:04:00 •Classification Algorithm Spot Check - K-Nearest Neighbors: 00:05:00 •Classification Algorithm Spot Check - Naive Bayes: 00:04:00 •Classification Algorithm Spot Check - CART: 00:04:00 •Classification Algorithm Spot Check - Support Vector Machines: 00:05:00 •Regression Algorithm Spot Check - Linear Regression: 00:08:00 •Regression Algorithm Spot Check - Ridge Regression: 00:03:00 •Regression Algorithm Spot Check - Lasso Linear Regression: 00:03:00 •Regression Algorithm Spot Check - Elastic Net Regression: 00:02:00 •Regression Algorithm Spot Check - K-Nearest Neighbors: 00:06:00 •Regression Algorithm Spot Check - CART: 00:04:00 •Regression Algorithm Spot Check - Support Vector Machines (SVM): 00:04:00 •Compare Algorithms - Part 1 : Choosing the best Machine Learning Model: 00:09:00 •Compare Algorithms - Part 2 : Choosing the best Machine Learning Model: 00:05:00 •Pipelines : Data Preparation and Data Modelling: 00:11:00 •Pipelines : Feature Selection and Data Modelling: 00:10:00 •Performance Improvement: Ensembles - Voting: 00:07:00 •Performance Improvement: Ensembles - Bagging: 00:08:00 •Performance Improvement: Ensembles - Boosting: 00:05:00 •Performance Improvement: Parameter Tuning using Grid Search: 00:08:00 •Performance Improvement: Parameter Tuning using Random Search: 00:06:00 •Export, Save and Load Machine Learning Models : Pickle: 00:10:00 •Export, Save and Load Machine Learning Models : Joblib: 00:06:00 •Finalizing a Model - Introduction and Steps: 00:07:00 •Finalizing a Classification Model - The Pima Indian Diabetes Dataset: 00:07:00 •Quick Session: Imbalanced Data Set - Issue Overview and Steps: 00:09:00 •Iris Dataset : Finalizing Multi-Class Dataset: 00:09:00 •Finalizing a Regression Model - The Boston Housing Price Dataset: 00:08:00 •Real-time Predictions: Using the Pima Indian Diabetes Classification Model: 00:07:00 •Real-time Predictions: Using Iris Flowers Multi-Class Classification Dataset: 00:03:00 •Real-time Predictions: Using the Boston Housing Regression Model: 00:08:00 •Resources - Data Science & Machine Learning with Python: 00:00:00

Overview This comprehensive course on CompTIA Network (N10-007) will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This CompTIA Network (N10-007) 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 Network (N10-007). It is available to all students, of all academic backgrounds. Requirements Our CompTIA Network (N10-007) 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 22 sections • 172 lectures • 22:43:00 total length •Introduction: 00:03:00 •What is a Model?: 00:02:00 •OSI vs. TCP/IP Model: 00:07:00 •Walking Through OSI and TCP/IP: 00:12:00 •Meet the Frame: 00:06:00 •The MAC Address: 00:07:00 •Broadcast vs. Unicast: 00:04:00 •Introduction to IP Addressing: 00:08:00 •Packets and Ports: 00:05:00 •Network Topologies: 00:10:00 •Coaxial Cabling: 00:05:00 •Twisted Pair Cabling: 00:06:00 •Cat Ratings: 00:06:00 •Fiber Optic Cabling: 00:09:00 •Fire Ratings: 00:05:00 •Legacy Network Connections: 00:07:00 •What is Ethernet?: 00:07:00 •Ethernet Frames: 00:07:00 •Early Ethernet: 00:08:00 •The Daddy of Ethernet, 10BaseT: 00:03:00 •Terminating Twisted Pair: 00:14:00 •Hubs vs. Switches: 00:13:00 •100BaseT: 00:05:00 •Connecting Switches: 00:05:00 •Gigabit Ethernet and 10-Gigabit Ethernet: 00:05:00 •Transceivers: 00:07:00 •Connecting Ethernet Scenarios: 00:14:00 •Introduction to Structured Cabling: 00:04:00 •Terminating Structured Cabling: 00:08:00 •Equipment Room: 00:07:00 •Alternative Distribution Panels: 00:04:00 •Testing Cable: 00:09:00 •Troubleshooting Structured Cabling, Part 1: 00:05:00 •Troubleshooting Structured Cabling, Part 2: 00:05:00 •Using a Toner and Probe: 00:03:00 •Wired Connection Scenarios: 00:11:00 •Introduction to IP Addressing and Binary: 00:13:00 •Introduction to ARP: 00:04:00 •Classful Addressing: 00:10:00 •Subnet Masks: 00:12:00 •Subnetting with CIDR: 00:10:00 •More CIDR Subnetting Practice: 00:10:00 •Dynamic and Static IP Addressing: 00:18:00 •Rogue DHCP Servers: 00:07:00 •Special IP Addresses: 00:07:00 •IP Addressing Scenarios: 00:15:00 •Introducing Routers: 00:15:00 •Understanding Ports: 00:05:00 •Network Address Translation: 00:06:00 •Implementing NAT: 00:03:00 •Forwarding Ports: 00:18:00 •Tour of a SOHO Router: 00:12:00 •SOHO vs. Enterprise: 00:09:00 •Static Routes: 00:13:00 •Dynamic Routing: 00:11:00 •RIP: 00:04:00 •OSPF: 00:04:00 •BGP: 00:06:00 •TCP and UDP: 00:07:00 •ICMP and IGMP: 00:06:00 •Handy Tools: 00:07:00 •Introduction to Wireshark: 00:11:00 •Introduction to netstat: 00:09:00 •Web Servers: 00:12:00 •FTP: 00:12:00 •E-mail Servers and Clients: 00:09:00 •Securing E-mail: 00:06:00 •Telnet and SSH: 00:09:00 •Network Time Protocol: 00:02:00 •Network Service Scenarios: 00:10:00 •Understanding DNS: 00:12:00 •Applying DNS: 00:19:00 •The Hosts File: 00:04:00 •Net Command: 00:08:00 •Windows Name Resolution: 00:11:00 •Dynamic DNS: 00:05:00 •DNS Troubleshooting: 00:13:00 •Making TCP/IP Secure: 00:04:00 •Symmetric Encryption: 00:06:00 •Asymmetric Encryption: 00:03:00 •Cryptographic Hashes: 00:05:00 •Identification: 00:00:00 •Access Control: 00:04:00 •AAA: 00:05:00 •Kerberos/EAP: 00:00:00 •Single Sign-On: 00:10:00 •Certificates and Trust: 00:14:00 •Certificate Error Scenarios: 00:08:00 •Understanding IP Tunneling: 00:06:00 •Virtual Private Networks: 00:13:00 •Introduction to VLANs: 00:12:00 •InterVLAN Routing: 00:03:00 •Interfacing with Managed Switches: 00:11:00 •Switch Port Protection: 00:07:00 •Port Bonding: 00:07:00 •Port Mirroring: 00:04:00 •Quality of Service: 00:05:00 •IDS vs. IPS: 00:04:00 •Proxy Servers: 00:13:00 •Load Balancing: 00:09:00 •Device Placement Scenarios: 00:13:00 •Introduction to IPv6: 00:13:00 •IPv6 Addressing: 00:15:00 •IPv6 in Action: 00:13:00 •IPv4 and IPv6 Tunneling: 00:05:00 •Telephony Technologies: 00:09:00 •Optical Carriers: 00:03:00 •Packet Switching: 00:05:00 •Connecting with Dial-up: 00:05:00 •Digital Subscriber Line (DSL): 00:05:00 •Connecting with Cable Modems: 00:04:00 •Connecting with Satellites: 00:03:00 •ISDN and BPL: 00:04:00 •Remote Desktop Connectivity: 00:05:00 •Advanced Remote Control Systems: 00:09:00 •Introduction to 802.11: 00:12:00 •802.11 Standards: 00:12:00 •Power over Ethernet (PoE): 00:04:00 •Antennas: 00:09:00 •Wireless Security Standards: 00:16:00 •Implementing Wireless Security: 00:07:00 •Threats to Your Wireless Network: 00:07:00 •Retro Threats: 00:05:00 •Wi-Fi Protected Setup (WPS): 00:05:00 •Enterprise Wireless: 00:06:00 •Installing a Wireless Network: 00:15:00 •Wireless Scenarios: 00:07:00 •More Wireless Scenarios: 00:09:00 •Virtualization Basics: 00:07:00 •Cloud Ownership: 00:03:00 •Cloud Implementation: 00:12:00 •Your First Virtual Machine: 00:09:00 •NAS and SAN: 00:16:00 •Platform as a Service (PaaS): 00:09:00 •Software as a Service (SaaS): 00:03:00 •Infrastructure as a Service (IaaS): 00:10:00 •Cellular Technologies: 00:05:00 •Mobile Connectivity: 00:07:00 •Deploying Mobile Devices: 00:05:00 •Mobile Access Control: 00:06:00 •Network Types: 00:04:00 •Network Design: 00:10:00 •Power Management: 00:06:00 •Unified Communications: 00:11:00 •Network Documentation: 00:07:00 •Contingency Planning: 00:10:00 •Predicting Hardware Failure: 00:05:00 •Backups: 00:08:00 •What is Risk Management?: 00:06:00 •Security Policies: 00:08:00 •Change Management: 00:07:00 •User Training: 00:03:00 •Standard Business Documentation: 00:05:00 •Mitigating Network Threats: 00:05:00 •High Availability: 00:05:00 •Denial of Service: 00:09:00 •Malware: 00:10:00 •Social Engineering: 00:04:00 •Access Control: 00:08:00 •Man-in-the-Middle: 00:22:00 •Introduction to Firewalls: 00:05:00 •Firewalls: 00:10:00 •DMZ: 00:06:00 •Hardening Devices: 00:14:00 •Physical Security Controls: 00:09:00 •Testing Network Security: 00:08:00 •Network Protection Scenarios: 00:14:00 •SNMP: 00:15:00 •Documenting Logs: 00:09:00 •System Monitoring: 00:08:00 •SIEM (Security Information and Event Management): 00:07:00 •Network Troubleshooting Theory: 00:05:00

The comprehensive Learn AutoCAD Programming using VB.NET has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Learn AutoCAD Programming using VB.NET today, and learn from the very best the industry has to offer! This best selling Learn AutoCAD Programming using VB.NET has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Learn AutoCAD Programming using VB.NET is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Learn AutoCAD Programming using VB.NET is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Learn AutoCAD Programming using VB.NET is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Learn AutoCAD Programming using VB.NET, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Learn AutoCAD Programming using VB.NET will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Learn AutoCAD Programming using VB.NET to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Learn Scrum, a popular framework used to develop software applications through the Agile methodology. This course provides you with step-by-step instructions for learning Scrum and gaining a strong foundation toward various Scrum certifications. Learn Scrum with a build-along experience and apply Scrum in your Agile-based product team at work.

Accounting won't be a problem after you are done with this course Are you good with numbers? Does keeping track of everyday transaction sound intriguing to you? Then you should definitely have a career in Accounting. Accountants whose work is of a high standard can quickly progress to positions of responsibility. And accountancy roles often attract high salaries. Accountants are in demand in a variety of sectors and organisations. You could work in business or finance, the public sector, the charity sector or public practice. You could choose to work for anyone from a large international accountancy firm to a small local business. And you can work in general practice or specialise in areas. Far from being all about number crunching, a career in accountancy will give you the opportunity to use a variety of skills including leadership, problem-solving, team-working and communication skills. This course will teach you all these attributes and everything you need to know about accounting. Course Highlights Advanced Accounting Diploma is an award-winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Advanced Accounting Diploma into 96 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 2 days, 20 hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Advanced Accounting Diploma Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Advanced Accounting Diploma is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Advanced Accounting Diploma is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Accounting Course Overview FREE 00:05:00 Getting the Facts Straight FREE 00:30:00 The Accounting Cycle 00:30:00 The Key Reports 00:30:00 A Review of Financial Terms 00:30:00 Understanding Debits and Credits 00:15:00 Your Financial Analysis Toolbox 00:30:00 Identifying High and Low Risk Companies 00:30:00 The Basics of Budgeting 00:30:00 Working Smarter 00:10:00 Bookkeeping Module One - Introduction FREE 00:30:00 Module Two - Basic Terminology FREE 01:00:00 Module Three - Basic Terminology (II) 01:00:00 Module Four - Accounting Methods 01:00:00 Module Five - Keeping Track of Your Business 01:00:00 Module Six - Understanding the Balance Sheet 01:00:00 Module Seven - Other Financial Statements 01:00:00 Module Eight - Payroll Accounting Terminology 01:00:00 Module Nine - End of Period Procedures 01:00:00 Module Ten - Financial Planning, Budgeting and Control 01:00:00 Module Eleven - Auditing 01:00:00 Module Twelve - Wrapping Up 00:30:00 Payroll Management What Is Payroll? FREE 01:00:00 Principles Of Payroll Systems FREE 01:00:00 Confidentiality And Security Of Information 00:30:00 Effective Payroll Processing 01:00:00 Increasing Payroll Efficiency 01:00:00 Risk Management in Payroll 00:30:00 Time Management 00:30:00 Personnel Filing 01:00:00 When Workers Leave Employment 01:00:00 Hiring Employees 01:00:00 Paye and Payroll for Employers 01:00:00 Tell HMRC about a New Employee 01:00:00 Net And Gross Pay 01:00:00 Statutory Sick Pay 00:30:00 Minimum Wage for Different types of Work 01:00:00 Tax System in the UK Tax System in the UK 01:00:00 Tax Management USA Individual Tax Saving Ideas 01:00:00 Tax Saving Measures For Business 01:00:00 The Tax Audit 01:00:00 The Ins And Outs Of Federal Payroll Taxes 02:00:00 Why People File Taxes Online 00:30:00 What Are Your County Property Taxes Used For? 00:30:00 Offering Personal Financial Advice -Ameriprise Financial Services 01:00:00 Using Free Tax Preparation Software 00:30:00 Consulting Tax Attorneys - Tax Law Specialists 00:30:00 Delinquent Property Taxes- Three Steps To Deal With Your Delinquent Property Taxes 01:00:00 Federal Income Taxes - How To Deal With Federal Income Taxes? 01:00:00 File State Taxes- E-File System Is The Best Way To File Your State Taxes 00:30:00 Filing Income Taxes- How To File Income Taxes? 01:00:00 Financial Planning Software- Nine Benefits Of Financial Planning Software 01:00:00 Free Taxes- Benefits Of Filing Free Taxes Online 00:30:00 Income Tax Forms- Three Must To Follow If You Desire To Fill Your Income Tax Forms Yourself 00:30:00 LLC Tax Savings- How To Avail LLC Tax Savings 00:30:00 Benefits Of Online Tax Forms Over Traditional Methods 00:30:00 Save On Taxes By Refinancing Your Mortgage 00:30:00 Save On Taxes By Spending Less On Credit 00:30:00 Save On Taxes By Investing In Life Insurance 00:30:00 Save On Taxes: Hot Tips 01:00:00 Save On Taxes With Tax Deductions 01:00:00 Federal Tax Law 2005 For Nonprofit Organizations 00:30:00 Understanding California State Taxes 00:30:00 Make Your Personal Finances Work for You 01:00:00 The Importance of Acquiring a Financial Planning Certificate 00:30:00 Social Development and Financial Planning 01:00:00 An Overview Of Hennepin County Property Taxes 00:30:00 Kentucky State Taxes 01:00:00 Maryland State Taxes 01:00:00 Ohio State Taxes 00:30:00 UBS Financial Services For Small And Large Business 00:30:00 What Is A VP Financial Planner? 00:15:00 Accounting Career Basics A Career in Accounting: Tips on How You Can be Successful 00:30:00 Accountancy Auditing Careers 00:30:00 Accountancy Career Change 00:30:00 Accountancy Career: The Reasons Why You Should Choose Accounting 01:00:00 Accounting/Accountancy Career: Steps to Success 00:30:00 Accounting Auditing Careers 00:30:00 Accounting Careers in Pontypridd 00:30:00 Accounting Careers: Promising Opportunities and Tips 00:30:00 Accounting Dictionary 00:30:00 Accounting Principles and Tulsa 00:30:00 Accounting Software for Small Businesses 00:30:00 Accounting Terms - Profit, Loss and Other Terms 00:30:00 Accounting Career Fundamentals Accounting 00:30:00 Advanced Accounting Career Training 00:30:00 Careers in Accountancy 01:00:00 Church Accounting Software 00:30:00 Finding an Accounting Job 00:30:00 Forensic Accounting 00:30:00 Free Accounting Software 00:30:00 List of Accounting Careers 00:30:00 Services in Financial Accounting 00:30:00 Successful Career in Accounting Even if You're Hit Forty! 00:30:00 The Benefits of an Accountancy Career 00:30:00 Types of Accountancy Career 00:30:00 Mock Exam Mock Exam- Advanced Accounting Diploma 00:30:00 Final Exam Final Exam- Advanced Accounting Diploma 00:30: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