35851 Design courses in Ince-in-Makerfield delivered Online

24-Hour Flash Sale! Prices Reduced Like Never Before!! Having a dream of being in charge of a restaurant, orchestrating unforgettable events, designing exquisite cakes, and ensuring the highest standards of food safety and hygiene can seem unachievable. But, with the UK's buzzing food scene, the demand for polished professionals who can deliver on both taste and safety is skyrocketing. The UK's catering sector alone generates an astonishing £1 billion annually. So, join in this Catering Management course to refine your culinary skills, and learn the secrets behind efficient restaurant and hotel management! From the nitty-gritty of Supervising Food Safety inCatering to the basics of Restaurant Management, this course covers it all! Get to know the essentials of Hygiene to the nuances of Managing a top-notch Hotel. And it doesn't stop there! We also explore the intriguing link between HACCP Training, and how Food Allergen Awareness can play a role in ensuring the best service for the customers. By the end of this journey, you'll not only be equipped with practical skills but also with a holistic understanding of the role nutrition plays in our lives. This Catering Management Bundle Package includes: Course 01: Diploma in Catering Management at QLS Level 4 10 Additional CPDQS Accredited Premium Courses - Course 01: Supervising Food Safety in Catering Course 02: Food Hygiene And Safety Level 3 Course 03: Level 5 Certificate In Cleaning Course 04: HACCP Training Course 05: Food Allergen Awareness Course 06: Personal Hygiene Course Course 07: Professional Waiter Diploma Course 08: Restaurant Management Course Course 09: Hotel & Hospitality Management Course 10: Customer Relationship Management So, why wait? Whether you're aspiring to climb the career ladder in the hospitality sector, dreaming of running your own catering business, or simply passionate about creating exceptional culinary experiences, this course bundle is for you. Embrace the opportunity to blend creativity with efficiency, passion with professionalism, and food with mood. Enrol now and start paving your path to success in one of the UK's most vibrant and rewarding industries! Learning Outcomes of the Catering Management Bundle: Master the art of effective catering management. Ensure food safety and hygiene in catering environments. Acquire skills in creative cake decorating techniques. Understand the operational dynamics of restaurant management. Learn the importance of personal hygiene in the food sector. Explore the impact of diet on mental health and well-being. Why Prefer this Course? Get a Free CPD Accredited Certificate upon completion of the course Get a Free Student ID Card with this training program The course is Affordable and Simple to understand Get Lifetime Access to the course materials The training program comes with 24/7 Tutor Support Start your learning journey straight away! Curriculum Breakdown Course 01: Diploma in Catering Management at QLS Level 4 Module 01: An Overview of Catering Business Module 02: Laws and Legislations Regarding Food Safety and Hygiene Module 03: Food Safety and Hygiene Module 04: Food Safety Module 05: Management of Food and Beverage Operations Module 06: Marketing and Human Resource Course 02: Supervising Food Safety in Catering Module 01: Introduction to Supervising Food Safety Module 02: Food Safety Legislation Module 03: Food Contamination Module 04: Controlling Contamination Module 05: Microorganisms Module 06: Food Poisoning and Foodborne Diseases Module 07: Non-bacterial Food Poisoning Module 08: Temperature Control Module 09: Checking, Verifying and Recording Temperatures Module 10: Food Preservation Module 11: Premises and Equipment Design Module 12: Waste, Cleaning and Disinfection Module 13: Pest Control Module 14: Personal Hygiene Module 15: Training Staff Module 16: Implementing a Food Safety Management System Module 17: Food Safety Management Tools Course 03: Cake Decorating Online Course Module 01: Basic Concepts Of Baking Module 02: Basic Ingredients Of Baking Module 03: Glossary And Equipment Used In Baking Module 04: Types Of Cakes Module 05: Baking The Cake Module 06: Baking Principles Module 07: Cake Decorating Recipes Module 08: Cake Decorating Ideas Module 09: Frosting And Icing Module 10: Working With Different Pastes Module 11: Working With Glazes Module 12: How To Stack A Cake Module 13: Piping And Writing Module 14: Health, Safety And Food Hygiene Module 15: Troubleshooting Module 16: Cake Decorating Business =========>>>>> And 8 More Courses <<<<<========= Assessment Process You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all the Diploma in Catering Management at QLS Level 4 exams. How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) CPD Hard Copy Certificate: Free (For The First Course: Previously it was £29.99) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £99) CPD 220 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Aspiring caterers Future restaurant managers Budding hoteliers Food safety enthusiasts Creative cake decorators Nutrition advocates Requirements You will not need any prior background or expertise to enrol in this Catering Management Course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Catering Manager - £30,000 Food Safety Officer - £25,000 Cake Decorator - £20,000 Restaurant Manager - £28,000 Hotel General Manager - £40,000 Wellness and Nutrition Advisor - £22,000 Certificates CPD Accredited Certificate Digital certificate - Included Upon passing the Bundle, you need to order to receive a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD . Diploma in Catering Management at QLS Level 4 Hard copy certificate - Included For Additional The Quality Licence Scheme Courses, You have to pay the price based on the Level of these Courses: Level 1 - £59 Level 2 - £79 Level 3 - £89 Level 4 - £99 Level 5 - £119 Level 6 - £129 Level 7 - £139 CPD Accredited Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (International delivery)

