166 Courses

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course is database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing. Overview Create sophisticated SSIS packages for extracting, transforming, and loading data Use containers to efficiently control repetitive tasks and transactions Configure packages to dynamically adapt to environment changes Use Data Quality Services to cleanse data Successfully troubleshoot packages Create and Manage the SSIS Catalog Deploy, configure, and schedule packages Secure the SSIS Catalog SQL Server Integration Services is the Community Courseware version of 20767CC Implementing a SQL Data Warehouse. This five-day instructor-led course is intended for IT professionals who need to learn how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages, and to use SSIS to extract, transform, and load data to and from SQL Server. This course is similar to the retired Course 20767-C: Implementing a SQL Data Warehouse but focuses more on building packages, rather than the entire data warehouse design and implementation. Prerequisites Working knowledge of T-SQL and SQL Server Agent jobs is helpful, but not required. Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of relational databases. Some experience with database design. 1 - SSIS Overview Import/Export Wizard Exporting Data with the Wizard Common Import Concerns Quality Checking Imported/Exported Data 2 - Working with Solutions and Projects Working with SQL Server Data Tools Understanding Solutions and Projects Working with the Visual Studio Interface 3 - Basic Control Flow Working with Tasks Understanding Precedence Constraints Annotating Packages Grouping Tasks Package and Task Properties Connection Managers Favorite Tasks 4 - Common Tasks Analysis Services Processing Data Profiling Task Execute Package Task Execute Process Task Expression Task File System Task FTP Task Hadoop Task Script Task Introduction Send Mail Task Web Service Task XML Task 5 - Data Flow Sources and Destinations The Data Flow Task The Data Flow SSIS Toolbox Working with Data Sources SSIS Data Sources Working with Data Destinations SSIS Data Destinations 6 - Data Flow Transformations Transformations Configuring Transformations 7 - Making Packages Dynamic Features for Making Packages Dynamic Package Parameters Project Parameters Variables SQL Parameters Expressions in Tasks Expressions in Connection Managers After Deployment How It All Fits Together 8 - Containers Sequence Containers For Loop Containers Foreach Loop Containers 9 - Troubleshooting and Package Reliability Understanding MaximumErrorCount Breakpoints Redirecting Error Rows Logging Event Handlers Using Checkpoints Transactions 10 - Deploying to the SSIS Catalog The SSIS Catalog Deploying Projects Working with Environments Executing Packages in SSMS Executing Packages from the Command Line Deployment Model Differences 11 - Installing and Administering SSIS Installing SSIS Upgrading SSIS Managing the SSIS Catalog Viewing Built-in SSIS Reports Managing SSIS Logging and Operation Histories Automating Package Execution 12 - Securing the SSIS Catalog Principals Securables Grantable Permissions Granting Permissions Configuring Proxy Accounts Additional course details: Nexus Humans 55321 SQL Server Integration Services training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 55321 SQL Server Integration Services course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Discover more about the benefits of a private yoga session and how yoga can help you release some of the blockers and pain points that are preventing you from creating & living your dream life. Listen to what your body needs from you to feel energised, calm, restful, motivated, build confidence. Choose the style of Yoga that your body, mind + soul needs from you. Vinyasa, Yin, Restorative or perhaps practicing mindfulness.

Learn the essentials of yoga and detox dieting. Level up your knowledge to improve your lifestyle with this masterclass Yoga and Detox Diet: Healthy Body course. Good health is the key to all success. In this sophisticated era, you need to keep yourself fit to stand out from the competition. For a healthy lifestyle, you should follow a smart guideline that is why we recommend our insightful Yoga and Diet: Healthy Body course for you.  This comprehensive course includes everything you need to know for achieving a healthy and mindful you. It includes a rigorous, step by step learning method to acquire precious knowledge on the yoga and detox diet.  This Yoga and Detox Diet: Healthy Body course will certainly meet your essential needs to practice yoga and prepare a detox diet for a great healthy life. Learn the fundamentals as well as intermediate through advanced yoga, meditation and cleansing dietary practices through video, audio and ebooks. This CPD accredited course offers a certificate of completion as proof of your expertise in this field, and you can show off your certificate in your Linkedin profile and your resume to impress employers and improve your soft skills to get yourself healthy. This course will be a stepping stone to your career success, equipping you with the necessary skills of yoga and detox diet

