6237 Courses

Here in this Sketchbook Workshop, we believe that art should be fun and accessible to everyone. That's why we have a wide variety of materials and techniques to choose from, so you can find your own style and approach. Our workshops are centered around your interests and needs, so whether you want to learn new skills or gain inspiration for your next project, we'll help you find it. You can find inspiration in the studio or the beautiful countryside it sits in. You'll leave feeling confident to carry on at home

Taking the twelve stages of Joseph Campbell's 'Hero's Journey' structure as a loose framework, this course offers the chance to write about themes such as risk, desire for change, resistance to change, travel, and encounters with others through a variety of prompts. There are opportunities to share your work, but no obligation.

24 Hour Flash Deal **33-in-1 Financial Manager Diploma Mega Bundle** Financial Manager Diploma Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Financial Manager Diploma package online with Studyhub through our online learning platform. The Financial Manager Diploma bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Financial Manager Diploma course provides complete 360-degree training on Financial Manager Diploma. You'll get not one, not two, not three, but 33 Financial Manager Diploma courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Financial Manager Diploma courses are yours for as long as you want them once you enrol in this course. This Financial Manager Diploma Bundle consists the following career oriented courses: Financial Management Professional Training Certification Finance for Non-finance Managers Certification Accounting Essentials and UK Taxation Understanding Financial Statements and Analysis Diploma in Accountancy Cashflow Management and Forecasting Financial Planning Corporate Risk And Crisis Management Financial Analysis Methods Finance: Financial Risk Management Corporate Finance: Working Capital Management Capital Budgeting & Investment Decision Rules Fundamentals of Corporate Finance Financial Modelling Comprehensive Mortgage Advice and Financial Guidance Sage 50 Accounts and Projects Creation Training Mastering Partnership Accounting: Financial Strategies and Reporting Sole Trader Financial Statements: A Practical Guide Marginal Costing in Economics: Financial Decision-Making Investment Analyst / Advisor Demystifying Depreciation Accounting: Financial Insights Trading and Financing Debt Management, Assessment, Financing & Counselling Tax Strategy and Financial Planning for Beginners Companies House Filing UK Financial Trading Certification and Risk Management Diploma Stock Trading Diploma Accountant's Guide to Climate Change Navigating Corporate Tax Return Procedures in the UK International Banking: Global Operations and Cross-Border Transactions FinTech The Infinite Banking Concept: Privatising Your Financial Future Economics Diploma In this exclusive Financial Manager Diploma bundle, you really hit the jackpot. Here's what you get: Step by step Financial Manager Diploma lessons One to one assistance from Financial Manager Diplomaprofessionals if you need it Innovative exams to test your knowledge after the Financial Manager Diplomacourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all 33 Financial Manager Diploma courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Financial Manager Diploma certificate and transcript on the next working day Easily learn the Financial Manager Diploma skills and knowledge you want from the comfort of your home The Financial Manager Diploma course has been prepared by focusing largely on Financial Manager Diploma career readiness. It has been designed by our Financial Manager Diploma specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Financial Manager Diploma Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Financial Manager Diploma bundle course has been created with 33 premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Financial Manager Diploma Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Financial Manager Diploma Elementary modules, allowing our students to grasp each lesson quickly. The Financial Manager Diploma course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. CPD 330 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Financial Manager Diploma training is suitable for - Students Recent graduates Job Seekers Financial analysis Budgeting and forecasting Risk management Financial reporting Strategic planning Investment management Cash flow management Tax planning and compliance Financial modeling Leadership and team management Communication and interpersonal skills Attention to detail Decision-making and problem-solving Regulatory compliance Knowledge of accounting principles and standards Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Financial Manager Diploma. Please note, To get qualified you need to enrol the below programmes: Bachelor's degree in Finance, Accounting, Economics, Business Administration, or a related field Professional certifications such as Chartered Financial Analyst (CFA), Certified Public Accountant (CPA), or Chartered Financial Planner (CFP) Master's degree in Finance, Business Administration, or a related field (MBA) Continuing education courses or workshops in financial management, investment analysis, or related areas Requirements To participate in this Financial Manager Diploma course, all you need is - A smart device A secure internet connection And a keen interest in Financial Manager Diploma. Career path You will be able to kickstart your Financial Manager Diploma career because this course includes various courses as a bonus. This Financial Manager Diplomais an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Financial Manager Diploma career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

