35770 Design courses in Lowestoft delivered Online

Overview This comprehensive course on 'Architectural Studies' will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This 'Architectural Studies' comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this 'Architectural Studies'. It is available to all students, of all academic backgrounds. Requirements Our 'Architectural Studies' is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 16 sections • 16 lectures • 05:23:00 total length •Introduction to Architectural Studies: 00:27:00 •Ancient Architecture: 00:13:00 •Architectural Ideas and Movements: 00:23:00 •Architectural Styles: 00:15:00 •Art Deco Architectural Style: 00:18:00 •Scandinavian Architectural Style: 00:22:00 •Victorian Architectural Style: 00:18:00 •Classical and Early Christian Architectural Style: 00:28:00 •Gothic Architectural Style: 00:22:00 •Baroque and Rococo Architectural Style: 00:17:00 •Eclecticism Architectural Style: 00:15:00 •Modern and Post-Modern Architectural Style: 00:28:00 •Interior Designing: 00:24:00 •Colour in Interior Designing: 00:24:00 •Lighting in Interior Design Part One: 00:12:00 •Lighting in Interior Design Part Two: 00:17:00

Why Choose Photoshop Evening Training Course? Click here for more info Become proficient in Photoshop, the premier photo editing software, with our London Software Training course. Gain essential skills in photo editing, enabling independent navigation of the interface for successful edits and graphic creation. Duration: 10 hours Approach: 1-on-1 guidance, Customized instruction. Schedule: Tailor your own hours, available from Mon to Sat between 9 am and 7 pm.Or Call 02077202581 or WhatsApp 07970325184. Participate in our Photoshop Evening Training Course, hosted at the UK's largest training school. Whether you're a beginner or an expert, our course is tailored to suit your level, offered both live online and in person. Adobe Photoshop Course Highlights: Embark on your design journey with our Adobe Photoshop course, conducted at the UK's leading Adobe Training Centre. Acquire proficiency in Adobe's premier digital imaging software, crucial for digital content creation. Our courses prioritize hands-on exercises, ensuring practical learning experiences. Whether you're new to Photoshop or an experienced user seeking efficiency, our diverse courses cater to your needs. Join us to master Photoshop and unleash your creative potential. Course Details: Duration: 10 hours Approach: Personalized 1-on-1 guidance, customized instruction. Schedule: Flexible hours available from Mon to Sat between 9 am and 7 pm. For inquiries, call 02077202581 or WhatsApp 07970325184. Evening Adobe Photoshop - 10-Hour Training Course Module 1: Introduction to Photoshop (1 hour) Overview of Photoshop interface and tools Understanding file formats and resolution Navigating the workspace and customizing preferences Essential keyboard shortcuts for efficient workflow Module 2: Working with Layers (1 hour) Mastering the concept of layers and their importance Organizing and managing layers effectively Applying layer styles for creative effects Utilizing blend modes for stunning compositions Module 3: Selection Techniques (1 hour) Understanding different selection tools and their uses Precise selections using the Marquee, Lasso, and Magic Wand tools Advanced selections with Quick Selection and Refine Edge Creating masks for non-destructive editing Module 4: Image Editing and Retouching (1 hour) Essential photo retouching techniques for portraits and landscapes Correcting exposure, color, and tone with Adjustment Layers Using the Healing Brush and Clone Stamp for seamless repairs Removing distractions and blemishes with Content-Aware tools Module 5: Typography and Text Effects (1 hour) Working with text layers and formatting options Creating eye-catching text effects using Layer Styles Manipulating text along paths and shapes Designing typographic compositions Module 6: Advanced Image Manipulation (1 hour) Combining images with layer masks and blending modes Creating composite images and surreal artwork Applying transformations and distortions for creative effects Working with Smart Objects for non-destructive editing Module 7: Filters and Special Effects (1 hour) Exploring various filters for artistic and practical purposes Applying blur, sharpening, and distortion filters Creating artistic effects with the Filter Gallery Using smart filters for flexible editing Module 8: Drawing and Vector Graphics (1 hour) Working with shape layers and vector tools Creating custom shapes and icons Utilizing the Pen tool for precise illustrations Designing logos and scalable graphics Module 9: Advanced Color Correction (1 hour) Mastering color adjustments with Curves and Levels Using Adjustment Layers for selective color control Understanding color spaces and profiles Creating duotones and split-tones Module 10: Designing for Web and Print (1 hour) Preparing images for web and social media platforms Understanding resolution and color modes for print Exporting files in various formats for different purposes Final project: Designing a digital artwork or print-ready composition Learning Outcome refers to what students are expected to know, understand, or be able to do at the end of a learning experience, such as a course, training program, or educational module. Learning outcomes are usually specific, measurable, and achievable objectives that demonstrate the effectiveness of the learning process. For example, learning outcomes for a Photoshop course could include: Participants will be proficient in using essential Photoshop tools and features. Participants will demonstrate the ability to apply advanced image editing and retouching techniques. Participants will be able to create visually appealing designs using layers, typography, and special effects. Participants will understand and utilize different file formats and color modes for various output requirements. Participants will produce a final project showcasing their skills and creativity in Adobe Photoshop.

