1894 Running courses

Duration 3 Days 18 CPD hours This course is intended for Professionals who want unparalleled creative freedom, productivity, and precision for producing superb 3D modeling. Overview Navigate the AutoCAD user interfacesUse the fundamental features of AutoCADUse the precision drafting tools in AutoCAD to develop accurate technical drawingsPresent drawings in a detailed and visually impressive way In this course, you will learn to navigate the AutoCAD user interfaces and use the fundamental features of AutoCAD. You will learn to use the precision drafting tools in AutoCAD to develop accurate technical drawings. Getting Started with AutoCAD Starting the Software User Interface Working with Commands Cartesian Workspace Opening an Existing Drawing File Viewing Your Drawing Saving Your Work Basic Drawing & Editing Commands Drawing Lines Erasing Objects Drawing Lines with Polar Tracking Drawing Rectangles Drawing Circles Undo and Redo Actions Projects - Creating a Simple Drawing Create a Simple Drawing Create Simple Shapes Drawing Precision in AutoCAD Using Running Object Snaps Using Object Snap Overrides Polar Tracking at Angles Object Snap Tracking Drawing with Snap and Grid (Optional) Making Changes in Your Drawing Selecting Objects for Editing Moving Objects Copying Objects Rotating Objects Scaling Objects Mirroring Objects Editing with Grips Projects - Making Your Drawing More Precise Schematic Project: Electronics Diagram Architectural Project: Landscape Mechanical Project (with Polar & Tracking) Mechanical Project: Surge Protector Mechanical Project: Satellite Organizing Your Drawing with Layers Creating New Drawings With Templates What are Layers? Layer States Changing an Object's Layer Advanced Object Types Drawing Arcs Drawing Polylines Editing Polylines Drawing Polygons Drawing Ellipses Analzying Model and Object Properties Working with Object Properties Measuring Objects Projects - Drawing Organization & Information Architectural Project Mechanical Project Civil Project Advanced Editing Commands Trimming and Extending Objects Stretching Objects Creating Fillets and Chamfers Creating Arrays of Objects Inserting Blocks What are Blocks? Working with Dynamic Blocks Inserting Blocks Inserting Blocks using the Tool Palettes Inserting Blocks using the DesignCenter Inserting Blocks using the Content Explorer Projects - Creating More Complex Objects Mechanical Project 1 - Plate Mechanical Project 2 - Gasket Mechanical Project 3 - Plate Mechanical Project 4 - Rocker Arm Architectural Project 1 - Floor Plan Architectural Project 2 - Floor Plan Civil Project - Parking Lot Setting Up a Layout Printing Concepts Working in Layouts Creating Layouts Creating Layout Viewports Guidelines for Layouts Printing Your Drawing Printing Layouts Print and Plot Settings Projects - Preparing to Print Mechanical Project Architectural Project Text Working with Annotations Adding Text in a Drawing Modifying Multiline Text Formatting Multiline Text Adding Notes with Leaders to Your Drawing Creating Tables Modifying Tables Hatching Hatching Editing Hatches Adding Dimensions Dimensioning Concepts Adding Linear Dimensions Adding Radial and Angular Dimensions Editing Dimensions Projects - Annotating Your Drawing Mechanical Project Architectural Project 1 Architectural Project 2 Civil Project Additional course details: Nexus Humans AutoCAD Level 1 - Essentials 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 AutoCAD Level 1 - Essentials 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.

