215 NOS courses

This is course will give you EVERYTHING you need to become a VTCT Level 3 Qualified Skin Specialist. Why do you need THIS course? Previously the beauty industry had very lax regulation and you could start your business with just CPD accreditation. However, insurance companies, professional skin care brands and professional equipment providers are now looking for qualifications like VTCT as these are a set standard that require assignments and exams at a very minimum of Level 2 and in most cases Level 3. This means a combination of both VTCT and CPD means your business will meet industry standards What is the difference between CPD and VTCT? Qualifications are listed on the Regulated Qualifications Framework (RQF), which is the national framework of UK qualifications, and the certificate of achievement is issued by an Awarding Organisation. Your certificate means you are ‘qualified’ in that subject CPD is a piece of training developed by an individual or organisation that sits outside the regulated qualifications framework. It confers a skill not a qualification. Treatments such as dermaplaning can only be completed as a CPD therefore a combination of both VTCT and CPD will increase your revenue. You will gain the following; Level 3 Access to Aesthetic Therapies- This has Level 2 Facial Therapy within it making the course suitable for complete beginner. Full content list is below. Advanced Skin Care Diploma Microdermabrasion LED Light Therapy Dermaplaning Chemical Peels. Microneedling Nano Needling If you prefer one treatment at a time then we offer this too. You can find all our courses here We also offer the Level 4 Qualified Skin Specialist Course Please confirm dates and availability with us prior to purchasing Who Is This Course Suitable For? This course is perfect for those who are beginners with no experience. However, the course can be tailored for those who have partial qualifications/ accreditation and would like to become a qualified Level 3 practitioner. Course Content You will cover; VTCT (ITEC) Level 3 Certificate in Access to Aesthetic Therapies This qualification is based on the National Occupational Standards (NOS) for relevant principles of beauty therapy and includes all the required elements to achieve a measurable and comparable qualification, which will facilitate further and additional study at levels 4 and above. Learners must achieve all mandatory units which include: – Health and safety – Facial therapy – Consultation and client care – Anatomy, physiology and pathology – Electrical therapies Throughout this qualification, learners will develop their knowledge and understanding of relevant anatomy and physiology and health and safety pertaining to level 2 and 3 therapies. They will also develop the knowledge, understanding and skills to consult with clients and analyse their skin to help facilitate the provision of facial therapies. In parallel, learners will develop their communication and customer service skills, all of which are valued highly by employers. Advanced Skin Care Diploma Microdermabrasion LED Light Therapy (full course content can be found here) Dermaplaning (full course content can be found here) Chemical Peels. (full course content can be found here) Microneedling Nano Needling (full course content can be found here) A full start up equipment kit will be available to purchase on training. Details will be provided upon booking. Course Duration & Cost You will be registered onto online portal with easy access for viewing of tutorials reducing time in the centre. You will be required to do home study of treatment theory as well as assignments before you attend the practical training. This will allow more time to work on models and get hands on experience. The Qualified Level 3 Skin Specialist course is a combination of the Advanced Skin Care Diploma and VTCT (ITEC) Level 3 Certificate in Access to Aesthetic Therapies and you will be required to be in the centre for 4 intensive practical days £3200 Why Choose Us? This course will allow you to offer the most on trend and in demand treatments that are results driven. The key to a successful business is to offer services that clients will want to keep coming back for. All of the treatments within this diploma have proven results which will support you in customer retention. We do not offer online courses for treatments that require the skill that can only be performed in front an experienced trainer. We ensure we offer a practical course that allows you to work on 2 models per treatment. We want you to be confident in the skill so you can start your business straight away. We are not an Academy and we take pride in this. This means we offer more than just training you in a skill. We understand how difficult and overwhelming it can be to start a new business and our ethos is to provide guidance and support to get you started. All our sessions have an option of 1-2-1 sessions for a personalised experience and have a maximum of 4 students per session. Your journey with us doesn’t end in the practical training session. When you train with Elixir Skin Training you become a part of our brand. We stay in touch with all our graduates and provide that motivation to get you going, which you will not find in large Academies. Quality of training is important but so is what comes after- we support you in every aspect because we want to see you build your business. Categories: Advanced Skin Care Courses, Combined Courses, ofqual, Training

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

