36901 Design courses in Reading delivered Online

In this course, you will learn how to unlock the power of Generative AI and learn to generate passive income for profitable online ventures with ChatGPT. Gain the skills to automate tasks efficiently, generate revenue from your content, and uphold ethical AI practices. This course is perfect for beginners or anyone seeking to enhance their online ventures with AI technology.

Course Overview Discover how to become a data scientist, prove hypotheses, and build complex algorithms with this advanced course on Statistics & Probability for Data Science & Machine Learning. This intuitive training will empower you to manipulate records and understand how to break down the most complex processes in this fascinating field. This comprehensive Data Science tutorial delivers the ideal way to learn the methodology and principles needed to excel in this sector. You will be given expert tuition in using all the relevant concepts for analysing information, gain a genuine understanding of these concepts, and attain the skills to excel in appropriate IT commercial industries. Complete this training, and you will have a unique advantage to work in such areas as automobile design, banking service, media forecasting, and much more. This best selling Statistics & Probability for Data Science & Machine Learning has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Statistics & Probability for Data Science & Machine Learning is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Statistics & Probability for Data Science & Machine Learning is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Statistics & Probability for Data Science & Machine Learning is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Statistics & Probability for Data Science & Machine Learning, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Statistics & Probability for Data Science & Machine Learning will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Statistics & Probability for Data Science & Machine Learning to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

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

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

Are you looking for a gardening course in the UK? Lead academy provides classes on gardening, which any individual can access from any location. It will guide you to acquire gardening skills passionately. This Course at a Glance Get introduced to the art and science of gardening. Learn about greenkeeping. Know how to do the planting. Gain knowledge about fertiliser and soil. Learn UK Vegetable Planting Calendar. Achieved reward CPD UK accredited certificate. Learn through engaging video-based training sessions. Continuous tutor support is available 24/7. The Gardening Course Online Overview This gardening course is developed for people who are interested in learning gardening. Whether a beginner or a little learner in the planting world, you will learn plenty of new things about gardening in this course. It will teach you about planting, fertiliser, soil, UK Vegetable Planting Calendar, Landscaping, Garden Design and more.  Register yourself as soon as possible as you will learn and, at the same time, obtain a valuable certificate that undoubtedly increases your value in the gardening world. This gardening course is accredited by CPD UK, valued by employers, professional organisations, and academic institutions. Your training provider can advise you on any further recognition, for example, progression routes into further and higher education. For details, please visit the Learner FAQs on our website. Who should take this course? The gardening course is suitable for the following:  People who are eager to learn gardening. Any individual who wishes to cultivate a garden at home. People who want to set up a garden business. Any individual who desires to become a botanist. Anyone with fundamental or little knowledge of planting will still be in the course. Entry Requirements The gardening Course requires no academic qualification. It is accessible to students from diverse backgrounds, and students enthusiastic about learning a new language will primarily benefit. However, You need a laptop, desktop, tablet, or smartphone and a reliable internet connection to enter this course on gardening. Assessment On the assessment round, you will participate in the MSQ test to examine your learning from this course. After completing the gardening course's all modules, learners must answer MCQs to complete the assessment procedure.  The MCQ test measures how much a learner can grasp from each section. In the assessment test, you must get 60% as a pass mark. Course Curriculum Module 1: Gardening - Introduction Module 2: Site Selection Module 3: Soil Science Module 4: Soil Preparation Module 5: Plant Nutrition Requirements - Fertilisers Module 6: Application of Fertilisers Module 7: Nutrient Deficiency Module 8: Basic Concepts of Organic Gardening Module 9: Plant Propagation Module 10: Amenity Horticulture and Native Plants Module 11: Exotic Plants - Exotic and Subtropical Gardening Module 12: UK Vegetable Planting Calendar Module 13: Landscaping and Garden Design Module 14: Permaculture Module 15: Arboriculture Module 16: Horticulture Statistics Module 17: Gardening - Conclusion Recognised Accreditation CPD Certification Service CPD stands for Continuing Professional Development. This term refers to learning activities that professionals undertake to improve their skills and capabilities. Employers and professional organizations globally recognize CPD UK. Thus, a certificate from CPD Certification Service creates value for your professional goal and achievement. Certificate of Achievement CPD Certificate After successfully passing the MCQ exam, you can 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. The certificate can be obtained in PDF version for £12, and there is an additional fee to receive a printed copy certificate which is £35. FAQs How will I purchase this course? First, select your desired course plan among the multiple existing course plans on the right side of your screen, then select the payment type, and once you made the payment, you can access the course any time you want. I made my payment. How will I get access to the Gardening course? A confirmation email will be sent to your registered email after payment. Hereafter anytime, you can start your learning journey with Lead Academy. I am from outside the UK. Will I get access to the Course? Yes, you can. Since it is an e-learning course, anyone from anywhere can enrol on our courses. What is an Accredited course? The professional body approves the procedures if any e-learning platform claims its courses are accredited. What is the benefit of doing an accredited course? You will only realise the benefit of having a CPD-accredited certificate once you face the corporate world. As employees, job places and more value the CPD-accredited certificate, you must own this certificate by doing the course with us. What do you mean by a CPD course? CPD refers to Continuing Professional Development, and the CPD-accredited course is developed for individuals who want to improve and update their skills within their professional field continuously. This certificate claims that the certificate holder's knowledge is up-to-date in their work area. After doing this course with you, Can I work as a Gardener? Yes, you can, without any doubt! We will teach you from scratch about gardening; after that, you can use this knowledge to become a gardener. How much does a gardener Earn in the UK? The average income of a gardener is between £15 - £25 per hour. However, it varies from city to city and country to country. I want to start gardening in my ward, how will I do that? Before you start gardening, you must understand that plants are living things and know how to look after them. Thus build your fundamental knowledge by doing this course, and after learning from us, you will be able to build a new world of herbal plants inside your home that will give you enchanting moments. Do I need a license to be a gardener in the UK? A gardener may not require a license, but owning a certificate is better. The authority often wants the gardeners to have a certificate before using some tools and chemicals.

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.

