Menu
close

Database Design and Management: Programming in SQL

Aimed at professionals who wish to specialise in database management and develop SQL programming skills.

3 Weeks (32h.) | No timetables

Academic information

Why study this course?
  • Standard language for relational databasesSQL (Structured Query Language) is one of the world's most widely used programming languages for managing databases. Learning SQL will allow you to access, manipulate and analyse data in a wide variety of work contexts.
  • Facilitates decision-makingSQL allows you to perform accurate and efficient database queries, which makes it easier to make decisions based on reliable and up-to-date data.
  • Easy to learnSQL is an accessible language, ideal for beginners. It does not require advanced programming skills, and its syntax is clear and intuitive, making it an excellent choice for those starting out in database management.
  • Increase your career opportunitiesLearning SQL can open doors in a variety of professional fields, such as IT, data analysis, digital marketing, finance and more.
Program aims
  • Understand the fundamental concepts of databases and their structure.
  • Learn to create, manage and manipulate databases using SQL.
  • Design and execute advanced SQL queries to extract and analyse data.
  • Knowledge of database normalisation and optimisation techniques.
  • Integrate SQL with other languages and tools for data analysis.
Professional skills

At the end of this course, you will be able to manage and design databases efficiently, apply advanced SQL queries to extract and transform data, and optimise database performance. In addition, you will have the skills to integrate SQL into data analysis projects and make decisions based on large volumes of information.

Methodology
  • Practical activities from minute 1
  • Each unit including a questionnaire type test
  • Al final from course you will solve a case practical guided

Study plan

Business Intelligence and database design

In this unit you will learn the basic concepts about databases, exploring the different models, with a special focus on the relational model and the Entity-Relationship (E/R) model, used to represent the structure of the database. You will also cover normalisation, a key process for optimising databases, and how to transform an E/R model into an applicable relational model.

  • Database models
  • Relational model
  • Entity-Relationship Model
  • Standardisation
SQL Standard I

This unit introduces the SQL language and its relevance to database management. You will learn how to configure the working environment to interact with databases. You will then explore DDL (Data Definition Language) statements for defining and modifying the database structure, and DML (Data Manipulation Language) statements for inserting, updating, deleting and querying data.

  • Data Definition Language (DDL) statements
  • Data Manipulation Language (DML) Sentences
SQL Standard II

In this unit you will delve into advanced SQL techniques, such as grouping records to perform complex analysis. You will learn how to combine tables using JOIN operations and how to use subqueries to nest queries. You will also explore ANY and ALL statements for comparing values in subqueries, and the concept of views, which allow you to store complex queries as virtual objects within the database.

  • Grouping of records
  • Table combinations
  • Sub-consultations
  • ANY and ALL statements
  • Views
The data warehouse

In this unit you will learn what a Data Warehouse is and how it is used to store large volumes of structured data for analysis. You will cover the concepts of dimensions and metrics for the design of analysis-oriented databases, and the ETL (Extract, Transform and Load) process to integrate data from different sources, ensuring its quality and accessibility.

  • Data Warehouse
  • Dimensions and metrics
  • Extraction, Transformation and Loading (ETL) process
*The academic program may be subject to changes in line with the changing demand for specific skills in the market. Your employability is our goal.