1392 Courses in London

Adobe Illustrator and Photoshop Masterclass Training, your gateway to Photoshop and Illustrator. Learn with the best software for publishing and marketing materials. This comprehensive training covers Photoshop, Illustrator, and InDesign, offering step-by-step tutorials tailored for creative professionals. Click here for more info: Website Duration: 10 hours Approach: Individualized, Tailored Content, Flexible Pace, Personal Support Scheduling Flexibility: 1-on-1 sessions from Mon to Sat, 9 am to 7 pm, based on your availability. Course Title: Adobe Photoshop and Illustrator Mastery Workshop Duration: 10 Hours (Divided into 10 Modules) Module 1: Introduction to Adobe Photoshop (1 hour) Familiarization with Photoshop interface and tools Understanding bitmap graphics and resolution Basic image editing techniques (cropping, resizing, color adjustments) Significance of layers in design Module 2: Essential Photoshop Tools (1 hour) Mastery of selection tools (Marquee, Lasso, Magic Wand) Understanding brushes and their settings Introduction to the Pen tool for precise selections Working adeptly with layers and layer styles Module 3: Advanced Image Editing (1 hour) Proficiency in advanced color adjustments (Curves, Levels, Hue/Saturation) Techniques for photo retouching and manipulation Creating composite images using blending modes Application of filters and special effects for creative designs Module 4: Introduction to Adobe Illustrator (1 hour) Exploration of Illustrator interface and tools Working with vector graphics and paths Basic shapes and drawing tools Understanding anchor points and handles Module 5: Creating Vector Artwork (1 hour) Expert use of the Pen tool for precise vector illustration Creating and editing shapes and objects Mastery in handling gradients and patterns Understanding the Appearance panel Module 6: Illustrator Typography (1 hour) Text tools and advanced formatting options Crafting text effects and artistic typography Integration of text with shapes and images Working adeptly with text on a path Module 7: Combining Photoshop and Illustrator (1 hour) Importing Illustrator files into Photoshop and vice versa Efficient use of smart objects and vector shapes in Photoshop Creation of custom brushes and patterns in Illustrator for seamless use in Photoshop Designing posters and flyers by combining elements from both software Module 8: Integration with InDesign (1 hour) Exporting assets from Photoshop and Illustrator for InDesign Crafting layouts in InDesign using assets from both programs Understanding print and digital design nuances Preparing files for printing and online use Module 9: Advanced Techniques and Tips (1 hour) Creating custom actions and automation in Photoshop Mastery in advanced selection techniques Utilizing Illustrator's advanced tools (Pathfinder, Shape Builder, etc.) Exploration of creative design styles and trends Module 10: Final Projects and Portfolio (1 hour) Individual or group projects incorporating Photoshop and Illustrator skills Detailed review and feedback on the projects Preparation of a portfolio showcasing the work   Upon completion of the Adobe Photoshop and Illustrator Mastery Workshop, participants will: Master Advanced Design Techniques: Acquire expert skills in both Adobe Photoshop and Illustrator, delving into advanced tools, filters, and effects for intricate design work. Seamlessly Integrate Software: Learn to seamlessly integrate Photoshop and Illustrator, enabling the creation of dynamic and visually appealing designs by leveraging the unique strengths of both programs. Develop Creative Problem-Solving: Cultivate creative problem-solving abilities by exploring diverse design styles and industry-relevant trends, empowering the creation of innovative and captivating visuals. Construct Professional Portfolios: Gain the expertise to construct professional portfolios, showcasing a diverse range of projects incorporating advanced Photoshop and Illustrator techniques. Collaborate on Real-World Projects: Collaborate effectively on real-world design projects, combining Photoshop and Illustrator skills to produce high-quality marketing materials, promotional content, and digital artwork. Career Opportunities: Upon mastering Photoshop and Illustrator, participants can pursue a range of creative careers, including: Graphic Designer: Craft visually appealing designs for print and digital media, ranging from marketing materials to social media graphics. Digital Illustrator: Create intricate digital illustrations and artworks for various applications, including book covers, digital publications, and games. Web Designer: Develop engaging and user-friendly website layouts and elements, optimizing user experience through appealing visuals. Advertising Artist: Design compelling advertisements for print and online platforms, captivating audiences and promoting brands effectively. Freelance Designer: Work as a freelance designer, taking on diverse projects from clients and agencies, showcasing versatility in both Photoshop and Illustrator skills. By mastering these Adobe tools, participants open doors to a multitude of creative opportunities in the ever-expanding digital design industry. Skills Acquired: Participants in the Adobe Illustrator and Photoshop Masterclass Training will develop advanced skills in vector graphics, digital illustration, and photo manipulation using Adobe Illustrator and Photoshop. Key skills include: Precision Vector Graphic Design in Illustrator Creative Digital Illustration Techniques Advanced Photo Editing and Manipulation in Photoshop Job Opportunities: Upon completion, individuals can pursue roles such as: Graphic Designer Digital Illustrator Advertising Creative Branding Specialist Elevate Your Design Skills: Master Adobe Illustrator and Photoshop, crafting stunning graphics, logos, and digital illustrations. Understand design principles, tools, and workflows. Receive a recognized Certificate of Completion and access recorded lessons for future reference. Expert Guidance, Your Schedule: Learn from certified experts, tailored to your timetable-flexible online or in-person sessions, Monday to Sunday, 9 am to 8 pm. Enjoy lifetime email support for seamless learning. Unleash Your Creativity Today: Enroll now to ignite your creative potential in Adobe Illustrator and Photoshop. Elevate your designs effortlessly.

