• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

35454 Design courses delivered Online

DASA DevOps Professional: Enable and Scale: Virtual In-House Training

By IIL Europe Ltd

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

DASA DevOps Professional: Enable and Scale: Virtual In-House Training
Delivered OnlineFlexible Dates
£1,750

Facilitation Skills for Business Analysts: Virtual In-House Training

By IIL Europe Ltd

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

Facilitation Skills for Business Analysts: Virtual In-House Training
Delivered OnlineFlexible Dates
£1,250

Advanced Digital Illustration: Exploring Mixed Media Techniques

By Compete High

Overview: Advanced Digital Illustration: Exploring Mixed Media Techniques   Unlock your creative potential and take your digital illustration skills to the next level with our comprehensive course: 'Advanced Digital Illustration: Exploring Mixed Media Techniques.' Whether you're a seasoned illustrator looking to expand your skillset or a beginner eager to dive into the world of digital art, this course offers a structured and immersive learning experience.   Module 1: Introduction to Advanced Digital Illustration Embark on your journey into advanced digital illustration with a solid foundation. Learn about the tools, techniques, and principles that will guide you through the rest of the course. Understand the importance of digital workflows, file management, and establishing your unique artistic style.   Module 2: Fundamentals of Composition and Color Theory Master the art of composition and color theory to create visually captivating illustrations. Explore the principles of balance, focal points, and harmony while delving into the psychology behind color choices. Elevate your artwork by understanding how to effectively communicate mood, emotion, and narrative through composition and color.   Module 3: Exploring Mixed Media Techniques in Digital Illustration Unleash your creativity by merging traditional and digital mediums in your artwork. Discover a variety of mixed media techniques, including incorporating hand-drawn elements, textures, and collage into your digital illustrations. Learn how to seamlessly integrate these techniques using popular software tools and workflows.   Module 4: Illustrating Characters and Portraits Bring your characters and portraits to life with depth, personality, and expression. Dive into the fundamentals of character design, anatomy, and facial expressions. Develop your skills in creating compelling character illustrations that resonate with your audience and convey powerful storytelling.   Module 5: Creating Dynamic Backgrounds and Environments Transport your viewers to immersive worlds through captivating backgrounds and environments. Learn essential techniques for creating dynamic landscapes, cityscapes, and atmospheric settings. Explore perspective, lighting, and mood to breathe life into your illustrations and enhance the narrative impact.   Module 6: Storyboarding and Narrative Illustration Master the art of visual storytelling through storyboarding and narrative illustration. Understand the fundamentals of sequential art, pacing, and composition to effectively convey narratives and concepts. Dive into practical exercises and projects that challenge you to craft compelling visual stories from start to finish.   By the end of this course, you'll emerge as a proficient digital illustrator equipped with the knowledge, skills, and confidence to tackle diverse illustration projects with creativity and flair. Elevate your artistic journey and join us in exploring the boundless possibilities of advanced digital illustration. Course Curriculum Module 1_ Introduction to Advanced Digital Illustration Introduction to Advanced Digital Illustration 00:00 Module 2_ Fundamentals of Composition and Color Theory Fundamentals of Composition and Color Theory 00:00 Module 3_ Exploring Mixed Media Techniques in Digital Illustration Exploring Mixed Media Techniques in Digital Illustration 00:00 Module 4_ Illustrating Characters and Portraits Illustrating Characters and Portraits 00:00 Module 5_ Creating Dynamic Backgrounds and Environments Creating Dynamic Backgrounds and Environments 00:00 Module 6_ Storyboarding and Narrative Illustration Storyboarding and Narrative Illustration 00:00

Advanced Digital Illustration: Exploring Mixed Media Techniques
Delivered Online On Demand6 hours
£25

Diploma in Web Video Production

4.3(43)

By John Academy

Description: This course design targets individuals who are willing to learn in detail about video and light production and also the people with no prior experience. In this course, students will know about different technical aspects of video making like audio production, camera operation, cameras and lighting and production management. Students joining this course will know in detail about skills required to operate a camera, recording sounds etc. Who is the course for? Beginners free lancer videographer production assistant Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Production Assistant Assistant camera operators film or video editor video equipment technician freelancer videographer boom operation. Diploma in Web Video Production Introduction 00:30:00 What You Can Use Video Production For 00:30:00 What You Will Need 00:30:00 Video Production Without Hardware 01:00:00 Planning and Pre-Production 01:00:00 Creating A Script 01:00:00 Filming and Production 01:00:00 Editing 01:00:00 Closing Notes 00:15:00 Mock Exam Mock Exam- Diploma in Web Video Production 00:20:00 Final Exam Final Exam- Diploma in Web Video Production 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Diploma in Web Video Production
Delivered Online On Demand7 hours 25 minutes
£25

