35207 Design courses delivered Online

Writing and Managing Requirements Documents - Creating the Acceptable, Approvable Requirements Document: On-Demand This course will enhance the skill set needed for writing and managing the complex readership that business analysts interact with on a day-to-day basis. What You Will Learn Upon Completion, participants will be able to: Write an understood requirements document that is approvable and acceptable Validate a requirements document Manage the changes to requirements documents through the SDLC Foundation Concepts The role of the business analyst An introduction to the BABOK® Guide The business analyst and the product/project life cycle The requirements documentation process Planning for Effective Requirements Documentation Overview of requirements planning Planning for validation Planning for verification: well-formed criteria Planning for verification: understood and usable criteria Writing Effective Requirements Documents Overview of writing requirements documents Using a standard structure / template Applying formatting techniques Meeting the challenge of writing non-functional requirements Baselining Requirements Documents Overview of the requirements baseline process Validation Verification Approval Managing Requirements Change through the Product Life Cycle Overview of requirements change management Establishing a formal change management process Tracing requirements through design and development (build, test, and implementation) Following through to post-implementation (transition and early production) Summary What did we learn, and how can we implement this in our work environments?

**Don't Spend More; Spend Smarter** Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Give a compliment to your career and take it to the next level. This Fine Art : Media and Art will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate skills for your next promotion, this Fine Art : Media and Art will help you keep ahead of the pack. The Fine Art : Media and Art incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your expertise and essential knowledge, which will assist you in reaching your goal. Further, this Fine Art : Media and Art will add extra value to your resume to stand out to potential employers. Along with this Fine Art : Media and Art course, you will get 10 premium courses, an original Hardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This Fine Art : Media and Art Bundle Consists of the following Premium courses: Course 01: Drawing and Illustration Level 2 Course 02: Landscape Paintings with Acrylic Course 03: Digital Art - Sketching In Photoshop Course 04: Adobe Illustrator CC Masterclass Course 05: Diploma in Animation Design Course 06: Basic Adobe Photoshop Course 07: Level 2 Adobe Graphics Design Course Course 08: Advanced Diploma in User Experience UI/UX Design Course 09: Video Editing Course 10: Toon Boom: Create Your First Character Course 11: Voiceover Artist Training So, enrol now to advance your career! How will I get my Fine Art : Media and Art Certificate? After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) Enroll Fine Art : Media and Art today Curriculum: Course 01: Drawing and Illustration Level 2 Introduction Perspective Shading Measuring Still Life Drawing Drawing a Portrait Drawing a Tree Course 02: Landscape Paintings with Acrylic Introduction Welcome to Switzerland Big Painting Course 03: Digital Art - Sketching In Photoshop Introduction Introduction to Photoshop Customizing Your Workspace Creating a New Document Installing Brush The Layers Panel Finding Reference Simplifying Your Reference Warm Up Sketch Sketching Refining Your Sketch Demo Your Project Conclusion Course 04: Adobe Illustrator CC Masterclass Getting Started Getting Comfortable in the Illustrator Environment Working With Selections Drawing Shapes Managing Objects Working With Colour Working With Type Going Further With Illustrator Saving and Exporting Your Work Wrapping Up Course 05: Diploma in Animation Design INTRODUCTION THE 12 PRINCIPLES OF ANIMATION JUMPING ELEPHANT WALKCYCLE RUNCYCLE DIALOGUE Course 06: Basic Adobe Photoshop Section 01: Shortcuts & the Brush Section 02: Layers Section 03: Modify Your Portrait Section 04: Watermark & Figures Section 05: Modify Your Text Course 07: Level 2 Adobe Graphics Design Course Basics of Graphic Design Foundation in Design Adobe Photoshop Basics Designers go to Software Adobe Illustrator Introduction and Typography Creating Logos with Illustrator Logo Design Basics Adobe in Design and Print Work Introduction Course 08: Advanced Diploma in User Experience UI/UX Design UX/UI Course Introduction Introduction To The Web Industry Foundations of Graphic Design UX Design (User Experience Design) UI Design (User Interface Design) Optimization Starting a Career in UX/UI Design Course 09: Video Editing Introduction to the Course Download Davinci Resolve Project Settings and Overview of Resolve The Media Tab Cut Tab Overview Making Ins and Outs in the Cut Tab with Precision Smart Editing Tools Trim Modes Overlay Edits Sync Audio with Video Mixing Audio Working with Transitions in Davinci Resolve Adding Effects Adding Texts Colour Tab Overview Understanding Nodes Tracing Effects Cinematic Look Viewing the Clip Fairlight Tab Fusion Tab How to Remove Green Screen Using Chroma Key Delta Keyer Deliver Tab Course 10: Toon Boom: Create Your First Character Introduction Class project Creating new scene Workspace Importing images and assets Basic Drawing tools Creating the head shape Using of shape tools Creating facial details Creating character body Finishing the drawing Creating colour palette Using gradient editor tool Colouring the rest of the drawing Rendering the image That's it Course 11: Voiceover Artist Training Introduction to Voiceover Voiceover Basics Finding Your Voice Using Your Instrument Exercising Your Voice Useful Tips Plan Your Demo The Audition Record Your Voice The Studio Promoting Your Voice UK Voice Acting Industry CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Fine Art : Media and Art bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our Fine Art : Media and Art is fully compatible with PC's, Mac's, laptops, tablets 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 Having this various expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Drawing and Illustration Level 2) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

