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

6119 Courses

Self Isolation and Self Distancing during COVID 19

By The Teachers Training

Overview Self Isolation and Self Distancing during COVID 19 is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Self Isolation and Self Distancing during COVID 19 and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 04 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Module 01: COVID-19 - The Pandemic COVID-19 - The Pandemic 00:20:00 Module 02: Social Distancing Social Distancing 00:21:00 Module 03: Self Isolation Self Isolation 00:23:00 Module 04: Quarantine and Its Mental Impacts Quarantine and Its Mental Impacts 00:25:00 Module 05: Anxiety and the Feeling of Loneliness Anxiety and the Feeling of Loneliness 00:25:00 Module 06: Young Generation's Mental Health during COVID-19 Young Generation's Mental Health during COVID-19 00:25:00 Module 07: Challenges of Older Generations during COVID-19 Challenges of Older Generations during COVID-19 00:24:00 Module 08: Connectivity during Self-Isolation Connectivity during Self-Isolation 00:28:00 Module 09: Community Response and Reliance on Others Community Response and Reliance on Others 00:25:00 Module 10: Productivity during Self-Isolation Productivity during Self-Isolation 00:22:00 Module 11: Applications of Technology Applications of Technology 00:19:00

Self Isolation and Self Distancing during COVID 19
Delivered Online On Demand4 hours 17 minutes
£24.99

Computer Workstation Safety Training

By Course Cloud

Using computers for long hours can pose health and safety risks, such as musculoskeletal disorders, eye strain, headaches, and mental stress. Computers can also expose you to digital dangers, such as hacking, phishing, ransomware, and identity theft. This course will teach you how to use your computer workstation safely and comfortably, and protect yourself from these hazards.  You will learn how to adjust your work environment, equipment, and habits to suit your needs and preferences. You will also learn how to apply ergonomics, prevent injuries and illnesses, perform stretching and relaxation techniques, and secure your digital devices and data. This course is suitable for anyone who uses computers regularly, whether for work or leisure. By taking this course, you will gain valuable knowledge and skills that will help you improve your productivity, performance, and well-being.

Computer Workstation Safety Training
Delivered Online On Demand
£25

HOW TO DEAL EFFECTIVELY WITH PASSIVE AGGRESSIVE AND TOXIC BEHAVIOUR AT WORK

By Fay Beck Studio

To help address this complex and yet commonplace experience, we’ve designed a one-day workshop to help professionals who experience passive-aggressive behaviour and toxic interpersonal communication in the workplace cope more effectively. Designed to be a decisive first step into gaining control over workplace toxicity, over the course of one day, attendees will be taught to recognise patterns of passive-aggressive behaviours and will learn how to respond appropriately to it. The workshop we will work through exercises to help demystify passive-aggressiveness so that it can be rendered increasingly more harmless to those who experience it routinely. Through specially designed exercises informed by the field of Emotion Psychology and Neuroscience you will also learn how to be less affected by it without resorting to repressing your emotions and shutting down.

HOW TO DEAL EFFECTIVELY WITH PASSIVE AGGRESSIVE AND TOXIC BEHAVIOUR AT WORK
Delivered In-PersonFlexible Dates
£495

Agriculture

By Compete High