Are you focusing enough on your own personal health? Are you curious how your personal health actually affects your life and the way you live? If so, then this diploma course will help you and your needs. Description: Every day our attitudes and opinions about our personal well-being are being influenced by the information, messages and advertising received from media and the Internet. Personal health and fitness has a significant influence on individuals and also on the society as well. This course will help you to have comprehensive lessons on personal health care. The course covers important aspects of health and fitness such as healthy eating, colon cleansing, fasting, diet and nutrition. This course will be of great interest to any person who is interested to be well informed and educated on the appropriate ways to improve their own personal health and fitness.This will also help individuals to appropriately deal with the polarised opinions and information about health and fitness received from media and the internet.  Who is the course for? Anyone regardless if they have prior knowledge or not in personal health. Anyone who thinks they possess a maturity to reflect their own development on their health. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Diploma in Personal Health Care will be very beneficial and helpful, especially to health and mental-related careers like: Clinical Psychologists Counsellors Medical Professionals Mental Health Experts Psychologists Psychotherapists Therapists And Much More! Diploma in Personal Health Care How I Became a Hygienist 01:00:00 The Nature and Cause of Disease99 01:30:00 Fasting 01:00:00 Colon Cleansing 01:00:00 Diet and Nutrition 01:30:00 Vitamins and Other Food Supplements 01:30:00 The Analysis of Disease States: Helping the Body to Recover 02:00:00 Reference Book Primary Health Care 00:00:00 Mock Exam Mock Exam- Diploma in Personal Health Care 00:20:00 Final Exam Final Exam- Diploma in Personal Health Care 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Duration 5 Days 30 CPD hours Overview Mining data Manipulating data Visualizing and reporting data Applying basic statistical methods Analyzing complex datasets while adhering to governance and quality standards throughout the entire data life cycle CompTIA Data+ is an early-career data analytics certification for professionals tasked with developing and promoting data-driven business decision-making. CompTIA Data+ gives you the confidence to bring data analysis to life. As the importance for data analytics grows, more job roles are required to set context and better communicate vital business intelligence. Collecting, analyzing, and reporting on data can drive priorities and lead business decision-making. 1 - Identifying Basic Concepts of Data Schemas Identify Relational and Non-Relational Databases Understand the Way We Use Tables, Primary Keys, and Normalization 2 - Understanding Different Data Systems Describe Types of Data Processing and Storage Systems Explain How Data Changes 3 - Understanding Types and Characteristics of Data Understand Types of Data Break Down the Field Data Types 4 - Comparing and Contrasting Different Data Structures, Formats, and Markup Languages Differentiate between Structured Data and Unstructured Data Recognize Different File Formats Understand the Different Code Languages Used for Data 5 - Explaining Data Integration and Collection Methods Understand the Processes of Extracting, Transforming, and Loading Data Explain API/Web Scraping and Other Collection Methods Collect and Use Public and Publicly-Available Data Use and Collect Survey Data 6 - Identifying Common Reasons for Cleansing and Profiling Data Learn to Profile Data Address Redundant, Duplicated, and Unnecessary Data Work with Missing Value Address Invalid Data Convert Data to Meet Specifications 7 - Executing Different Data Manipulation Techniques Manipulate Field Data and Create Variables Transpose and Append Data Query Data 8 - Explaining Common Techniques for Data Manipulation and Optimization Use Functions to Manipulate Data Use Common Techniques for Query Optimization 9 - Applying Descriptive Statistical Methods Use Measures of Central Tendency Use Measures of Dispersion Use Frequency and Percentages 10 - Describing Key Analysis Techniques Get Started with Analysis Recognize Types of Analysis 11 - Understanding the Use of Different Statistical Methods Understand the Importance of Statistical Tests Break Down the Hypothesis Test Understand Tests and Methods to Determine Relationships Between Variables 12 - Using the Appropriate Type of Visualization Use Basic Visuals Build Advanced Visuals Build Maps with Geographical Data Use Visuals to Tell a Story 13 - Expressing Business Requirements in a Report Format Consider Audience Needs When Developing a Report Describe Data Source Considerations For Reporting Describe Considerations for Delivering Reports and Dashboards Develop Reports or Dashboards Understand Ways to Sort and Filter Data 14 - Designing Components for Reports and Dashboards Design Elements for Reports and Dashboards Utilize Standard Elements Creating a Narrative and Other Written Elements Understand Deployment Considerations 15 - Understand Deployment Considerations Understand How Updates and Timing Affect Reporting Differentiate Between Types of Reports 16 - Summarizing the Importance of Data Governance Define Data Governance Understand Access Requirements and Policies Understand Security Requirements Understand Entity Relationship Requirements 17 - Applying Quality Control to Data Describe Characteristics, Rules, and Metrics of Data Quality Identify Reasons to Quality Check Data and Methods of Data Validation 18 - Explaining Master Data Management Concepts Explain the Basics of Master Data Management Describe Master Data Management Processes Additional course details: Nexus Humans CompTIA Data Plus (DA0-001) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the CompTIA Data Plus (DA0-001) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

