1636 Database courses in Ware 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

Delivered in Horsham or OnlineFlexible Dates

Price on Enquiry

FULL STACK JAVA

By London School of Emerging Technology

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

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

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

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

1...162 163 164

Educators matching "Database"

Show all 8

tigerfitness uk

Hitchin

Home | TigerFitnessUK Tiger fitness UK features the largest online database of quality training programs for every goal.

Message

fleet source

Hertfordshire

We are eager to expand our portfolio of enthusiastic and experienced trainers to deliver our industry-leading courses. If you think this could be you, contact us today to find out about our available opportunities.

Message

cache

4.3(18)

St Albans

We’re NCFE: an educational charity and leader in vocational and technical learning. We combine over 170 years of education experience with deep insight, working with a network of expert collaborators to shape smarter solutions around the greatest learning needs. In doing this, we’re working for a fairer education system for all learners to power inclusivity and choice.

Message

role group ltd

3.9(11)

London

Established in 2016, Role Group was conceptualised by David McHugh, Managing Director, as an outcome of his extensive experience and ability to identify the requirement for skilled, reliable and experienced operatives in the construction, civils and rail industries. The Role Group team are diligent in sourcing skilled and reliable trades and labour. Our current database consists of highly skilled operatives who have been assessed via our stringent vetting processes. The skills held by our operatives are reviewed on a regular basis with training offered to those who require renewals or upskilling via our in-house training company, Role Training Ltd. As a result of our synergetic recruitment and compliance strategies, we have the ability to provide clients with multi-skilled and flexible operatives at relatively short notice. As a team of experienced recruiters, Role Group have a vast number of years’ experience under their belts. Our team are familiar with the regulations and compliance requirements that are a part of every construction project in the UK. On previous projects, we have built strong relationships with a variety of skilled tradespeople and are seen as a valued and reliable supplier within the sector. Our team has collectively transformed our expertise and knowledge into a respectable and dependable recruitment firm. We have collaborated with our clients on some of the most high-profile projects in the UK. We have provided trades and labour, as well as logistical staff, to projects such as the Southall Waterside, Imperial College London, Highbury Corner Tunnels, Waterloo Platform Extension and the AMP 6 Framework. We are currently preparing our workforce to participate in the new AMP 7 Framework which will see Role Group provide trades and labour, logistical staff, confined spaces operatives and specialised utilities teams. AIMS FOR THE FUTURE: We are working to expand our workforce whilst maintaining our current quality of skilled trades and labour as we have the ability to upskill our operatives, in house, at no extra cost to our clients. Our new training centre will be supported by an innovative booking system, that will allow our operatives to easily book the training or renewals that they require. We are currently implementing a plan to expand our order book significantly by 2022 and aim to open a Role Group and Training satellite office at a new location within the UK.

Message

enfield county school for girls

London

Welcome to Enfield County School for Girls, a vibrant and exciting place to learn with a strong sense of purpose and achievement I am very proud to be the Headteacher of this school and to work in such a culturally diverse school community. Enfield County School for Girls values of: Respect, Responsibility, Equality of Opportunity, Cooperation and Generosity of Spirit permeate and guide the work of our school and we look forward to welcoming and working in partnership with you. We work to provide a daily learning experience which educates and empowers each student to recognise and grow her gifts and talents to become the very best version of herself and become a leader of tomorrow and our school motto of “Onward Ever” encapsulates this perfectly.

Message

waterworld sports ltd

Borehamwood

