295 Courses in London

Database design training course description Although this course mentions Microsoft Access the same course can be run with a variety of different databases. The duration of the course is dependent on the experience of the delegates. What will you learn Name and give 3 types of database structure. Explain the difference between standard SQL and different flavours. Use SQL statements to query databases. Use SQL statements to query and define databases. Describe the principles of relational database design and 3 types of relational joins. Normalise a given flat file table into relational tables. Database design training course details Who will benefit: Anyone who needs to be able to design an efficient, watertight database following the best practice of the principles of Relational Database design. Prerequisites: None. Duration 3 days Database design training course contents Database structure and terminology. Principles of Relational Database Design. Types of relationship. Normal Forms. Practical examples of relational database design. Hands-on creation of a database. On paper design a relational database applicable to the delegates work.

MySQL Performance & Tuning training course description This MySQL Performance & Tuning course is designed for Database Administrators, Application Developers and Technical Consultants who need to monitor and tune the performance of MySQL servers and databases. The course provides practical experience in monitoring and tuning MySQL servers and databases. Note: This MySQL Performance & Tuning course does not cover clustering (other than at overview level), replication or non-standard storage engines such as Falcon and PBXT. What will you learn Develop a monitoring and tuning plan Use server configuration and status variables. Identify and improve problem queries. Make efficient use of indexes. Monitor and size memory caches and locks. Tune the MyISAM and InnoDB storage engine. Evaluate the use of partitioning for performance. MySQL Performance & Tuning training course details Who will benefit: Anyone who wishes to monitor and tune MySQL performance. Prerequisites: Delegates must have a working knowledge of MySQL Database Administration Duration 3 days MySQL Performance & Tuning training course contents Introduction to performance tuning Tuning overview, Resolving performance issues, Recommended approach to tuning, Items to evaluate, Where to look, Planning a monitoring routine, Building a new database for performance, Tuning an existing database, Setting suitable goals. MySQL performance tuning tools Administration tools, the information schema, performance-related SHOW commands, benchmarking tools, the MySQL performance schema, MonYog. Hands on Obtaining performance information. Schema design Normalisation, de-normalisation, naming conventions, load generation, stress testing and benchmarking tools, selecting data types, data types, character sets, choosing storage engines. Hands on effects of design on performance. Statement tuning Overview of statement tuning, identifying problem queries, the optimizer, explain, explain extended. Hands on identifying problem queries and using explain. Indexes Index overview, Types of index, Index tuning, Indexes and joins. Hands on Indexes and performance. Server configuration and monitoring Server configuration variables, server status variables, table cache, multi-threading, connection issues, query cache. Hands on setting and interpreting server variables and caching. Locking Types of locking, locking and storage engines, effects of locking on performance. Hands on locking and performance. The InnoDB engine Transactions, crash recovery, locking, monitoring InnoDB, caches and buffers, configuring data files, configuring the log files. Hands on InnoDB configuration and performance. Other storage engines MyISAM engine, merge engine, archive engine, memory engine, blackhole engine, CSV engine, the Spider engine, the ColumnStore engine, the MyRocks engine, mixing sorage engines. Hands on storage engine performance. Overview of clustering and performance Advantages of performance, advantages of clustering, performance issues and clustering, the NDBCluster engine, the Galera cluster, the Percona XtraDB cluster, MySQL InnoDB cluster, the federated engine, the federatedX engine, overview of other high availability techniques. NOSQL and Mencached overview. Dumping and loading data SQL statements versus delimited data, parameters affecting dump performance, parameters affecting load performance. Hands on dump and load performance. Partitioned tables Partitioned tables concepts, range partitioning, hash partitioning, key partitioning, list partitioning, composite partitioning or subpartitioning, partition pruning. Hands on partitioned table performance.

Database fundamentals training course description This three-day training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. What will you learn Describe core database concepts. Create database objects. Manipulate data. Describe data storage. Administer a database. Create a relational database consisting of 3 related tables. Database fundamentals training course details Who will benefit: Those working with databases. Prerequisites: None. Duration 3 days Database fundamentals training course contents Understanding core database concepts Flat-type databases, hierarchical databases, relational databases, database fundamentals, relational database concepts, using the SQL Server Management Studio Interface. Data Manipulation Language (DML), Data Definition Language (DDL), using DDL statements. Creating database objects Defining data types, using built-in data types, using exact numeric data types, using approximate numeric data types. Creating and using tables. Creating views. Creating stored procedures, SQL injections. Manipulating data Using Queries to select data, combining conditions, using the BETWEEN clause, using the NOT clause, using the UNION clause, using the EXCEPT and INTERSECT clauses, using the JOIN clause. Using Queries to insert data, Inserting data. Updating data and databases, Using the UPDATE statement. Deleting data, Using the DELETE statement, truncating a table with TRUNCATE TABLE, deleting a table with DROP TABLE, using referential integrity. Understanding data storage Normalising a database, normalization, first normal form, second normal form, third normal form, fourth normal form, fifth normal form. Primary, foreign and composite keys, clustered and non-clustered indexes, creating a non-clustered table. Administering a Database Securing Databases, server-level security, database-level security, Windows security, SQL authentication, database server roles, granting access to a database, fixed database roles, object permissions, managing roles, ownership chains, reviewing a sample security model. Backing up and restoring databases, recovery models, backup devices.

