5280 Writing courses in Swindon delivered Online

Executive PA: Executive PA Training Online Introducing Executive PA: Executive PA Training Course "Empowering the Next Generation" Online course! This Executive PA: Executive PA Training could be the key to your dream job. Transform your ambition and enthusiasm into a rewarding career for life by studying from home at your own pace and time. After Completing this Executive PA : Executive PA Training learn how to handle a wide range of essential office administration tasks, as well as how to write important business letters and handle complex mail and shipping requirements. Making travel arrangements on behalf of others, organising meetings and events, the importance of time management as a PA, and how to become a better communicator are also covered in the Executive PA: Executive PA course. Our Executive PA: Executive PA Training course has been designed to equip you with the essential knowledge and skills needed to become an expert executive secretary or personal assistant and will give you all the practical knowledge & credentials that you need to excel in your new role. Enrol on our Executive PA: Executive PA Training course today and begin your journey to improve your career prospects with the latest skills and the power of self-belief! Courses including with this Executive PA: Executive PA Training Course bundle. Course 01: Executive PA Training Course 02: Office Management and Administration Course 03: Minute Taking Course Course 04: HR Management Course Course 05: Time Management Course Special Offers of this Executive PA: Executive PA Course: This Executive PA: Executive PA Course includes a FREE PDF Certificate. Lifetime access to this Executive PA: Executive PA Course Instant access to this Executive PA: Executive PA Course 24/7 Support Available to this Executive PA: Executive PA Course [ Note: Free PDF certificate as soon as completing the Executive PA: Executive PA Training course] Executive PA: Executive PA Training Online This Executive PA: Executive PA Training course consists of 11 modules. Unlock your potential with our Executive PA: Executive PA Training, the perfect pathway to your dream job. This Executive PA: Executive PA course allows you to study at your own pace, transforming your ambition into a lifelong career. Through our Executive PA: Executive PA Training, you'll master essential office administration tasks, business letter writing, and complex mail handling. Additionally, our Executive PA: Executive PA course covers making travel arrangements, organizing meetings and events, and time management. Become a better communicator and elevate your career with our comprehensive Executive PA: Executive PA Training. Start your journey today! Who is this course for? Executive PA : Executive PA Training Online This Executive PA: Executive PA Training course is designed for existing secretarial/administrative workers seeking advancement or newcomers seeking their first professional position. Requirements Executive PA : Executive PA Training Online To enrol in this Executive PA: Executive PA Training Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Executive PA: Executive PA Training Course. Be energetic and self-motivated to complete our Executive PA: Executive PA Training Course. Basic computer Skill is required to complete our Executive PA: Executive PA Training Course. If you want to enrol in our Executive PA: Executive PA Training Course, you must be at least 15 years old. Career path Executive PA: Executive PA Training After completing this Executive PA: Executive PA Training course, you may be able to pursue a variety of promising career opportunities, such as: Office Assistant or Executive PA Receptionist Personal Concierge Executive Assistant

