Data Architecture Principles, Data Structure and SQL

This course will cover different types of Data Structures, different Organizations of Databases including Operational Datastores, Data Warehouses and Data Marts, Data Modelling and Data Mining Concepts, Industry Best Practices, and the SQL Language.

Particularly this course covers the concepts and architecture of database systems, including different types of data models and relational databases. Students learn data normalization and denormalization, as well as logical and physical data modeling. We examine CASE tools for data modeling, data warehouses, and datamarts. Other topics include multi-dimensional databases, star-schema and snowflake structures, data visualization, data mining, and database design project lifecycle. Among the tools considered are OLAP/ROLAP/MOLUP. The course also covers SQL core, dialects, and components. Students learn about multi-table queries, summary queries, sub-queries, and major SQL implementations. Other topics include database objects, database modifications, data integrity, data consistency, and locking mechanisms. Finally, the course considers database dictionaries and security concepts.

Instructor: Gary Yurkovsky

Day/Time: Monday 6:00 p.m. - 8:30 p.m.

The Retraining program is made possible through generous donations from the Robin Hood Foundation and Con Edison. The Retraining Program would also like to thank our individual donors for their support.

logos

  • Founded by inventor, industrialist and philanthropist Peter Cooper in 1859, The Cooper Union for the Advancement of Science and Art offers education in art, architecture and engineering, as well as courses in the humanities and social sciences.

  • “My feelings, my desires, my hopes, embrace humanity throughout the world,” Peter Cooper proclaimed in a speech in 1853. He looked forward to a time when, “knowledge shall cover the earth as waters cover the great deep.”

  • From its beginnings, Cooper Union was a unique institution, dedicated to founder Peter Cooper's proposition that education is the key not only to personal prosperity but to civic virtue and harmony.

  • Peter Cooper wanted his graduates to acquire the technical mastery and entrepreneurial skills, enrich their intellects and spark their creativity, and develop a sense of social justice that would translate into action.