• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

1636 Database courses in Maidenhead delivered Online

Excel Power Query and Power Pivot

By Underscore Group

Learn how to work with and connect multiple data sets to effectively analyse and report on data. Course overview Duration: 1 day (6.5 hours) Within Excel you have some powerful features to enable you to connect and analyse multiple data sources. Power Query enables you to import and manipulate your data, Power Pivot enables you to connect multiple data sources and create pivot tables and pivot charts from them. This course is an introduction to Power Query and Power Pivot in Excel to get you started on creating a powerful reporting capability. Knowledge of working with Excel workbooks and relational databases would be an advantage. Objectives By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Add extra columns of data Append data Merge data from other tables Create data models Build data relationships Build Pivot Tables Build Pivot Charts Use Slicers and Timeline Filters Content Importing data Data sources Importing data Transforming data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Appending queries Appending data from other tables Adding text Columns from example Custom columns Conditional columns Merge queries Setting up and using merge queries Merging in columns of data Creating a data model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Analysing information using pivot tables Creating and modifying a Pivot Table Recalculating the Pivot Table Filtering the Pivot Table Searching the Pivot Table Drilling down to underlying data Customising field names Changing field formatting Pivot charts, slices and timelines Creating Pivot Charts Adding and using Slicers

Excel Power Query and Power Pivot
Delivered in Horsham or OnlineFlexible Dates
Price on Enquiry

Full Stack Development encompasses the complete creation of end-to-end development of both the front-end and back-end of an application. LSET Bridges The Gap Between Education And Employment

FULL STACK JAVA
Delivered in Internationally or OnlineFlexible Dates
Price on Enquiry

Developing on Hyperledger Fabric 1.4

By Nexus Human

Duration 2 Days 12 CPD hours Overview Understand why Blockchain is needed and where Explore the major components of BlockchainLearn about Hyperledger Fabric and the structure of the Hyperledger ArchitectureLean the features of the Fabric model including chaincode, SDKs, Ledger, Security and Membership ServicesPerform comprehensive labs on writing chaincodeExplore the architecture of Hyperledger FabricUnderstand and perform in depth labs on Bootstrapping the NetworkPerform comprehensive labs to integrate/develop an application with Hyperledger Fabric running a smart contractBuild applications on Hyperledger FabricCourse Outline: This training course has been created to walk you through Chaincode Development, Testing, and Deployment for a Hyperledger Fabric Network catering specifically toward Golang written Chaincode (Fabric?s original Chaincode Language). Additionally as an Application Developer you will learn how to write, and prepare Client Applications using the most mature Standard Development Kit in Hyperledger Fabric, NodeJS. Blockchain Basics (Overview)Hyperledger Fabric Development EnvironmentKnowing the Difference: ComposerChaincode Use CasesChaincode BasicsGolang Shim DevelopmentDatabases for the DeveloperChaincode Dev. Deployment and InteractionsClients & SDK Development: Fabric-NetworkClients & SDK Development: Fabric-Client InteractionsLogging and Monitoring

Developing on Hyperledger Fabric 1.4
Delivered OnlineFlexible Dates
Price on Enquiry

R12.x Extend Oracle Applications - OA Framework Personalizations

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for Application Developers Business Analysts Developer End Users Functional Implementer Java Developer System Analysts Technical Administrator Overview Create administrator-level personalizations Personalize configurable pages Utilize advanced personalization features Implement flexfields on OA Framework-based pages Create custom look and feel definitions Create user-level personalizations This course will be applicable for customers who have implemented Oracle E-Business Suite Release 12 or Oracle E-Business Suite 12.1. This course will be applicable for customers who have implemented Oracle E-Business Suite Release 12 or Oracle E-Business Suite 12.1.

R12.x Extend Oracle Applications - OA Framework Personalizations
Delivered OnlineFlexible Dates
Price on Enquiry

