35655 Courses in Cardiff delivered Online

DWDM training course description A concise overview of Wave Division Multiplexing (WDM) with both Coarse Wave Division Multiplexing (CWDM) and Dense Wave Division Multiplexing (DWDM) being covered. The course starts with a review of the relevant elements of fibre transmission and multiplexing before then studying WDM components and architectures. Reliability, resilience and management are then followed by WDM services and futures. What will you learn Explain the benefits of WDM. Describe Dispersion and four way mixing. Describe the different WDM equipment components. Describe different WDM architectures. Explain How DWDM works. DWDM training course details Who will benefit: Anyone working with CWDM/DWDM. Prerequisites: Telecommunications Introduction Duration 2 days DWDM training course contents Fibre communications review Optical transmission, Fibre characteristics, Fibre component parts. Multi Mode Fibre (MMF). Single Mode Fibre (SMF). Fibre connections. Lasers. Attenuations, dispersion, optical signal noise ratios (OSNR) and their effects. Channel Spacing and Signal Direction. Limiting factors to single wavelength. WDM overview Multiplexing, TDM, WDM benefits. WDM standards. CWDM vs. DWDM. Four Wave Mixing (FWM). Impact and countermeasures to FWM on WDM. CWDM ITU G.694.2, channels, channel spacing. DWDM ITU G.694.1, channels, channel spacing. WDM Equipment Components Equipment components and building blocks. Optical Terminal Multiplexers (OTM). Optical Add/Drop Multiplexers (OADM). Adding versus dropping. Optical Amplifiers. Erbium Doped Fibre Amplifiers (EDFA). Transponders and Combiners. WDM/DWDM Hubs. Optical and Electrical Cross Connects (OXCs/DXCs). Types of Cross Connects (Transparent/Opaque). Advantages and disadvantages of various Optical cross connects. WDM Architectures WDM network sections. Point-to-Point, Optical switches, mesh, ring and star topology. Example of combined WDM and other technology network. Wavelength converting transponders, 1R, 2R, 3R. Protection for WDM Sub 50ms failover. Equipment protection. Card protection. Y cable, Splitter protection. Far end laser control. Line protection. OMSP 1+1, OMSP 1:1, OMSP 1: N. Self healing optical ring. Sub Network Connection Protection (SNCP). Automatically Switched Optical Networks (ASON). WDM Management Options In band management. Out of band management. The Optical Supervisory Channel (OSC). OSC capabilities. WDM services WDM Access. Bit rates, Transparent Networks. Modulation, DQPSK. SDH over WDM. Migrating from SDH to DWDM. Ethernet over WDM, IP over WDM. Optical Transport Networks G.709, 'digital wrapper', Optical Channel Payload Unit (OPU), Optical Channel Transport Unit ( OTU), Optical Channel Data Unit (ODU). OTU1, OTU2, OTU3, OTU4. WDM Futures All optical amplification, Raman amplification, distributed, lumped. Bit rates. Solitons. Coherent technologies.

