This 2 - 2-5 hour course is designed is designed to provide parents and carers with the opportunity to: Develop the basic skills and knowledge needed to deal with a wide range of emergency paediatric First Aid situations, which could arise when looking after babies and children. The course can take place in in a community group or in the comfort of your home, with family and friends who maybe caring for your child or they may have children of their own. The course can be booked during the week, week nights or weekends, with or without children present. The idea is to bring the skills and knowledge to you, in your normal routine.
Essential SDN training course description Software Defined Networking (SDN) has become one of the industries most talked technologies. This training course cuts through the hype and looks at the technology, architecture and products available for SDN along with looking at the impact it may have on your network. What will you learn Explain how SDN works. Describe the architecture of SDN. Explain the relationship between SDN and OpenFlow. Recognise the impact SDN will have on existing networks. Essential SDN training course details Who will benefit: Anyone wishing to know more about SDN. Prerequisites: None. Duration 2 days Essential SDN training course contents Introduction What is SDN? What is OpenFlow? SDN benefits. The SDN stack and architecture. SDN architecture SDN applications, SDN switches, SDN controllers, Network Operating Systems. Control plane, data plane. Control to Data Plane Interface (CDPI), Northbound interfaces. SDN components, control and data plane abstractions. Network Operating Systems Finding the topology, Global view, control program, configuration based on views, graph algorithm. OpenFlow Just one part of SDN. Open Networking Foundation, OpenFlow ports, Flow tables, OpenFlow Channels. The OpenFlow protocol, OpenFlow header, OpenFlow operations. OpenFlow versus OpFlex. SDN and open source OpenDaylight, OpenVSwitch, Open Networking Forum, Open Network Operating System. OpenStack Neutron. SDN implications Separation of control and data plane, NOS running on servers, Emphasis on edge complexity, core simplicity, OpenvSwitch, Incremental migration, importance of software. SDN vs NVF.
Security+ training course description A hands on course aimed at getting delegates successfully through the CompTia Security+ examination. What will you learn Explain general security concepts. Describe the security concepts in communications. Describe how to secure an infrastructure. Recognise the role of cryptography. Describe operational/organisational security. Security+ training course details Who will benefit: Those wishing to pass the Security+ exam. Prerequisites: TCP/IP foundation for engineers Duration 5 days Security+ training course contents General security concepts Non-essential services and protocols. Access control: MAC, DAC, RBAC. Security attacks: DOS, DDOS, back doors, spoofing, man in the middle, replay, hijacking, weak keys, social engineering, mathematical, password guessing, brute force, dictionary, software exploitation. Authentication: Kerberos, CHAP, certificates, usernames/ passwords, tokens, biometrics. Malicious code: Viruses, trojan horses, logic bombs, worms. Auditing, logging, scanning. Communication security Remote access: 802.1x, VPNs, L2TP, PPTP, IPsec, RADIUS, TACACS, SSH. Email: S/MIME, PGP, spam, hoaxes. Internet: SSL, TLS, HTTPS, IM, packet sniffing, privacy, Javascript, ActiveX, buffer overflows, cookies, signed applets, CGI, SMTP relay. LDAP. sftp, anon ftp, file sharing, sniffing, 8.3 names. Wireless: WTLS, 802.11, 802.11x, WEP/WAP. Infrastructure security Firewalls, routers, switches, wireless, modems, RAS, PBX, VPN, IDS, networking monitoring, workstations, servers, mobile devices. Media security: Coax, UTP, STP, fibre. Removable media. Topologies: Security zones, DMZ, Intranet, Extranet, VLANs, NAT, Tunnelling. IDS: Active/ passive, network/host based, honey pots, incident response. Security baselines: Hardening OS/NOS, networks and applications. Cryptography basics Integrity, confidentiality, access control, authentication, non-repudiation. Standards and protocols. Hashing, symmetric, asymmetric. PKI: Certificates, policies, practice statements, revocation, trust models. Key management and certificate lifecycles. Storage: h/w, s/w, private key protection. Escrow, expiration, revocation, suspension, recovery, destruction, key usage. Operational/Organisation security Physical security: Access control, social engineering, environment. Disaster recovery: Backups, secure disaster recovery plans. Business continuity: Utilities, high availability, backups. Security policies: AU, due care, privacy, separation of duties, need to know, password management, SLAs, disposal, destruction, HR policies. Incident response policy. Privilege management: Users, groups, roles, single sign on, centralised/decentralised. Auditing. Forensics: Chain of custody, preserving and collecting evidence. Identifying risks: Assets, risks, threats, vulnerabilities. Role of education/training. Security documentation.
The aim of the Level 2 Diploma in Care - fast track mode (Accredited by Qualifi, UK) is to confirm occupational competence for Adult Care Workers or Healthcare Support Workers. This Level 2 Diploma in Care (fast track mode) qualification offers the opportunity for learners to demonstrate their knowledge, understanding and practical skills required to be an Adult Care Worker in an adult care setting or a Healthcare Assistant; Support Worker or Personal Assistant in a healthcare support environment. At Level 2, the UK sector skills council decided that there would be a common qualification for both Health and Adult Care settings. This means that there will be no barrier to entering either the Adult Care or Health Workforces. The content of the Level 2 Diploma in Care (fast track mode) qualification links with the knowledge and skills required for the Apprenticeship Standards 'Adult Care Worker' and 'Healthcare Support Worker'. The content is applicable to a variety of roles, examples of which are included below: Adult care worker Healthcare Assistant / Support Worker Personal Assistant The Level 2 Diploma in Care (fast track) will require learners to demonstrate understanding and effective practice in the following areas: Communication Person development Values and behaviours Health and wellbeing Responsibilities Safeguarding The Level 2 Diploma in Care qualification links with the requirements for the National Occupational Standards (NOS) for Health and Social Care. Program Overview: Level 2 Diploma in Care Key Highlights of Level 2 Diploma in Care qualification are: Program Duration: 9 Months (Fast track mode available) Program Credits: 46 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Master's degree programme. Alumni Status No Cost EMI Option Mandatory units (Total Credits: 24) The Qualifi Level 2 Diploma in Care qualification consists of 9 mandatory units for a combined total of 24 credits Communication in Care Settings (3 credits) Duty of Care (1 credits) Equality, Diversity and Inclusion in Care Settings (2 credits) Handle Information in Care Settings (1 credits) Health, Safety and Well-being in Care Settings (4 credits) Implement Person-Centred Approaches (5 credits) Personal Development in Care Settings (3 credits) Responsibilities of a Care Worker (2 credits) Safeguarding and Protection in Care Settings (3 credits) Optional Units (Total Credits: 22) The learner must also achieve a minimum of 22 credits from these units. Introductory Awareness of Autistic Spectrum Conditions (2 credits) Understand the Context of Supporting People with Learning Disabilities (4 credits) Assist in the Administration of Medication (4 credits) Contribute to Support Positive Risk-Taking of Individuals (3 credits) Contribute to Support Learning Disabilities to Access Healthcare (3 credits) Promote Positive Behaviour Support (6 credits) Awareness of the Mental Capacity Act 2005 (3 credits) Understand Mental Health Problems (3 credits) Understand Mental Well-Being and Mental Health Promotion (3 credits) Enable Individuals to Develop Strategies to Manage their Behaviour (8 credits) Support Independence in the Tasks of Daily Living (5 credits) Understand how to Support Individuals to be part of a Community (3 credits) Understand the Impact of Acquired Brain Injury on Individuals (3 credits) Who is this course for? At Level 2, the UK sector skills council decided that there would be a common qualification for both Health and Adult Care settings. This means that there will be no barrier to entering either the Adult Care or Health Workforces. The content of the Level 2 Diploma in Care qualification links with the knowledge and skills required for the Apprenticeship Standards 'Adult Care Worker' and 'Healthcare Support Worker'. The content is applicable to a variety of roles, examples of which are included below: Adult care worker Healthcare Assistant / Support Worker Personal Assistant Requirements The Level 2 Diploma in Care will require learners to demonstrate understanding and effective practice in the following areas: Communication Person development Values and behaviours Health and wellbeing Responsibilities Safeguarding Career path Achievement of Level 2 Diploma in Care qualification confirms the learner has gained the knowledge and skills required to: Gain employment as a Healthcare Assistant / Support Worker or Adult Care Worker / Personal Assistant Progress onto the Qualifi Level 3 Diploma in Health and Social Care Progress onto the Level 3 Lead Adult Care Worker Apprenticeship.
The aim of the Level 2 Diploma in Care (Accredited by Qualifi, UK) is to confirm occupational competence for Adult Care Workers or Healthcare Support Workers. This Level 2 Diploma in Care qualification offers the opportunity for learners to demonstrate their knowledge, understanding and practical skills required to be an Adult Care Worker in an adult care setting or a Healthcare Assistant; Support Worker or Personal Assistant in a healthcare support environment. At Level 2, the UK sector skills council decided that there would be a common qualification for both Health and Adult Care settings. This means that there will be no barrier to entering either the Adult Care or Health Workforces. The content of the Level 2 Diploma in Care qualification links with the knowledge and skills required for the Apprenticeship Standards 'Adult Care Worker' and 'Healthcare Support Worker'. The content is applicable to a variety of roles, examples of which are included below: Adult care worker Healthcare Assistant / Support Worker Personal Assistant The Level 2 Diploma in Care will require learners to demonstrate understanding and effective practice in the following areas: Communication Person development Values and behaviours Health and wellbeing Responsibilities Safeguarding The Level 2 Diploma in Care qualification links with the requirements for the National Occupational Standards (NOS) for Health and Social Care. Program Overview: Level 2 Diploma in Care Key Highlights of Level 2 Diploma in Care qualification are: Program Duration: 9 Months (Fast track mode available) Program Credits: 46 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Master's degree programme. Alumni Status No Cost EMI Option Mandatory units (Total Credits: 24) The Qualifi Level 2 Diploma in Care qualification consists of 9 mandatory units for a combined total of 24 credits Communication in Care Settings (3 credits) Duty of Care (1 credits) Equality, Diversity and Inclusion in Care Settings (2 credits) Handle Information in Care Settings (1 credits) Health, Safety and Well-being in Care Settings (4 credits) Implement Person-Centred Approaches (5 credits) Personal Development in Care Settings (3 credits) Responsibilities of a Care Worker (2 credits) Safeguarding and Protection in Care Settings (3 credits) Optional Units (Total Credits: 22) The learner must also achieve a minimum of 22 credits from these units. Introductory Awareness of Autistic Spectrum Conditions (2 credits) Understand the Context of Supporting People with Learning Disabilities (4 credits) Assist in the Administration of Medication (4 credits) Contribute to Support Positive Risk-Taking of Individuals (3 credits) Contribute to Support Learning Disabilities to Access Healthcare (3 credits) Promote Positive Behaviour Support (6 credits) Awareness of the Mental Capacity Act 2005 (3 credits) Understand Mental Health Problems (3 credits) Understand Mental Well-Being and Mental Health Promotion (3 credits) Enable Individuals to Develop Strategies to Manage their Behaviour (8 credits) Support Independence in the Tasks of Daily Living (5 credits) Understand how to Support Individuals to be part of a Community (3 credits) Understand the Impact of Acquired Brain Injury on Individuals (3 credits) Who is this course for? At Level 2, the UK sector skills council decided that there would be a common qualification for both Health and Adult Care settings. This means that there will be no barrier to entering either the Adult Care or Health Workforces. The content of the Level 2 Diploma in Care qualification links with the knowledge and skills required for the Apprenticeship Standards 'Adult Care Worker' and 'Healthcare Support Worker'. The content is applicable to a variety of roles, examples of which are included below: Adult care worker Healthcare Assistant / Support Worker Personal Assistant Requirements The Level 2 Diploma in Care will require learners to demonstrate understanding and effective practice in the following areas: Communication Person development Values and behaviours Health and wellbeing Responsibilities Safeguarding Career path Achievement of Level 2 Diploma in Care qualification confirms the learner has gained the knowledge and skills required to: Gain employment as a Healthcare Assistant / Support Worker or Adult Care Worker / Personal Assistant Progress onto the Qualifi Level 3 Diploma in Health and Social Care Progress onto the Level 3 Lead Adult Care Worker Apprenticeship.
Python Unittest Course Summary. Testing plays a major role in software development. This course will explain Python Unit Testing using the unittest built-in module. We'll cover issues before going to the production itself and the basics of testing in Python. Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Unittest Certification Duration: 1-Day, 10am-5pm Unittest topics UnitTest Framework - Home UnitTest Framework - Overview UnitTest - Framework UnitTest - API UnitTest - Assertion UnitTest - Test Discovery UnitTest - Skip Test UnitTest - Exceptions Test UnitTest - Time Test UnitTest - Unittest2 UnitTest - Signal Handling UnitTest - Doctest UnitTest - Doctest API UnitTest - Py.test Module Nose Testing - Framework Nose Testing - Tools Included with Python Unittest Course Python Unittest Certificate on completion Python Unittest Videos Python Unittest Notes Python Unittest Examples Practical Python Unittest exercises
Make your life easier, learn how to communicate effectively Do you want to be a good communicator? Professional training for salespeople complete with a certificate Learn how to enter into contracts and how to bookkeep including accounting for travel. Learn from the best in the industry An employment law specialist with extensive experience will be leading the course. Test your knowledge Take the tests and practical tasks in the course to consolidate your knowledge and skills. Take the most effective and comprehensive sales training on the Polish Internet. Join the best salespeople in the business and rocket the sales in your company. In this training discover how the most professional salespeople work every day. Learn how they attract their customers, make business connections, arrange meetings, have key conversations and most importantly how they finalize deals and close contracts. You’ll discover all of this and more with concrete real life examples from a TOP salesperson and manager with 12 years of experience in professional sales. By taking this course you will have instant access to the practices of one of the best salespeople in the business who will also show you their sales process from A to Z as well as interviews with real clients. The sales training is done through the National Education Center’s interactive platform and includes invaluable resources such as a hybrid workshop with practical tasks and training for salespeople complete with expert feedback. Parts of the course will require active participation in order to complete the training. You can take the course at your own pace from the comfort of your own home and will have access to the materials on the interactive platform for two years after completing the course Join the communication course and get the benefits: Learning from a professional instructor24/7 access from any devicePractical exercisesTests, quizzes and recapsCertificate of completionExtra materials and downloadable bonuses100% satisfaction guarantee Your Singing Instructor: Faustine Parsons Communication expert Faustine is a manager, speaker and communication expert. She has over 14 years of experience in coaching and developing people skills for SMEs and international corporations. As a manager, she saw firsthand the importance of an effective team cooperation and got involved in the field. As a consultant, she specialized in smoothing the information exchange, bringing down barriers and creating a positive atmosphere throughout the organization. She developed skills and techniques which solved many of her clients’ problems. She combines the theory of psychology with down to earth practical approach. Let her guide you during the exciting journey through the dynamics of human interactions. Get ready for an interesting and fun ride, as her passion and positivity is contagious from the very beginning. Overview of the course: Detailed video presentations and training videos Fundamentals of effective communication Emotions and problems Daily communication at work and at home Business environment Advanced subjects Repetitions and tests Five repetitions Five tests Final exam Exercises and practial tasks Mapping good and bad practices Recognizing styles, behaviors and personalities Troubleshooting and dispute resolving in practice Giving feedback Overcoming challenges in your position All in one simulation Bonus materials Best practices kaizen map Scenarios and phrases for everyday situations Communication no-nos guide Personalities compendium Experience Beginner-IntermediateLanguage English, German, French, Polish, Portuguese A letter from your expert instructor: Many professionals encounter communication problems both at home and at work. They manifest themselves in misunderstandings, disputes and tension. It does not have to be this way. It all boils down to communication skills. For people and organizations who master them, everything comes easy.In my career, I have seen tremendous transformations on this front. Join me in this unique course and let me show you many of the best practices and techniques to make your life easier. Believe in yourself and make the most of your opportunities. Invest in your communication skills today!Faustine ParsonsCommunication expert
Our online course equips you with the necessary skills to deliver quality leadership within care settings. The course content aligns with the National Occupational Standards (NOS) for Leadership and Management in Care Services, ensuring that you meet the required standards. You will gain the confidence to handle challenging situations and adapt to changing environments. The Level 5 Leadership and Management for Adult Care course provides essential training and guidance for the Level 5 Diploma in Leadership and Management for Adult Care (RQF). This qualification is the most up-to-date and recognised qualification for Registered Managers approved by CQC and Skills For Care.
LOOKING FOR: PICTURE BOOKS Barry Timms is a children's picture book editorial consultant with over twenty years' experience. He has also edited preschool books, non-fiction and young fiction works. Barry's editorial roles include senior and managerial positions at Macmillan Children's Book, Walker Books and Little Tiger Group, making commercially successful books of the UK, US and international markets. Barry is also an award winning author of over fifteen picture books. This is NOT a Unicorn!, published by Nosy Crow, won the Stockport Children's Book Award 2022. Barry would like you to submit a covering letter and a maximum of two picture book texts to be discussed. This should be in one Word document with the cover letter at the top. The texts should be for children aged within the 2-6 years age bracket and can be in prose or rhyme. As well as conventional fiction narratives, narrative non-fiction is also acceptable. (In addition to the paid sessions, Barry is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print). By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Monday 3rd February 2025
MASTERCLASS 8 CPD POINTS 1 DAY INTENSIVE COURSE ONLINE or IN-CLINIC NOTE! After booking we will contact you for scheduling the exact course date! Courses dates are subject to change due to mentors availability. We will inform you via email if a date becomes available! On this course, we aim to help you master a technique that will set you apart from most routine cosmetic treatment providers and enable you to step into the future of advanced cosmetic. Training THEORY will enable you to understand: Anatomy Vascular Supply, Nerves on the face Contraindications Patient consultation ONE-TO-ONE Training Nose Job Masterclass You will perform this procedure on live models under the supervision and guidance of highly experienced aesthetic practitioners. You will be trained under ENT specialist. We will give you all the knowledge you need for a safe technique in your practice. A certification of training will be provided upon completion of the course. You need to be medically qualified as a doctor, dentist, nurse, pharmacist or paramedic with full governing body registration and have completed a Foundation Filler Course and to have administered a number of cases. Additional information ATTENDANCE ONLINE (Theory), IN CLINIC (Practice) COURSE LEVEL EXPERT | Masterclass Course
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