The perfect course for car care enthusiasts who have a passion for keeping their cherished vehicles in peak cosmetic condition safely and effectively, using tips and tricks to preserve and protect finishes, and who want to further their knowledge of detailing. Enthusiast Classic Car detailer training. The perfect course for classic car care enthusiasts who have a passion for keeping their vintage cherished vehicle in peak cosmetic condition, and who want to further their knowledge of detailing with a slant towards the classic end of the market. The course will guide the attendee through best practice processes of safe washing, decontamination, inspection, paint protection and preservation, mild paint correction, leather, plastics and vinyl care, and discuss/apply the various protection options on offer including paint type suitability. Course Details: • Assessment of vehicle exterior & interior inspection. • Cleaning, decontamination & preparatory work of the vehicle body: Washing processes, Pre-wash & snow foam, multi bucket methods, acids and alkalis, fallout removers and in-depth cleaning practices. Use of low water, less invasive wash methods and drying techniques • Cleaning, decontamination & preparatory work of alloy, steel and wire wheels. • Paintwork inspection using lighting techniques, depth gauges, and visual cues. Identifying paint types and areas of concern, and how to address them. • Engine bay cleaning and steaming, what chemicals can be used where, brightwork and mare metal care, what can you safely clean? • Practical overview of machine polisher ranges and their usage. • Practical overview of various polishing compounds and pad combinations. • Paintwork and Wheel protection options and application technique. • Glass cleansing and protection practical overview. • Detailing tips and tricks to give you the best results. You will have hands-on experience starting from the very beginning and working your way through all steps of a full enhancement detail, it will then be up to you to build on the knowledge you have gained by practising on your own vehicle, with ongoing support. The course is run from our fully equipped studio in the heart of Gloucestershire, with easy access to the M4/M5, and under an hour and a half to the M25. Course Length 1 Day (0930-1600) Group Size One-to-One Location UK Detailing Academy, 2 Purlieus Barn, Ewen, Cirencester, GL7 6BY Experience / Qualification Open to all Refreshments or Lunch Refreshments included

Get job ready with CompTIA's Data Analysis Certification. Live Classes - Career Guidance - Exam Included.

Reiki 1 Initiation course - A soulful 2 days with deep personal experience - that's what Reiki Initiation is really about. In our Reiki Lineage we lead the training to awaken the part of us that might be deep asleep or just waking up, as Reiki is the Universal Life Energy, you can NOT learn it, you can only be guided to rediscover it within you...

Are you interested in a career in health and development but confused about the newest trends in health and fitness? Are you curious to know how your personal health affects your life and the way you live? If so, then this diploma course will help you and your needs. In recent years it's hard not to see on an everyday basis the latest article, radio or TV spot on the newest trend in well-being and wellness. Confused? I'm not astonished. The fact of the matter is the basics have never changed. This course unlike any other is based on over 20 years of real world personal training methods which have helped a great many individuals get thinner, tone up, get fit and figure out how to live a happy and healthier life. Enroll now to begin. The course covers all aspects of health and fitness such as healthy eating, colon cleansing, fasting, diet, and nutrition. This course would be beneficial to any person who is interested in their health and wants to be informed and educated on ways to improve their own personal health and fitness. Course Highlights Certified Diploma in Personal Health Care 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 Certified Diploma in Personal Health Care into 8 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 10 hours, 55 minutes 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 Certified Diploma in Personal Health Care 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? Certified Diploma in Personal Health Care 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 Certified Diploma in Personal Health Care 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. How I Became a Hygienist FREE 00:45:00 The Nature and Cause of Disease FREE 01:30:00 Fasting 01:00:00 Colon Cleansing 01:00:00 Diet and Nutrition 01:30:00 Vitamins and Other Food Supplements 01:30:00 The Analysis of Disease States: Helping the Body to Recover 03:00:00 Reference Book Primary Health Care 00:00:00 Mock Exam Mock Exam- Certified Diploma in Personal Health Care 00:20:00 Final Exam Final Exam- Certified Diploma in Personal Health Care 00:20:00

Welcome to the wonderful world of crystals with this foundational course on working with crystals, with sensei Alison, Advanced Reiki Master, Teacher and Crystal Reiki Master.