🌱 Unlock Your Potential with Our Agriculture Course! Are you ready to cultivate a brighter future in the world of agriculture? Dive into the vast expanse of possibilities with our comprehensive Agriculture course! 🚜   Why Choose Our Agriculture Course? 👩‍🌾 Grow Your Knowledge: From soil management to crop production techniques, our course covers all aspects of modern agriculture, providing you with a solid foundation to thrive in this dynamic field. 📈 Stay Ahead of the Curve: In today's rapidly evolving agricultural landscape, staying updated with the latest trends and technologies is crucial. Our course ensures you're equipped with the most current practices to excel in your endeavors. 💡 Hands-On Learning: Theory is essential, but practical experience is invaluable. That's why our course integrates hands-on learning opportunities, allowing you to apply theoretical concepts in real-world scenarios, enhancing your understanding and skill set. 🌍 Make a Difference: Agriculture plays a vital role in feeding the world's growing population and addressing global food security challenges. By enrolling in our course, you'll be part of a movement driving sustainable agricultural practices and making a positive impact on society and the environment. 🎓 Expert Guidance: Learn from seasoned professionals and industry experts who bring years of experience and insights to the table. Benefit from their mentorship as you navigate through the complexities of agriculture and carve out your path to success.   Who is this for? 👨‍🌾 Aspiring Farmers: Whether you dream of managing your own farm or joining an established agricultural enterprise, this course provides the knowledge and skills you need to kickstart your journey in farming. 👩‍🔬 Agricultural Scientists: If you're passionate about research and innovation in agriculture, our course offers a solid grounding in scientific principles and methodologies, empowering you to contribute to groundbreaking discoveries and advancements in the field. 🌱 Agribusiness Entrepreneurs: For those looking to venture into agribusiness, understanding the intricacies of agriculture is essential for making informed decisions and maximizing profitability. Our course equips you with the business acumen and industry insights necessary to thrive in the competitive agribusiness landscape. 👩‍🎓 Students and Educators: Whether you're pursuing a career in agriculture or teaching the next generation of agricultural professionals, our course provides valuable resources and knowledge to support your academic and career aspirations.   Career Path 🚜 Farm Manager: Take the helm of agricultural operations, overseeing day-to-day activities, managing resources, and optimizing productivity to ensure the success of the farm. 🌾 Crop Consultant: Offer expert advice to farmers on crop selection, planting techniques, pest management, and other aspects of crop production to maximize yields and profitability. 🌱 Sustainability Specialist: Champion sustainable farming practices, promoting environmental stewardship and resource conservation to create a more resilient and eco-friendly agricultural ecosystem. 🔬 Research Scientist: Conduct groundbreaking research in agricultural science, exploring innovative solutions to enhance crop productivity, mitigate climate change impacts, and address global food security challenges. 📊 Agribusiness Manager: Lead strategic initiatives in agribusiness, from market analysis and supply chain management to sales and marketing, driving growth and profitability in agricultural enterprises.   Embark on your journey to success in agriculture today! Enroll in our Agriculture course and unlock a world of opportunities in this thriving industry. 🌱🌟   FAQ (Frequently Asked Questions) - Agriculture Course Q1: What is Agriculture? Agriculture is the practice of cultivating crops, raising animals, and other activities involved in the production of food, fiber, and other products used to sustain human life. It encompasses various practices such as crop cultivation, animal husbandry, forestry, and aquaculture. Agriculture plays a crucial role in providing food security, supporting livelihoods, and contributing to economic development globally. Q2: What are the key principles of sustainable agriculture? Sustainable agriculture aims to meet current food production needs without compromising the ability of future generations to meet their own needs. Key principles of sustainable agriculture include soil health management, water conservation, biodiversity preservation, integrated pest management, and promoting efficient resource use. It emphasizes environmentally friendly practices that promote resilience, minimize negative impacts on ecosystems, and ensure the long-term viability of agricultural systems. Q3: What are the major challenges facing modern agriculture? Modern agriculture faces various challenges, including climate change, soil degradation, water scarcity, pest and disease outbreaks, and socio-economic disparities. Climate change disrupts weather patterns, leading to more frequent extreme weather events such as droughts and floods, which affect crop yields and livestock production. Soil degradation reduces fertility and threatens agricultural productivity, while water scarcity limits irrigation and threatens crop survival. Pests and diseases can devastate crops if not managed effectively, and socio-economic disparities impact access to resources and markets for smallholder farmers. Q4: How can technology improve agricultural productivity? Technology plays a vital role in enhancing agricultural productivity and efficiency. Innovations such as precision farming, genetically modified crops, drones, and remote sensing technologies help farmers monitor crops, optimize inputs, and manage resources more effectively. Machinery and equipment such as tractors, harvesters, and irrigation systems streamline farming operations, saving time and labor. Information and communication technologies provide farmers with access to market information, weather forecasts, and agricultural extension services, enabling them to make informed decisions and improve their yields. Q5: What career opportunities are available in the field of agriculture? The field of agriculture offers diverse career opportunities across various sectors, including farming, agribusiness, research and development, extension services, education, policy-making, and conservation. Career options include agronomist, agricultural engineer, livestock specialist, farm manager, agricultural economist, food scientist, extension officer, environmental consultant, and policy analyst. With the growing demand for sustainable food production and innovation in agriculture, there is a need for skilled professionals to address the challenges and opportunities in the agricultural sector. Course Curriculum Module 1 Introduction to Agriculture Introduction to Agriculture 00:00 Module 2 Soil Management Soil Management 00:00 Module 3 Sustainable Agriculture Practices Sustainable Agriculture Practices 00:00 Module 4 Marketing and Business Management in Agriculture Marketing and Business Management in Agriculture 00:00 Module 5 Agricultural Technology Agricultural Technology 00:00

Agriculture
Delivered Online On Demand5 hours
£4.99

Real-World DevOps Project From Start to Finish

By Packt

Embark on a transformative DevOps journey! This comprehensive course equips you with skills in Ansible, Docker, GitLab, backups, and more. Master the art of self-hosting your infrastructure, streamlining deployments, and boosting efficiency. Launch your DevOps career today and unleash the endless possibilities!