BOW320 SAP BusinessObjects Web Intelligence - Advanced Report Design

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Analysts, and Business Process Owner/Team Lead/Power Users. Overview Create complex Web Intelligence documents using advanced query and reporting techniques, including:Combined queries and sub-queriesCharacter and date string functionsVariables and calculation contextsLink documents using hyperlinks In this course, students will gain the comprehensive skills and in-depth knowledge needed to apply alternative query and reporting techniques when creating complex Web Intelligence documents. Web Intelligence Core Report Design Reviewing Core Report Design Concepts Comparing the Differences between Java Report Panel (JRP) and WebI Rich Client (WRC) Multiple Data Sources Synchronizing Data from Multiple Data Sources Creating Multiple Queries in a Document Synchronizing Data with Merged Dimensions Interacting with Other Data Providers Advanced Query Techniques Implementing Combined Queries Implementing Subqueries Creating a Query Based on Another Query Changing Data Sources Calculation Contexts Describing Calculation Contexts Redefining Calculation Contexts Implementing Extended Syntax Operators Implementing Extended Syntax Keywords Defining Calculation Context Formulas with Character and Date String Functions Creating Formulas with Character and Date String Functions Implementing the Right() Function Implementing the Replace() Function Implementing the SubStr() Function Implementing the Pos() Function Concatenating Character Strings Implementing Date Functions If Logic Executing If() to Group Data Executing the If() Function to Modify Calculation Behavior Hyperlinks in Web Intelligence Documents Managing Hyperlinks in Web Intelligence Documents Managing Hyperlinks in Web Intelligence Desktop and the Rich Internet Application Panel Managing Hyperlinks in the Web Intelligence Interactive Panel Additional Reporting Techniques Implementing Data Tracking Implementing Additional Report Functions

BOW320 SAP BusinessObjects Web Intelligence - Advanced Report Design
Delivered OnlineFlexible Dates
Price on Enquiry

Civil Engineering and Construction Management

4.9(27)

By Apex Learning

