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
Curso Online
Programa
- 
	
Introducción
 - 
	
What is Data Modeling?
 - 
	
Entity Relationship Diagramming
 - 
	
Supertypes, Subtypes, and Business Rules
 - 
	
Working with EntityRelationships
 - 
	
Unique Identifiers and Normalization
 - 
	
Arcs, Hierarchies, and Historical Data
 - 
	
ERD Project Presentation
 - 
	
Drawing Conventions and Generic Modeling
 - 
	
Transforming From Conceptual Model to Physical Model
 - 
	
Introduction to SQL
 - 
	
Using Complex SQL with Aggregated Data
 - 
	
Creating Subqueries
 - 
	
Constructing DML Statements
 - 
	
Working with DDL Statements
 - 
	
Fundamentals of Database Security
 - 
	
Oracle ProprietaryJoin Syntax