1719 Courses in Liverpool delivered Online

Advanced Meeting Skills for Project Managers and Professionals who need to Achieve Business Outcomes

Overview This comprehensive course on Internet of Things will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Internet of Things 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 Internet of Things. It is available to all students, of all academic backgrounds. Requirements Our Internet of Things is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 15 sections • 65 lectures • 08:53:00 total length •Module 01: Introduction: 00:02:00 •Module 02: Course Agenda: 00:03:00 •Module 01: Introduction to Internet of Things: 00:13:00 •Module 02: Choosing Cloud Services for IoT: 00:05:00 •Module 03: What is Raspberry Pi Part 1?: 00:09:00 •Module 04: What is Raspberry Pi Part 2?: 00:06:00 •Module 01: Downloading OS for Raspberry Pi Noobs-Raspbian: 00:07:00 •Module 02: Install OS using NOOBS: 00:11:00 •Module 03: Remote Control of Raspberry Pi Using VNC Viewer: 00:10:00 •Module 04: Install OS using Raspbian Image part 1: 00:06:00 •Module 05: Install OS using Raspbian Image part 2: 00:02:00 •Module 01: Getting Around Raspbian Operating System part 1: 00:10:00 •Module 02: Getting around Raspbian Operating System part 2: 00:08:00 •Module 03: Getting around Raspbian Operating System part 3: 00:06:00 •Module 04: How To Run Python program On Raspberry Pi: 00:09:00 •Module 01: Raspberry PI GPIO Concepts: 00:07:00 •Module 02: Raspberry Pi GPIO Interfacing Single LED: 00:17:00 •Module 03: Raspberry Pi GPIO Interfacing Multiple LED's: 00:09:00 •Module 04: Rapberry Pi GPIO Interfacing Buzzer: 00:03:00 •Module 01: Raspberry Pi and Transistorized Switching: 00:09:00 •Module 02: Raspberry Pi and Relay part 1: 00:13:00 •Module 03: Raspberry Pi and Relay part 2: 00:08:00 •Module 01: Accepting Digital Input on Raspberry Pi Part 1: 00:13:00 •Module 02: Accepting Digital Inputs on Raspberry Pi Part 2: 00:07:00 •Module 01: Sensor Interfacing With Raspberry Pi LDR1: 00:05:00 •Module 02: Sensor Interfacing With Raspberry Pi LDR 2: 00:10:00 •Module 03: Sensor Interfacing With Raspberry Pi LDR 3: 00:07:00 •Module 04: Sensor Interfacing with Rapberry Pi DHTT11 part 1: 00:10:00 •Module 05: Sensor Interfacing with Rapberry Pi DHTT11 part 2: 00:10:00 •Module 06: Sensor Interfacing with Raspberry pi Using SenseHAT: 00:11:00 •Module 07: Ultrasonic Sensor Interfacing with Raspberry Pi: 00:14:00 •Module 01: BMP180 with Raspberry Pi: 00:07:00 •Module 02: Enabling I2C on Raspberry Pi: 00:05:00 •Module 03: BMP180 Python Code: 00:06:00 •Module 01: Getting Started With IoT: 00:11:00 •Module 02: Getting Started with Microsoft Azure IoT Hub Part 1: 00:04:00 •Module 03: Getting Started with Microsoft Azure IoT Hub Part 2: 00:05:00 •Module 04: Getting Started with Microsoft Azure IoT Hub Part 3: 00:09:00 •Module 05: Create Device inside Azure IoT Hub: 00:06:00 •Module 06: Enable Azure Cloud Shell and enable IoT Extension: 00:08:00 •Module 07: Send Data to Azure IoT Hub Using Python Program: 00:09:00 •Module 08: Send Actual Temperature and Humidity Values to Azure IoT hub: 00:03:00 •Module 09: Storing the Data on Microsoft Azure Using Custom Gateway: 00:13:00 •Module 10: Save data to blob storage using Stream Analytics Job: 00:12:00 •Module 11: Data Visualization with Power BI Part 1: 00:07:00 •Module 12: Data Visualization with Power BI Part 2: 00:12:00 •Module 13: Creating Custom web app with azure for data visualization Part 1: 00:10:00 •Module 14: Creating Custom web app with azure for data visualization Part 2: 00:14:00 •Module 15: Creating Custom web app with azure for data visualization Part 3: 00:12:00 •Module 16: Dealing with password error while pushing your webapp to azure: 00:01:00 •Module 17: Cleaning up Azure Resources: 00:02:00 •Module 18: Remote Monitoring using Azure Logic App Part 1: 00:12:00 •Module 19: Remote Monitoring using Azure Logic App Part 2: 00:10:00 •Module 01: Introduction to Thingspeak: 00:06:00 •Module 02: Create an account and send data to Thingspeak: 00:08:00 •Module 01: Getting started with SaaS IoT Platform io.adafruit.com: 00:08:00 •Module 02: What is MQTT?: 00:10:00 •Module 03: Sending Data to Adafruit Io Using MQTT Part 1: 00:17:00 •Module 04: Sending Data to Adafruit io Using MQTT part 2: 00:14:00 •Module 05: Home automation project with adafruit IO Part 1: 00:15:00 •Module 06: Home Automation Project with Adafruit IO Part 2: 00:02:00 •Module 01: IoT Security: 00:14:00 •Module 02: Conclusion: 00:01:00 •Resources - Internet of Things: 00:00:00 •Assignment - Internet of Things: 00:00:00