Our Creative Writing course, running for five weeks, will explore the art of storytelling in depth. Is your child a budding writer aiming to excel in 11+ exams in the UK? Our Creative Writing course is designed just for them Over five weeks, we'll delve into the art of storytelling, focusing on creating pieces that set your child apart and building essential exam skills. From mastering the nuances of the five senses to paragraph and story structure, our expert exam tutor, Kristen, will guide students every step of the way. We'll help your child answer those seemingly boring questions with enthusiasm, explore figures of speech, enrich vocabulary, and unleash their creative potential. This will be the perfect course to learn about exam skills for 11+ creative writing tasks!

🚀 Unlock Your E-Commerce Potential with Marketplace Mastery! 🌐 Are you ready to transform your online business and skyrocket your profits? Introducing 'Marketplace Mastery: Unleashing E-Commerce Success' - the ultimate online course designed to propel you to new heights in the world of digital commerce!   🌟 What You'll Gain: Strategic Insights: Discover the secrets behind successful e-commerce ventures. From choosing the right marketplace to understanding consumer behavior, we've got you covered. Mastering Platforms: Dive deep into the major e-commerce platforms like Amazon, eBay, and more. Learn how to leverage their algorithms, optimize product listings, and dominate your niche. Effective Marketing Techniques: Unleash the power of digital marketing to drive traffic and increase sales. From social media strategies to email campaigns, we'll show you how to create a buzz around your products. Optimizing Conversions: Turn visitors into customers with proven techniques for optimizing your product pages. Learn the art of persuasive copywriting, stunning visuals, and user-friendly design. Customer Relationship Management (CRM): Build lasting relationships with your customers. Explore the importance of excellent customer service and how it can lead to repeat business and positive reviews. Scaling Your Business: Take your e-commerce venture to the next level. Explore advanced strategies for scaling your business, managing inventory, and expanding into new markets. Profitable Analytics: Harness the power of data to make informed decisions. Learn to interpret analytics, identify trends, and use data-driven insights to boost your bottom line.   🎓 Why Choose Marketplace Mastery? Expert Instructors: Our course is curated by industry experts with a track record of e-commerce success. Benefit from their firsthand experience and insider knowledge. Practical, Actionable Content: We believe in learning by doing. Each module is packed with actionable steps and real-world examples to ensure you can apply your newfound knowledge immediately. Community Support: Join a thriving community of like-minded entrepreneurs. Share experiences, ask questions, and collaborate with fellow students to enhance your learning journey. Lifetime Access: Once enrolled, you'll have lifetime access to the course content. Stay updated with the latest e-commerce trends and revisit the material whenever you need a refresher.   💡 Don't Miss Out on the E-Commerce Revolution! Take control of your e-commerce destiny with 'Marketplace Mastery: Unleashing E-Commerce Success.' Whether you're a beginner looking to launch your first online store or an experienced seller aiming to boost your profits, this course is your roadmap to success.   🔥 Enroll Now and Elevate Your E-Commerce Game! Course Curriculum

