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

spun glass theatre

Brighton

Spun Glass Theatre is an award-winning theatre production company based in Hastings, East Sussex, founded by Jessica Cheetham. Spun Glass Theatre blend groundbreaking theatre making with excellent community engagement. We're a young, dynamic company creating bold, visual theatre productions for all ages with experience in traditional theatres, schools, community settings and developing early years activities. Each project is built from the ground up with its intended audience, ensuring that the end result is delightful, entertaining and meaningful.

Message

st. john's college (brighton)

3.5(41)

Brighton

St. John’s is a non-maintained specialist School and College, working with autistic people, the majority of whom also have learning disabilities. Some of our learners also have conditions such as epilepsy, hearing or visual impairments, or mental health needs. We also support autistic learners who have an additional profile of pathological demand avoidance syndrome. Each learner’s curriculum is shaped by their individual strengths, interests, and challenges. St. John’s is awarded with Autism Accreditation by the National Autistic Society (NAS). We support our learners to develop their skills in the NAS’s four focus areas of: Difference in social communication and interaction Self-reliance and problem-solving Sensory Emotional well-being St. John’s has an outstanding training package which ensures our learners are supported by a highly skilled staff team who respect their choices and lifestyle. We have high expectations for our learners, helping them to achieve success in their future lives.

Message

bipc sussex

Brighton

Have a great business idea, but unsure how to develop it? Or have a business which needs help to grow? We're here for you, whether you need to discuss those first business steps, need to understand patent searching or find the latest market trends. The Business & IP Centre can support you via our regular information, IP and expert 121s, workshops and events.

Message

the art house

4.6(615)

Eastbourne

The Art House provides time, space and support for artists, makers and creative businesses to develop their practice. It is a place where artists and audiences of all kinds are welcome to engage with the creative process through a year-round programme of exhibitions and events.

Message

the uk district energy association (ukdea)

Wivelsfield Green

We are the Knowledge Hub and Voice for the UK’s District Energy Sector. With over 140 Members, we are the largest voice for District Energy in the UK. Here on our website, you can learn all about us and our initiatives, as well as what we can offer you as a UKDEA Member. Take a look at our Member Directory, which houses information on all of our Full and Associate Members. UKDEA Members are also able to post their Job Vacancies on the UKDEA Website free of charge. Another benefit to UKDEA Members is our Training, Register. This document contains details of all the Training Courses that are offered by our Members. With over 25 UKDEA Members included in this document, this is an invaluable resource that is publically available. Be sure to also take a look at our Events Calendar, which contains details of all of our upcoming/past online and in-person events. UKDEA Members have access to the exclusive Document Library. This database contains hundreds of useful documents, such as: All past UKDEA Journals UKDEA Event Presentations Hard to find BEIS Documents (Consultations & UKDEA Responses, GHNF, Useful Regulations, Model Form Contracts, Heat Network Publications, Heat Metering and Billing Regulations) GLA Documents + Many more to be added in the future…

Message

brighton chamber

Brighton

Brighton Chamber has lots of brilliant events on offer each month. Events are at the heart of Brighton Chamber. Our varied programme offers first-class opportunities for connecting and learning both in-person (when it’s safe to do so again) and at the moment - virtually. We offer Learning, networking and topical events.

Message

the community kitchen

0.0(7)

Brighton