Description: Whether you're a dog lover or a dog owner, becoming a dog trainer can be an incredibly rewarding job for you. In this dog training course, you will explore different types and styles of dog training, including simple yet effective techniques you can master to understand dog language and know what your dogs are really saying. Learn how to work with reactive dogs and deal with separation anxiety, aggression and biting, chewing, barking or other issues in the quickest possible time. Gain all the required knowledge and confidence to become a professional dog trainer and discover a comprehensive career guide to ensure you're following the path that best matches your expectations. Moreover, this course is led by an experienced instructor, who will provide you with essential tips and practical training on how to get started in setting up your own dog training business. Learning Outcome Learn simple techniques for integrating aggressive dogs with other dogs. Understand dominant and submissive signals that prevent dog attacks from happening Get a grip on the 3 different types of dog aggression Understand the answers to 10 frequently asked puppy training questions Discover simple and effective techniques to market your dog training business Master how to communicate with dogs in a language they understand Who is the course for? Pet care professionals who specialize in dog training Dog owners and lovers who want to learn how to train their dogs 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. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Career Path: The Advanced Diploma in Dog Training is perfect for dog owners and lovers who want to live peacefully with their obedient and well-behaved dogs. The course can also help in pet care careers such as: Dog Trainer Pet Care Specialist Pet Groomer Pet Store Owner Veterinarian. Module 1: Introduction Why Getting 2, 8 Week Old Parson Terrier Puppies Changed My Life And My Career! 00:03:00 Here's What You'll Get From This Course 00:04:00 Module 2: Feeding Time - Aggression and Stealing Food How To Communicate You're In Charge During Feeding Time 00:10:00 How To Stop Food Aggression And Stealing Food 00:08:00 This Dog Is A Professional At Stealing Food, You'll Be Amazed At What He Does! 00:04:00 Module 3: The Right Way to Greet a Dog How You Greet Your Dog Says So Much More Than Hello - Here's Why 00:12:00 It's Not As Difficult As You May Think To Do And Makes The World Of Difference 00:05:00 Help! What When Visitors Come Round And Get Jumped On? Here's What To Do 00:05:00 Here's The Right Way For Guests To Enter Your Home And Stop Jumping Up 00:02:00 Module 4: Separation Anxiety How To Stop Dogs Barking, Chewing, Panting And Pacing When Left Alone 00:13:00 The Time To Get This Right Is When They Are A Puppy - Here's How To Do It 00:02:00 Can You Resolve Separation In Dogs Of All Ages? Yes! Here's How 00:02:00 Module 5: Dog Language - What They're Really Saying! Is Your Dog Trying To Calm You Down?! Find Out Here 00:09:00 This ONE Technique Works Like Magic With Numerous Unwanted Behaviours 00:10:00 The 3 F's For Dogs And Top Tips 00:11:00 Module 6: The Answers To 10 Popular Dog Questions You Are Likely To Be Asked Here's The Answers To Frequently Asked Dog Training Questions Numbers 1 and 2 00:09:00 Here's The Answers To Commonly Asked Dog Training Questions Numbers 3 and 4 00:09:00 Here's The Answers To Frequently Asked Dog Training Questions Numbers 5 and 6 00:06:00 Here's The Answers To Top Dog Training Questions 7 and 8 00:09:00 Here's The Answers To Commonly Asked Dog Training Questions 9 and 10 00:08:00 Module 7: The Answers To 10 Common Puppy Training Questions That You'll Likely To Be Asked Here's The Answers To Commonly Asked Puppy Training Questions Numbers 1 and 2 00:10:00 Here's The Answers To Popular Puppy Training Questions 3 and 4 00:05:00 Here's The Answers To Common Puppy Training Questions Numbers 5 and 6 00:07:00 Here's The Answers To Popular Puppy Training Questions Numbers 7 and 8 00:06:00 Here' The Answers To Common Puppy Training Questions Numbers 9 and 10 00:09:00 Module 8: Dog Training Consultations With Clients Someone Has Said Yes To A Dog Training Consultation With You - Here's What To Do 00:09:00 Top Tips Of What To Include During Your Dog Training Consultation 00:14:00 **Bonus Video** A Demonstration Of A Real-Life Dog Training Consultation **Bonus Video** A Demonstration Of A Real-Life Dog Training Consultation 00:22:00 Agreement Letters To Be Signed After The Consultation 00:06:00 How To Leave A Consultation On A High 00:02:00 Resources Read This First As It Will Really Help You With The Following Videos 00:05:00 Read This First As It Will Really Help You With The Following Videos 00:05:00 Dog Training Consultation Form 00:05:00 Dog Training Confirmation Letter Template - Page 1 00:05:00 Dog Training Confirmation Letter Template - Page 2 00:05:00 Top Tips Of What To Include During A Dog Training Consultation Handout 00:05:00 Agreement Letter Template - The One You Sign And Leave With Your Client 00:05:00 Agreement Letter Template - The One Your Client Signs And You Keep 00:05:00 The Best 'Feel Good' Dog Poem Ever! 00:05:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Become an expert in DIY and transform your gloomy, neglected basement into a sleek and stylish living space with the Basement Improvement & Renovation Course. This instructor-led course is a complete introduction to basement remodelling and includes expert audio-visual material to develop your practical skills for everyday DIY projects. You will learn the basics of electrical and plumbing installation, how to make the most of natural lighting, repair walls, control mould and much more. This course also provides step-by-step guidance on waterproofing your basement and installing adequate heating and air conditioning. You will also be trained on the fundamentals of basement repair and maintenance to ensure a healthy and safe living space. On completion, you will be equipped with the knowledge and skills to plan your transformation project and utilise your space to create a beautiful sanctuary that everyone can enjoy. Your Learning Goals: Save money and do it yourself - the faster and more affordable way! Develop the practical skills to transform your basement into a stylish and useful living space Get handy tips and tricks from the experts in home DIY Understand the basics of plumbing and electrical installation Learn how to control moisture levels, temperature and lighting quality Familiarise with tools of the trade required for everyday DIY projects Discover everything you need to know about subfloors, partition walls and basement ceilings Be able to repair beams and walls, seal cracks, and ensure adequate insulation Who is this Course for? Basement Improvement & Renovation is 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 background. 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. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Week#1: Intro & Assessment Week#1: Intro & Assessment 00:05:00 Week#1 - Lesson#1 : The Benefits & Challenges of Finishing a Basement 00:15:00 Week#1 - Lesson#2: Assessing Your Basement Space 00:00:00 Week#1 - Lesson#3: Do-It-Yourself, Contractor or Both? 00:00:00 Week#2: Basement Finishing Options Week#2: Lesson#1 : Anatomy of a Basement 00:30:00 Week#2 - Lesson#2: Basement Finishing Best Practices 02:00:00 Week#3: Moisture-proofing, Electricity, Plumbing & Tearing Out An Old Basement Week#3 - Lesson#1: Moisture-Proofing Strategies 00:20:00 Week#3 - Lesson#2: Power, Lighting & Plumbing Best Practices 00:40:00 Week#3 - Lesson#3: Tearing Out an Old Basement Best Practices 00:20:00 Week#4: Basement Planning and Layout Week#4: Lesson#1 : Understanding Layout Options 00:15:00 Week#4 - Lesson#2: Experience your layout in full size 00:15:00 Week#5: Special Basement Features Week#5 - Lesson#1: Basement Bathrooms, Saunas & Steam Rooms 00:30:00 Week#5 - Lesson#2: Building a Second Suite 00:05:00 Week#5 - Lesson#3: How to Create a Basement Kitchen 00:10:00 Week#5 - Lesson#4: Basement Cold Rooms & Cellars 00:30:00 Week#5 - Lesson#5: Bring Outdoor Light Into Your Basement 00:10:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Duration 3 Days 18 CPD hours This course is intended for Developers Administrators Overview Understand why Blockchain is needed and where Explore the major components of Blockchain Learn about Hyperledger Fabric v1.1 and the structure of the Hyperledger Architecture Lean the features of the Fabric model including chaincode, SDKs, Ledger, Security and Membership Services Perform comprehensive labs on writing chaincode Explore the architecture of Hyperledger Fabric v1.1 Understand and perform in depth labs on Bootstrapping the Network Gain a detailed understanding of the benefits, components and architecture of Hyperledger Composer Learn Hyperledger Explorer and Hyperledger Composer Playground Perform comprehensive labs to integrate/develop an application with Hyperledger Fabric running a smart contract Build applications on Hyperledger Fabric v1.1 This instructor-led Hyperledger training course is designed for developers and administrators who want to take a comprehensive deep dive on Hyperledger Fabric and Hyperledger Composer. This Hyperledger training course has several comprehensive labs, giving you real world experience.In 3 days, you will learn the need for blockchain applications, where blockchain is used, and about Hyperledger Fabric, the open source framework for developing blockchain applications and solutions with a modular architecture. Introduction to Blockchain Introduction to Blockchain What is Blockchain Types of network Public network Permissioned network Private network Need for Blockchain Components of Blockchain Consensus Provenance Immutability Finality Where can Blockchain be used Example on Blockchain How Blockchain Works How Blockchain Works Structure of Blockchain Block Hash Blockchain Distributed Lifecycle of Blockchain Smart Contract Consensus Algorithm Proof of Work Proof of Stake Practical Byzantine Fault Tolerance Actors of Blockchain Blockchain developer Blockchain operator Blockchain regulator Blockchain user Membership service provider Building A Small Blockchain Application Introduction to Hyperledger Fabric v1.1 Introduction to Hyperledger What is Hyperledger Why Hyperledger Where can Hyperledger be used Hyperledger Architecture Membership Blockchain Transaction Chaincode Hyperledger Fabric Features of Hyperledger Fabric Installation of prerequisite Getting Started With Fabric Model The Fabric Model Features of Fabric Model Chaincode SDKs Ledger Privacy through channels Security and Membership services Assets Consensus Components of Fabric Model Peer Orderer Certificate Authority Building your network Chaincode Chaincode Chaincode API How to write a Chaincode Lab Work Architecture of Hyperledger Fabric v1.1 Architecture of Hyperledger Fabric Transaction Ledger Nodes Peer Endorser Ordering Nodes Channels Certificate Authority Transaction Flow Lab Work Bootstrapping Bootstrapping the Network Introduction Lab Work Task 1 - Generate the crypto material for the various participants. Task 2 - Generate the genesis block for the Orderer node and start ordering service (solo node). Task 3 - Generated the configuration transaction block to create a new channel. Task 4 - Sign the configuration block and create the new channel. Task 5 - Make peers of all the organizations join the channel that we created in Task 4 Introdcution to Hyperledger Explorer Introduction To Hyperledger Explorer Block Details Peer List Chaincode List Transaction Details Installation of Hyperledger Explorer Starting the Explorer App Introduction to Hyperledger Composer Introduction Components of Hyperledger Composer Benefits of Hyperledger Composer Key Concepts Hyperledger Composer Solution Installation Hyperledger Composer Playground Hyperledger Composer Playground Introduction Playground Overview Lab Work Additional course details: Nexus Humans Hyperledger Training - Developing on Hyperledger Fabric 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 Hyperledger Training - Developing on Hyperledger Fabric 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.

