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

42606 Learning courses in Cardiff delivered Online

Literacy and Numeracy Mastery for Adults

By Online Training Academy

Unleash your potential in the realm of literacy and numeracy mastery. Discover the art and science behind adult learning, delve into the intricacies of teaching and learning literacy, and unlock the secrets of imparting numeracy with finesse. Our comprehensive programme takes you on a journey through the fascinating landscapes of adult education, blending theory with practical insights. Elevate your teaching prowess and redefine your impact on learners with modules that explore inclusive learning, technology integration, and the nuances of policy and practice. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access Immerse yourself in an engaging learning adventure that goes beyond conventional approaches, equipping you with the knowledge and skills to navigate the diverse challenges of adult education. Join us in reshaping the educational landscape, where your passion meets purpose, and your expertise becomes a beacon for adult learners seeking the keys to literacy and numeracy mastery. Course Curriculum Module 1: Overview of Adult Literacy and Numeracy Module 2: Understanding Adult Learning Theories Module 3: Teaching and Learning Literacy Module 4: Teaching and Learning Literacy Writing, Speaking and Listening Module 5: Planning and Assessment Literacy Module 6: Learning Numeracy Module 7: Learning Numeracy Percentage, Statistical Functions and Probabilities Module 8: Teaching Numeracy Module 9: Technology in Learning Module 10: Adult Learning Difficulties Module 11: Inclusive Learning Module 12: Policy and Practice Learning Outcomes: Grasp adult learning theories for effective teaching strategies. Hone literacy teaching skills in writing, speaking, and listening. Demonstrate proficiency in planning and assessing literacy education. Acquire a solid foundation in numeracy, including statistical functions. Develop advanced teaching techniques for imparting numeracy concepts. Cultivate inclusive practices and align teaching with educational policies. CPD 10 CPD hours / points Accredited by CPD Quality Standards Literacy and Numeracy Mastery for Adults 3:00:58 1: Module 1: Overview of Adult Literacy and Numeracy 17:41 2: Module 2: Understanding Adult Learning Theories 16:05 3: Module 3: Teaching and Learning Literacy 16:25 4: Module 4: Teaching and Learning Literacy Writing, Speaking and Listening 09:44 5: Module 5: Planning and Assessment Literacy 12:59 6: Module 6: Learning Numeracy 17:51 7: Module 7: Learning Numeracy Percentage, Statistical Functions and Probabilities 14:50 8: Module 8 Teaching Numeracy 15:42 9: Module 9: Technology in Learning 13:21 10: Module 10: Adult Learning Difficulties 15:42 11: Module 11: Inclusive Learning 17:14 12: Module 12: Policy and Practice 12:24 13: CPD Certificate - Free 01:00 Who is this course for? Educators seeking advanced adult teaching expertise. Literacy and numeracy enthusiasts passionate about adult education. Professionals eager to enhance their teaching impact. Individuals committed to fostering inclusive learning environments. Aspiring educators ready to embrace the challenges of adult education. Career path Adult Education Coordinator Literacy Outreach Specialist Numeracy Instructor Inclusive Learning Advocate Educational Policy Analyst Technology Integration Facilitator Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Literacy and Numeracy Mastery for Adults
Delivered Online On Demand3 hours
£12

Report Writing When Your Child is in Burnout

By LivePlayLearn

Reporting to the LA when your child is in burnout

Report Writing When Your Child is in Burnout
Delivered Online On Demand1 hour
£25

Reflective Culture Practice: Part 2

By iStudy UK

Course Description Get instant knowledge from this bite-sized Reflective Culture Practice: Part 2 course. This course is very short and you can complete it within a very short time. In this Reflective Culture Practice: Part 2 course you will get fundamental ideas of reflective practice, the key understanding of setting reflection in practice and so on. Enrol in this course today and start your instant first step towards learning about reflective tools. Learn faster for instant implementation. Learning outcome  Understand the reflective tools Gain in-depth knowledge of the misconceptions about reflective practice from teacher and student perspective Deepen your understanding of setting reflection in practice Requirement Our Reflective Culture Practice: Part 2 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Reflective Culture Practice: Part 2 Module 01: Reflective Tools (Part 1) 00:50:00 Module 02: Reflective Tools (Part 2) 00:36:00 Module 03: Setting Reflection in Practice 00:22:00 Module 04: Misconceptions about Reflective Practice from Teacher and Student Perspective 00:16:00 Assignment Assignment - Reflective Culture Practice: Part 2 00:00:00

Reflective Culture Practice: Part 2
Delivered Online On Demand2 hours 4 minutes
£25

Business Improvement

4.7(47)

By Academy for Health and Fitness

