123 Database courses in London

About this Virtual Instructor Led Training (VILT) This 4 half-day Virtual Instructor Led Training (VILT) course presents the principles and best practices of portfolio management in the upstream (E&P) oil and gas industry. The VILT course is equally valuable for small independents, large integrated international companies and national oil companies. The VILT course consists of presentations, case studies, illustrative practical exercises and syndicate discussions. Particular emphasis is given to pragmatic portfolio management approaches and solutions which can be implemented swiftly without recourse to major investments in planning and portfolio management software. The VILT course will draw on examples from your expert course leader's 35+ years' experience in the oil and gas industry as an explorationist, upstream vice-president and management consultant. The VILT course handout will comprise softcopy slides used in the presentation and a softcopy workbook for the exercises. Participants will gain proficiency in portfolio management techniques, understand how and why to undertake this activity and be able to apply key concepts directly in the business of their teams / divisions. The VILT course will be presented over 4 half-days, using Microsoft Teams or Zoom and a proprietary set of VILT tools. Participants will be asked to complete a pre course questionnaire (PCQ) addressing their objectives and experience, and attend a session to familiarise themselves with VILT tools before course commencement.     Training Objectives To present the tools, concepts and principles of portfolio management To define the quantitative metrics which are used to describe projects in a portfolio To understand the benefits of portfolio management at different stages of the upstream business: in strategy development, opportunity screening, business development, drilling prospects, conducting appraisal of discoveries and developing fields To put portfolio management in the organisational context by describing the role of the portfolio management team and examining how value assurance (quality control) is best conducted on portfolio data for projects and assets To demonstrate how portfolio management contributes to improved business performance By the end of the VILT course, participants will understand: Key concepts and principles of portfolio management How to design a simple portfolio database and describe complex projects in a small number of objective metrics How to segment the portfolio into meaningful units How to use portfolio data in making business choices and decisions at the strategic and tactical levels The extent to which it is meaningful and reasonable to make comparisons across different portfolio segments How the portfolio management team can support the wider business in decision-making Target Audience This VILT course is specially designed for exploration and development geoscientists, E&P economists and finance staff, and E&P managers. Both technical and non-technical staff will benefit from the concepts presented. Companies are encouraged to send participants from different functions and seniority levels to gain great benefits especially those which would like to implement the concepts presented in this VILT course. Course Level Basic or Foundation Training Methods The VILT course will be delivered online in 4 half-day sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day. The VILT course will be presented in an interactive workshop format that allows for discussion. Course Duration: 4 half-day sessions, 4 hours per session (16 hours in total). Trainer Your expert course leader draws on more than 35 years of experience managing, reviewing and directing projects in all aspects of the exploration business: from exploration business development (new ventures), through prospect maturation and drilling, to the appraisal of discoveries. He has more than 30 years' experience with Shell International, followed by 10 years consulting to NOCs in Asia Pacific, Africa and South America and independent oil companies in the United Kingdom, continental Europe and North America. Other than delivering industry training, he has worked on projects for oil & gas companies of all sizes, including independents, national oil companies and (super)-majors, private equity firms, hedge funds and investment banks, and leading management consulting firms. He is an alumnus of Cambridge University. He has M.A and Ph.D. degrees in geology and is a Fellow of the Geological Society of London as well as a respected speaker on management panels at international conferences. Professional Experience Management consultancy & executive education: Advice to investment banks, businesses and major consulting firms. Specialist expertise in upstream oil & gas, with in depth experience in exploration strategy, portfolio valuation and risk assessment. Leadership: Managed and led teams and departments ranging from 3 - 60 in size. Provided technical leadership to a cadre of 800 explorationists in Shell worldwide. Member of the 12-person VP team leading global exploration in Shell, a $3 bln p.a. business and recognised as the most effective and successful among its industry peers. Accountability & decision-making: Accountable for bottom-line results: in a range of successful exploration ventures with budgets ranging from $10's million to $100's million. Made, or contributed to, complex business decisions / investments, taking into account strategic, technical, commercial, organisational and political considerations. Corporate governance: Served as non-executive director on the Boards of the South Rub al Khali Company (oversight of gas exploration studies and drilling in Saudi Arabia) and SEAPOS B.V. (exploration deep-water drilling and facilities management). Technical & operations: Skilled in exploration opportunity evaluation, the technical de risking of prospects, portfolio analysis and managing the interface between exploration and well engineering activities. Unparalleled knowledge of the oil and gas basins of the world, and of different operating regimes and contractual structures, ranging from Alaska, Gulf of Mexico and Brazil, through to the Middle East, former Soviet Union, Far East and Australia. Safety: Following an unsatisfactory audit, became accountable for safety performance in Shell's exploration new ventures. Through personal advocacy and leadership of a small team, delivered pragmatic and effective HSE systems, tools and staff training / engagement and a dramatically improved safety record. R&D: Experience in the 3 key roles in R&D: scientific researcher, research manager, and 'customer' for R&D products. After re-defining Shell's exploration R&D strategy, led the re-structuring of the R&D organization, its interface with 'the business' and approaches to deployment and commercialization. Strategy: Accomplished at formulating competitive strategies in business, R&D and technology deployment, translating them into actionable tactics and results. Defined the exploration strategy of PDO (a Shell subsidiary in Oman) and latterly of Shell's global exploration programme. Professional education, behavioural/motivational coaching: Experienced in organisational re-design, change management, leadership education and talent development. Commercial skills: Personally negotiated drilling compensation claims, educational contracts and E&P contracts, with values of $5 million to $100+ million. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

