Skip to content

Latest commit

 

History

History
90 lines (66 loc) · 4.53 KB

DS108-Syllabus.md

File metadata and controls

90 lines (66 loc) · 4.53 KB

DS108 Databases

Course Description: This course is an introduction to working with and designing databases. Students will develop a foundational knowledge of database concepts, theory, and an overview of the various implementations and architectures.
Quarter Credit Hours: 4.5
Course Length: 60 hours
Prerequisites: None
Proficiency Exam: No
Theory Hours: 30
Laboratory Hours: 30
Externship Hours: 0
Outside Hours: 15
Total Contact Hours: 60
Module Lesson Number Lesson Name
DS108 Databases – SQL 1 Getting Started with SQL
2 Joins
3 CRUD in SQL
4 Creating Tables
5 Indexes and Projects
DSO108 Databases - NoSQL 1 Getting Started with NoSQL
2 Querying Documents
3 Updating Documents
4 Deleting and Indexing Documents
5 Sharding, More Methods, and Project

Required Resources:

  • Ground-based students are required to bring a late model laptop computer (either PC or MacBook) to class every day.

  • Online students are required to have a late model laptop or desktop computer with internet access.

  • Minimum: PC (Windows 10/11) or Mac (Big Sur or Monterey) laptop. 8GB ram, 512GB HD, Intel Core i5, AMD Ryzen 5, or Apple Intel or M1 Chipsets.

  • Recommended: PC (Windows 10/11) or Mac laptop(Big Sur or Monterey). 16GB ram, 1TB SSD, Intel Core i7, AMD Ryzen 7, or Apple M1/M1 Pro Chipsets.

  • Professionals: PC (Windows 10/11) or Mac(Big Sur or Monterey). 32-64 GB ram, 2-8TB SSD, Intel Core i9, AMD Ryzen 9/Threadripper, or Apple M1 Max Chipsets.

  • It is a requirement that you are able to download programming resources to your laptop/desktop for this class. (This means you need a steady internet high bandwidth connection.)

  • You are required to have a quiet place to study and to be able to focus on the material.

  • You are required to have uninterrupted weekly 1:1 video meetings with your mentor.

  • You are required to log into the Learning Management System (LMS) daily for at least 20 minutes.

Educational Objectives:

Upon successful completion of this course, students will be able to:

  1. Learn how Databases are used to store and provide data
  2. Learn Database Design Concepts
  3. Learn the components of a Database System
  4. Understand the reasons for using a Database
  5. Learn the differences between Relational and Non-relational databases
  6. Learn Basic Create, Read, Update, Delete operations
  7. Learn basic Security Practices for Database operations

Course Outline

  • L1: Introduction
  • L2: File Systems
  • L3: Databases
  • L4: Core Data
  • L5: Remote Persistence I
  • L6: Remote Persistence II
  • L7: Remote Persistence III
  • L8: Local & Remote
  • L9: Security & Authentication
  • L10: Final Project

Course Evaluation Strategies (Methodologies):

Professionalism, Attendance and Class Participation 5%

Assignments/Hands-On/Homework 95%

Total 100%