In today’s data-driven landscape, mastering relational databases and SQL is not just an advantage; it is 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 is 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 explore 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 hours
Introduction
Objectives
- To understand the basics of SQL and relational databases.
- To execute SQL commands for data manipulation.
- To use SQL functions to optimise data queries.
- To design a data warehouse schema efficiently.
- To optimise database queries for performance.
- To analyse data using SQL to gain analytical insights.
- To integrate SQL with data warehouse solutions.
Table of Contents
UNIT 1. FIRST STEPS IN SQL
Introduction to SQL
Database manipulation
Data types
Normalisation
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)
Numerical function (II)
Date and time functions
Other functions
Loops, conditionals and triggers in SQL
UNIT 4. DATA WAREHOUSE DESIGN
An introduction to data warehousing
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
More related courses
Cross-cutting
1 hour