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

38735 Design courses

Adobe After Effects CC

4.7(160)

By Janets

Nowadays, Adobe After Effects CC broadly used in the post-production process of filmmaking and video production. In this Adobe After Effects CC course, you will equip yourself with multiple tools that empower you to improve your videos with expert motion graphics. Besides, you will learn powerful techniques to create the most detailed animations, implement animation effect, use graph editor, combine appealing backgrounds, colour creation, layouts and more. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99.00. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. Course Content Introduction 0. After Effects Promo Video FREE 00:02:00 1.1 Intro Video 00:03:00 1.2 Project Files - Adobe After Effects CC 2017 Complete Training 00:00:00 1.3 Animate Your Name 00:07:00 After Effects Basics 2.1 Understand the After Effects Workspace 00:06:00 2.2 Starting a New Composition 00:08:00 2.3 Adding Media to Your Project and Timeline 00:05:00 2.4 Using the Basic After Effects Tools 00:10:00 2.5 Create a Perfect Circle, Alignment, and Shape Colors 00:03:00 2.6 Working in the Timeline 00:11:00 2.7 Layer Properties 00:09:00 Animating with Keyframes 3.1 Animating in After Effects 00:08:00 3.2 Position, Scale, and Rotation Animations 00:05:00 3.3 Tips to Make Your Animations Look More Nautral 00:04:00 3.4 Using the Graph Editor 00:06:00 3.5 Challenge - Bouncing Ball 00:01:00 3.6 Solution - Bouncing Ball 00:20:00 Shapes and Solid Layers 4.1 Working With Solid Layers and the ken Burns Effects 00:07:00 4.2 Working With Shape Layers, Strokes, and Paths 00:06:00 4.3 Adding Layer Styles Like Drop Shadow, Bevel, and Gradients 00:04:00 4.4 Shape Effects - Trim Path Animation, Wiggle, and Zig Zag 00:06:00 Important After Effects Skills 5.1 Track Matte Animation - Make Layers Appear And Disappear 00:09:00 5.2 Using Pre-Compositions to Group Layers 00:06:00 5.3 Easily Reverse Complicated Animations 00:02:00 5.4 Playing with Time 00:06:00 5.5 Blend Modes 00:06:00 5.6 Stabilize Shaky Footage 00:04:00 Motion Graphics Projects 6.1 Intro to Motion Graphics Projects 00:01:00 6.2 Clean Lower Third 00:09:00 6.3 Logo Reveal Animation Bumper 00:13:00 6.4 Colorful Transition 00:17:00 6.5 Text with Mask Path Animation 00:10:00 6.6 Text Bubble Animation 00:14:00 6.7 Weather App 1 00:16:00 6.8 Weather App 2 00:08:00 6.9 Weather App 3 00:07:00 Flat Animation Challenge 7.1 Flat Animation Challenge 00:03:00 7.2 Phil Designs his Flat Animation Scene 00:13:00 7.3 Animating Fireworks with the Repeater Effect 00:15:00 Green Screen (Chromakeying) 8.1 Removing Green Screen Background 00:07:00 8.2 Adding a Background that Matches the Foreground 00:08:00 8.3 Adding Motion to a Still Image with the Puppet Tool 00:06:00 8.4 Adding Movement with the Ripple Effect 00:06:00 3D Animations and the Camera Tool 9.1 Intro to 3D 00:10:00 9.2 Swinging 3D Text Animation 00:12:00 9.3 Build Out Your 3D Composition 00:06:00 9.4 Animating Our 3D Scene 00:08:00 9.5 Create Stars in After Effects 00:05:00 Rotoscoping 10.1 Using the Rotoscope Tool 00:07:00 10.2 Cleaning Up Your Edges 00:07:00 10.3 Finishing Our Rotobrush Animation 00:08:00 Screen Replacements 11.1 Easy Screen Replacement with Masks 00:10:00 11.2 Replacing a Screen Version 2 00:00:00 11.3 Screen Replacement with Mocha 00:08:00 Puppet Tool Animations 12.1 Using the Puppet Pin Tool 00:05:00 12.2 Animating Your Puppet Pins 00:03:00 12.3 Animated Blinking Eyes 00:08:00 12.4 Adding Perspective with Animated Clouds 00:07:00 Effects & Presets 13.1 Applying Text Animation Presets 00:00:00 13.2 Create a page Turn Effect with CC page Turn 00:10:00 13.3 Radial and Linear wipes 00:03:00 13.4 Color Correction in After Effects 00:04:00 Motion Tracking 14.1 Motion Tracking Basics 00:10:00 14.2 Tracking Text and Visual Effects to Video Clip 00:06:00 14.3 Tracking Rotation and Scale 00:12:00 14.4 Adding Details to Our Text 00:04:00 Character Animations 15.1 Intro to Character Animation 00:02:00 15.2 Design Your Character 00:15:00 15.3 Rigging Your Character 00:03:00 15.4 animation Our Character 00:10:00 15.5 Adding the Animated Background 00:09:00 15.6 Adding Details to Character Movement 00:07:00 15.7 Adding the Paper Cut Out Look 00:06:00 Exporting From After Effects 16.1 Exporting an H264 File From After Effects 00:07:00 16.2 Exporting from After Effects with a Transparent Background 00:04:00 16.3 Exporting from After Effects through Adobe Media Encoder 00:05:00 16.4 Create an Animated GIF from After Effects 00:07:00 After Effects Workflow + Tips 17.1 Audio Tips for After Effects 00:03:00 17.2 Working with Premiere Pro 00:06:00 Expressions 18.1 Expressions Basics 00:07:00 18.2 Animate a Flickering with Expressions 00:18:00 Conclusion 19.1 Conclusion 00:01:00 Assignment Assignment - Adobe After Effects CC 2 weeks, 1 day Order Your Certificate Order your Certificate QLS 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Adobe After Effects CC
Delivered Online On Demand3 weeks
£25

