518 Administration courses delivered Live Online

MySQL foundation training course description The MySQL foundation course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create, alter and drop a MySQL database. Write SQL statements. Use SQL expressions and functions. Create and alter tables, indexes and views. Use transactions. Grant and revoke access privileges. Export and import data. MySQL foundation training course details Who will benefit: Anyone who needs to access and work with a MySQL Database. Prerequisites: An understanding of databases and exposure to information technology in general would be useful. Duration 3 days MySQL foundation training course contents Database concepts What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases. Hands on using a database. Using the MySQL client What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts. Hands on Using the MySQL client. Basic SELECT The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators. Hands on querying the sample database. LIMIT, UNION and AGGREGATE functions The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause. Hands on using limit, union and aggregate functions. Subqueries and joins Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins. Numeric and character functions Function types, testing functions, numeric functions character functions. Hands on using numeric and character functions. Data, time and other functions Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions. Hands on using date, time and other functions. Databases and tables Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables. Hands on maintaining databases and tables. Indexes and views What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views. Hands on maintaining indexes and views. Managing data Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits. Hands on managing data. Access control Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking. Import and export Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line. Hands on export and import data.

Database design training course description Although this course mentions Microsoft Access the same course can be run with a variety of different databases. The duration of the course is dependent on the experience of the delegates. What will you learn Name and give 3 types of database structure. Explain the difference between standard SQL and different flavours. Use SQL statements to query databases. Use SQL statements to query and define databases. Describe the principles of relational database design and 3 types of relational joins. Normalise a given flat file table into relational tables. Database design training course details Who will benefit: Anyone who needs to be able to design an efficient, watertight database following the best practice of the principles of Relational Database design. Prerequisites: None. Duration 3 days Database design training course contents Database structure and terminology. Principles of Relational Database Design. Types of relationship. Normal Forms. Practical examples of relational database design. Hands-on creation of a database. On paper design a relational database applicable to the delegates work.

Coming soon! Embark on a dynamic journey towards administrative mastery with our Level 3 Business Administrator course. Tailored for individuals stepping into the vibrant world of business administration, be it through recent recruitment or a well-deserved promotion, this program is crafted to instil a distinctive set of skills and insights essential for success in the administrative landscape.

Duration 5 Days 30 CPD hours This course is intended for Channel Field Engineers Employees Overview After taking this course, you should be able to: Define Cisco Business TelePresence Solutions components and architectures Implement Cisco TelePresence Video Communication Server (Expressway) for basic and advanced video networks Implement Cisco TelePresence Management Suite (TMS) Configure Cisco Meeting Server Features Define integration of Cisco Collaboration Premise Solutions with Cisco Cloud, including Cisco Spark, Cisco Spark Hybrid, and WebEx Cisco Video Infrastructure Implementation (VII) v1.0 will provide you with the necessary knowledge and skills to implement a complete Cisco TelePresence solution, including TelePresence endpoints, integration of premise with cloud solutions, meeting solutions, and management software. It describes Cisco business TelePresence solutions and enables students to implement and troubleshoot basic and advanced TelePresence network solutions. Module 1: Advanced Cisco Expressway Features Lesson 1: Introducing Cisco Video Network Solutions Lesson 2: Exploring Cisco Expressway Basic Setup Lesson 3: Explaining Regular Expressions in a Cisco Expressway Environment Lesson 4: Deploying Components of Cisco Expressway Security Lesson 5: Exploring the Fundamentals of Subzones on a Cisco Expressway Lesson 6: Administering Call Control on a Cisco Expressway Lesson 7: Implementing Subzone Bandwidth Management on a Cisco Expressway Lesson 8: Implementing Zones on a Cisco Expressway Lesson 9: Exploring Clustering on the Cisco Expressway Lesson 10: Applying Troubleshooting on the Cisco Expressway Module 2: Advanced Cisco Meeting Server Features Lesson 1: Introducing the Cisco Meeting Server Lesson 2: Exploring Cisco Meeting Server API Configuration Lesson 3: Exploring Cisco Meeting Server Resilient and Scalable Deployments Lesson 4: Exploring Additional Features with Cisco Meeting Server Module 3: Cisco Collaboration Meetin gRoom Solutions wiht Cisco TelePresence Server Lesson 1: Introducing Cisco Collaboration Meeting Room Cloud, Premises, and Hybrid Products Lesson 2: Deploying the Cisco TelePresence Server and Cisco TelePresence Conductor Lesson 3: Applying Troubleshooting to Cisco CMR Premises Solutions Module 4: Cisco TelePresence Management Suite Solution Lesson 1: Explaining Cisco TMS Installation Lesson 2: Describing Cisco TMS Operation Lesson 3: Explaining Cisco TMS Conference Scheduling and Management Lesson 4: Configuring Permissions on Cisco TMS for Administration Lesson 5: Applying Troubleshooting to Cisco TMS Module 5: Cisco Cloud Solutions?WebEx and Spark Lesson 1: Introducing Cisco WebEx and Cisco Spark Cloud Solutions Lesson 2: Exploring Cisco Spark Administration Configuration Lesson 3: Deploying Cisco Spark Hybrid Services Lesson 4: Exploring Cisco Spark APIs and BOTs Configuration Module 6: Cisco TelePresence Content Server (Optional Module) Lesson 1: Examining Cisco TCS Operation and Configuration