Duration 1 Days 6 CPD hours This course is intended for Students taking this course are database administrators or prospective database administrators who have experience working with Access for Microsoft 365 and need to learn advanced skills. Overview In this course, you will manage an Access database and add complex database features to improve its usability, efficiency, performance, and security. You will: Share data across applications. Use action, unmatched, and duplicate queries to manage data. Create complex reports and forms. Use macros to improve user interface design. Use VBA to extend database capabilities. Perform database management tasks such as backup, compacting, repairing, performance analysis, checking object dependencies, and documenting. Implement security strategies and distribute a database to multiple users. You've covered many of the basic functions of Microsoft© Access©, and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separates database professionals from the casual database users or occasional designers.This course is the third part of a three-course series that covers the skills needed to perform basic database design and development in Access.Microsoft© Access© for Office 365?: Part 1 : Focuses on the design and construction of an Access database?viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.Microsoft© Access© for Office 365?: Part 2 : Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.Microsoft© Access© for Office 365?: Part 3 (this course): Focuses on managing the database and supporting complex database designs, including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.This course may be a useful component in your preparation for the Microsoft Access Expert (Microsoft 365 Apps and Office 2019): Exam MO-500 certification exam. Lesson 1: Importing and Exporting Table Data Topic A: Import and Link Data Topic B: Export Data Topic C: Create a Mail Merge Lesson 2: Using Queries to Manage Data Topic A: Create Action Queries Topic B: Create Unmatched and Duplicate Queries Lesson 3: Creating Complex Reports and Forms Topic A: Create Subreports Topic B: Create a Navigation Form Topic C: Show Details in Subforms and Popup Forms Lesson 4: Creating Access Macros Topic A: Create a Standalone Macro to Automate Repetitive Tasks Topic B: Create a Macro to Program a User Interface Component Topic C: Filter Records by Using a Condition Topic D: Create a Data Macro Lesson 5: Using VBA to Extend Database Capabilities Topic A: Introduction to VBA Topic B: Use VBA with Form Controls Lesson 6: Managing a Database Topic A: Back Up a Database Topic B: Manage Performance Issues Topic C: Document a Database Lesson 7: Distributing and Securing a Database Topic A: Split a Database for Multiple-User Access Topic B: Implement Security Topic C: Convert an Access Database to an ACCDE File Topic D: Package a Database with a Digital Signature

Course Overview Understanding a problem properly and creatively can create new opportunities for your business. Learn how to solve problems creatively from this Creative Problem Solving and Decision Making course and boost your personal growth today.  In this Creative Problem Solving and Decision Making course, you will learn the importance of creative problem solving and decision making. You'll understand how decision making works, problem-solving steps, thinking outside the box and many other techniques. This course will teach you the aspects of creative problem-solving. Problem-solving is necessary for any work. Your problem-solving skill can help you ride the ladder in your career and personal growth. So, learn how you can solve your problems creatively today from this course. Learning Outcomes Learn how to break a problem into small pieces Understand why organizations need to be creative with their problem solving and decision making Familiarize with the steps of problem-solving Learn why decision making is important Know about the benefits realization approach to problem-solving Be able to think outside the box Familiarize with tools that will help to solve problems creatively Who is this course for? This course will be helpful for anyone who needs decision making and problem-solving skills in their life. This course will help to understand a problem and finding a creative solution for that. 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. Certification After you have successfully completed the course, 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 hardcopy at the cost of £39 or in PDF format at the 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 recognized 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 Creative Problem Solving and Decision Making is a useful qualification to possess and would be beneficial for any related profession or industry such as: Entrepreneurs Business Owners Managing Directors Administrators Team Leaders Unit 01: Thinking Styles and the structure for problem solving and decision making Introduction to Problem Solving and Decision Making Creatively 00:02:00 Thinking Styles in decision making 00:08:00 Steps to Creative Problem Solving and Decision Making 00:10:00 Analyse the Problem 00:08:00 Analysing Performance Data 00:06:00 Unit 02: Generate and Test Ideas Generate Ideas 00:05:00 Test the Solutions and Decide 00:04:00 Benefits Realisation Introduction 00:01:00 Problem Solving using Benefits Realisation 00:10:00 Thinking outside the Box 00:01:00 Thank you for completing the course 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