Learn to reach your full potential by taking our Business Improvement and leap up the career ladder of your choice You can become quickly skilled in the field by enrolling in this bestselling course and stand proudly above applicants and candidates as you impress your future employer. Business Improvement has been especially designed by industry experts and specialists to rapidly coach learners just like you and help you succeed in your ambitions. We are committed to support you all the way and our dedicated staff will be available 24/7 to answer any queries or resolve technical problems. The learning modules are small but intensive and crafted to help you gain the maximum knowledge in the minimum time. Business Improvement will also give you approved accreditation from CPD and allow you to study anywhere and at any time. We work to your requirements, not the other way round. Let us help you by accepting our gift of learning with Business Improvementand a high-flying job in a relevant field could soon be yours. Why People love Business Improvement From Academy for Health & Fitness: Opportunity to boost your CV/Resume with CPD accredited proficiency Student ID card with amazing discounts - completely for FREE! (Postal charges will be applicable for international delivery) Instant results upon completion of each assessment Certificates available in both PDF and hard copy format Interactive, high-quality course content with 24/7 online access Full tutor support and learning assistance included Course Curriculum Here are the topics you will cover on the Course: ***Business Improvement*** Module 01: Business Development and Succession Planning Module 02: Process Management Module 03: Supply Chain Management Module 04: Planning & Forecasting Operations Module 05: Procurement & Purchasing Management Module 06: Project Management Module 07: Retail Pricing Module 08: Business Analysis Planning and Monitoring Module 09: Strategic Analysis and Product Scope Module 10: Quality Management Module 11: Management Skills for Leading Your Team Module 12: Selling in Multiple Channels Module 13: Representing Your Boss and Company Module 14: Preparing for Brainstorming Module 15: Generating Solutions (I) Module 16: Generating Solutions (II) Module 17: Analyzing Solutions Module 18: Selecting a Solution Module 19: Negotiation Techniques Module 20: Communication Skills Module 21: Skills of an Effective Administrator Module 22: What is Marketing? Module 23: Common Marketing Types (I) Module 24: Common Marketing Types (II) Module 25: Conflict Management Module 26: Talent Management Module 28: Managing Risk and Recovery Module 27: Time Management Module 29: Business Etiquette Assessment Process Once you have finished the learning stages in the course, your abilities will be assessed by an automated multiple-choice question session, after which you will receive the results immediately. CPD 15 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Business Improvement has been professionally-designed for motivated learners who are looking to add a new skill to their CV and stand head and shoulders above the competition. Learn the latest industry-specific information with the Business Improvement. Enrol on the course and learn a new professional skill from anywhere, at any time! Requirements Enrol on the course with no formal entry requirements! If you have a passion for knowledge and want to learn something new, register on theBusiness Improvement without any delay. We only ask that all students have a passion for learning and literacy, and be over the age of 16. Complete the Business Improvement online from your computer, tablet, or smartphone, and learn in a way that suits you. Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Business Improvement
Delivered Online On Demand11 hours
£12

Level 2 Certificate in Self Development

4.3(43)

By John Academy

