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

the ark

5.0(1)

Wigan

Jnee is an advanced Programmatic Job Advertising platform, helping employers find their ideal candidates and job seekers the suitable job opportunities they are looking for. Jnee has millions of job openings in its database from the world’s top organizations.

Message

think tank academy

0.0(2)

Ormskirk

As our team themselves have grown organically through Social Services, Education and Health sectors, there is a shared passion with providers in understanding their needs, their strengths, challenges and threats so that we create access opportunities where together, we raise the bar. Professional, Respect, Integrity, Development & Equality are the core characteristics that all care workers should have to give them a baseline to grow. For us, Social Care will no longer be an under resourced and undervalued relative of Health Care, but rather a career of choice. We view our role as supporting the career development for all care workers, creating innovative learning platforms, providing access to conference and events to connect the sector and to provide empowerment opportunities to support development.

Message

corinth business and community training

Manchester

Corinth starts the new term with a range of exciting 8 session courses from w/c 16 Jan '23. The courses will be delivered from various venues across Salford. Some courses will also be available to join online. For further information/to enrol, please contact us on the details below. Free community courses include a range of First and Next Steps levels in; Initial IT training, Microsoft Office, Photoshop (First Steps and Advanced options), English, Math, Spreadsheets and Databases, Office Work and Admin Skills, Reading, Writing and Speaking English, The History and Stories of Salford and Manchester. ...and First Steps levels in HTML, JavaScript and CSS for Web Design, Confidence Building, Building Your Skills, Getting to Grips with your Camera, Planting Seeds, Saving Bees, Learning IT, (4 week mini course), Craft & IT, App Design and Building, and Teaching Adults The courses are perfect for improving your skills and opportunities, building your confidence, meeting new people and making new friends. Please note that our courses are not qualification courses. So whether it be that you would like to learn new skills in IT, use fractions and percentages in math, build a web site, learn how to use Excel, create a database, learn how to use Photoshop to edit your photos, learn about mail merge, how to improve your online presence using # (hash tags), improve your health and well-being through positive thinking, or would like to just know a little bit more, then please feel free to contact us on 07482 606808 , 07882 092231 or email us: info@corinth-training.com

Message

st edward's college

Liverpool

St Edward’s College offers an inspiring and challenging Catholic education to over 1200 children from across the City and further afield. An explicitly Catholic culture prioritises serving God through serving one another in community, demonstrating commitment, caring for others and striving for success.

Message

keys training

Preston

Established for over 20 years, Keys Training is a privately owned Business Training company. The main focus is on providing training solutions to Corporate and Public Sector clients across the UK. Many of our courses are run on client premises as closed/tailored events; we have experienced high quality trainers, committed dedicated support staff, first class training materials and a client base including several large international companies, NHS and other Government agencies and numerous medium sized and smaller organisations. Keys Training complies rigorously with accepted codes of practice over a wide range of compliance and regulatory issues, conducts regular formal internal quality audits, and has a detailed internal Quality Manual. Keys Training is also a recognised Investor in People. We maintain a comprehensive database of all courses and delegates who have attended and can provide on request any historical information to enable an in-depth analysis. At Keys Training, we offer a large range of instructor led training courses to meet the needs of our clients across the country. We offer regular scheduled courses in a number of Microsoft and Personal Development Skills that are very useful in today’s work place environment. The most popular training we offer here is the Microsoft Office Training Courses. Our trainers are qualified Microsoft Certified Trainers (MCT) and many are also accredited Microsoft Master Instructors (MMI), so you can be assured that your training will be delivered by experts that have both the knowledge and ability to teach their areas in an enjoyable and receptive manner. We have city based training venues at Preston, Manchester, Liverpool, Leeds, London and Birmingham but we are happy to train on your site anywhere in Britain, usually for no additional fee.

Message

warrington russian language school solnyshko

Warrington

It all began in June 2012, when a team of parents-enthusiasts set up a Russian speaking parent and toddler group, called “Solnyshko" (loosely translated as “Sunshine”). The aim of this group was to create a Russian speaking environment for their young children and help them in learning the Russian language. The parent and toddler group is aimed at children from 1 to 3 years and operates all year around, excluding school holidays. The sessions include the staples of singing, dancing, nursery rhymes, puppet shows, crafts and sensory activities for the younger ones, as well as themed sessions aimed at expanding vocabulary of a particular topic of the week, basic numeracy and knowledge of the alphabet. Following growing demand and in response to a number of requests, the Committee decided to open a Saturday school for teaching Russian language to older children in more depth. Thus, in September 2013 Warrington Russian Language School “Solnyshko” opened its doors to older children. The opening ceremony was attended by the Mayor of Warrington and accompanying dignitaries. "Solnyshko" has been expanding ever since and currently offers classes to children aged from 3 and 16 years. Classes are organised according to age and knowledge of the Russian language. The curriculum includes lessons of Russian language and literature, expanding vocabulary and music, preparing for Russian language GCSE exam. Our goal - creation of friendly Russian-speaking environment for children, helping them to learn the language, make friends and have fun. We are truly an international school, we unite people from different backgrounds and ethnic groups. The school holds regular “open lessons” and special children performances involving the school’s pupils, where parents have the opportunity to observe the development and success of their children. The Committee and school staff are tirelessly working on creating a positive and welcoming atmosphere in the school, which is important not only for children, but also helps adults to develop and maintain social ties and support each other. The school has a system of seeking parents feedback - in addition to regular parent surveys through written questionnaires, parents are invited to write their comments and suggestions and drop them in the “suggestion box”, located next to the entrance. They are also encouraged to ask questions or make suggestions at any time. The Committee is always glad to welcome new volunteers, who wish to join the management of the school. All school staff are DBS is checked. School teachers have appropriate pedagogical education and experience of working with children. Classes are held each Saturday from 9.30 to 11:50. From 12:00 a selection of clubs start. "Solnyshko" is a not-for-profit organisation, registered with Warrington Borough Council. Families, who have two or more children attending "Solnyshko" are eligible to discounts. Anyone, who is struggling to pay school fees, is encouraged to talk to the school’s Committee, where arrangements could be considered. *** Given the momentum and public support Warrington Russian Language School has received during its temporary closure on 12th of March 2022, we work closely with Warrington Borough Council on two matters: 1. On preventing bullying of kids with links to Russia or Russian language at this difficult time. 2. Working together helping Ukrainian refugees to quickly and successfully integrate into the community by providing translation/interpreting, advice and free lessons in our language school (English, Russian and Ukrainian), as well as access to art/painting, craft, music band, football and other activities in Russian language (as you know, most people in Ukraine can speak Russian language). We have a small database of local people (as well as our own teachers) willing to give their free time to teach various subjects and translate as necessary for the Ukrainian refugees. We also work closely with the community and can propose and host "tea and advice" meet up events in various locations. The temporary closure of our classes on 12th of March was very tough for everyone at Russian Language School "Solnyshko" (parents, pupils, teachers). We were so glad, however, to receive such overwhelming support from local community and happy it's behind us now. We look forward to even closer links to the wider community, St Wilfrids Primary School and Warrington Borough Council.

Message

Show all 6