Why Learn Adobe InDesign Advanced Training Course? Master Adobe InDesign for efficient page layouts with our advanced course. Learn document setup, text formatting, and special effects. Suitable for beginners and advanced users. London Design Training Course provides top InDesign course with Adobe Certified Instructors. Course Link Duration: 10 hrs Method: 1-on-1, Personalized attention Schedule: Tailor your own schedule by pre-booking hours of your choice, available from Mon to Sat between 9 am and 7 pm Flexible Learning Options: Choose between in-class training at our London center or participate online. Both options provide hands-on, practical learning with step-by-step demonstrations and ample opportunities for questions. Introduction to InDesign: Exploring InDesign Basics Customizing Preferences and Workspace Navigating Panels and Windows Setting Up Toolbar and Properties Panel Document Management: New Document, Pages, and Order Quick Navigation Techniques with Shortcuts Smart Layout: Organizing Layouts with Guides and Grids Understanding Bleed, Slug, and Margins Utilizing Smart Guides for Precision Typography: Mastering the Type Tool Adding Text to Pages and Using Placeholder Text Text Formatting with Character and Paragraph Controls Editing Text Frames and Justifying Text Multi-column Setup and Styling with Character/Paragraph Styles Working with Bullet Points and Numbering Working with Images: Creating Frames and Placing Images Content Fitting Options: Proportional Fit, Content-Aware Fit, Auto-Fit Manipulating Frame Properties: Fill, Stroke, Effects Utilizing Object Styles for Consistent Frames Advanced Techniques: Image Frame Grids, Merging Frames, Text Wrap Options Understanding Image Formats and Resolution Tabs and Alignment: Mastering Tab Palette and Alignment Options Adding Leaders for Enhanced Formatting Color Theory and Editing: Basics of Color Theory and Color Modes Creating Color Themes with the Color Theme Tool Swatches, Color Libraries, and Gradients Editing Gradient Fills and Colors Advanced Interactive Actions: Adding Animation Effects with Animation Panel Fine-tuning Animations with Timing Panel Creating Complex Object States and Action Buttons Adding and Testing Hyperlinks, Page Transitions Parent Page Basics: Understanding Parent Pages Page Numbering, Order, Headers, and Footers Inserting Text Variables for Dynamic Content Advanced Object Styles and Effects: Opacity Control and Blending Modes Black and White Conversion, Color Blending Modes Adding Dimension with Bevel and Emboss Effects Advanced Text Frame Options: Auto-sizing Text Frames and Balancing Column Height Inset Spacing and Fill Colors for Text Boxes Hot Corner Resizing Shortcuts and Anchor Objects Footnotes: Purpose and Usage of Footnotes Adding, Editing Footnotes with Footnote Options By the end of this Adobe InDesign training, participants will: Understand InDesign basics and its interface. Create effective page layouts with text formatting and image placement. Work with layers, apply special effects, and manage tables. Ensure error-free and print-ready documents through preflighting. Receive a practical training guide and an e-certificate upon completion.