On this course we go into far greater detail on understanding the dog’s needs, behaviour, state of mind, language, and improving your leadership skills.

SketchUp Course With Layout and V-Ray

Why choose SketchUp Basic to Intermediate Training Course? Click for more info SketchUp offers a user-friendly experience with its intuitive interface, enabling beginners to start smoothly and professionals to work efficiently. The software provides straightforward tools and shortcuts, ensuring precise and speedy creation of 3D models. Duration: 5 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 SketchUp is a popular and robust CAD solution designed for engineers, designers, architects, and more. Its powerful suite of tools includes customizable palettes, lighting effects, animations, textures, and access to the Trimble 3D warehouse. SketchUp Basic Training Course. 1 on 1 Training. 5 hours Understanding the Basics of SketchUpIntroduction to SketchUpNavigating the SketchUp EnvironmentExploring Zoom, Pan, and Rotate FunctionsFamiliarizing Yourself with the XYZ Axis Mastering SketchUp ToolsEfficient Toolbar SelectionsUtilizing Templates for ProjectsDrawing with Precision Using the Pencil ToolWorking with Fundamental Geometric ShapesTaking Accurate Measurements Advanced SketchUp TechniquesCreating Circles and ArcsHarnessing Sticky Geometry SolutionsUnveiling the Power of Tags (Formerly Layers)Streamlining Workflow with Keyboard ShortcutsAccurate Object Measurement within SketchUpInformation Management and Database UsageMoving and Copying ObjectsSimple Array TechniquesMastering Rotational ManipulationsEffortless Rotational CopyingFractional and Relative Scaling Component and Group CreationConstructing Components for ReusabilityCreating Efficient GroupsComparing the Advantages of Components and GroupsSaving and Reusing ComponentsImporting Components from Digital Repositories Advanced Modeling and GeometryLeveraging Push-Pull OperationsCreating Complex Shapes with the Follow Me ToolExploring Geometry IntersectionsDuplicating and Offsetting Faces, Edges, and PolygonsIncorporating 2D Polygons into Your DrawingsSkillful Use of the Paint Bucket Tool Materials and TexturesProficiency with the Materials EditorApplying High-Quality TexturesSourcing and Positioning TexturesGraphics and Bitmap ConsiderationsCrafting Scenes and StylesGenerating and Customizing ScenesManaging Scenes and Styles Introduction to Animation and PresentationAnimation ConceptsAdding Dimensions to Your SketchUp ModelsAnnotating Designs for ClarityPreparing Models for PrintingExporting Images and PDFs in 2D Formats