Scuba-Diving | Snorkelling | Swimming | Watersports – waterworldsports.co.uk PADI & SSI scuba diving school & stockists of big brand scuba, snorkel, paddleboard, swim & watersports gear. ScubaPro, Mares, Cressi, TUSA, Fourth Element + more. Based in Borehamwood, covering London & Hertfordshire. Why choose us? Waterworld Sports is a friendly scuba diving, snorkelling, paddleboarding, swim and watersports shop based in the north London and southern Hertfordshire area. We are also a qualified SSI & PADI scuba school (incorporating Borehamwood Scuba) and a one-stop-shop providing our customers with scuba diving classes and all the necessary equipment. For more expensive equipment purchases we offer Finance via Klarna or PayPal Pay-in-3 [https://www.waterworldsports.co.uk/pages/pay-with-klarna-finance] so that you can pay in smaller chunks. We can get any item from any of the brands on our website as we deal direct with the brand owner in question. Please email us if you need something that isn't displayed on our website and we will promptly find out from our supplier regarding availability and pricing. Any product that says: In Stock At Our Suppliers Warehouse Please Allow 1 Extra Day is definitely in stock as we are linked to our supplier's stock-database. It will arrive with us the following day (if you have made your order by 2pm) ready to be dispatched to you. Clear, transparent, and always here to help, we look forward to serving you!🤙

Message

oasis academy enfield

Enfield

Everything within Oasis Community Learning is framed by our ethos. Our ethos is rooted in what we believe and who we are. Grounded in our story, it is an expression of our character; a set of values that inform and provide the lens on everything we do. A passion to include A desire to treat people equally respecting differences A commitment to healthy, open relationships A deep sense of hope that things can change and be transformed A sense of perseverance to keep going for the long haul It is these ethos values that we want to be known for and to live by. We are committed to a model of inclusion, equality, healthy relationships, hope, and perseverance throughout all the aspects of the life and culture of every Oasis Hub and academy community. We encourage every member of our family, be that staff or student, to align themselves to these ethos values. The values themselves are inspired by the life, message and example of Jesus but we make it clear that we will not impose on anyone, the beliefs that underpin our ethos values. We recognise and celebrate the richness that spiritual and cultural diversity brings to our community, respecting the beliefs and practices of other faiths in the hope that we will provide a welcoming environment for all. The Oasis 9 Habits The Oasis Ethos is aspirational, inspirational and something that we have to constantly work at. It is important to remember that every organisation is made up of its people, and people don’t always get things right. This means that there can sometimes be a dissonance between what we say we are, as stated in our ethos values, and what we actually do and experience. Recognising this is helpful because it reminds us that we each have things to work on; we have space to grow, develop and change to become the best version of ourselves. To help us in this process of personal growth and development we have the Oasis 9 Habits. It is our bespoke and unique approach to character development. We know that by living the way of the Habits, the Oasis Ethos will become second nature to us. We also believe that this process of continually developing our character and being transformed to become the best version of ourselves is really important for every student and staff member alike. Therefore, we actively promote and practice the Oasis 9 Habits which are an invitation to a way of life characterised by being compassionate, patient, humble, joyful, honest, hopeful, considerate, forgiving and self-controlled. We believe that by becoming people who live this way, by becoming the best version of ourselves, whether we are a staff member or students, we are transformed, and we are also able to play our part in bringing transformation locally, nationally and globally.

Message

futuretrend

Enfield

Futuretrend has been providing IT, Design, Financial and Business Skills training since December 2000. With a solid reputation for delivering high quality programmes, Futuretrend has become a successful and well established training centre. Year on year hundreds of learners come to this centre to pursue a course of study that will help them fulfill career aspirations, improve their job prospects or to simply learn more about a particular area of interest. In today's competitive business environment the importance of up-to-date skills cannot be overstated. With Futuretrend, you and/or your team will benefit immensely from our results-oriented training. Our instructors are professionals who work full-time in the industry and bring their working knowledge to the classroom to enhance your learning experience. Our courses are centred on learning by doing, ensuring that learning retention rates are high and that delegates are able to confidently apply their new found skills in the workplace or successfully in an exam situation, demonstrating an immediate return on investment. A prerequisite for any Futuretrend trainer is that they must practise the skills they teach. It is essential that they are able to draw from real world experiences to illustrate subject matter, thereby enabling delegates to envisage how best to use software and concepts effectively. This is based on the following ethos: “Tell me and I’ll forget. Teach me and I’ll remember. Involve me and I’ll learn.” We are often asked how we have made a success from a company which was seemingly produced from nothing but which has now become one of the most dynamic organisations within the industry. The answers are simple; Speed - We have built a good reputation around the fact that we do not keep our clients waiting for answers to their requirements. If we tell you we shall call back the same day then we absolutely mean it. Itâ€™s more likely that we will get back to you on the spot. Quality - One attribute is nothing without the other. All Futuretrend's staff and associated freelancers have major industry experience and are amongst the best and highest qualified in their sphere of activity in the UK; and why not? Our reputation depends on them. Personal touch - Whilst maintaining the air and professionalism of a larger company you will always know who you are dealing with when you dial through to our offices. We give our individual time to each of our clients and as such you are guaranteed a friendly and personal reception. These are only three of the numerous reasons as to why so many individuals and organisations in and around the UK are choosing to trust their training to Futuretrend. Our success depends entirely on our client's satisfaction and this is mirrored in our everyday approach to your requests. We don't expect to stay at the forefront of our competitors without maintaining sharp minds and a fresh attitude. Another typical question asked is how can we offer our courses at such low prices ? Here is why; Futuretrend has never taken out costly traditional advertising which would lead to unnecessary expenditure and thus forcing prices up. We have built our success mainly on very good "word of mouth" and relatively inexpensive online marketing. As such we are in the lucky position of being able to do away with the myth that business can only be generated through glossy brochures. Additionally, we are not passing on the premiums charged for West End and City training venues. Most of these will still not be as modern or well-equipped as our newly refurbished classrooms. Our premises are within an Elegant Victorian North London building. You could easily be paying double the amount and more attending a similar course elsewhere and probably not even half the quality. We hope our web site will give you a taste of the quality of study available at Futuretrend and make your decision to study with us a little easier. We all learn best when we are happy and valued so let us help advance your skills and enhance your potential.

Show all 8