• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

2018 Open courses

Sterling Silver Bangle Workshop.

By Oldman House Studio

Sterling Silver Bangle Workshop For Complete Beginners. A day to learn some basic silver jewellery making techniques and create your own bangles. Learn to use basic tools and techniques to form and texture, hammered or waved bangles to completion. Going home with beautifuly finished items of jewellery. The ticket price covers the cost of tuition and all precious and non precious practice materials. Whilst soldering experience is not necessary, a basic understanding of soldering and forming metal would be advantageous, enabling you more time to focus on your design. However, we practice simple soldering techniques, for those with little or no experience. To ensure that all abilities are catered for. On the day you will design and make gorgeous sterling silver bangles. You will be guided through a variety of techniques. You can choose from a variety of designs to make two bangles. You can choose to make hammered textures, using small specialised hammers. Twisted wire bangles. Waved or plain round bangles or a combination of two designs. If you wish, these can be joined together with a large jump ring. Price includes all precious materials, practice materials & instruction. We also include light refreshments of hot and cold drinks with plenty of cake and biscuits throughout the day. Please note, this ticket is your deposit and is non-refundable unless the event is cancelled. We reserve the right to cancel the event if we do not have a minimum of 3 people, in which case your payment will be fully refunded. To ensure the quality of your personal experience, the classes are limited to six people. You will have quality time to ask any questions you might have, and guided help along the way. Suitable for complete beginners and limited to adults only. You will be provided with an apron and safety glasses but please wear workshop appropriate clothing on the day (no open toe shoes or loose clothing) for your safety. Please get in touch if you’d like a group booking on an alternative date. About the workshop Make your own bangles - choice of different designs and textures. There are different texture and forming tools to choose from, to make your bangle combinations unique to you. We cover a range of basic silversmithing techniques in this workshop so it really is a great introduction to working with silver. Who is it for? Beginners onwards. What will I learn? You'll learn the basics of jewellery making, including annealing, sawing, filing, soldering, shaping, forming, texturing and polishing. What's included? We provide all the equipment and materials you will need including the sterling silver to make your bangles. Tea, coffee and cake are also included on the day. What shall I bring? Reading glasses if you use them. Also to keep you safe it's best to wear closed toed shoes, tie long hair back and avoid loose flapping clothing. For more information about our terms and conditions, please refer to the link on our Facebook page, or feel free to contact us. Please be aware that cancellations made within two weeks of the event date will forfeit the workshop fee, although we may be able to fill your place and offer a refund. We reserve the right to cancel the class if we do not have a minimum of three people attending. Should this happen, your payment will be fully refunded. We are committed to ensuring that every participant has a fantastic time, and we can't wait to see you at our next workshop!

Sterling Silver Bangle Workshop.
Delivered In-PersonFlexible Dates
£85

Sterling Silver Bangle Workshop. June 30th

By Oldman House Studio