Vectorworks Evening Course face to face One to one

Voice over LTE training course description This course provides a basic understanding of the 3G LTE Air Interface, SAE, as well as Voice over LTE options and LTE Advanced features. Investigating the standards for the EPS , formulated by the 3GPP standards body, the course will set out to examine and explain the 4G environment from user equipment to border gateway and beyond. This course will ensure the delegate has a grasp of all aspects of the current global deployments, the next steps in upgrades and the promise of things to come. What will you learn Describe the complete EPC architecture. Explain the use of QoS within the air interface & core network. Explore the features of LTE advanced. Describe the various methods of supporting voice services with 3G LTE. Describe IMS structure and control entities. Explain an IMS session. Voice over LTE training course details Who will benefit: Any engineers who are assisting in the deployment of voice services within their LTE networks. Prerequisites: Intro to Data comms & networking Telecommunications Introduction Duration 3 days Voice over LTE training course contents 3GPP standards body Release 8 - Release 12, Supported and expected features. The EPC revisited EPC revisited 3G LTE & EPC Architecture, NB, MME, SGW, PDNGW, PCRF, Interworking capabilities, Protocol stack explored, NAS signalling, Default EPS bearer, Slot allocation algorithms, Scheduling algorithms, Quality of Service requirements, Dedicated EPS bearers. VoLTE deployment strategies Common networks everywhere, GSM/WCDMA view, CDMA view. VoLTE system architecture LTE radio, LTE Radio background, LTE radio architecture, Evolved packet core, EPC entities & functions, EPS mobility management, MS entities, Home subscriber server, Policy & charging rules function. VoLTE functionality Radio functionality, Bearers & schedulers, Mobility, Circuit switched fall back handover, Mobility from 2G/3G back to LTE, Power Saving Features, Positioning services, UE radio access capabilities for VoLTE users. EPC functionalities, LTE subscriber identification, PDN connectivity establishment, EPS dedicated bearer setup, IMS identification, IP multimedia identification module, Public user identity, Private user identity, Relationship between public & private identity, identification of users device, identification of network entities, identification of services, identification without ISIM. IMS service provisioning, Enforcement of allowed services, Service triggering information, Selection of the AS, AS behaviour, Service provisioning in action. VoLTE end-to-end & signalling VoLTE subscription & device configuration. EPS attach for CSFB/IMS VoIP & default bearer. IMS registration, Constructing the REGISTER request, From UE to P-CSCF, From P-CSCF to I-CSCF, From I-CSCF to S-CSCF, S-CSCF challenges the UE, UE's response to the challenge, Registration at the S-CSCF, The 200 OK response, Third-party registration to application servers, Subscription to registration event package, Re-registration & re-authentication, De-registration, Related standards. IMS VoIP session, Constructing the INVITE request, Routing, Media negotiation, Media resource reservation & policy control, Charging, Session release. Voice continuity, PS - PS intersystem handover, Single radio voice call continuity. IMS emergency session, PDN Connection setup for emergency session, Emergency registration, Emergency session. CS fallback for EPS call case, Architecture of CS fallback in EPS, Description of SGs interface, Idle mode signalling reduction, Idle mode vs active mode, CS fallback attachment, Mobile originating call using CSFB, Mobile terminating call using CSFB, Call unrelated CSFB procedures, Mobile terminating roaming retry & forwarding. VoLTE Messaging, Native IMS messages, SMS interworking, Multimedia messaging service. Unstructured supplementary services data simulation in IMS. IMS services VoLTE radio performance Coverage, Latency, Capacity. LTE advanced features Carrier aggregation, Coordinated mMulti-point Operation (CoMP), ICIC & eICIC, Relay node deployment & donor eNBs, Improved cell edge coverage, Reduced control plane latency, Heterogeneous networks, HeNB, security gateways, HeNB gateways.