Duration 3 Days 18 CPD hours This course is intended for This is an introductory- level course appropriate for those who are developing applications using relational databases, or who are using SQL to extract and analyze data from databases and need to use the full power of SQL queries. Overview This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert practitioner, attendees will learn to: Maximize the potential of SQL to build powerful, complex and robust SQL queries Query multiple tables with inner joins, outer joins and self joins Construct recursive common table expressions Summarize data using aggregation and grouping Execute analytic functions to calculate ranks Build simple and correlated subqueries Thoroughly test SQL queries to avoid common errors Select the most efficient solution to complex SQL problems 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. SQL is the cornerstone of all relational database operations. In this hands-on course, you learn to exploit the full potential of the SELECT statement to write robust queries using the best query method for your application, test your queries, and avoid common errors and pitfalls. It also teaches alternative solutions to given problems, enabling you to choose the most efficient solution in each situation. Introduction: Quick Tools Review Introduction to SQL and its development environments Using SQL*PLUS Using SQL Developer Using the SQL SELECT Statement Capabilities of the SELECT statement Arithmetic expressions and NULL values in the SELECT statement Column aliases Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword Use of the DESCRIBE command Restricting and Sorting Data Limiting the Rows Rules of precedence for operators in an expression Substitution Variables Using the DEFINE and VERIFY command Single-Row Functions Describe the differences between single row and multiple row functions Manipulate strings with character function in the SELECT and WHERE clauses Manipulate numbers with the ROUND, TRUNC and MOD functions Perform arithmetic with date data Manipulate dates with the date functions Conversion Functions and Expressions Describe implicit and explicit data type conversion Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions Nest multiple functions Apply the NVL, NULLIF, and COALESCE functions to data Decode/Case Statements Using the Group Functions and Aggregated Data Group Functions Creating Groups of Data Having Clause Cube/Rollup Clause SQL Joins and Join Types Introduction to JOINS Types of Joins Natural join Self-join Non equijoins OUTER join Using Subqueries Introduction to Subqueries Single Row Subqueries Multiple Row Subqueries Using the SET Operators Set Operators UNION and UNION ALL operator INTERSECT operator MINUS operator Matching the SELECT statements Using Data Manipulation Language (DML) statements Data Manipulation Language Database Transactions Insert Update Delete Merge Using Data Definition Language (DDL) Data Definition Language Create Alter Drop Data Dictionary Views Introduction to Data Dictionary Describe the Data Dictionary Structure Using the Data Dictionary views Querying the Data Dictionary Views Dynamic Performance Views Creating Sequences, Synonyms, Indexes Creating sequences Creating synonyms Creating indexes Index Types Creating Views Creating Views Altering Views Replacing Views Managing Schema Objects Managing constraints Creating and using temporary tables Creating and using external tables Retrieving Data Using Subqueries Retrieving Data by Using a Subquery as Source Working with Multiple-Column subqueries Correlated Subqueries Non-Correlated Subqueries Using Subqueries to Manipulate Data Using the Check Option Subqueries in Updates and Deletes In-line Views Data Control Language (DCL) System privileges Creating a role Object privileges Revoking object privileges Manipulating Data Overview of the Explicit Default Feature Using multitable INSERTs Using the MERGE statement Tracking Changes in Data

Diploma in Python Programming Course Overview The Diploma in Python Programming offers an in-depth exploration of Python, one of the most versatile and in-demand programming languages. This course is designed to provide learners with a strong foundation in Python, covering essential concepts such as data structures, functions, libraries, and file handling. Learners will gain the skills necessary to write Python code to solve real-world problems, enabling them to create applications, automate tasks, and perform data analysis. By the end of the course, learners will have the practical knowledge to use Python effectively for various programming tasks in both professional and personal settings. Course Description This comprehensive course begins with the basics of Python programming, guiding learners through essential concepts such as syntax, data types, and conditional statements. Learners will progress to more advanced topics, including file handling, data storage structures, and error handling. Key modules like the creation of user functions, working with external libraries, and implementing Python in database management provide valuable skills that can be directly applied in the workplace. This course also covers essential tools such as command prompt usage, Jupyter notebooks, and package management in Python. By the end of the course, learners will have developed the confidence and competence to apply Python across various domains, including software development, data analysis, and system automation. Diploma in Python Programming Curriculum Module 01: Introduction to Python Programming Module 02: Getting Started with Python Module 03: Conditional Branching with Python Module 04: Importing External/Internal Library in Python Module 05: Project Rock Paper and Scissors Module 06: Strings Operation in Python Module 07: Date and Time in Python Module 08: File Handling, Read and Write Using Python Module 09: Data Storage Structures: Tuple, List, and Dictionary Module 10: Writing User Functions in Python Module 11: Sending Mail Module 12: Import Tricks in Python Module 13: Import Operating System and Platform Module 14: Exceptions Handling in Python Module 15: Installing Packages and Scheduling in Python Module 16: Database in Python Using SQLite Module 17: Running Programs from Command Prompt and Jupyter Notebook Module 18: Conclusion (See full curriculum) Who is this course for? Individuals seeking to develop a foundational understanding of Python programming. Professionals aiming to enhance their programming skills for career advancement. Beginners with an interest in software development, data analysis, or automation. Anyone looking to pursue a career in programming or technology. Career Path Software Developer Data Analyst Automation Engineer Python Programmer Database Administrator IT Specialist