If you want to gain a solid understanding of Energy Efficient Lighting - Household Cost Cutting and fast-track your dream career, then take a step in the right direction with this industry-standard, comprehensive Energy Efficient Lighting - Household Cost Cutting course designed by expert instructors. Dedicated tutor support and 24/7 customer support are available to all students with this premium quality Energy Efficient Lighting - Household Cost Cutting course. You can get the help you require and the answers to all your queries throughout the comprehensive syllabus of this course. This premium online course titled Energy Efficient Lighting - Household Cost Cutting ensures your professional development with CPD certification service accreditation. You'll have the privilege of learning in your own time, at your own pace and earning an accredited certification. With this Energy Efficient Lighting - Household Cost Cutting course, success will become a lot easier and enable you to monetise your skills. This course is designed for both part-time and full-time students and can be completed at a pace that suits your learning style. This Energy Efficient Lighting - Household Cost Cutting course is developed by industry experts and is packed with several insightful modules to give you a proper understanding of Energy Efficient Lighting - Household Cost Cutting and allow you to accelerate your career. Who is this Course for? The Energy Efficient Lighting - Household Cost Cutting course is ideal for highly motivated individuals who want to enhance their professional skills and train for the job they want! This course also suits people aspiring for some in-depth knowledge on this topic and keeping up to date with the latest information, especially the following: Engineers Consultants Energy consultants Practising Engineers HVAC consultant Engineering students Boiler Operators Requirements There are no formal entry requirements for the Energy Efficient Lighting - Household Cost Cutting course, with enrollment open to anyone! Anyone with a knack for learning can enrol on this course without any hesitation. Learn online from any internet device, including your computer, tablet or smartphone. Study when it suits you and complete the course at your own pace. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Energy Efficient Lighting - Household Cost Cutting course is designed to help you get the job of your dreams or even that promotion you've always wanted! Learn the essential skills and knowledge you need to exceed in your professional life with the help & guidance from our Energy Efficient Lighting - Household Cost Cutting course. Course Curriculum Section 01: Introduction Introduction 00:04:00 Section 02: Fundamentals of lighting Fundamentals of Lighting 00:11:00 Section 03: Types of Lighting Systems Types of Lighting System 00:10:00 Section 04: Control and audit Control and Audit of Lighting System 00:17:00 Section 05: Energy-saving measures Energy Saving Measures in Lighting System 00:14:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Administering Microsoft SQL Server course description This course provides students with the knowledge and skills to maintain a Microsoft SQL Server database. The course focuses on how to use SQL Server 2016 product features and tools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2014 or SQL Server 2016. It covers the new features in SQL Server 2016, but also the important capabilities across the SQL Server data platform. What will you learn Describe core database administration tasks and tools. Configure SQL Server databases and storage. Import and export data. Monitor SQL Server. Trace SQL Server activity. Manage SQL Server security. Audit data access and encrypt data. Administering Microsoft SQL Server course details Who will benefit: Individuals who work with SQL Server databases. Individuals who develop applications that deliver content from SQL Server databases. Prerequisites: Introduction to data communications & networking. Duration 3 days Administering Microsoft SQL Server course contents Introduction to SQL Server administration Database administration, SQL Server platform, database management tools and techniques. Hands on SQL Server Management Studio, sqlcmd Windows PowerShell with SQL Server. Working with databases and storage Data storage with SQL Server, managing storage for system databases, managing storage for user databases, moving database files, configuring the buffer pool extension. Hands on Configuring tempdb storage, creating databases, attaching a database. Importing and exporting data Transferring data, importing and exporting table data, copying or moving a database. Hands on import and export wizard, bcp utility, BULK INSERT statement, OPENROWSET function. Monitoring SQL Server 2014 Monitoring SQL Server, dynamic management views and functions, performance monitor. Hands on Baseline metrics, monitoring a workload. Tracing SQL Server activity Tracing workload activity, using traces. Hands on Capturing a trace in SQL Server profiler, generating tuning recommendations. Managing SQL Server security SQL Server security, server-level security, database-level principals, database permissions. Hands on SQL Server security. Testing access.