LINX 3 training course description A detailed study of BGP, from the basics of how it works through to advanced issues such as route reflectors, policy, filtering, route selection and routing registries. The course culminates with a study of an industrial strength BGP template illustrating important issues such as bogon filtering. Practical hands on with routers follow the major sessions to reinforce the theory. A multiple choice exam, leading to the LAIT III certification, is available after the course. The exam consists of 60 questions and lasts 2 hours. What will you learn Connect enterprises to the Internet, and ISPs to each other. Describe how BGP works. List, describe and configure the main BGP attributes. Implement and troubleshoot BGP. Work with route aggregation and calculate CIDR prefixes in seconds. Influence traffic paths with BGP. LINX 3 training course details Who will benefit: Network engineers. Prerequisites: LAIT I and II OR CCNP and take LAIT I and LAIT II exams whilst on this course. Duration 5 days LINX 3 training course contents Basic BGP IGPs, EGPs, What's BGP? BGP RIB, in/out process, tables peers, adding routes. Hands on Simple configuration and troubleshooting. The Internet and peering ASs, AS numbers, Internet structure, ISP types, ISP network design, IXs, peering vs. transit, public/ private peering, bi/multi-lateral peering. Hands on AS information gathering. How BGP works Incremental updates, Path vector protocols, BGP protocol stack, the BGP header, message types, NLRI, withdrawn routes, route refresh, route dampening. Hands on More troubleshooting, packet analysis. MBGP and IPv6 Multiprotocol routing, AFI, SAFI, MBGP and multicasts, IPv6, MPLS VPNs. Hands on IPv6 BGPv4 aggregation CIDR, benefits, techniques, shortcuts, configuring BGP aggregation, leaking routes. Hands on Reducing routing table size. BGP path selection BGP attributes, attribute types, route selection order, Local preference, AS prepend, MEDs. Hands on Influencing traffic with BGP. BGP routing policies What is policy? Examples, route filtering, AS filtering, REs, applying preference selectively, peer groups. Hands on Sophisticated policies. RIPE and routing registries RIRs, Allocations, assignments, PI vs. PA. Objects, RPSL, routing registry, Hands on The RIPE database. Automating BGP configuration Automation tools, whois, IRRToolSet, Bogon lists, tracking bogon lists, HTTP, Peering, routing registries, DNS. Communities What is a community? Community names, communities for: peer types and geography. RFC 1998, default communities. Hands on Setting local preference on other routers. Route servers What are route servers? LINX route servers, route server policy control, What are route collectors, Looking glasses. Hands on Setting up and working with a route server. Peer relationships IBGP, EBGP, next hop self, advertising routes into/out of BGP, synchronisation. Hands on IBGP, troubleshooting a large BGP network. Route reflectors and confederations Full mesh IBGP, Route reflectors, RR configuration and design, confederations, migration issues. Hands on RR configuration. BGP architectures Stub vs. transit AS, when to use BGP, multihoming strategies and issues, default routes. Multihop EBGP, load balancing. Hands on Multihoming. BGP security RFC 7454, security steps, BGP TTL security, filters, RPKI, ROAs, rsync, rrdp, validators. A secure BGP template. Hands on RPKI prefix validation.