Photoshop Essentials Evening Training Sessions, where you'll master the basics and elevate your photography and Photoshop rendering skills. Enhance your photos significantly, learning everything from color correction to retouching techniques. Expertly retouch and repair images during our comprehensive Photoshop training courses. Click here for more info: Website Duration: 10 hours Approach: 1-on1 guidance, Customized instruction and Tailored content. Choose your own time and day Monday to Saturday 9 am to 7 pm Becoming Proficient in Adobe Photoshop - 10-Hour Training Program Module 1: Introduction to Photoshop (1 hour) Familiarization with Photoshop interface and tools Understanding file formats and resolution concepts Navigation within the workspace and customization of preferences Mastering essential keyboard shortcuts for efficient workflow Module 2: Working with Layers (1 hour) Grasping the significance of layers and their efficient organization Application of layer styles to enhance creativity Utilization of blend modes for striking compositions Module 3: Selection Techniques (1 hour) Understanding diverse selection tools and their specific applications Precision in selections using Marquee, Lasso, Magic Wand, Quick Selection, and Refine Edge tools Creation of masks for non-destructive editing Module 4: Image Editing and Retouching (1 hour) Essential techniques for retouching portraits and landscapes Corrections in exposure, color, and tone using Adjustment Layers Seamless repairs with Healing Brush, Clone Stamp, and Content-Aware tools Module 5: Typography and Text Effects (1 hour) Working with text layers and formatting options Crafting captivating text effects using Layer Styles Manipulating text along paths and shapes for creative compositions Module 6: Advanced Image Manipulation (1 hour) Merging images with layer masks and blending modes Crafting composite images and surreal artwork Applying transformations and distortions creatively using Smart Objects Module 7: Filters and Special Effects (1 hour) Exploration of various filters for artistic and practical applications Application of blur, sharpening, distortion filters, and creative effects using the Filter Gallery Flexible editing with smart filters Module 8: Drawing and Vector Graphics (1 hour) Working with shape layers and vector tools Creation of custom shapes, icons, and logos Precision in illustrations using the Pen tool Module 9: Advanced Color Correction (1 hour) Expertise in color adjustments with Curves and Levels Selective color control using Adjustment Layers Understanding color spaces, profiles, and creating duotones and split-tones Module 10: Designing for Web and Print (1 hour) Image preparation for web and social media platforms Understanding resolution and color modes for print File exportation in various formats catering to diverse needs Final Project: Crafting a digital artwork or print-ready composition to showcase acquired skills. Upon completing this 10-hour Adobe Photoshop course, participants will: Master Photoshop Tools: Navigate the interface efficiently, apply advanced tools, and utilize essential shortcuts for streamlined work. Perfect Layer Techniques: Organize layers, use blend modes, and apply styles for visually appealing compositions. Refine Selection Skills: Make precise selections, create masks, and employ advanced selection tools for accuracy. Enhance Images Professionally: Learn advanced retouching, correction, and repair techniques for seamless photo editing. Create Captivating Text: Work with text layers, apply styles, and design typographic compositions creatively. Master Image Manipulation: Merge images seamlessly, apply transformations, and create surreal artwork with Smart Objects. Apply Filters and Effects: Utilize a range of artistic filters and effects for creative enhancements. Professional Vector Graphics: Craft custom shapes, logos, and icons with precision using vector tools. Advanced Color Correction: Master color adjustments, selective color control, and create captivating duotones and split-tones. Produce Print and Web Designs: Prepare images for various platforms, understand resolution, and export files in diverse formats. Hands-On Project Proficiency: Apply skills in real-world projects, demonstrating professional design expertise. Upon completion, participants will have the confidence and proficiency to excel in Photoshop, enabling high-quality, professional design work in both digital and print media. Adobe Photoshop Course: Adobe Photoshop course, hosted at the UK's top Adobe Training Centre. Develop expertise in Adobe's premier digital imaging software, crucial for crafting compelling visuals across a multitude of digital platforms. Our Photoshop training programs focus on interactive, real-life exercises, ensuring a hands-on and practical learning environment. Whether you are a novice aiming for a robust foundation or a proficient user striving for increased efficiency, our wide-ranging Photoshop courses are tailored to meet your specific requirements. Enroll today to master Photoshop and tap into a world of creative possibilities. Jobs You Can Pursue: Graphic Designer: Create visually appealing graphics for print and digital media. Digital Artist: Craft digital artwork for various applications, from illustrations to advertisements. Photo Retoucher: Enhance and manipulate photos to achieve desired visual effects. UI/UX Designer: Design user interfaces and experiences for websites and applications. Web Designer: Develop visually engaging websites by incorporating Photoshop skills into web design. Marketing Content Creator: Produce marketing materials like banners, brochures, and social media visuals. Freelance Designer: Work independently, offering design services to clients across different industries. Advertising Creative: Contribute to creative campaigns by designing impactful ad visuals. Print Production Specialist: Prepare print-ready materials, ensuring quality in printed products. Photography Post-Processing Specialist: Enhance and retouch photographs, optimizing them for professional use. Course Advantages: Master Vital Photoshop Skills: Gain expertise in essential image editing and manipulation techniques. Craft Striking Digital Artwork: Create visually appealing digital art and design graphics with finesse. Attain Professional-Quality Results: Achieve high-quality outcomes with accuracy and speed in your work. Unleash Creative Potential: Explore versatile design capabilities, tapping into your full creative spectrum. Flexible Learning: Access recorded lessons for convenient learning and revision. Continuous Assistance: Benefit from lifetime email support, ensuring ongoing guidance and support.