Barbering

I want to discuss the existential-phenomenological challenges of viewing the human condition and explore alternatives for openness. We aim to explore the lived experiences on irregular perceptions of reality with an open mind. Each Saturday includes: a live dialogue between Prof. Ernesto Spinelli and an International Existential Therapist; a moment to share your thoughts and feelings with the teachers; and a final integration facilitated by Bárbara Godoy. This series of ten dialogues set out to explore the multifaceted dimentions and complexities associated with Existential Therapies. It attempts to engage with various interpretations of insanity through the lens of patients often painful, confounding, and deeply unsettling life experiences. Opening- between Prof. Ernesto Spinelli and Dr. Yaqui Martinez “From my early days studying psychology, I never felt comfortable with psychopathological nosologies. They seemed exaggerated to me and demonstrated the intense human desire to classify all possible expressions of our existence. Likewise, I have not been comfortable with the tendency to promote dualistic perspectives that compartmentalize our reality into separate aspects where one is not only different from the other but even in opposition, such as the sane/insane dichotomy. During this dialogue, I want to talk with Ernesto about the difficulties involved, from an existential-phenomenological perspective, in viewing the human condition from this position. Perhaps we can ask ourselves together what advantages they offer and what alternatives for openness we can propose.” Dr. Yaqui Martinez. Dr. Yaqui A. Martínez-Robles is a psychologist with Masters, PhD and PsyD in Psychotherapy. He has training in Gestalt Therapy; Music Therapy; Transpersonal Psychology and Holotropic Breathwork (with the Grof Transpersonal Training Association); Narrative and postmodern therapies and Social Constructionism; and in Psychedelic-Assisted Therapy (with the Integrative Psychiatry Institute and MAPS-Multidisciplinary Association for Psychedelic Studies). He is the author of four books, and co-author of another two, focused on the existential perspective. He has participated with chapters in several books and with articles in several journals. Yaqui is the founder of the Circle of Studies in Existential Therapy, in Mexico City and in Medellin, Colombia,. He teaches existential-phenomenological psychology and therapy in Mexico and different countries of South America. He is the current president of the Latin American Association of Existential Psychotherapy (ALPE). He works in private practice as an existential-phenomenological therapist and coach, in modalities one-on-one, couples and groups. Prof. Ernesto Spinelli was Chair of the Society for Existential Analysis between 1993 and 1999 and is a Life Member of the Society. His writings, lectures and seminars focus on the application of existential phenomenology to the arenas of therapy, supervision, psychology, and executive coaching. He is a Fellow of the British Psychological Society (BPS) as well as an APECS accredited executive coach and coaching supervisor. In 2000, he was the Recipient of BPS Division of Counselling Psychology Award for Outstanding Contribution to the Profession. And in 2019, Ernesto received the BPS Award for Distinguished Contribution to Practice. His most recent book, Practising Existential Therapy: The Relational World 2nd edition (Sage, 2015) has been widely praised as a major contribution to the advancement of existential theory and practice. Living up to the existential dictum that life is absurd, Ernesto is also the author of an on-going series of Private Eye novels. Date and Time: Saturday 19 June from 2 pm to 3 pm – (UK time) Individual Dialogue Fee: £70 Venue: Online Zoom FULL PROGRAMME 2025: 25 January “Knots” with Prof. Ernesto Spinelli and Bárbara Godoy 22 February “Healing” with Dr. Michael Guy Thompson and Prof. Ernesto Spinelli 22 March “Difference” with Prof. Tod DuBose and Prof. Ernesto Spinelli 12 April “Polarisation” with Prof. Kirk Schneider and Prof. Ernesto Spinelli 3 May “Character” with Prof. Robert Romanyshyn and Prof. Ernesto Spinelli 21 June “Opening” with Dr. Yaqui Martinez and Prof. Ernesto Spinelli 19 July “Meaning” with Dr. Jan Resnick and Prof. Ernesto Spinelli 25 October “Invention” with Dr. Betty Cannon and Prof. Ernesto Spinelli 15 November “Hallucination” with Prof. Simon du Plock and Prof. Ernesto Spinelli 13 December “Hysteria” with Bárbara Godoy and Prof. Ernesto Spinelli Read the full programme here > Course Organised by:

In this first aid course, all basic first aid procedures are examined, including what to do if you come across an emergency situation, how to treat various types of casualties and how to record any incidents that have taken place. This course covers topics such as how and when to use a first aid box, how to use an AED, when to call an ambulance and goes into details about how to handle different emergency situations that may emerge in a care home. This first aid course follows guidelines and procedures issued by the British Red Cross, St. John Ambulance and the latest Resuscitation Council Guidelines (UK). This course can be used for induction training of appointed persons and all other staff as required by the Care Certificate. Subjects covered include: The DR ABC Primary Survey • CPR • Use of an AED • Recovery Position • Calling an Ambulance • Heart Attack • Stroke • Severe External Bleeding • Shock • Choking • Seizures • Concussion • Broken (Fractured) Bones • Back Injury • Burns • Diabetes • Eye Injury • Allergic Reactions • Swallowed Poisons • The First Aid Box • Records Standards England Care Certificate Standard 12 and 13.4 NOS: CHS36 RQF: Basic Adult Life Support and Automated External Defibrillation (Level 2 Diploma in Emergency Care Assistance), Understand the administration of medication (Level 2 Diploma in Care, Level 3 Diploma in Adult Care, Level 3 Diploma in Healthcare Support) Wales All Wales Induction Framework for Health and Social Care (AWIFHSC) Section 7 Scotland The Health and Social Care Standards Northern Ireland NISCC's Induction Standards

QA Level 3 Award In Paediatric First Aid (RQF) Two day course HSE highly recommends this course for those who work with children in a childcare setting Being able to deal with peadiatric emergencies can make the difference between the life and death of children, and save them a lot of suffering Course Contents: The Roles and Responsibilities of an Emergency Paediatric First Aider Assessing an Emergency Situation Accident Recording Minor Injuries Cuts, Grazes and Bruises Minor Burns and Scalds Managing an Unresponsive Infant and Child Recovery Position Infant and Child CPR Infant and Child Safe Use of an AED (Automated External Defibrillator) Choking Anaphylaxis Seizures Wounds and Bleeding Hypovolaemic Shock Head, Neck and Back Injuries Sprains, strains, dislocations and fractures Meningitis Asthma Diabetes Eye, Ear and Nose Conditions Poisoning Electric Shock Bites and Stings Hot and Cold Temperatures Benefits of this course: Would you know what to do if you saw a child in need of First Aid? Children are prone to minor injuries, but suffer from serious injuries also In 2014, 2,269 children in the UK were so badly bitten by an animal they had to be admitted to hospital More than 2 million children have accidents in the home for which they're taken to A&E - every year, with Under 5s accounting for 7% of all hospital emergency treatments Being able to deal with peadiatric emergencies can make the difference between the life and death of children, and save them a lot of suffering. This QA Level 3 Award in Paediatric First Aid (RQF) qualification is ideal for: - Parents/carers or family members who want to learn key paediatric first aid skills - those who work with, or intend to work with children in a childcare setting as it is designed to fulfill Ofsted’s First Aid requirements for early years teachers, nursery workers and childminders (as defined within the Statutory Framework for the Early Years Foundation Stage (EYFS) 2014 and within the Child Care Register guide) Childcare settings who are working towards Millie’s Mark We also run a Paediatric Annual Refresher to keep those life-saving skills up to date Accredited, Ofqual regulated qualification: Our Paediatric First Aid at Work course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards.This means that you can be rest assured that your Paediatric First Aid certificate will fulfill the legal requirements. It is a very good way to make sure you and your employees are trained in First Aid for Children and Infants (babies).The Ofqual Register number for this course is 603/0785/7

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