Software development training course description This three-day MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-361, and build an understanding of these topics: Core programming, Object-Oriented programming, general software development, web applications, desktop applications, and databases. This course leverages the same content as found in the Microsoft Official Academic Course (MOAC) for this exam. What will you learn Describe core programming. Explain Object Oriented programming. Describe general software development. Describe Web applications. Describe desktop applications. Explain how databases work. Software development training course details Who will benefit: Anyone looking to learn the fundamentals of software. Prerequisites: None. Duration 3 days Software development training course contents Core programming Computer storage and data types How a computer stores programs and the instructions in computer memory, memory stacks and heaps, memory size requirements for the various data storage types, numeric data and textual data. Computer decision structures Various decision structures used in all computer programming languages; If decision structures; multiple decision structures, such as If…Else and switch/Select Case; reading flowcharts; decision tables; evaluating expressions. Handling repetition For loops, While loops, Do...While loops and recursion. Understand error handling Structured exception handling. Object-oriented programming Classes Properties, methods, events and constructors; how to create a class; how to use classes in code. Inheritance Inheriting the functionality of a base class into a derived class. Polymorphism Extending the functionality in a class after inheriting from a base class, overriding methods in the derived class. Encapsulation Creating classes that hide their implementation details while still allowing access to the required functionality through the interface, access modifiers. General software development Application life cycle management Phases of application life cycle management, software testing. Interpret application specifications Application specifications, translating them into prototypes, code, select appropriate application type and components. Algorithms and data structures Arrays, stacks, queues, linked lists and sorting algorithms; performance implications of various data structures; choosing the right data structure. Web applications Web page development HTML, CSS, JavaScript. ASP.NET web application development Page life cycle, event model, state management, client-side versus server-side programming. Web hosting Creating virtual directories and websites, deploying web applications, understanding the role of Internet Information Services. Web services Web services that will be consumed by client applications, accessing web services from a client application, SOAP, WSDL. Desktop applications Windows apps UI design guideline categories, characteristics and capabilities of Store Apps, identify gestures. Console-based applications Characteristics and capabilities of console- based applications. Windows Services Characteristics and capabilities of Windows Services. Databases Relational database management systems Characteristics and capabilities of database products, database design, ERDs, normalisation concepts. Database query methods SQL, creating and accessing stored procedures, updating and selecting data. Database connection methods Connecting to various types of data stores, such as flat file; XML file; in-memory object; resource optimisation.