ITIL® 4 Specialist: High Velocity IT The ITIL® 4 Specialist: High-Velocity IT module is part of the Managing Professional stream for ITIL® 4. Candidates need to pass the related certification exam for working towards the Managing Professional (MP) designation. This course is based on the ITIL® 4 Specialist: High-Velocity IT exam specifications from AXELOS. With the help of ITIL® 4 concepts and terminology, exercises, and examples included in the course, candidates acquire the relevant knowledge required to pass the certification exam. This module addresses the specifics of digital transformation and helps organizations to evolve towards a convergence of business and technology, or to establish a new digital organization. It was designed to enable practitioners to explore the ways in which digital organizations and digital operating models function in high-velocity environments. Working practices such as Agile and Lean, and technical practices and technologies such as Cloud, Automation, and Automatic Testing are included. What You Will Learn At the end of this course, participants will be able to: Understand concepts regarding the high-velocity nature of the digital enterprise, including the demand it places on IT. Understand the digital product lifecycle in terms of the ITIL operating model. Understand the importance of the ITIL guiding principles and other fundamental concepts for delivering high-velocity IT. Know how to contribute to achieving value with digital products. Course Introduction Let's Get to Know Each Other Course Learning Objectives Target Audience Characteristics ITIL® 4 Certification Scheme Course Components Course Agenda Module-End Exercises Exam Details Introduction to High-Velocity IT High-Velocity IT Digital Technology Digital Organizations Digital Transformation High-Velocity IT Approaches Relevance of High-Velocity IT Approaches High-Velocity IT Approaches in Detail High-Velocity IT Operating Models Introduction ITIL® Perspective High-Velocity IT Aspects High-Velocity IT Applications ITIL® Building Blocks for High-Velocity IT Digital Product Lifecycle Service Value Streams Four Dimensions of Service Management ITIL® Management Practices High-Velocity IT Culture Key Behavior Patterns ITIL® Guiding Principles Supporting Models and Concepts for Purpose Ethics Design Thinking Supporting Models and Concepts for People Reconstructing for Service Agility Safety Culture Stress Prevention Supporting Models and Concepts for Progress Working in Complex Environments Lean Culture ITIL® Continual Improvement Model High-Velocity IT Objectives and Techniques High-Velocity IT Objectives High-Velocity IT Techniques Techniques for Valuable Investments Prioritization Techniques Minimum Viable Products and Services Product / Service Ownership A/B Testing Techniques for Fast Developments Basic Concepts Related to Fast Development Infrastructure as Code Reviews Continual Business Analysis Continuous Integration / Continuous Delivery (CI/CD) Continuous Testing Kanban Techniques for Resilient Operations Introduction to Resilient Operations Technical Debt Chaos Engineering Definition of Done Version Control Algorithmic IT Operations ChatOps Site Reliability Engineering (SRE) Techniques for Co-created Value Basic Concepts of Co-created Value Service Experience Techniques for Assured Conformance DevOps Audit Defense Toolkit DevSecOpsPeer Review

