Nov 22, 2024  
2023-2024 Catalog 
    
2023-2024 Catalog [PAST CATALOG]

CTP 140 - Database Foundations, SQL/NoSQL

3 credit hours - Three hours of lecture and directed laboratory weekly; one term.
Learn database fundamentals while working with both relational (SQL) and non-relational (NoSQL) architectures. Learn to create, update, delete, and retrieve data from a traditional relational database using SQL as well as non-relational databases using NoSQL. Lab fee $25.

Note: The student must be familiar with personal computers before beginning the class; no lecture time is spent introducing personal computer terminology and use. CTP 103  can be taken to introduce general computer skills.

Course Outcomes:
 

  1. Describe how databases are used to store and retrieve data.
  2. Describe the differences between relational and non-relational databases. 
  3. Implement Create, Read, Update, and Delete (CRUD) operations in both relational and non-relational databases.