Sterling Silver Bangle Workshop For Complete Beginners. A day to learn some basic silver jewellery making techniques and create your own bangles. Learn to use basic tools and techniques to form and texture, hammered or waved bangles to completion. Going home with beautifuly finished items of jewellery. The ticket price covers the cost of tuition and all precious and non precious practice materials. Whilst soldering experience is not necessary, a basic understanding of soldering and forming metal would be advantageous, enabling you more time to focus on your design. However, we practice simple soldering techniques, for those with little or no experience. To ensure that all abilities are catered for. On the day you will design and make gorgeous sterling silver bangles. You will be guided through a variety of techniques. You can choose from a variety of designs to make two bangles. You can choose to make hammered textures, using small specialised hammers. Twisted wire bangles. Waved or plain round bangles or a combination of two designs. If you wish, these can be joined together with a large jump ring. Price includes all precious materials, practice materials & instruction. We also include light refreshments of hot and cold drinks with plenty of cake and biscuits throughout the day. Please note, this ticket is your deposit and is non-refundable unless the event is cancelled. We reserve the right to cancel the event if we do not have a minimum of 3 people, in which case your payment will be fully refunded. To ensure the quality of your personal experience, the classes are limited to six people. You will have quality time to ask any questions you might have, and guided help along the way. Suitable for complete beginners and limited to adults only. You will be provided with an apron and safety glasses but please wear workshop appropriate clothing on the day (no open toe shoes or loose clothing) for your safety. Please get in touch if you’d like a group booking on an alternative date. About the workshop Make your own bangles - choice of different designs and textures. There are different texture and forming tools to choose from, to make your bangle combinations unique to you. We cover a range of basic silversmithing techniques in this workshop so it really is a great introduction to working with silver. Who is it for? Beginners onwards. What will I learn? You'll learn the basics of jewellery making, including annealing, sawing, filing, soldering, shaping, forming, texturing and polishing. What's included? We provide all the equipment and materials you will need including the sterling silver to make your bangles. Tea, coffee and cake are also included on the day. What shall I bring? Reading glasses if you use them. Also to keep you safe it's best to wear closed toed shoes, tie long hair back and avoid loose flapping clothing. For more information about our terms and conditions, please refer to the link on our Facebook page, or feel free to contact us. Please be aware that cancellations made within two weeks of the event date will forfeit the workshop fee, although we may be able to fill your place and offer a refund. We reserve the right to cancel the class if we do not have a minimum of three people attending. Should this happen, your payment will be fully refunded. We are committed to ensuring that every participant has a fantastic time, and we can't wait to see you at our next workshop!

Sterling Silver Bangle Workshop. June 30th
Delivered In-PersonFlexible Dates
£85

GCSE Tuition - Religious Studies - In Person, London, Lambeth, Wandsworth, Merton, Southwark, Kensington & Chelsea

5.0(8)

By GLA Tutors Home or Online

Excelling in GCSE Religious Studies! At GLA Tutors, we are dedicated to helping students succeed in their GCSE Religious Studies examinations. Our experienced tutors are passionate about the subject and committed to providing comprehensive support aligned with the AQA examination board's specification. Let's explore the breakdown of the AQA GCSE Religious Studies specification: Paper 1: The Study of Religions: Beliefs and Teachings This paper focuses on the study of two religions, such as Christianity and Islam. Our tutors will guide students through the fundamental beliefs, teachings, and practices of these religions. We delve into topics like the nature of God, religious texts, worship, and the impact of religion on individuals and society. Through engaging discussions and thought-provoking exercises, we help students develop a deep understanding of religious beliefs. Paper 2: Thematic Studies This paper explores ethical and philosophical issues, as well as the influence of religion in the modern world. Our tutors will delve into topics like crime and punishment, human rights, life and death, and religion and society. We provide in-depth analysis, case studies, and perspectives from different religious traditions to enable students to critically examine these issues. We also emphasise the development of strong argumentation and evaluation skills. Paper 3: Study of Religion: Textual Studies In this paper, students will explore religious texts and their significance. Our tutors will guide students through the study of sacred texts, such as the Bible or the Qur'an. We help students analyse and interpret these texts, understand their historical and cultural context, and explore their relevance in contemporary society. We provide comprehensive guidance on textual analysis and the application of religious teachings to real-life situations. At GLA Tutors, we foster a supportive and inclusive learning environment, where students can explore and deepen their understanding of religious studies. Our tutors provide personalised one-on-one sessions, group discussions, and access to a range of learning resources to cater to each student's unique needs. Beyond the specification, we encourage critical thinking, empathy, and open-mindedness, enabling students to engage with complex ethical and philosophical questions. We also focus on developing strong exam techniques, essay writing skills, and effective revision strategies to maximize exam success. Join us at GLA Tutors and embark on a transformative journey in GCSE Religious Studies. Our tutors are here to guide you towards academic excellence, a deep appreciation for religious diversity, and the ability to apply religious teachings to real-world contexts. Feel free to exploreour websitefor more information or reach out to us with any questions you may have.  https://www.globallearners.academy/services/gcse We can provide assistance for everything you need to prepare students for exams, including: past papers, mark schemes and examiners’ reports specimen papers and mark schemes for new courses exemplar student answers with examiner commentaries high quality revision guides

