4629 Courses in Cardiff delivered Online

Duration 5 Days 30 CPD hours This course is intended for This course is intended for anyone responsible for conf iguring, maintaining, and troubleshooting Symantec Data Loss Prevention. Additionally, this course is intended for technical users responsible for creating and maintaining Symantec Data Loss Prevention policies and the incident response structure. Overview At the completion of the course, you will be able to: Enforce server, detection servers, and DLP Agents as well as reporting, workflow, incident response management, policy management and detection, response management, user and role administration, directory integration, and filtering. This course is designed to provide you with the fundamental know ledge to configure and administer the Symantec Data Loss Prevention Enforce platform. Introduction to Symantec Data Loss Prevention Symantec Data Loss Prevention overview Symantec Data Loss Prevention architecture Navigation and Reporting Navigating the user interface Reporting and analysis Report navigation, preferences, and features Report filters Report commands Incident snapshot Incident Data Access Hands-on labs: Become familiar with navigation and tools in the user interface. Create, filter, summarize, customize, and distribute reports. Create users, roles, and attributes. Incident Remediation and Workflow Incident remediation and w orkf low Managing users and attributes Custom attribute lookup User Risk Summary Hands-on labs: Remediate incidents and configure a user?s reporting preferences Policy Management Policy overview Creating policy groups Using policy templates Building policies Policy development best practices Hands-on labs: Use policy templates and policy builder to configure and apply new policies Response Rule Management Response rule overview Configuring Automated Response rules Configuring Smart Response rules Response rule best practices Hands-On Labs: Create and use Automated and Smart Response rules Described Content Matching DCM detection methods Hands-on labs: Create policies that include DCM and then use those policies to capture incidents Exact Data Matching and Directory Group Matching Exact data matching (EDM) Advanced EDM Directory group matching (DGM) Hands-on labs: Create policies that include EDM and DGM, and then use those policies to capture incident Indexed Document Matching Indexed document matching (IDM) Hands-on labs: Create policies that include IDM rules and then use those policies to capture incidents Vector Machine Learning Vector Machine Learning (VML) Hands-on labs: Create a VML profile, import document sets, and create a VML policy Network Monitor Review of Network Monitor Protocols Traffic filtering Network Monitor best practices Hands-On Labs: Apply IP and L7 filters Network Prevent Network Prevent overview Introduction to Network Prevent (Email) Introduction to Network Prevent (Web) Hands-On Labs: Configure Network Prevent (E-mail) response rules, incorporate them into policies, and use the policies to capture incidents Mobile Email Monitor and Mobile Prevent Introduction to Mobile Email Monitor Mobile Prevent overview Configuration VPN configuration Policy and Response Rule Creation Reporting and Remediation Troubleshooting Network Discover and Network Protect Network Discover and Network Protect overview Configuring Discover targets Configuring Box cloud targets Protecting data Auto-discovery of servers and shares Running and managing scans Reports and remediation Network Discover and Network Protect best practices Hands-on labs: Create and run a filesystem target using various response rules, including quarantining Endpoint Prevent Endpoint Prevent overview Detection capabilities at the Endpoint Configuring Endpoint Prevent Creating Endpoint response rules Viewing Endpoint Prevent incidents Endpoint Prevent best practices Managing DLP Agents Hands-on labs: Create Agent Groups and Endpoint response rules, monitor and block Endpoint actions, view Endpoint incidents, and use the Enforce console to manage DLP Agents Endpoint Discover Endpoint Discover overview Creating and running Endpoint Discover targets Using Endpoint Discover reports and reporting features Hands-on labs: Create Endpoint Discover targets, run Endpoint Discover targets, and view Endpoint Discover incidents Enterprise Enablement Preparing for risk reduction Risk reduction DLP Maturity model System Administration Server administration Language support Incident Delete Credential management Troubleshooting Diagnostic tools Troubleshooting scenario Getting support Hands-on labs: Interpret event reports and traffic reports, configure alerts, and use the Log Collection and Configuration tool Additional course details: Nexus Humans Symantec Data Loss Prevention 14.0 - Administration 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 Symantec Data Loss Prevention 14.0 - Administration 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.