Make your own Hiking Staff, Walking Stick or Foraging Crook

5.0(6)

By Natural Pathways Bushcraft

A fantastic opportunity to spend time in tranquil woodland in the heart of South East Kent making your own unique Hiking Staff, Walking Stick or Foraging Crook that you will value and use for a life time. You can choose to personalise your Staff with markings or carvings and could EVEN make your own Foraging Crook to use in the field on our Forage and Fire Course.  Sitting around a warm camp fire you will design and create your own personalised Staff/Stick with the guidance of an experienced instructor. During this one day practical event you WILL be... Given the tools and advice of how to make the most of your PERSONALISED design. Choose from various seasoned wood, Hazel, Ash or Maple. Decide on the length, the width and design for your UNIQUE Staff. Design and carve your own unique hiking staff Shown how to STRIP and SHAPE the seasoned wood correctly. Be given clear bushcraft instruction on SAFE knife and tool use. Provided with all the EQUIPMENT and materials needed, seasoned wood, tools, vanish and wax.  Carvings of your choice on your newly made Staff you may choose to add your own personal CARVING.  Given a choice of finishes for your Hiking Staff or Foraging Crook with either varnish or bees wax.  Choosing whether to add a rubber base to the bottom of your Staff. What's included in the price? Wood All tools and equipment Hot drinks Free parking Cancellation policy Medium - Cancellation and a full refund can be obtained up to 4 weeks before the course starts

Make your own Hiking Staff, Walking Stick or Foraging Crook
Delivered In-PersonFlexible Dates
£59

Writing and Managing Requirements Documents - Creating the Acceptable, Approvable Requirements Document: On-Demand

By IIL Europe Ltd

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?

Writing and Managing Requirements Documents - Creating the Acceptable, Approvable Requirements Document: On-Demand
Delivered Online On Demand7 hours
£850

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

Including Autistic Children in Mainstream School

By Inclusive Solutions

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

Including Autistic Children in Mainstream School
Delivered Online On Demand
£750

Makeup and Nail Artist - Double Endorsed Certificate

By Imperial Academy

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

Makeup and Nail Artist - Double Endorsed Certificate
Delivered Online On Demand
£159

Silver Etching Workshop Sunday 13th October 10-5pm

5.0(21)

By Workshop 925