GCSE Tuition - Religious Studies - In Person, London, Lambeth, Wandsworth, Merton, Southwark, Kensington & Chelsea
Delivered In-Person in LondonFlexible Dates
£60

Introduction Day to Shamanism 6th September 2025

4.9(30)

By School of Shamanism

Join me for a full immersive day, online and in Edinburgh at the Art and Spirituality Centre, with theory and practice to discover: 🔍What Shamanism is and its origins 🔍How to journey for yourself and another person 🔍How to retrieve a gift 🔍Introduction to healing: extractions and soul retrieval 🔍Power dance Please have with you: 🌟 a blindfold 🌟 your favourite scarf to be used as a magic cloak 🌟 a notebook if you like Shamanism is a spiritual practice that goes beyond every beliefs and culture and is about trying to reach your full potential as you walk on planet earth, so connecting yourselves to the whole. Shamans were described as the first physicians, magicians, artists, storytellers, spiritual beings. But shamans are healers that make changes in invisible realms to help healing in the ordinary reality of the community. Shamans see in the darkness while connecting with the divine outside the time in an altered state of consciousness. The Powerful Benefits of Shamanic Drumming Shamanic drumming can: 🌿 Reduce stress 🌿 Improve concentration 🌿 Open the door to self-acceptance 🌿 Encourage healthier lifestyle choices 🌿 Support cardiovascular health 🌿 Boost your immune system 🌿 Promote deeper self-awareness by synchronizing brain activity and inducing alpha waves 🌿 Help release negative emotions and emotional trauma Lunch is not included Giada's Journey Creative explorer of the human well-being with twenty years’ experience running events, workshops and retreats. Co-author of a non-profit book with other 33 Italian women about their stories in different countries. She has been learning to heal herself supporting a Holistic connection between mind, body and spirit. She has been studying and practicing Buddhist teachings, meditation and the Five Tibetan Rites Yoga in Nepal, India and Italy. Approached the imaginal world and dreams with the psychologist Elio Occhipinti and a regressive hypnosis journey with the vision of the psychiatrist Brian Weiss.  Her studies and practice have helped her become: Shamanic Practitioner and Teacher with the two years formal training at Anam Cara and Teacher Training in Wales  Shamanic and Integral Yoga Teacher, Ikigai Coach, Forest Therapy Guide qualified with Selene Calloni Williams at the Imaginal Academy and part of the Italian-Swiss Association for Counselling and Coaching, Aiscon.  Professional Esoteric Numerologist graduated at The Connaissance School of Numerology Corporate Mental Health Coach achieved with WeFocus Founder of Drink In Art exhibitions of local artists in private flats Founder of School of Shamanism creative and spiritual workshops, classes and therapies Founder of the Art and Spirituality Centre centre for creativity and well-being in Edinburgh By attending to our classes, workshops and retreats you agree to our TERMS AND CONDITIONS Payment  Bookings are non-refundable.  Disclaimer  By booking a class or workshop or retreat or 1-1 session -online or any other venues – with us, you release Giada Gaslini, Invisible Caims/School of Shamanism and any business partners working with Invisible Caims from any liability arising out of any personal injuries, emotional or physical release, death, expectations of results, theft in the venue or damages that may happen to people and objects while attending. We recommend that you consult your GP regarding the suitability of undertaking an exercise programme, if the class you are booking includes it like with yoga or similar, and following all the safety instructions required before beginning to exercise. When participating in an exercise, there is the possibility of sustaining a physical injury. If you engage in this exercise programme, you agree that you do so at your own risk, are voluntarily participating in these activities and assume all risk of injury to yourself. You acknowledge that coaching, shamanic healing and counselling are not to be used as a substitute for psychotherapy, psychoanalysis, mental health care, or other professional advice by legal, medical or other professionals. Our sessions are aimed at inner research, problem solving and personal growth, they do not replace the work of doctors and psychotherapists because they do not consider, treat or aim to solve pathologies and symptoms that are strictly medical. All contracts subject to and governed by English Law and the exclusive jurisdiction of the Courts of England and Wales according to my current insurance.   Added element of the disclaimer If the class happens in any venue and you are causing any damage to the property, you are taking responsibility of your actions. It is down to the individual to take personal responsibility when participating in physical activity and when entering a space that is used and shared by other parties. Invisible Caims does not take any responsibility about possible risks that may arise but can only advise and enforce guidelines and legal requirements as defined by the Scottish Government and local authorities.   