Duration 5 Days 30 CPD hours This course is intended for Network engineers and technicians that are working in the enterprise sector. Overview - Describe the factors that led to the development of IPv6 and possible uses of this new IP structure - Describe the structure of the IPv6 address format, how IPv6 interacts with data link layer technologies, and how IPv6 is supported in Cisco IOS Software - Implement IPv6 services and applications - Understand the updates to IPv4 routing protocols needed to support IPv6 topologies - Understand multicast concepts and IPv6 multicast specifics - Evaluate the scenario and desired outcome and identify the best transition mechanism for the situation - Describe security issues, how security for IPv6 is different than for IPv4, and emerging practices for IPv6-enabled networks - Describe the standards bodies that define IPv6 address allocation, in addition to one of the leading IPv6 deployment issuesâ€'multihoming - Describe the deployment strategies that service providers might consider when deploying IPv6 - Describe case studies for enterprise, service provider, and branch networks This course is a five-day course aimed at providing network engineers and technicians that are working in the enterprise sector with the knowledge and skills that are needed to study and configure Cisco IOS Software IPv6 features. Introduction to IPv6 Explaining the Rationale for IPv6 Evaluating IPv6 Features and Benefits Understanding Market Drivers IPv6 Operations Understanding the IPv6 Addressing Architecture Describing the IPv6 Header Format Enabling IPv6 on Hosts Enabling IPv6 on Cisco Routers Using ICMPv6 and Neighbor Discovery IPv6 Services IPv6 Mobility Describing DNS in an IPv6 Environment Understanding DHCPv6 Operations Understanding QoS Support in an IPv6 Environment Using Cisco IOS Software Features IPv6-Enabled Routing Protocols Routing with RIPng Examining OSPFv3 Examining Integrated IS-IS Examining EIGRP for IPv6 Understanding MP-BGP Configuring IPv6 Policy-Based Routing Configuring FHRP for IPv6 Configuring Route Redistribution IPv6 Multicast Services Implementing Multicast in an IPv6 Network Using IPv6 MLD IPv6 Transition Mechanisms Implementing Dual-Stack Describing IPv6 Tunneling Mechanisms IPv6 Security Configuring IPv6 ACLs Using IPsec, IKE, and VPNs Discussing Security Issues in an IPv6 Transition Environment Understanding IPv6 Security Practices Configuring Cisco IOS Firewall for IPv6 Deploying IPv6 Examining IPv6 Address Allocation Understanding the IPv6 Multihoming Issue Identifying IPv6 Enterprise Deployment Strategies IPv6 and Service Providers Identifying IPv6 Service Provider Deployment Understanding Support for IPv6 in MPLS Understanding 6VPE Understanding IPv6 Broadband Access Services IPv6 Case Studies Planning and Implementing IPv6 in Enterprise Networks Planning and Implementing IPv6 in Service Provider Networks Planning and Implementing IPv6 in Branch Networks Lab Exercises Lab 2-1: Enabling IPv6 on Hosts Lab 2-2: Using Neighbor Discovery Lab 3-1: Using Prefix Delegation Lab 4-1: Routing with OSPFv3 Lab 4-2: Routing with IS-IS Lab 4-3: Routing with EIGRP Lab 4-4: Routing with BGP and MP-BGP Lab 5-1: Multicasting Lab 6-1: Implementing Tunnels for IPv6 Lab 7-1: Configuring Advanced ACLs Lab 7-2: Implementing IPsec and IKE Lab 7-3: Configuring Cisco IOS Firewall Lab 9-1: Configuring 6PE and 6VPE Configuration Files Summary Lab Activity Solutions Teardown and Restoration Additional course details: Nexus Humans Cisco IPv6 Fundamentals, Design and Deployment 3.0 (IP6FD) 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 Cisco IPv6 Fundamentals, Design and Deployment 3.0 (IP6FD) 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.

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview Identify independent and dependent variables and measurement levels in their own analytical work scenarios. Identify variables of interest in relational database tables. Choose a data aggregation level and data set design appropriate for the intended analysis and tool. Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. Create stored procedures, views, and functions to modularize data retrieval code. This three-day instructor-led course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. Specifically, this course presents TSQL within the context of data analysis in other words, making meaning from the data rather than transaction-oriented data-tier application development. The course starts with a brief discussion of levels of measurement and quantitative research methodogy, and integrates these concepts into each TSQL topic presented. The goal is to provide a consistent, direct, and purposeful learning path from RDBMS data retrieval through analytical tools such as SQL Server Reporting Services, PowerBI, Excel, R, SAS, and SPSS. Module 1: Introduction to TSQL for Business Intelligence Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Module 2: Turning Table Columns into Variables for Analysis: SELECT List Expressions, WHERE, and ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Module 3: Combining Columns from Multiple Tables into a Single Dataset: The JOIN Operators Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSSJOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNERJOIN Understanding Joins, Part 3: The OUTERJOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTERJOINs Combining JOIN Operations with WHERE and ORDER BY Module 4: Creating an Appropriate Aggregation Level Using GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Module 5: Subqueries, Derived Tables and Common Table Expressions Non-correlated and correlated subqueries Derived tables Common table expressions Module 6: Encapsulating Data Retrieval Logic Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Module 7: Getting Your Dataset to the Client Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Additional course details: Nexus Humans Writing Analytical Queries for Business Intelligence 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 Writing Analytical Queries for Business Intelligence 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.

