133 Courses in London

MySQL for developers training course description This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. What will you learn Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. Use advanced features of the MySQL Client. Use advanced data types. Manage the structure of databases and tables. Manage and using indexes. Write complex SQL query statements. Use advanced SQL expressions. Use advanced SQL functions. Perform advanced Insert, Update, Delete, Replace and Truncate Operations. Use user variable syntax and properties. Import and export data from within MySQL. Import and export data from the command line. Perform complex joins to access multiple tables. Perform complex subqueries. Create, manage and us views. Use prepared statements. Create and use stored routines. Create and use triggers. Obtain database metadata. Optimize queries. Work with the main storage engines. Debug MySQL applications. MySQL for developers training course details Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. Prerequisites: MySQL foundation Duration 5 days MySQL for developers training course contents Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations More about indexes Indexes and joins Hands on Investigating indexes and joins

PYTHON BOOTCAMP: This 12-week Python Data Analytics Data Boot Camp is designed to give you a complete skill set required by data analysts . You will be fully fluent and confident as a Python data analyst, with full understanding of Python Programming. From Data, databases, datasets, importing, cleaning, transforming, analysing to visualisation and creating awesome dashboards The course is a practical, instructor-lead program.

Take your knowledge to the next level with EnergyEdge course on Layer of Protection Analysis (LOPA). Enroll now to advance your career.

Giving your child the gift of music while they are still young can be one of the most meaningful investments you could make in their life, and our London piano lessons for kids are structured to support the musical goals you have for your children. Your child’s or grandchild’s life will be permanently enriched from music lessons, whether they continue with music as a career, enjoy it as a serious amateur pursuit, or play casually for their own benefit and that of their friends and family.

Interactive Presentation Skills, Presenting, Presentations, Presentation Skills,

How is SIA SO Top Up course delivered? It is a blended course. Total time is 4 hours (minimum). Online learning – minimum 4 hrs eLearning must be done online prior to the course commencement date. You will be given access to our online portal. Classroom learning – 1 day We will give you access to our learner portal for you to get ready for the exams. Exams - 45 minutes (1 exam) are allocated for exams, which will be done in the classroom. You would need to come to the centre and sit the exams. Course Benefits / Package Deal ✅ UNPARALLELED VALUE! ✅ FREE Retakes of all units ✅ TRAINING GUARANTEE: We have never postponed a course yet. You get your training or a full refund without losing a penny. ✅ BEST TRAINING: No nonsense or bla bla bla! We have trainers with a minimum of 20 years of field experience, offering you the best possible insights and practical knowledge. You will learn from industry experts who understand the real-world challenges and nuances of security work. See Reviews! ✅ FREE reading materials. Full access to our course materials and beyond, giving you comprehensive resources for your learning journey. ✅ FREE e-certificate via email upon completion (No need for a hard copy). ✅ FREE step-by-step guidance on how to apply for the SIA license, streamlining the post-training process. ✅ FREE parking (North London Centre Only) ✅ ALL-INCLUSIVE PRICES: Our pricing is transparent and all-inclusive. Course and exam fees are included, so you won't encounter any hidden costs. ✅ FREE employment support after completing your training. ✅ Customer support - via chat-box, phone, or email for any questions or assistance. ✅ We always deliver on our promise! We pride ourselves on delivering on our promises, ensuring that you receive the highest quality training and support. ✅ Hassle-Free Booking under 60 seconds / Pick a location / Select a date / Fill in the form / Click on Go To Check Out.

London yoga teacher training course, led by senior teachers with decades of experience. Trauma sensitive, somatic approach. Online and in-person.

