534 Courses in Cardiff delivered Live Online

Supporting Microsoft SQL server course description A concise hands on course enabling delegates to manage and administer a Microsoft SQL server database. What will you learn Install SQL server. Backup SQL server databases. Recover SQL server databases. Secure SQL server databases. Perform routine maintenance. Automate tasks. Supporting Microsoft SQL server course details Who will benefit: Anyone working with Microsoft SQL server Prerequisites: Supporting Windows server. Duration 3 days Supporting Microsoft SQL server course contents SQL server introduction Platform, Tools, services. Installation. Creating databases. Backups Back up types, transaction logging, restoring from a backup: Full database, individual files. Security Users, server roles, database roles. Permissions. Monitoring Routine database maintenance. Performance data. Jobs and alerts The SQL server agent, database mail, alerts, jobs.

Database fundamentals training course description This three-day training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. What will you learn Describe core database concepts. Create database objects. Manipulate data. Describe data storage. Administer a database. Create a relational database consisting of 3 related tables. Database fundamentals training course details Who will benefit: Those working with databases. Prerequisites: None. Duration 3 days Database fundamentals training course contents Understanding core database concepts Flat-type databases, hierarchical databases, relational databases, database fundamentals, relational database concepts, using the SQL Server Management Studio Interface. Data Manipulation Language (DML), Data Definition Language (DDL), using DDL statements. Creating database objects Defining data types, using built-in data types, using exact numeric data types, using approximate numeric data types. Creating and using tables. Creating views. Creating stored procedures, SQL injections. Manipulating data Using Queries to select data, combining conditions, using the BETWEEN clause, using the NOT clause, using the UNION clause, using the EXCEPT and INTERSECT clauses, using the JOIN clause. Using Queries to insert data, Inserting data. Updating data and databases, Using the UPDATE statement. Deleting data, Using the DELETE statement, truncating a table with TRUNCATE TABLE, deleting a table with DROP TABLE, using referential integrity. Understanding data storage Normalising a database, normalization, first normal form, second normal form, third normal form, fourth normal form, fifth normal form. Primary, foreign and composite keys, clustered and non-clustered indexes, creating a non-clustered table. Administering a Database Securing Databases, server-level security, database-level security, Windows security, SQL authentication, database server roles, granting access to a database, fixed database roles, object permissions, managing roles, ownership chains, reviewing a sample security model. Backing up and restoring databases, recovery models, backup devices.

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.

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course is as follows: • Cisco Unified Communications system channel partners and resellers who are responsible for sales, implementation or administration of a Cisco Unified Contact Center. • System and technical support engineers. • Day 1 and Day 2 support personnel. • Administrative and reporting personnel. Overview Upon completing this course, the learner will be able to meet these overall objectives: • Understand the Cisco Unified CCE solution, architecture, solution options, integrated features, and call flow options. • Understand basic principles and configuration requirements for ACD activity in Cisco Unified CM, Cisco Unified CVP, ICM, and how to access and use the Cisco Finesse Agent Desktop. • Understand requirements and configurations to implement IVR activity in Cisco Unified CVP. • Understand and use administrative features and functions of ICM and implement more complex routing to include Precision Routing, routing from Cisco Unified Communications Manager and routing in a ring-no-answer condition. • Understand basic concepts and terms to access, view, modify reports and use other reporting functions provided by Cisco Unified Intelligence Center. Helps prepare learners to administer the Cisco Unified CCE v11.5 solution. Cisco Unified Contact Center Enterprise Overview Lesson 1: Presenting Cisco Unified Contact Center Enterprise Lesson 2: Cisco Unified CCE Core Components Lesson 3: Cisco Unified CCE Options Lesson 4: Basic Call Flow Models Basic ACD Configurations Lesson 1: Configuring Cisco Unified Communications Manager Lesson 2: Configuring Cisco Unified CVP Lesson 3: Configuring Cisco Unified CCE Lesson 4: Using Cisco Finesse Lesson 5: Using Cisco Unified CCE Script Editor Configuring Cisco Unified CVP for IVR Functionality Lesson 1: Basic IVR Configurations Lesson 2: Basic IVR Scripting using CVP Micro-Applications Extended Functions Lesson 1: ICM User Accounts and Feature Control Sets Lesson 2: Using ICM Utilities Lesson 3: Understanding ICM Variables Lesson 4: Precision Routing Lesson 5: Routing Calls from Cisco Unified CM Lesson 6: Ring-No-Answer Routing Cisco Unified CCE Reporting Lesson 1: Introducing Cisco Unified Intelligence Center Lesson 2: Running and Modifying CUIC Reports Lesson 3: Creating CUIC Reports and Dashboards