Duration 5 Days 30 CPD hours This course is intended for Application Developers; Programmers, Sales and Pre Sales, Technical Support, Project Managers, Cisco customers, partners and employees involved in UCCE/CVP or CVP stand alone deployments Overview Upon completing this course, the learner will be able to meet these overall objectives: Introduction to the Java API, its capabilities and limitations - Practice - This course is applicable for any version of CVP and Studio. Introduction to Voice Elements and their complexity - creating every different Java component to extend Studio (see below) Overview of a UCCE with CVP Comprehensive Call Flow Module 1 Overview of a UCCE with CVP Comprehensive Call Flow Module 2 ICM routing scripts to route calls to CVP VXML Server applications Passing data (e.g., global variables) Parsing and evaluating data returned Queueing Assigning data to send to Finesse. Module 3 Writing Call Studio scripts (applications) Prompting Callers ? using pre-recorded audio; TTS text-to-speech; Say it Smart to format audio as digits, date, time, currency; input error reprompting Menus Collecting and confirming caller input, such as account numbers, dates of birth, etc Working with variables ? Session data, Element data, Call data, Local data (CVP11) Introduction to retrieving data from back end systems: SQL Database interaction ? using the Studio Database element to select data Web service interaction- Studio Web Services element for SOAP-web services and calling a simple REST web service Playing audio to callers during back-end data retrieval Catch events Working with counters, decisions, math Introduction to javascript for substrings and string length Setting VoiceXML properties affecting the gateway Multi-Language applications Module 4 Working with Version Control Module 5 ÿImplementing a Post Call Survey Module 6 Using the Studio Debugger to test applications within Studio Module 7 CVP Reporting Server and CVP CUIC Reports Best practices regarding naming elements and variables Configuring data to pass to the Reporting Server using OAMP Understanding Reporting Server tables Understanding the Application Summary CUIC reports Module 8 Administration covered throughout the course OAMP Operations Console to deploy applications to VXML Server Using Studio Documenter to print Visio-like diagrams of the application Configuring log file properties Using logs for debugging applications Administrative scripts for graceful updates or suspensions of the server Important log, debug, administration files Module 9 Cisco Courtesy Callback Detailed discussion of the CCB Call flow, the ICM script, and the 5 Studio scripts used for Courtesy Callback.