Overview: ***Limited Time Flash Sale*** Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £250 as a Gift! - Enrol Now! Civil Engineering and Construction Management is a rapidly evolving field that is essential to building and maintaining the infrastructure that our society relies on. This Civil Engineering and Construction Management course will provide you with the essential knowledge and in-demand skills you need to succeed in this exciting and rewarding profession. Begin with the basics of Construction Management, learning about its Scope and the roles of Contractors and Subcontractors. The Construction Management course will guide you through Surveying, Cost Estimation, and the nuances of Construction Design. Additionally, you will get into the critical areas of Safety Standards and other miscellaneous but vital Construction Management. This Civil Engineering and Construction Management Bundle Consists of the following Premium courses: Course 01: Read Construction & Structural Drawing Like Expert Course 02: Diploma in Construction Management Course 03: Quantity Surveyor Diploma Course 04: Building Surveyor Course 05: Land Surveying Course 06: Construction Cost Estimation Diploma Course 07: Construction Industry Scheme (CIS) Course 08: WELL Building Standard Course 09: LEED V4 - Building Design and Construction Course 10: Architectural Studies Course 11: CAD Design Course: Assemblies, Modelling And Civil Drawings Course 12: Autocad Electrical Design Course 13: Solidworks Foundation Training Course 14: Interior Design Professional Diploma Course 15: Professional Interior Design & Construction Course 16: Construction Safety Course 17: Fire Safety | Online Course Course 18: Electrical Safety Course 19: Emergency First Aid and Incident Management at Work Course 20: RIDDOR Training Learning Outcomes: Read and understand architectural plans and construction drawings Apply Construction Management principles to the design and construction of various building components, such as footings, columns, beams, and slabs Use various software to model and analyze civil engineering structures Calculate dead and live loads, and apply them to civil engineering structures Design and detail civil engineering structures in accordance with standard codes and practices Key Features of the Course: FREE Construction Management CPD-accredited certificate Get a free student ID card with Construction Management training (£10 applicable for international delivery) Lifetime access to the Construction Management course materials The Construction Management program comes with 24/7 tutor support Get instant access to this Construction Management course Learn Construction Management training from anywhere in the world The Construction Management training is affordable and simple to understand The Construction Management training is an entirely online Enrol in Civil Engineering and Construction Management today and start your journey to becoming a successful civil engineer or construction manager! Description: Enrol in this Civil Engineering and Construction Management Bundle today and start your journey to becoming a successful civil engineer or construction manager! ★★★ Course Curriculum of Civil Engineering and Construction Management Bundle ★★★ Course 01: Read Construction & Structural Drawing Like Expert Section 01: Architectural & Structural Drawings of G+3 Residential Building Section 02: Etabs Model of G+3 Residential Building Course 02: Diploma in Construction Management Module 01: Introduction to Construction Management Module 02: Project Life Cycle and Success Module 03: Cost Management Module 04: Preliminary Site Investigation and Site Organisation Module 05: Site Management Module 06: Planning and Management of Equipment Module 07: Construction Materials Management Module 08: Vendor Analysis in Construction Management Module 09: Construction Procurement Module 10: Stock Control Module 11: Supply Chain Management Module 12: The Main Participators Module 13: Quality Assurance and Customer Care Module 14: Legal Aspects of Contracting Module 15: Human Resources Management Module 16: Risk and Value Management Module 17: Communications, Information and Documentation of Construction Module 18: Health and Safety in Construction Management =========>>>>> And 18 More Related Courses <<<<<========= How will I get my 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 £9.99*20 = £199.7) Hard Copy Certificate: Free (For The Title Course: Previously it was £14.99) So, enrol now in this Construction Management Bundle to kickstart your career! Who is this course for? Civil engineering and construction management Bundle: Students who are interested in a career in civil engineering or construction management Students who are currently pursuing a degree in civil engineering or construction management Professionals who want to upgrade their skills and knowledge in civil engineering or construction management Requirements Our Civil Engineering and Construction Management Bundle is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. This Civil engineering and construction management 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 Civil engineering and construction management course, it can be studied in your own time at your own pace. Career path This Civil Engineering and Construction Management bundle will help you learn the necessary skills to explore opportunities such as: Structural Engineer: £36,000 - £38,000 per annum Engineer: £27,000 - £45,000 per annum Construction Manager: £3,000 - £45,000 per annum Engineer Surveyor: £28,000 - £32,500 per annum Civil Engineer: £29,000 - £38,000 per annum Certificates Digital certificate - Included Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Construction Management) absolutely Free! Other hard-copy certificates are available for £14.99 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Civil Engineering and Construction Management
Delivered Online On Demand3 days
£109

Intermediate Solidworks Course

4.5(3)

By Studyhub UK

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 Intermediate Solidworks 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 Intermediate Solidworks Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Intermediate Solidworks 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 Intermediate Solidworks 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 Intermediate Solidworks Course? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Intermediate Solidworks Course 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 Intermediate Solidworks Course 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 Intermediate Solidworks Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Intermediate Solidworks Course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Intermediate Solidworks Course is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Unit 01: Part Modeling Advanced Techniques- Part 1 1.1 Extruded Boss Advanced 00:03:00 1.2 Extruded Boss Additional 00:04:00 1.3 Extruded Cut Advanced 00:03:00 1.4 Swept Boss 00:02:00 1.5 Lofted Boss 00:03:00 1.6 Draft 00:03:00 1.7 Shell 00:02:00 1.8 Rib 00:04:00 1.9 Example #1 00:08:00 1.10 Example #2 00:07:00 Unit 02: Part modeling advanced techniques- Part 2 2.1 Linked dimensions 00:04:00 2.2 Equations 00:05:00 2.3 Coordinate System 00:03:00 2.4 Hole wizard 00:03:00 2.5 Feature scope 00:02:00 2.6 Mirror 00:03:00 2.7 Example #1 00:09:00 2.8 Example #2 00:09:00 Unit 03: Design Table and Configurations 3.1 Creating a Design Table 00:06:00 3.2 Configurations 00:05:00 3.3 Example #1 00:07:00 3.4 Example #2 00:04:00 Unit 04: Assembly advanced techniques- Part 1 4.1 Distance and Angle 00:04:00 4.2 Profile Center 00:04:00 4.3 Symmetric and Width 00:05:00 4.4 Path Mate 00:05:00 4.5 Linear Coupler 00:06:00 4.6 Example #1 00:08:00 4.7 Example #2 00:13:00 Unit 05: Assembly advanced techniques- Part 2 5.1 Collision Detection 00:02:00 5.2 Interference Detection 00:03:00 5.3 Assembly Feature 00:02:00 5.4 Replacing Part 00:01:00 5.5 Sub-assembly 00:03:00 5.6 Example #1 00:05:00 5.7 Example #2 00:05:00 Assignment Assignment - Intermediate Solidworks Course 00:00:00

