5017 Courses

Master the Formulas For Entrepreneurial Success Course Overview This course offers a comprehensive guide to mastering the essential strategies for entrepreneurial and business success. Learners will explore fifteen proven approaches that cover financial understanding, leadership development, competitive advantage creation, and effective execution. The course emphasises the importance of value-based pricing, recurring revenue streams, and strategic partnerships, while also addressing company culture, talent retention, and marketing excellence. By engaging with this course, learners will gain clarity on how to synchronise key business initiatives to drive sustainable growth. It is designed to empower aspiring entrepreneurs and established professionals alike with actionable insights that foster confident decision-making and strategic business growth. Upon completion, learners will be equipped to navigate complex business environments and implement effective strategies that align with their goals. Course Description This detailed course delves into the core strategies that underpin entrepreneurial success, covering a wide array of business fundamentals and leadership principles. Participants will engage with topics such as financial literacy, problem-solving, competitive positioning, and the development of a unique value proposition. The curriculum highlights critical aspects including building recurring revenue, value-based pricing, marketing and sales leadership, and strategic alliances. It further addresses the importance of talent attraction and retention, organisational culture, and managing priority initiatives effectively. The learning experience is designed to enhance strategic thinking and business acumen, preparing learners to lead with confidence and vision. By the end of the course, participants will have gained a robust framework to build, scale, and sustain a successful business enterprise in a competitive marketplace. Master the Formulas For Entrepreneurial Success Curriculum Module 01: Introduction – 15 Strategies for Entrepreneurial & Business Success Module 02: Strategy #1 – Know Your Numbers Module 03: Strategy #2 – Know the Problem You Are Trying to Solve Module 04: Strategy #3 – Become a Leader in Your Industry Module 05: Strategy #4 – Have a Clear and Distinct Unique Competitive Advantage Module 06: Strategy #5 – Execution is Everything Module 07: Strategy #6 – Always Be Investing and Building Assets Module 08: Strategy #7 – Build Reoccurring Revenue Module 09: Strategy #8 – Price Based on Value Delivered Module 10: Strategy #9 – Build a Cohesive Messaging Strategy Module 11: Strategy #10 – Be a Sales and Marketing Driven Company Module 12: Strategy #11 – Leverage Partners to Build Your Business Module 13: Strategy #12 – Become a Thought Leader In Your Industry Module 14: Strategy #13 – Attract and Retain Your Top Talent Module 15: Strategy #14 – Build an Incredible Culture Module 16: Strategy #15 – Manage your Top 5 Key Initiatives Module 17: Bonus Strategy #1 – Create a Compelling Event Module 18: Bonus Strategy #2 – Stairstep Your Investment Module 19: Bonus Strategy #3 – Make All Strategies Sync Up (See full curriculum) Who Is This Course For? Individuals seeking to launch or grow their own business ventures. Professionals aiming to develop strategic leadership and business management skills. Beginners with an interest in entrepreneurship and business strategy. Business owners wanting to refine their competitive advantage and growth tactics. Career Path Entrepreneur / Business Owner Business Development Manager Strategic Planner or Consultant Marketing and Sales Manager Leadership and Team Development Specialist

Introduction to Project Management (Virtual) This course provides practical insights into what is project management and how it is performed in a structured manner.You will learn how projects are selected, initiated, planned, executed, monitored and control, as well as closed, which could serve you ubiquitously. The goal of this course is to provide a minimally essential orientation to practical project management concepts, tools, and techniques. You will be provided with enough of these that can be applied from both a project manager and a key stakeholder perspective. Getting Started Introductions Course orientation Participants' expectations Foundation Concepts Key terms and concepts Organizational framework Leadership framework Originating and Initiating Originating projects Initiating projects Planning Planning overview Scope and quality planning Resources and risk planning Schedule and cost planning Project baselining Executing and Controlling Executing Monitoring and Controlling Closing Project closing overview Closing administratively Closing financially