Handset and/or Voicemail Training 1600’s, 1400, 96/95 series handsets, J Series and voicemail One X Communicator One-X Mobile IX Workplace Desktop and Mobile App Web Conferencing Collaboration System Administration Training up to Release 11 Voicemail Pro Administration Training ACCS Agent, Supervisor and Administration Training XIMA/CHRONICALL/ACR Agent, Realtime, Recording and Reporting

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.

Duration 5 Days 30 CPD hours This course is intended for Senior system administrators who wish to learn more about troubleshooting. Have earned a Red Hat Certified System Administrator (RHCSA) or have similar experience. It is recommend that students have earned a Red Hat Certified Engineer (RHCE) or have similar experience. Overview As a result of attending this course, students should be able to leverage the software development life-cycle process to plan, create, test, and provision host systems within an organization. Students should be able to demonstrate the following skills: - Installation of Red Hat Satellite 6 - Software life-cycle management of software used to provision and maintain configured hosts within a controlled production environment This course enriches your skills by providing the tools and techniques that you need to successfully diagnose, and fix, a variety of potential issues. You will work through hands-on problems in various subsystems to diagnose and fix common issues. You will learn develop the skills to apply the scientific method to a structured form of troubleshooting. You will then apply this approach in troubleshooting various types of problems, including boot issues, hardware issues, storage issues, RPM issues, network issues, third-party application issues, security issues, and kernel issues. At the end of the course, you will be empowered to complete various comprehensive review labs to test your skills. 1 - INTRODUCTION TO TROUBLESHOOTING Describe a generalized strategy for troubleshooting. 2 - TAKE PROACTIVE STEPS TO PREVENT SMALL ISSUES Prevent small issues from becoming large problems by employing proactive system administration techniques. 3 - TROUBLESHOOT BOOT ISSUES Identify and resolve issues that can affect a system's ability to boot. 4 - IDENTIFY HARDWARE ISSUES Identify hardware problems that can affect a system?s ability to operate. 5 - TROUBLESHOOT STORAGE ISSUES Identify and fix issues related to storage. 6 - TROUBLESHOOT RPM ISSUES Identify and fix problems in, and using, the package management subsystem. 7 - TROUBLESHOOT NETWORK ISSUES Identify and resolve network connectivity issues. 8 - TROUBLESHOOT APPLICATION ISSUES Debug application issues. 9 - DEAL WITH SECURITY ISSUES Identify and fix issues related to security subsystems. 10 - TROUBLESHOOT KERNEL ISSUES Identify kernel issues and assist Red Hat Support in resolving kernel issues. 11 - RED HAT ENTERPRISE LINUX DIAGNOSTICS AND TROUBLESHOOTING COMPREHENSIVE REVIEW Practice and demonstrate knowledge and skills learned in Red Hat Enterprise Linux Diagnostics and Troubleshooting.