PMI-ACP® Exam Prep: Virtual In-House Training This course builds on the candidates' practical experience of Agile in the workplace to equip them with the broad range of knowledge and skills required for the PMI® Agile Certification exam. It will follow the PMI® requirements and reference the suggested reading list, including the Agile Practice Guide, but will not be limited to those areas. Within the profession and discipline of project management, Agile continues to develop as a significant and important aspect of bringing change to an organization. Where the products of change must be delivered to the business 'on time,' Agile is often the chosen methodology. In addition to equipping candidates for the PMI® Agile Certification examination, this course will also support candidates in taking a more informed and effective role in Agile projects. It will also enable them to take a significant role in encouraging and enabling the organization to become or develop as an Agile environment. What you will Learn You will learn how to: Appreciate the wider aspects of Agile project management tools and techniques Integrate various disciplines within Agile Tailor / customize Agile to suit the needs of different projects Prepare yourself for the PMI® Agile Certification examination Getting Started Introductions Agenda Expectations Foundation Concepts Defining 'Traditional' Project Management Project management parameters The 'traditional' approach to the parameters Strengths and weaknesses of the traditional approach Defining 'Agile' Project Management Project management parameters revisited The 'agile' approach to the parameters Strengths and weaknesses of agile Managing projects with traditional and agile methods Can the two approaches co-exist? Leveraging the benefits of both methods Options for using both methods on a project Avoiding the elephant traps Key aspects of the PMI® Agile Certified Practitioner (PMI-ACP)® Handbook Overview Eligibility requirements Exam information Exam Blueprint Continuing certification requirements Key aspects of the PMI Agile Certification Examination Content Outline Introduction Agile exam content outline Tools and techniques Knowledge and skills Domains and tasks (not examined) An Introduction to Agile and Implementing Agile Definable work vs. high-uncertainty work Project factors that influence tailoring The Agile Manifesto and 12 Principles Agile mindset Agile domains and tasks Agile Tools and Techniques Related to PM 'Hard Skills' Planning, monitoring, and adapting The need for planning, monitoring, and adapting The Agile approach to planning and plans The Agile planning tools and techniques The Agile monitoring tools and techniques The Agile approach to adapting Product quality A definition of 'product quality' Setting the standard for product quality Agile tools and techniques for achieving product quality Risk management A definition of 'risk' What is 'at risk'? The acceptability of risks The Agile tools and techniques for managing risks Agile Tools and Techniques Related to PM 'Soft Skills' The difference between PM 'hard and soft' skills Communications The importance of communications Forms of agile communications Communications within the project Communications from the project Communications to the project Making communications the cultural norm Interpersonal Skills Defining and understanding management Defining and understanding leadership Defining and understanding servant leadership Delegating vs. empowering Playing to people's strengths Overcoming the roadblocks Core Agile Tools and Techniques The philosophy of core Agile tools and techniques Agile estimation Will traditional forms of estimating work for agile? The relationship between estimating and guessing The relationship between estimating and sizing The where, who, and how of agile estimating Agile analysis and design Product analysis and design from a user point of view Product analysis and design from a supplier point of view Product analysis and design from an agile project point of view Value-Based Agile Tools and Techniques The role of value-based tools and techniques in bridging traditional PM with Agile Value-based prioritization Value-based prioritization and agile projects Investment appraisal methods Regulatory driven Customer driven Ranking methods (MMF, MoSCoW) Metrics What should we measure / track? Methods of measuring / tracking Adding value with metrics Process Improvement Value-stream analysis Value-stream mapping Agile Knowledge and Skills Context of Agile Knowledge and Skills vis-à-vis Agile Tools and Techniques Agile Knowledge and Skills Process focused People focused Product focused Project focused Exam Preparation and Course Closure The application process - where are you now? The 'Exam-Focused Journal' - what you still have to do Further preparation - self-study schedule Exam topic review Practice exam Practice exam debrief Course closure