Duration 5 Days 30 CPD hours This course is intended for This course is designed for IT professionals whose primary job responsibility is the management of servers and other devices running the Linux operating system. A typical student in this course should have at least nine months of hands-on Linux experience and at least one and a half years of IT experience in other computing environments. The target student should wish to expand their skillset to support their career in Linux system administration and operation. This course is also designed for students who are seeking the CompTIA Linux+ certification and who want to prepare for Exam XK0-005. The Linux+ certification can validate the student's understanding and skill in configuring, monitoring, and supporting Linux systems. Overview In this course, you will configure, operate, and troubleshoot Linux systems. You will: - Perform basic Linux tasks. - Manage users and groups. - Manage permissions and ownership. - Manage storage. - Manage files and directories. - Manage kernel modules. - Manage the Linux boot process. - Manage system components. - Manage devices. - Manage networking. - Manage packages and software. - Secure Linux systems. - Write and execute Bash shell scripts. - Automate tasks. - Plan and perform a Linux installation. The Official CompTIA© Linux+© courseware builds on your existing experience with systems operations and administration to provide you with the knowledge and skills required to configure, manage, operate, and troubleshoot a Linux environment by using security best practices, scripting, and automation. This course will also prepare you for the Exam XKO-005. 1 - PERFORMING BASIC LINUX TASKS Identify the History and Development of Linux Enter Shell Commands Get Help Using Linux 2 - MANAGING USERS AND GROUPS Assume Superuser Privileges Create, Modify, and Delete Users Create, Modify, and Delete Groups Query Users and Groups Configure Account Profiles 3 - MANAGING PERMISSIONS AND OWNERSHIP Modify File and Directory Permissions Modify File and Directory Ownership Configure Special Permissions and Attributes Troubleshoot Permissions Issues 4 - MANAGING STORAGE Create Partitions Manage Logical Volumes Mount File Systems Manage File Systems Navigate the Linux Directory Structure Troubleshoot Storage Issues 5 - MANAGING FILES AND DIRECTORIES Create and Edit Text Files Search for Files Perform Operations on Files and Directories Process Text Files Manipulate File Output 6 - MANAGING KERNEL MODULES Explore the Linux Kernel Install and Configure Kernel Modules Monitor Kernel Modules 7 - MANAGING THE LINUX BOOT PROCESS Configure Linux Boot Components Configure GRUB 2 8 - MANAGING SYSTEM COMPONENTS Configure Localization Options Configure GUIs Manage Services Troubleshoot Process Issues Troubleshoot CPU and Memory Issues 9 - MANAGING DEVICES Identify the Types of Linux Devices Configure Devices Monitor Devices Troubleshoot Hardware Issues 10 - MANAGING NETWORKING Identify TCP/IP Fundamentals Identify Linux Server Roles Connect to a Network Configure DHCP and DNS Client Services Configure Cloud and Virtualization Technologies Troubleshoot Networking Issues 11 - MANAGING PACKAGES AND SOFTWARE Identify Package Managers Manage RPM Packages with YUM Manage Debian Packages with APT Configure Repositories Acquire Software Build Software from Source Code Troubleshoot Software Dependency Issues 12 - SECURING LINUX SYSTEMS Implement Cybersecurity Best Practices Implement Identity and Access Management Methods Configure SELinux or AppArmor Configure Firewalls Implement Logging Services Back Up, Restore, and Verify Data 13 - WORKING WITH BASH SCRIPTS Customize the Bash Shell Environment Identify Scripting and Programming Fundamentals Write and Execute a Simple Bash Script Incorporate Control Statements in Bash Scripts 14 - AUTOMATING TASKS Schedule Jobs Implement Version Control Using Git Identify Orchestration Concepts 15 - INSTALLING LINUX Prepare for Linux Installation Perform the Installation Additional course details: Nexus Humans CompTIA Linux Plus Certification (Exam XK0-005) 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 CompTIA Linux Plus Certification (Exam XK0-005) 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.

This workshop gives an opportunity to focus on the emotional needs of girls and how to meet these. We lift the lid on a less well explored inclusion issue, meeting the emotional needs of girls. Everyone knows a girl or woman. They may be pupil, daughter, sister, parent or partner. Course Category Meeting emotional needs Behaviour and Relationships Inclusion Early Years Description This workshop gives an opportunity to focus on the emotional needs of girls and how to meet these. We lift the lid on a less well explored inclusion issue, meeting the emotional needs of girls. Everyone knows a girl or woman. They may be pupil, daughter, sister, parent or partner. Girls will often withdraw, attack or even hurt themselves when under emotional stress and this is not always obvious in the way it is with boys. 1 in 4 women experience domestic violence and every week 2 women are killed by a current or ex partner. Whilst the world assumes girls have no problems processing their emotions, we lift the lid on this and question what is really happening for girls this century? Testimonials Learning Objectives Increased understanding of girls’ emotional needs Access to a wider range of practical strategies to impact on meeting emotional and behaviour problems Deeper understanding of core values surrounding inclusion Opportunity to reflect on professional attitudes and behaviour towards girls and their emotional challenges New skills and processes to make girls’ inclusion and achievement more successful Who Is It For ? Early years and school based practitioners Key workers Teaching Assistants with support roles Heads and deputies SENCOs Advanced skills teachers Primary and secondary classroom teachers Parents Local Authority support services Course Content The course explores the questions : Is there an invisible problem with girls? What can we do to meet the emotional needs of girls? What helps? What should our priority be with girls? This workshop will explore: Cultural and historical expectations of girls in our society Shared experiences of teaching and parenting girls Circle of Courage as a way of understanding emotional needs Fathers, mothers and daughters Solution Circle Problem Solving around girls’ needs What girls really need If you you want something similar, but not gender specific try: FRESH APPROACHES TO BEHAVIOUR AND RELATIONSHIPS or you may like: RESTORATIVE INTERVENTIONS