Oracle Solaris 11 System Administration

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for The course provides an intensive hands-on experience for key system administration tasks with the goal of making the system administrator job-ready. Overview Administer the Oracle Solaris 11 Host on an Existing Network Administer Oracle Solaris Zones Control Access to Systems and Files Install Oracle Solaris 11 Operating System Administer User Accounts Administer System Processes and Schedule System Tasks Manage Data by Using ZFS Manage Boot and Shutdown of a System Administer Services by Using SMF Administer Software Packages by Using IPS and Manage Boot Environments Describe the use of IPS in packaging the Oracle Solaris OS Manage boot environments Updating the OS by using IPS The Oracle Solaris 11 System Administration training covers the full range of introductory system administration tasks on Oracle Solaris 11.3 OS. The topics covered range from installing the operating system on a single system, to monitoring and basic troubleshooting. The Oracle Solaris 11 System Administration course is designed to provide new system administrators, as well as enterprise system administrators who are new to the Oracle Solaris 11 Operating System, with the skills they need to perform their job tasks successfully and efficiently. Installing Oracle Solaris 11 Operating System Introduction to Oracle Solaris 11 OS Planning for Oracle Solaris 11 OS installation Installing Oracle Solaris 11 OS by Using the Live Media Installer Installing Oracle Solaris 11 OS Using the Text Installer Verifying the OS Installation Managing Boot and Shutdown of Systems Analyze the boot design and boot process Boot a SPARC-based system Boot an x86-based system Shut down a system Administering Services by Using SMF Describing SMF and its components Administering SMF Services Administering Software Packages by Using IPS and Managing Boot Environments Describing IPS, its components, and interfaces Configuring an IPS Client to Access the Local IPS Repository Managing Package Publishers Managing Software Packages Managing Signed Packages and Package Properties Describe the use of IPS in packaging the Oracle Solaris OS Manage boot environments Updating the OS by using IPS Managing Data by Using ZFS Introducing ZFS Administering ZFS Storage Pools Administering ZFS File Systems Administering ZFS Properties Administering ZFS Snapshots and Clones Administering the Network Reviewing Networking Fundamentals Administering Datalink Configuration Administering a Network Interface Administering Profile-Based Network Configuration Configuring a Virtual Network Verifying the Network Operations Managing Resources on the Virtual Network Administering Oracle Solaris Zones Introducing Oracle Solaris Zones Configuring an Oracle Solaris Zone Determining an Oracle Solaris Zone Configuration Controlling Access to Systems and Files Controlling Access to Systems Controlling Access to Files Securing Access to Remote Host Administering User Accounts Getting Started with the User Administration Setting Up User Accounts Maintaining User Accounts Configuring User Disk Quotas Managing System Processes and System Tasks Managing System Processes Scheduling System Administration Tasks

Oracle Solaris 11 System Administration
Delivered OnlineFlexible Dates
Price on Enquiry

Building Data Analytics Solutions Using Amazon Redshift

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for This course is intended for data warehouse engineers, data platform engineers, and architects and operators who build and manage data analytics pipelines. Completed either AWS Technical Essentials or Architecting on AWS Completed Building Data Lakes on AWS Overview In this course, you will learn to: Compare the features and benefits of data warehouses, data lakes, and modern data architectures Design and implement a data warehouse analytics solution Identify and apply appropriate techniques, including compression, to optimize data storage Select and deploy appropriate options to ingest, transform, and store data Choose the appropriate instance and node types, clusters, auto scaling, and network topology for a particular business use case Understand how data storage and processing affect the analysis and visualization mechanisms needed to gain actionable business insights Secure data at rest and in transit Monitor analytics workloads to identify and remediate problems Apply cost management best practices In this course, you will build a data analytics solution using Amazon Redshift, a cloud data warehouse service. The course focuses on the data collection, ingestion, cataloging, storage, and processing components of the analytics pipeline. You will learn to integrate Amazon Redshift with a data lake to support both analytics and machine learning workloads. You will also learn to apply security, performance, and cost management best practices to the operation of Amazon Redshift. Module A: Overview of Data Analytics and the Data Pipeline Data analytics use cases Using the data pipeline for analytics Module 1: Using Amazon Redshift in the Data Analytics Pipeline Why Amazon Redshift for data warehousing? Overview of Amazon Redshift Module 2: Introduction to Amazon Redshift Amazon Redshift architecture Interactive Demo 1: Touring the Amazon Redshift console Amazon Redshift features Practice Lab 1: Load and query data in an Amazon Redshift cluster Module 3: Ingestion and Storage Ingestion Interactive Demo 2: Connecting your Amazon Redshift cluster using a Jupyter notebook with Data API Data distribution and storage Interactive Demo 3: Analyzing semi-structured data using the SUPER data type Querying data in Amazon Redshift Practice Lab 2: Data analytics using Amazon Redshift Spectrum Module 4: Processing and Optimizing Data Data transformation Advanced querying Practice Lab 3: Data transformation and querying in Amazon Redshift Resource management Interactive Demo 4: Applying mixed workload management on Amazon Redshift Automation and optimization Interactive demo 5: Amazon Redshift cluster resizing from the dc2.large to ra3.xlplus cluster Module 5: Security and Monitoring of Amazon Redshift Clusters Securing the Amazon Redshift cluster Monitoring and troubleshooting Amazon Redshift clusters Module 6: Designing Data Warehouse Analytics Solutions Data warehouse use case review Activity: Designing a data warehouse analytics workflow Module B: Developing Modern Data Architectures on AWS Modern data architectures

Building Data Analytics Solutions Using Amazon Redshift
Delivered OnlineFlexible Dates
Price on Enquiry

Educators matching "Database"

Show all 11
Ptr

ptr

4.7(28)

Wokingham