Why Choose Vray for Maya Essentials Course?  Learn V-Ray's power for stunning 3D visualizations. In design and architecture, it's essential for effective idea communication, offering an intuitive interface and efficient rendering, ensuring faster images and animations. Click here for more info: Website Duration: 10 hours Training Approach: 1-To-1 Sessions. Schedule: Customize your schedule by pre-booking a convenient hour of your choice, available Mon to Sat between 9 am and 7 pm. Module 1: Introduction to Vray for Maya (2 hours) Understand the significance of Vray and its integration with Maya. Installation and setup of Vray for Maya. Familiarize with the Vray interface, workflow, and materials overview. Module 2: Lighting with Vray (2 hours) Explore various lighting techniques in Vray. Understand different Vray lights and their settings. Master the creation and control of Vray sun, sky, dome lighting, and IES lights. Learn efficient lighting workflows with Vray. Module 3: Vray Camera (2 hours) Grasp Vray camera settings and exposure control. Work with Vray depth of field and create camera animations. Understand Vray frame buffer functionalities. Module 4: Vray Materials (2 hours) Explore Vray materials, realistic material creation, and custom material libraries. Utilize Vray material overrides for enhanced customization. Module 5: Vray Rendering and Post Production (2 hours) Dive into Vray rendering settings and techniques for both images and animations. Enhance post-production skills using Photoshop and Vray frame buffer. Learn the art of compositing Vray render elements and utilizing Vray denoiser. Additional Topics Covered: Global Illumination in VRay: Exploring techniques such as Irradiance Map, Light Cache, Quasi-Monte Carlo/Brute Force, and Environmental Lighting. Image Sampling: Understanding Fixed, Adaptive QMC, and Adaptive Subdivisions for optimal rendering quality. VRay Lights: Mastering Plane Light, Dome Light, Sphere Light, VRay Sun, VRay Shadow, Image-Based Lighting HDRI, and Object-Based Lighting. VRay Camera: Manipulating Focal Length, Film Speed, and Shutter Speed for precise camera control. VRay Materials: Customizing Diffuse Color, Reflection, Refraction, and Blurry Reflections for lifelike material creation. Rendering Test Scenes: Practical application by rendering interior and exterior scenes for a hands-on learning experience. V-Ray-Maya Trial  https://www.chaos.com Master Vray for Maya to create high-quality renders. Apply various lighting techniques for realistic and visually appealing scenes. Control Vray camera settings and create dynamic shots. Create and customize realistic Vray materials for 3D scenes. Optimize rendering settings for high-quality output. Enhance renders with post-production techniques in Photoshop. Establish an efficient workflow with Vray in Maya. Gain hands-on experience and access valuable resources for further practice. Vray Proficiency: Master Vray tools, interface, and workflows in Maya for advanced 3D visualization. Advanced Lighting Skills: Expertise in diverse lighting techniques, including Vray sun, sky, and IES lights. Camera Control: Proficient manipulation of Vray camera settings, exposure, and animations. Material Customization: Create and customize realistic materials, utilizing custom libraries and overrides. Rendering Excellence: Skills in rendering images and animations, post-production, and compositing techniques. Global Illumination Mastery: Understand advanced global illumination methods for realistic scene lighting. Potential Jobs: 3D Lighting Artist: Specialize in illuminating scenes for films, games, or animations. 3D Visualization Specialist: Create realistic architectural or product visualizations. 3D Rendering Specialist: Focus on rendering high-quality images and animations. 3D Animator: Animate scenes within the context of realistic lighting. 3D Modeler: Develop detailed 3D models, ensuring realistic rendering. Visualization Consultant: Provide expert advice on visualization techniques. Freelance Vray Artist: Work independently on diverse projects, rendering scenes with exceptional realism. Expert Guidance: Receive guidance from certified tutors and industry professionals, benefitting from their deep expertise and practical insights. They will share valuable tips and techniques to enhance your rendering skills. Flexible Learning: Choose between in-person or live online sessions, tailored to your preference and location. Schedule training at your convenience, available Monday to Sunday, 9 am to 8 pm. Lifetime Assistance: Access lifetime email support, ensuring continuous guidance even after course completion. Our dedicated team is committed to addressing your queries and helping you overcome challenges. Unlock Your Potential: Enroll in our V-Ray for Maya Training Course to harness the power of this industry-leading rendering engine. Elevate your visual effects and animation skills, unleashing your creativity with stunning and lifelike renders.

Managing Successful Programmes (MSP®) 5th Edition Foundation: On-Demand MSP certification provides guidance for programme managers, business change managers and the next step for project managers to develop their knowledge and skills to be able to positively respond to the challenges for managing programmes and larger, more strategic or multiple projects. What you will Learn At the end of this course, participants will be able to: Understand key concepts relating to programmes and MSP Understand how the MSP principles underpin the MSP framework Understand the MSP themes and how they are applied throughout the programme Understand the MSP processes and how they are carried out throughout the programme Key Concepts of MSP Programmes Three Lenses of MSP Principles Themes and Governance Organization Organization Theme Organization Structure Individual Roles Stakeholder Management Design Design Theme Benefits Risk Identification and Prioritization Target Operating Model Documents and Key Roles Justification Justification Theme Business Case Financial Planning Documents and Key Roles Structure Structure Theme Delivery Planning Dependencies Benefits Realization Plan Resourcing Documents and Key Roles Knowledge Knowledge Theme Knowledge Management Information Management Document and Key Roles Assurance Assurance Theme Assurance at Multiple Levels Assurance Planning Document and Key Roles Decisions Decisions Theme Issue Resolution Risk Response Data Gathering and Reporting Options and Analysis Document and Key Roles MSP Processes Identify the Programme Design the Outcomes Plan Progressive Delivery Deliver the Capabilities Embed the Outcomes Evaluate New Information Close the Programme About the MSP 5th Edition Foundation Exam 60 multiple-choice questions 1-hour Closed-book Candidates require a minimum of 36 correct answers (60%) to pass

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.