The Food Partnership was started by local residents in 2003, and our committed team of staff & volunteers deliver a range of food projects which have helped over 15,000 local people learn to cook, grow their own food, eat a healthier diet and waste less. Eating is central to life’s celebrations and memories, and our approach is to use this power of food to bring about change. Much of our work benefits vulnerable adults and people experiencing deprivation, isolation, poor health and other life challenges. Our activities makes lasting changes to habits and behaviours which improve lives. We’re a not-for-profit organisation and we work with a wide range of partners including community organisations, statutory agencies, local businesses and individual residents. Our work has been recognised by independent bodies – most recently awarded ‘Non profit of the year’ 2019 at the Brighton & Hove Business Awards, ‘Team of the Year’ at the Cost Sector Catering Awards 2019 and the ‘Community Benefit Award’ at the 2019 Southeast RICS awards for the build project to create the Community Kitchen. We led Brighton & Hove’s successful submission for ‘Gold Sustainable Food City’ status. We hold the PQASSO Level 2 quality mark, and are proud to be a Living Wage employer. The Food Partnership is grateful to its current funders for supporting this work: the Big Lottery Fund, the Esmee Fairbairn Foundation, the Fonthill Foundation, Sussex Community Foundation, Brighton & Hove CCG and Brighton & Hove City Council.

Message

hollingbury learning centre

Brighton

- for families with disabled children and young people in Sussex

Message

for legal

Brighton

For Media Group is an on-demand video platform designed for professionals across a range of sectors. We produce webinars on a monthly basis that cover an array of topics relevant to our audience. We simplify the way online learning is delivered by providing a trusted choice of videos and resources that are accessible anytime, anywhere. An online learning platform trusted by professionals. For Media Group was established in 2021 by an experienced team who share a passion for technology-enhanced education via exceptional digital content. Our platform connects professionals and enables learning to be more accessible, efficient, flexible and impactful. The way we work, learn and connect is changing. By working alongside industry experts and embracing innovation, we are focused on providing high-quality professional development and best practice production. We are constantly looking to ensure a seamless and tailored experience for our community to learn and enhance their knowledge, develop future-ready skills and grow their careers. Get Inspired. Discover a new way of learning. We believe learning should be inclusive which is why we provide a choice of flexible subscription plans and are constantly innovating to ensure we are utilising the latest technologies. Our platform is always available so you can learn at a time and place that suits you. Your learning, your way.

Message

liz lilley

Brighton

Liz is passionate about supporting and empowering people to move through areas of restriction in their lives. When we are recognised, witnessed, and understood as individuals, in a safe, non-judgemental space, we can integrate all the strengths and vulnerabilities we encompass. Experiencing a compassionate relationship is a foundation to be able to identify, feel and heal the challenges you face, be the best version of yourself, whatever that may look like, and thrive. Liz Lilley is a Humanistic Psychotherapist, Massage Therapist and Breathwork Facilitator. She also provides Psychedelic-Assisted Therapy on Clinical Trials using psilocybin in the UK, integrating her professional experience from all her passions into her therapeutic practice. After many years of working with the body and witnessing the somatic release of trauma Liz went on to study psychotherapy in order to bring her knowledge of the mind-body in line with her experiences. She has supported thousands of people through bodywork and counselling yet felt there was a missing piece of the puzzle to her offerings. Then she discovered simple and powerful breathwork techniques, had some deeply profound personal experiences and went on to become a trained Breathwork Facilitator, completing the puzzle. Liz now holds group and one-to-one sessions online and in-person combining these practices to enhance the healing potential of unifying Body, Mind and Breath. Liz has an ongoing interest in expanded states including breathwork, meditation, psychedelics and shamanic journeying as tools and openings that enhance self-awareness, creativity, connection and therapeutic release. Her experiences in these practices have informed her focus on the integration of her client’s exploration into the Body, Mind and Breath. She believes that with focus, intention and integration we can prolong the benefits of the work we do on ourselves. Liz has held sharing circles, worked in young people’s mental health and with refugees and has supported people who have experienced domestic abuse and homelessness. Liz developed a special interest in working as a Psychedelic-Integration Psychotherapist and is on the Advisory Board and is the Project Lead for Growthful Networks, the community area for the Institute of Psychedelic Therapy as well as a registered practitioner on their database. She has also faciltated breathwork sessions for the therapists training for the DMT for Depression clinical trial and provides Psychedelic-Assisted Therapy on clinical trial research for psilocybin for mental health conditions.

Message

Show all 11