Required Websites

What is MongoDB? (2023) MongoDb
- This resource is basically a user’s manual for using MongoDb. It describes MongoDb and also explains how to store, query, transform, and secure access to your data. It is essentially a beginner’s guide to using MongoDb. The material in this article will help students complete the chapter quiz, in-class practice, and homework by helping them understand and utilize MongoDb. This resource aligns with Module Learning Objective 1: Be able to create an online MongoDB NoSQL database (MongoDB Atlas), Module Learning Objective 2: Load data into MongoDB, Module Learning Objective 3: Query data in MongoDB using MongoDB Compass, and Module Learning Objective 4: Utilize MongoDb to extract data from JSON files.
SQL - Indexes (n.d.) Tutorialspoint
- This resource is an introduction and overview of Indexing in a SQL database. It outlines four types of indexes, which are Unique, Single-Column, Composite, and Implicit indexes. It presents examples of how to create each type of index as well as the code needed to delete and index. It ends with situations when an index should be avoided. The material in this article will help students complete the chapter quiz, in-class practice, and homework by providing them with a very useful tool regarding indexes. This resource aligns with Module Learning Objective 5: Be able to create an index on a column, and Module Learning Objective 6: Understand the pros and cons of indexing.
Peterson, Richard (Updated December 9, 2023). Indexing in DBMS: What is, Types of Indexes with EXAMPLES. GURU99.
- This article defines and describes indexing, presents different types of indexing (see visualization below), and includes excellent examples of each while presenting helpful visualizations for all indexes.

Different types of indexing include Primary (including dense and sparse), clustering, and secondary indexes.

It outlines some advantages and disadvantages of indexing as well. The material in this article will help students complete the chapter quiz, in-class practice, and homework by providing them with basic knowledge of indexes in SQL servers. This resource aligns with Module Learning Objective 5: Be able to create an index on a column, and Module Learning Objective 6: Understand the pros and cons of indexing.

Required Media

SQL Index, Indexes in SQL, Database Index (YouTube Video, 9:56)