Risk Management for IT Projects: Virtual In-House Training IT projects may have direct bottom-line impact on the organization, cost millions of dollars, cause organizational change and change the way the organization is perceived by clients. Many IT projects are notoriously hard to predict and are filled with risk. IT Risk Management takes a comprehensive look at IT project risk management using PMI's PMBOK® Guide Risk Management Model in the context of IT Project Life Cycle phases. The goal of this course is to arm the practitioner with a rigorous, common-sense approach to addressing uncertainty in projects. This approach includes the ability to influence project outcomes, avoid many potential project risks, and be ready to calmly and efficiently respond to unavoidable challenges. What you will Learn You'll learn how to: Describe the risk management process, using the PMBOK® Guide's standard models and terminology Discuss the potential barriers to managing risk effectively in IT project organizations Develop an effective risk management plan for IT projects Identify project risks using IT-specific, practical tools Analyze individual risk events and overall project risk using IT-specific, practical approaches Plan effective responses to IT-specific risk based on the results of risk analysis and integrate risk responses into project schedules and cost estimates Manage and control risk throughout the IT project life cycle Implement selected elements of IT project risk management on your next project Foundation Concepts Basic concepts and purpose Risk and project constraints Risk and corporate cultures Risk management and IT PLC standards Plan Risk Management for IT Projects Plan Risk management process Plan Risk management activities Design a standard template Assess the project-specific needs Tailor the template Produce a project-specific risk management plan Gain consensus and submit as part of overall project plan A risk management plan of IT projects Identify Risks for IT Projects Identify risk process overview Risk categories and examples Risk identification tools Risk events by project life-cycle phases Perform Risk Analysis for IT Projects Perform qualitative risk analysis overview Core qualitative tools for IT projects Auxiliary qualitative tools for cost and schedule estimates When to use quantitative analysis for IT projects Plan Risk Response for IT Projects Plan risk response overview Active risk response strategies for IT projects (Threat and Opportunity) Acceptance and contingency reserves Contingency planning for IT projects Plan risk responses for IT projects Implement Risk Response for IT Projects Implement Risk Responses Executing Risk Response Plans Techniques and Tools Used Continuous Risk Management Monitor Risks for IT Projects Monitor risks overview Monitor risks tips for IT projects Technical performance measurement systems Risk management implementation for IT projects

Come and join us to learn this beautiful meditative technique and let your mind and body relax with your hands engaged in this amazing creative and mindful activity. Weaving is a technique that has existed for thousands of years, present in every culture across the globe. You can weave with various materials and we will be using only upcycled wool and other textile pieces. You are also more than welcome to bring your own fabric scraps or wool and incorporate them it into your project. During the 3 hours workshop, you will learn how to set up a basic weaving loom, see some examples, and discuss various possibilities how they could be incorporated into clothing and fashion projects. This workshop will familiarise you with basic weaving techniques. We will cover how to prepare a loom, the plain weave and the soumak stitch. You should be able to complete a small wall hanging about size A6 (4,1x5,8 inches) or a bookmark if you are a complete beginner. This workshop is led by Anna Baran, a trauma informed designer, artist, and maker based in the north of Edinburgh. She has always drawn inspiration from the sea, with her walks to local beaches, particularly Wardie Bay during the lockdown, becoming not only a source of new ideas for her artistic practice but also a way to gather materials such as driftwood, pieces of plastic ropes, and seashells. Anna has consistently sought to incorporate upcycled materials into her art, using her work to raise environmental awareness and promote art as an accessible medium for self-expression, regardless of financial circumstances. In addition to participating in various art exhibitions and fashion-related events, she has delivered a wide range of art and craft workshops to diverse communities across Edinburgh. This FREE workshop is for Adults women only and is sponsored by CORRA and HENRY DUNCAN GRANTS By attending this class you release Anna Baran, Giada Gaslini and Art and Spirituality Cic, from any liability arising out of any personal injuries, emotional or physical release, death, physical reaction, expectations of results, theft in the venue or damages that may happen to people and objects while attending. Pictures will be taken during the workshop, if you prefer not to be in them, please inform the teacher.

