Database analysis/management transcends a wide range of skills from data modeling, analysis, scripting, to understanding users, what they do, what they want, as well as statistical analysis and data mining–and, how the developer can meet all of those needs, and code the necessary solutions! This course examines relational database management systems using typical, commercial DBMS, including MySQL, MS SQL Server, Oracle, as well as an introduction to NOSQL (i.e., nonstructured data). Topics include data modeling, database design/implementation, forms and reports, as well as remote access to databases. The goal of this course is to provide students with an intermediate understanding of database design, implementation, and management concepts and techniques.
Learning Objectives
- Explain the operation of Database Management Systems.
- Explain database environments and development processes.
- Explain basic information organizational concepts and theories.
- Design and implement more advanced logical and physical database solutions.
- Utilize client/server database environments.
- Use advanced SQL techniques (e.g., advanced queries, inserts, and joins).
- Analyze advanced database design and management concepts (e.g., views, stored procedures, and triggers).
- Design databases, using advanced modeling techniques, and employing MySQL and MS SQL Server.
Framework Connections
Feedback
If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.