DASA DevOps Professional: Enable and Scale: Virtual In-House Training DevOps embodies both cultural changes and practices through which organizations can facilitate the IT functions of software development (Dev) and software operation (Ops). The DevOps movement advocates automation and phase-based monitoring practices. Its objectives include: Decreasing development cycles · Increasing deployment frequency Improving the reliability of releases Developing a closer alignment with business objectives The DASA DevOps Professional: Enable and Scale course (formerly known as DevOps Practitioner) is designed to provide individuals with the core education necessary to put DevOps into practice. With the help of DevOps theory, pragmatic examples and exercises, and interactive group discussions, the course will help you understand how to apply the necessary skills to practice DevOps. Building on the knowledge learned on theFundamentals course (the 'why'), you will learn the 'how'. The DevOps Professional: Enable and Scale course focuses on improving the skill set of the DASA competency model, which includes competencies like Courage, Teambuilding, DevOps Leadership, and Continuous Improvement. On completion of the DASA DevOps Professional: Enable and Scale training and passing the exam, the certification is awarded. What you will Learn At the end of this program, you will be able to: Explain the importance of DevOps culture and the aspects that can influence it Explain why courage, teambuilding, leadership, and continuous improvement are required in a DevOps environment Explain why courage is essential to enable trust, honesty, and experimentation Identify and evaluate different types of behavior in a DevOps environment Recognize the signals indicating impediments and/or team dysfunctions Describe how to form good DevOps teams and assess their maturity List the effects of happiness and motivation on team performance Identify how leaders encourage feedback and transparency Discuss the factors that leaders can influence to build trust Explain how and why leaders promote a 'safe to fail' environment Analyze value streams to improve throughput and flow Facilitate the tools for continuous improvement: structured problem-solving workshops, Story Mapping sessions, and retrospectives TEAMBUILDING Teambuilding is about understanding the other's point of view, collaboration, mutual accountability, common purpose, and the ability to integrally support the service/product. Design Teams Characteristics of a DevOps team Skills of a DevOps Team Self-organization and autonomy Rules to consider when designing DevOps teams Build Teams Effects of happiness and motivation on performance Feedback Creating high-performance teams Governance Governance within teams and between multiple teams Governance between organizations DevOps contracts DEVOPS LEADERSHIP This module describes how to facilitate teams to high performance, DevOps behavior, transparency, and a service lifecycle mindset. Build Culture Creating the right environment and providing vision and purpose Stimulating the right behavior Servant leadership: giving control, supporting, and inspiring Create Purpose Defining and aligning purpose Purpose of having a purpose Alignment versus autonomy Be a Servant Leader Give control to the team Inspire and support the team Focus on Success Output versus outcome Measuring and steering COURAGE The Courage module is about coaching courageous behavior, proactivity, reflection, trust, open discussions, experimentation, fail fast, and the courage to change. Build Courage The importance of courage Courage in relationship with leadership and feedback Enabling courage at the team level Dealing with failure Think Different Courage day to day Encourage critical thinking Techniques to promote courageous behavior VALUE CUSTOMER-CENTRIC ACTION This module describes the important aspects that are relevant to identify and deliver the required and expected value for all relevant stakeholders. Aspects of Value and Managing Expectations The different aspects of value Stakeholder management Customer collaboration and using customer feedback How to do prioritization CONTINUOUS IMPROVEMENT Continuous improvement describes the importance of a Kaizen mindset, quality at the source, first time right, knowledge-sharing, and the ability to adapt. Build Flow Understanding the importance of flow Using Lean to optimize flow Kaizen as a mindset Radical change versus Kaizen Using Pull to optimize flow Continuous Improvement Tools Kaizen Event Value Stream Mapping Visual Management Retrospective Daily Standup Five Times Why

