{"id":561,"date":"2024-09-11T12:32:16","date_gmt":"2024-09-11T10:32:16","guid":{"rendered":"https:\/\/principal.immune.institute\/?post_type=programas&p=561"},"modified":"2026-01-23T14:22:08","modified_gmt":"2026-01-23T13:22:08","slug":"curso-de-diseno-y-gestion-de-bases-de-datos-programacion-en-sql","status":"publish","type":"programas","link":"https:\/\/immune.institute\/en\/programas\/curso-de-diseno-y-gestion-de-bases-de-datos-programacion-en-sql\/","title":{"rendered":"Database Design and Management Course: SQL Programming"},"content":{"rendered":"
\"\"<\/span>
\n
\n

Database Design and Management Course: SQL Programming<\/h1>\n\n\n

Aimed at professionals who wish to specialise in database management and develop SQL programming skills.<\/p>\n\n\n\n

\n

Asynchronous online learning<\/p>\n\n\n\n

<\/p>\n\n\n\n

3 weeks (32h.)<\/p>\n\n\n\n

No son necesarios conocimientos previos<\/p>\n<\/div>\n\n\n\n

\n
Make payment<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div><\/section>\n\n\n\n
\n
\n

Why study this course?<\/h2>\n\n\n\n
    \n
  • Standard language for relational databases<\/strong>SQL (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.<\/li>\n\n\n\n
  • Facilitates decision-making<\/strong>SQL allows you to perform accurate and efficient database queries, which makes it easier to make decisions based on reliable and up-to-date data.<\/li>\n\n\n\n
  • Easy to learn<\/strong>SQL 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.<\/li>\n\n\n\n
  • Increase your career opportunities<\/strong>Learning SQL can open doors in a variety of professional fields, such as IT, data analysis, digital marketing, finance and more.<\/li>\n<\/ul>\n<\/div>\n<\/section>\n\n\n\n
    \n
    \n
    \n
    Program aims<\/summary>\n
      \n
    • Understand the fundamental concepts of databases and their structure.<\/li>\n\n\n\n
    • Learn to create, manage and manipulate databases using SQL.<\/li>\n\n\n\n
    • Design and execute advanced SQL queries to extract and analyse data.<\/li>\n\n\n\n
    • Knowledge of database normalisation and optimisation techniques.<\/li>\n\n\n\n
    • Integrate SQL with other languages and tools for data analysis.<\/li>\n<\/ul>\n<\/details>\n<\/div>\n\n\n\n
      \n
      Methodology<\/summary>\n
        \n
      • Actividades pr\u00e1cticas desde el minuto 1.<\/li>\n\n\n\n
      • Cada unidad incluye un cuestionario tipo test.<\/li>\n\n\n\n
      • Al final del curso resolver\u00e1s un caso pr\u00e1ctico guiado.<\/li>\n<\/ul>\n<\/details>\n<\/div>\n<\/div>\n<\/section>\n\n\n\n
        \n
        \n

        Study plan<\/h2>\n\n\n\n
        Business Intelligence and database design<\/summary>\n

        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.<\/p>\n\n\n\n

          \n
        • Database models<\/li>\n\n\n\n
        • Relational model<\/li>\n\n\n\n
        • Entity-Relationship Model<\/li>\n\n\n\n
        • Standardisation <\/li>\n<\/ul>\n<\/details>\n\n\n\n
          SQL Standard I<\/summary>\n

          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.<\/p>\n\n\n\n

            \n
          • Data Definition Language (DDL) statements<\/li>\n\n\n\n
          • Data Manipulation Language (DML) Sentences<\/li>\n<\/ul>\n<\/details>\n\n\n\n
            SQL Standard II<\/summary>\n

            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.<\/p>\n\n\n\n

              \n
            • Grouping of records<\/li>\n\n\n\n
            • Table combinations<\/li>\n\n\n\n
            • Sub-consultations<\/li>\n\n\n\n
            • ANY and ALL statements<\/li>\n\n\n\n
            • Views<\/li>\n<\/ul>\n<\/details>\n\n\n\n
              The data warehouse <\/summary>\n

              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.<\/p>\n\n\n\n

                \n
              • Data Warehouse<\/li>\n\n\n\n
              • Dimensions and metrics<\/li>\n\n\n\n
              • Extraction, Transformation and Loading (ETL) process<\/li>\n<\/ul>\n<\/details>\n\n\n\n

                * Los docentes realizar\u00e1n la selecci\u00f3n del alumnado.<\/p>\n<\/div>\n<\/section>","protected":false},"excerpt":{"rendered":"

                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.<\/p>","protected":false},"featured_media":23324,"menu_order":5,"template":"","meta":{"_acf_changed":false,"_crdt_document":"","footnotes":""},"area":[241],"tipo":[259],"class_list":["post-561","programas","type-programas","status-publish","has-post-thumbnail","hentry","area-data","tipo-curso"],"acf":[],"_links":{"self":[{"href":"https:\/\/immune.institute\/en\/wp-json\/wp\/v2\/programas\/561","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/immune.institute\/en\/wp-json\/wp\/v2\/programas"}],"about":[{"href":"https:\/\/immune.institute\/en\/wp-json\/wp\/v2\/types\/programas"}],"version-history":[{"count":0,"href":"https:\/\/immune.institute\/en\/wp-json\/wp\/v2\/programas\/561\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/immune.institute\/en\/wp-json\/wp\/v2\/media\/23324"}],"wp:attachment":[{"href":"https:\/\/immune.institute\/en\/wp-json\/wp\/v2\/media?parent=561"}],"wp:term":[{"taxonomy":"area","embeddable":true,"href":"https:\/\/immune.institute\/en\/wp-json\/wp\/v2\/area?post=561"},{"taxonomy":"tipo","embeddable":true,"href":"https:\/\/immune.institute\/en\/wp-json\/wp\/v2\/tipo?post=561"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}