CNE 340 - Network Databases and Structured Query Language (SQL)

5 Credits
This course introduces students to database management using Structured Query Language (SQL). Students are introduced to table formats, data types, schemas, ACID, and relational elements. Students will create tables, construct queries, and manage database systems. Students will use Python to automate database actions. Students will use a LAMP stack to integrate databases into web projects.

Prerequisite(s): Completion of CNE 330 with a 2.0 or higher.

Course Outcomes

Use SQL to create tables and indexes.
Compose SQL queries.
Understand constraints, views, triggers, and indexes in databases.
Explain how queries are processed, optimized and evaluated in a DBMS.
Explain transaction processing.
Recognize common SQL server issues (log space, performance problems, job failures).