3775 Courses

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!

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.

An Essential Sewing & Making Skills Course for Teachers of GCSE & A Level Fashion & Textiles for both Art & Design and D&T.

An immersive and creative cross curricular experience with art, drama, science and exploration.

Take your songwriting to the next level with this five session mentoring journey from Josh Bowker, acclaimed folk songwriter and workshop leader.

Learn more about yourself, your relationships and your career. Transactional Analysis is a great place to start for personal and professional growth. Join us for this 2 day workshop in an area of outstanding beauty. Have fun whilst learning!

Learn the art of tambour beading in this class

A 5-day intensive, practical course covering model-making skills for theatre, film, animation or spatial design. Led by David Neat from his studio in Deptford.

The Special Educational Needs Teaching Assistant Diploma is a professional qualification focussed on the practical application of theoretical knowledge. You will gain knowledge of classroom methodologies, communication skills for teaching and how to safeguard children, along with role-specific competencies such as the SEN code of practice, understanding learning difficulties, supporting children on the autistic spectrum, and managing ADHD and dyslexia in the classroom. We've taken this comprehensive course and broken it down into several manageable modules which we believe will assist you to easily grasp each concept - from the fundamental to the most advanced aspects of the course. It really is a sure pathway to success. Who is the course for? Educators who want to improve their interactive teaching course. People who have an interest in teaching and studying. 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. 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 This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Module 1: Fundamentals of Teaching Understanding the Development of Children and Young Person 01:00:00 Communication and Professional Relationships with Pupils and Family 01:00:00 Safeguarding the Welfare of Children and Young Person 01:00:00 Module 2: Teaching in UK Teaching in the UK 00:10:00 Teachers' Standards in UK 00:10:00 Teachers Pay 00:30:00 The English School System 00:10:00 Evaluation of Schools and Teachers 00:30:00 School Governance 00:15:00 Inclusive Teaching 00:15:00 Module 3: Teacher Training Module 01: Getting Started 00:22:00 Module 02: Understanding Training and Facilitation 00:25:00 Module 03: Gathering Materials 00:12:00 Module 04: Creating a Lesson Plan 00:15:00 Module 05: Choosing Activities 00:15:00 Module 06: Preparing for the Workshop 00:10:00 Module 07: Getting Off on the Right Foot 00:10:00 Module 08: Delivery Tips and Tricks 00:30:00 Module 09: Keeping it Interactive 00:08:00 Module 10: Dealing With Difficult Participants 00:12:00 Module 11: Tackling Tough Topics 00:16:00 Module 12: Wrapping Up 00:12:00 Activities 00:00:00 Module 4: Teaching Methodologies Education - A Group Enterprise 00:20:00 Traits to Develop 00:30:00 Grow the Attention 00:30:00 Learning Good Habits 00:25:00 Importance of Memory 00:30:00 Imagination is Important 00:16:00 Breakdown of Thinking Process 00:30:00 Appreciation - An Aesthetic Emotion 00:20:00 Learning Reflexive Activities 00:35:00 Differing Individuals 01:00:00 Morality Matters 00:30:00 Different Learning Methods 00:15:00 Different Psychological Exercises 00:30:00 Problems, Situations & Solutions 00:20:00 Measuring the Achievements 01:00:00 Module 5: Psychology of Teaching Why Young People Do Not Learn to Study Properly? 00:20:00 The Nature of Study, and Its Principal Factors 00:30:00 Provision for Specific Purposes, as One Factor of Study 00:40:00 The Supplementing of Thought, as a Second Factor of Study 00:15:00 The Organization of Ideas, as a Third Factor in Study 00:30:00 Judging of the Soundness and General Worth of Statements, as a Fourth Factor in Study 00:25:00 Memorizing, as a Fifth Factor in Study 02:00:00 The Using of Ideas, as a Sixth Factor in Study 00:25:00 Provision for a Tentative Rather Than a Fixed Attitude Toward Knowledge, as a Seventh Factor in Study 01:00:00 Provision for Individuality, as an Eighth Factor in Study 00:15:00 Full Meaning of Study: Relation of Study to Children and to the School 00:15:00 Module 6: SEN Teaching Introduction to Special Educational Needs (SEN) 00:05:00 Understand Constructivism in the Classroom and know your role as a teacher 00:10:00 SEN Code of Practice 00:15:00 Get an understanding on SENCO 00:10:00 Classroom Management Strategies for Children with Special Needs 00:05:00 Physical Difficulties, Sensory Difficulties, Cognitive Impairments of Pupils 00:10:00 How to Deal with Pupils with Autism 00:10:00 Understanding Learning Difficulties 00:10:00 Anger Management Methods for Pupils With Special Needs 00:10:00 Teaching Children with Down Syndrome 00:10:00 Conclusion SEN 00:05:00 Module 7: SEN in USA INTRODUCTION to SEN USA 02:00:00 PRINCIPLES OF SPECIAL EDUCATION 01:00:00 SEN CURRICULUM 01:00:00 SEN TEACHING 01:00:00 CONCLUSION to SEN USA 00:15:00 Module 8: ADHD What is ADHD? 00:05:00 Causes of ADHD 00:05:00 Diagnosing ADHD 00:05:00 Treating ADHD 00:05:00 ADHD and Education 00:05:00 Reasonable Adjustments: ADHD 00:10:00 Adults with ADHD 00:10:00 Module 9: Dyslexia What is Dyslexia? 00:10:00 Identifying Dyslexia 00:05:00 Co-occurring Conditions 00:05:00 Diagnosing Dyslexia 00:05:00 Creating Dyslexia Friendly Environment 00:05:00 Solutions for Dyslexia 00:30:00 Module 10: Dealing with Troubled Children YOU AND YOUR CHILD STUDY 01:30:00 THE PROBLEM OF PUNISHMENT 00:30:00 WHEN YOUR CHILD IMAGINES THINGS 00:30:00 WHY KIDS LIE AND WHAT TO DO ABOUT IT 01:00:00 BEING AFRAID 00:30:00 THE FIRST GREAT LAW 00:30:00 THE TRAINING OF THE WILL 01:00:00 HOW CHILDREN REASON ABOUT FUTURE 00:30:00 WORK AND PLAY 01:00:00 CHILDREN'S GANGS, CLUBS, AND FRIENDSHIPS 00:15:00 CHILDREN'S IDEALS AND AMBITIONS 01:00:00 THE STORK OR THE TRUTH 00:30:00 THE GOLDEN AGE OF TRANSITION 00:15:00 HEREDITY AND ENVIRONMENT 01:00:00 FREEDOM AND DISCIPLINE 00:15:00 Mock Exam Mock Exam- Advanced Diploma in Teaching 00:30:00 Final Exam Final Exam- Advanced Diploma in Teaching 00:30:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Our Team Leader Programme is designed specifically for new & existing Team Leads & Managers in Healthcare, such as General Practice, Primary & Secondary Care. This programme gives delegates the opportunity to spend time with peers, gain new tools & techniques that enable them to develop & support their team effectively. Building confidence to be able to have more proactive & challenging conversations with team members, supporting managers and reducing escalation.