Why Choose Adobe InDesign Fundamentals Training Course? Course info. Learn Adobe InDesign fundamentals from certified tutors. Master layout creation, typography, layouts and design principles. Choose in-person or live online sessions. Certificate of Completion and lifetime email support provided.  Duration: 5 hrs. Method: 1-on-1, Personalized attention. Schedule: Tailor your own hours of your choice, available from Monday to Saturday between 9 am and 7 pm. Adobe Certified Instructors and Expert for InDesign, and a professional graphic designer. In this advanced course, we will delve into InDesign's powerful features, productivity techniques, and workflow speed tricks. 5-hour Adobe InDesign Fundamentals training course, designed to empower you with essential skills for layout and design projects. Suitable for beginners and those with some experience, this course ensures you can confidently create professional-quality documents and publications. Part 1: Introduction to Adobe InDesign (1 hour) Explore the workspace and tools Set up new documents with proper page size and margins Format text and images effectively Customize the interface for efficient workflow Part 2: Text Formatting and Styles (1 hour) Apply character and paragraph styles for consistent formatting Control text flow with text frames Organize lists using bullets and numbering Master special characters for typographic control Part 3: Working with Images (1 hour) Import and position images in the document Adjust image size and alignment within frames Create professional layouts with text wrapping around images Enhance visuals with image frames and effects Part 4: Layout Design (1 hour) Create precise grids and guides for alignment Arrange objects for a balanced layout Streamline design work with layers Maintain consistency with master pages and templates Part 5: Printing and Exporting (1 hour) Understand color modes and printing principles Export to PDF and other formats for various outputs Ensure print readiness through preflighting Efficiently archive and manage InDesign files Through hands-on exercises and practical examples, you'll solidify your understanding of each module. This course equips you to design visually captivating layouts, create documents for diverse purposes, and manage InDesign projects effectively. Adobe InDesign is a powerful desktop publishing tool, and our fundamentals course sets the stage for you to explore and expand your skills in a wide range of design projects. Don't miss this opportunity to unlock your creative potential with InDesign!

C++ Bootcamp is for coding beginners: You want all the basic stuff, all the advanced stuff and practical experience and get a fantastic job in C++

Today's administrative professional needs flexibility and a broad portfolio of skills including self-motivation, assertiveness, and the ability to deal with difficult people. You will benefit from this course if you are an administrator, medical/legal secretary or PA, who wants to enhance your administrative support skills, as well as evaluating your existing techniques. This course will help you identify: your areas of strength and your areas for improvement in the work environment ways to accept new challenges and responsibilities with confidence what motivates you at work techniques to improve your planning and time management ways of improving your influencing and assertiveness skills your preferred working style (and relate it to your interaction with others) ways of using your initiative how to deal with challenging people, using recognised communication methods The course will help you develop a flexible set of skills that will allow you to succeed at work, no matter what the day throws at you. It will help you communicate effectively with a diverse range of colleagues and others with tact and diplomacy. And, finally, it will help you provide the administrative support that is essential for the smooth running of your area and of the organisation as a whole. 1 Introduction Overview Introductions Individual objectives 2 What exactly is your role? Before looking at new skills and techniques, where are you now? Do you have the skills, knowledge and attitude required to be an exceptional administrator? Understand your job criteria Identifying your strengths and areas for development Activity - skills analysis Activity - action plan 3 Building trust How can you build trust? Understanding the links between reliability, consistency and trust What is required to deliver efficient service? Activity: efficient service requirements of the professional administrator 4 Working styles Identifying your working style preference Understanding the importance of a flexible approach Identifying areas of improvement to become a more effective team member Activity: Questionnaire (completing, scoring and charting) Activity: drawbacks of my style Developing your working style 5 Assertiveness Understand the differences between behaviours Activity: Definition and characteristics of assertive / aggressive / passive behaviour Activity: Identifying different behaviours Understanding how to be more assertive How to use assertiveness techniques How to ask for feedback Activity: Making requests assertively Activity: Refusing requests assertively 6 Time management The importance of planning for success The importance of managing interruptions The importance of having clear purpose Time management best practices Activity: How do you plan your time? What prevents you improving your time management? How will you recognise success? 7 Prioritisation How to prioritise work to meet deadlines The prioritisation matrix Activity: Post it! 8 Dealing with interruptions The impact interruptions have on productivity How to manage interruptions Activity: What interruptions do you experience? What tactics can be employed to reduce these interruptions? 9 Close Open forum Summary Action planning