***24 Hour Limited Time Flash Sale*** Construction & Structural Drawing Like Pro Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive Construction & Structural Drawing Like Pro Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Construction & Structural Drawing Like Pro bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Construction & Structural Drawing Like Pro Online Training, you'll receive 25 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Construction & Structural Drawing Like Pro Career Bundle: Course 01: Construction & Structural Drawing Course 02: LEED V4 - Building Design and Construction Course 03: Architectural Studies Course 04: Interior Design Professional Diploma Course 05: Professional Interior Design & Construction Course 06: CAD Design Course: Assemblies, Modelling, And Civil Drawings Course 07: Solidworks Foundation Training Course 08: Intermediate Solidworks Course Course 09: Autocad Electrical Design Course 10: WELL Building Standard Course 11: Diploma in Construction Management Course 12: Quantity Surveyor Diploma Course 13: Building Surveyor Course 14: Land Surveying Course 15: Construction Cost Estimation Diploma Course 16: Construction Estimation using RSMeans Course 17: Construction Cost Estimation Using Xactimate Course 18: Cost Estimation for Multiplex Building Using Xactimate Course 19: AutoCAD Programming using C# with Windows Forms Course 20: Construction Safety Course 21: Fire Safety | Online Course Course 22: Emergency First Aid and Incident Management at Work Course 23: Property Law and Legislation Course 24: Construction Industry Scheme (CIS) Course 25: Bricklaying With Construction & Structural Drawing Like Pro, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Don't let this opportunity pass you by. Enrol in Construction & Structural Drawing Like Pro today and take the first step towards achieving your goals and dreams. Why buy this Construction & Structural Drawing Like Pro? Free CPD Accredited Certificate upon completion of Construction & Structural Drawing Like Pro Get a free student ID card with Construction & Structural Drawing Like Pro Lifetime access to the Construction & Structural Drawing Like Pro course materials Get instant access to this Construction & Structural Drawing Like Pro course Learn Construction & Structural Drawing Like Pro from anywhere in the world 24/7 tutor support with the Construction & Structural Drawing Like Pro course. Start your learning journey straightaway with our Construction & Structural Drawing Like Pro Training! Construction & Structural Drawing Like Pro premium bundle consists of 25 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of Construction & Structural Drawing Like Pro is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Construction & Structural Drawing Like Pro course. After passing the Construction & Structural Drawing Like Pro exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Construction & Structural Drawing Like Pro course is ideal for: Students seeking mastery in Construction & Structural Drawing Like Pro Professionals seeking to enhance Construction & Structural Drawing Like Pro skills Individuals looking for a Construction & Structural Drawing Like Pro-related career. Anyone passionate about Construction & Structural Drawing Like Pro Requirements This Construction & Structural Drawing Like Pro doesn't require prior experience and is suitable for diverse learners. Career path This Construction & Structural Drawing Like Pro bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

This bundle will transform your approach to the inclusion of autistic children with all of our most effective course modules

Overview While thousands of new homes are being constructed, there need to be more skilled labourers to support their trade. More than ever, there needs to be more skilled artisans in the United Kingdom, mainly electrical work. An electrician must know how to install and maintain street and intercom systems, design lighting systems, ensure electrical work complies with codes, and fix broken wires. The work of an electrician is physically demanding and can be hazardous if done improperly. Therefore, a complete training and skill development programme is required before entering this work sector. With our Electrical 3 Phase Power Transformers Fundamentals course, learners will have a firm awareness of the fundamental principles of electricity and how it works. What Can You Hope To Achieve By Completing This Course? Specifying the basic principles and concepts of transformers. Differentiating between ideal and real transformers and their characteristics. Gaining knowledge of instrument transformers and their applications. Understanding the principles and operation of three-phase power transformers. Learning about transformer construction, cooling methods, and protection mechanisms. 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 Electrical 3 Phase Power Transformers Fundamentals. It is available to all students, of all academic backgrounds. Requirements Our Electrical 3 Phase Power Transformers Fundamentals is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 9 lectures • 05:37:00 total length •Module 01: Introduction: 00:10:00 •Module 02: The Ideal Transformer: 00:55:00 •Module 03: The Real Transformer: 00:09:00 •Module 04: Instrument Transformers: 00:19:00 •Module 05: Three Phase Power Transformers: 01:50:00 •Module 06: Transformer Clock System Vector Nomenclature: 00:17:00 •Module 07: Transformer Construction and Cooling: 00:25:00 •Module 08: Transformer Protection: 00:54:00 •Module 09: Transformer Relays: 00:38:00