Overview Learn in detail about Exotic Options – Taxonomy, Barriers, and Baskets Who the course is for Fixed Income sales, traders, portfolio managers Bank Treasury Insurance Pension Fund ALM employees Central Bank and Government Funding managers Risk managers Auditors Accountants Course Content To learn more about the day by day course content please click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Entrepreneurs Business Planning 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 Entrepreneurs Business Planning 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 Entrepreneurs Business Planning 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. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD 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 Entrepreneurs Business Planning 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 Entrepreneurs Business Planning 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 Entrepreneurs Business Planning 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 Introduction to Business Plan for Entrepreneurs Business Plan for Entrepreneurs Achieve Your Short & Long Term Goals preview 00:04:00 Module 01: Things to Consider Before Starting a Business Plan Things to Consider Before Starting a Business Plan 00:04:00 Lesson 01 Identify Your Skills 00:04:00 Lesson 02 Audit the Market Demand of Your Idem 00:04:00 Lesson 03 Check for Availability of Resources 00:04:00 Lesson 04 Work on a Financial Plan 00:03:00 Lesson 05 Be Ready to Face Failure 00:03:00 Module 02: The Elements of a Business Plan The Elements of a Business Plan 00:03:00 Lesson 01 Mission Statement (Company Overview) 00:04:00 Lesson 02 Marketplace Opportunity 00:05:00 Lesson 03 Product/Service Information 00:04:00 Lesson 04 Sales/Market Plan 00:04:00 Lesson 05 Financials 00:04:00 Module 03: Who Are You Writing the Business Plan For Who Are You Writing the Business Plan For 00:04:00 Lesson 01 You Want to Start a Business 00:03:00 Lesson 02 You Own an Established Firm and are Seeking Help 00:04:00 Lesson 03 You Need to Determine Your Objectives 00:04:00 Lesson 04 You're Trying to Predict the Future 00:04:00 Lesson 05 You Want to Use it to Raise Money 00:03:00 Module 04: The Purpose of a Business Plan The Purpose of a Business Plan 00:03:00 Lesson 01 Provide a Road Map 00:04:00 Lesson 02 Understand What to Focus On 00:04:00 Lesson 03 Raise finance 00:04:00 Lesson 04 Manage your Business Effectively 00:04:00 Lesson 05 Enlightening Executive Talent 00:04:00 Module 05: How a Business Plan Can Help with Long Term Success How a Business Plan Can Help with Long Term Success 00:04:00 Lesson 01 A Business Plan Is Simply a Must-Have for Some Businesses 00:05:00 Lesson 02 A Business Plan Helps You Make Decisions 00:03:00 Lesson 03 A Business Plan Can Be a Reality Check 00:05:00 Lesson 04 A Business Plan Can Give You New Ideas 00:05:00 Lesson 05 A Business Plan Creates an Action Plan 00:03:00 Module 06: Reasons You Need a Business Plan Reasons You Need a Business Plan 00:04:00 Lesson 01 Gain a Deep Understanding of Your Market 00:03:00 Lesson 02 Hold Yourself Accountable 00:04:00 Lesson 03 Know Your Message 00:05:00 Lesson 04 Confirm the Math 00:06:00 Lesson 05 Iron Out Possible Kinks 00:04:00 Module 07: Conclusion Review 00:03:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Are you looking for a way to manage your projects more efficiently and effectively? Do you want to learn how to use Microsoft Project, one of the most popular and powerful project management tools in the world? If so, this online course is for you! In this course, you will learn how to create, update, and share project plans using Microsoft Project. You will also learn how to use the social media features of Microsoft Project to collaborate with your team members, stakeholders, and clients. You will discover how to: - Set up a project and enter tasks, durations, dependencies, and resources - Track the progress and performance of your project using various views and reports - Adjust your project plan to deal with changes, risks, and issues - Export your project data to Excel, PowerPoint, or Word This course is suitable for anyone who wants to learn how to use Microsoft Project for project management, whether you are a beginner or an intermediate user. You will need access to a computer with Microsoft Project installed (any version from 2013 to 2021) and an internet connection. You will also need a Microsoft account to use the social media features of Microsoft Project. By the end of this course, you will be able to create and manage project plans using Microsoft Project and leverage the power of social media to enhance your project communication and collaboration. Enrol today and take your project management skills to the next level!

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Career Development Masterclass: Become a Copywriter 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 Career Development Masterclass: Become a Copywriter 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 Career Development Masterclass: Become a Copywriter 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. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD 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 Career Development Masterclass: Become a Copywriter 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 Career Development Masterclass: Become a Copywriter. 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 £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Career Development Masterclass: Become a Copywriter 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: What Niche Best Fits Your Interests Lesson 01: How to Find Your Niche 00:04:00 Lesson 02: How to Find a Niche Market: A Step-By-Step Guide 00:04:00 Lesson 03: The Advantages of Having a Niche Market 00:04:00 Lesson 04: 5 Ways to Research Your Potential Customers 00:03:00 Lesson 05: 5 Simple Steps To Find Your Niche Market 00:04:00 Lesson 06: Ways to Narrow Down Your Niche Market 00:03:00 Section 02: Ways to Hone Your Skills as A Copywriter Lesson 01: 10 Reasons Why People Who Read A Lot Are More Likely To Be Successful 00:04:00 Lesson 02: The Importance of Written Communication Skills 00:04:00 Lesson 03: 5 Reasons why Feedback may be the Most Important 00:04:00 Lesson 04: What Copywriting Certification Programs Can Teach You 00:04:00 Lesson 05: 8 Online Tools That Will Improve Your Writing 00:03:00 Lesson 06: Why Should You Network? 00:04:00 Lesson 07: Why New Writers Should Enter Writing Competitions 00:03:00 Section 03: Communicating with Your Prospect Lesson 01: How To Get The Most Out Of Customer Polls And Surveys 00:04:00 Lesson 02: How to Identify a Target Demographic 00:04:00 Lesson 03: Learn Your Customers Habits 00:03:00 Lesson 04: 11 Ways to Provide Great Customer Service 00:03:00 Lesson 05: Your Small Business Competitors: Where to Learn About Their Customers 00:04:00 Section 04: Expanding Your Business Lesson 01: The Easiest Way to Build Your Business Through Referrals 00:04:00 Lesson 02: What is a Paid Online Advertising Strategy? 00:03:00 Lesson 03: What Is a Portfolio Website and Why You Need It? 00:04:00 Lesson 04: Copywriting for Social Media: 7 Tips to Boost Engagement 00:03:00 Lesson 05: 5 Rules for Customer-Centric Copywriting Your Support Reps Should Use 00:03:00 Section 05: Niches that Copywriters Work In Lesson 01: Break into the Self-Improvement Market 00:04:00 Lesson 02: Fundraising - Selling Your Services to Non-Profit Companies 00:04:00 Lesson 03: Health Copywriting- Working to Improve People's Lives 00:06:00 Lesson 04: Financial Services 00:04:00 Lesson 05: Christian Market - Writing for a Higher Purpose 00:04:00 Section 06: Why Become a Freelance Copywriter Lesson 01: Choose Your Own Working Hours 00:05:00 Lesson 02: The Newbie's Guide to Making the Most of Remote Work 00:04:00 Lesson 03: Copywriter Job Satisfaction: Why Copywriting is a Good Career 00:03:00 Lesson 04: Why Copywriting Helps your Business and Adds Value to your Marketing Assets 00:04:00 Lesson 05: Potential to Earn Higher than Average Income 00:03:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Project Risk Management: Virtual In-House Training Have you been surprised by unplanned events during your projects? Are you and your project team frequently fighting fires? Well, you are not alone. Uncertainty exists in any project environment. While it's impossible to predict project outcomes with 100% certainty, you can influence the outcome, avoid potential risks, and be ready to respond to challenges that arise. In this course, you'll gain the proper knowledge needed to identify, assess, plan for, and monitor risk in your projects. You'll learn how to set up and implement risk management processes, helping you to minimize uncertainty and achieve more consistent, predictable outcomes as a result. What You Will Learn You'll learn how to: Demonstrate to others how the risk management processes in A Guide to the Project Management Body of Knowledge (PMBOK® Guide) apply to your project's environment, especially for high-risk projects Adapt these processes for a particular high-risk project team's operating principles Explain the importance of using risk management best practices at single and enterprise project levels Lead an initiative to implement risk management best practices in your project environment Foundation Concepts Risk-related definitions The risk management process High-risk projects and project failures Classical failures in implementing risk management Plan Risk Management Project risk management and governance Risk management planning for high-risk projects High-risk variations on a risk management plan Identify Risk Adapting the risk identification process for high-risk projects Recognizing risks spontaneously Confirming and structuring risk events for treatment Wrapping up risk identification for high-risk projects Perform Qualitative Risk Analysis Adapting qualitative risk analysis for high-risk projects Accelerating risk analysis Clearing risk action Wrapping up qualitative risk analysis for the next level Perform Quantitative Risk Analysis Adapting quantitative risk analysis for high-risk projects Ensuring effective risk analyses with data quality assessments Building a foundation for quantitative risk analysis Using discrete quantitative tools Using continuous quantitative tools Wrapping up quantitative risk analysis for high-risk projects Plan Risk Responses Adapting risk response planning for high-risk projects Optimizing active risk response strategies Leveraging contingencies for high project performance Wrapping up risk response planning for high-risk projects Implement Risk Responses Implementing Risk Responses Process Executing Risk Response Plans Tools and Techniques Best Practices Continuous Risk Management Monitor Risks Adapting risk monitoring for high-risk projects Optimizing risk plan maintenance Weaving risk reassessment into the project's progress Maintaining a continuous 'vigil' in high-risk project environments

