Tag: databases

Duration

14 hours (usually 2 days including breaks)

Requirements

Basic computer skills.

Overview

This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn:

• how to write SQL queries
• what relational databases are and how we can use them
• what are relations and how to create them
• the structure of data
• differences between SQL dialects (Oracle, T-SQL, ANSI)
• practical skills for writing queries

This SQL course deals with generic ANSI SQL. It can be used in any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL any other relational databases.

Course Outline

RDBMS (Relational DataBase Management System)

Relational Operators

SQL as Declarative Language

SQL Syntax

SQL Sublanguages DQL, DML, DDL, DCL

DQL (Data Query Language) in Detail

• SELECT clause
• Column aliases
• Table aliases
• Date types and Date functions
• Group function
• Table joins
• JOIN clause
• UNION operator
• Nested queries
• Correlated subqueries

DML (Data Manipulation Language) Overview

• Inserting rows (INSERT)
• Inserting rows using subquery
• Updating rows (UPDATE)
• Deleting rows (DELETE)

DDL (Data Definition Language) Overview

• Creating, altering and dropping objects (CREATE, ALTER, DROP)
• Creating tables using subquery (CREATE TABLE …. AS SELECT…)

CONSTRAINTS Overview

• NULL i NOT NULL
• CONSTRAINT clause
• ENUM type
• SET type
• PRIMARY KEY
• UNIQUE
• FOREIGN KEY
• DEFAULT clause

Transactions Overview

• COMMIT
• ROLLBACK
• SAVEPOINT
• Implicit and explicit rollbacks and commits

SQL Dialects Overview

• MySQL
• Microsoft Access and SQL Server
• Oracle and PostgreSQL

Duration

28 hours (usually 4 days including breaks)

Requirements

• Basic Linux and SQL knowledge

Audience

• Database administrators and developers
• Cloud database architects
• Application developers

Overview

Oracle Database 21c is a converged database that supports a large range of workloads and data models. It’s a data management platform that provides high performance, security, availability, and scalability for cloud environments.

This instructor-led, live training (online or onsite) is aimed at database administrators who wish to learn and use the features of Oracle Database 21c in performing administrative tasks.

By the end of this training, participants will be able to:

• Understand the core concepts of Oracle Database 21c administration.
• Understand the Oracle 21c architecture.
• Learn how to perform administration tasks on Oracle 21c.
• Understand the Oracle 21c backup and recovery process.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Course Outline

Introduction

• Introduction to Oracle Cloud
• Overview of Oracle Database 21c

Oracle Database Architecture

• Overview of the Oracle Database architecture
• Configuring and connecting to the Oracle Database Instance
• Understanding the Oracle Database memory structures
• Process architecture and structures
• Process startup sequence
• Storage architecture

Database Instance

• Overview of the Oracle Database management tools
• Enterprise manager management framework

Setting Up the Oracle Network Environment

• Overview of the Oracle Net Services and Oracle Net Listener
• Oracle Network Connections
• Configuring the Oracle Network tools
• Listener Control Utility
• Oracle Net configuration assistant
• Oracle Net Manager
• Enterprise Manager Cloud Control

Database Storage Structures

• Overview of Database Block Content
• Storage structure
• Creating and managing Tablespaces
• Navigating and viewing Tablespace information
• Using Oracle managed files

User Security

• Managing database user accounts
• Predefined administrative accounts
• Creating a user account
• Authentication and password reset
• Understanding the concept of privileges, roles, and profiles

Data Concurrency

• Understanding the locking mechanism
• Understanding data concurrency
• DML locks
• Enqueue mechanism
• Lock conflicts

Undo Data

• Overview of Undo data
• Managing transactions and storing Undo information
• Undo data vs. Redo data
• Configuring and guaranteeing Undo retention
• Changing the size of an Undo Tablespace

Oracle Database Auditing

• Overview of database auditing
• Database security and compliance monitoring
• Standard database auditing
• Audit administration
• Configuring audit train
• Audit options

Database Maintenance

• Overview of database maintenance
• Alert history
• Automatic Database Diagnostic Monitoring (ADDM)
• Understanding the advisory framework
• Enterprise manager and advisor

Managing Performance and Resources

• Monitoring performance
• Tuning activities and performance planning
• Instance tuning
• Performance tuning methodology and data
• Managing memory
• Overview of Database Resource Manager
• Using the Database Resource Manager
• Maintenance Resource Manager plan
• Resource Manager workflow
• Resource allocation methods

Space Management

• Block space management
• Chaining and migration
• Understanding the types of segments
• Allocating extents and space
• Creating tables without segments

Backup and Recovery

• Overview of Instance Recovery
• Understanding and configuring Instance Recovery
• Instance Recovery Phases
• Using MTTR Advisor
• Understanding Media Failure