Step confidently into one of the fastest-growing sectors in science, care, and veterinary services. The Animal Technician 20-in-1 Premium Bundle equips you with a powerful mix of biological, technical, and care-focused training—making you stand out as a highly employable, multi-skilled professional in animal labs, clinics, and research environments. Description Today’s animal technician roles demand more than compassion—they require scientific know-how, hygiene discipline, and strong reporting and communication abilities. Whether you’re looking to work in veterinary practices, biomedical labs, animal care facilities, or public health settings, this all-in-one training bundle brings together the most in-demand subjects employers seek. From biology and chemistry to public health, dog grooming, and nutrition, each topic enhances your profile across multiple job sectors. Add in practical skills like stress management, self-organisation, and problem solving, and you’re not just another applicant—you’re a complete package. If you’re aiming for a career that blends science, animal care, and job security, this is your opportunity. These 20 career-aligned courses are bundled together for a limited time—get hired faster by training smarter. FAQ Q: Who is this course bundle designed for? A: Aspiring animal technicians, veterinary assistants, pet care specialists, lab techs, and biomedical trainees. Q: Will this improve my chances of being hired? A: Absolutely. It offers a blend of technical, care, and professional skills that align with real hiring needs. Q: What industries does this bundle support? A: Veterinary services, biomedical labs, animal research, public health, and nutrition-based care. Q: Is this suitable for beginners? A: Yes—it's ideal for both newcomers and those looking to strengthen their current credentials. Q: Can I use this to work in labs or clinics? A: The topics reflect the core competencies required in both settings, making you far more hireable. Q: Why should I enrol now? A: This bundle offers massive value for a limited time. Miss it, and you'll likely pay more for less later.

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Course Overview Movie - Course Overview 00:06:00 Building Your Virtual Lab Environment Video - Downloading ISO and OVA Fles for VirtualBox 00:08:00 Video and Lab - Creating Virtual Install of Server 2012r2 00:08:00 Video and lab -Create a Virtual Install Of Windows 10 VirtualBox 00:16:00 Video - Taking A Snapshot Of Your Current Configuration 00:04:00 Installing and Configuring Active Directory Video and Lab - Preparing Your Network For Active Directory 00:08:00 Video and Lab - Preparing Server 2012 r2 for Promotion to a Domain Controller 00:10:00 Video and Lab - Join Server 2012 R2 Core to an Existing Domain 00:06:00 Video and Lab - Join a Windows 10 Workstation to a Microsoft Domain 00:15:00 Video and Lab - Promote Server Core to a Domain Controller 00:14:00 Video and Lab- Creating a Server 2012 r2 RODC 00:11:00 Domain Naming System (DNS) Video - Create a Secondary Or Backup DNS Server 00:07:00 Create a DNS Reverse Lookup Zone 00:08:00 Video and Lab - Create a GlobalNames zone * (Requires ADDS being present) 00:11:00 Video - Create a New DNS Host Record 00:02:00 Video - Create a Host Record For a New Website In Microsoft DNS 00:04:00 Video - Creating a DNS MX record 00:04:00 Dynamic Host Configuration Protocol (DHCP) Video and Lab - Install and Configure DHCP on Server 2012 00:11:00 Video - Install the DHCP Role Using PowerShell 00:09:00 Video - How to Authorize/Unauthorize a DHCP Server 00:03:00 Video - How To Edit The Default Gateway Settings In DHCP 00:03:00 Video - Edit DNS Server List In DHCP 00:04:00 Video and Lab - Configuring a DHCP SuperScope 00:04:00 Video and Lab - Manage DHCP Failover in Server 2012 R2 00:08:00 Video - Edit a DHCP Scope 00:03:00 Backup And Restore The DHCP Database 00:03:00 Group Policy Video - Creating a Group Policy Object 00:07:00 Video and Lab - Fine-Grained Password Policy in Windows Server 2012 00:10:00 Video and Lab - Configure Folder Redirection in Window Server 2012 R2 00:11:00 Video and Lab - Creating a Mapped Drive Using Group Policy 00:04:00 Video and Lab - Managing User Desktops Using Group Policy 00:06:00 Video - Prevent Automatic Logoff Due To Inactivity 00:03:00 Video - How To Edit Group Policy Objects To Affect a User 00:03:00 Video - How To Edit a Group Policy Object To Affect a Computer 00:04:00 Video - Backup And Restore Group Policy Objects In Active Directory 00:03:00 Video - Force Screensaver and Timeouts Using Group Policy 00:07:00 Video- Change Users Desktop Background Using Group Policy 00:09:00 Disk Management Video - How To Shrink Or Extend a Volume in Windows Server 2012 00:04:00 Video - How To Format a Volume With ReFS in Windows Server 2019 00:04:00 Video - How To Format a Volume With FAT32 in Windows Server 2019 00:02:00 Print Services TCP/IP Printing Overview 00:08:00 Installing Print Services on Server 2012 R2 00:14:00 Video and Lab - Installing a Network Printer Onto a Windows Client 00:03:00 Video and Lab - Adding a Printer to the Network Using TCP/IP 00:10:00 Video - Printer Pooling 00:06:00 Active Directory Maintenance Video and Lab - Creating a Custom Microsoft Management Console (MMC) 00:06:00 Video and Lab - Creating and Managing Objects in Active Directory 00:14:00 Video and Lab - Performing a Full Backup and Recovery of Server 2012 R2 00:06:00 Video - Rearm the 180-Day Evaluation Period for Wondows Server 00:03:00 Video - Rearm the 30-day Evaluation for Windows 10 00:03:00 Video and Lab - Disable the Internet Explorer Enhanced Security 00:03:00 Video and Lab - Performing an Offline Defragmentation of the Directory Database 00:04:00 Video - Creating a Mapped Drive in Server 2012r2 00:04:00 Video - Create a Heads-Up Display Using BgInfo 00:08:00 Troubleshooting Video - Allow PING Packets through for Server 2012, 2016 and 2019 00:05:00 Video and Lab - Troubleshooting Internet Connectivity 00:16:00 Video - NSLookup 00:05:00 Video - Windows Reliability Monitor (RELI) 00:04:00 Overview of Windows Sysinternal Tools 00:08:00 Video - Overview of Sysinternal's Process Explorer 00:15:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Financial transactions don’t just move money—they tell stories. Stories that, if read carefully, can reveal patterns, flags, or even risks. This course is designed for individuals who wish to develop their understanding of how financial movements are observed, interpreted, and evaluated in structured environments. It offers a strong foundation in the methods used to track suspicious activities, detect anomalies, and report transactions that could point to deeper financial concerns. Whether you’re looking to enter the world of financial scrutiny or simply sharpen your knowledge, this course gives you the insight to navigate regulatory frameworks, understand key identifiers, and follow the trail with a keener eye. Learn how professionals identify red flags and assess data without missing a beat—entirely online, with your schedule in mind. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01: Introduction to Transaction Monitoring Module 02: Regulatory Framework and Risk-Based Approach Module 03: Transaction Monitoring Systems and False Positives Reduction Module 04: Red Flags and SAR Module 05: Terrorism Financing, Name Screening, and Record-Keeping Module 06: Future of Transaction Monitoring Learning Outcomes Master regulatory compliance for financial vigilance. Apply risk-based strategies to monitor transactions effectively. Identify and reduce false positives in monitoring systems. Recognize red flags and prepare suspicious activity reports. Navigate counter-terrorism financing and name screening. Implement meticulous record-keeping practices. Accreditation This course 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. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring financial analysts Compliance officers Risk managers AML (Anti-Money Laundering) professionals Financial investigators Banking and financial sector employees Individuals seeking career advancement in financial surveillance Career path Compliance Officer Financial Analyst Risk Manager AML Specialist Financial Investigator Banking Executive Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Information on the risks and practical advice to address them TSC's eBooks, whitepapers, and reports cover some of the most important risks in information and cyber security — risks that constantly challenge information and cyber security professionals who work tirelessly to reduce them across their organisations and home users alike.

