The Course: Relational Databases. SQL. Designing a Data Warehouse (Big Data) immerses you in the fascinating and dynamic world of data management, which is essential in today’s digital age. The relational databases and SQL are fundamental pillars of the information management, whilst the design of a data warehouse It equips you to handle large volumes of data, a skill that is in high demand in the job market. You will learn the basics of SQL right through to advanced commands and functions, enabling you to acquire skills that will set you apart as a professional. With a focus on the Big Data, this course prepares you to tackle the current challenges of data management and positions you within a booming sector offering a wealth of opportunities for professional development. The online format allows you to tailor your learning to suit your needs, so that you can acquire these essential skills from anywhere.
Relational databases. SQL. Data warehouse design (Big Data)
Big Data
8 pm
Introduction
Objectives
- To learn how to use SQL commands to manage databases effectively and efficiently.
- Develop the ability to create and modify tables using SQL in order to structure data appropriately.
- Identify and apply SQL functions to carry out complex analyses and obtain accurate results.
- Design a data warehouse tailored to big data requirements to improve decision-making.
- To understand the architecture of a data warehouse and its role in managing large volumes of data.
- Run advanced SQL queries to manipulate and extract useful information from relational databases.
Table of Contents
TEACHING UNIT 1. FIRST STEPS IN SQL
Introduction to SQL
Database management
Data types
Standardisation
Creating tables in SQL
TEACHING UNIT 2. SQL COMMANDS
Working with tables
Querying tables in SQL
Joining tables in SQL
Combinations of tables and views
Other SQL commands
TEACHING UNIT 3. SQL FUNCTIONS
Functions for strings and numerical functions (I)
Numerical functions (II)
Date and time functions
Other features
Loops, conditionals and triggers in SQL
TEACHING UNIT 4. DESIGNING A DATA WAREHOUSE
An Introduction to Data Warehousing
Databases in a data warehouse. Stage
Databases in a data warehouse. ODS (I)
Data in a data warehouse. ODS (II)
Databases in a data warehouse. DDS