Introduction Day to Shamanism 6th September 2025
Delivered in Edinburgh or Online
£60 to £80

Certified Wireless Analysis Professional

5.0(3)

By Systems & Network Training

CWAP training course description This WiFi analysis course consists of hands-on learning using the latest enterprise wireless LAN analysis and troubleshooting tools. The course takes an in-depth look at the functionality of WLANs, intended operation of the 802.11 protocol and Wi-Fi Alliance specifications, WLAN frame formatting and structure, troubleshooting methodology, and protocol analysis. It also includes extensive training in modern spectrum analysis with a focus on advanced RF behaviour analysis, data collection methods, interpreting spectrum plots and charts, and understanding advanced features of WLAN spectrum analysers. What will you learn Analyse WiFi frames using Wireshark. Explain 802.11 protocol operation. Troubleshoot WiFi networks using Wireshark. Troubleshoot WiFi networks using spectrum analysers. CWAP training course details Who will benefit: Technical Network Staff Anyone looking to become a CWAP Prerequisites: Certified Wireless Network Administrator Duration 4 days CWAP training course contents Principles of WLAN Communication 802.11 Working Group, OSI reference model and the 802.11 PHY and MAC, Communication sublayers and data units, WLAN architecture components, Organization of station forwarding Addressing and internetworking operation, Modern WLAN product architectures. Physical (PHY) and MAC Layer Formats and Technologies Physical layer functions, Preamble function and format, Header purpose and structure, Analysis of PHY problems, Physical PPDU formats, 802.11b, 802.11a, 802.11g, 802.11n, MAC frame components, MAC encapsulation, Fields and subfields of the MAC header, Frame Control, Frame types and subtypes and their uses, Addressing, Frame body, Data frame format, Control frame format, Management frame format, Information elements and fields. Beaconing and synchronization Scanning, Client state machine, 802.11 contention, QoS, Admission control, Band steering and airtime fairness mechanisms Fragmentation, Acknowledgments and Block acknowledgments, Protection mechanisms and backward compatibility, Power management, Dynamic Frequency Selection (DFS) and Transmit Power Control (TPC), Security components, methods, and exchanges, Roaming procedures exchanges, Future protocol enhancements. 802.11n Transmit beamforming, Spatial multiplexing, Maximal Ratio Combining (MRC), Space-Time Block Coding, 40 MHz channels, Frame aggregation, HT-OFDM format, Modulation and Coding Schemes (MCS), HT frame formatting and more. Protocol Analysis Tools and Methodology Troubleshooting methodology, Protocol analyser types, Analysis NIC/adapter selection and constraints, Interpreting results based on location, Analyzer settings and features, Filtering and channel scanning, Interpreting decodes, Using advanced analysis features, Assessing WLAN health and behaviour factors, Evaluating network statistics, Troubleshooting common problems, Wired analysis to support wireless network issues. Spectrum Analysis Tools and Methodology Radio frequency behaviour review, Visualizing RF domains using spectrum measurement tools, Spectrum analyser types and operation, Analyser specifications and characteristics, Understanding spectrum data presentation, Interpreting plots and charts, Common WLAN spectrum analyser features, Identifying transmit patterns, Device classification and network impact, Recognizing transmit signatures. Hands on lab exercises Wireshark Setup, Use, and In-Depth Analysis Wireshark is fundamental to troubleshooting. Labs include: - Capabilities, configuration, and data display - Opening, collecting, saving, and modifying capture files. - Filtering traffic, and using colouring rules as analysis aides. - Live captures based on a set of desired collection criteria. - Identify and isolate network problems. - Conversation analysis. - Remote packet capture with an AP. Understanding Frame Components Familiarity with the frame structure and contents is essential in real -world troubleshooting efforts. Labs include: - Understanding the MAC header - Comparing the three major frame types and their subtypes - Analysing frame formats of individual frame types - Analysing 802.11n frame components - Additional information is reported by protocol analysers - Information not visible in protocol analysers Frame Exchanges Understanding frame exchange rules and behaviors is critical to identifying expected and unexpected. It is also necessary to understand what is normal so that aberrations can be properly troubleshot. Labs include: - Connectivity exchanges and sequences - Legacy and modern security exchanges - ERP and HT protection mechanisms - Power save behaviour - Acknowledgments, block acknowledgments, and supporting action frames - Dynamic rate switching - Band steering Troubleshooting Common Problems This lab exposes students to hands-on troubleshooting skills by setting up common problems in WLANs and allowing students to attempt to solve them. - Trouleshooting connectivity exchanges - Troubleshooting 802.1X and EAP exchanges - Troubleshooting roaming Spectrum Analyzer Setup, Use, and In-Depth Analysis Specifically, it will explore the plots and charts used to display spectrum data and how to interpret this data to define a transmitter's impact on the network. The following are covered: - Installing the analyser and using display and navigation - The 'RF perspective' provided by each plot and chart - Using built-in features and automated device identification - Characterizing the behaviours of an interference source - Assessing the impact of an interference source - Determining the impact of transmitter proximity on interference. - Identifying signatures of common transmitters - Remote spectrum analysis with an AP