This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: Ensure the integrity of their databases Manage field properties Use the query functions effectively Save time with the query expression builder Create different types of query more quickly Design better forms Link expressions in forms Create better and more useful reports Import and export tables more easily 1 Table relationship integrity Identifying relationships Identifying criteria for data integrity Applying referential integrity Managing relationship join types 2 Table field properties Field properties overview Using input mask field Using default value fields Using field validation rules 3 Query functions Running aggregate function calculations Running sum, average, count, max and min functions Grouping calculated data 4 Query calculations Using query operators and expressions Adding calculated fields to a query Using the query expression builder 5 Action queries Creating make table queries Creating append queries Creating update queries Creating delete queries 6 Designing forms Adding form controls Aligning and arranging form controls Adding pictures and labels to forms Adding new fields to a form Controlling tab order Adding command buttons Adding a combo box control Formatting data using conditional formatting 7 Form expressions (calculations) Using the form expression builder Working with a property sheet within a form Linking expressions within a form 8 Working with reports Creating reports with the report wizard Inserting report fields Formatting fields Inserting report headers and footers Working with a property sheet within a report 9 Grouped reports Creating groups with the report wizard Sorting grouped data Grouping alphabetically Grouping on date intervals Creating sub reports Adding calculations to groups 10 Importing and exporting tables Importing tables into Access Exporting tables from Access Importing and linking data in Access

This course presents an approach for dealing with security and privacy throughout the entire software development lifecycle. You will learn about vulnerabilities that undermine security, and how to identify and remediate them in your own projects.

