The National Health Service (NHS) remains a beacon of hope and symbol of pride for the United Kingdom. As one of the world's largest employers, it provides an array of opportunities for individuals aiming to make a difference in people's lives. Being part of the NHS or the wider healthcare industry in the UK is not just about having a job; it's a vocation that requires passion, dedication, and most importantly, specialised skills and knowledge. Given the increasing complexities of medical care, there's a soaring demand for professionals equipped with specialized skills, ranging from nursing and clinical care to medical writing and understanding medical law. Enter our 25 courses Healthcare Skill & Knowledge Enhancement Bundle, meticulously crafted for those keen on deepening their understanding and honing their expertise in various niches within the healthcare industry. Why This Bundle? Comprehensive Curriculum: From the foundation of nursing to the complexities of medical law and safety regulations, our courses cover all the essential areas that are crucial for a healthcare professional in today's dynamic environment. Empowerment through Knowledge: Whether it's mastering medical jargon or understanding European Medical Device Regulations, this bundle ensures you stay at the top of your game, making you an indispensable asset in the healthcare sector. This Nursing & Care Bundle Comprises the Following CPD Accredited Courses: Course 1: Care Certificate - 15 Standards Course 2: Health & Social Care Level 3 Course 3: Nursing Assistant Diploma Course 4: Adult Care Management Course 5: Medical Gases Course 6: Basic Principles of Health Care Delivery Course 7: Duty of Care & Safety Responsibilities Course 8: Care Planning and Record Keeping | Health & Safety Course 9: Communication & Information Handling in Care Course 10: Phlebotomy Training Course 11: Medical & Clinical Administration Diploma Course 12: Essentials of European Medical Device Regulations Course 13: Medical Writing Course 14: Medical Transcription Course 15: Medical Terminology Training Course 16: Mental Health Nursing Course 17: Medical Law Course 18: Medical Jargon for Healthcare Assistant Course 19: Clinical Observations Skills Course 20: Introduction to Vaccination Course 21: First Aid Training Course Course 22: Anaphylaxis & BLS Course 23: Verification of Death Course 24: Safe Handling of Medicines Course 25: Adult Nursing Learning Outcomes: Achieve a foundational understanding of nursing with the Nursing Assistant Diploma. Grasp essential principles of effective healthcare delivery. Learn about care duties, health & safety, and safe medicine management. Specialise in health and safety-centric care plans and record-keeping. Hone interpersonal and data management skills for care settings. Master phlebotomy techniques and death verification procedures. Explore European medical device regulations for compliance. Improve medical writing skills and decode intricate terminology. Study mental health nursing, vaccination basics, and anaphylaxis & BLS. Familiarise yourself with the basics of IsiXhosa for enhanced patient communication. Why Invest in This Bundle? Holistic Knowledge Base: The Health & Care bundle offers a diversified range of 25 meticulously curated courses. Whether you're keen to understand the foundational principles of healthcare delivery, medical terminologies, or the intricacies of European medical device regulations, this bundle has got you covered. Aligned with Industry Standards: Courses such as the Care Certificate - 15 Standards and Health & Social Care Level 3 are structured around recognised and essential guidelines, ensuring learners receive information that is compliant and updated. Enhanced Skills for Specialised Roles: Whether it's mastering the art of phlebotomy, diving deep into the mental health nursing realm, or becoming proficient in medical writing, the courses cater to a broad spectrum of specializations, adding immense value to your skill set. Stay Updated: With rapid advancements in medical science and healthcare regulations, it's paramount to stay informed. Courses focusing on areas like European medical device regulations or medical law keep learners at the forefront of essential regulatory changes. Equip for Various Responsibilities: The bundle ensures learners are well-versed in both the clinical and administrative facets of healthcare. From care planning and record-keeping to understanding duty of care and safety responsibilities, the courses equip learners to handle diverse responsibilities with aplomb. Elevate Clinical Expertise: Understanding the nuances of clinical observation skills, safe handling of medicines, and adult nursing are pivotal in the healthcare sector. Through specialised courses, enhance your clinical expertise and be better prepared to manage and respond to real-world situations. Bridge Knowledge Gaps: Whether you're unfamiliar with medical jargon or seek a comprehensive understanding of anaphylaxis & BLS, the bundle helps bridge knowledge gaps, making healthcare concepts more accessible. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Nursing, Observation skills, Medical Writing, Medical Law, Health and Safety bundle is ideal for the following: Aspiring and current healthcare professionals. Those seeking to excel in medical writing and communication. Individuals are interested in medical law and safety protocols. Healthcare workers aim to enhance patient care skills. Anyone desiring a comprehensive healthcare understanding. Please be informed that this course doesn't provide any formal qualification. To get qualified, you have to join programs such as - Level 3 NVQ Health and Social Care Level 5 NVQ Health and Social Care Level 2 NVQ Health and Social Care Level 4 NVQ Health and Social Care A-Level Health Social Care QCF Level 2 Health and Social Care Health and Social Care Level 3 QCF Level 3 Health and Social Care Level 2 Certificate in Preparing to Work in Adult Social Care Level 2 Diploma in Health and Social Care (Adults) for England (RQF), etc. Requirements Without any formal requirements, you can delightfully enrol on this Nursing, Observation Skills, Medical Writing, Medical Law, Health and Safety bundle. Career path Our bundle will prepare you for a range of careers, including: Certified Nursing Assistant. Medical Writer or Content Creator. Compliance Officer in healthcare. Clinical Observer or Patient Care Technician. Healthcare Administrator or Manager. Versatile Healthcare Professional. The combined salary range for careers associated with this bundle typically varies from £20,000 to £45,000 annually. Certificates CPD Accredited Certificate Digital certificate - Included
Description: Learning how to express what you need is a basic human function. Reading is an action which is considered as a skill of reading and understanding written or printed materials. Writing, another action of communication is the ability to communicate through making words on papers and composing text. Speaking is also a form of communication through conveying information in spoken language. Through this course, you will learn how to master all these three skills to be able to communicate effectively. Who is the course for? People who are in need to enhance their English written skills. Professionals, writers, and editors who write in the English language. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Mastering Skills (Reading, Writing & Speaking) course is a useful qualification to possess, and will be very helpful to have especially for these careers: Businessmen Copywriter Editor Journalist Marketing Content Creator Product Creator Professor Teacher Technical Writer. Module 1: Reading Introduction 01:00:00 Before Speed Reading 01:00:00 How People Read 01:00:00 Radically Increasing Your Reading Speed 01:00:00 Suggestions for Improving Speed and Effectiveness 01:00:00 Human Mind and Vocalization 01:00:00 Getting the Main Idea 01:00:00 Conclusion 00:15:00 Module 2: Writing INDEX OF RULES 00:30:00 CLEARNESS AND FORCE 01:00:00 ORDER OF WORDS IN A SENTENCE 01:00:00 EXERCISES 01:00:00 CONTINUOUS EXERCISES 01:00:00 Module 3: Speaking Public Speaking Basics 01:00:00 Know Your Audience 00:30:00 Use The Right Words 00:30:00 Decide What You Want To Convey 00:30:00 Learn How to Communicate 00:30:00 What Happens If Your Don't Connect to Your Audience 00:30:00 Wrapping Up 00:15:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00
Four weeks of revision exercises, study stories and feedback exchange for flash fiction authors.
About Course A Comprehensive Course on Business Communication and Communication Skills In this Business Communication online course by Xpert Learning, you will learn how to adapt your communication style for different audience, how to nuance your communication in different situations and mediums, and in this process, maximize productivity. You will also learn the necessary skills to handle difficult conversations within the workplace. According to a LinkedIn survey, Communication is identified as the most sought-after soft skill among employers. Communication is an essential skill for every individual regardless of position in the hierarchy, industry, or location. For achieving organizational success, effective communication is crucial. Through precise and succinct communication, organizations can develop better strategies, enhance productivity, boost morale, and stimulate innovation. Because communication is so important in business, Organizations want and need people with good communication skills. However, most individuals do not communicate well and they are unaware of the fact. The communication shortcomings of employees and the importance of communication in business explain why you should work to improve your communication skills. Your ability to communicate effectively will determine how others perceive you, and largely, your performance and value in the organization. Business Communication is a Learned skill: you learn when and how to say or write the message that needs to be delivered. You can learn this skill from the comprehensive course developed by Xpert Learning. Through different learning mediums you will learn how to understand your audience and nuance your message accordingly, qualities of Effective Business Writing, how to write precise Business Reports, Emails, how to present a Steller Business presentation, and how to use these skills in your career development. Enroll today in this Business Communication Course and advance your career with Xpert Learning! What Will You Learn? Understand the importance of effective communication in business settings Identify and analyze different types of audiences and tailor communication to their needs Develop skills for writing clear, concise, and effective business documents, such as reports and emails Learn techniques for delivering effective business presentations Understand the importance of continuous learning and career development in a business environment Course Content Introduction to Business Communication Introduction to Business Communication Understanding your Audience and Deliver your Message Understanding your Audience and Deliver your Message Effective Business Writing Effective Business Writing Writing Business Reports and Emails Writing Business Reports and Emails Business Presentation Business Presentation Part 1 Business Presentation Part 2 Sample Presentation Career Development Career Development: Job Searching, Resume/CV, Cover Letters, and Interview skills Conclusion Conclusion A course by Xpert Learning RequirementsThere are no specific requirements or prerequisites for this course. Learners of all levels and backgrounds can benefit from this course. However, it would be beneficial if learners have a basic understanding of business communication. Audience This course is designed for individuals who want to develop their business communication skills, including managers, executives, and professionals in various industries. Additionally, this course is also beneficial for students who are pursuing business-related degrees or courses and want to improve their communication skills in a business setting. Whether you are a beginner or an experienced professional, this course can help you elevate your communication skills and achieve your business goals. Audience This course is designed for individuals who want to develop their business communication skills, including managers, executives, and professionals in various industries. Additionally, this course is also beneficial for students who are pursuing business-related degrees or courses and want to improve their communication skills in a business setting. Whether you are a beginner or an experienced professional, this course can help you elevate your communication skills and achieve your business goals.
Unlock your full potential and thrive in your career with our Certificate in Mastering the Art of Bid Writing: Comprehensive Online Training at QLS Level 3 course. This comprehensive course covers the key elements of successful bid writing, equipping you with the necessary tools to win contracts and secure business growth. Whether you're a seasoned professional or just starting, this course helps you master proposal development, client-centric focus, unique selling points identification, and pricing strategies. This online training navigates through 12 insightful modules, starting from the foundational aspects of bid writing to the detailed estimation methods, all the way to quality control and compelling client presentations. Mastering these topics will enable you to create convincing proposals and ensure optimal returns on investment. Our expertly designed course structure allows you to learn at your pace, helping you to grow in this critical business function. Enrol in our Mastering the Art of Bid Writing course today and elevate your professional stature. With our specialised training in proposal process, client engagement, and proposal building templates, you will emerge as an expert in bid writing. Deliver powerful and compelling bids that win clients and foster business success. Learning Outcomes Acquire foundational and advanced knowledge of bid writing. Develop effective strategies for planning and formulating bids. Learn a structured approach to writing compelling proposals. Understand the nuances of customer-centric bid development. Identify unique selling points for competitive bidding. Grasp effective estimation methods for costing and pricing. Master quality control processes for editing and improving bids. Gain expertise in client presentation and proposal template building. Why buy this Mastering the Art of Bid Writing course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Mastering the Art of Bid Writing course for? Professionals seeking to enhance their bid writing skills. Start-ups aiming to win contracts and boost business growth. Business students looking to specialize in procurement and contract management. Any individual interested in understanding and mastering bid writing Career path This Bid Writing course can open up job opportunities in contract management, procurement, business development, and project management. With mastered skills in bid writing, you'll be a valuable asset to organisations aiming to secure high-value contracts, positioning yourself for roles such as Bid Manager, Proposal Writer, and Procurement Specialist. Prerequisites This Certificate in Mastering the Art of Bid Writing: Comprehensive Online Training at QLS Level 3 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £85 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Module 01: Bid Writing Bid Writing 00:30:00 Module 02: Planning and Developing the Bid Planning and Developing the Bid 00:30:00 Module 03: Structured Approach to Writing Bids Structured Approach to Writing Bids 00:30:00 Module 04: Understanding the Proposal Understanding the Proposal 00:30:00 Module 05: Proposal Process Proposal Process 00:30:00 Module 06: Focusing on Clients and Customers Focusing on Clients and Customers 00:30:00 Module 07: Finding Unique Selling Points Finding Unique Selling Points 00:30:00 Module 08: Estimation Method Estimation Method 00:30:00 Module 09: Costing and Pricing Costing and Pricing 00:30:00 Module 10: Quality Control (Editing) Quality Control (Editing) 00:30:00 Module 11: Client Presentation Client Presentation 00:30:00 Module 12: Templates for Proposal Building Templates for Proposal Building 00:30:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00
Want to know how to transfer books to Kindle and make money in the process? The Create Your First Kindle Book course designed for the individuals who want to learn all the myths, fables, rules and reviews about what it takes to write and publish a book. Initially, you will receive step by step guideline to start writing a book. The course will show you an astonishingly easy way, where you will get ideas for writing and have a book to share. Explore more about layout and formatting, following with learning a few fundamental text-formatting rules that will enable you to transform the pages of your script into a final book that looks attractive and professional. Last but not the least, you will learn how the technology of the iPhone can be effectively used to get your book started. What Will I Learn? Will know that they can actually write and share a book of their thoughts and ideas in a simple but powerful way. How to cultivate and live with a writer's 'state of mind.' that give us the power and confidence to achieve our goals. Know that you are not going to write a book as much as you are going to perform your story and solutions so a book can be written. Learn how the technology of the iPhone can be effectively used to get the book, your book, started. You will start to claim the term writer and enjoy the fun of being a book writer. Requirements They will need to have some idea of what they want to achieve in their life and business. Who is the target audience? Starting now, in life and business, your book will be your business card and your broadcast will be your brochure, so every aspiring professional and anyone who has had in any way an inclination that ,'perhaps I should try to write a book'. If you are not willing to be challenged in your ideas and beliefs you should not take this course because all of Stan Hustad's courses contain new and creative information combined with challenging ideas and a call to accept and take action on tough challenges. Create Your First Kindle Book Introduction to Creating Your First Book FREE 00:03:00 How To Start To Write Your First Book - Stan Hustad FREE 00:08:00 How To Make This Idea Work For You! 00:13:00 Our State of Mind Matters ... a lot! 00:15:00 A Writer Is a Capturer ... How To Do That! copy 00:13:00 You Are a Writer - Tools of The Trade - Power of The iPhone copy 00:16:00 Ready Set Run! copy 00:10:00 Start With Why, Who & What When Writing Your First Book copy 00:12:00 Image & Cover Matter - Keep your Energy Level High copy 00:10:00 This Is For You - Teach & Write -To Change the World! copy 00:08:00
SNMP training course description A hands-on generic look at the technical operation of SNMP. The course starts with an overview of all the components, which make up SNMP. Hands on starts early with configuration of a managed network. The major versions of SNMP are then put into perspective followed by a look at the SNMP protocol. MIBs are then studied both from the perspective of reading MIBs and writing MIBs. The course finishes with a look at the security implications of SNMP. What will you learn Describe the SNMP architecture. Analyse SNMP packets. Recognise the MIB structure. Describe the SMI. Recognise the strengths and weaknesses of SNMPv2 and SNMPv3. SNMP training course details Who will benefit: Network administrators. Network operators. Programmers writing MIBs and agents. Prerequisites: TCP/IP Foundation for engineers Hands on experience of an SNMP management station would also be beneficial. Duration 3 days SNMP training course contents Network management What is network management? Benefits, issues. What is SNMP? SNMP architecture, SNMP MIBs, SMI, the SNMP protocol, polling security, alternatives to SNMP: CMIP, web based management. Configuring SNMP Auto discovery for management stations, NMS configuration, agent configuration, traps. Hands on Configuring agents and an NMS. SNMP background SNMP history, RFCs, standards, SNMP protocol versions, SNMPv1, SNMPv2, SNMPv3, SNMP SMI versions, which version should you use? Futures. SNMPv1 packets SNMP in the 7 layer model, port numbers, general packet format, BER, GET, GET-NEXT, tables, SET, TRAP, bandwidth issues, in band versus out of band management. Hands on Analysing SNMPv1 packets. SNMPv2 packets SNMPv2 improvements, error handling, GETBULK, v2traps, INFORM. Hands on Analysing SNMPv2 packets. SNMPv3 packets SNMPv3 packet format, use of SNMPv2 messages, REPORT PDU. MIB structure The internet MIB branch, standard mib-2, extra parts of mib-2, private enterprise MIBs, loading extra MIBs. Hands on MIB browsing. mib-2 The mib-2 groups, system group, interfaces group, IP group, ICMP group, TCP group, UDP group, transmission group, SNMP group, RMON. Hands on mib-2 browsing in detail. SMI The MIB layout, obtaining a private enterprise number, MIB definitions, IMPORT, Module identity, Textual conventions, object definitions, notifications, compliance statements, object groups, base SMI data types, application data types, scalars, instances, tables, table definition, writing agents, SMIng. SNMP security Community strings, SNMPv1 and SNMPv2c security practices, SNMPv3 security, SNMPv3 architecture, SNMP applications, the SNMP engine, the EngineID, security fields in SNMPv3 packets, USM, authentication, encryption, timeliness, VBAC, SNMPv3 configuration.
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