103 Database courses in London

CSCS is the leading Construction Skills Certification Scheme within the UK construction industry to ensure safety standards are high and maintained within the construction industry in the UK. CSCS cards provide proof that individuals working on construction sites have the required training in Construction Health and Safety awareness for the type of work they carry out.

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing

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