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
The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):
Competency Areas
Feedback
If you would like to provide feedback on this course, please e-mail the NICCS team at NICCS@mail.cisa.dhs.gov. Please keep in mind that NICCS does not own this course or accept payment for course entry. If you have questions related to the details of this course, such as cost, prerequisites, how to register, etc., please contact the course training provider directly. You can find course training provider contact information by following the link that says “Visit course page for more information...” on this page.