ITIL® 4 Specialist: High Velocity IT: In-House Training The ITIL® 4 Specialist: High-Velocity IT module is part of the Managing Professional stream for ITIL® 4. Candidates need to pass the related certification exam for working towards the Managing Professional (MP) designation. This course is based on the ITIL® 4 Specialist: High-Velocity IT exam specifications from AXELOS. With the help of ITIL® 4 concepts and terminology, exercises, and examples included in the course, candidates acquire the relevant knowledge required to pass the certification exam. This module addresses the specifics of digital transformation and helps organizations to evolve towards a convergence of business and technology, or to establish a new digital organization. It was designed to enable practitioners to explore the ways in which digital organizations and digital operating models function in high-velocity environments. Working practices such as Agile and Lean, and technical practices and technologies such as Cloud, Automation, and Automatic Testing are included. What You Will Learn At the end of this course, participants will be able to: Understand concepts regarding the high-velocity nature of the digital enterprise, including the demand it places on IT. Understand the digital product lifecycle in terms of the ITIL operating model. Understand the importance of the ITIL guiding principles and other fundamental concepts for delivering high-velocity IT. Know how to contribute to achieving value with digital products. Course Introduction Let's Get to Know Each Other Course Learning Objectives Target Audience Characteristics ITIL® 4 Certification Scheme Course Components Course Agenda Module-End Exercises Exam Details Introduction to High-Velocity IT High-Velocity IT Digital Technology Digital Organizations Digital Transformation High-Velocity IT Approaches Relevance of High-Velocity IT Approaches High-Velocity IT Approaches in Detail High-Velocity IT Operating Models Introduction ITIL® Perspective High-Velocity IT Aspects High-Velocity IT Applications ITIL® Building Blocks for High-Velocity IT Digital Product Lifecycle Service Value Streams Four Dimensions of Service Management ITIL® Management Practices High-Velocity IT Culture Key Behavior Patterns ITIL® Guiding Principles Supporting Models and Concepts for Purpose Ethics Design Thinking Supporting Models and Concepts for People Reconstructing for Service Agility Safety Culture Stress Prevention Supporting Models and Concepts for Progress Working in Complex Environments Lean Culture ITIL® Continual Improvement Model High-Velocity IT Objectives and Techniques High-Velocity IT Objectives High-Velocity IT Techniques Techniques for Valuable Investments Prioritization Techniques Minimum Viable Products and Services Product / Service Ownership A/B Testing Techniques for Fast Developments Basic Concepts Related to Fast Development Infrastructure as Code Reviews Continual Business Analysis Continuous Integration / Continuous Delivery (CI/CD) Continuous Testing Kanban Techniques for Resilient Operations Introduction to Resilient Operations Technical Debt Chaos Engineering Definition of Done Version Control Algorithmic IT Operations ChatOps Site Reliability Engineering (SRE) Techniques for Co-created Value Basic Concepts of Co-created Value Service Experience Techniques for Assured Conformance DevOps Audit Defense Toolkit DevSecOpsPeer Review