Real-World DevOps Project From Start to Finish
Delivered Online On Demand5 hours 56 minutes
£48.99

Microsoft Word, PowerPoint and Outlook In 90 Minutes!

By The Teachers Training

This course condenses Microsoft Word, PowerPoint, and Outlook into a powerful 90-minute learning experience. Learn the core functionalities to create professional documents, captivating presentations, and manage your email efficiently. Ideal for busy professionals or anyone new to Microsoft Office. Boost your productivity and become a Microsoft whiz in just 90 minutes! Enroll now and conquer your workday!

Microsoft Word, PowerPoint and Outlook In 90 Minutes!
Delivered Online On Demand2 hours
£15

Become an Expert in Trello Course

By One Education

Master the art of project and task management with Trello — a refreshingly visual and flexible tool trusted by teams and individuals alike. This course is tailored for anyone looking to organise tasks, streamline workflows, and finally get on top of their never-ending to-do list. Whether you're managing team projects or simply trying to sort out your life’s chaos, this course will guide you through the smart way to use Trello without the fuss or jargon. From the moment you start, you’ll be walked through Trello’s features in plain English, with just enough cleverness to keep you smiling while you learn. We’ll take you through everything from building your first board to managing complex workflows using labels, checklists, and automation — all without making it feel like a chore. If you’ve ever opened Trello and closed it again out of confusion, this course is your friendly nudge in the right direction. Learning Outcomes: Navigate the Trello interface with ease Configure Trello settings to match your workflow preferences Use Trello Power-Ups to streamline your project management processes Create and manage cards, due dates, labels, comments, and attachments Organise boards, teams, and checklists for optimal productivity Import data from other tools and integrate Trello with Google Drive Utilise Trello on mobile devices for on-the-go productivity Course Curriculum: Overview and Pricing Working With the Menu Configure Settings Trello Power-Ups Cards and Due Dates Creating Labels and Comments Adding Attachments Adding Checklists Custom Fields Send a Card By Email To Trello Profile Activity Tracking Creating Boards Creating Teams Creating Checklists For The Team Importing Data Direct Integrations Google Drive Tracking and Storage Sharing And Discussion Trello On Mobile How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Project Manager: £30,000 - £60,000 per year Operations Manager: £40,000 - £70,000 per year Digital Marketer: £20,000 - £40,000 per year Social Media Manager: £25,000 - £40,000 per year Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Become an Expert in Trello Course
Delivered Online On Demand2 hours
£12

Microsoft Word 2016 Essentials (Basic to Advanced)

By Compete High

🚀 Unlock Your Full Potential with Microsoft Word 2016 Essentials 🚀 Are you tired of spending hours wrestling with Microsoft Word, trying to create professional documents without breaking a sweat? Say goodbye to frustration and hello to efficiency with our Microsoft Word 2016 Essentials course! 🌐 Why Microsoft Word 2016 Essentials? ✅ Master the Basics: Whether you're a beginner or looking to refresh your skills, our course covers all the fundamental features of Microsoft Word 2016. Say goodbye to confusion and hello to confidence. ✅ Boost Productivity: Learn the tips and tricks to streamline your document creation process. From formatting to collaboration, discover the tools that will save you time and energy. ✅ Create Stunning Documents: Unlock the secrets of effective document design. Impress your colleagues and clients with polished and professional-looking reports, resumes, and more. ✅ Effortless Collaboration: Discover the art of seamless collaboration. Learn how to edit and review documents with ease, making teamwork a breeze. ✅ Troubleshooting Made Simple: Tired of tech hiccups? Our course includes troubleshooting strategies, empowering you to tackle issues and navigate Microsoft Word 2016 with ease. ✅ Lifetime Access: Once you enroll, you get lifetime access to the course material. Take it at your own pace and revisit the content whenever you need a refresher. 🎁 Bonus Features: 🚀 Interactive Exercises: Reinforce your learning with hands-on exercises that ensure you retain the information. 📚 Resource Library: Gain access to a wealth of additional resources, including cheat sheets and templates, to enhance your Word skills. 🌟 Certificate of Completion: Receive a prestigious certificate upon finishing the course, showcasing your commitment to mastering Microsoft Word 2016.   💡 Don't miss this opportunity to transform the way you work with Microsoft Word. Enroll now and take the first step towards becoming a Word wizard! 🚀 Course Curriculum Basic Overview 01:28 File Menu 03:02 File Menu - Part 2 01:28 Home Menu 02:13 Home Menu - Part 2 - Styles 03:21 Insert Menu 03:00 Insert Menu - Part 2 00:00 Design Menu 00:00 Layout Menu 00:00 References Menu 00:00 References Menu - Table Of Contents 00:00 Mailings Menu 00:00 Review Menu - Part 1 00:00 Review Menu - Part 2 00:00 Review Menu - Resume Assistant 00:00 View Menu 00:00 Basic Document Creation - Part 1 00:00 Basic Document Creation - Part 2 00:00 File Type Saving 00:00 Conclusion 00:00 Advanced Overview 00:00 Importing From PowerPoint 00:00 Importing From Word to PowerPoint 00:00 File Menu - Importing Content from Excel 00:00 File Menu 00:00 Voice Recognition and Dictation 00:00 Insert Menu-Documenting Items 00:00 Text and Symbols Tab 00:00 Design Menu - Page Background 00:00 Layout Menu 00:00 References Section - Index Tab 00:00 Mail Merge - Part 1 00:00 Mail Merge - Part 2 00:00 Review Menu - Protect Tab 00:00 Review Menu - Compare Tab 00:00 Review Menu - Resume Assistant Tab 00:00 Review Menu - Linked Notes 00:00 View Menu - Windows Tab 00:00 Interface with Google Docs 00:00 Mobile Integration 00:00