Duration 3 Days 18 CPD hours This course is intended for Program / Project ManagerSystem ArchitectSystem Administrator Overview Learn about the elements, strategies, and tools of the SAP authorization conceptCreate and assign authorizations using the Role Administration / Profile GeneratorLearn about the principle usage of the NetWeaver Identity Management and Central User Administration (CUA) In this course, students will learn about the elements, strategies, and tools of the SAP authorization concept, create and assign authorizations using the Role Administration/Profile Generator, & learn about the Central User Administration role. Authorizations Describing Authorization Authorization Concepts for Compliant Identity Management Designing Authorization for an AS ABAP-Based System Implementing Authorization for an AS ABAP-Based System Authorization Terminology Defining the Authorization Elements and Terms Checking Authorizations in ABAP Systems User Maintenance Maintaining User Data Basic Role Maintenance Defining a Role Defining Authorizations in a Role Defining Customizing Roles Creating Composite Roles Creating Reference and Derived Roles Maintaining Roles for SAP NetWeaver Business Client Advanced Role Maintenance Applying the Special Functions of Authorization Maintenance Defining Authorizations for a System User Authorization Environment Configuration Installing and Upgrading Role Maintenance Configuring Role Maintenance Defining System Settings Analyzing Missing Authorizations Transporting Authorizations Integration of Authorization Systems into an Organization's Landscape Creating Users with the Central User Administration (CUA) Migrating the CUA into SAP NetWeaver Identity Management (ID Management) Identifying Non-Standard Authorization Concepts in the SAP Business Suite Integrating Authorization Assignments with Organizational Management SAP Systems for Identity Management Identifying Different User Sources Describing SAP NetWeaver Identity Management (ID Management) Planning SAP Governance, Risk, and Compliance (SAP GRC) Describing Compliant Identity Management (CIM) Additional course details: Nexus Humans ADM940 SAP AS ABAP - Authorization Concept 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 ADM940 SAP AS ABAP - Authorization Concept 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 4 Days 24 CPD hours This course is intended for This intermediate course is designed for technical support personnel who implement, operate, and perform day-to-day administration of IBM MQ V8 on z/OS. Overview Describe message-oriented middleware and the capabilities it must provideIdentify the key components of IBM MQ for z/OSSummarize the responsibilities of the IBM MQ administratorConfigure IBM MQ IBM V8 for z/OSEnable IBM MQ for z/OS eight-byte RBA and buffers above 2 GBDemonstrate how to create and change queues and place and retrieve messages from a queueDefine and demonstrate how to set up and work with distributed queuingDifferentiate between an IBM MQ queue manager and an IBM MQ clientDescribe and demonstrate how to set up an IBM MQ clusterContrast point-to-point and publish/subscribe messaging stylesDescribe shared queues and queue sharing groupsSummarize IBM MQ for z/OS recovery and restart activitiesDemonstrate how to use IBM MQ events for monitoringSummarize performance considerationsDescribe security considerations for IBM MQ for z/OSDescribe and implement connection authentication and channel authorizationIdentify correct problem determination techniques for IBM MQ for z/OSSummarize basic use and configuration of IBM MQ Managed File TransferDescribe IBM MQ support for CICS and IMS interfaces This course provides the skills that are necessary to configure and manage an IBM MQ V8 queue manager on z/OS. Through lectures and hands-on lab exercises, students learn how to install, customize, operate, and administer IBM MQ V8. Course Outline Course introduction IBM MQ review IBM MQ architecture, installation, and configuration Exercise: Configuring an IBM MQ for z/OS queue manager IBM MQ for z/OS administrative interface options Exercise: Working with queues Distributed queuing Exercise: Working with channels IBM MQ clients Exercise: Working with IBM MQ clients IBM MQ cluster basics Exercise: Working with IBM MQ clusters Publish/subscribe basics Exercise: Publish/subscribe basics Queue sharing groups Using IBM MQ events and the dead-letter queue utility Exercise: Working with IBM MQ events Security considerations Exercise: Security Problem determination IBM MQ Managed File Transfer Exercise: IBM MQ Managed File Transfer configuration for z/OS IBM MQ for z/OS backup, recovery, and related file tasks Exercise: Working with file handling utilities Support for CICS, IMS, and HTTP applications Course summary