Duration 3 Days 18 CPD hours This course is intended for This course is intended for experienced administrators with a background in either software development or system administration. Team leaders, lead developers, and other accidental Team Foundation Server administrators are also encouraged to take this course. This course will also help a student prepare for the relevant Microsoft certification exam. Overview At course completion, attendees will have had exposure to: - TFS editions and components - Supported topologies and environments - Must-have TFS administration tools - Hardware and software requirements - Required service accounts and permissions - Installing Team Foundation Server - Configuring Team Foundation Server - Managing relevant SQL Server components - Managing relevant SharePoint components - Installing and using Team Explorer - Team project collections and team projects - Using and customizing process templates - TFS licensing and Client Access Licenses - Connecting and using Microsoft Excel & Project - Installing and using Team Explorer Everywhere - Integrating TFS and SharePoint - Using the TFS web portal - Git and TFVC version control systems - Basic and advanced version control workflows - Configuring and using code search - Controlling access to version controlled items - Command-line and third party tools - Configuring automated builds - Deploying and using Visual Studio agents - Configuring agent pools and queues - Creating and queuing automated builds - Configuring Package Management - Configuring Release Management - Creating a release definition - Creating and deploying a release - Strategies for upgrading and migrating to TFS - Integrating TFS with other systems and data - High availability and scalability options - Capacity planning and disaster recovery - Backing up, restoring, and moving TFS data - Managing the data warehouse - Using PowerShell to manage TFS - Customizing Team Foundation Server - Extending Team Foundation Server Provides students with the knowledge and skills to deploy, configure, and manage Microsoft Team Foundation Server 2019 and related software components. Introduction to Team Foundation Server Introduction to Team Foundation Server Editions, components, and configurations Visual Studio Team Services comparison TFS' support of Application Lifecycle Management TFS administrator responsibilities and tasks ?Must-have? tools of a TFS administrator Planning and Deploying TFS Planning the deployment System requirements, software, and accounts Installing and configuring TFS Installing Team Explorer Troubleshooting Configuring TFS Administrator roles and tools Managing team project collections Managing team projects Managing process templates Securing TFS, SharePoint, and SQL Server Renaming and deleting a team project Client Applications TFS Client Access Licenses (CAL) Team Explorer and the web portal Microsoft Excel and Microsoft Project SharePoint project portal Team Explorer Everywhere Command-line and 3rd party tools Version Control Overview of Git and TFVC version control systems Integration with Visual Studio Using TFVC and Git version control Basic and advanced workflows Controlling access to version control Command-line tools and utilities TFS Proxy, MSSCCI Provider, and TFS Sidekicks Building and Releasing Overview of the Visual Studio build system Build agents, agent pools, agent queues Creating and queuing a build Monitoring, and managing a build Securing the build process Running tests as part of the build Overview of Package Management Overview of Release Management Defining, creating, and deploying a release Upgrading, Migrating, and Integrating Upgrading Team Foundation Server In-place vs. migration upgrade Performing post-upgrade tasks Migrating work items Migrating items under version controlled Integrating with Team Foundation Server Custom and 3rd party solutions Advanced Administration Monitoring the health of Team Foundation Server Web-based diagnostic tools Options for scalability and high availability Disaster recovery, backup, and restore Moving Team Foundation Server Managing the data warehouse Using PowerShell to manage TFS Customizing and Extending Customizing vs. extending Customizing a process template Customizing a work item type Creating default work items Creating and using a global list Using Witadmin.exe Using work item templates Creating a custom report Using the REST API to extend Team Foundation Server Additional course details: Nexus Humans Administering Team Foundation Server 2017 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 Administering Team Foundation Server 2017 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.

