1 credit
Summer 2025 Distance Learning Upper Division
This course introduces students to the fundamentals of database management systems (DBMS) from a user's perspective. The principles of modeling an enterprise using Entity-Relationship diagrams and transforming the model into a relational or NoSQL database are illustrated through a range of examples. The SQL language is used to create, query, aggregate, and update a relational database. NOSQL databases and the related data models (column, graph, and document-based) are introduced. Experience in Python Programming is required.
Learning Outcomes1Carry out database design steps from conceptual to logical to physical design.
2Use SQL commands to define the structure of a relational database, populate, update and delete data in the database, retrieve data having specified characteristics, and specify access control.
3Explain the differences, advantages, and disadvantages of relational and NOSQL databases.
4Describe features of relational databases not needed in big data applications.
5Create a document-based, NOSQL database like mongoDB and movie data from an SQL to a NOSQL database.
6Understand the benefits and downsides of creating index structures on query performance for relational, and NOSQL databases.
7Explain the difference between hash indices and B-tree indices.
8Analyze large data sets created from piecing together multiple data files through the application of SQL queries.
Restrictions
made by Purdue students.