This course addresses the analysis, design implementation, and management of relational databases. Structured query language (SQL) is covered in depth along with standard problem domain and data modeling techniques. Implementation techniques and considerations are discussed and practiced extensively. Key concepts include analysis and design using a standardized notation, data model to logical schema conversion techniques, normalization, data security, client-server architectures and web-based access to database systems. Students are exposed to user and privilege management, database backup and recovery, and security vulnerabilities such as SQL injection.
This course addresses the analysis, design implementation, and management of relational databases. Structured query language (SQL) is covered in depth along with standard problem domain and data modeling techniques. Implementation techniques and considerations are discussed and practiced extensively. Key concepts include analysis and design using a standardized notation, data model to logical schema conversion techniques, normalization, data security, client-server architectures and web-based access to database systems. Students are exposed to user and privilege management, database backup and recovery, and security vulnerabilities such as SQL injection.
This course addresses the analysis, design and implementation of relational and non-relational databases. Structured query language (SQL) is covered in depth along with standard problem domain and data modeling techniques. Implementation techniques and considerations are discussed and practiced extensively. Key concepts include analysis and design using a standardized notation such as the unified modeling language (UML), data model to logical schema conversion techniques, normalization, data security, client-server architectures and web-based access to database systems (e.g. XML). Additional advanced topics covered include system security, transaction processing, web data extraction, Big Data, MapReduce framework and key-value stores.
This course addresses the analysis, design and implementation of relational database applications. The structured query language (SQL) is covered in depth along with standard problem domain and data modeling techniques. Implementation techniques and considerations are discussed and practiced extensively. Key concepts include analysis and design using a standardized notation such as the unified modeling language (UML), data model to logical schema conversion techniques, normalization, client-server architectures and web-based access to database systems (e.g. XML). Additional advanced topics covered include system security, transaction processing, data recovery techniques, and maintaining state for mobile devices. Design projects focus on implementing the key course concepts using state-of-the-art multi-user database software.
This course addresses the analysis, design and implementation of relational database applications. The structured query language (SQL) is covered in depth along with standard problem domain and data modeling techniques. Implementation techniques and considerations are discussed and practiced extensively. Key concepts include analysis and design using a standardized notation such as the unified modeling language (UML), data model to logical schema conversion techniques, normalization, client-server architectures and web-based access to database systems (e.g. XML). Additional advanced topics covered include system security, transaction processing, data recovery techniques, and maintaining state for mobile devices. Design projects focus on implementing the key course concepts using state-of-the-art multi-user database software.
This course addresses the analysis, design and implementation of relational database applications. The structured query language (SQL) is covered in depth along with standard problem domain and data modeling techniques. Implementation techniques and considerations are discussed and practiced extensively. Key concepts include analysis and design using a standardized notation such as the unified modeling language (UML), data model to logical schema conversion techniques, normalization, client-server architectures and web-based access to database systems (e.g. XML). Additional advanced topics covered include system security, transaction processing, and data recovery techniques. Design projects focus on implementing the key course concepts using state-of-the-art multi-user database software. (Note: became CS350 Database Design and Implementation eff 2004-2)