Duration 5 Days 30 CPD hours This course is intended for This course is designed for technical professionals who need to know how to deploy and manage a Cisco Firepower NGIPS in their network environment. Security administrators Security consultants Network administrators System engineers Technical support personnel Channel partners and resellers Overview After taking this course, you should be able to: Describe the components of Cisco Firepower Threat Defense and the managed device registration process Detail Next-Generation Firewalls (NGFW) traffic control and configure the Cisco Firepower system for network discovery Implement access control policies and describe access control policy advanced features Configure security intelligences features and the Advanced Malware Protection (AMP) for Networks implementation procedure for file control and advanced malware protection Implement and manage intrusion and network analysis policies for NGIPS inspection Describe and demonstrate the detailed analysis techniques and reporting features provided by the Cisco Firepower Management Center Integrate the Cisco Firepower Management Center with an external logging destination Describe and demonstrate the external alerting options available to Cisco Firepower Management Center and configure a correlation policy Describe key Cisco Firepower Management Center software update and user account management features Identify commonly misconfigured settings within the Cisco Firepower Management Center and use basic commands to troubleshoot a Cisco Firepower Threat Defense device This course shows you how to deploy and use Cisco Firepower© Next-Generation Intrusion Prevention System (NGIPS). This hands-on course gives you the knowledge and skills to use the platform features and includes firewall security concepts, platform architecture and key features; in-depth event analysis including detection of network-based malware and file type, NGIPS tuning and configuration including application control, security intelligence, firewall, and network-based malware and file controls; Snort© rules language; file and malware inspection, security intelligence, and network analysis policy configuration designed to detect traffic patterns; configuration and deployment of correlation policies to take action based on events detected; troubleshooting; system and user administration tasks, and more. This course helps you prepare to take the exam, Securing Networks with Cisco Firepower (300-710 SNCF), which leads to CCNP Security and Cisco Certified Specialist ? Network Security Firepower certifications. The 300-710 SNCF exam has a second preparation course as well, Cisco© Securing Networks with Cisco© Firepower Next Generation Firewall (SSNGFW). You can take these courses in any order. Course Outline Cisco Firepower Threat Defense Overview Cisco Firepower NGFW Device Configuration Cisco Firepower NGFW Traffic Control Cisco Firepower Discovery Implementing Access Control Policies Security Intelligence File Control and Advanced Malware Protection Next-Generation Intrusion Prevention Systems Network Analysis Policies Detailed Analysis Techniques Cisco Firepower Platform Integration Alerting and Correlation Policies Performing System Administration Troubleshooting Cisco Firepower