Fatigue journeys vary from person to person - no two experiences are the same. But there's one challenging topic that seems to feature in most people's journeys at one time or another... communication! In this webinar recording I share tips and advice on how to tackle five of the most common conversation challenges when you're on a fatigue recovery journey. How this webinar will help you There are many reasons why conversations with others can be challenging when you've got fatigue - the key one being that fatigue challenges seem to be very difficult to understand (or even believe) if you haven't been through one yourself. And this really doesn't help when it comes to interacting with others - whether that be your loved ones, colleagues, or those you've only just met. I've helped countless people figure out how to communicate with those around them, in ways that don't negatively impact their health - while keeping both parties feeling as positive about the interaction as possible. This has given me a clear view of the most common challenges people face, and the solutions that tend to work best. And that's what I share with you in this recording of a webinar held recently. Of course, conversations are contextual and every single one is unique. But the tips and suggestions I share here can be tailored and customised to many different situations. I can't commit to running this as a live event terribly often, so I recorded the last time I ran it - and now offer it to you to purchase on demand. Meaning you can access this help straight away! Contents A quick introduction! Comms_intro.mov 2 mins101 MB The webinar recording In this 49 minute video, hear me give advice and tips on how to tackle these tricky communication situations: Communicating your situation to those you live with/are close to - in a way that goes well, and doesn't negatively impact your health/symptoms How to talk to people who are 'helpfully' trying to tell you how to cure yourself (when you know it's wrong!) Socialising with friends when you have fatigue Navigating conversations at large events (weddings, parties etc) How to talk to people who don't understand fatigue (or even believe in it) Main event.mp4 49 mins83 MB A copy of the slides I presented Communicating when fatigued0410.pdf 1.38 MB The Q&A digest This is a written capture of the Q&A discussion, held after my main presentation. I didn't record the Q&A in order to allow those who attended live to feel comfortable switching their cameras on and participating in the discussion. I hope you find this written summary helpful. Comms webinar Q&A capture.pdf 65.6 KB

Join our Talent Management course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Talent Management course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Talent Management course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Talent Management. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital/PDF Certificate After completing the Talent Management course, you can order your CPD-accredited Digital/PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. (Each) Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Talent Management is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Talent Management course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Talent Management Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Section 1: Introduction Unit 1: Welcome to the Course 00:05:00 Unit 2: Highlights of this Course 00:02:00 Unit 3: Little Activity Before We Begin 00:01:00 Section 2: Core Concepts of Talent Management Unit 1: What is Talent Management 00:03:00 Unit 2: Responsibilities of Talent Management Manager & Professionals 00:02:00 Unit 3: Talent Management - The Pillar of Successful Business 00:03:00 Unit 4: Benefits of Talent Management: How Your Business Can Benefit From it 00:02:00 Section 3: Top Reasons Why Employees Leave an Organisation Unit 1: Top 5 Reasons Why Employees Leave an Organisation 00:04:00 Unit 2: Reasons of Employee Resignation 00:03:00 Section 4: Understanding the Needs and Mindset of Employee Unit 1: The Most Useful Technique to Understand Employee's Needs 00:04:00 Unit 2: Practical, Real Life Example of Retaining Top Employees & Keeping Them Engaged 00:06:00 Section 5: Steps to Create an Effective Talent Management Plan Unit 1: Steps in Talent Management Process 00:02:00 Section 6: Talent Acquisition Unit 1: What is Talent Acquisition and How it is Different from Recruitment 00:02:00 Unit 2: Steps for Talent Acquisition 00:05:00 Unit 3: Top Selection Tests to Check Candidate's Potential 00:04:00 Unit 4: Manpower Estimation Template 00:01:00 Section 7: How to Develop High Potential Employees Unit 1: Creating a High Performance Workforce 00:05:00 Unit 2: Understanding the Difference Between Training & Development 00:02:00 Unit 3: Why Talent Development Process is Important for Employees 00:02:00 Unit 4: How Talent Development Helps in Running the Business Smoothly 00:03:00 Unit 5: Steps in Developing the Talent 00:02:00 Section 8: Evaluating Performance Unit 1: Performance Management 00:02:00 Unit 2: Performance Appraisal 00:01:00 Unit 3: Tools for Performance Appraisal 00:06:00 Section 9: "SMR" - How You Can Retain the Employees Using This Formula Unit 1: 'SMR' - How You Can Retain the Employees Using This Formula 00:04:00 Section 10: How to Retain High Potential Employees Unit 1: Employee Retention Programs 00:02:00 Unit 2: Onboarding Correctly 00:06:00 Unit 3: Career Planning & Development 00:04:00 Unit 4: Job Promotions 00:05:00 Unit 5: Using Motivators (Financial & Non- Financial Incentives) 00:05:00 Unit 6: Maintaining Work-Life Balance 00:02:00 Section 11: Bonus Section: Achieving Business Goals with Talent Management Strategy Unit 1: Return on Investment (ROI) on Talent Management 00:03:00 Unit 2: Achieving Business Goals with The Help of Talented Workforce 00:04:00 Unit 3: Little Activity Before We Began - Here's What You Learnt 00:02:00 Section 12: Conclusion Unit 1: Conclusion 00:01:00

Using Blueprints in UE5, you can learn game development without coding. This beginner-friendly course will teach you how to use Unreal Engine's visual coding system. There is no prior experience required, and each lesson will gradually increase your knowledge.

Want to master medical coding and billing? Are you interested in setting up a medical coding and billing

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 Learn Game Development using Cocos2d-x v3 C++ 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 Learn Game Development using Cocos2d-x v3 C++ Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Learn Game Development using Cocos2d-x v3 C++ 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 Learn Game Development using Cocos2d-x v3 C++ 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 Learn Game Development using Cocos2d-x v3 C++? 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 Game Development using Cocos2d-x v3 C++ 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 Learn Game Development using Cocos2d-x v3 C++ 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 Learn Game Development using Cocos2d-x v3 C++ does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Learn Game Development using Cocos2d-x v3 C++ 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 Learn Game Development using Cocos2d-x v3 C++ is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Course Introduction 00:03:00 Section 02: Setting Up Setting Up For iOS 00:05:00 Setting Up For Android on Mac 00:11:00 Setting Up For Android on Windows 00:13:00 Multi Resolution Support 00:16:00 Section 03: Adding a Sprite Adding a Sprite 00:04:00 Section 04: Positioning Positioning Using MoveBy 00:03:00 Positioning Using MoveTo 00:03:00 Positioning Using JumpBy 00:03:00 Positioning Using JumpTo 00:03:00 Positioning Using BezierBy 00:04:00 Positioning Using BezierTo 00:03:00 Positioning Using Place 00:02:00 Section 05: Scaling Scaling Using ScaleBy 00:03:00 Scaling Using ScaleTo 00:03:00 Section 06: Rotation Rotating Using RotateBy 00:03:00 Rotating Using RotateTo 00:03:00 Section 07: Tinting Tinting Using TintBy 00:03:00 Tinting Using TintTo 00:02:00 Section 08: Fading Fading Using FadeTo 00:02:00 Fading Using FadeIn 00:02:00 Fading Using FadeOut 00:02:00 Section 09: Sequencing Repeat 00:04:00 RepeatForever 00:03:00 Sequence 00:04:00 Section 10: Skewing Skewing Using SkewBy 00:02:00 Skewing Using SkewTo 00:02:00 Section 11: Audio Playing Sound Effect 00:06:00 Playing Sound Effect Repeatedly 00:04:00 Setting Sound Effect Volume 00:03:00 Stopping Sound Effect 00:05:00 Playing Music 00:04:00 Stopping Music 00:03:00 Pausing and Resuming Music 00:04:00 Setting Music Volume 00:03:00 Section 12: Touch Input Setting Up Single Touch Events 00:04:00 Touch Began Using onTouchBegan 00:05:00 Touch Moved Using onTouchMoved 00:03:00 Touch Ended Using onTouchEnded 00:03:00 Setting Up Multi Touch Events1 00:05:00 Touches Began Using onTouchesBegan 00:02:00 Touches Moved Using onTouchesMoved 00:03:00 Touches Ended Using onTouchesEnded 00:03:00 Section 13: Menus Setting up A Menu 00:03:00 Adding a Menu Font Item 00:07:00 Adding a Menu Image Item 00:05:00 Menu Alignment 00:02:00 Section 14: Scenes Creating a New Scene 00:04:00 Pushing a Scene 00:05:00 Popping a Scene 00:03:00 Replace a Scene 00:05:00 Scene Transitions 00:03:00 Section 15: Animations Sprite Animations 00:04:00 Section 16: Accelerometer Accelerometer 00:05:00 Section 17: Cocos Console Creating a New Project 00:02:00 Compiling a Project 00:07:00 Running a Project 00:07:00 Deploying a Project 00:06:00 Section 18: Resource Resource 00:00:00 Assignment Assignment - Learn Game Development using Cocos2d-x v3 C++ 00:00:00

With expert guidance and easy-to-understand narration, this course gets you up and running with the SwiftUI framework. You will learn how to use the SwiftUI framework, its tools, and its technology to build applications with ease.

Duration 3 Days 18 CPD hours This course is intended for This course benefits individuals responsible for configuring and monitoring devices running the Junos OS. Overview Describe the value of MPLS VPNs. Describe the differences between provider-provisioned VPNs and customer-provisioned VPNs. Describe the differences between Layer 2 VPNs and Layer 3 VPNs. List the provider-provisioned MPLS VPN features supported by the JUNOS software. Describe the roles of a CE device, PE router, and P router in a BGP Layer 3 VPN. Describe the format of the BGP routing information, including VPN-IPv4 addresses and route distinguishers. Describe the propagation of VPN routing information within an AS. List the BGP design constraints to enable Layer 3 VPNs within a provider network. Explain the operation of the Layer 3 VPN data plane within a provider network. Create a routing instance, assign interfaces to a routing instance, create routes in a routing instance, and import/export routes from a routing instance using route distinguishers/route targets. Describe the purpose of BGP extended communities, configure extended BGP extended communities, and use BGP extended communities. List the steps necessary for proper operation of a PE-CE dynamic routing protocol. List the troubleshooting and monitoring techniques for routing instances. Explain the difference between the bgp.l3vpn table and the inet.0 table of a routing instance. Monitor the operation of a CE-PE dynamic routing protocol. Explain the operation of a PE mulit-access interface in a Layer 3 VPN and list commands to modify that behavior. Describe ways to support communication between sites attached to a common PE router. Provision and troubleshoot hub-and-spoke Layer 3 VPNs, Describe the flow of control traffic and data traffic in a hub-and-spoke Layer 3 VPN. Describe QoS mechanisms available in L3VPNs. Configure L3VPN over GRE tunnels. Describe the RFC 4364 VPN options. Describe the carrier-of-carriers model. Configure the carrier-of-carriers and ''Option C'' configuration. Describe the flow of control and data traffic in a draft-rosen multicast VPN. Describe the configuration steps for establishing a draft-rosen multicast VPN. Monitor and verify the operation of draft-rosen multicast VPNs. Describe the flow of control traffic and data traffic in a next-generation multicast VPN. Describe the configuration steps for establishing a next-generation multicast VPN. Describe the configuration steps for establishing a next-generation multicast VPN. Monitor and verify the operation of next-generation multicast VPNs. This three-day course is designed to provide students with MPLS-based Layer 3 virtual private network (VPN) knowledge and configuration examples. Chapter 1: Course Introduction Course Introduction Chapter 2: MPLS VPNs MPLS VPNs Provider-Provisioned VPNs Chapter 3: Layer 3 VPNs Layer 3 VPN Terminology VPN-IPv4 Address Structure Operational Characteristics Chapter 4: Basic Layer 3 VPN Configuration Preliminary Steps PE Router Configuration Lab: Layer 3 VPN with Static and BGP Routing Chapter 5: Layer 3 VPN Scaling and Internet Access Scaling Layer 3 VPNs Public Internet Access Options Lab: LDP over RSVP Tunnels and Public Internet Access Chapter 6: Layer 3 VPNs ? Advanced Topics Exchanging Routes between Routing Instances Hub-and-Spoke Topologies Layer 3 VPN CoS Options Layer 3 VPN and GRE Tunneling Integration Layer 3 VPN and IPSec Integration Layer 3 VPN Egress Protection BGP prefix-independent convergence (PIC) edge for MPLS VPNs VRF Localization Provider Edge Link Protection Support for configuring more than 3 million L3VPN Labels Lab: GRE Tunneling Chapter 7: Interprovider Backbones for Layer 3 VPNs Hierarchical VPN Models Carrier-of-Carriers Model Option C Configuration Lab: Carrier of Carrier Layer 3 VPNs Chapter 8: Troubleshooting Layer 3 VPNs Working with Multiple Layers Troubleshooting Commands on a PE Device Multiaccess Interfaces in Layer 3 VPNs PE and CE-based Traceroutes Layer 3 VPN Monitoring Commands Lab: Troubleshooting Layer 3 VPNs Chapter 9: Draft Rosen Multicast VPNs Multicast Overview Draft Rosen MVPN Overvie Draft Rosen MVPN Operation Configuration Monitoring Chapter 10: Next Generation Multicast VPNs Multicast VPN Overview Next-Generation MVPN Operation Configuration Monitoring Internet Multicast Ingress Replication Internet Multicast Signaling and Data Plane Configuring MVPN Internet Multicast Monitoring MVPN Internet Multicast Lab: MVPN Internet Multicast

Duration 2 Days 12 CPD hours This course is intended for vSphere administrators, architects, system engineers, and systems integrators who are responsible for the deployment or management of Site Recovery Manager Overview By the end of the course, you should be able to meet the following objectives: Summarize the components of Site Recovery Manager architecture Deploy and configure the Site Recovery Manager appliance Describe the principal disaster recovery topologies that are used with Site Recovery Manager Configure inventory and resource mappings Describe the storage replication options that are used with Site Recovery Manager Configure Site Recovery Manager to leverage array-based replication Describe VMware vSphere Replication™ functionality Describe the vSphere Replication architecture Deploy and configure vSphere Replication for use with Site Recovery Manager Build Site Recovery Manager protection groups based on vSphere Replication Build, edit, execute, test, and remove a recovery plan Perform a planned migration Perform reprotect and failback using Site Recovery Manager and vSphere Replication This hands-on training course gives experienced VMware vSphere© administrators the knowledge to install, configure, and manage VMware Site Recovery Manager? 8.2. This course also shows you how to write and test disaster recovery plans that use Site Recovery Manager. Course Introduction Outline the necessary information to effectively undertake this course Identify resources for additional information Overview and Architecture Discuss Site Recovery Manager architecture Examine disaster recovery options with Site Recovery Manager Describe Site Recovery Manager integration with VMware vSphere© ClientTM Discuss Site Recovery Manager features Analyze Site Recovery Manager storage policies and integration options Discuss how Site Recovery Manager supports several disaster recovery topologies identify use cases for Site Recovery Manager across various scenarios Describe how VMware Site Recovery? for VMware Cloud? on AWS integrates with Site Recovery Manager. Deploy & Configure Site Recovery Manager Identify the requirements to deploy Site Recovery Manager Discuss the benefits of the Site Recovery Manager appliance Explore vSphere deployment models Deploy the Site Recovery Manager appliance Navigate the Site Recovery Manager configuration user interface Describe the process to register Site Recovery Manager with VMware vCenter Server© Configure site pairing Identify how to perform updates to the Site Recovery Manager appliance Configuring Inventory Mappings Outline the importance of inventory mappings Examine configuration options for inventory mappings Outline the importance of placeholders Using Array-based Replication Describe array-based replication Discuss the role of the Storage Replication Adapter (SRA) Explore the relationship between devices, consistency groups and datastore groups Configure array pairs vSphere Replication Explore vSphere Replication architecture Examine vSphere Replication functionality Formulate use cases for vSphere Replication Deploy a vSphere Replication appliance Configure vSphere Replication appliance settings Configure a vSphere Replication appliance connection Deploy a vSphere Replication server Register a vSphere Replication server Replicating Virtual Machines with vSphere Replication Configure vSphere Replication for virtual machines Explain the importance of datastore mappings Describe vSphere Replication recovery point objective scheduling Describe the vSphere Replication disk transfer protocol Building Protection Groups Define protection group functionality Examine the differences between array-based protection groups, protection groups based on vSphere Replication, and storage profile protection groups Create a protection group Discuss protection group settings Remove protection from a virtual machine Create a storage profile protection group Building Recovery Plans Discuss recovery plan concepts List recovery plan steps Discuss network planning Discuss customization options in recovery planning Outline how to implement a recovery plan Investigate recovery plan options Testing and Running a Recovery Plan Discuss use cases for Site Recovery Manager Describe planned migration Identify Site Recovery Manager workflows Discuss the importance of VMware vSphere© VMFS resignaturing Examine Site Recovery Manager integration with various vSphere technologies Outline how to conduct a recovery plan test Perform recovery plan test execution Identify the effects on the storage layer during recovery steps Explain a recovery plan execution in planned migration or disaster recovery mode Understand storage layer changes for plan execution types Identify the recovery steps for each execution type Describe how to reprotect a data center Examine failback steps Monitoring and Troubleshooting Discuss Site Recovery Manager alarms Explore Site Recovery Manager history reports Configuring advanced Site Recovery Manager settings Describe how to modify logging levels Explain how to collect log bundles Identify key log locations

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.