Get ready for an exceptional online learning experience with the Electrician, Electrical Engineering, HVAC, Circuit Analysis bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The Electrician, Electrical Engineering, HVAC, Circuit Analysis is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Electrician & Electrical Engineering package has something for everyone. As part of the Electrician, Electrical Engineering, HVAC, Circuit Analysis package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Electrician & Electrical Engineering bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following CPD Accredited Courses: Course 01: Electrician Complete Training Course 02: Electrical Engineering for Electrical Substations Course 03: Electrical Machines for Electrical Engineering Course 04: Certificate in HVAC Fundamentals Course 05: High Voltage Generation for Electrical Engineering Course 06: Electric Circuits for Electrical Engineering Course 07: Electrical Engineering DC Circuit Analysis Course 08: Electronic & Electrical Devices Maintenance & Troubleshooting Course 09: Energy Engineer Course Course 10: Light Current Systems for Electrical Engineering Course 11: Distribution Station & Feeder Protection Course 12: Symmetrical Components for Three-Phase Power Analysis Course 13: Data Center Training Essentials: Power & Electrical Course 14: MATLAB Simulink for Electrical Power Engineering Course 15: Working at Height Level 2 Course 16: Career Development Plan Fundamentals Course 17: CV Writing and Job Searching Course 18: Learn to Level Up Your Leadership Course 19: Networking Skills for Personal Success Course 20: Ace Your Presentations: Public Speaking Masterclass Learning Outcome: Gain comprehensive insights into multiple fields. Foster critical thinking and problem-solving skills across various disciplines. Understand industry trends and best practices through the Electrician & Electrical Engineering Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with the Electrician & Electrical Engineering. Build a strong knowledge base in your chosen course via the Electrician & Electrical Engineering. Benefit from the flexibility and convenience of online learning. With the Electrician & Electrical Engineering package, validate your learning with a CPD certificate. Each course in this bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with the Electrician, Electrical Engineering, HVAC, Circuit Analysis, a rich anthology of 15 diverse courses. Each course in the Electrician & Electrical Engineering bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. This Electrician, Electrical Engineering, HVAC, Circuit Analysis bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Electrician, Electrical Engineering, HVAC, Circuit Analysis bundle offers you the flexibility and convenience to learn at your own pace. Make the Electrician & Electrical Engineering package your trusted companion in your lifelong learning journey. CPD 215 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Electrician, Electrical Engineering, HVAC, Circuit Analysis bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Requirements Without any formal requirements, you can delightfully enrol in this Electrician, Electrical Engineering, HVAC, Circuit Analysis bundle. Career path This Electrician, Electrical Engineering, HVAC, Circuit Analysis bundle will help you to pursue: Electrical Technician HVAC Technician Electrical Engineer Energy Engineer Data Center Specialist Power Systems Engineer Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

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.