In this course we explore Mental Health and address how such needs can be met in mainstream classrooms. Course Category Behaviour and Relationships Meeting Emotional Needs Description This is our lead workshop/training day on understanding mental health, behaviour and relationship work in schools other settings and is both a values primer and a practical guide to successful innovative strategies for improving behaviour and strengthening relationships for challenging children and young people of all ages. Not just another day on ‘Behaviour Management’ – Our Mental Health Day goes well beyond a rewards and sanctions approach to ‘behaviour’. We will be focused on those young people for whom rewards and punishments do not always work and who confuse the adults who work with them. We aim to take a relationships-based approach and to give those attending an opportunity to think more deeply about why young people do the things they do and what our part as adults is in creating, sustaining and changing these behaviours. The day gives those present opportunities to reflect on their attitudes and practice in relation to children’s behaviour and relationship building.   If your usual approaches to managing tackling mental health needs aren’t working with particular individuals then take a tour through this range of cutting edge strategies for bringing about positive behaviour change, and for meeting challenging emotional needs  Learning Objectives reinforce and affirm good practice re-energise, stimulate and challenge thinking about inclusion of challenging pupils and children increased understanding of mental health increased confidence in managing challenging pupils in mainstream schools access to a wider range of practical strategies to impact on behaviour problems opportunity to reflect on professional attitudes and behaviour towards mental health in families and pupils Who Is It For ?  Anyone concerned with understanding and meeting emotional and mental health needs  Course Content Circle of Courage – belonging-achievement-generosity – independence – model for understanding mental health Compass of Anxiety – understanding and going deeper Active listening – Listening to the person underneath the behaviour Involving other children and young people in solutions and interventions - Circles of friends: peer support, counselling and mediation Team Problem Solving – Solution Circles: a 30 minute group problem solving process to get Teams ‘unstuck’ and to generate positive first action steps Restorative justice and restitution: principles and practice of this approach to repairing harm and restoring relationships without reliance on punishment Understanding the effects of Separation, Loss, Trauma and Neglect on children’s learning and relationships in school and what adults can do to reach and support these children