Oracle SQL training course description The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create SQL statements to query database tables. Use standard aggregate functions and related SELECT statement clauses. Join Tables. Use basic subqueries and the set operators. Use numeric, character and date functions. Use conversion and other miscellaneous functions. Use SQL parameters. Use complex subqueries. Create and alter tables and views. Insert, update and delete rows in database tables. Manage sequences and synonyms. Oracle SQL training course details Who will benefit: Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database. Prerequisites: None. Duration 3 days Oracle SQL training course contents Retrieving data with the SELECT statement The SELECT statement, The SELECT and FROM clauses, Conditions and the WHERE clause, Other conditional operators, Logical operators, The ORDER BY clause, Column aliases, Arithmetic expressions, Precedence of operators. Aggregate functions Overview of built In aggregate functions, The GROUP BY clause, The HAVING clause. Joining tables Overview of table joins, Inner joins, Table aliases, Outer joins, Self joins, ANSI standard joins. Basic subqueries and set operators Overview of subqueries, Basic subqueries, Set operators, The union, intersect and ,minus operators. Numeric, character and data functions Function types, Using the table dual to try out functions, Numeric functions, Character functions, String concatenation, Date arithmetic and date functions. Conversion and miscellaneous functions Conversion functions, The NVL and NVL2 functions, The DECODE function, CASE expressions, The COALESCE and NULLIF functions. SQL parameters Command line substitution parameters, The accept command, The define and undefine commands. Complex subqueries Subqueries usage, In-line views, Top-N queries, Subqueries with joins, Multi column subqueries, Correlated subqueries, Subquery rules, Using the ANY, ALL and SOME operators. Managing data Inserting rows, Updating rows, Deleting rows, Verifying updates, Transaction control, Commit and rollback, Savepoints, Commits and constraints, Amending data in SQL developer. Managing tables Creating tables, Specifying constraints, Altering tables, columns and constraints, Dropping tables, columns and constraints, Recovering dropped tables, Copying tables. Managing indexes and views Creating indexes, Dropping indexes, Listing indexes, Creating and using views, Dropping views, Listing views. Managing sequences and synonyms Create a sequence, View sequence details, Create a synonym, List synonyms.

Definitive Segment Routing course description This Segment Routing (SR) training course is a comprehensive program designed to equip network professionals with the knowledge and skills needed to implement and manage SR in modern networking environments. Segment Routing is a cutting-edge network architecture that enhances network flexibility, scalability, and efficiency. This course offers in-depth coverage of SR principles, protocols, and practical implementation techniques. Hands on sessions are used to reinforce the theory rather than teach specific manufacturer equipment. What will you learn Explain packet paths when implementing SLB. Explain how Segment Routing works. Explain the relationship between SR and MPLS. Use SR for Traffic Engineering. Troubleshoot Segment Routing. Implement TI-LFA using Segment Routing Definitive Segment Routing course details Who will benefit: This course is ideal for network engineers, architects, and administrators who want to stay up-to-date with the latest networking technologies and enhance their expertise in Segment Routing. Prerequisites: Concise MPLS for engineers Duration 3 days Definitive Segment Routing course contents Introduction to Segment Routing (SR) What is SR? Source based routing, SPRING, history, segments, why SR? SR benefits.SR usage: Traffic Engineering, Shortest path, local protection. Relationship between SR and MPLS, SRv6. Hands on Investigating the base network. Segment Routing architecture SR domains, SR paths, SR segments. Segment types. Segment IDs, combining segments, IGP extensions, control plane components. Hands on Configuring SR, exploring how SR works, Segment Routing protocols SR-MPLS. MPLS label stack operations. Segment Routing Global Block (SRGB). SRLB. IS-IS and OSPF extensions for SR. Prefix segments, adjacency segments. SRGB/IGP interactions. Multidomain SR policies. SPF, Strict SPF. Hands on Analysing IGP SR extension operation. Investigating the SRGB. Segment Routing Traffic Engineering RSVP-TE versus SR-TE. SR policies. Anycast and binding SIDs. SR flexible algorithm flex-algo, Performance measurement delay. Hands on Optimising network paths for various applications. SR integration with 'older' technologies MPLS and LDP integration with SR. Hands on Integration. Topology Independent Loop Free Alternative Classic LFA and IP/MPLS protection mechanisms. TI-LFA protection options. Hands on TI-LFA operation with SR and LDP traffic. Scenarios SDN. Managing SR with SR controllers. Analyse, optimise, automate. Network slicing. BGP peering segments Path Computation Elements, BGP Link State. BGP prefix segments, BGP peer segments. Egress peer engineering. SR enabled VPNs. Hands onBGP segment routing. Troubleshooting Segment Routing IP toolkit: ping and traceroute. MPLS toolkit: MPLS ping, MPLS echo request/reply, MPLS ping, MPLS traceroute and path discovery. Router show commands. Hands on Used throughout the course during exercises. SRv6 Note this is an optional extra day. See our one day SRv6 course for details. IPv6 headers review, routing headers, IPv6 segment, SRv6 segment Identifiers. IPv6 Segment Routing Header. SRH procedures. Hands on Configuring SRv6, Analysing SRv6 operation.

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.