Go to Main Content

Purdue Self-Service

 

HELP | EXIT

Catalog Entries

 

Spring 2022
Mar 28, 2024
Transparent Image
Information Select the Course Number to get further detail on the course. Select the desired Schedule Type to find available classes for the course. The Schedule Type links will be available only when the schedule of classes is available for the selected term.

CS 50024 - Data Engineering II
Credit Hours: 1.00. 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.
1.000 Credit hours

Syllabus Available
Levels: Graduate, Professional, Undergraduate
Schedule Types: Distance Learning

Offered By: College of Science
Department: Computer Science

Course Attributes:
Upper Division

May be offered at any of the following campuses:     
      West Lafayette

Learning Outcomes: 1. Carry out database design steps from conceptual to logical to physical design. 2. Use 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. 3. Explain the differences, advantages, and disadvantages of relational and NOSQL databases. 4. Describe features of relational databases not needed in big data applications. 5. Create a document-based, NOSQL database like mongoDB and movie data from an SQL to a NOSQL database. 6. Understand the benefits and downsides of creating index structures on query performance for relational, and NOSQL databases. 7. Explain the difference between hash indices and B-tree indices. 8. Analyze large data sets created from piecing together multiple data files through the application of SQL queries.



Return to Previous New Search XML Extract
Transparent Image
Skip to top of page
Release: 8.7.2.4