This course explores various topics in database management systems (DBMSs), using various industry-standard commercial DBMSs (e.g., MySQL, SQL Server, Oracle), as well as non-relational data repositories (i.e., NoSQL databases). Administration, security, stored procedures, triggers, transactions, functions, data mining, data warehousing, data analytics, remote access, and distributed version control systems are some of the topics covered. The student is expected to demonstrate an understanding of these database/data repository concepts through creating, deploying, and utilizing various relational, and non-relational database designs.
Learning Objectives
- Perform advanced relational data modeling, using entity-relationship diagrams.
- Design a data warehouse.
- Apply performance tuning techniques.
- Administer and perform backup and recovery procedures.
- Justify and define user’s roles, permissions, and access-levels as a database administrator.
- Create database security settings.
- Demonstrate an understanding of data warehousing, data mining, and data analytic techniques.
- Compare and contrast NoSQL and SQL (RDBMS) solutions.
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@hq.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.