Duration 3 Days 18 CPD hours This course is intended for Team leaders, managers, executives, and other business and IT professionals who lead others as well as Individual contributors ready for transformational self-development as a leader. Overview Recognize vulnerability as the emotion we feel during times of uncertainty, risk, and emotional exposure. Explain why courage requires vulnerability. Establish a link between what I learned and behaviors I want to change. Recognize the critical role that self-awareness plays in daring leadership. Give examples to support how armor - not fear -is the greatest obstacle to daring leadership. Identify the four skill sets that make up courage: rumbling with vulnerability, living into our values, BRAVING trust, and learning to rise. Recognize that courage is a collection of four skill sets that are measurable, observable, and teachable. Recognize that vulnerability is the birthplace of many of the behaviors that define daring leadership, including creativity, accountability, and difficult conversations. Give examples of why daring leadership requires showing up for hard conversations and rumbles, including giving and receiving feedback. This workshop is all about your own leadership self-awareness, identifying your call to courage as a leader and the learning, practice and integration of the four courage skills sets so you can show up authentically in life and leadership. Dare to Lead? is the ultimate playbook for developing brave leaders and courageous cultures. The greatest barrier to daring leadership is not fear; the greatest obstacle is armor ? how we self-protect when we feel uncertainty, risk and emotional exposure. Learn the skills to move from armored leadership to daring leadership. Daring leaders are self-aware, know how to have hard conversations, hold themselves and others accountable, build trust, lead with empathy and connection, take smart risks that lead to innovation, reset quickly after disappointments and setbacks, and give and receive feedback. This interactive curriculum is delivered in five, half-day sessions and is based on the research by Bren‚ Brown. This course comes with a PDF workbook and an Amazon gift card to purchase the Dare to Lead? book in the version of your choice. You also have access to a series of leadership and personal development assessments and exclusive training videos led by Dr. Bren‚ Brown. At the end of the event, a digital badge is awarded to those who complete 24 hours of course content. The Heart of Daring Leadership Permission Slips Container Building Armored Leadership versus Daring Leadership Call to Courage Assembling Our Armor Building Grounded Confidence to Replace our Armor Aplying the 5Cs Self-Awareness & Emotional Literacy Developing Emotional Literacy Getting Curious About Emotions Exploring the Iceberg The Myths of Vulnerability Rumbling with Vulnerability The Six Myths of Vulnerability Exploring Your Arena Shame Resilience Shame 101 Defining Shame The Physiology of Shame Shame Shields How Shame Shows Up in Organizations How Shame Shows up at Work Empathy and Self-Compassion Attributes of Empathy What Does Empathy Look Like? Empathy Misses Comparative Suffering Self-Compassion Talk to Yourself the Way You Talk to Someone You Love Empathy & Self-Compassion Commitment Supplemental Exercise: Kristin Neff?s Self-Compassion Scale Supplemental Exercise: Putting Empathy, Curiosity, and Rumble Tools in Action Living Into Our Values Living Into Our Values Values Clarification Taking Values from Professing Words to Practicing Behaviors Grounded Confidence and Rumbling Skills Grounded Confidence and Rumbling Skills Rumble Starters The 5Cs of Strategic Thinking, Decision Making, and Delegation Using the 5Cs Supplemental Exercise ? Gritty Faith & Gritty Facts Supplemental Exercise ? Horizon Conflict Engaged Feedback Giving Engaged Feedback Recognizing Defensiveness in Feedback Conversations BRAVING Trust BRAVING Trust Square Squad Rumbling with Self-Trust Trust with Others Trust on Teams Rumbling with Living BIG Learning to Rise: The Reckoning Learning to Rise: The Rising Strong Process The Rising Strong Process Getting Emotionally Hooked Offloading Hurt: Barriers to Reckoning with Emotion Strategies for Reckoning with Emotion The Rumble and The Revolution Writing My SFD The Delta The Revolution: When the Process Becomes a Daily Practice Supplemental Exercise ? Reset and Resilience Practices Integration Dare to Lead Integration Plan