Why Learn Autodesk AutoCAD | 3ds Max Training Course? Course Link 3ds Max serves as a powerful tool in architectural modeling, product design, games and films. Engaging with 3ds Max tutorials proves invaluable, particularly for game designers, as it can significantly enhance their professional growth and career prospects. Duration: 16 hrs Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. AutoCAD and 3ds Max Training Course: Tailored Learning Experience: Benefit from personalized, one-on-one training tailored to your individual needs and learning pace. Flexibility in Learning: Choose between attending in-person sessions or participating in live online classes, granting you the flexibility to learn from anywhere at your convenience. Accessible Lesson Recordings: Access recorded lessons to revisit concepts, practice techniques, and reinforce your understanding whenever you need. Ongoing Email Support: Receive continuous assistance and expert guidance through lifetime email support, ensuring you never feel left behind in your learning journey. Learn from Certified Tutors and Industry Experts: Be educated by experienced professionals proficient in both Autodesk AutoCAD and 3ds Max, providing valuable insights into industry best practices. Complimentary Career Advice: Take advantage of our career advisory services to receive valuable guidance in navigating your professional path and making informed decisions. Download Autodesk Autocad and 3ds max AutoCAD and 3ds Max Training Course. Course Duration: 16 hours Course Overview: Join our training program to master AutoCAD and 3ds Max. Suitable for beginners and experienced 2D/3D modelers, this course equips you with essential skills to create stunning designs in both 2D and 3D. Course Outline: Part 1: Introduction to AutoCAD Familiarizing with the AutoCAD interface Understanding the drawing environment Mastering basic 2D geometry creation Exploring essential drawing tools and commands Introduction to blocks and symbols for efficient design Part 2: Advanced AutoCAD Techniques Delving into advanced drawing techniques Manipulating and editing 2D geometry like a pro Creating custom symbols and blocks for enhanced productivity Working with text and annotations for clear communication Utilizing layers and line types for organized design Part 3: Plans sections and Elevations Entering the realm of Plans sections and Elevations Crafting Plans and 2D construction detailing precision Modifying and manipulating 2D seamlessly Crafting custom materials and textures for realistic designs Part 4: Introduction to 3ds Max Embracing the 3ds Max interface and workspace setup Mastering navigation within 3ds Max Understanding the viewport for optimized design Exploring basic 3D modeling techniques in 3ds Max Part 5: Materials and Textures in 3ds Max Applying and modifying textures to elevate designs Unraveling the art of UVW mapping for precise texturing Utilizing the material editor for creative freedom Crafting custom materials to suit your design vision Harnessing the power of Vray materials for realistic renders Part 6: Lighting in 3ds Max Introducing various lighting techniques Understanding light properties for impactful designs Setting up lights strategically to enhance scenes Illuminating scenes using Vray lights Part 7: Cameras in 3ds Max Mastering camera systems in 3ds Max Exploring camera properties for cinematic effects Creating animation with cameras for dynamic scenes Utilizing Vray cameras to achieve stunning renders Part 8: Rendering in 3ds Max Unveiling the art of rendering Utilizing Vray Global Illumination for realistic lighting Leveraging Vray Physical Cameras for precise control Enhancing scenes with Vray HDRI Lighting Following a Vray Rendering Workflow for professional results Part 9: Advanced Modeling Techniques Crafting complex geometry with finesse Utilizing modifiers for intricate designs Exploring polygonal modeling for versatile creations Creating organic and inorganic models with expertise Unleashing the potential of advanced modeling techniques Part 10: Projects Applying all learned skills to create real-world scenes Designing a simple interior scene with attention to detail Crafting a captivating exterior scene for visual impact Creating a complex scene with multiple objects and materials Course Requirements: A computer with AutoCAD and 3ds Max installed Basic knowledge of computer operations An interest in 2D and 3D modeling and design

FourSquare Training specialise in private, corporate Power Automate courses delivered at your premises and tailored to your needs.

Python Data Analytics boot camp. 12 1 day lessons, learn Python Basics through to machine learning and front-ends. With practical project to give you full confidence and credibility.

Intro to SQL training course description A hands on course focusing on the use of SQL. In particular this course does not concentrate on any particular version of SQL but rather enables delegates to recognise the differences found in SQL on different platforms. What will you learn Explain the difference between standard SQL and different flavours. Use SQL statements to query databases. Use SQL statements to define databases. Intro to SQL training course details Who will benefit: Anyone working with databases. Prerequisites: None. Duration 2 days Intro to SQL training course contents What is SQL? What is SQL? History, standards, What is SQL used for? Dialects, ANSI SQL, PL/SQL, Transact SQL, front ends. Database basics RDBMS, Tables. Hands on Investigating a database. Basic SQL commands SQL Overview: SQL DML, SQL DDL, SQL queries. SELECT, WHERE and ORDER BY clauses. Combining conditions. IN, LIKE and BETWEEN. Hands on Querying a database from existing tables. SQL data retrieval Scalar functions. Hands on Selecting data from an existing database. More SQL data retrieval Scalar functions, variations. Aggregate functions, GROUP BY. HAVING. Hands on Selecting data from an existing database. Table joins Multiple tables, joins, keys, inner joins, left joins, right joins. Hands on Selecting data from an existing database. SQL basic data manipulation INSERT, UPDATE, MERGE, DELETE. Transaction controls: COMMIT, ROLLBACK. Hands on Modifying data in tables. SQL Data Definition USE, CREATE, DROP, TRUNCATE, ALTER. Hands on Managing new tables and columns. Data control GRANT, REVOKE. Hands on Defining permissions.