Who is this course for? Landmark Training Course With Vectorworks. Dive into terrain modeling, planting, irrigation, and site analysis guided by certified tutors. Master these tools for precise landscape designs and effective documentation. Check our Website Enrollment : 1-on-1 Landmark Training. Tailor your schedule. Mon to Sat between 9 am and 7 pm Call 02077202581 to book your slot. Duration: 16 hours. "Split these hours over multiple days as needed for your ideal schedule." Approach: In-person or live online. Landmark Training Course with Vectorworks: Basic to Intermediate Level Course Duration: 16 Hours Embark on a transformative journey with our Landmark Training Course tailored for landscape architects and designers. Over 16 intensive hours, dive deep into Vectorworks Landmark, mastering fundamental and intermediate techniques crucial for comprehensive 2D and 3D landscape design. Craft intricate site analyses, plans, irrigation systems, and elevate your designs with mesmerizing 3D visualizations. Explore custom plant symbols, detailed planting plans, and learn the art of efficient collaboration and customization. Course Highlights: I. Introduction to Vectorworks Landmark (1 hour) Explore Vectorworks Landmark for landscape design Master interface, tool usage, and project management II. Site Analysis and Site Plans (3 hours) Craft detailed site analyses and hardscape designs Work with contours, elevations, and terrain models III. Planting Plans (5 hours) Utilize the plant database for region-specific plant selection Create personalized plant symbols and comprehensive planting plans IV. Irrigation Design (2 hours) Design and edit efficient irrigation systems and zones Integrate irrigation components into site plans V. 3D Visualization (3 hours) Create captivating 3D models with realistic textures and materials Enhance designs with advanced lighting and special effects VI. Customization (1 hour) Tailor the interface for efficient landscape design Create custom object styles and resource libraries VII. Collaboration and Sharing (1 hour) Seamlessly import/export data from other platforms Share designs effectively with colleagues and collaborators VIII. Conclusion and Next Steps (1 hour) Review course content comprehensively Receive guidance on further learning resources Engage in a Q&A session and provide valuable feedback Enhance your landscape design expertise and unleash your creativity. Enroll now in our Vectorworks Landmark Basic to Intermediate Training and transform your designs. Download Vectorworks Landmark By the end of the Vectorworks Landmark Training Course, participants will: Understand the key features and functionalities of Vectorworks Landmark for landscape design. Demonstrate proficiency in using essential tools for site analysis, site plans, and hardscape design. Create detailed planting plans, selecting appropriate plants, and understanding their compatibility and growth patterns. Design efficient and effective irrigation systems, including generating irrigation reports. Create 3D visualizations of landscape designs, applying textures, materials, lighting, and special effects. Customize the interface and create personalized object styles and resources. Collaborate and share landscape design drawings with other software users. Have the foundation to pursue further learning and exploration in landscape design using Vectorworks Landmark. Mastering Foundations Begin your project by organizing your files and importing survey data. Learn to sketch existing buildings using Building Shell tools and model neighboring structures with Massing Model. Explore different methods for laying out survey points and marking existing features with precision. Objectives: Review File Organization Techniques Import Survey Data (DWG Import) Create Building Structures with Building Shell Tools Utilize Triangulation and Arc Tool for Precision Master Various Tape Measurement Techniques Elevating Your Design Enhance your survey with detailed ground, existing trees, and fences. Conduct shadow analysis to optimize planting locations. Dive into the Vectorworks Plant tool, your key design companion. Objectives: Develop Detailed Ground Surfaces Incorporate Existing Trees and Fences Design with Railing Fence Tool Conduct Shadow Analysis using Heliodon Tool Utilize Plant Tool Modes for Plant Placement Access Existing Plant Libraries and Customize Plants in 2D/3D Crafting Landscapes Create vibrant plant mixes using Landscape Area tool and apply them across your site models. Design intricate hardscapes, aligning them effortlessly even in complex paving scenarios. Learn to use components for detailed reporting, cut and fill calculations, and precise detailing. Explore custom object creation and site furniture placement. Objectives: Design Landscape Areas and Define Custom Plant Mixes Create Hardscapes and Define Custom Paving Constructions Generate Reports and Tags for Landscape Areas and Hardscapes Access and Manage Objects in Resource Manager Craft Custom Objects and Site Furniture Polished Presentation Present your designs professionally using Sheet layers and viewports. Create Section viewports to cut through your model and Detail viewports to focus on specific areas. Enhance visual appeal with mood boards and annotations, ensuring a refined, detailed presentation. Objectives: Craft Sheet Layers for Presentation Create Plan, Elevation, and Perspective Viewports Generate Section and Detail Viewports Annotate Viewports for Clear Communication Incorporate Images and Plant Reports for Comprehensive Presentations Master Vectorworks Landmark: Gain expertise in essential and advanced 2D/3D landscape design tools for precision and efficiency. Boost Efficiency: Learn time-saving techniques and workflows tailored to Vectorworks Landmark, enhancing productivity. Versatile Landscape Skills: Develop proficiency in site analysis, planting plans, hardscapes, and irrigation systems for diverse projects. Industry-Ready Expertise: Acquire sought-after skills in landscape architecture, paving the way for career growth. Flexible Learning: Access recorded lessons for convenient review and receive lifetime email support for ongoing guidance.

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups

Personalized Revit Training: One-to-One Sessions with Pay-as-You-Go Flexibility

