Mydra logo
Log in
>All courses>Data
Data
Data
Nuclio Learning logo

Nuclio Learning

Advanced Data Management: Mastering SQL

  • Intermediate

Explore the fascinating world of databases with our SQL specialization. From fundamentals to advanced strategies, we forge experts capable of transforming data into knowledge, providing efficient solutions for robust and effective information management.

  • SQL vs NoSQL Databases
  • Database Management Systems (DBMS)
  • Data Modeling with Entity-Relationship
  • SELECT Syntax Fundamentals
  • Data Filtering with WHERE

Overview

This course provides a deep understanding of the differences between SQL and NoSQL databases, equips students with solid SQL querying skills for data extraction, and imparts basic knowledge of table editing commands in SQL databases.

  • Web Streamline Icon: https://streamlinehq.com
    Online
    course location
  • Layers 1 Streamline Icon: https://streamlinehq.com
    Spanish
    course language
  • Professional Certification
    upon course completion
  • Self-paced
    course format
  • Pre-recorded classes
    delivered online

Who is this course for?

Data Analysis Professionals

Professionals in data analysis who require SQL skills.

Application Developers

Developers of applications that require SQL skills.

Information Management Professionals

Professionals interested in efficiently managing the information of their projects or businesses.

Why should you take this course?

Data

Núria Xifré Martín

Instructor

A SQL course is key to boosting your professional profile in the digital age. Learning SQL gives you the essential ability to manage data, vital in software development, data analysis, and decision-making. Knowing SQL will make you stand out in a competitive job market, whether you're a developer, data analyst, or executive. Invest in your future and acquire fundamental skills with a SQL course!

Pre-Requisites

1 / 3

  • Basic understanding of databases

  • Interest in data management and analysis

  • Willingness to learn and apply SQL in practical scenarios

What will you learn?

Differences Between SQL and NoSQL Databases
General overview, comparison of models, differences, structure, flexibility, and use cases of SQL and NoSQL databases.
Database Management Systems (DBMS)
Key functions, description of DBMS responsibilities, and functions in database administration.
Types of DBMS
Understanding MySQL, PostgreSQL, MongoDB, and their specific applications.
Data Modeling with Entity-Relationship
Principles of E-R, basic concepts of the E-R model.
Fundamental SELECT Syntax
Introduction to the basic structure of SELECT queries, understanding column selection and result handling.
Data Filtering with WHERE
Applying conditions to retrieve specific data, restrictions on queries to retrieve specific data.
Sorting and Limiting with ORDER BY and LIMIT
Learning about result ordering, limiting records for more precise queries.
Aggregations and Subqueries in SQL
Group functions and aggregations like SUM, AVG, COUNT, grouping with GROUP BY, creation and optimization of subqueries, using subqueries for more complex operations and improved query efficiency.
Joins and Window Functions in SQL
Types of Joins: INNER, LEFT, RIGHT, FULL, Window Functions and Partitioning (ROW_NUMBER and RANK), application in queries for data analysis in partitions.
Data Manipulation in SQL
Inserting data with INSERT, updating records with UPDATE, deleting data with DELETE.

Meet your instructor

  • Núria Xifré Martín

    Data Scientist, Caixabank Advanced Business Analytics

    I am an Aerospace Engineer passionate about project management and software engineering. You can check my Github profile to see my work: https://github.com/NuriaXForgeFlow.

Upcoming cohorts

  • Dates

    start now

€290