CSCD327 — Relational Database Systems
Basic concepts in relational database systems including SQL, Relational Algebra, Entity-Relationship Model, and application development.
Learning Objectives & Matches
Design and implement relational database schemas using normalization principles
Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
Develop and document database architectures.
Design and implement warehouse database structures.
Document and communicate database schemas, using accepted notations.
Design databases to support business applications, ensuring system scalability, security, performance, and reliability.
Develop data models for applications, metadata tables, views or related database structures.
Design database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access of the generic database structure.
Write and code logical and physical database descriptions and specify identifiers of database to management system, or direct others in coding descriptions.
Write and code logical and physical database descriptions, and specify identifiers of database to management system or direct others in coding descriptions.
Demonstrate database technical functionality, such as performance, security and reliability.
Write SQL queries for data retrieval, manipulation, insertion, and deletion operations
Generate data queries, based on validation checks or errors and omissions identified during data entry, to resolve identified problems.
Write computer programs or scripts to be used in querying databases.
Prepare data for processing by organizing information, checking for inaccuracies, and adjusting and weighting the raw data.
Clean and manipulate raw data using statistical software.
Analyze, manipulate, or process large sets of data using statistical software.
Prepare and structure data warehouses for storing data.
Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
Prepare statistical data for inclusion in reports to data monitoring committees, federal regulatory agencies, managers, or clients.
Write and code logical and physical database descriptions and specify identifiers of database to management system, or direct others in coding descriptions.
Write and code logical and physical database descriptions, and specify identifiers of database to management system or direct others in coding descriptions.
Create and manage database objects including tables, views, indexes, and stored procedures
Apply relational algebra concepts to query optimization and database theory
Write and code logical and physical database descriptions, and specify identifiers of database to management system or direct others in coding descriptions.
Write and code logical and physical database descriptions and specify identifiers of database to management system, or direct others in coding descriptions.
Develop data models for applications, metadata tables, views or related database structures.
Conduct logical analyses of business, scientific, engineering, and other technical problems, formulating mathematical models of problems for solution by computers.
Address the relationships of quantities, magnitudes, and forms through the use of numbers and symbols.
Mentor others on mathematical techniques.
Apply mathematical theories and techniques to the solution of practical problems in business, engineering, the sciences, or other fields.
Conduct research to extend mathematical knowledge in traditional areas, such as algebra, geometry, probability, and logic.
Develop new principles and new relationships between existing mathematical principles to advance mathematical science.
Translate nursing practice information between nurses and systems engineers, analysts, or designers, using object-oriented models or other techniques.
Develop Entity-Relationship diagrams to model data requirements and relationships
Develop data models for applications, metadata tables, views or related database structures.
Develop data model describing data elements and their use, following procedures and using pen, template or computer software.
Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
Develop data models describing data elements and how they are used, following procedures and using pen, template, or computer software.
Create Web models or prototypes that include physical, interface, logical, or data models.
Create Web models or prototypes that include physical, interface, logical, or data models.
Develop system interaction or sequence diagrams.
Develop system interaction or sequence diagrams.
Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
Document and communicate database schemas, using accepted notations.