Who is this course for? SketchUp Basic Level Training Course. Click here for more info: Website Ideal for newcomers to 3D modeling, it suits students, hobbyists, and professionals. Gain a strong foundation in SketchUp, perfect for careers in architecture and interior design. Our flexible 1-on-1 sessions let you tailor your learning schedule. Schedule sessions Monday to Saturday, 9 am to 7 pm. The 5-hour course adapts to your timeline, ensuring a personalized, supportive, and adaptable learning experience. Course Title: SketchUp Basic Course. Course Duration: 5 hours Understanding the Basics of SketchUp Introduction to SketchUp Navigating the SketchUp Environment Exploring Zoom, Pan, and Rotate Functions Familiarizing Yourself with the XYZ Axis Mastering SketchUp Tools Efficient Toolbar Selections Utilizing Templates for Projects Drawing with Precision Using the Pencil Tool Working with Fundamental Geometric Shapes Taking Accurate Measurements Advanced SketchUp Techniques Creating Circles and Arcs Harnessing Sticky Geometry Solutions Unveiling the Power of Tags (Formerly Layers) Streamlining Workflow with Keyboard Shortcuts Accurate Object Measurement within SketchUp Information Management and Database Usage Moving and Copying Objects Simple Array Techniques Mastering Rotational Manipulations Effortless Rotational Copying Fractional and Relative Scaling Component and Group Creation Constructing Components for Reusability Creating Efficient Groups Comparing the Advantages of Components and Groups Saving and Reusing Components Importing Components from Digital Repositories Advanced Modeling and Geometry Leveraging Push-Pull Operations Creating Complex Shapes with the Follow Me Tool Exploring Geometry Intersections Duplicating and Offsetting Faces, Edges, and Polygons Incorporating 2D Polygons into Your Drawings Skillful Use of the Paint Bucket Tool Materials and Textures Proficiency with the Materials Editor Applying High-Quality Textures Sourcing and Positioning Textures Graphics and Bitmap Considerations Crafting Scenes and Styles Generating and Customizing Scenes Managing Scenes and Styles Introduction to Animation and Presentation Animation Concepts Adding Dimensions to Your SketchUp Models Annotating Designs for Clarity Preparing Models for Printing Exporting Images and PDFs in 2D Formats This comprehensive SketchUp Fundamentals course will equip you with essential skills to create, modify, and present 3D models effectively. After completing our 5-hour SketchUp training, you'll achieve the following learning outcomes: Basic SketchUp Proficiency: Gain essential skills to navigate the SketchUp interface and utilize its core features effectively. Geometry Creation: Learn to create 2D and 3D geometric shapes, lines, and curves with precision. Rendering Concepts: Understand the fundamentals of rendering and how to apply basic rendering techniques to enhance your designs. Model Organization: Discover techniques for organizing and structuring your SketchUp models efficiently. Visualization Skills: Develop the ability to visualize and plan architectural and interior design concepts in 3D. Efficient Workflows: Acquire time-saving tips and tricks for streamlining your design workflow. Personal Projects: Apply your newfound skills to your personal design projects or professional endeavors. By the end of this short training, you'll have a solid foundation in SketchUp, allowing you to create and present basic 3D models and designs effectively. After SketchUp Training, You'll Acquire: Advanced 3D Modeling: Master the art of creating intricate 3D models, architectural designs, and detailed structures using SketchUp. Texture Mapping and Material Application: Learn to apply realistic textures and materials, enhancing the visual appeal of your 3D creations. Rendering Techniques: Explore rendering plugins like V-Ray or Twilight Render to create lifelike visualizations of your designs. Collaboration and Presentation: Develop skills to effectively collaborate with teams and present your ideas in professional and compelling ways. Project Visualization: Enhance your ability to transform conceptual ideas into visually stunning and detailed 3D representations. Job Opportunities: Architectural Designer: Create detailed architectural models for residential and commercial projects. Interior Designer: Design interior spaces, visualizing furniture placements, colors, and decor elements. Landscape Architect: Develop 3D landscape designs, showcasing outdoor spaces and environmental elements. 3D Modeler: Work in various industries, creating 3D models for animations, games, or simulations. Visualization Specialist: Provide visualization services to real estate agencies, design firms, or marketing companies, transforming ideas into compelling visuals. Why Choose Us? Tailored One-on-One Training: Exclusive coaching from skilled architects and designers, in-person or live online, Monday to Saturday. Customized Tutorials: Enhance your skills with tailored video tutorials to take home. Comprehensive Learning: Receive digital resources for thorough understanding and revision. Free Ongoing Support: Enjoy continuous assistance via phone or email, ensuring your success beyond the course. Flexible Syllabus: Adapted to your needs for focused learning. Official Certificate: Validate your expertise with our prestigious certification.