GLA Tutors is your trusted partner in preparing children for the SATs and Eleven Plus exams.  We understand the importance of these exams in shaping a child's academic future, and we are here to provide comprehensive and effective tutoring to ensure their success. Our dedicated team of tutors is well-versed in the style and content of both the SATs and Eleven Plus exams. We are committed to equipping children with the knowledge, skills, and confidence they need to excel in these challenging assessments. For SATs preparation, we offer targeted instruction in key subjects such as English (including Grammar, Reading and Writing), Mathematics, and Science. Our tutors are experienced in teaching the specific curriculum and concepts covered in the SATs, ensuring that children are thoroughly prepared for each section of the exam. From comprehension and grammar in English, to problem-solving and data analysis in Mathematics, our tutors provide tailored guidance to help children tackle every aspect of the SATs with confidence. For the Eleven Plus, we assess a child's aptitude in key areas such as English, Mathematics, Verbal Reasoning, and Non-Verbal Reasoning. Our tutors have in-depth knowledge of the exam format and content, and they employ effective strategies to help children succeed in each section. From improving comprehension and vocabulary skills in English, to developing logical reasoning and problem-solving abilities in Mathematics and Reasoning, we provide comprehensive support to ensure children are well-prepared for the Eleven Plus exams. Successfully passing the SATs or Eleven Plus exams  Success in these exams opens up a world of opportunities for children. After achieving these milestones, children will have various options available to them. They may gain entry into selective secondary schools, including grammar schools, which can provide an academically challenging environment and a strong foundation for future success. Additionally, achieving high scores in these exams can enhance a child's confidence and self-esteem, paving the way for a positive attitude towards learning and academic achievement in the future. There is a direct correlation between success in these exams and the GCSEs. Individual Styles AtGLA Tutors, we understand that every child is unique, and we tailor our tutoring approach to meet their individual needs. Our tutors provide personalised instruction, focusing on areas where each child requires additional support, while also nurturing their strengths and building their overall academic abilities. We are dedicated to fostering a positive and engaging learning environment, where children feel motivated and empowered to reach their full potential. Our tutors not only impart knowledge but also instill important study skills, critical thinking abilities, and effective exam techniques that will serve children well beyond the SATs and Eleven Plus exams. Choose GLA Tutorsas your partner in preparing your child for the SATs and Eleven Plus exams. With our experienced tutors, comprehensive resources, and personalised approach, we are committed to helping children achieve their academic goals and unlock a brighter future.  Invest in your child's success and join us at GLA Tutors today.

Learn to crochet in Surrey - this is an immersive 4 x 2 hour course running on Tuesday evenings in Walton-on-Thames.

This one-day introduction workshop is intended for users who need to get to grips with the essentials of Microsoft Outlook. It will provide you with the basic skills you need to effectively start using Outlook to manage your emails, calendar, contacts, tasks and notes. This course will help participants: Send messages with added email options applied Quickly file messages away for safe keeping Manage messages and attachments Organise calendar meetings and check other people's schedules Respond to a meeting request Create a contacts list Manage daily tasks Use reading and folder panes Create and manage folders Use auto reply Use notes Utilise Outlook's printing functionality 1 Getting started Using the reading pane Using the folder pane Changing inbox views Managing the to-do bar 2 Emailing messages Replying to and forwarding messages Adding message options Attaching files to an email message Opening and saving attachments 3 Outlook folders Creating and managing folders Moving messages into folders Adding folders to favourites Using search folder Always moving messages in conversation Automatically move messages with rules 4 Managing messages Using instant search Finding messages by criteria Grouping and sorting messages Categorising messages Adding message follow up flags Filtering messages with the people pane 5 Using auto reply Replying to messages whilst you are away Managing auto reply settings Applying rules to auto reply 6 Outlook calendars Adding and editing appointments Adding calendar reminders Moving and copying appointments Creating all day events Recurring appointments Sharing your calendar Opening another user's calendar 7 Planning a meeting Arranging meetings Inviting attendees to meetings Responding to meeting invites 8 Outlook contacts Creating and editing a contact Saving emails as contacts Finding contacts Sending messages to contacts Creating contact groups 9 Adding tasks Creating and editing tasks Completing tasks Assigning a task to another user Responding to a task request 10 Notes Creating and editing tasks Emailing notes Sticking notes on your desktop 11 Printing Printing messages Printing calendars Printing contacts