Duration 1 Days 6 CPD hours This course is intended for This course is intended for the following participants: Individuals planning to deploy applications and create application environments on Google Cloud Platform Developers, systems operations professionals, and solution architects getting started with Google Cloud Platform Executives and business decision makers evaluating the potential of Google Cloud Platform to address their business needs. Overview This course teaches participants the following skills: Identify Google Cloud counterparts for Azure IaaS, Azure PaaS, Azure SQL, Azure Blob Storage, Azure Application Insights, and Azure Data Lake Configure accounts, billing, projects, networks, subnets, firewalls, VMs, disks, auto scaling, load balancing,storage, databases, IAM, and more Manage and monitor applications Explain feature and pricing model differences This 1-day instructor led course introduces Azure professionals to the core capabilities of Google Cloud in the four technology pillars: networking, compute, storage, and database. It is designed for Azure system administrators, Solution Architects and SysOps Administrators familiar with Azure features and setup; and want to gain experience configuring Google Cloud products immediately. With presentations, demos, and hands-on labs, participants get details of similarities, differences, and initial how-tos quickly. Introducing Google Cloud Explain the advantages of Google Cloud. Define the components of Google's network infrastructure, including: Points of presence, data centers, regions, and zones. Understand the difference between Infrastructure-as-a-Service (IaaS) and Platform-as-a-Service (PaaS). Getting Started with Google Cloud Identify the purpose of projects on Google Cloud. Understand how Azure's resource hierarchy differs from Google Cloud's Understand the purpose of and use cases for Identity and Access Management. Understand how Azure AD differs from Google Cloud IAM. List the methods of interacting with Google Cloud. Launch a solution using Cloud Marketplace. Virtual Machines in the Cloud Identify the purpose and use cases for Google Compute Engine Understand the basics of networking in Google Cloud. Understand how Azure VPC differs from Google VPC. Understand the similarities and differences between Azure VM and Google Compute Engine. Understand how typical approaches to load-balancing in Google Cloud differ from those in Azure. Deploy applications using Google Compute Engine Storage in the Cloud Understand the purpose of and use cases for: Cloud Storage, Cloud SQL, Cloud Bigtable and Cloud Datastore. Understand how Azure Blob compares to Cloud Storage. Compare Google Cloud?s managed database services with Azure SQL. Learn how to choose among the various storage options on Google Cloud. Load data from Cloud Storage into BigQuery Containers in the Cloud Define the concept of a container and identify uses for containers. Identify the purpose of and use cases for Google Container Engine and Kubernetes. Understand how Azure Kubernetes Service differs from from Google Kubernetes Engine. Provision a Kubernetes cluster using Kubernetes Engine. Deploy and manage Docker containers using kubectl Applications in the Cloud Understand the purpose of and use cases for Google App Engine. Contrast the App Engine Standard environment with the App Engine Flexible environment. Understand how App Engine differs from Azure App Service. Understand the purpose of and use cases for Google Cloud Endpoints. Developing, Deploying and Monitoring in the Cloud Understand options for software developers to host their source code. Understand the purpose of template-based creation and management of resources. Understand how Google Cloud Deployment Manager differs from Azure Resource Manager. Understand the purpose of integrated monitoring, alerting, and debugging Understand how Google Monitoring differs from Azure Application Insights and Azure Log Analytics. Create a Deployment Manager deployment. Update a Deployment Manager deployment. View the load on a VM instance using Google Monitoring. Big Data and Machine Learning in the Cloud Understand the purpose of and use cases for the products and services in the Google Cloud big data and machine learning platforms. Understand how Google Cloud BigQuery differs from Azure Data Lake. Understand how Google Cloud Pub/Sub differs from Azure Event Hubs and Service Bus. Understand how Google Cloud?s machine-learning APIs differ from Azure's. Load data into BigQuery from Cloud Storage. Perform queries using BigQuery to gain insight into data Summary and Review Review the products that make up Google Cloud and remember how to choose among them Understand next steps for training and certification Understand, at a high level, the process of migrating from Azure to Google Cloud.

