Live online classes

Course on Database design and management: Programming in SQL

3 weeks (32h.)

With this course you will understand what a database is in today's digital ecosystem (basic concepts, management for consumption, etc.). You will review the compound and derivative operations of relational algebra and then discuss two very important aspects for designing and optimising the relational database model using the SQL query language.

Make payment

10% lump sum discount

Academic information

Why study this course?

Standard language used for relational databases: SQL (Structured Query Language) is one of the most widely used programming languages in the world. Learning SQL will allow you to access and manipulate information in a wide variety of work contexts.
It facilitates decision-making: SQL allows you to make accurate and efficient queries to a database, making it easier to make data-driven decisions.
Easy to learn: SQL is relatively easy to learn. It does not require advanced programming skills and the syntax is fairly intuitive.
Increase your career opportunities: Learning SQL can increase your career opportunities in a variety of fields, such as computer science, data analysis, digital marketing, finance and more.
For people with no previous programming knowledge. Aimed at people interested in learning about the different data models as well as the different repositories and databases in the digital ecosystem.

Program aims

SQL programming
Linear algebra
Multimedia data analysis
Web scrapping
Entity/relationship model

Professional skills

There are a number of career opportunities for those with SQL skills. Some of the main options are: Database administrator: Database administrators are responsible for maintaining and ensuring the performance of databases in a company or organisation. Software Developer: Software developers can use SQL to create applications that interact with databases. Data Analyst & Business Intelligence Specialist: Data analysts use SQL to extract valuable information from databases and provide important insights for decision making.

Methodology

Practical activities from minute 1
For each unit there will be a multiple-choice test and at the end of the course a real case will have to be solved.

Study plan

With this course you will understand what databases are in today's digital ecosystem (basic concepts, management for consumption, etc.). You will review the compound and derivative operations of relational algebra, and then you will deal with two very important aspects for designing and optimising the relational database model using the SQL query language.

Introduction to Business Intelligence and database design

This module provides an introduction to databases, including their definition and historical overview. It describes database management systems and the DDL, DML, DCL and TCL statements. The database models and the differences between OLTP and OLAP databases are also mentioned. The relational model is introduced and how it relates to relational algebra and SQL is explained.

SQL Standard

This module covers various aspects of the relational database model. It explains the concept of relational algebra and its relationship to the SQL language. Composite or derived operations and normalisation are described, as well as the process of moving from the Entity-Relationship model to the relational model. It details the SQL language and how to create and use a relational database, including subqueries and the ANY and ALL statements. The article concludes with examples and practices to reinforce the concepts.

*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.