Intermediate Solidworks Course
Delivered Online On Demand2 hours 45 minutes
£10.99

55232 Writing Analytical Queries for Business Intelligence

By Nexus Human

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.

55232 Writing Analytical Queries for Business Intelligence
Delivered OnlineFlexible Dates
£1,785

Budget-Friendly Video Presentations Workshop

By Compete High

🌟 Elevate Your Presentations with Budget-Friendly Video Mastery! 🌟   🎬 Unleash Your Potential with the Budget-Friendly Video Presentations Workshop! 🎬   Are you ready to captivate your audience, stand out with stunning visuals, and deliver compelling video presentations without breaking the bank? Look no further! Welcome to our exclusive Budget-Friendly Video Presentations Workshop! In this comprehensive online course, you'll master the art of creating professional-grade video presentations on a budget. Whether you're a seasoned professional, a budding entrepreneur, or a student looking to excel in your presentations, this workshop is tailored just for you.   🔥 Here's what you'll gain from this workshop:   🎥 Masterful Video Creation: Learn step-by-step techniques to produce high-quality videos without expensive equipment or software. From scripting to filming and editing, discover the secrets to make your presentations stand out.   🎨 Visual Design Excellence: Explore cost-effective tools and design principles to create visually stunning slides, graphics, and animations that grab attention and leave a lasting impact.   💡 Budget-Savvy Tools & Techniques: Unlock the power of free and affordable resources, software, and apps to enhance your video quality, ensuring a professional finish without burning a hole in your pocket.   📈 Engagement & Impact: Understand how to engage your audience effectively, maintain their interest, and deliver a message that resonates, boosting your credibility and influence.   👩‍💻 Practical Hands-On Learning: Dive into practical exercises, real-life examples, and actionable tips from industry experts, empowering you to apply your newfound skills immediately.   🏆 Certificate of Completion: Receive a prestigious certificate upon finishing the course, showcasing your expertise in creating budget-friendly yet impressive video presentations.   🚀 Join our community of like-minded individuals dedicated to mastering the art of impactful video presentations without breaking the bank! Don't let budget constraints hinder your ability to create exceptional video content. Enroll in the Budget-Friendly Video Presentations Workshop today and unleash your creativity while saving your resources! Ready to take your presentations to the next level? Enroll now and start crafting captivating videos that leave a lasting impression!   Invest in your success. Invest in mastering video presentations on a budget! 🌟🎓🚀 Course Curriculum Budget-Friendly Video Presentations The Video Advantage In All Your Proposals - Quick Win! 00:00 Hype Versus Reality - Why Most People Never Create Simple Video 00:00 Mastering the Human Side Of Looking and Sounding Your Best on Video 00:00 How This course Will Improve Your Business 00:00 Your Proposals will Stand Head and Shoulders Above Your Competitors 00:00 Your Clients Will Find You Their Most Responsive Partner Ever 00:00 Your Website Can Be Video-Centric 00:00 Now You Can Answer Frequently Asked Questions Just Once! 00:00 Talk Your Customers Through Your Whole Business Process 00:00 Have an Even Greater Presence on YouTube 00:00 Speak Your Thought Leadership 00:00 Your Exciting Video Newsletters Will Outshine Text Newsletters 00:00 Your Client Video Testimonials Will Prove Your Credibility Beyond a Doubt 00:00 Facebook Live Will Never Scare You Again 00:00 Project Your Best Face on Skype and Zoom 00:00 Deliver Keynote Speeches Without Ever Leaving Home 00:00 Supercharge Your Public Relations Efforts With Video 00:00 The Crisis Communications Secret Weapon 00:00 Drastically Reduce Your Time Training Employees and Others 00:00 Anything You Can Type You Can Now Speak on Video 00:00 Conclusion - You are Now Ready to Use Video Successfully In All Communications 00:00

Budget-Friendly Video Presentations Workshop
Delivered Online On Demand1 hour 3 minutes
£25

Nail and Bridal Makeup Artist

By Imperial Academy

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

Nail and Bridal Makeup Artist
Delivered Online On Demand
£150