FOUR DAY ATTENDENCE AND TRAINING GUIDELINE: DAY ONE AND TWO - INTRODUCTION TO DERMAL FILLERS Day one Arrive and coffees (10.00) Registration, introduction and expectations (10.00-10.15) Structure of the training (10.15-10.30) Break (10.30-11.00) Lectures and interactive workshops / simulation (11.00 - 1230pm) Health and safety in the workplace Sharps injury and disposal The consultation process and prescriptions LUNCH (1300-1730) with a coffee break Basic life support Anaphylaxis - recognition and management Emergency kits - what it should contain and how to buy one Your doctors on call - how to contact our on call doctors for emergency advice How to use Hyalase safely - when to use it / recognise mechanism of action, how prescription in an emergency works and how to give the hyalase Practical and to include demonstration of Hyalase injection Our added benefits services for safety and convenience Day two Arrive and coffees (10.00) introduction and expectations (10.00-10.30) Structure of the training (10.30-11.00) Formal written examination covering key areas of THEORY for Dermal Filler injections: Anatomy, Physiology, Products and Complications. This will highlight early on if any important areas need to be covered in more detail for the students (11.00 - 1200) - Break for lunch - Practical session commences - (12.30 - 1800) - and in total on average we have scope for one model per 30 minutes on both of the Dermal filler days, so that’s a potential for 10 in total for a class size of maximum 4, which will give good hands on experience, as the way we train is to allow several people the opportunity to be involved with each patient - e.g. splitting into the phases of treatment, which allows the trainees to understand the concept of the treatment process. That would be - consultation, consent, marking up, readying equipment, performing the injection, providing advice and aftercare. DAY THREE AND FOUR BOTOX FOUNDATION COURSE Day three Arrive and coffees (10.00) introduction and expectations (10.00 – 10.30) Structure of the training (10.30 – 11.00) Formal written examination covering key areas of THEORY for Botox Application: Anatomy, Physiology, Products and Complications. This will highlight early on if any important areas need to be covered in more detail for the students (11.00 - 1200) - Break for lunch - Practical session commences - (12.30 - 1800) - and in total on average we have one model per 30 minutes on both the botox and days, so that’s a potential of 10 in total for a class size of 4, which will give good hands on experience, as the way we train is to allow several people the opportunity to be involved with each patient - e.g. splitting into the phases of treatment, which allows the trainees to understand the concept of the treatment process. That would be - consultation, consent, marking up, readying equipment, performing the injection, providing advice and aftercare. Day four Observed Treatment Process Examination The participants will be tested on the following key facets of safe practical care: Consultation process - rapport and understanding what the client wants Safe consent Marking and photographs Technical skill of injection Atercare provision and safety netting (eg if this happens do this / call me) 1 model will be provided for Botulinum (3 area) treatment and 1 - 2 clients for filler to ensure that each of the key anatomical areas covered are observed. Morning = Botulinum (0900 - 1230) Afternoon = Botulinum and Option Dermal fillers (1330 - 1630) Conclusion Candidates given session and refreshments and discussion regarding Case Studies and further support. (1700 - 1800)

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