Masterclasses? Refreshers? Introductions? It depends what you're looking for and where you want to pitch them, but here are six tried-and-tested highly focused sessions that organisations can take individually or as a series, to help develop their teams' project management capabilities one topic at a time. Objectives for each individual session are set out below, as part of the session outlines. Taken together, as a series, however, these modules are an ideal opportunity to develop your team's levels of project management capability maturity, whether that's by introducing them to the basic principles, refreshing them on best practice, or giving them the opportunity to really drill down into a specific area of challenge in your particular operating environment. Session outlines 1 Stakeholder management Session objectives This session will help participants: Understand why stakeholders matter to projects Be able to identify and engage stakeholders Be able to categorise stakeholders by their significance 1 Key principles What does 'stakeholder' mean - in theory? What does this mean in practice? Why stakeholders matter Consequences of missing stakeholders The stakeholder management process:IdentifyAssessPlanEngage 2 Identifying stakeholders Rapid listing CPIG analysis PESTLE analysis Drawing on the knowledge and experience of others Other ways to identify stakeholders 3 Assessing stakeholders Which stakeholders are significant? Stakeholder radar Power-interest maps Power-attitude maps 4 Planning The adoption curve Dealing with obstacles Who should engage which stakeholder? How should the project's organisation be structured? How will communication happen? 5 Engaging Seven principles of stakeholder engagement 2 Requirements and prioritisation Session objectives This session will help participants: Understand how clarity of requirements contributes to project success Use different techniques for prioritising requirements Agree requirements with stakeholders Manage changes to requirements 1 Understanding and managing stakeholder needs and expectations What are 'requirements'? What is 'requirements management'? Sources of requirements - and the role of stakeholders Are stakeholders sufficiently expert to specify their needs? Do they understand the detail of what they want, or do they need help to tease that out? What do stakeholders want to achieve? Working within constraints Prioritising requirements - three techniques 2 MoSCoW prioritisation 'Must have', should have', 'could have, 'won't have this time' When to use MoSCoW 3 The Kano Model Customer satisfaction - 'attractive' and 'must-be' qualities When to use Kano 4 Value-based prioritisation Understanding risk v value Using risk v value to prioritise features and schedules 5 Agreeing requirements Perfect v 'good enough' Establishing acceptance criteria Requirements traceability Agreeing project scope 6 Changing requirements Why requirements change Why change control matters Impact on projects A formal change control process Paying for change - managing change for different types of project 3 Estimating Session objectives This session will help participants: Understand the different purposes estimates satisfy Be able to use different estimating techniques Understand how to achieve different levels of accuracy 1 Key principles What's an estimate? Informed guesswork What needs to be estimated? Costs, resources, effort, duration Tolerances Precision v accuracy 2 Estimating through the lifecycle Start Plan Do 3 Early estimates Comparative ('analogous') estimating Parametric estimating Using multiple estimating techniques 4 Bottom-up estimating Bottom-up ('analytical') estimating Pros Cons 5 Three-point estimating Three-point ('PERT': Programme Evaluation and Review Technique) estimating Uncertainty and the range of estimates Calculating a weighted average Three-point with bottom-up 4 Scheduling Session objectives This session will help participants: Understand how to create a viable schedule Be able to use different forms of schedule Understand the concept of the critical path 1 Key principles The planning horizon Rolling wave planning Release planning 2 Viable scheduling Creating a viable schedule Define the scope Sequence the work Identify the risks and build in mitigations Identify the resources Estimate the effort and durations Check resource availability Refine until a workable schedule is produced 3 Critical path analysis The critical path Network diagrams Sequence logic Practical application:Network diagram with estimated durationsThe 'forward pass'The 'backward pass'Calculating total floatIdentifying the critical pathCalculating free float Gantt charts 5 Risk and issue management Session objectives This session will help participants: Understand the difference between risks and issues Be able to identify and assess risks Understand ways of mitigating risks Manage issues 1 Key principles Understanding risk Threats and opportunities The risk management processPreparation - proactive risk managementThe process - identify, assess, plan, implementStakeholder communication Roles and responsibilities Risk management strategy The risk register Risk appetite 2 Risk identification Brainstorming Interviews Assumption analysis Checklists 3 Risk assessment and prioritisation Probability, impact and proximity Triggers Qualitative risk assessment Qualitative impact assessment Qualitative probability assessment Probability / impact grid Bubble charts Risk tolerance 4 Planning countermeasures To mitigate or not to mitigate? Categories of risk response Avoid and exploit Reduce and enhance Transfer Share Accept Contingency Secondary risks 5 Issue management What is an issue? Tolerances Issues and tolerances The PRINCE2 view of issues Ownership of issues An issue management process Issue register 6 Budgeting and cost control Session objectives This session will help participants: Understand what to include in a budget - and why Choose - and use - the appropriate estimating technique Align the budget with the schedule Understand how to monitor spend and control costs Trouble-shoot effectively to get projects back within budget Session format Flexible. The session can be tailored to the participants' average level of project management maturity - a 60-minute session (delivered virtually) is an effective introduction. A 90-minute session allows for more in-depth treatment. A half-day session (face-to-face or virtual) gives time for a more challenging workshop, particularly to discuss specific cost control issues with any of the participants' current projects. 1 Where is the money coming from? Can we pay from revenue? Do we need to borrow? How long will the project take to pay back? The lifecycle of the budget Through-life costs Stakeholder involvement 2 Estimating costs Reminder: the relationship between estimates Reminder: possible estimating techniques What do we need to estimate?PeopleEquipmentMaterialsFacilities and operating costsWork package estimateEstimated project costs Estimating agile projects 3 Aligning budget and schedule Scheduling and financial periods Spreading the budget 4 Reserves and agreeing the budget Contingency reserve Management reserve Agreeing the budget 5 Cost control Planned spend over time Actual spend over time Work completed over time Evaluating different scenarios: delivery v spend 6 Trouble-shooting Why are we where we are? What has caused the project to spend at the rate it is? Why is it delivering at the rate it is? What are the root causes? What can we do about it?