This is a full day intensive workshop which will teach you the processes involved in photo etching, including preparing the metal for etching, transferring the designs onto the metal using press and peel (P&P) paper and how to use specific etching solutions to cut the designs into the metal. This course will allow you to broaden your design process so that you can add some intricate textures to your copper and silver jewellery designs. You will be provided with a set amount of materials including copper sheet to practice the process and a 4cm by 4cm piece of silver sheet to create a silver textured pendant during your session. WHEN: Sunday 13th October 10-5pm WHERE:  Workshop 925 based at The Mayford Centre, just outside of Woking and very close to Guildford. Unit F9 The Mayford Centre, Mayford Green Woking, Surrey  GU22 0PP TUTOR: Krista Thomson WHAT DOES THE DAY INVOLVE? This is a full day intensive workshop which will teach you the processes involved in photo etching, including preparing the metal for etching, transferring the designs onto the metal using press and peel (P&P) paper and how to use specific etching solutions to cut the designs into the metal. This course will allow you to broaden your design process so that you can add some intricate textures to your copper and silver jewellery designs. You will be provided with a set amount of materials including copper sheet to practice the process and a 4cm by 4cm piece of silver sheet to create a silver textured pendant during your session. If you would like to create additional designs, you are welcome to bring along your own additional flat silver sheet, it must be no thinner than 0.6mm. This is a great opportunity to stock pile some great patterned silver for us with future projects. On the day you will be provided with some patterns to etch, if you have a set pattern in mind, please send us the artwork in good time for your class. Designs must be black and white only and please note smaller patterns work better than larger ones. Please email it to us at hello@workshop925.com. Alternatively instruction on where to purchase P&P paper and how to print your own designs onto it will be sent out prior to your course date to those of you who wish to etch your own designs. You will be etching the majority of the day, however if you would like to create a finished design, we can accommodate this, you can do some etching in the morning and create a design in the afternoon. EXPERIENCE REQUIRED: None, all abilities are welcomed. This course is a great introduction to etching for those who have a vast experience in jewellery making but have not yet tried this technique as well as beginners looking to create beautiful textural pieces of jewellery. Our small classes mean we are able to provide each student with the support they require. CLASS SIZE: 6 WHAT IS INCLUDED? All tools and consumables are supplied Please bring refreshments as we are no longer able to provide them The cost of this course includes copper sheet to practice the technique and a 4cm by 4cm section of silver sheet. The price also includes a selection of patterns printed on P&P paper to use during your course.  WHAT TO BRING: For safety reasons, during each class, you are required to wear appropriate footwear, we request that no open toed shoes are worn within Workshop 925. Long hair should also be tied back when working with the equipment. You may also wish to bring a notebook. We have handouts for many demonstrations, but there are always many tips and tricks given verbally by the tutor, which some might like to keep note of. Please bring any PPE, snacks and drinks to each session. We regret we can’t offer tea and coffee at the moment due to Coronavirus. PAYMENT OPTIONS: You can pay via our website or in our workshop in person using our card machine. If you prefer to pay directly, you can email us on hello@workshop925.com and we can invoice you manually to arrange a bank transfer. For classes over £80, instalment options are also available. Please email us on hello@workshop925.com to arrange. Gift Voucher – if you have a voucher to redeem, please email us before booking on hello@workshop925.com Please check your dates carefully before booking a class as we are unable to offer refunds. See our Terms & Conditions for full details.

Silver Etching Workshop Sunday 13th October 10-5pm
Delivered In-PersonFlexible Dates
£150

Construction & Structural Drawing Like Pro- CPD Certified

4.7(47)

By Academy for Health and Fitness

***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.

Construction & Structural Drawing Like Pro- CPD Certified
Delivered Online On Demand6 days
£149

1 Day beginners Fused Glass Wall Panel - Vessels class

By The Silver Zebra Glass Studio

Fused glass courses & workshops in the heart of Cheshire. Create your own unique fused glass wall panels, they can be split into 2 panels or work on 2 vessels if you prefer.

1 Day beginners Fused Glass Wall Panel - Vessels class
Delivered In-PersonFlexible Dates
£145

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