Women in Healthcare Leadership Workshop Our Aims For This Workshop: Become clear about your leadership style and philosophy. Understanding how to navigate yourself and your team in a VUCA environment. How to communicate with presence and impact. Topic 1 Foundations For Effective Leadership Develop your leadership story – (know yourself) Your values, influences and leadership philosophy Clear vision and purpose as a leader Adapting style to suit the context Topic 2 Leading Through Rapid Change (Uncertainty) Exploring the VUCA environment (Volatile, Uncertain, Complex, Ambiguous) Understanding the psychological process of change Resilience and stress management Topic 3 Communication Skills For Influential Leaders How to prepare to be present so you have a presence Explore and understand your own innate communication style Importance of voice, pace, trust, and rapport THE FACILITATOR Ruth Sangale Ruth has 20 years HR and OD experience in the public and private sectors, leaving the NHS in 2012 to set up her own business “Enjoy Work” and specialise in Creative Leadership development and executive coaching. She works internationally coaching and running residential leadership programs for global organisations such as UNICEF, WHO, UN Women, and PLAN International and charitable NGOs in a range of countries including, Afghanistan, Brazil, India, Kenya, and Belize. In the UK she designs and delivers workshops for mostly the NHS, on topics such as career development, resilience and positive psychology, feedback skills, coaching skills for leaders and team development. She is an ICF-accredited coach and has an M Sc in Innovation, Creativity and Leadership. In her work she uses creative tools such as drama, visualization, drawing, mindfulness and storytelling to stimulate creative thinking and develop leadership capability. She has two daughters and in her free time loves hiking, climbing mountains and salsa dancing. THE PANEL Sam Foster - Chief Nursing Officer - Oxford University Teaching Hospitals Sam joined the Board of Oxford University Hospitals NHSFT in September 2017 as an experienced Chief Nurse who previously worked at the Heart of England NHS Foundation Trust where she held the role of Chief Nurse for four years. Sam has also worked in a number of Trusts in clinical, operational and educational roles. Sam's portfolio includes the professional leadership and education of over 5,000 Nurses, Midwives and AHPs. In addition to the Executive leadership of the Trust Facilities and PFI Services, she is accountable for the Estates and delivery of the capital program. Sam leads the Urgent Care program across the Oxfordshire system. Avey Bhatia - Chief Nursing Officer - Guys & St Thomas’ NHS Trust Avey Bhatia is Chief Nurse at Guy’s and St Thomas’ Trust. Avey returned to the Trust as Chief Nurse in November 2020, having trained as a critical care nurse at St Thomas’ in the early part of her career. Avey qualified in 1991 and her clinical experience includes theatres, general intensive care, coronary care and cardiothoracic nursing. She held various staff nurse and sister posts at hospitals in London before becoming Chief Nurse and Director of Infection Prevention and Control at St George's University Hospitals NHS Foundation Trust in 2017.  Avey holds a postgraduate diploma in health services management and a Masters in Public Administration. She is also the Trust’s Director of Patient Experience, and the executive lead for adults’ and children’s safeguarding, and for infection, prevention and control. Beyond Guy’s and St Thomas’, Avey is Vice President for the Florence Nightingale Foundation and Honorary Vice President of The Nightingale Fellowship. She is a Trustee for the St John of Jerusalem Eye Hospital Group.  Caroline Alexander CBE - Group Chief Nurse - Barts NHS Trust Caroline graduated as a nurse in 1987 from Edinburgh University (BSc/RGN) and has an MSc in Nursing Studies from South Bank University (2001). From 1987 to 1993 she specialised in nursing older people in Edinburgh and then London at Guy’s Hospital as a ward sister. Caroline then worked for the Foundation of Nursing Studies for three years supporting nurses to use research in practice. In 1998 Caroline returned to the NHS and worked in Tower Hamlets in a range of roles within older people’s services. In 2005, Caroline took up her first Director post, as Director of Nursing and Therapies within Tower Hamlets PCT. With the clustering of PCTs in London in 2011, she took on the Director of Nursing and Quality within NHS East London and the City initially and then within NHS North East London when the clusters merged in 2012. until she joined NHS England as Regional Chief Nurse for London in April 2013. Caroline took up her current role of Chief Nurse for Barts Health in March 2016. Caroline was a 2008 Florence Nightingale Leadership Scholar and has been awarded Honorary Doctorates from City, University of London in 2017, Middlesex University in 2018 and University of East London in 2021. She is a Trustee of the Foundation of Nursing Studies. In 2020 she was made a CBE in the Queen’s Birthday Honours. Who will attend? Emerging Leaders looking to step into management roles Current Leaders looking to progress into senior management roles This workshop is open to any woman who works in health care and wants to take her next step in their career; women include trans women and non-binary people who are comfortable in a female-centered group. Group Rate Discounts 2-3 people, 7% discount 4+ people, 20% discount We have two group rates which you can take advantage of depending on the size of the group you wish to book: Option 1️⃣ Groups between 2 & 3 are eligible for the 7% Discount. Please use this code at checkout: GROUP 2+  Option 2️⃣ For groups of over 4+ attendees, the eligible discount is 20%. Please use this code at checkout: GROUP 4+  Where do I add the discount code? 

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course is as follows: System Engineers System Administrators Architects Channel Partners Overview Upon completing this course, the learner should be able to meet these overall objectives: Describe Cisco Webex Teams Comprehend Cisco Webex Meetings Understand Cisco Webex Messaging Recognize Cisco Webex Teams Calling Appreciate Cisco Webex Teams Care Explain Cisco Webex teams Management and Administration Describe Cisco Webex Teams Service Availability, Ordering, and Support Understand Cisco Webex Teams Board Cisco Webex Teams is an app-centric, cloud-based service that provides a complete collaboration suite for teams to create, meet, message, call, care, whiteboard, and share, regardless of whether they?re together or apart?in one continuous work stream before, during, and after meetings. Being able to understand how this works and what the features are is the key focus of this 2-day course. NterOne?s Webex Teams Collaboration Workshop should be taken by students who have a working understanding of Cisco Collaboration Products. This Cisco Webex Teams Workshop enables learners to describe Cisco Webex Teams, comprehend Cisco Webex Teams Meetings, and grasp Cisco Webex Teams Messaging, among much more. This workshop is intended to be taken by system engineers, system administrators, architects, and channel partners. Learn more below. Cisco Webex Teams Overview What is Cisco Webex Teams Webex Teams Delivery Webex Teams Security Webex Teams Collaboration Webex Teams API Meetings Messaging Calling Cisco Webex Teams Spaces Cisco Webex Teams Hybrid Services Cisco Webex Teams Benefits Cisco Webex Team Meetings Basic Meetings Instant Messages Schedule Meetings Cisco Webex Teams Advanced Meetings Overview Webex Integration Personal Room Cisco Webex Teams Desk and Room Devices and the Cisco Smart Board Cisco Webex Teams Conferencing Cisco Webex Teams Board and Room Device Setup and Use Three ways to enable pairing Cisco WebEx Teams Messaging Cisco Webex Teams Messaging Overview Key Benefits of Cisco Webex Teams Messaging Cisco Webex Teams Messaging Features Cisco Webex teams (feature in the app) Use Cases Cisco Webex Teams Board Advanced Interactive Whiteboard No Network, Bluetooth needed Microphones Voice-Tracking Technology Webex Teams Board Application Suite Camera Webex Teams APIs Any Board, anywhere Messaging Setup Cisco Webex Teams Calling Overview Traditional Calling Features in Cisco Webex Teams Features and Benefits of Cisco Webex Teams Calling Benefits of Mobility and Collaboration Features of Cisco Webex Teams PSTN Calling Phone Support Use Cases Cisco Webex Teams Care Overview Embedding Experience Cisco Webex Teams Management and Administration Overview Cisco Cloud Collaboration Management Features and Benefits Management Security Portal Cisco Webex Teams Service Availability, Ordering, and Support Country Availability Language Support Ordering Support Cisco Capital