Summary and Next Steps

Duration

14 hours (usually 2 days including breaks)

Overview

The course is part of the Data Scientist skill set (Domain: Data and Technology).

Course Outline

Data Warehousing Concepts

• What is Data Ware House?
• Difference between OLTP and Data Ware Housing
• Data Acquisition
• Data Extraction
• Data Transformation.
• Data Loading
• Data Marts
• Dependent vs Independent data Mart
• Data Base design

ETL Testing Concepts:

• Introduction.
• Software development life cycle.
• Testing methodologies.
• ETL Testing Work Flow Process.
• ETL Testing Responsibilities in Data stage.      

Big data Fundamentals

• Big Data and its role in the corporate world
• The phases of development of a Big Data strategy within a corporation
• Explain the rationale underlying a holistic approach to Big Data
• Components needed in a Big Data Platform
• Big data storage solution
• Limits of Traditional Technologies
• Overview of database types

NoSQL Databases

Hadoop

Map Reduce

Apache Spark

Duration

21 hours (usually 3 days including breaks)

Requirements

• A general understanding of databases.

Overview

Knowledge discovery in databases (KDD) is the process of discovering useful knowledge from a collection of data. Real-life applications for this data mining technique include marketing, fraud detection, telecommunication and manufacturing.

In this instructor-led, live course, we introduce the processes involved in KDD and carry out a series of exercises to practice the implementation of those processes.

Audience

• Data analysts or anyone interested in learning how to interpret data to solve problems

Format of the Course

• After a theoretical discussion of KDD, the instructor will present real-life cases which call for the application of KDD to solve a problem. Participants will prepare, select and cleanse sample data sets and use their prior knowledge about the data to propose solutions based on the results of their observations.

Course Outline

Introduction

• KDD vs data mining

Establishing the application domain

Establishing relevant prior knowledge

Understanding the goal of the investigation

Creating a target data set

Data cleaning and preprocessing

Data reduction and projection

Choosing the data mining task

Choosing the data mining algorithms

Interpreting the mined patterns

Summary and conclusion

Overview

Become a software developer with a FREE course at ELATT

Our courses are currently taught live online using Zoom. We have daytime and evening courses available.

We are a charity supporting Londoners to better themselves through education for over 35 years. Please only apply if you live in a London Borough.

Resources

• Software Development Level 1 Course outline

Description

About Software Development

Our software development course will teach you to design and develop a range of programs. You will learn Java as your core coding language and key soft skills such as project management, databases, case diagrams and essential office skills. Your tutor will help you develop proven professional coding skills through object oriented coding, design patterns and frameworks.

Software engineering combines problem solving, creativity and analytical skills. It suits those who are detail oriented with an eye for solutions. There is an ever-increasing demand for new software and a wide variety of clients across a range of sectors are looking to employ skilled software developers.

You will be taught by experienced teachers and we also support you with employability, including opportunities to speak to professionals and access mentoring, volunteering and work experience.

Level 2 Award

• IT security for users: use basic techniques in the operation of an IT system to create, edit and view Python programs online
  Specialist software: learn Online Python IDLE to create basic programs
• Using collaborative technologies: use IT tools and devices for collaborative working and communications in and out of the classroom such as online lessons tools, instant messaging/chat, online forums and more
• IT software fundamentals: learn the basics of software fundamentals, including traditional software development cycles

Level 2 Certificate

• Improving productivity: plan, produce and evaluate your Python programme
• IT security for users: learn about methods to minimise security risks to IT systems and data
• Specialist software: use editors to create Graphical User Interfaces (GUI) and Python modules
• Drawing and planning software: learn how to use free online software to create algorithmic flowcharts for Python programming
• Presentation software: prepare a pitch for your app

Level 2 Diploma

• Customer support provision: learn professional customer support behaviours and practices
• Software testing/software testing fundamentals: test the functionality of a software application to find out whether the software meets the specified requirements
• Creating an event driven computer programme: create a Graphical User Interface (GUI) app
• Creating an procedural computer programme: create a Procedures and Classes Library for an app

Level 3 Diploma

• Customer support provision: including software documentation and remote support
• Software design fundamentals: the Software Development Life Cycle (SDLC)
  Principles of ICT system and data security: understanding threats to ICT systems and site data encryption and cryptography
• Software testing: test the functionality of your software. including PHP unit testing
• Presentation software: use Microsoft PowerPoint to make a business pitch for your software
• Develop software: using SQL (Structured Query Language)
• The technologies of the internet: learn the principles, technologies, security and support systems that allow the internet to work, such as DevOps, website domain hosting and FTP
• Creating an object-oriented computer programme: learn Object-Orientated Programming (OOP) with PHP