Description: The reality is there's continually some little way you can enhance for yourself and other individuals. No matter how experienced you think you are, there will still be unending little things you can do to improve a move to make yourself improve. You have to find the indicators that will tell you that you are actually moving forward and that you have developed in every aspect of your life. In this course, you will be able to become empowered to develop yourself and putting yourself out there to improve to its maximum potential. You will be able to do self-development through visualization and affirmation in this course by picturing yourself in the scene that has helped many individuals throughout the years develop a positive personality. Through perception, one can go any place rationally and utilize the implementers by affirming what they need from life, to arrive. Utilizing the perception and affirmatives provided in this course, you can advance toward a positive future while building up your internal identity. Self-advancement begins in the womb and conveys forward over the span of one's life. All through this stage, one learns, while picking up information from encounters and occasions seen by the eye. Who is the course for? Professionals, Trainers, and Individuals who want to be expert in positive self-development. Anyone who wants to know to manage their life and self-development. 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 hard copy 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 recognized 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: Level 2 Certificate in Self Development will be useful and would be beneficial for every kind of occupations and careers like: Employees General Managers Management Directors Top Executives And Much More. Development of the Self Self Development through Visualization and Affirmation 01:00:00 Hints in Affirmation and Visualization 01:00:00 Development for Affirmation and Visualization 00:45:00 How to Build Critical Thinking Skills 01:00:00 Visualizing Problems with Affirmations 00:30:00 Development Evaluation in Affirmation and Visualization 00:30:00 Practice Development through Visualization and Affirmation 01:00:00 Self-Development Procedures through Visualization 01:00:00 Development thru Visualization of Problems in Affirmation 01:00:00 Process of Affirmation through Development Visualization 01:00:00 Sense of Development thru Affirmation and Visualization 01:00:00 Natural Development thru Affirmation and Visualization 01:00:00 Visualization through Development Affirmation 01:00:00 Choices in Development thru Affirmation and Visualization 01:00:00 Development thru Argument Affirmation and Visualization 01:00:00 Visualization in Development of Affirmation 01:00:00 Revolutionary Development thru Visualization and Affirmation 00:30:00 Focus for Development thru Visualization and Affirmation 01:00:00 Visualization Music thru Affirmation Development 01:30:00 Energy Development thru Visualization and Affirmation 01:00:00 Relax with Development thru Affirmative Visualization 01:00:00 New Age Development in Affirmative Visualization 01:00:00 Conclusion 00:15:00 Development of Self Esteem INTRODUCTION 01:00:00 LOW SELF-ESTEEM? Why It Occurs? 01:00:00 YOUR LACK OF SELF-ESTEEM 01:00:00 SELF ESTEEM - GETTING TO THE Root OF THE ISSUE 01:00:00 SELF-ESTEEM AND THE INNER VOICE 01:00:00 YOU GET WHAT YOU PROJECT 01:00:00 SELF-ESTEEM BUILDING EXERCISES 01:00:00 WHERE, WHEN AND HOW TO BUILD SELF-ESTEEM 01:00:00 CONCLUSION 00:30:00 Being Assertive Module One - Getting Started 01:00:00 Module Two - What Does Self-Confidence Mean To You 01:00:00 Module Three - Obstacles to Our Goals 01:00:00 Module Four - Communication Skills 01:00:00 Module Five - The Importance of Goal Setting 01:00:00 Module Six - Feeling the Part 01:00:00 Module Seven - Looking the Part 01:00:00 Module Eight - Sounding the Part 01:00:00 Module Nine - Powerful Presentations 00:30:00 Module Ten - Coping Techniques 01:00:00 Module Eleven - Dealing with Difficult Behavior 00:30:00 Module Twelve - Wrapping Up 00:15:00 Mock Exam Mock Exam- Level 2 Certificate in Self Development 00:20:00 Final Exam Final Exam- Level 2 Certificate in Self Development 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Level 2 Certificate in Self Development
Delivered Online On Demand40 hours
£18

Architecting on AWS

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This course is intended for solutions architects, solution-design engineers, developers seeking an understanding of AWS architecting and individuals seeking the AWS Solutions Architect-Associate certification. Overview Identify AWS architecting basic practices. Explore using the AWS management tools: The AWS Console, Command Line Interface (CLI), and CloudFormation in a lab environment. Examine the enforcement of accounts security using policies. Identify the elements that build an elastic, secure, virtual network that includes private and public subnets. Practice building an AWS core networking infrastructure. Determine strategies for a layered security approach to Virtual Private Cloud (VPC) subnets. Identify strategies to select the appropriate compute resources based on business use-cases. Practice building a VPC and adding an Elastic Cloud Compute (EC2) instance in a lab environment. Practice installing an Amazon Relational Database Service (RDS) instance and an Application Load Balancer (ALB) in the VPC you created. Compare and contrast AWS storage products and services, based on business scenarios. Compare and contrast the different types of AWS database services based on business needs. Practice building a highly available, auto-scaling database layer in a lab. Explore the business value of AWS monitoring solutions. Identify the role of monitoring, event driven load balancing, and auto scaling responses, based on usage and needs. Identify and discuss AWS automation tools that will help you build, maintain and evolve your infrastructure. Discuss network peering, VPC endpoints, gateway and routing solutions based on use-cases. Discuss hybrid networking configurations to extend and secure your infrastructure. Discuss the benefits of microservices as an effective decoupling strategy to power highly available applications at scale. Explore AWS container services for the rapid implementation of an infrastructure-agnostic, portable application environment. Identify the business and security benefits of AWS serverless services based on business examples. Practice building a serverless infrastructure in a lab environment. Discuss the ways in which AWS edge services address latency and security. Practice building a CloudFront deployment with an S3 backend in a lab environment. Explore AWS backup, recovery solutions, and best practices to ensure resiliency and business continuity. Build a highly available and secure cloud architecture based on a business problem, in a project-based facilitator-guided lab. Architecting on AWS is for solutions architects, solution-design engineers, and developers seeking an understanding of AWS architecting. In this course, you will learn to identify services and features to build resilient, secure and highly available IT solutions on the AWS Cloud. Architectural solutions differ depending on industry, types of applications, and business size. AWS Authorized Instructors emphasize best practices using the AWS Well-Architected Framework, and guide you through the process of designing optimal IT solutions, based on real-life scenarios. The modules focus on account security, networking, compute, storage, databases, monitoring, automation, containers, serverless architecture, edge services, and backup and recovery. At the end of the course, you will practice building a solution and apply what you have learned with confidence. Prerequisites AWS Cloud Practitioner Essentials classroom or digital training, or Working knowledge of distributed systems Familiarity with general networking concepts Familiarity with IP addressing Working knowledge of multi-tier architectures Familiarity with cloud computing concepts 0 - Introductions & Course Map review Welcome and course outcomes 1 - Architecting Fundamentals Review AWS Services and Infrastructure Infrastructure Models AWS API Tools Securing your infrastructure The Well-Architected Framework Hands-on lab: Explore Using the AWS API Tools to Deploy an EC2 Instance 2 - Account Security Security Principals Identity and Resource-Based Policies Account Federation Introduction to Managing Multiple Accounts 3 - Networking, Part 1 IP Addressing Amazon Virtual Private Cloud (VPC), Patterns and Quotas Routing Internet Access Network Access Control Lists (NACLs) Security Groups 4 - Compute Amazon Elastic Cloud Compute (EC2) EC2 Instances and Instance Selection High Performance Computing on AWS Lambda and EC2, When to Use Which Hands-On Lab: Build Your Amazon VPC Infrastructure 5 - Storage Amazon S3, Security, Versioning and Storage Classes Shared File Systems Data Migration Tools 6 - Database Services AWS Database Solutions Amazon Relational Database Services (RDS) DynamoDB, Features and Use Cases Redshift, Features, Use Cases and Comparison with RDS Caching and Migrating Data Hands-on Lab: Create a Database Layer in Your Amazon VPC Infrastructure 7 - Monitoring and Scaling Monitoring: CloudWatch, CloudTrail, and VPC Flow Logs Invoking Events 8 - Automation CloudFormation AWS Systems Manager 9 - Containers Microservices Monitoring Microservices with X-Ray Containers 10 - Networking Part 2 VPC Peering & Endpoints Transit Gateway Hybrid Networking Route 53 11 - Serverless Architecture Amazon API Gateway Amazon SQS, Amazon SNS Amazon Kinesis Data Streams & Kinesis Firehose Step Functions Hands-on Lab: Build a Serverless Architecture 12 - Edge Services Edge Fundamentals Amazon CloudFront AWS Global Accelerator AWS Web Application Firewall (WAF), DDoS and Firewall Manager AWS Outposts Hands-On Lab: Configure an Amazon CloudFront Distribution with an Amazon S3 Origin 13 - Backup and Recovery Planning for Disaster Recovery AWS Backup Recovery Strategie Additional course details: Nexus Humans Architecting on AWS 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 Architecting on AWS 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.

