4 credits
core
CAE-CD; CAE-CO
CSCD 327 — Database Systems
Introduction to database management systems with a focus on relational databases. Topics include the relational model, SQL, entity-relationship modeling, normalization, transactions, concurrency control, and introduction to NoSQL systems.
DCWF work roles this course develops
-
DA-653 Data Architect
partial
Data Architect designs the schemas this course introduces.
-
IT-421 Database Administrator
primary
Database Administrator role.
-
DA-422 Data Analyst
strong
Data Analyst uses SQL and relational modeling.
Knowledge Units covered
-
CD-ISC IT Systems Components
partial
Databases are IT systems components.
ABET student outcomes
Student outcomes defined by the ABET Computing Accreditation Commission. Outcome 7 applies to cybersecurity-designated programs.
- ABET 1 strong Analyze a complex computing problem and apply principles of computing and other relevant disciplines to identify solutions.
- ABET 2 strong Design, implement, and evaluate a computing-based solution to meet a given set of computing requirements in the context of the program's discipline.
- ABET 6 strong Apply computer science theory and software development fundamentals to produce computing-based solutions. (Computer Science only.)
O*NET civilian tasks prepared
Tasks drawn from the O*NET records for the occupations that most directly correspond to the DCWF roles this course develops.
- SOC 15-1242.00: Plan, coordinate, and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification, or disclosure.
- SOC 15-1242.00: Specify users and user access levels for each segment of database.
NCAE CyberGames scoreboard errors this course addresses
The coursework covers topics that appear in these scoreboard patterns during NCAE regional and national events.
- NCAE-53a9f9da43 WWW Port 80 / failure: Failed to connect to server, is port 80 open?
- NCAE-eeb5e4e8f3 SMB Login / failure: SMB operation failed: [Errno 111] Connection refused
- NCAE-efd6404d3c SMB Read / failure: SMB operation failed: [Errno 111] Connection refused
- NCAE-600767ba09 SMB Write / failure: SMB operation failed: [Errno 111] Connection refused
- NCAE-ed9f4ee89c SMB Read / partial: SMB operation failed: Failed to get attributes for addict_with_a_pen.data on files: Unable to open remote file object
- NCAE-4b7774940b SMB Login / failure: SMB operation failed: [Errno 113] Host is unreachable
- NCAE-b9e0ec08d1 SMB Write / failure: SMB operation failed: [Errno 113] Host is unreachable
- NCAE-1c78c96e24 SMB Read / failure: SMB operation failed: [Errno 113] Host is unreachable
- NCAE-93ded42199 SMB Read / partial: 22 files have incorrect content
- NCAE-4dc6feb4c8 SMB Read / failure: SMB connection failed: protocol error
- NCAE-2ec02e1cd0 SMB Login / failure: SMB connection failed: protocol error
- NCAE-7aef47fca9 SMB Write / failure: SMB connection failed: protocol error
- NCAE-6874759148 SMB Read / partial: SMB operation failed: Failed to get attributes for cottonwood.data on files: Unable to open remote file object
- NCAE-935f9d5213 SMB Read / partial: SMB operation failed: Failed to retrieve before_you_start_your_day.data on files: Unable to open file
- NCAE-523d40773c SMB Read / partial: SMB operation failed: Failed to get attributes for .choker.data on files: Unable to open remote file object
- NCAE-b149cb49bf SMB Read / partial: SMB operation failed: Failed to get attributes for air_catcher.data on files: Unable to open remote file object
- NCAE-4b8d0cb667 SMB Read / failure: Failed to connect to host: IP
- NCAE-d9f492a0da SMB Login / failure: Failed to connect to host: IP
- NCAE-864b183177 SMB Write / failure: SMB operation failed: timed out
- NCAE-825cea0d2d SMB Read / partial: SMB operation failed: Failed to get attributes for addict_with_a_pen.data on files: Unable to connect to shared device
- NCAE-e95d2c2e3c SMB Read / failure: SMB operation failed: timed out
- NCAE-8295662a0b SMB Write / failure: Failed to connect to host: IP
- NCAE-55a9a5a7d4 SMB Login / failure: SMB operation failed: timed out
- NCAE-720468fcb4 SMB Login / partial: SMB operation failed: Failed to list shares: Unable to locate Server Service RPC endpoint
- NCAE-8a154c2d67 SMB Write / failure: SMB operation timed out in 5 seconds
- NCAE-ef2e6bfc87 SMB Read / partial: SMB operation failed: Failed to get attributes for data_dump_1.bin on files: Unable to open remote file object
- NCAE-49be0b578b SMB Login / failure: SMB operation timed out in 5 seconds
- NCAE-73f906f1e8 SMB Read / failure: SMB operation timed out in 5 seconds
- NCAE-34e3807d5a SMB Login / partial: SMB operation failed: Failed to list shares: Unable to connect to IPC$
- NCAE-8eaf99105e SMB Read / partial: SMB operation failed: Failed to retrieve be_concerned.data on files: Unable to open file