Database Design and Management: Programming in SQL Course

Why this course?

Standard language used for relational databases: SQL (Structured Query Language) is one of the most widely-used programming languages in the world. By learning SQL, you will be able to access and process information in a wide range of contexts.
Facilitating decision-making: SQL enables you to make accurate and efficient queries to a database, making it easier to make data-driven decisions.
Easy-to-learn: SQL is a relatively easy to learn programming language. It does not require advanced programming knowledge and the syntax is intuitive.
Boost your career opportunities: Learning SQL can improve your career opportunities across a number of fields, including computer science, data analytics, digital marketing, finance, and others.
For people without prior programming knowledge. Aimed at people interested in learning about a range of data models, as well as the different repositories and databases of the digital ecosystem.

Course aims

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

Professional competencies of the course

There are a range of career opportunities for those with SQL skills. Main opportunities include: Database managers: Database managers are responsible for maintaining databases and ensuring they operate adequately in a company or organization. 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, providing important insights to aid decision making.

Study Plan

This course explains what a database is in the current digital ecosystem (basic concepts, management, etc.). Students review the compound and derivative operations of relational algebra and then discuss two key aspects of design and optimize the relational database model using SQL.

Introduction to Business Intelligence and Database Design

This module presents an introduction to databases, including their definition and a review of their history. Students learn about database management systems and DML, DCL, TCL, and DDL statements. The course also looks at database models and the differences between OLTP and OLAP databases. There is an explanation of the relational model and how it relates to relational algebra and SQL.

SQL Standard

This module covers several aspects of the relational database model. The concept of relational algebra and its relationship with the SQL language is explained. Students explore composite and derived operations and normalization, as well as the process of moving from an entity-relationship model to a relational model. They will look at SQL and how to create and use a relational database, including subqueries and the ANY/ALL statements. The module concludes with examples and practical work to consolidate 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.

Database Design and Management: Programming in SQL Course

Why this course?

Methodology

Study Plan