java fundamentals
oracle

Programación y Diseño de Bases de Datos con SQL

This course engages students to analyze complex business scenarios and create a data model—a conceptual representation of an organization’s information. Participants implement their database design by creating a physical database using SQL. Basic SQL syntax and the rules for constructing valid SQL statements are reviewed. This course culminates with a project that challenges students to design, implement, and demonstrate a database solution for a business or organization.

For college/university faculty who teach computer programming, information communications technology (ICT), or a related subject • Secondary school teachers who teach computer programming, ICT, or a related subject.

Prerequisites Required:  Ease with using a computer and general knowledge of databases and query activity 

Duración

180 horas

Online course

Del 1 de enero 2020
al 31 de octubre 2020

Programa

  1. Introducción 

  2. What is Data Modeling? 

  3. Entity Relationship Diagramming

  4. Supertypes, Subtypes, and Business Rules 

  5. Working with EntityRelationships 

  6. Unique Identifiers and Normalization

  7. Arcs, Hierarchies, and Historical Data 

  8. ERD Project Presentation

  9. Drawing Conventions and Generic Modeling

  10. Transforming From Conceptual Model to Physical Model 

  11. Introduction to SQL 

  12. Using Complex SQL with Aggregated Data

  13. Creating Subqueries

  14. Constructing DML Statements 

  15. Working with DDL Statements 

  16. Fundamentals of Database Security

  17. Oracle ProprietaryJoin Syntax

Multiples Imagenes
ods gral
ods educación

Suscríbete

Recibe las últimas tendencias tecnológicas y no te pierdas ninguno de nuestros eventos
The subscriber's email address.

Nuestras redes sociales