The course 'Microsoft Excel' covers the latest features of Microsoft Excel 2019, introducing learners to CONCAT, IFS, MAXIFS, MINIFS, SWITCH, TEXTJOIN, Map Chart, Funnel Chart, and other enhancements. It also covers fundamental Excel skills, data analysis, visualization, pivot tables, workbook management, and automation using VBA. Learning Outcomes: Familiarize with the new features in Microsoft Excel 2019, including CONCAT, IFS, MAXIFS, MINIFS, SWITCH, and more. Gain proficiency in basic Excel tasks like navigating the user interface, entering data, and using Excel commands. Perform calculations, create formulas, and use functions to analyze and manipulate data effectively. Format worksheets, apply conditional formatting, and utilize templates to present data professionally. Understand data visualization using charts, sparklines, and mapping techniques in Excel. Work with PivotTables and PivotCharts for in-depth data analysis and presentation. Learn advanced Excel features such as data validation, scenarios, and Goal Seek. Automate workbook functionality using macros and Visual Basic for Applications (VBA). Collaborate on workbooks, protect data, and apply security measures in Excel. Create and work with Excel templates to streamline repetitive tasks and optimize workflow. Why buy this Microsoft Excel? Unlimited access to the course for forever PDF Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Microsoft Excel you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Microsoft Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning. Prerequisites This Microsoft Excel was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Microsoft Excel is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started with Microsoft Office Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:16:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Excel VBA Data Management Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 and VBA 00:00:00 Excel Templates Excel Templates 00:00:00 Mock Exam Mock Exam - Microsoft Excel 00:20:00 Final Exam Final Exam - Microsoft Excel 00:20:00
Embark on a comprehensive journey into the world of MySQL with a focus on its applications in Data Science and Analytics. This course is structured to take you from the fundamentals to advanced topics in MySQL Server. Covering SQL basics, data manipulation and definition, control and analytic functions, and database management, you'll acquire the essential skills for harnessing MySQL's power in data-driven decision-making. Learning Outcomes: Establish a strong foundation in SQL and MySQL. Set up and configure SQL Server for efficient data handling. Master SQL's Data Manipulation, Definition, and Control Language. Create and optimize SQL queries for data analysis. Perform advanced data analytics using SQL. Understand the power of GROUP BY and JOIN statements. Implement data constraints and views for data integrity and security. Develop proficiency in stored procedures, data import/export, and database backup/restore. Why buy this Learn MySQL from Scratch for Data Science and Analytics? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Learn MySQL from Scratch for Data Science and Analytics you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Learn MySQL from Scratch for Data Science and Analytics course is ideal for Aspiring Data Scientists and Analysts. Database Administrators and Developers. Students and professionals seeking to enter the field of Data Science. Anyone looking to enhance their SQL and MySQL skills for data-related roles. Prerequisites This Learn MySQL from Scratch for Data Science and Analytics was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Data Analyst: £25,000 - £50,000 per year. Database Administrator: £30,000 - £60,000 per year. SQL Developer: £30,000 - £60,000 per year. Data Scientist: £40,000 - £80,000 per year. Business Intelligence Analyst: £35,000 - £65,000 per year. Course Curriculum Learn MySQL from Scratch for Data Science and Analytics Section 01: Getting Started Introduction 00:02:00 How to get course requirements 00:01:00 Getting started on Windows, Linux or Mac 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 What is Source Code? 00:09:00 Section 02: SQL Server setting up Section Introduction 00:01:00 MySQL Server Installation 00:14:00 Connect MySQL Server Instance 00:06:00 MySQL Workbench overview 00:11:00 Download and Restore Sample Database 00:08:00 Section 03: SQL Database basics Section Introduction 00:01:00 Overview of Databases 00:09:00 Creating Database 00:07:00 SQL Data Types 00:04:00 Column Data Types on Workbench 00:07:00 Creating Table 00:04:00 Overview of Primary and Foreign Key 00:03:00 Primary Key 00:06:00 Foreign Key 00:12:00 Creating Temporary tables 00:12:00 EER - Enhanced Entity Relationship Diagrams 00:04:00 Section 04: SQL DML (Data Manipulation Language) Section Introduction 00:01:00 Insert statement 00:07:00 Update statement 00:06:00 Delete statement 00:03:00 Section 05: SQL DDL (Data Definition Language) Section Introduction 00:01:00 CREATE table statement 00:08:00 DROP statement 00:03:00 ALTER statement 00:05:00 TRUNCATE statement 00:03:00 COMMENT in query 00:02:00 RENAME table 00:03:00 Section 06: SQL DCL (Data Control Language) Create Database user 00:03:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 07: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:03:00 SELECT DISTINCT 00:02:00 SELECT with column headings 00:01:00 Column AS statement 00:02:00 DASHBOARD Analytics 00:06:00 Section 08: Filtering Data rows SELECT WHERE Clause - theory 00:03:00 SELECT WHERE Clause - practical 00:06:00 Section 09: Aggregate functions for Data Analysis Sum() 00:06:00 Min()-Max() 00:03:00 Section 10: SQL Data Analyticstatements Order By statement 00:05:00 SELECT TOP 3 records 00:02:00 BETWEEN command 00:06:00 IN operator 00:03:00 Search Data usingLIKE cards 00:05:00 Section 11: SQL Group by statement Section Introduction 00:01:00 Group by - theory 00:04:00 Data Analytics with Group By 00:04:00 HAVING statement 00:03:00 Section 12: JOINS Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:07:00 Left outer join 00:02:00 Right outer join 00:02:00 Union 00:03:00 CERTESIAN Product or Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 13: SQL Constraints Section introduction 00:01:00 Check constraint 00:09:00 NOT NULL constraint 00:03:00 UNIQUE constraint 00:06:00 Section 14: Views Creating Views 00:03:00 Data Analytic Views from multiple tables 00:03:00 Section 15: Advanced SQL Functions Section Introduction 00:01:00 Timestamp 00:03:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:03:00 String functions3 00:07:00 Advanced functions 00:04:00 Sub Queries 00:03:00 SELECT with calculations 00:05:00 Section 16: SQL Stored procedures Create stored procedure 00:06:00 Stored procedure with parameter 00:03:00 Drop Procedure 00:01:00 Section 17: Import & Export data Section Introduction 00:01:00 Import .csv file 00:04:00 Export Data to .csv file 00:02:00 Section 18: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:02:00 Restoring Database backup 00:02:00
Overview Introducing our meticulously designed 'Addiction Therapy Diploma' course. An illuminating pathway, commencing with the fundamental understanding of drugs and their effects, progressing to the intrinsic relationship between addictions and mental health, and culminating with integrative strategies. From this course, you will gain invaluable insights into neurophysiology, the pivotal role of trauma in addiction, and the crucial tripod of support, ensuring a comprehensive grasp of this pivotal discipline. With our compelling modules, one learns not only the science but also the art of aiding those entrapped in the challenging cycle of addiction. Through our focused curriculum, ranging from the minutiae of the brain works to the broader aspects of harm minimisation, you'll be equipped to make meaningful differences in people's lives. Not only will you be enriched with knowledge, but the structured guidance of our course will also instil the confidence to navigate this complex terrain of therapy. As addiction continues to be a significant challenge globally, there's an ever-growing demand for professionals adept in this sphere. This diploma serves as both an enlightening educational experience and a stepping stone towards a fulfilling career, cementing your position in a field that necessitates compassion, understanding, and expertise. Learning Outcomes Understand the varied effects of drugs and their impact on human physiology. Identify the correlation between addictions and underlying mental health issues. Develop strategies for harm minimisation and promotion of optimal health. Acquire knowledge on the neurophysiological workings of the brain in addiction scenarios. Comprehend the trauma model and its significance in treatment methodologies. Implement brief interventions, early strategies, and comprehend the integral tripod of support. Gain an in-depth perspective on the dual diagnosis of addiction and mental health. Why buy this Addiction Therapy Diploma? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Addiction Therapy Diploma 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 £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Addiction Therapy Diploma course for? This course is ideal for Individuals aspiring to delve into the realm of addiction therapy. Health professionals aiming to expand their therapeutic toolkit. Counsellors and therapists focusing on enhancing their proficiency in addiction. Graduates in psychology or related fields exploring specialised avenues. Anyone passionate about understanding addiction and providing holistic care. Prerequisites This Addiction Therapy Diploma does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Addiction Therapy Diploma was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Addiction Therapy Diploma is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Promotional Video Promotional 5 minute video 00:06:00 SAMHI Dual Diagnosis Intro video SAMHI Dual Diagnosis Intro video and downloadable worksheet PowerPoint slides 00:04:00 Module 1 - Drugs and Effects Module 1 - Drugs and Effects: VIDEO PART 1 (content part 1 - 4) 00:16:00 Module 1 - Drugs and Effects: VIDEO PART 2 (content part 5 - 6) 00:20:00 Module 1 - Drugs and Effects: VIDEO PART 3 (content part 7 - 8) 00:20:00 Module 1 - Drugs and Effects: VIDEO PART 4 (content part 9) 00:16:00 Module 1 - Drugs and Effects: VIDEO PART 5 (content part 10) 00:10:00 Module 1 - Drugs and Effects: VIDEO PART 6 (content 10 - 12) 00:18:00 Module 1 - Drugs and Effects: VIDEO PART 7 (content part 13) 00:13:00 Module 1 - Drugs and Effects: VIDEO PART 8 (content part 14) 00:20:00 Module 1 - Drugs and Effects: VIDEO PART 9 (content part 14) 00:20:00 Module 1 - Drugs and Effects: VIDEO PART 10 (content part 15 - 18) 00:19:00 Module 2 - Addictions & Mental Health Module 2 Addictions & Mental Health: VIDEO PART 1 content part 1 - 2 00:16:00 Module 2 Addictions & Mental Health: VIDEO PART 2 content part 3 - 5 00:19:00 Module 2 Addictions & Mental Health: VIDEO PART 3 content part 6 - 7 00:14:00 Module 2 Addictions & Mental Health: VIDEO PART 4 content part 00:17:00 Module 2 Addictions & Mental Health: VIDEO PART 5 content part 00:18:00 Module 2 Addictions & Mental Health: VIDEO PART 6 content part 00:20:00 Module 2 Addictions & Mental Health: VIDEO PART 7 content part 00:14:00 Module 2 Addictions & Mental Health: VIDEO PART 8 content part 00:12:00 Module 2 Addictions & Mental Health: VIDEO PART 9 content part 00:20:00 Module 3 - Harm Minimisation & Optimal Health Module 3 Harm Minimisation & Optimal Health VIDEO PART 1 content part 00:23:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 2 content part 00:17:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 3 content part 00:09:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 4 content part 00:18:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 5 content part 00:17:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 1 content part 6 00:11:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 7 content part 7 00:12:00 Module 4 - Brain Works - Neurophysiology Module 4 Brain Works - Neurophysiology 00:17:00 Module 4 Brain Works - Neurophysiology VIDEO PART 1 content part 00:10:00 Module 4 Brain Works - Neurophysiology VIDEO PART 2 content part 00:17:00 Module 4 Brain Works - Neurophysiology VIDEO PART 3 content part 00:19:00 Module 4 Brain Works - Neurophysiology VIDEO PART 4 content part 00:16:00 Module 4 Brain Works - Neurophysiology VIDEO PART 5 content part 00:11:00 Module 5 - Trauma Model & Keys to Treatment Module 5 Trauma Model & Keys to Treatment VIDEO PART 1 content part 1 - 2a - 2f 00:20:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 2 content part 2g 00:15:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 3 content part 2h - 2i 00:15:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 4 content part 3 00:13:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 5 content part 4 00:12:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 6 content part 5 - 7 00:18:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 7 content part 8 00:17:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 7 content partVIDEO PART 8 00:16:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 9 content part 11 00:16:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 10 content part 12 00:19:00 Module 6 - Brief & Early Intervention and Tripod of Support Module 6 Brief & Early Intervention and Tripod of Support VIDEO 1 content part 1 00:18:00 Module 6 Brief & Early Intervention and Tripod of Support VIDEO 2 content part 2 00:20:00 Resources - Addiction & Mental Health (Dual Diagnosis) Integrative 12hrs Resources - Addiction & Mental Health (Dual Diagnosis) Integrative 12hrs 00:00:00 Assignment Assignment - Addiction Therapy Diploma 00:00:00
Dive into the world of sustainable architecture and environmental design with the 'LEED V4 - Diploma in Building Design and Construction at QLS Level 4.' This comprehensive course, meticulously structured over eleven units, offers a deep exploration of green building principles and practices. Starting with an introductory unit that sets the stage for a transformative learning journey, the course progresses through a series of meticulously crafted modules. Each unit, from the integrative process to regional priority considerations, is designed to enhance understanding and skills in creating environmentally responsible and resource-efficient buildings. The curriculum culminates with a completion unit, ensuring learners emerge with a holistic grasp of the subject matter. The diploma not only educates but inspires, focusing on critical areas such as location and transportation, sustainable site development, water efficiency strategies, energy and atmosphere considerations, and the use of sustainable materials and resources. It also delves into the nuances of indoor environmental quality and innovative approaches to building design and construction. This course is an invaluable resource for those aspiring to make a significant impact in the building and construction industry, equipping them with the knowledge to design and construct buildings that align with the advanced standards of LEED V4. Learning Outcomes Acquire comprehensive knowledge of sustainable building practices and principles. Develop expertise in optimizing water usage and energy efficiency in construction. Gain skills in selecting and utilizing sustainable materials and resources. Understand the significance of indoor environmental quality in building design. Master innovative strategies for building design and construction with a focus on regional priorities. Why choose this LEED V4 - Diploma in Building Design and Construction at QLS Level 4 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are 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. Who is this LEED V4 - Diploma in Building Design and Construction at QLS Level 4 course for? Aspiring architects and designers keen on specializing in sustainable construction. Professionals in the construction industry aiming to enhance their eco-friendly building skills. Environmental consultants seeking to deepen their knowledge of green building practices. Urban planners interested in incorporating sustainable strategies in city designs. Project managers in the construction sector aiming to adopt LEED V4 standards. Career path Sustainable Architect: £30,000 - £50,000 Green Building Consultant: £35,000 - £55,000 Environmental Design Coordinator: £32,000 - £48,000 Urban Sustainability Planner: £28,000 - £45,000 Resource Efficiency Manager: £34,000 - £52,000 Eco-friendly Construction Project Manager: £36,000 - £60,000 Prerequisites This LEED V4 - Diploma in Building Design and Construction at QLS Level 4 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course 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 £95 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 Unit 01: Introduction Introduction 00:01:00 Getting Started 00:04:00 Minimum Program Requirements 00:07:00 Rating System Selection 00:07:00 Unit 02: Integrative Process Integrative Process 00:04:00 Integrative Project Planning and Design 00:02:00 Unit 03: Location & Transportation Overview 00:03:00 Neigbourhoud Development 00:03:00 Sensitive Land 00:02:00 Surrounding Density & Diverse Uses 00:07:00 High Priority Site 00:02:00 Access to Quality Transit 00:06:00 Bicycle Facilities 00:06:00 Reduced Parking Footprint 00:04:00 Green Vehicles 00:04:00 Unit 04: Sustainable Sites Overview 00:02:00 Construction Activity Pollution Prevention 00:03:00 Environmental Site Assessment 00:03:00 Restore or Protect Habitat 00:04:00 Open Space 00:03:00 Rainwater Management 00:03:00 Heat Island Reduction 00:04:00 Light Pollution Reduction 00:05:00 Site Master Plan 00:02:00 Tenant Design and Construction Guidelines 00:02:00 Places of Respite 00:03:00 Direct Exterior Access 00:02:00 Joint Use Facilities 00:03:00 Unit 05: Water Efficiency Overview 00:01:00 Prereq Outdoor Water Use 00:03:00 Prereq Indoor Water Use 00:04:00 Prereq Building Water Metering 00:02:00 Credit Outdoor Water Use 00:02:00 Credit Indoor Water Use 00:03:00 Cooling Tower Water use 00:03:00 Building Water Metering Credit 00:02:00 Unit 06: Energy & Atmosphere Overview 00:02:00 Fundamental Commissioning & Verification 00:04:00 Minimum Energy Performance 00:05:00 Prereq Building Level Energy Metering 00:02:00 Fundamental Refrigerant Management 00:02:00 Enhanced Commissioning 00:05:00 Minimum Energy Performance 00:04:00 Advanced Energy Metering 00:02:00 Demand Response 00:03:00 Renewable Energy Production 00:02:00 Enhanced Refrigerant Management 00:03:00 Green Powerand Carbon Offsets 00:02:00 Unit 07: Materials & Resources Overview 00:02:00 Storage and Collection of Recyclables 00:03:00 Construction and Demolition Waste Management Planning 00:02:00 Preq PBT Source Reduction - Mercury 00:03:00 Building Life Cycle Impact Reduction 00:05:00 BPDO Environmental Product Declaration 00:04:00 BPDO Sourcing of Raw Materials (2020 Update Web) 00:03:00 BPDO Material Ingredients 00:05:00 PBT Source Reduction - Mercury Credit 00:02:00 PBT Source Reduction - Lead Cadmium Copper 00:03:00 Furniture and Medical Furnishings 00:04:00 Design for Flexibilty 00:02:00 Construction and Demolition Waste Management 00:03:00 Unit 08: Indoor Environment Quality Overview 00:01:00 Min Indoor Air Quality Performance 00:06:00 Environmental Tobacco Smoke Control 00:03:00 Minimum Accoustic Performance 00:03:00 Enhanced Indoor Air Quality Strategies 00:02:00 Low Emitting Materials 00:03:00 Construction Indoor Air Quality Management Plan 00:04:00 Indoor Air Quality Assessment 00:03:00 Thermal Comfort 00:04:00 Interior Lighting 00:06:00 Daylight 00:06:00 Quality Views 00:03:00 Accoustic Performance 00:03:00 Unit 09: Innovation Innovation Credit 00:03:00 Innovation LEED AP 00:01:00 Unit 10: Regional Priority Regional Priority Overview 00:01:00 Regional Priority Credit 00:02:00 Unit 11: Completion Completion 00:01:00 Assignment Assignment - LEED V4 - Diploma in Building Design and Construction at QLS Level 4 02:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00
Discover the world of feline behaviour and health in our 'Cat Care' course. Gain valuable insights into common cat behaviour issues, from scratching to OCD, and learn to create a harmonious environment for your furry friend. In the second part, explore cat health problems, from seizures to kidney diseases, and master preventive care for a happy and healthy cat. Equip yourself to be a responsible cat owner and ensure your feline companion thrives. Join us on this enriching journey into the world of cat care. Learning Outcomes of Cat Care Course: Understand various cat behaviour issues and their underlying causes. Develop effective strategies to manage and modify cat behaviour problems. Recognize common cat health problems and their symptoms. Learn preventive measures to promote your cat's long-term health. Gain practical knowledge on ways to boost your cat's immunity and overall well-being. Why buy this Cat Care Course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Cat Care 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. Who is this Cat Care course for? Aspiring cat owners looking to prepare for the responsibilities of cat ownership. Current cat owners seeking to better understand and manage their cat's behavior and health. Animal enthusiasts interested in expanding their knowledge of feline care. Veterinary assistants or pet caregivers aiming to enhance their skills in cat care. Anyone looking to provide the best possible care for their beloved feline companions. People already working in the relevant fields and want to polish their knowledge and skill. Career path Veterinary Technician: £18,000 - £30,000 per year Pet Behaviorist: £20,000 - £45,000 per year Animal Welfare Officer: £18,000 - £30,000 per year Pet Care Specialist: £16,000 - £25,000 per year Veterinary Nurse: £18,000 - £30,000 per year Animal Shelter Manager: £22,000 - £40,000 per year Prerequisites This Cat Care course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Cat Care course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Introduction Course Introduction 00:02:00 Cat Behavior Issue 1: Scratching Behavior Scratching Behavior 00:07:00 Cat Behavior Issue 2: Intercat Aggression Intercat Aggression 00:05:00 Cat Behavior Issue 3: Attention Seeking Behavior Attention Seeking Behavior 00:08:00 Cat Behavior Issue 4: Petting Induced Aggression Petting Induced Aggression 00:05:00 Cat Behavior Issue 5: Redirected Aggression Redirected Aggression 00:07:00 Cat Behavior Issue 6: Separation Anxiety Separation Anxiety 00:08:00 Cat Behavior Issue 7: Obsessive Compulsive Disorder (OCD) Obsessive Compulsive Disorder (OCD) 00:05:00 Cat Behavior Issue 8: Urine Marking Urine Marking 00:09:00 Cat Behavior Issue 9: Excessive Vocalisation Excessive Vocalisation 00:08:00 Cat Behavior Issue 10: Spilling Water Spilling Water 00:04:00 Cat Behavior Issue 11: Destructive Chewing Destructive Chewing 00:05:00 Cat Behavior Issue 12: Fear in Cats Fear in Cats 00:09:00 Cat Behavior Issue 13: Play Aggression Play Aggression 00:07:00 Cat Health Problem 1: Seizures 1.1 Seizures: Ways to Identify 00:02:00 1.2 Seizures: Causes 00:02:00 1.3 Seizures: Ways to Manage 00:02:00 1.4 Seizures: Preventive Measures 00:01:00 Cat Health Problem 2: Obesity 2.1 Obesity: Ways to Identify 00:02:00 2.2 Obesity: Health Consequences 00:01:00 2.3 Obesity: Causes 00:01:00 2.4 Obesity: Ways to Manage 00:02:00 Cat Health Problem 3: Hearing Loss 3.1 Hearing Loss: Ways to Identify 00:02:00 3.2 Hearing Loss: Causes 00:02:00 3.3 Hearing Loss: Ways to Manage 00:03:00 3.4 Hearing Loss: Preventive Measures 00:01:00 Cat Health Problem 4: Feline Cognitive Dysfunction (FCD) / Memory Loss 4.1 FCD / Memory Loss: Ways to Identify 00:05:00 4.2 FCD / Memory Loss: Causes 00:01:00 4.3 FCD / Memory Loss: Ways to Manage 00:04:00 Cat Health Problem 5: Urinary Incontinence 5.1 Urinary Incontinence: Ways to Identify 00:01:00 5.2 Urinary Incontinence: Causes 00:01:00 5.3 Urinary Incontinence: Ways to Manage 00:03:00 Cat Health Problem 6: Arthritis / Joint Pain 6.1 Arthritis / Joint Pain: Ways to Identify 00:03:00 6.2 Arthritis/ Joint Pain: Causes 00:01:00 6.3 Arthritis: Ways to Manage 00:04:00 Cat Health Problem 7: Vision Loss 7.1 Vision Loss: Ways to Identify 00:05:00 7.2 Vision Loss: Causes 00:01:00 7.3 Vision Loss: Ways to Manage 00:03:00 7.4 Vision Loss: Preventive Measures 00:01:00 Cat Health Problem 8: Diabetes 8.1 Diabetes: Ways to Identify 00:03:00 8.2 Diabetes: Ways to Manage 00:02:00 Cat Health Problem 9: Cancer 9.1 Cancer: Ways to Identify 00:03:00 9.2 Cancer: Causes 00:03:00 9.3 Cancer: Preventive Measures 00:02:00 Cat Health Problem 10: Dental Diseases 10.1 Dental Diseases: Ways to Identify 00:03:00 10.2 Dental Diseases: Preventive Measures 00:02:00 Cat Health Problem 11: Fatty Liver Disease 11.1 Fatty Liver Disease: Ways to Identify 00:02:00 11.2 Fatty Liver Disease: Causes 00:02:00 11.3 Fatty Liver Disease: Ways to Manage 00:02:00 11.4 Fatty Liver Disease: Preventive Measures 00:02:00 Cat Health Problem 12: Heart Diseases 12.1 Heart Diseases: Ways to Identify 00:02:00 12.2 Heart Diseases: Causes 00:02:00 12.3 Heart Diseases: Preventive Measures 00:01:00 Cat Health Problem 13: Hyperthyroidism 13.1 Hyperthyroidism: Ways to Identify 00:03:00 13.2 Hyperthyroidism: Causes 00:01:00 13.3 Hyperthyroidism: Ways to Manage 00:01:00 Cat Health Problem 14: Kidney Diseases 14.1 Kidney Diseases: Ways to Identify 00:02:00 14.2 Kidney Diseases: Health Consequences 00:02:00 14.3 Kidney Diseases: Causes 00:01:00 14.4 Kidney Diseases: Ways to Manage 00:02:00 Cat Health Problem 15: Lactose Intolerance 15.1 Lactose Intolerance: Ways to Identify and Causes 00:02:00 15.2 Lactose Intolerance: Ways to Manage 00:03:00 Cat Health Problem 16: Feline Distemper Disease (Vaccination) 16.1 Feline Distemper Disease: Causes 00:02:00 16.3 Feline Distemper Disease: Ways to Manage 00:01:00 16.4 Feline Distemper Disease: Preventive Measures 00:02:00 Cat Health Problem 17: Rabies 17.1 Rabies: Ways to Identify 00:03:00 17.2 Rabies: Management & Prevention 00:04:00 Conclusion: Ways to Boost Immunity of your Cat Ways to Boost Immunity of your Cat 00:03:00 Assignment Assignment - Cat Care 00:00:00
Embarking on a journey into the world of feline fascination? The 'Cat Care and Dog Training Course' is an all-encompassing curriculum that is crafted under the supervision of industry experts and delves deep into the unique behavioural intricacies of cats, as well as touching upon the pivotal issues related to cat health care. Whether it's understanding the complexities of inter-cat aggression or the factors contributing to feline obesity, this course brings a treasure trove of knowledge right to your fingertips. But that's not all! For those dog lovers, finding the right 'dog training near me' has never been easier. This course seamlessly integrates vital components of dog training, ensuring you are well-equipped to foster harmonious relationships with both cats and dogs alike. Learning Outcomes Analyse and address various cat behavioural issues, from scratching behaviours to excessive vocalisation. Implement strategies to combat specific cat health challenges, including diabetes and dental diseases. Employ techniques to mitigate complex cat behavioural challenges such as obsessive compulsive disorder and redirected aggression. Understand and manage health concerns such as feline cognitive dysfunction and urinary incontinence. Implement preventive health measures for cats, including understanding vaccinations like rabies and feline distemper. Discover ways to enhance the immunity of your cat for optimum health and well-being. Gain insights into foundational dog training methodologies for harmonious pet integration. Why buy this Cat Care and Dog Training Course? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Cat Care and Dog Training Course you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Cat Care and Dog Training Course course for? This course is ideal for: Pet lovers aiming to gain deeper insights into cat behaviours and health issues. Individuals seeking a comprehensive understanding of both feline care and dog training. Aspiring pet trainers or carers wanting to broaden their expertise. Cat owners looking for practical solutions to common behavioural and health problems. Dog enthusiasts wanting to integrate foundational dog training knowledge into their skill set. Prerequisites This Cat Care and Dog Training Course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Feline Behavioural Specialist: £30,000 - £45,000 annually Veterinary Nurse Specialising in Cats: £21,000 - £30,000 annually Animal Welfare Officer: £20,000 - £28,000 annually Professional Dog Trainer: £25,000 - £40,000 annually Pet Care Business Owner: £30,000 - £60,000 (depending on the size and location of business) Animal Shelter Manager: £28,000 - £40,000 annually. Course Curriculum Introduction Cat Behavior Issue 1: Scratching Behavior Scratching Behavior 00:07:00 Cat Behavior Issue 2: Intercat Aggression Intercat Aggression 00:05:00 Cat Behavior Issue 3: Attention Seeking Behavior Attention Seeking Behavior 00:08:00 Cat Behavior Issue 4: Petting Induced Aggression Petting Induced Aggression 00:05:00 Cat Behavior Issue 5: Redirected Aggression Redirected Aggression 00:07:00 Cat Behavior Issue 6: Separation Anxiety Separation Anxiety 00:08:00 Cat Behavior Issue 7: Obsessive Compulsive Disorder (OCD) Obsessive Compulsive Disorder (OCD) 00:05:00 Cat Behavior Issue 8: Urine Marking Urine Marking 00:09:00 Cat Behavior Issue 9: Excessive Vocalisation Excessive Vocalisation 00:08:00 Cat Behavior Issue 10: Spilling Water Spilling Water 00:04:00 Cat Behavior Issue 11: Destructive Chewing Destructive Chewing 00:05:00 Cat Behavior Issue 12: Fear in Cats Fear in Cats 00:09:00 Cat Behavior Issue 13: Play Aggression Play Aggression 00:07:00 Cat Health Problem 1: Seizures 1.1 Seizures: Ways to Identify 00:02:00 1.2 Seizures: Causes 00:02:00 1.3 Seizures: Ways to Manage 00:02:00 1.4 Seizures: Preventive Measures 00:01:00 Cat Health Problem 2: Obesity 2.1 Obesity: Ways to Identify 00:02:00 2.2 Obesity: Health Consequences 00:01:00 2.3 Obesity: Causes 00:01:00 2.4 Obesity: Ways to Manage 00:02:00 Cat Health Problem 3: Hearing Loss 3.1 Hearing Loss: Ways to Identify 00:02:00 3.2 Hearing Loss: Causes 00:02:00 3.3 Hearing Loss: Ways to Manage 00:03:00 3.4 Hearing Loss: Preventive Measures 00:01:00 Cat Health Problem 4: Feline Cognitive Dysfunction (FCD) / Memory Loss 4.1 FCD / Memory Loss: Ways to Identify 00:05:00 4.2 FCD / Memory Loss: Causes 00:01:00 4.3 FCD / Memory Loss: Ways to Manage 00:04:00 Cat Health Problem 5: Urinary Incontinence 5.1 Urinary Incontinence: Ways to Identify 00:01:00 5.2 Urinary Incontinence: Causes 00:01:00 5.3 Urinary Incontinence: Ways to Manage 00:03:00 Cat Health Problem 6: Arthritis / Joint Pain 6.1 Arthritis / Joint Pain: Ways to Identify 00:03:00 6.2 Arthritis/ Joint Pain: Causes 00:01:00 6.3 Arthritis: Ways to Manage 00:04:00 Cat Health Problem 7: Vision Loss 7.1 Vision Loss: Ways to Identify 00:05:00 7.2 Vision Loss: Causes 00:01:00 7.3 Vision Loss: Ways to Manage 00:03:00 7.4 Vision Loss: Preventive Measures 00:01:00 Cat Health Problem 8: Diabetes 8.1 Diabetes: Ways to Identify 00:03:00 8.2 Diabetes: Ways to Manage 00:02:00 Cat Health Problem 9: Cancer 9.1 Cancer: Ways to Identify 00:02:00 9.2 Cancer: Causes 00:03:00 9.3 Cancer: Preventive Measures 00:02:00 Cat Health Problem 10: Dental Diseases 10.1 Dental Diseases: Ways to Identify 00:03:00 10.2 Dental Diseases: Preventive Measures 00:02:00 Cat Health Problem 11: Fatty Liver Disease 11.1 Fatty Liver Disease: Ways to Identify 00:02:00 11.2 Fatty Liver Disease: Causes 00:02:00 11.3 Fatty Liver Disease: Ways to Manage 00:01:00 11.4 Fatty Liver Disease: Preventive Measures 00:02:00 Cat Health Problem 12: Heart Diseases 12.1 Heart Diseases: Ways to Identify 00:02:00 12.2 Heart Diseases: Causes 00:02:00 12.3 Heart Diseases: Preventive Measures 00:01:00 Cat Health Problem 13: Hyperthyroidism 13.1 Hyperthyroidism: Ways to Identify 00:03:00 13.2 Hyperthyroidism: Causes 00:01:00 13.3 Hyperthyroidism: Ways to Manage 00:01:00 Cat Health Problem 14: Kidney Diseases 14.1 Kidney Diseases: Ways to Identify 00:02:00 14.2 Kidney Diseases: Health Consequences 00:02:00 14.3 Kidney Diseases: Causes 00:01:00 14.4 Kidney Diseases: Ways to Manage 00:02:00 Cat Health Problem 15: Lactose Intolerance 15.1 Lactose Intolerance: Ways to Identify and Causes 00:02:00 15.2 Lactose Intolerance: Ways to Manage 00:03:00 Cat Health Problem 16: Feline Distemper Disease (Vaccination) 16.1 Feline Distemper Disease: Causes 00:02:00 16.2 Feline Distemper Disease: Health Consequences 00:01:00 16.3 Feline Distemper Disease: Ways to Manage 00:01:00 16.4 Feline Distemper Disease: Preventive Measures 00:02:00 Cat Health Problem 17: Rabies 17.1 Rabies: Ways to Identify 00:03:00 17.2 Rabies: Management & Prevention 00:04:00 Conclusion: Ways to Boost Immunity of your Cat Ways to Boost Immunity of your Cat 00:03:00
Introducing the 'Python Programming Bible | Networking, GUI, Email, XML, CGI' - your comprehensive, all-in-one resource for mastering Python! Are you an aspiring developer looking to dive into the ocean of Python programming or a seasoned coder seeking to level up your Python game? Look no further! Our course is expertly designed to take you from the basics to the complexities of Python, including Networking, GUI, Email, XML, and CGI. If you've ever dreamt of not just learning Python but truly mastering it, this is the course for you. This program is designed to provide a solid foundation and sharpen your skills in one of the most in-demand programming languages, while also introducing you to its many applications. This course starts with the basics of Python, providing a gentle yet thorough introduction and setup that caters to beginners as well as those looking to refresh their Python knowledge. As we study deeper into the heart of Python, we dive into objects, classes, and the power of regular expressions. But it doesn't stop there! You'll also become comfortable with concepts like CGI programming, which is an important building block for creating dynamic web pages. Navigating from core programming, we transition into the intricacies of managing databases and executing multithreading in Python. You'll gain the confidence to handle complex data management tasks, understand how Python interacts with databases, and efficiently manages multiple tasks simultaneously. The XML section allows you to get hands-on with parsing, data extraction, and manipulation, while the GUI section unveils the art of creating beautiful, user-friendly interfaces using Python. The course is enriched with a diverse set of resources, including real-world projects, quizzes, and interactive coding exercises. This is more than just a course, it's your passport to a new realm of opportunities, unlocking a world where Python programming is your strength, not just a skill. So whether you're a student aiming to get a head start on your peers, a professional looking to diversify your skills, or an enthusiast wanting to dive deeper into the Python universe, the Python Programming Bible is the starting point for your journey to becoming a Python expert. Enrol today and step into a future of endless opportunities with Python! Learning Outcomes: Upon completion of the Python Programming Bible course, you should be able to: Understand and implement Python basics and advanced concepts. Build object-oriented programs with Python. Utilise regular expressions for pattern-matching tasks. Develop dynamic web pages using CGI programming. Interact with databases efficiently using Python. Apply multithreading for better utilisation of resources. Process and manipulate data using XML in Python. Design and create user-friendly GUIs with Python. Who is this course for? This Python Programming Bible course is ideal for the following: Beginners aiming to learn Python from scratch. Professionals looking to broaden their programming skills. Students pursuing a degree in Computer Science. Web developers looking to integrate Python into their toolkit. Data enthusiasts aiming to handle data with Python. Career Path: This Python Programming Bible course will help you to develop your knowledge and skills to pursue different careers, such as: Python Developer: (£35,000 - £70,000). Data Analyst: (£27,000 - £55,000). Web Developer: (£24,000 - £60,000). Data Scientist: (£45,000 - £90,000). Machine Learning Engineer: (£50,000 - £90,000). Software Developer: (£30,000 - £70,000). Certification After studying the course materials of the Python Programming Bible | Networking, GUI, Email, XML, CGI 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. Prerequisites This Python Programming Bible | Networking, GUI, Email, XML, CGI does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Python Programming Bible | Networking, GUI, Email, XML, CGI 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. Course Curriculum Section 01: Introduction & Setup Introduction 00:02:00 Setup on Mac OS X 00:03:00 Setup On Linux/Ubuntu 00:03:00 Setup On Windows 00:03:00 Run Code Online 00:03:00 Section 02: Basics Comments 00:02:00 Variables & Variable Types 00:05:00 Lists 00:04:00 Tuples 00:03:00 Dictionary 00:06:00 Data Type Conversion 00:02:00 Arithmetic Operators 00:05:00 Comparison Operators 00:03:00 Assignment Operators 00:03:00 Bitwise Operators 00:10:00 Logical Operators 00:07:00 Membership Operators 00:02:00 Identity Operators 00:02:00 Operator Precedence 00:03:00 Decision Making 00:09:00 Loops 00:06:00 Loop Control Statements 00:05:00 Numbers 00:05:00 Strings 00:12:00 Lists In Depth 00:05:00 Tuples In Depth 00:06:00 Dictionary In Depth 00:08:00 Date & Time 00:07:00 Functions 00:11:00 Modules 00:05:00 File Inputs & Outputs 00:13:00 Handling Exceptions 00:07:00 Section 03: Classes/Objects Simple Example 00:04:00 Creating Instance Objects 00:01:00 Accessing Attributes 00:04:00 Constructor New & Init Method 00:06:00 Destroying Objects 00:02:00 Class Inheritance 00:04:00 Overriding Methods 00:03:00 Overloading Methods 00:01:00 Overloading Operators 00:04:00 Data Hiding 00:03:00 Section 04: Regular Expressions Match Function 00:05:00 Search Function 00:02:00 Advanced Expressions 00:05:00 Search & Replace 00:03:00 Section 05: CGI Programming Basic CGI Programming 00:08:00 Get Method 00:06:00 Post Method 00:05:00 Cookies 00:05:00 Section 06: Database Setup Database 00:02:00 Connect To Database 00:05:00 Create Table 00:03:00 INSERT Operation 00:04:00 READ Operation 00:06:00 UPDATE Operation 00:02:00 DELETE Operation 00:02:00 Simple Network Example 00:04:00 Simple Client 00:04:00 Section 07: Multithreading Initiate a New Thread 00:07:00 Create Thread 00:06:00 Synchronise Threads 00:03:00 Multithreaded Priority Queue 00:09:00 Section 08: XML Parse an XML File 00:10:00 Section 09: GUI Introduction 00:02:00 Button Preview 00:03:00 Canvas 00:04:00 Checkbutton 00:02:00 Entry 00:02:00 Frame 00:04:00 Label 00:02:00 List Box 00:02:00 Menu button 00:03:00 Menu 00:08:00 Message 00:02:00 Radio button 00:05:00 Scale 00:03:00 Scrollbar 00:04:00 Text 00:03:00 Top-level 00:02:00 Spinbox 00:02:00 Paned Window 00:03:00 Message Box 00:02:00 Label Frame 00:02:00 Section 10: Resource Resource 00:00:00 Assignment Assignment - Python Programming Bible | Networking, GUI, Email, XML, CGI 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 CompTIA Cloud+ (CV0-002) 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 professional training that employers are looking for in today's workplaces. The CompTIA Cloud+ (CV0-002) Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This CompTIA Cloud+ (CV0-002) 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 CompTIA Cloud+ (CV0-002) Course, like every one of Study Hub'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 StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this CompTIA Cloud+ (CV0-002)? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the CompTIA Cloud+ (CV0-002) 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 £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This CompTIA Cloud+ (CV0-002) 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 skill. Prerequisites This CompTIA Cloud+ (CV0-002) does not require you to have any prior qualifications or experience. You can just enrol and start learning.This CompTIA Cloud+ (CV0-002) was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This CompTIA Cloud+ (CV0-002) is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: What You Need to Know Introduction to the Cloud 00:04:00 Cloud+ Exam Info 00:08:00 What Can Cloud+ Do For You? 00:03:00 Preparing for the Cloud+ Exam 00:06:00 Section 02: Introducing the Cloud Setting up Your Cloud Accounts 00:06:00 Defining the Cloud 00:08:00 Deployment Models 00:05:00 Public Cloud (Demo) 00:08:00 Private Cloud (Demo) 00:06:00 Community Cloud (Demo) 00:06:00 Hybrid Cloud (Demo) 00:05:00 Additional Models 00:05:00 Cloud Architectures 00:06:00 Capacity, Elasticity, and Support Agreements 00:08:00 Resource Balancing 00:07:00 Change Management 00:07:00 Section 03: System Requirements for Cloud Deployments Deployment Exam Objectives Explained 00:06:00 Cloud Component Interactions, Part 1 00:07:00 Cloud Component Interaction, Part 2 00:08:00 Non-Cloud Component Interactions 00:09:00 Platforms and Applications 00:05:00 Baselines (Lab) 00:07:00 Target Hosts 00:05:00 Existing Systems (Lab) 00:09:00 Architecting for Elements and Targets (Demo) 00:07:00 Selecting Deployment Tools (Demo) 00:07:00 Executing a Deployment Plan (Demo) 00:09:00 Evaluating Testing Plans 00:05:00 Testing Techniques 00:05:00 Analyzing Testing Results 00:04:00 Baseline Confirmation (Lab) 00:08:00 Deployment Problem Resolution (Lab) 00:08:00 Section 04: Cloud Storage Cloud Storage Types 00:06:00 Provisioning Storage 00:06:00 Storage Protection Capabilities 00:09:00 Storage Features 00:06:00 Access Protocols 00:06:00 Storage Management (Demo) 00:06:00 Storage Security (Lab) 00:05:00 Disaster Recovery Capabilities (Demo) 00:07:00 Disaster Recovery Considerations 00:05:00 Business Continuity Plan (Lab) 00:07:00 Section 05: Cloud Compute Compute Introduction 00:06:00 CPU Capabilities 00:08:00 Memory Requirements 00:07:00 Performance Considerations 00:07:00 Cost Considerations (Lab) 00:07:00 Energy Savings 00:05:00 Dedicated vs. Shared Compute 00:04:00 High Availability and Disaster Recovery for Compute 00:05:00 Monitoring (Lab) 00:08:00 Forecasting 00:05:00 Policies 00:03:00 Section 06: Cloud Networking Network Components (Demo) 00:09:00 Network Protocols 00:04:00 Network Ports (Lab) 00:05:00 Virtual Private Networks (VPNs) 00:10:00 IDS/IPS 00:07:00 Segmentation 00:09:00 Network SLAs and Change Management 00:04:00 Networking in Different Models 00:05:00 Section 07: Cloud Security Security Policies 00:06:00 Standards and Compliance (Demo) 00:05:00 Identity, Authentication, and Authorization 00:08:00 Multi-Factor Authentication (Lab) 00:05:00 Authorization (Lab) 00:08:00 Encryption (Demo) 00:08:00 Compute Security (Demo) 00:07:00 Account Management (Lab) 00:07:00 Segmentation (Lab) 00:05:00 Security Tools (Demo) 00:07:00 Security Services 00:05:00 Security Automation and Orchestration 00:06:00 Models and Security 00:06:00 Section 08: Migrating to the Cloud Migration Types 00:07:00 Workload Management 00:05:00 Virtualizing Physical Systems 00:06:00 Migrating Security 00:07:00 Protocols and Services 00:08:00 Environmental Constraints 00:07:00 Section 09: Maintaining Cloud Solutions Planning Patch Management 00:07:00 Manual Patch Management 00:04:00 Automated Patch Management (Lab) 00:03:00 Update Types 00:08:00 Automated Workflows (Lab) 00:07:00 Backup Types (Lab) 00:10:00 Backup Targets and Options 00:07:00 Maintenance Automation Techniques 00:05:00 Maintenance Automation Tasks 00:07:00 Provisioning and Deprovisioning 00:07:00 Application Life Cycle 00:03:00 Monitoring and Reporting (Lab) 00:07:00 Monitoring Metrics 00:06:00 Section 10: Troubleshooting Cloud Solutions Troubleshooting Methodology 00:08:00 Troubleshooting Deployment 00:07:00 Troubleshooting Capacity 00:08:00 Troubleshooting Automation and Orchestration 00:07:00 Troubleshooting Connectivity 00:10:00 Troubleshooting Security 00:09:00 Assignment Assignment - CompTIA Cloud+ (CV0-002) 00:00:00
This comprehensive course, 'SQL for Data Science, Data Analytics, and Data Visualization,' covers essential SQL concepts and tools for working with data. Participants will learn to manipulate, analyze, and visualize data using SQL Server, Azure Data Studio, and other relevant tools. The course also delves into advanced SQL commands, stored procedures, and data import/export, making it ideal for aspiring data professionals. Learning Outcomes: Set up and configure SQL Server and SQL Azure Data Studio for data analysis. Master SQL statements for data manipulation, data structure, and user management. Utilize SQL queries, joins, and aggregate functions for efficient data analysis. Understand SQL constraints, views, and advanced commands for in-depth data exploration. Create and implement SQL stored procedures to automate tasks. Leverage Azure Data Studio for data visualization and perform data analysis with SQL. Why buy this SQL for Data Science, Data Analytics and Data Visualization? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the SQL for Data Science, Data Analytics and Data Visualization 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 £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This SQL for Data Science, Data Analytics and Data Visualization 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 skill. Prerequisites This SQL for Data Science, Data Analytics and Data Visualization does not require you to have any prior qualifications or experience. You can just enrol and start learning.This SQL for Data Science, Data Analytics and Data Visualization was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This SQL for Data Science, Data Analytics and Data Visualization is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Getting Started Introduction 00:03:00 How to get course requirements 00:03:00 Getting started on Windows, Linux or Docker 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 Section 02: SQL Server setting up Section Introduction 00:02:00 Microsoft SQL Server Installation 00:19:00 SQL Server Management Studio (SSMS) Installation 00:08:00 How to connect MS SQL (Windows Authentication) 00:04:00 How to connect MS SQL (SQL Server Authentication) 00:03:00 Download and Restore Sample Database 00:07:00 Section 03: SQL Azure Data Studio What is Azure Data Studio 00:06:00 Azure Data Studio Installation steps 00:07:00 Azure Data Studio to Connect SQL Server 00:09:00 Create a Database 00:07:00 Create a Table 00:09:00 Insert Data rows 00:07:00 View the Data returned by Query 00:03:00 Section 04: SQL Database basic SSMS Section Introduction 00:01:00 Overview of Databases8 00:11:00 Creating Database 00:05:00 SQL Data Types 00:03:00 Column Data Types on SSMS 00:04:00 Creating Table 00:09:00 Overview of Primary Key and Foreign Key 00:04:00 Primary Key 00:04:00 Foreign Key 00:07:00 Creating Temporary tables 00:06:00 Section 05: SQL Statements for DATA Section Introduction 00:01:00 Insert statement 00:08:00 Update statement 00:05:00 Delete statement 00:03:00 Section 06: SQL Data Structure statements Section Introduction 00:01:00 CREATE table statement 00:03:00 DROP statement 00:02:00 ALTER statement 00:05:00 TRUNCATE statement 00:04:00 COMMENT in query 00:01:00 RENAME 00:02:00 Section 07: SQL User Management Create Database user 00:04:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 08: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:07:00 SELECT DISTINCT 00:03:00 SELECT with column headings 00:03:00 Column AS statement 00:02:00 Section 09: Filtering Data rows SELECT WHERE Clause - theory 00:04:00 SELECT WHERE Clause - practical 00:07:00 Section 10: Aggregate functions Sum() 00:08:00 Min()-Max() 00:06:00 Section 11: SQL Query statements Order By statement 00:05:00 SELECT TOP clause in SQL 00:04:00 BETWEEN command 00:08:00 IN operator 00:04:00 Wildcard Characters and LIKE 00:05:00 Section 12: SQL Group by statement Section Introduction 00:01:00 Group by - theory8 00:03:00 Group by - practical 00:05:00 HAVING statement 00:04:00 Section 13: JOINS for Multiple table Data Analysis Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:08:00 Left outer join 00:03:00 Right outer join 00:02:00 Full outer join 00:01:00 Union 00:03:00 Cartesian Product with the Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 14: SQL Constraints Section introduction 00:01:00 Check constraint 00:07:00 NOT NULL constraint 00:08:00 UNIQUE constraint 00:05:00 Section 15: Views Creating Views 00:04:00 Reporting with multiple tables 00:03:00 Section 16: Advanced SQL commands Section Introduction 00:01:00 Timestamp 00:04:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:04:00 String functions 00:05:00 Sub Query 00:03:00 SELECT with calculations 00:06:00 Section 17: SQL Stored procedures Create stored procedure 00:05:00 Stored procedure with parameter 00:04:00 Section 18: Azure Data Studio Visualization Installing SandDance Extension 00:03:00 Visualization Charts 00:05:00 Multiple Table Data Charts 00:06:00 Section 19: Azure Studio SQL for Data Analysis Type Decision for Data Analysis 00:13:00 Data Analysis with Case Statement and String Text 00:09:00 Section 20: Import & Export data Section Introduction 00:01:00 Import Flat File 00:05:00 Import .csv or excel file 00:03:00 Export Data to Excel or any format 00:06:00 Section 21: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:04:00 Restoring Database backup 00:04:00
Overview Learn about The 100 Most Common Verbs in French from industry experts and boost your professional skill. This The 100 Most Common Verbs in French course will enhance your skill and make you ready for the job market. You'll get expert opinions about the best practices and problems of The 100 Most Common Verbs in French. You'll also gain the skills of The 100 Most Common Verbs in French to excel in your job and tips to master professional skills in no time. You'll be connected with the community of The 100 Most Common Verbs in French professionals and gain first-hand experience of The 100 Most Common Verbs in French problem-solving. The The 100 Most Common Verbs in French is self-paced. You can complete your course and attend the examination in your suitable schedule. After completing the The 100 Most Common Verbs in French, you'll be provided with a CPD accredited certificate which will boost your CV and help you get your dream job. This The 100 Most Common Verbs in French will provide you with the latest information and updates of The 100 Most Common Verbs in French. It will keep you one step ahead of others and increase your chances of growth. Why buy this The 100 Most Common Verbs in French? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the The 100 Most Common Verbs in French 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 £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This The 100 Most Common Verbs in French does not require you to have any prior qualifications or experience. You can just enrol and start learning. Prerequisites This The 100 Most Common Verbs in French was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This The 100 Most Common Verbs in French is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum The 100 Most Common Verbs in French Etre - to be 00:02:00 Avoir - to have 00:02:00 Devoir - to must 00:02:00 Falloir - to have to 00:02:00 Vouloir - to want 00:02:00 Savoir - to know 00:01:00 Penser - to think 00:02:00 Faire - to do 00:02:00 Venir - to come 00:02:00 Prendre - to take 00:02:00 Parler - to speak 00:02:00 Commencer - to start 00:02:00 Essayer - to try 00:02:00 Aller - to go 00:02:00 Entendre - to wait 00:02:00 Sortir - to go out 00:02:00 Attendre - to wait 00:02:00 Permettre - to allow 00:02:00 Compter - to count 00:02:00 Donner -to give 00:02:00 Comprendre - to understand 00:02:00 Connaitre - to know 00:02:00 Empecher - to stop 00:02:00 Reprendre - to take back 00:02:00 Appeler - to call 00:02:00 Mener - to lead 00:02:00 Permettre - to allow 00:02:00 Appartenir - to belong to 00:02:00 Occuper - to occupy 00:03:00 Toucher - to touch 00:02:00 Risquer - to risk 00:02:00 Aimer - to like 00:02:00 Devenir - to become 00:02:00 Concerner - to concern 00:01:00 Retrouver - to find back 00:02:00 Apprendre - to learn 00:02:00 Partir - to leave 00:02:00 Perdre - to loose 00:02:00 Rencontrer - to meet 00:02:00 Tenir - to keep 00:02:00 Decider - to decide 00:02:00 Creer - to create 00:02:00 Expliquer - to explain 00:02:00 Arriver - to arrive 00:02:00 Obtenir - to obtain 00:02:00 Ouvrir - to open 00:02:00 Considerer - to consider 00:03:00 Chercher - to look for 00:02:00 Assurer - to ensure 00:02:00 Servir - to serve 00:02:00 Entrer - to enter 00:02:00 Porter - to carry 00:02:00 Sembler - to seem 00:02:00 Gagner - to win 00:02:00 Presenter - to present 00:02:00 Proposer - to propose 00:02:00 Revenir - to come back 00:02:00 Exister - to exist 00:02:00 Changer - to change 00:02:00 Accepter - to accept 00:02:00 Produire - to produce 00:02:00 Montrer - to show 00:02:00 Apporter - to bring 00:02:00 Laisser - to let 00:02:00 Voir - to see 00:02:00 Agir - to act 00:02:00 Preparer - to prepare 00:02:00 Refuser - to refuse 00:02:00 Continuer - to continue 00:02:00 Recevoir - to receive 00:02:00 Utiliser - to use 00:02:00 Demander - to ask 00:02:00 Poser - to put 00:02:00 Relever - to raise 00:02:00 Repondre - to answer 00:02:00 Lire - to read 00:02:00 Atteindre - to reach 00:02:00 Trouver - to find 00:02:00 Ecrire - to write 00:02:00 Jouer - to play 00:02:00 Travailler - to work 00:02:00 Passer - to pass 00:02:00 Rappeler - to call back 00:03:00 Tenter - to tempt 00:02:00 Suivre - to follow 00:02:00 Defendre - to defend 00:02:00 Representer - to represent 00:02:00 Reconnaitre - to recognize 00:02:00 Ajouter - to add 00:02:00 Rendre - to give back 00:02:00 Vivre - to live 00:02:00 Tirer - to pull 00:03:00 Choisir - to choose 00:02:00 Reussir - to succeed 00:02:00 Importer - to import 00:02:00 Rester - to stay 00:02:00 Croire - to beleive 00:02:00 Manger - to eat 00:02:00 Boire - to drink 00:02:00 Dormir - to sleep 00:02:00 Assignment Assignment - The 100 Most Common Verbs in French 00:00:00