Nowadays, efficient data management is an essential skill in the workplace, given the exponential growth of information and the need for companies to make data-driven decisions. The Course in SQL and NoSQL Databases will provide you with the tools you need to master both databases relational and non-relational data, which will enable you to adapt to a range of situations and market requirements. This online course is designed to help you develop skills in the creation, management and database optimisation, as well as in the integration of different systems. Demand for professionals in this field is high, and having this knowledge will open the door to numerous career opportunities. Don’t get left behind – become an expert in data management, a profile that is increasingly valued in the sector.
SQL and NoSQL databases
Big Data and Business Intelligence Development
30 hours
Introduction
Objectives
-
Understanding the basics and benefits of SQL and NoSQL databases in modern applications.
-
To know the SQL language for the creation and the management of databases and tables.
-
Perform basic and advanced enquiries in SQL for the effective handling of data.
-
Designing relational data models using the standardisation and the use of appropriate passwords.
-
Managing databases in MySQL y MongoDB, including its installation and configuration.
-
Compare SQL DBMSs y NoSQL relevant factors for choosing the best option based on specific needs.
-
Integrate data from SQL and NoSQL databases using strategies and the right tools for optimisation.
Table of Contents
TEACHING UNIT 1. INTRODUCTION TO DATABASES
Database basics
Advantages of using databases in applications
A Brief History of Database Management Systems (DBMS)
Types of databases: SQL and NoSQL
TEACHING UNIT 2. BASICS OF SQL
An Introduction to SQL
Creating databases and tables
Data entry and retrieval
Amending and deleting data
Advanced queries: JOIN operations
Data aggregation and grouping functions
TEACHING UNIT 3. QUERIES AND SUBQUERIES IN SQL
Basic queries: SELECT, FROM and WHERE
Sorting results: the ORDER BY clause
Data filtering: LIKE and IN clauses
Using subqueries in SQL
Logical operators and combining conditions
Query optimisation
TEACHING UNIT 4. RELATIONAL DATA MODELLING
Relational database design
Modelling entities and relationships
Database normalisation
Primary and foreign keys
One-to-one, one-to-many and many-to-many relationships
TEACHING UNIT 5. MySQL
Installing and configuring MySQL
Creating and managing databases in MySQL
Creating and managing tables in MySQL
Advanced queries in MySQL
Transactions and Concurrency Control in MySQL
Indexes and query optimisation in MySQL
TEACHING UNIT 6. MongoDB
An Introduction to MongoDB and NoSQL Databases
Installing and configuring MongoDB
Creating and managing databases in MongoDB
Collections and documents in MongoDB
Queries and filters in MongoDB
Indexes and performance in MongoDB
TEACHING UNIT 7. OTHER RELEVANT SQL DATABASE MANAGEMENT SYSTEMS
Oracle Database: features and usage
PostgreSQL: features and usage
SQL Server: features and usage
Comparison of relational database management systems
TEACHING UNIT 8. OTHER RELEVANT NOSQL DBMSs
Cassandra: features and usage
Redis: features and usage
Neo4j: features and usage
Comparison of NoSQL DBMSs
TEACHING UNIT 9. INTEGRATION OF SQL AND NOSQL DATABASES
Benefits of integrating SQL and NoSQL
Data integration strategies
Tools and techniques for integration
Use cases for SQL and NoSQL integration