Architecting on AWS
Delivered OnlineFlexible Dates
£2,025

DevOps Essentials Training

4.8(9)

By Skill Up

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

DevOps Essentials Training
Delivered Online On Demand1 hour 56 minutes
£25

Growth Mindset Course

5.0(1)

By Course Gate

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Growth Mindset course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Growth Mindset course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Growth Mindset and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Please note: Our Growth Mindset course only gives you the theoretical knowledge to excel in this field. This course doesn't entitle you to practise as a professional in this specific field. Learning Objectives Learn the fundamental skills you require to be an expertExplore different techniques used by professionalsFind out the relevant job skills & knowledge to excel in this professionGet a clear understanding of the job market and current demandUpdate your skills and fill any knowledge gap to compete in the relevant industryCPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Growth Mindset course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Growth Mindset course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path The Growth Mindset will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Section 01: Introduction & First Concepts Introduction 00:02:00 Awareness and Planning Is Key 00:06:00 Section 02: Investing In Yourself Investing Is Your Physical Health 00:06:00 Investing Is Your Mental Health 00:08:00 Section 03: Attitudes for Success Letting Go of Negativity 00:09:00 Adopting the Attitude of a Winner 00:09:00 Build People Up - Not Down 00:02:00 Embracing Positivity 00:04:00 Section 04: Personal Growth Strategies Being Yourself 00:03:00 Finding Your Place and Purpose 00:03:00 Dedicating Time to What Matter Most 00:05:00 Section 05: Final Thoughts & Ideas Final Thoughts & Ideas 00:04:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Growth Mindset Course
Delivered Online On Demand1 hour 1 minutes
£11.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

Growth is a Thinking Game

By IIL Europe Ltd

Growth is a Thinking Game As we learn from the times and think forward, there are a lot of actions we can take to ready ourselves, our businesses, and our customers for growth. The great reset isn't a new normal. It's a shift in our mindset that pushes us to pause and reflect on the past, respond to the present, and rethink the future. What can we control? Our attitude. Our actions. What can we do together to get back to growth? Energize our teams. Set a clear direction. Get closer to our customers. In this fresh perspective keynote, Tiffani shares what it takes to stay relevant and build a bias for existing customers to enable continued growth together - and make smarter business decisions now and in the future. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Growth is a Thinking Game
Delivered Online On Demand30 minutes
£15