Duration 3 Days 18 CPD hours This course is intended for This is an introductory level SQL course, appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators. Overview Working in a hands on learning environment led by our expert practitioner, attendees will explore: Basic RDBMS Principles The SQL Language and Tools Using SQL Developer SQL Query Basics WHERE and ORDER BY Functions ANSI 92 Joins ANSI 99 Joins Subqueries Regular Expressions Analytics A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. A full presentation of the basics of relational databases and their use are also covered. Basic RDBMS Principles Relational design principles Accessing data through a structured query language Entity relationship diagrams Data Domains Null values Indexes Views Denormalization Data Model Review The SQL Language and Tools Using SQL*Plus Why Use SQL*Plus When Other Tools Are Available? Starting SQL*Plus EZConnect SQL Commands PL/SQL Commands SQL*Plus Commands The COLUMN Command The HEADING Clause The FORMAT Clause The NOPRINT Clause The NULL Clause The CLEAR Clause Predefined define variables LOGIN.SQL Command history Copy and paste in SQL*Plus Entering SQL commands Entering PL/SQL commands Entering SQL*Plus commands Default output from SQL*Plus Entering Queries What about PL/SQL? Using SQL Developer Choosing a SQL Developer version Configuring connections Creating A Basic Connection Creating A TNS Connection Connecting Configuring preferences Using SQL Developer The Columns Tab The Data Tab The Constraints Tab The Grants Tab The Statistics Tab Other Tabs Queries In SQL Developer Query Builder Accessing Objects Owned By Other Users The Actions Pulldown Menu Differences between SQL Developer and SQL*Plus Reporting Commands Missing In SQL Developer General Commands Missing In SQL Developer Data Dictionary report User Defined reports Using scripts in SQL Developer WHERE and ORDER BY WHERE clause basics Comparison operators Literals and Constants in SQL Simple pattern matching Logical operations The DUAL table Arithmetic operations Expressions in SQL Character operators Pseudo columns Order by clause basics Ordering Nulls Accent and case sensitive sorts Sampling data WHERE and ORDER BY in SQL Developer All, Any, Some Functions The basics of Oracle functions Number functions Character functions Date functions Conversion functions Other functions Large object functions Error functions The RR format mode; Leveraging your knowledge ANSI 92 JOINS Basics of ANSI 92 Joins Using Query Builder with multiple tables Table Aliases Outer joins Outer Joins In Query Builder Set operators Self-referential joins Non-Equijoins ANSI 99 Joins Changes with ANSI99 CROSS Join NATURAL Join JOIN USING JOIN ON LEFT / RIGHT OUTER JOIN FULL OUTER JOIN Subqueries Why use subqueries? WHERE clause subqueries FROM clause subqueries HAVING clause subqueries CORRELATED subqueries SCALAR subqueries DML and subqueries EXISTS subqueries Hierarchical queries TOP N AND BOTTOM N queries Creating subqueries using Query Builder Regular Expressions Available Regular Expressions Regular Expression Operators Character Classes Pattern matching options REGEX_LIKE REGEXP_SUBSTR REGEXP_INSTR REGEXP_REPLACE REGEXP_COUNT Analytics The WITH clause Reporting aggregate functions Analytical functions User-Defined bucket histograms The MODEL clause PIVOT and UNPIVOT Temporal validity More Analytics RANKING functions RANK DENSE_RANK CUME_DIST PERCENT_RANK ROW_NUMBER Windowing aggregate functions RATIO_TO_REPORT LAG / LEAD Linear Regression functions Inverse Percentile functions Hypothetical ranking functions Pattern Matching Additional course details: Nexus Humans Introduction to SQL Programming Basics (TTSQL002) 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 Introduction to SQL Programming Basics (TTSQL002) 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.