Putting the success of your business at the heart of ours It’s our winning formula. For over 30 years we have been working with businesses just like yours to ensure their IT, and their knowledge to use it, are ready to deliver the success they deserve. We are proud of our heritage and the fact that so much of our business is built on repeat business from satisfied customers. info@ptr.co.uk 0118 979 4000 Here are some of the reasons why they keep coming back: Knowledge & Expertise Our team of consultants and instructors are expert in their fields. And with decades of experience they understand how your business can use their knowledge to achieve its goals. Simply put, we apply our knowledge to ensure your success. The Personal Touch PTR is a family business - and we see our customers as part of our extended family. We know every business is different. So, we won’t just tell you what to do and then leave you to it. We commit time and expertise to really understand your business and the problems that are unique to it. And then, we stick around to make sure you’re on track to reach your business goals. The Right Tools Whilst we are an enthusiastic Microsoft Gold Data Platform and Data Analytics Partner, we think it’s more important that you get the right, vendor-independent, solutions in place to meet your own, individual, needs. So, whether its consultancy or training that you need you can be sure of our balanced, impartial advice and guidance at all times. Whatever your need, we can tailor the solution for a perfect fit.

The Museum of English Rural Life (The MERL)

the museum of english rural life (the merl)

4.6(146)

Reading

The Museum of English Rural Life is owned and managed by the University of Reading. We use our diverse and surprising collection to explore how the skills and experiences of farmers and craftspeople, past and present, can help shape our lives now and into the future. We work alongside rural people, local communities and specialist researchers to create displays and activities that engage with important debates about the future of food and the ongoing relevance of the countryside to all our lives. We were established by academics in the Department of Agriculture in 1951 to capture and record the rapidly changing countryside following World War II. The Museum is based on Redlands Road in a building originally designed by Sir Alfred Waterhouse in 1880 for local businessman Alfred Palmer, of the Huntley & Palmer biscuit company. The house then became St Andrews Hall of Residence in 1911, and in 2005 a modern extension was built onto the house for the Museum. The Museum was awarded £1.8million from the Heritage Lottery Fund (HLF) in 2014 for the redevelopment of the galleries, reopening in October 2016. The redevelopment strengthens and renews our links with agriculture as well as enhancing our position in supporting engagement opportunities for students and academics across a wide variety of disciplines, nationally and internationally. The MERL and Reading Museum are currently in a strategic partnership as part of the Arts Council England National Portfolio 2018-2022. As Museums Partnership Reading we work together to provide cultural opportunities for Reading’s young people and diverse communities, through schools, volunteering, digital engagement and exhibitions. PLANS AND POLICIES

Bm Trada

bm trada

High Wycombe

BM TRADA has a long history and heritage that we are justifiably proud of and we can trace our origins back over 80 years to 1934. We are a global testing, inspection and certification company that delivers critical services in materials testing, product qualification testing, inspection and certification to the Fire and Building Products marketplace, where failure in service is simply not an option. Everything BM TRADA does is designed to help our customers to develop better products and processes; get their products to market on time; save time and money; and minimize the risk associated with product and process development as well as product production. Our purpose as a business is a simple one. To help our customers to make certain that all of the materials, products and processes we test, inspect and certify for them, regardless of the industry sectors they operate in, are always safe in their end application; are of marketable quality; are compliant with all relevant standards and industry regulations; and are ultimately fit for purpose. In 1934, a forerunner of what later became the Timber Research and Development Association (TRADA) was set up, its mission, to promote the use of wood in construction in the face of a growth in the use of alternative materials. 60 years later in the mid 1990s and following a management buyout of TRADA’s operating companies, the testing, inspection and certification services were grouped together under the three brands, BM TRADA Certification, Chiltern International Fire and TRADA Technology.

Apply4graduation

apply4graduation

London

aiHitdata - a brief introduction aiHitdata is a unique source of company information. It stores and continually updates huge amounts of company data. Much of this data is unique, it will not be found in any other database available on the Internet. Below we briefly answer all the hows and whys, so that you could understand the power of aiHit and how it might help you. What is aiHitdata? aiHitdata is a massive, artificial intelligence/machine learning, automated system that has been trained to build and update company information from the web. What makes the data different? aiHitdata not only extracts data. It can monitor and understand the changes that occur on company websites; afterwards, it records these changes as time series transactions. This information is incredibly powerful. What are the benefits? Most company information databases might tell you the name of a company’s CEO. aiHitdata will tell you when the CEO changed and show the resulting transaction, date and change details. Most query engines and company databases simply tell you what a company currently says on its website. aiHitdata shows you how the company has changed over time. Most company databases quickly become out of date. aiHitdata is constantly being updated. This enables you to understand what is happening to companies and to perform queries such as… “show me all the engineering companies in California with a new CTO appointed in the last 9 months.” Hence, you can find and list companies by what they are and see what is happening to them. This makes aiHitdata an extremely powerful tool. Click here to see an example What else is different about aiHitdata? It is up to date, and we mean really up to date. There are no humans involved in compiling its data. It is all fully automated. aiHitdata’s servers scour the Internet continually, 24/7, monitoring and updating company data.