Touch Typing: Touch Typing Training Are you excited to learn how to type properly and quickly without having to glance at the keyboard? You are welcome in our dynamic touch typing course. This touch typing course includes hand and finger placement techniques. Also, this touch typing course explains the methods to increase typing accuracy and speed. In addition, this touch typing course covers how to practice typing exercises that concentrate on the home, top, and bottom rows of the keyboard. Students in this touch typing course also learn to use all 10 fingers. Drills and exams are a common part of this touch typing course. Join our touch typing course to increase productivity and lower the chance of repetitive strain injuries! Learning outcomes of touch typing course After completing this touch typing course, students will learn about: The introduction of touch typing methods, their types, and keys using processes. How to drill sentences is also described in our touch typing course. Figures and alphabetical paragraphs are also taught by our touch typing course. Moreover, this touch typing course explains the ergonomics and posture of touch typing. Throughout this touch typing course, you will learn about typing software and tools. Special Offers Of this Touch Typing: Touch Typing course This Touch Typing: Touch Typing course includes a FREE PDF Certificate. Lifetime access to this Touch Typing: Touch Typing course Instant access to this Touch Typing: Touch Typing course Get FREE Tutor Support from Monday to Friday in this Touch Typing: Touch Typing course. [ Note: Free Digital certificate as soon as completing the Touch Typing: Touch Typing course] Touch Typing: Touch Typing Training Unlock your typing potential with our comprehensive Touch Typing: Touch Typing course. This Touch Typing: Touch Typing program teaches essential hand and finger placement techniques, ensuring you master the fundamentals. Learn how to increase typing accuracy and speed through proven methods in our Touch Typing: Touch Typing course. You'll practice exercises focusing on the home, top, and bottom rows of the keyboard, and gain the skill of using all 10 fingers efficiently. With drills and exams integrated into our Touch Typing: Touch Typing course, you'll develop the expertise needed for fast and accurate typing. Enroll today! Who is this course for? Touch Typing: Touch Typing Training Students, professionals, and everyone else who wants to increase their typing efficiency and speed should take our touch typing course. Requirements Touch Typing: Touch Typing Training To enrol in this Touch Typing: Touch Typing Course Course, students must fulfil the following requirements. To join in our Touch Typing: Touch Typing Course, you must have a strong command of the English language. To successfully complete our Touch Typing: Touch Typing Course, you must be vivacious and self driven. To complete our Touch Typing: Touch Typing Course, you must have a basic understanding of computers. Career path Touch Typing: Touch Typing Training This touch typing course helps you get a job in: Administration Data entry Tanscribing Writing Programming Customer service

Looking to sharpen your auditing prowess without stepping outside? Our Internal Auditor Training - CPD Certified Course is designed to equip you with the essential knowledge and expertise required to excel in the auditing field—all from the comfort of your own desk. This course unpacks the key principles, methodologies, and best practices internal auditors need to confidently assess organisational processes, identify risks, and support sound decision-making. Perfect for professionals aiming to enhance their career prospects or refresh their understanding of internal audit standards. Delivered entirely online, this course offers flexible learning tailored to fit around your schedule. You’ll explore the latest techniques in audit planning, risk assessment, and report writing, all presented in a clear and engaging manner. Plus, with CPD certification, your professional development gets a credible boost. Whether you’re new to auditing or brushing up your knowledge, this course strikes the right balance between thoroughness and accessibility—with just the right dash of wit to keep things interesting. Ready to sharpen your audit insight with no need to leave your chair? This training has you covered. Key Features CPDA Accredited Internal Auditor Training Instant FREE e-certificate Fully online, interactive Internal Auditor course with audio voiceover Self-paced learning and laptop, tablet, and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Free Gifts Life Coaching Course Enrol now in this Internal Auditor course to excel! Internal Auditor Course Curriculum Module 01: Auditing as a Form of Assurance Module 02: Internal Audit Procedures Module 03: Technology-based Internal Audit Module 04: Internal Control and Control Risk Module 05: Audit Interviews Module 06: Reporting Audit Outcome Module 07: UK Internal Audit Standards Module 08: Career as an Internal Auditor Accreditation This Internal Auditor is CPD Quality Standards (CPD QS) Accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Internal Auditor course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? This Internal Auditor course is suitable for anyone interested in: Information Systems Audit and Control Association Financial Investigator Forensic Accounting Professionals seeking to develop skills in auditing, including entry-level Internal auditors, financial controllers, risk managers, and compliance officers. Requirements No prior degree or experience is required to enrol in this Internal Auditor course. Career path Entry-level Internal Auditor: £25,000 - £35,000 per annum Internal Auditor with 3-5 years of experience: £35,000 - £50,000 per annum Senior Internal Auditor with 5+ years of experience: £50,000 - £80,000+ per annum Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.