Total QoS training course description An advanced technical hands on course focusing on Quality of Service issues in IP networks. What will you learn Explain the difference between Integrated services and differentiated services. Explain how DiffServ works. Explain how RSVP works. Design networks supporting QoS. Total QoS training course details Who will benefit: Network administrators. Network operators. Prerequisites: TCP/IP Foundation for engineers Duration 3 days Total QoS training course contents What is QoS QoS and CoS, throwing bandwidth at the problem, Best effort services, Differentiated services, Integrated services, guarantees, the need for QoS, IETF working groups. Application issues Video, Voice, other applications, Jitter, delay, packet loss. Flows, per flow and per aggregate QoS, Stateful vs. stateless QoS, applications vs. network QoS. 'Traditional' IP QoS The TOS field and precedence, the obsolete OSPF use of the TOS field, TCP congestion avoidance. Queuing Where to use queuing, FIFO, Priority queuing, Custom queuing, Weighted Fair Queuing, CBWFQ, PQWFQ, LLQ, RED and WRED. DiffServ Architecture, DSCP, CU, packet classification and marking, meters and conditioners, Bandwidth brokers and COPS, Per Hop Behaviours, best effort PHB, Assured Forwarding PHB, Expedited forwarding PHB, Network Based Application Recognition (NBAR). Layer 2 issues Fragmentation and interleaving, compression (codecs, MPEG formats, header compression…), 802.1p, Subnet bandwidth management, Bandwidth allocators and requestor modules, the use of MPLS, traffic engineering, traffic shaping. RSVP What is RSVP? architectures, paths, path messages, reservations, traffic specifications, tear downs, guaranteed and controlled load, token buckets, Call Admission Control in voice networks, gatekeepers. Other issues Policy based routing, the Resource Allocation Protocol, QoS management tools, baselining networks, design issues, QoS in IPv6, QoS and multicasts.

Windows clustering training course description This course covers high availability and disaster recovery technologies such as live migration, storage migration and Hyper-V Replica, as well as providing indepth coverage of failover clustering including a detailed implementation of failover clustering of Hyper- V using SoFS. The course also covers System Center Virtual Machine Manager and implementing Network Load Balancing (NLB) and load balancing clusters. What will you learn Plan and implement a failover cluster. Describe managing server roles and clustering resources. Implement and manage virtual machines. Use System Center Virtual Machine Manager. Describe cloud-based storage and high availability solutions. Implement a Network Load Balancing (NLB) cluster. Windows clustering training course details Who will benefit: Technical staff working with Microsoft clusters. Prerequisites: Supporting Microsoft Windows server Duration 3 days Windows clustering training course contents High Availability in Windows Server Defining levels of availability, High Availability and disaster recovery solutions with Hyper-V Virtual Machines, High Availability with failover clustering in Windows Server. Hands on Configuring High Availability and Disaster Recovery. Implementing failover clustering Planning a failover cluster, creating a new failover cluster. Hands on Creating and Administering a Cluster. Server roles and clustering resources Configuring highly available applications and services on a failover cluster, managing and maintaining a failover cluster, troubleshooting a failover cluster, implementing site high availability with multisite failover clusters. Hands on Managing server roles and clustering resources. Failover clustering with Hyper-V Overview of integrating Hyper-V with failover clustering, implementing Hyper-V with failover clustering, managing and maintaining Hyper-V Virtual Machines on failover clusters. Hands on Implementing failover clustering by using Hyper-V Storage Infrastructure Management with Virtual Machine Manager Virtual Machine Manager, managing storage infrastructure with Virtual Machine Manager, provisioning failover clustering in Virtual Machine Manager. Hands on Managing storage infrastructure. Cloud-Based storage and High Availability Azure storage solutions and infrastructure, cloud integrated storage with StorSimple, disaster recovery with Azure Site Recovery. Hands on Managing cloud-based storage and high availability Network Load Balancing Clusters Overview of NLB, configuring an NLB cluster, planning NLB. Hands on Implementing a Network Load Balancing Cluster

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.