Oracle SQL Advanced training course description The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features. What will you learn Retrieve data using correlated subqueries, in-line views and multi-column subqueries. Use the WITH Clause. Inserting and Updating Rows Using Complex Subqueries Create Hierarchical Queries. Use ROLLUP, CUBE and GROUPING SETS group by enhancements. Implement the GROUPING and GROUPING_ID functions. Manage large data sets. Insert data conditionally and unconditionally. Merge Rows in a Table. Create TIMESTAMP and INTERVAL Datatypes. Use TIMESTAMP, TIMEZONE and INTERVAL functions and literals. Use regular expressions and implement related functions. Manage objects with the data dictionary. Manage schema objects. Perform flashback operations. Create and using external tables. Control user access to database objects. Oracle SQL Advanced training course details Who will benefit: Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database. Prerequisites: Delegates should have attended the Oracle SQL course or have a similar level of experience. Duration 2 days Oracle SQL Advanced training course contents Retrieve data using subqueries ANY, ALL or SOME operators, Correlated subqueries, In-Line views, The Exists operator, The WITH clause, Multi-Column subqueries, Insert and update using a query, Correlated update and delete. Hierarchical queries Hierarchical data, The START WITH and CONNECT BY clauses, The LEVEL pseudo-column, Sequencing the output, Eliminating nodes and branches. Enhanced grouping features Review of basic grouping concepts, The ROLLUP and CUBE extensions, The GROUPING SETS extension, Using the GROUPING and GROUPING_ID functions. Manage large data sets Multi-table Inserts, Conditional and unconditional Inserts, Merging data into a table, Table and view based merge, A sub query based merge. Flashback technology Flashback query, The AS clause, Flashback table, Flashback drop. Date, time and time zone support Date, Timestamp and Interval datatypes, Handling dates and times, Handling intervals, Date, timestamp and interval functions and literals, Related NLS parameters. Regular expression support Regular expression notation, Character matching, Repetition operators, Sub expression grouping, Regular expression functions. Manage objects with the Data Dictionary The Data Dictionary, Useful Data Dictionary tables, Using the Data Dictionary. Manage schema objects Column operations, Constraint operations, Creating and dropping Indexes, B-Tree indexes, Function based indexes, Descending indexes, Creating and using external tables. Access control System privileges and roles, Create users, Alter user details, Grant and revoke object privileges.