Are you interested in learning how to make polymer clay jewellery? Join us for a fun and informative workshop that will teach you everything you need to know about conditioning the clay, texturing, cutting, shaping the clay, forming and moulding. You'll create a range of finished jewellery pieces that you can take home with you afterwards. This is a great way to learn some new skills and explore a wide variety of style and techniques that are easy enough for beginners but also have room for more advanced learners!

Dance For Healing Class is a unique experience for men & women who want to empower themselves through core moves to increase strength, balance, and self-confidence This class is based on Flamenco moves. The artist is specialized in Flamenco with 15 years of experience in the international arena Taught by a native instructor from Chile Julieta Arteaga “ The class will be 1 hour & 15 minutes max as this dance therapist needs concentration, breathing, and stretching  The place will be on King Street, W6 9JT (Hammersmith high street with Rivercourt Rd corner) Bus stop “Ravenscourt” Buses 27, 190, 267, 391, H91, N9, N11 Nearest tube station: Ravenscourt Park (District Line) First-class will cost £12   Benefits of the DANCE FOR HEALING” program: Great Coordination Balance & Strength Increase core awareness Develops inner self-confidence Promote happiness Enhance body posture Reduce Depression & Anxiety - Release Stress

24 Hour Flash Deal **X-in-1 Level 4 Diploma in Advice And Guidance Mega Bundle** Level 4 Diploma in Advice And Guidance Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Level 4 Diploma in Advice And Guidance package online with Studyhub through our online learning platform. The Level 4 Diploma in Advice And Guidance bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. In this exclusive Level 4 Diploma in Advice And Guidance bundle, you really hit the jackpot. Here's what you get: Step by step Level 4 Diploma in Advice And Guidance lessons One to one assistance from Level 4 Diploma in Advice And Guidanceprofessionals if you need it Innovative exams to test your knowledge after the Level 4 Diploma in Advice And Guidancecourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all X Level 4 Diploma in Advice And Guidance courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Level 4 Diploma in Advice And Guidance certificate and transcript on the next working day Easily learn the Level 4 Diploma in Advice And Guidance skills and knowledge you want from the comfort of your home This Level 4 Diploma in Advice And Guidance course provides complete 360-degree training on Level 4 Diploma in Advice And Guidance. You'll get not one, not two, not three, but X Level 4 Diploma in Advice And Guidance courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Level 4 Diploma in Advice And Guidance courses are yours for as long as you want them once you enrol in this course. This Level 4 Diploma in Advice And Guidance Bundle consists the following career oriented courses: Course 01: Level 4 Diploma in Advice And Guidance Course 02: Paralegal (Legal Professional) Certification Course 03: Business Law Course 04: English Law Basics: Understanding Legal Principles Course 05: UK Commercial Law and Consumer Protection Training Course 06: Understanding UK Insurance (General, Commercial, Liability, Life) Course 07: Data Protection and Data Security (GDPR) Training Certification Course 08: Cyber Security Law Course 09: Family Law Course 10: Workplace Violence, Harassment, and Conflict Resolution Training Course 11: Tort Law Simplified: Understanding Legal Principles and Rights Course 12: Criminology: Criminal Law Course 13: Criminal Intelligence & Counterterrorism Analysis Course 14: International Law Certificate Course 15: GDPR Training Course 16: Workplace Confidentiality Course 17: Business Contract & Compliance Manager: Ensuring Legal Integrity Diploma Course 18: Corporate Social Responsibility Diploma Course 19: Emotional Intelligence and Social Management Diploma Course 20: Resilience Masterclass Course 21: Cross-Cultural Awareness Training Diploma Certificate Course 22: Office Skills (Administration, Communication, and Management) Diploma Course 23: Public Speaking: Presentations like a Boss Course 24: Strategic Business Management Course 25: Middle Manager Management 3 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01 :Career Development Plan Fundamentals Course 02 :CV Writing and Job Searching Course 03 :Interview Skills: Ace the Interview The Level 4 Diploma in Advice And Guidance course has been prepared by focusing largely on Level 4 Diploma in Advice And Guidance career readiness. It has been designed by our Level 4 Diploma in Advice And Guidance specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. Course Curriculum **Level 4 Diploma in Advice And Guidance** Module 01: Legal Advice and Advisor Understanding the role and responsibilities of legal advisors Providing legal advice within ethical and professional standards Exploring the regulatory framework governing legal advisory services Developing effective communication skills for legal consultation Module 02: Legal Terminology Learning key legal terms and concepts Understanding the meaning and usage of legal terminology Developing proficiency in interpreting and using legal language Applying legal terminology accurately in written and verbal communication Module 03: Law and Legal System Exploring the structure and functions of the legal system Understanding the sources of law and hierarchy of legal norms Analyzing the roles of different legal institutions and actors Examining the principles of justice and fairness in the legal system Module 04: Property Law Understanding the principles and concepts of property law Exploring different types of property rights and interests Analyzing legal issues related to ownership, transfer, and use of property Examining relevant legislation and case law in property disputes Module 05: Wills, Probate, Estate Law Understanding the legal framework governing wills, probate, and estates Exploring the process of estate planning and administration Analyzing legal issues related to inheritance, succession, and distribution of assets Providing guidance on drafting wills and navigating probate proceedings Module 06: Contract & Business Law Understanding the elements and formation of a contract Exploring contractual rights, obligations, and remedies Analyzing legal issues in business transactions and commercial agreements Providing advice on contract negotiation, drafting, and enforcement Module 07: Family Law Understanding the principles and procedures of family law Exploring legal issues related to marriage, divorce, and child custody Analyzing the rights and responsibilities of family members Providing guidance on resolving family disputes through legal channels Module 08: Criminal and Tort Law Understanding the principles and categories of criminal and tort law Exploring legal definitions of crimes and civil wrongs Analyzing legal liability and defenses in criminal and tort cases Providing advice on seeking justice and compensation for victims of crimes and torts Module 09: Human Rights Understanding the principles and significance of human rights law Exploring international and domestic human rights instruments Analyzing legal issues related to discrimination, freedom, and equality Providing guidance on protecting and promoting human rights in various contexts Module 10: Good Customer Service Understanding the importance of customer service in legal advisory roles Developing interpersonal skills for effective client interaction Providing timely and accurate information to clients Resolving client queries and concerns professionally Module 11: Customer Relationship Management Building and maintaining strong client relationships Understanding client needs and preferences Tailoring legal advice and services to meet client expectations Managing client feedback and satisfaction Module 12: Partnership and Agreements Understanding the legal framework governing partnerships and agreements Exploring the rights and obligations of partners in business ventures Analyzing the process of forming, operating, and dissolving partnerships Providing guidance on drafting and negotiating partnership agreements Module 13: Considerations And Capacities Of Contact Laws Understanding the legal principles governing contracts Exploring the requirements for a valid contract Analyzing issues related to capacity, consent, and consideration in contract law Providing advice on contract formation, interpretation, and enforcement Module 14: Terms Within A Contract Identifying and defining key terms in contracts Understanding the significance of contract terms and clauses Analyzing the implications of different contractual provisions Providing guidance on drafting clear and enforceable contract terms Module 15: Consumer Protection Understanding consumer rights and protections under the law Exploring legal remedies for consumer grievances and disputes Analyzing regulations and standards for consumer products and services Providing guidance on consumer rights awareness and advocacy Module 16: Reflective Practice and Professional Development Reflecting on personal practice and professional development needs Seeking feedback and engaging in continuous learning Developing strategies for self-care and managing stress Enhancing professionalism and maintaining professional boundaries Module 17: Information Governance Understanding the principles and practices of information governance Ensuring compliance with data protection and privacy regulations Managing confidential and sensitive information securely Promoting transparency and accountability in information management Module 18: Human Behaviour and Basic Psychological Process Exploring fundamental concepts of human behavior and psychology Understanding factors influencing individual behavior and decision-making Analyzing psychological processes relevant to advisory roles Applying psychological insights to enhance communication and interaction with clients Module 19: Databases and Information Management Understanding the role of databases in information management Exploring database design, structure, and functionality Managing data effectively and securely using database systems Analyzing ethical and legal considerations in database management Module 20: Common Facilitation Techniques Exploring techniques for facilitating group discussions and workshops Engaging participants and managing group dynamics Facilitating learning and skill development through interactive activities Evaluating the effectiveness of facilitation techniques in achieving desired outcomes CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Level 4 Diploma in Advice And Guidance training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Level 4 Diploma in Advice And Guidance. Please note, To get qualified you need to enrol the below programmes: Level 2 Certificate in Information Advice or Guidance (RQF) Level 3 NVQ Certificate in Advice and Guidance (RQF) Level 4 NVQ Diploma in Advice and Guidance (RQF) Requirements To participate in this Level 4 Diploma in Advice And Guidance course, all you need is - A smart device A secure internet connection And a keen interest in Level 4 Diploma in Advice And Guidance. Career path You will be able to kickstart your Level 4 Diploma in Advice And Guidance career because this course includes various courses as a bonus. This Level 4 Diploma in Advice And Guidanceis an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Level 4 Diploma in Advice And Guidance career opportunities. Certificates Enrolment Letter Digital certificate - Included Level 4 Diploma in Advice And Guidance Digital & Hardcopy Certificate Digital certificate - Included Student ID Card Digital certificate - Included