Overview Appreciative Inquiry is a form of action research that collects people’s stories of best practices. We can use these best practices as a way to initiate organisational change. This course will guide attendees through the process of Appreciative Inquiry (AI) and give them the techniques to succeed in using the AI system. This course will benefit anyone that leads change and wants to create positive dialogue that leads to improvements within their organisation. Description David Cooperrider, Suresh Srivastva, and their colleagues at Case Western Reserve University developed AI in the 1980s. According to them, the aim of Appreciative Inquiry is to help the organisation in: Envisioning a collectively desired future Realising that vision in ways that successfully translate intention into reality and beliefs into practices The AI approach can be applied in almost all groups of people and once the process starts, the change is put in motion. The appreciative approach works in individual conversations among colleagues, managers and employees. AI consultants around the world are increasingly using an appreciative approach to bring about collaborative and strengths-based change. This course will provide attendees with the means to effectively develop the skills of managers for the benefit of their organisation. They will be taken through the full process of appreciative inquiry; developing a wide understanding of the tools and techniques required to effectively improve communication and affect change. What can Appreciative Inquiry achieve? Well, just imagine you were better able to: Solve problems within an organisation in a positive and forward-thinking way. Be more curious and excited about the challenges faced within the business. Ask unconditional, positive questions to strengthen the organisations capacity to increase potential. Approach change in an affirmative mindset. Use questions to create movement and change within the company. Simply apply core communication skills, for overall organisational success Topics covered: What is Appreciative Inquiry? – A review of the subject with an activity that helps embed understanding and a case study that explains the process in action. Benefits of Appreciative Inquiry to the Organisation – Establishing how AI can aid and improve the way an organisation works and how people communicate within it. Exploring how specific organisational issues can be viewed positively. Appreciative Inquiry Questions – Understanding how questions can be used to identify positive organisational improvements and refocus our approach to business issues. Appreciative Inquiry Interviews – A set process for performing AI interviews and framing consultations to get the best out of those involved. A chance to practice the given approach and hone personal skills. The 4D Model – An overview of the AI 4D Model (Discovery, Dream, Design, Destiny) and how it is applied. The 4D Model: Topic – Demonstrating how selecting the topic is the beginning of the 4D model process. Choosing the participants own topic to work on throughout the training. The 4D Model: Discovery – Showing how positive discussions are kick-started at this stage and taking a chance to look at, ‘the best there is and what has been’. The 4D Model: Dream – ‘Thinking big and beyond what they have in the past’. Creating an amazing and positive vision for the future. The 4D Model: Design – Laying the foundation with a design of the vision, principles, and set of propositions that describe the ideal end state. Defining the desired state by creating a hierarchy and blueprint for success. The 4D Model: Destiny – Defining clear actions that will help the organisation and individuals achieve what they have set out to. The output is the self-reinforcing nature of using positive and affirmative inquiry to improve the business. The 4D Model: Summary Task – Review of learning and knowledge check. The Change Process – Exploring Dr. Kotter’s 8-step change process and how it can support the AI approach. Rooms of Change – Understanding feelings and attitudes to change, using this interesting and memorable model. Using an activity to help participants consider their own ‘change position’ and what this might mean for them. Strategies for Managing Change – A simple set of skills to help overcome the challenges faced by people trying to implement change. Applying these strategies to the 4D Model and Appreciative Inquiry. Recall Quiz – A chance to review learning in an engaging way. Summary – Developing actions and key points to take away. Who should attend Managers who want to learn about and practice the Appreciative Inquiry approach to drive positive changes. Requirements for Attendees None.