Dealing with Difficult People: Dealing with Difficult People Online Are you struggling to deal with difficult people? Our Dealing with Difficult People: Dealing with Difficult People course can help improve your skills at work. Dealing with Difficult People: Dealing with Difficult People defy logic. Some are blissfully unaware of the negative impact they have on those around them, while others appear to derive satisfaction from causing chaos and pushing other people's buttons. In either case, they add unnecessary complexity, strife and worst of all stress. Stress has long been shown in studies to have a long-term negative impact on the brain. Stress is a formidable threat to your success; when it becomes uncontrollable, your brain and performance suffer. The majority of workplace stressors are easy to identify. Dealing with difficult people is always stressful. We've all been in situations where we had to interact with difficult people, whether at work, school, or over a business lunch. They do exist in the workplace, and the better you become at dealing with them, the happier you will be at work. Dealing with Difficult People: Dealing with Difficult People may take advantage of every opportunity to cause problems, or they may simply use passive resistance to waylay your best efforts to move your agenda forward. While you cannot control others, you can control and improve yourself by doing the following: Recognising your own attitudes and behaviours, creating coping strategies, managing your anger. Through this Dealing with Difficult People: Dealing with Difficult People course, you'll learn how to deal with aggressive, manipulative, undermining, prejudiced, or otherwise difficult people. Main Course: Dealing With Difficult People Course Free Courses included with Dealing with Difficult People: Dealing with Difficult People Course: Along with Dealing With Difficult People Course you will get free Level 5 Report Writing Course Along with Dealing With Difficult People Course you will get free Communication Skills Course Special Offers of this Dealing with Difficult People: Dealing with Difficult People Course: This Dealing with Difficult People: Dealing with Difficult People Course includes a FREE PDF Certificate. Lifetime access to this Dealing with Difficult People: Dealing with Difficult People Course Instant access to this Dealing with Difficult People: Dealing with Difficult People Course 24/7 Support Available to this Dealing with Difficult People: Dealing with Difficult People Course Dealing with Difficult People: Dealing with Difficult People Online Our Dealing with Difficult People: Dealing with Difficult People course has various modules to explain difficult people and their behaviours. How to communicate, solve problems and guide techniques are parts of this Dealing with Difficult People: Dealing with Difficult People course. You also know how to effectively deal with bosses and colleagues are explained in the Dealing with Difficult People: Dealing with Difficult People course. You will be able to make impossible situations possible with this Dealing with Difficult People: Dealing with Difficult People course. Who is this course for? Dealing With Difficult People: Dealing with Difficult People Online This Dealing with Difficult People: Dealing with Difficult People course is ideal for: Anyone involved in communication at work. Executive Assistants or Sales Reps Customer Support Agents Requirements Dealing with Difficult People: Dealing with Difficult People Online To enrol in this Dealing with Difficult People Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Dealing with Difficult People: Dealing with Difficult People Course. Be energetic and self-motivated to complete our Dealing with Difficult People: Dealing with Difficult People Course. Basic computer Skill is required to complete our Dealing with Difficult People Course. If you want to enrol in our Dealing with Difficult People Course, you must be at least 15 years old. Career path Dealing with Difficult People: Dealing with Difficult People Online The Dealing with Difficult People: Dealing with Difficult People course is intended to help you obtain the skills, knowledge, and career of your dreams!