Duration 4 Days 24 CPD hours This course is intended for This course is for IT Professionals with expertise in designing and implementing solutions running on Microsoft Azure. They should have broad knowledge of IT operations, including networking, virtualization, identity, security, business continuity, disaster recovery, data platform, budgeting, and governance. Azure Solution Architects use the Azure Portal and as they become more adept they use the Command Line Interface. Candidates must have expert-level skills in Azure administration and have experience with Azure development processes and DevOps processes. Overview Recommend solutions to minimize costs Recommend a solution for Conditional Access, including multi-factor authentication Recommend a solution for a hybrid identity including Azure AD Connect and Azure AD Connect Recommend a solution for using Azure Policy Recommend a solution that includes KeyVault Recommend a solution that includes Azure AD Managed Identities Recommend a storage access solution Design an Azure Site Recovery solution Recommend a solution for autoscaling Recommend a solution for containers Recommend a solution for network security Recommend a solution for migrating applications and VMs Recommend a solution for migration of databases This course teaches Solutions Architects how to translate business requirements into secure, scalable, and reliable solutions. Lessons include design considerations related to logging, cost analysis, authentication and authorization, governance, security, storage, high availability, and migration. This role requires decisions in multiple areas that affect an overall design solution. Design a Compute Solution Recommend a Solution for Compute Provisioning Determine Appropriate Compute Technologies Recommend a Solution for Containers Recommend a Solution for Automating Compute Management Design a Network Solution Recommend a Solution for Network Addressing and Name Resolution Recommend a Solution for Network Provisioning Recommend a Solution for Network Security Recommend a Solution for iInternete Connectivity and On-Premises Networks Recommend a Solution for Automating Network Management Recommend a Solution for Load Balancing and Rraffic Routing Design for Migration Assess and On-Premises Servers and Applications for Migration Recommend a Solution for Migrating Applications and VMs Recommend a Solution for Migration of Databases Design Authentication and Authorization Tips for Identity and Access Management Recommend a Solution for Multi-Factor Authentication Five Steps for Securing Identity Infrastructure Recommend a Solution for Single-Sign On (SSO) Recommend a Solution for a Hybrid Identity Recommend a Solution for B2B Integration Recommend a Hierarchical Structure for Management Groups Design Governance Recommend a Solution for using Azure Policy Recommend a Solution for using Azure Blueprint Design a Solution for Databases Select an Appropriate Data Platform Based on Requirements Overview of Azure Data Storage Recommend Database Service Tier Sizing Dynamically Scale Azure SQL Database and Azure SQL Managed Instances Recommend a Solution for Encrypting Data at Rest, Transmission, and In Use Select an Appropriate Storage Account Understanding Storage Tiers Recommend a Storage Access Solution Recommend Storage Management Tools Design Data Integration Recommend a Data Flow Recommend a Solution for Data Integration Design a Solution for Logging and Monitoring Azure Monitoring Services Azure Monitor Design a Solution for Backup and Recovery Recommend a Recovery Solution for Hybrid and On-Premises Workloads Design and Azure Site Recovery Solution Recommend a Solution for Recovery in Different Regions Recommend a Solution for Azure Backup Management Design a Solution for Data Archiving and Retention Design for High Availability Recommend a Solution for Application and Workload Redundancy Recommend a Solution for Autoscaling Identify Resources that Require High Availability Identify Storage Tpes for High Availability Recommend a Solution for Geo-Redundancy of Workloads Design for Cost Optimization Recommend Solutions for Cost Management Recommended Viewpoints for Minimizing Costs Design an Application Architecture Recommend a Microservices Architecture Recommend an Orchestration Solution for Deployment of Applications Recommend a Solution for API Integration Design Security for Applications Security for Applications and Services Recommend a Solution using Key Vault Recommend Solutions using Azure AD Managed Identities