Duration 5 Days 30 CPD hours This course is intended for Students in this course are interested in Azure development or in passing the Microsoft Azure Developer Associate certification exam. This course teaches developers how to create end-to-end solutions in Microsoft Azure. Students will learn how to implement Azure compute solutions, create Azure Functions, implement and manage web apps, develop solutions utilizing Azure storage, implement authentication and authorization, and secure their solutions by using KeyVault and Managed Identities. Students will also learn how to connect to and consume Azure services and third-party services, and include event- and message-based models in their solutions. The course also covers monitoring, troubleshooting, and optimizing Azure solutions. Prerequisites To be successful in this course, learners should have the following: Hands-on experience with Azure IaaS and PaaS solutions, and the Azure Portal. Experience writing in an Azure supported language at the intermediate level. (C#, JavaScript, Python, or Java) Ability to write code to connect and perform operations on, a SQL or NoSQL database product. (SQL Server, Oracle, MongoDB, Cassandra or similar) Experience writing code to handle authentication, authorization, and other security principles at the intermediate level. A general understanding of HTML, the HTTP protocol and REST API interfaces. 1 - Explore Azure App Service Examine Azure App Service Examine Azure App Service plans Deploy to App Service Explore authentication and authorization in App Service Discover App Service networking features 2 - Configure web app settings Configure application settings Configure general settings Configure path mappings Enable diagnostic logging Configure security certificates 3 - Scale apps in Azure App Service Examine autoscale factors Identify autoscale factors Enable autoscale in App Service Explore autoscale best practices 4 - Explore Azure App Service deployment slots Explore staging environments Examine slot swapping Swap deployment slots Route traffic in App Service 5 - Explore Azure Functions Discover Azure Functions Compare Azure Functions hosting options Scale Azure Functions 6 - Develop Azure Functions Explore Azure Functions development Create triggers and bindings Connect functions to Azure services 7 - Explore Azure Blob storage Explore Azure Blob storage Discover Azure Blob storage resource types Explore Azure Storage security features Discover static website hosting in Azure Storage 8 - Manage the Azure Blob storage lifecycle Explore the Azure Blob storage lifecycle Discover Blob storage lifecycle policies Implement Blob storage lifecycle policies Rehydrate blob data from the archive tier 9 - Work with Azure Blob storage Explore Azure Blob storage client library Create a client object Manage container properties and metadata by using .NET Set and retrieve properties and metadata for blob resources by using REST 10 - Explore Azure Cosmos DB Identify key benefits of Azure Cosmos DB Explore the resource hierarchy Explore consistency levels Choose the right consistency level Explore supported APIs Discover request units 11 - Work with Azure Cosmos DB Explore Microsoft .NET SDK v3 for Azure Cosmos DB Create stored procedures Create triggers and user-defined functions Explore change feed in Azure Cosmos DB 12 - Manage container images in Azure Container Registry Discover the Azure Container Registry Explore storage capabilities Build and manage containers with tasks Explore elements of a Dockerfile 13 - Run container images in Azure Container Instances Explore Azure Container Instances Run containerized tasks with restart policies Set environment variables in container instances Mount an Azure file share in Azure Container Instances 14 - Implement Azure Container Apps Explore Azure Container Apps Explore containers in Azure Container Apps Implement authentication and authorization in Azure Container Apps Manage revisions and secrets in Azure Container Apps Explore Dapr integration with Azure Container Apps 15 - Explore the Microsoft identity platform Explore the Microsoft identity platform Explore service principals Discover permissions and consent Discover conditional access 16 - Implement authentication by using the Microsoft Authentication Library Explore the Microsoft Authentication Library Initialize client applications 17 - Implement shared access signatures Discover shared access signatures Choose when to use shared access signatures Explore stored access policies 18 - Explore Microsoft Graph Discover Microsoft Graph Query Microsoft Graph by using REST Query Microsoft Graph by using SDKs Apply best practices to Microsoft Graph 19 - Implement Azure Key Vault Explore Azure Key Vault Discover Azure Key Vault best practices Authenticate to Azure Key Vault 20 - Implement managed identities Explore managed identities Discover the managed identities authentication flow Configure managed identities Acquire an access token 21 - Implement Azure App Configuration Explore the Azure App Configuration service Create paired keys and values Manage application features Secure app configuration data 22 - Explore API Management Discover the API Management service Explore API gateways Explore API Management policies Create advanced policies Secure APIs by using subscriptions Secure APIs by using certificates 23 - Explore Azure Event Grid Explore Azure Event Grid Discover event schemas Explore event delivery durability Control access to events Receive events by using webhooks Filter events 24 - Explore Azure Event Hubs Discover Azure Event Hubs Explore Event Hubs Capture Scale your processing application Control access to events Perform common operations with the Event Hubs client library 25 - Discover Azure message queues Choose a message queue solution Explore Azure Service Bus Discover Service Bus queues, topics, and subscriptions Explore Service Bus message payloads and serialization Explore Azure Queue Storage Create and manage Azure Queue Storage and messages by using .NET 26 - Monitor app performance Explore Application Insights Discover log-based metrics Instrument an app for monitoring Select an availability test Troubleshoot app performance by using Application Map 27 - Develop for Azure Cache for Redis Explore Azure Cache for Redis Configure Azure Cache for Redis Interact with Azure Cache for Redis by using .NET 28 - Develop for storage on CDNs Explore Azure Content Delivery Networks Control cache behavior on Azure Content Delivery Networks Interact with Azure Content Delivery Networks by using .NET