Office Management: Office Management Online Introducing the Ultimate Office Management Online Course: Unlock Your Potential! Are you ready to take your career in office management to the next level? Look no further! Our comprehensive Office Management: Office Management Course is designed to equip you with the skills and knowledge you need to thrive in today's dynamic workplace. Whether you are an aspiring office manager or an experienced professional looking to enhance your abilities, this Office Management: Office Management course is your gateway to success. Our Office Management: Office Management course curriculum has been carefully crafted by industry experts to ensure that you gain practical, up-to-date knowledge in all areas of office management: office management. From effective communication strategies to project management techniques, you will acquire the essential skills employers value most. Upon successful completion of the Office Management: Office Management course, you will receive a prestigious Office Management: Office Management Certification. This valuable credential will set you apart from the competition, increase your employability, and demonstrate your commitment to professional development. By enrolling in our Office Management: Office Management Online Course, you are ensuring maximum exposure and credibility for your qualifications. So, enroll in our Office Management: Office Management Course today to make your mark in the world of office management: office management! Main Course: Office Management Course Courses including with this Office Management: Office Management Course. Course 01: Level 7 Leadership & Management Course 02: Executive PA Training Course 03: Time Management Course 04: Minute Taking Course Course 05: HR Management Course [Note: Free PDF certificate will provide as soon as completing the Office Management: Office Management Course] Office Management: Office Management Online Course Curriculum of Office Management Module 01: Fundamentals of Office Administration Module 02: Qualities of an Effective Administrator Module 03: Information regarding shipping and mail services Module 04: Ways to create effective plans and schedule. Module 05: Outline setting up conferences and meetings. Module 06: Business Writing Techniques Module 07: Management of time Module 08: An Overview of Stress Management Module 09: Telephone Business Proficiency Module 10: Communication Techniques Module 11: Strategies to manage conflicts. Module 12: Business etiquette guidelines Module 13: Basics of Microsoft Office Skills Certification of Office Management: Office Management After completing the Office Management: Office Management course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Assessment Method of Office Management: Office Management After completing Office Management: Office Management Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Who is this course for? Office Management: Office Management Online Learners can take this Office Management: Office Management course without any prior knowledge of this topic, and there are no age restrictions. As a result, anyone interested in Office Management: Office Management can enrol in the course. Requirements Office Management: Office Management Online To enrol in this Office Management: Office Management Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Office Management: Office Management Course. Be energetic and self-motivated to complete our Office Management: Office Management Course. Basic computer Skill is required to complete our Office Management: Office Management Course. If you want to enrol in our Office Management: Office Management Course, you must be at least 15 years old. Career path Office Management: Office Management Online After completing the Office Management: Office Management course/training, you will be able to confidently grasp specific knowledge and skills in order to improve yourself and enhance your skills for a career in the relevant employment sector.

Course description Bid writing requires attention to detail. Pay close attention to the specification and understand the bid process thoroughly. This short bite-sized course allows you to learn tips on how to prepare a bid that demonstrate why you or your company are the best choice for a particular project / grant / funding opportunity. Who is the course for? Whether you’re a novice or experienced at successful bids, bid writing courses allow you to gain a better insight into practical tools and strategies for achieving better outcomes. Remember, bid readiness sets the foundation for successful bidding. By following these steps, you’ll be better equipped to compete effectively and secure valuable contracts. What's the value of this course? Remember that bid writing requires careful planning, attention to detail, and adherence to guidelines. Avoiding these common pitfalls can significantly improve your chances of success.

Are you sitting comfortably? From postural issues to eye strain, the regular use of display screen equipment can cause many issues. Learn the steps to make the use of DSE as comfortable as possible with this 30-minute online Short Course. Are You Sitting Comfortably? Every day hundreds of thousands of us spend multiple hours using display screen equipment (DSE), a computer at work, a laptop or tablet at home, with little regard for the health problems it may cause us. From postural issues to eye strain, repetitive strain injury to headaches - if you’re using display screen equipment regularly you may suffer from one or more of these conditions. The good news is that there are steps you can take to make working with DSE as comfortable as possible. This course outlines the steps you should take. The Course Highfield’s Display Screen Equipment (DSE) Short Course is designed to ensure that users of DSE set up their work stations effectively and ergonomically, avoiding the health risks associated with their use. Learners undertaking this course will learn what DSE is, the health risks associated with its use, how to use DSE appropriately and the importance of correct posture and regular breaks. Finally, the course will outline the kind of support employers should provide for users of DSE at work. Areas Covered What is DSE? DSE health risks Workstation design Correct working position for DSE Portable equipment Identifying risks and safe working practices Eye tests and eyewear Assessing DSE

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.