The Level 5 qualifications in Management and Leadership are aimed at those who are working as middle managers and those who are aspiring to be senior managers. This qualification is mainly focused on the improvement of the student’s capabilities and core management skills such as resource management, recruitment, and information management. The Level 5 Diploma in Management and Leadership has been devised for developing the key skills of middle managers and those who are striving to be senior managers. This diploma is a benchmark qualification for full CMI membership which will take you one step closer to the status of a Chartered Manager. We have a 100% pass rate due to the high levels of support delivered through our online learning platform and individual coaches/assessors are assigned to all students. Our speed of response is second to none and our 5-star rating from our students speaks for itself. We are delighted to have supported students to unleash their potential from a diverse range of organisations both within the UK and internationally from organisations that have most recently included: Michelin Barclays Firstsource Mercedes Benz Shangrila Hotels and Resorts Virgin Money UK Person College London North Norfolk District Council G&L Scientific Coca Cola New Balance PureGym As a CMI accredited Chartered Manager Centre, many of our students go on to achieve recognition as Chartered Managers through our centre. Study method Online, self-paced Duration 9 months Access to content Access until course completion Qualification Level 5 Diploma - Extended Diploma in Business and Management CPD 540 CPD hours / points Additional info Exam(s) / assessment(s) is included in price Tutor is available to students CPD 540 CPD hours / points Accredited by Chartered Management Institute Key Benefits Latest and emerging as well as classical leadership and management concepts, theories and models. Practical guidance and support from our coaches and assessors who are all CMI Chartered Managers or Fellows. An internationally – recognised professional qualification. The credits earned at this course can be transferred to other courses if the students want to pursue MBA or any other Masters. On successful completion of the programme, students will be able to demonstrate their understanding and ability to apply leadership and management good practice which will improve their attractiveness to employers. The programme covers a choice of the following Units to a Total Qualification Time of 540 hours: CMI 502 Developing, Managing and Leading Individuals and Teams to Achieve Success (60 Hours TUT) CMI 504 Managing Performance (50 Hours TUT) CMI 506 Managing Equality, Diversity and Inclusion (50 Hours TUT) CMI 514 Managing Change (50 Hours TUT) CMI 513 Managing Projects to Achieve Results (60 Hours TUT) CMI 515 Creating and Delivering Operational Plans (60 Hours TUT) CMI 517 Principles of innovation (50 Hours TUT) CMI 520 Managing finance (60 Hours TUT) CMI 523 Principles of marketing products and services (60 Hours TUT) CMI 524 Conducting a Management Project (100 Hours TUT) CMI 525 Using Reflective Practice to Inform Personal and Professional Development (50 Hours TUT) We also provide students with access to the full CMI syllabus and support them if they wish to choose alternative Units. What the programme offers Level 5 Diploma in Leadership & Management from Chartered Management Institute (CMI) Student membership of the Chartered Management Institute Full learning support and all course materials All registration and assessment fees (We don't believe in hidden costs) Unrivalled one-to-one tutor support throughout the entire learning journey. A dedicated Chartered Manager as your programme coach/assessor 24-7 access to our extensive online Academy and CMI's Management Direct learning platform. All assessment and support materials are accessible through our online learning platform Assessment feedback within 48 hours to keep students motivated and on track The opportunity to progress to become recognised as a Chartered Manager upon successful completion Who is this course for? Middle Managers, potential middle managers and senior managers/business owners who want to consolidate their understanding of leadership and management good practice and gain formal recognition of their leadership and management abilities from the Chartered Management Institute – the only worldwide Chartered leadership and management professional body. Requirements None - we offer an inclusive and welcoming learning environment to all our students and there are no barriers to entry. Prospective students should be aware this CMI level 5 qualification is approximately equivalent to an academic degree level. Students will be required to submit assignments to this level. Career path A career in leadership and management. A possible progression route on successful completion of a Level 5 qualification in Strategic Management and Leadership would be to, Progress to other qualifications at the next level (e.g. from Level 5 Certificate to Level 6 or 7 Certificate)

Our Practitioner Diploma in Clinical Hypnotherapy is a blend of eLearning at your own pace, weekly video conferencing, Masterclasses, and Peer Supervision sessions with interactive and synchronised learning.

This workshop gives an opportunity to focus on the emotional needs of children and young people and how to meet these. We lift the lid on an emerging urgent inclusion issue, meeting the emotional well being of all children. In one year 1300 young men committed suicide in the UK. In the UK the commonest cause of death among those aged 16-35 is suicide. Online Course now available via Teachable Platform – Understanding children’s Emotional Needs Learn at your own pace… lots of text and video support Course Category Behaviour and Relationships Meeting emotional needs Early Years Inclusion Description This workshop gives an opportunity to focus on the emotional needs of children and young people and how to meet these. We lift the lid on an emerging urgent inclusion issue, meeting the emotional well being of all children. In one year 1300 young men committed suicide in the UK. In the UK the commonest cause of death among those aged 16-35 is suicide. 1 in 4 women experience domestic violence and 2 women a week are killed by a current or ex partner. We need to find ways to allow children to unclench their hearts and learn to experience, process, communicate and manage their own emotional lives for their own and for the good of the wider community. Testimonials Be the first…. Learning Objectives Increased understanding of emotional needs Access to a wider range of practical strategies to impact on meeting emotional and behaviour problems Deeper understanding of core values surrounding inclusion Opportunity to reflect on professional attitudes and behaviour towards children and their emotional challenges New skills and processes to make emotionally challenged children’s inclusion and achievement more successful Who Is It For ? Early years and school based practitioners Key workers Teaching Assistants with support roles Heads and deputies SENCOs Advanced skills teachers Primary and secondary classroom teachers Parents Local authority support services Course Content Shared experiences of teaching and parenting around emotional well being Circle of Courage as away of understanding emotional needs Fathers, mothers and sons and daughters Drinking and drugs, filling the emotional void Depression and suicide Anger and violence Solution Circle Problem Solving What children really need

Duration 1 Days 6 CPD hours This course is intended for This course is designed for Microsoft© Windows© and Microsoft Office users who are transitioning to a SharePoint environment, and who need to access information from and collaborate with team members within Microsoft SharePoint. Overview Launch a SharePoint site and navigate among the pages and resources provided by the site. Use SharePoint lists to track and view information. Use document libraries to store and organize documents. Find, share, and archive content stored in SharePoint. Author documents as a member of a SharePoint team site. Use SharePoint workflow automation tools. In many professional environments, people work collaboratively in teams. Information technology and applications facilitate this by enabling people to easily share, access, edit, and save information. Microsoft© SharePoint© is a platform specifically designed to facilitate communication and collaboration, enabling people to use familiar applications and web-based tools to create, access, store, and track documents and data in a central location. In this course, you will use SharePoint to access, store, share, and collaborate with information and documents. Prerequisites To ensure your success in this course, you should have basic end-user skills with a current version of Microsoft Windows. Lesson 1: Navigating SharePoint Sites Topic A: Launch SharePoint Topic B: Gain Access to a Site You Didn't Create Topic C: Navigate Within a SharePoint Site Topic D: Access SharePoint from Your Mobile Device Lesson 2: Using Lists to Track Information Topic A: Add and Populate Lists Topic B: Change View Options Topic C: Create a Custom View Lesson 3: Using Document Libraries to Share and Organize Documents Topic A: Store Files in a Document Library Topic B: Create and Use Document Templates Lesson 4: Finding, Sharing, and Archiving Content Topic A: Search for Items in Lists or Libraries Topic B: Share Through Links Topic C: Move Files Offline Lesson 5: Authoring Documents as a Team Topic A: Work Together on Documents Topic B: Manage File Versions and Document Recovery Lesson 6: Automating Business Processes Topic A: Use Rule-Based Automation Topic B: Use Power Automate to Automate a Workflow

This training gives an opportunity to focus on how to embed effective approaches to meeting emotional needs in schools. We explore a range of ways into meeting emotional needs of pupils across a school. We focus on including pupils with extreme emotional needs. Course Category Meeting emotional needs Description This training gives an opportunity to focus on how to embed relevant ideas and materials in schools. We explore how to make these materials really come to life as we explore a range of ways into meeting emotional needs of pupils across a school. We focus on including pupils with extreme emotional needs. There are lots of opportunities for personal and professional reflection on engagement with challenging pupils as we provide processes to support reflection, visioning and problem solving. Testimonials ‘Thank you so much for the work you did with us yesterday – I have since been in 2 schools today and have spoken to an number of other colleagues who were present – all were totally overwhelmed by the session – they loved it.”NOTTINGHAM SEAL COORDINATOR “I was totally blown away, when I realised how passionate people were about SEAL” “So nice to reflect and realise what a long way we have come” “That was so powerful and motivational”.’ Learning Objectives Shared vision of a school that is truly meeting all social and emotional needs Access to a wider range of practical strategies to impact on meeting emotional and behaviour problems Deeper understanding of how to embed positive Mental Health approaches in a school Opportunity to reflect on professional attitudes and behaviour towards children with emotional challenge Who Is It For? All practitioners who are leading on Mental Health work in schools or on behalf of a Local Authority Full range of agencies committed to meeting social and emotional needs in schools Course Content The training explores the questions: What would a school look like when Mental Health was truly part of everything that was happening, a shared vision? How can we truly embed Mental Health approaches and materials in our school? What can we do to meet complex and challenging emotional needs in schools? Can we learn a process to understand at a deeper level highly complex social and emotional needs? This training will cover: Bringing positive Mental Health approaches to life in schools: creating a shared vision and a set of grounded goals together Circle of Adults process for self-reflection and understanding emotional needs of high profile pupils. We will model and teach how this process links in and strengthens PSHE work in schools. If you liked this try: FRESH APPROACHES TO BEHAVIOUR AND RELATIONSHIPS or: RESTORATIVE INTERVENTIONS

MySQL for developers training course description This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. What will you learn Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. Use advanced features of the MySQL Client. Use advanced data types. Manage the structure of databases and tables. Manage and using indexes. Write complex SQL query statements. Use advanced SQL expressions. Use advanced SQL functions. Perform advanced Insert, Update, Delete, Replace and Truncate Operations. Use user variable syntax and properties. Import and export data from within MySQL. Import and export data from the command line. Perform complex joins to access multiple tables. Perform complex subqueries. Create, manage and us views. Use prepared statements. Create and use stored routines. Create and use triggers. Obtain database metadata. Optimize queries. Work with the main storage engines. Debug MySQL applications. MySQL for developers training course details Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. Prerequisites: MySQL foundation Duration 5 days MySQL for developers training course contents Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations More about indexes Indexes and joins Hands on Investigating indexes and joins