Facilitation Skills for Business Analysts: Virtual In-House Training This course is part of IIL's Business Analysis Certificate Program (BACP), a program designed to help prepare individuals pass the IIBA® Certification exam to become a Certified Business Analysis Professional (CBAP™). Business analysts are communicators who bridge the gap between people with business needs and knowledge and the people who will provide solutions. Business analysts are continuously involved in communications with stakeholders and developers as they create the solution to business problems. They participate in information-gathering sessions including interviewing, joint requirements definition, and Joint Application Design (JAD) workshops which are used to streamline information gathering and get immediate validation from user representatives. The business analyst is also involved with negotiating the solution with the stakeholders, upper-level management, and the developers, mediating among the groups when disagreements take place, and influencing the results of decisions during the solution cycle. This course teaches the methods needed to organize and run information-gathering events. It combines the basics of graphic decision making and modeling with facilitation, communication, and meeting management skills. What you will Learn At the end of this program, you will be able to: Identify the major touch points between key BABOK® Guide knowledge areas and business analysis communication Describe the facilitation skills that are most supportive of those intersections Improve your ability to apply these skills in the context of your business analyst functions Foundation Concepts The role of the Business analyst (BA) An Introduction to the BABOK® Guide Business analyst roles and the product / project life cycle (PLC) Facilitation skills for the business analyst The BABOK® Guide and Communication An introduction to the communication process Addressing basic communications challenges Planning business analysis communication Communication and BABOK® Guide tasks Targeted Elicitation Techniques Synergy between communication and targeted elicitation techniques Preparing for elicitation Cornerstone targeted technique: interviews Other targeted elicitation techniques Related general communication skills Group Elicitation Techniques Synergy between requirements communication and group elicitation techniques Cornerstone group elicitation technique - requirements workshops Other group elicitation techniques Related general communication skills - meeting management best practices Related general communication skills - facilitating best practices Process / Model-Based Elicitation Techniques Synergy between requirements communication and process / model-based elicitation techniques Process / model-based elicitation techniques Related interpersonal skills - problem solving and decision making Investigative Elicitation Techniques Synergy between requirements communication and investigative elicitation techniques Cornerstone investigative elicitation technique - document analysis Other investigative elicitation techniques Summary of elicitation techniques by usage in the requirements process Using Presentations, Structured Walkthroughs, and Influencing Structured walkthroughs, presentations, and influencing within BABOK® Guide tasks Cornerstone technique - structured walkthroughs General communication skill - presenting Related interpersonal skill - influencing Special Facilitation Skills - Negotiating and Mediating Negotiating Mediating

If you are searching for the right course to learn about iOS Development from scratch, you've just found it. This course will take you from a complete beginner to a confident practitioner, as we focus on practical iOS development without neglecting the theory.

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 Adobe After Effects Training 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 the professional training that employers are looking for in today's workplaces. The Adobe After Effects Training Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Adobe After Effects Training 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 Adobe After Effects Training Course, like every one of Skillwise'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 Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Adobe After Effects Training ? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance 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 Adobe After Effects Training there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the PDF certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Adobe After Effects Training course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already work in relevant fields and want to polish their knowledge and skills. Prerequisites This Adobe After Effects Training does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Adobe After Effects Training was made by professionals and it is compatible with all PCs, Macs, 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 a bonus, you will be able to pursue multiple occupations. This Adobe After Effects Training is a great way for you to gain multiple skills from the comfort of your home. Course Promo Learn After Effects for Social Media Promo 00:01:00 Project #1(Beginner) - Create an Instagram Story Quick Introduction 00:01:00 Set up Our Project File 00:04:00 Add Our Background and Animate it 00:06:00 Throw in Some Text 00:06:00 Animate the Text In and Out 00:11:00 Music, Render 00:05:00 Project #2 (Intermediate) - Create "Viral Style" Text Boxes and Learn Animation Create a Text Box and Align 00:04:00 The Anchor Point & Scaling 00:06:00 Animating the Text Box 00:04:00 Fit the Text in the Box 00:05:00 The Grand Reveal 00:04:00 Render and Congratulations 00:08:00 Project#3 (Advanced) Screen Capture and Web Presentation Project Screen Capture Software 00:05:00 Replace a Phone or Laptop Screen 00:10:00 Create a '3D' Display 00:09:00 PROJECT - Create your own Web Browser 00:16:00 Project #4 (Advanced) Create a Social Media Animated Poster Social Media Project Introduction 00:02:00 The Master Plan 00:08:00 Time to Design 00:16:00 Trim Paths 00:04:00 Animate Your Image 00:06:00 Let's Talk About Text 00:17:00 Shake that Button 00:09:00 Texture, Render, Congratulations 00:11:00 Assignment Assignment - Adobe After Effects Training 02:28:00 Order Your Certificate Order Your Certificate QLS

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 After completing this course, students will be able to: - 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 course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 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 Lab 1: Introduction to TSQL for Business Intelligence 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 Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNER JOIN Understanding Joins, Part 3: The OUTER JOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTER JOINs Combining JOIN Operations with WHERE and ORDER BY Lab 1: Write SELECT queries 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 Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS Non-correlated and correlated subqueries Derived tables Common table expressions Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Lab 1: Encapsulating Data Retrieval Logic 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 Lab 1: Getting Your Dataset to the Client Additional course details: Nexus Humans 55232 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 55232 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.