Microsoft Word 2016 Essentials (Basic to Advanced)
Delivered Online On Demand1 hour 25 minutes
£4.99

Microsoft 365 Apps - Updated Features Course

By Lead Academy

Microsoft 365 Apps - Updated Features Course Overview Are you looking to begin your Microsoft 365 career or want to develop more advanced skills in Microsoft 365? Then this new features in Microsoft 365 apps - updated features course will set you up with a solid foundation to become a confident office admin and help you to develop your expertise in Microsoft 365. This new features in Microsoft 365 apps - updated features course is accredited by the CPD UK & IPHM. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this new features in Microsoft 365 apps - updated features course will set you up with a solid foundation to become a confident office admin and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as an office admin. The new features in Microsoft 365 apps - updated features course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as an office admin. This comprehensive new features in Microsoft 365 apps - updated features course is the perfect way to kickstart your career in the field of Microsoft 365. This new features in Microsoft 365 apps - updated features course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. If you're interested in working as an office admin or want to learn more skills on Microsoft 365 but unsure of where to start, then this new features in Microsoft 365 apps - updated features course will set you up with a solid foundation to become a confident office admin and develop more advanced skills. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This new features in Microsoft 365 apps - updated features course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Who should take this course? This comprehensive new features in Microsoft 365 apps - updated features course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of Microsoft 365. Entry Requirement There are no academic entry requirements for this new features in Microsoft 365 apps - updated features course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Career path This new features in Microsoft 365 apps - updated features course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your new skills to your CV, enhance your career and become more competitive in your chosen industry. Course Curriculum Introduction to the Concept of Microsoft 365 What is Microsoft 365. What's the Difference between Office 2019 and Microsoft 365 Understand and Manage Updates in Microsoft 365 What is the Cloud. New Functions, Which are Almost Identical In All Office Applications New Search Function Auto Save and Version Management Fast File Search How to Share Files Black Theme The Dictate Function Translate Text into other Languages Insert icons Add Transparency to Images Work with 3D Models Work with Animated 3D Models Use @Mentions in Comments Mark Comments as Done Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Quality Licence Scheme Endorsed The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Microsoft 365 Apps - Updated Features Course
Delivered Online On Demand
£25

MySQL foundation

5.0(3)

By Systems & Network Training

MySQL foundation training course description The MySQL foundation course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create, alter and drop a MySQL database. Write SQL statements. Use SQL expressions and functions. Create and alter tables, indexes and views. Use transactions. Grant and revoke access privileges. Export and import data. MySQL foundation training course details Who will benefit: Anyone who needs to access and work with a MySQL Database. Prerequisites: An understanding of databases and exposure to information technology in general would be useful. Duration 3 days MySQL foundation training course contents Database concepts What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases. Hands on using a database. Using the MySQL client What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts. Hands on Using the MySQL client. Basic SELECT The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators. Hands on querying the sample database. LIMIT, UNION and AGGREGATE functions The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause. Hands on using limit, union and aggregate functions. Subqueries and joins Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins. Numeric and character functions Function types, testing functions, numeric functions character functions. Hands on using numeric and character functions. Data, time and other functions Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions. Hands on using date, time and other functions. Databases and tables Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables. Hands on maintaining databases and tables. Indexes and views What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views. Hands on maintaining indexes and views. Managing data Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits. Hands on managing data. Access control Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking. Import and export Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line. Hands on export and import data.

MySQL foundation
Delivered in Internationally or OnlineFlexible Dates
£2,367