In today’s data-driven landscape, mastering relational databases and SQL is not just advantageous; it’s essential. The Relational Databases: SQL. Data Warehouse course is your gateway to unlocking the power of data management and analysis. As businesses increasingly rely on data to drive decisions, there’s a soaring demand for professionals skilled in SQL and data warehousing. Through this course, you’ll gain proficiency in SQL commands and functions, equipping you to efficiently query and manipulate databases. You’ll also delve into data warehouse design, a critical component for organising and optimising large datasets. By enrolling, you’ll position yourself at the forefront of a booming industry, enhancing your career prospects and becoming an invaluable asset to any data-focused organisation. Seize this opportunity to elevate your skills and meet the growing demand for data expertise.
Relational databases: SQL. Data warehouse
Big Data
40 h
Presentación
Objetivos
- To understand the basics of SQL and relational databases.
- To execute SQL commands for data manipulation.
- To apply SQL functions to streamline data queries.
- To design a data warehouse schema efficiently.
- To optimise database queries for performance.
- To interpret data through SQL for analytical insights.
- To integrate SQL with data warehouse solutions.
Índice de contenidos
UNIT 1. FIRST STEPS IN SQL
Introduction to SQL
Database manipulation
Data types
Normalization
Creating tables in SQL
UNIT 2. SQL COMMANDS
Table manipulation
SQL table query
Table joining in SQL
Table combinations and views
Other SQL commands
UNIT 3. SQL FUNCTIONS
String functions and numeric functions (I)
Numeric function (II)
Date and time functions
Other functions
Loops, conditionals and triggers in SQL
UNIT 4. DATA WAREHOUSE DESIGN
Data warehousing introduction
Databases in a data warehouse. Stage
Databases in a data warehouse. ODS (I)
Databases in a data warehouse. ODS (II)
Databases in a data warehouse. DDS