🚀 Unlock the Secrets of Flawless Software with Our Software Testing Course! Are you ready to embark on a journey that will revolutionize the way you approach software development? Look no further! Our cutting-edge Software Testing course is designed to equip you with the essential skills and knowledge needed to become a master in the art of testing software applications. 🎯   🔍 Why Software Testing Matters In today's fast-paced digital world, software plays a crucial role in every aspect of our lives. From mobile apps to web applications, the demand for seamless, bug-free software is higher than ever before. However, achieving perfection in software development is no easy feat. This is where software testing comes into play. Software testing is the process of evaluating a software application to uncover bugs, errors, or any other potential issues before it is released to the market. By meticulously testing software, developers can ensure that it meets the highest standards of quality, functionality, and reliability. 💡 Our Software Testing course dives deep into the various testing techniques, methodologies, and best practices that are essential for ensuring the success of any software project. Whether you're a seasoned developer looking to enhance your skill set or a newcomer to the world of software development, this course is your gateway to success. 🌟   🛠️ What You'll Learn Throughout this comprehensive course, you'll gain hands-on experience with a wide range of software testing concepts and tools. From manual testing to automated testing, you'll explore the different approaches used to identify and eliminate bugs in software applications. Additionally, you'll learn about test planning, execution, and reporting techniques that are crucial for effective software testing. By the end of the course, you'll be equipped with the knowledge and skills needed to: Understand the fundamentals of software testing Identify different types of software defects Create and execute test cases Utilize various testing tools and frameworks Implement effective testing strategies Analyze test results and generate reports With our expert-led training and hands-on exercises, you'll be well-prepared to tackle any software testing challenge that comes your way. 🚀   👩‍💼 Who is this for? Our Software Testing course is perfect for: Software developers looking to enhance their testing skills Quality assurance professionals seeking to deepen their understanding of software testing IT professionals interested in transitioning into the field of software testing Students and beginners eager to kickstart their career in software development No matter your background or experience level, this course provides a solid foundation for mastering the art of software testing and advancing your career in the tech industry. 🌐   🚀 Career Path Upon completing our Software Testing course, you'll be well-positioned to pursue a variety of exciting career opportunities in the software development and quality assurance fields. Some potential career paths include: Software Tester Quality Assurance Engineer Test Automation Engineer Software Developer (with specialized testing skills) Test Manager Quality Assurance Manager   With the ever-increasing demand for skilled software testers in today's job market, completing this course will open up a world of possibilities for career advancement and professional growth. 🌟 Don't miss out on this incredible opportunity to take your software testing skills to the next level! Enroll in our Software Testing course today and unlock the secrets to building flawless software that delights users and exceeds expectations. 💻🔍   FAQ (Frequently Asked Questions) about Genealogy Q1: What is genealogy? Genealogy is the study of family history and descent. It involves tracing ancestry and lineage through historical records, oral traditions, genetic analysis, and other sources to create a comprehensive family tree. Genealogy allows individuals to understand their familial connections, cultural heritage, and ancestral roots. Q2: Why is genealogy important? Genealogy is important for several reasons. Firstly, it helps individuals develop a deeper understanding of their identity and belonging by uncovering their familial history. It allows people to connect with their ancestors, understand their struggles, achievements, and cultural traditions. Genealogy also helps in preserving family stories and traditions for future generations. Additionally, it can provide valuable insights into medical history and genetic predispositions, aiding in personalized healthcare decisions. Q3: How can I start researching my family history? Starting your genealogical research can be exciting yet daunting. Begin by gathering information from living relatives, such as names, dates, and places of birth, marriage, and death. Organize this information systematically and then proceed to explore online databases, historical records, and archives. Utilize genealogical software or websites to build and maintain your family tree. Joining genealogical societies or online forums can also provide guidance, resources, and support from experienced researchers. Q4: What challenges might I encounter in genealogical research? Genealogical research often comes with various challenges. Common obstacles include incomplete or inaccurate records, surname changes, language barriers, and geographical relocations. Additionally, the availability of historical records may vary depending on factors such as time period, location, and societal norms. Genetic genealogy can also present challenges such as privacy concerns and the interpretation of DNA test results. Overcoming these challenges requires patience, perseverance, critical thinking, and creativity in research strategies. Q5: How can I verify the accuracy of my genealogical findings? Verifying the accuracy of genealogical findings is essential to ensure the reliability of your family tree. Cross-referencing multiple sources, including primary documents, official records, oral histories, and genetic evidence, can help confirm information. It's important to critically evaluate the credibility and reliability of each source, considering factors such as the author's expertise, biases, and the context in which the information was recorded. Collaborating with other researchers and seeking professional assistance when needed can also contribute to the accuracy of your genealogical research. Course Curriculum Chapter 1 Why Explore Your Past Why Explore Your Past 00:00 Chapter 2 The Search For Answers The Search For Answers 00:00 Chapter 3 Modern Methods of Researching Your Past Modern Methods of Researching Your Past 00:00 Chapter 4 Where to Start Searching Where to Start Searching 00:00 Chapter 5 Search of Records Search of Records 00:00 Chapter 6 Conclusion Conclusion 00:00