Train the Trainer Recharge: The Healthy Trainer Course Overview This course offers an essential refresh for trainers aiming to enhance their personal wellbeing alongside their professional skills. It focuses on maintaining a healthy balance between the demands of training others and self-care, ensuring trainers remain effective, energised, and confident. Learners will develop strategies to manage their own stress, address challenges confidently, and create positive learning environments. This course equips participants with the ability to engage audiences meaningfully, foster productive feedback, and maintain resilience in dynamic training settings. By the end, trainers will be better prepared to sustain their motivation and deliver impactful sessions while prioritising their own health and wellbeing. Course Description The programme delves into key areas crucial for trainers to maintain optimal performance and wellbeing. It covers techniques for self-management, including stress reduction and emotional regulation, alongside strategies to resolve common challenges encountered in training roles. Emphasis is placed on managing classroom dynamics and engaging diverse audiences effectively. Additionally, learners will explore ways to interpret and respond to feedback constructively to improve delivery and participant outcomes. This course combines reflective learning with evidence-based methods to build resilience, boost trainer confidence, and support continuous professional growth in a balanced, healthy manner. Participants will leave with renewed skills to enhance both their training impact and personal wellbeing. Train the Trainer Recharge: The Healthy Trainer Curriculum Module 01: Welcome to Healthy Trainer Module 02: Manage Yourself Module 03: Manage Your Issues Module 04: Manage Your Classroom Module 05: Manage Your Audience Module 06: Manage Your Feedback (See full curriculum) Who is this course for? Individuals seeking to enhance their trainer wellbeing and effectiveness. Professionals aiming to develop sustainable training practices. Beginners with an interest in personal development and training skills. Trainers wanting to improve audience engagement and feedback management. Career Path Corporate Trainer Learning and Development Specialist Workshop Facilitator Training Coordinator Education Consultant