Overview Breaches in corporate information can cost companies millions, both in terms of financial loss and reputation damage. 'Workplace Confidentiality' is not just a course; it is a critical arsenal in equipping professionals with the knowledge and strategies to navigate this delicate terrain. Delve into the 'Introduction to Workplace Confidentiality', where the foundational concepts are laid bare, preparing you for the intricate nuances of 'Business Etiquette and Types of Confidentiality'. Understand deeply 'The Importance of Confidentiality' before diving into actionable strategies in 'Preventing Confidentiality Breach'. Finally, empower every employee with tools and techniques in 'How Employees Can Protect Confidential Information'.  Secure your place in this essential course and fortify your professional stature in the competitive corporate world. How will I get my certificate? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Workplace Confidentiality. It is available to all students, of all academic backgrounds. Requirements Our Workplace Confidentiality is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 6 sections • 6 lectures • 00:52:00 total length •Introduction to Workplace Confidentiality: 00:05:00 •Business Etiquette and Types of Confidentiality: 00:11:00 •The Importance of Confidentiality: 00:06:00 •Maintaining Confidentiality with Co-workers: 00:11:00 •Preventing Confidentiality Breach: 00:08:00 •How Employees Can Protect Confidential Information: 00:11:00

🚀 Unleash Your Productivity Potential with 'Optimizing Productivity Through Slack Efficiency' 🚀 Are you drowning in a sea of endless Slack messages, struggling to keep your tasks organized and team communication streamlined? It's time to transform the way you work and skyrocket your productivity! Introducing our game-changing online course:   🌟 Optimizing Productivity Through Slack Efficiency 🌟   🚀 Unlock the Power of Slack: Master the Art of Collaboration Discover insider secrets to turn Slack from a communication tool into a productivity powerhouse. Learn how to harness the full potential of channels, threads, and integrations to create a seamless workflow that propels your projects forward. 🔥 Boost Your Team's Efficiency: Strategies for Effective Communication Say goodbye to information overload and hello to clarity! Dive into proven techniques for crafting concise messages, managing notifications, and facilitating focused discussions. Transform your team into a well-oiled machine that accomplishes more in less time. 🎯 Time-Saving Hacks: Work Smarter, Not Harder Explore a treasure trove of time-saving hacks that will revolutionize the way you work in Slack. From keyboard shortcuts to automation tools, we'll teach you how to navigate Slack effortlessly and reclaim precious hours in your day. 🌐 Global Collaboration: Connecting Teams Across Time Zones Crush geographical boundaries and optimize collaboration in a distributed world. Learn strategies for managing time zone differences, scheduling effective meetings, and keeping everyone in the loop, no matter where they are. 🔒 Security and Compliance: Ensure Confidentiality in Every Message Protect sensitive information and maintain compliance effortlessly. Our course covers best practices for secure communication, setting up permissions, and keeping your team's data safe within the Slack ecosystem.   🎓 Why Choose Our Course? ✅ Expert Guidance: Learn from industry experts with years of experience in maximizing productivity through Slack. ✅ Practical Insights: Gain real-world strategies and actionable tips that you can implement immediately. ✅ Interactive Learning: Engage with hands-on exercises, case studies, and live Q&A sessions to solidify your understanding. ✅ Lifetime Access: Enjoy unlimited access to course materials, updates, and a supportive community of fellow learners.   🚨 Don't miss out on the opportunity to revolutionize the way you work! Join 'Optimizing Productivity Through Slack Efficiency' now and take the first step towards a more efficient, collaborative, and successful future. ⏰ Time is of the essence. Enroll today and supercharge your productivity with Slack mastery! ⏰   🚀 Elevate Your Productivity, Transform Your Workflow, Master Slack Efficiency! 🚀 Course Curriculum Basic Overview 00:00 Pricing 00:00 Account Opening 00:00 Profile and Multiple Workspaces 00:00 Desktop and Mobile Software 00:00 Customizing the Workspace - Part 1 00:00 Customizing the Workspace - Part 2 00:00 Settings and Preferences 00:00 Settings and Preferences - Part 2 00:00 Members and User Groups 00:00 Built In Recordings 00:00 Zapier Integrations 00:00 Creating Channels - Part 1 00:00 Creating Channels - Part 2 00:00 Sending Direct Messages 00:00 Creating Message Posts - Part 1 00:00 Creating Message Posts - Part 2 00:00 Analytics 00:00 Search 00:00 Conclusion 00:00 Advance Overview and Skype Integration 00:00 Meeting Live - Zoom Integration 00:00 Sharing Meeting Recordings - YouTube Integration 00:00 Sharing Meeting Recordings - YouTube Integration - Part 2 00:00 Sharing Google Docs - Part 1 00:00 Sharing Google Docs - Part 2 00:00 Sharing Google Calendar 00:00 WordPress Website Updates with Slack - Part 1 00:00 WordPress Website Updates with Slack - Part 2 00:00 Slack Storage - Google Drive 00:00 Slack Storage - Dropbox 00:00 Client and Customer Management - Stripe 00:00 Client and Customer Management - Paypal 00:00 Client and Customer Management - Getresponse 00:00 Client and Customer Management - Mailchimp 00:00 LIve Example - Channel Creation 00:00 Live Example - Team Invitations 00:00 Live Meeting Creation 00:00 Live Meeting Archive 00:00 Conclusion 00:00

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Become a certified auditor and gain expertise in governing an organization effectively with the Internal Auditor Beginner Course.

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.