Certified Wireless Analysis Professional
Delivered in Internationally or OnlineFlexible Dates
£3,297

Learn The Art of Smudging

5.0(13)

By Spiritual Vitality

Learn The Art of Smudging Learn everything you need to know to confidently begin incorporating this powerful Smudging Ceremony into your life today! Smudging is a practice of connecting with the Spirit of specific plants and herbs to help cleanse, uplift, protect, and unite the physical and spiritual planes. Ancient traditions all around the world have incorporated the practice of smudging into their ceremonies. Now is your time to connect with “that which is greater than us”.

Learn The Art of Smudging
Delivered in person or OnlineFlexible Dates
£100

GYMD Leaders Workshop | Adolescence, what we've learnt three months on

By The Diocese of St Albans

Adolescence: What have we learnt? In March 2025, the Netflix series Adolescence sparked widespread conversation about the hidden lives of young people, raising important questions about the support we provide to the youth in our care. Three months later, what have we learned? Regardless of how we engage with young people, there's valuable insight to be gained from this powerful story. We’d like to share the key takeaways and reflect on how we can better support the next generation. How the day will go Join us at 9.30 for coffee and pastries, before we hear from a guest speaker on the impact Adolescence has had on their context. Following a short coffee break we will then have time to explore how we can each respond, using the Open Space Technology conference tool to create opportunities for the conversations that will help us to move forward appropriately. We will end with lunch at 12.30pm. Key Information We will be gathering at Youthscape in Luton, which is conveniently located next to Luton Train station, for those traveling by train. For those driving, please note that the car park directly outside Youthscape is no longer available, the closest car park can be located on Power Court, just a 5 minute walk from the venue.

GYMD Leaders Workshop | Adolescence, what we've learnt three months on
Delivered In-Person in Luton
FREE

An Understanding of Tracheostomy Care

By Guardian Angels Training

Gain comprehensive knowledge and practical skills to provide safe and effective care for tracheostomy patients with our "Understanding Tracheostomy Care" course. Learn the management and maintenance of surgical openings in the trachea to facilitate breathing.

An Understanding of Tracheostomy Care
Delivered In-Person in InternationallyFlexible Dates
£1,175

Introduction to lino printing onto paper

5.0(6)

By The Arienas Collective

Fun lino printing workshop run by local artist Suzanne Kemplay at The Arenas Collective creative workshop hub in Edinburgh City Centre.

Introduction to lino printing onto paper
Delivered In-Person in Edinburgh
£95

MySQL for developers

5.0(3)

By Systems & Network Training

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

MySQL for developers
Delivered in Internationally or OnlineFlexible Dates
£2,797