Learn the art of silk shading from home

Duration 5 Days 30 CPD hours This course is intended for The target audience for this textbook is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this textbook will be helpful are: ? Business and non-IT professionals ? Application designers and database developers ? Business Intelligence (BI) analysts and consumers ? Database administrators ? Web server administrators Overview The first portion of this textbook considers the logical models upon which a relational database is based and the various configurations and environments in which you may work with the Oracle database. The next segment focuses on the actual SQL syntax for writing database queries. You will begin with the simplest of queries and then proceed onto moderately complex query scenarios. Finally, this textbook covers the DDL, DML and transaction control portions of the SQL language that allow one to create, maintain and manipulate application database objects and application data. This textbook takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle. Relational Databases & Data Models About Data Models About the Relational Model The Electronics Data Model About the Relational DBMS Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL*Plus Setup Jdeveloper Using the Database Interface About Bind & Substitution Variables Using SQL Developer Using SQL*Plus Introduction to the SQL Language About the SQL Language Characteristics of SQL Introducing SQL Using Select SQL Rules The Select Statement The Select Statement Distinct/Unique Keyword Using Alias Names Restricting Results with the Where Clause About Logical Operators Equality Operator Boolean Operators REGEXP_LIKE() In Operator Sorting Data with the Order By Clause About the Order by Clause Multiple Column Sorts Specify the Sort Sequence About Null Values within Sorts Using Column Aliases Pseudo Columns, Functions & Top-N Queries Rowid Pseudo Column ORA_ROWSCN PSEUDO Column ROWNUM Pseudo Column About the Built-In Functions SYSDATE User & UID SESSIONTIMEZONE Function Using the Dual Table Row Limiting & Top-N Queries FETCH First x Rows Only Clause OFFSET x Rows Clause FETCH?PERCENT Clause The WITH TIES Option Joining Tables About Joins Inner Joins Reflexive Join Non-Key Join Outer Join Using the Set Operators About the Set Operators SQL Set Operator Examples UNION Example INTERECT Example MINUS Example UNION All Summary Functions Using Sub-Queries Finding Data with Sub-Queries Standard Sub-Queries Correlated Sub-Queries The EXISTS Operator Aggregating Data within Groups About Summary Groups Find Groups within the Tables Select Data From the Base Tables Select Groups from the Results Use DDL to Create & Manage Tables Create Table Statement Column Data Types Not Null Default Describe Alter Table Statement Drop Table Statement Table DDL Using SQL Developer Alter User Statement Alter Session Statement NLS_Language NLS_Date Use DML to Manipulate Data The Insert Statement The Delete Statement The Update Statement About Transactions Transaction Rollback Transaction Commit Transaction Savepoint The Set Transaction Statement Set Transaction Read Only Statement Rules Understanding the Data Models The Company Data Model The Electronics Data Model About the SQL-99 Standard SQL-92 & SQL-99 Cross Joins Natural Joins Inner Joins Implicit Inner Join Outer Joins Anti Joins Named Sub-Queries Enhancing Groups with Rollup & Cube Using Rollup The Grouping() Function Using Cube SQL Functions: Character Handling What are the SQL Functions? String Formatting Functions UPPER(), LOWER() Example INITCAP() Example Character Codes Functions CHR((), ASCII() Examples PAD & TRIM Functions RPAD() Example RTRIM() Example TRIM() Example String Manipulation Functions DECODE () Example SUBSTR() Example INSTR() Example TRANSLATE() Example REPLACE() Example String Comparison Functions LEAST() Example Phonetic Search Function SOUNDEX() Example SQL Functions: Numeric Handling About the Numeric Data Functions GREATEST() Example ABS() Example ROUND() Example TRUNC() Example SIGN() Example TO_NUMBER() Example & Data ype Conversions NULL VALUES FUNCTIONS NVL() & NVL2() Function NVL() Example (Character) NVL() Example (Numeric Loss of Data) NVL() Example (Numeric Output) NVL2() Example COALESCE() Function NULLIF() Function SQL Functions: Date Handling Date Formatting Functions TO_CHAR() & TO_DATE() Format Patterns TO_CHAR() Examples TO_DATE() Examples EXTRACT() Example Date Arithmetic Functions MONTHS_BETWEEN() Example ADD_MONTHS() Example LAST_DAY() Example NEXT_DAY() Example TRUNC(), ROUND() Dates Example NEW_ TIME() Example About V$TIMEZONE_NAMES CAST() FUNCTION & TIME ZONES Database Objects: About Database Objects About Database Objects About Schemas Making Object References Database Objects: Relational Views About Relations Views The Create View Statement Why Use Views? Accessing Views with DML Maintaining View Definitions Alter View Drop View DDL Using SQL Developer Database Objects: Indexes About Indexes Create & Drop Index Statements Indexes & Performance Data Dictionary Storage Database Objects: Creating Other Objects About Sequences Referencing NEXTVAL Referencing CURRVAL Within the DEFAULT Clause Alter Sequence & Drop Sequence ALTER SEQUENCE DROP SEQUENCE About Identity Columns CREATE TABLE?GENERATED AS IDENTITY ALTER TABLE?GENERATED AS IDENTITY Start With Limit Value ALTER TABLE...DROP IDENTITY About Synonyms CREATE & DROP SYNONYM Statements CREATE SYNONYM DROP SYNONYM Public Vs Private Synonyms CREATE SCHEMA AUTHORIZATION Database Objects: Object Management Using DDL The RENAME Statement TABLESPACE Placement CREATE TABLE?TABLESPACE The Comment Statement The TRUNCATE TABLE Statement Database Objects: Security About Object Security Grant Object Privileges Revoke Object Privileges Object Privileges & SQL Developer Data Integrity Using Constraints About Constraints NOT NULL Constraint NOT NULL Example CHECK Constraint UNIQUE Constraint PRIMARY KEY Constraint REFERENCES Constraint ON DELETE CASCADE Example ON DELETE SET NULL Example Constraints on Existing Tables Constraints & SQL Developer Managing Constraint Definitions RENAMING & DROPPING Constraints ENABLING & DISABLING Constraints DEFERRED Constraint Enforcement SET CONSTRAINTS Handling Constraint Exceptions Constraints with Views DATA Dictionary Storage The Data Dictionary Structure More About the Data Dictionary OBJECT-SPECIFIC Dictionary Views USER_UPDATABLE_COLUMNS The Dictionary Structure METADATA & SQL Developer Additional course details: Nexus Humans Oracle 12c SQL Fundamentals 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 Oracle 12c SQL Fundamentals 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.