Courses may be offered in one of the following modalities:
If you are enrolled in courses delivered in traditional or hybrid modalities, you will be expected to attend face-to-face instruction as scheduled.
Semester: | Fall 2024 |
Number: | 0145-263-001 |
Instructor: | Sukun Li |
Days: | Tuesday Thursday 9:25 am - 10:40 am |
Note: | Traditional In-Person Class |
Location: | Garden City - Swirbul Library 100 |
Credits: | 3 |
Status: | This Course is Filled to Capacity |
Course Materials: | View Text Books |
Description: |
Students manipulate structured data using different data management techniques, and analyze data requirements. Students learn to design relational databases and use SQL to define, query, and update them. Students explore non-relational schemaless databases, and query them. |
Learning Goals: |
Students will:• Have an appreciation of the role of data, files, and databases in information systems. This will be measured by Quizzes 1, 2, and the Mid-Term Examination.• Understand the database development activities during the System Development Life Cycle (SDLC). This will be measured by Quizzes 3, 4, and the Mid-Term Examination.• Be familiar with the data modeling concepts (Entity-Relationship and Class diagrams) that are used in database design. This will be measured by Quiz 5 and the Mid-Term Examination.• Be able to create databases and pose complex SQL queries of relational databases. This will be measured by Lab Assignments 1, 2, and the Final Examination.• Be knowledgeable about several Database Management Systems (DBMS's such as MSAccess, Microsoft SQL Server, and ORACLE). This will be measured by Quizzes 6, 7, and the Final Examination. *The learning goals displayed here are those for one section of this course as offered in a recent semester, and are provided for the purpose of information only. The exact learning goals for each course section in a specific semester will be stated on the syllabus distributed at the start of the semester, and may differ in wording and emphasis from those shown here. |
Prerequisites: |
» View Other Sections of this Course