CIS376
Preview: CIS376 SQL Programming :
Course Guide
Prerequisites
Course Description
Instructional Materials
Course Learning Outcomes
Weekly Course Schedule
Week 1 - To Do List
Discuss: Introduce yourself to your professor and classmates.
Learn: Read Exam
Ref
70-761
Querying
Data
with
Transact-SQL, Chapter 1, Skill 1.1.
Learn: View CBT Nuggets videos.
Discuss: Participate in the discussion, Referential Integrity.
Assignment: Complete CBT Nuggets Virtual Labs 4,6, and 7.
CIS111 (Introduction to Relational Database Management Systems)
This course covers the concept, design and components of querying databases using the Structured Query Language (SQL). It involves the creation of
tables, constraints, use of DML, use of DDL, and defining transactions.
Required Resources
Itzik Ben-Gan. 2017. Exam
Ref
70-761
Querying
Data
with
Transact-SQL. Pearson Education.
CBT Nuggets. No date. Microsoft MCSA SQL Server 2016 (70-761).
Note: student code is required and must be purchased through the Strayer Bookstore. The will distribute this code to each A Strayer Bookstore
registered student’s email address. Students should check their junk mail folder as well as their inbox folder for the email.
Execute SQL statements to select, filter, and aggregate data.
1
Perform advanced data query operations.
2
Program databases using SQL statements.
3
NOTE: The links in this document do not function. Please refer to your course to view/download linked content.
Week - To Do List 1
Quiz: Complete the Skill 1.1 Quiz.
Week - To Do List 2
Learn: Read Exam
Ref
70-761
Querying
Data
with
Transact-SQL, Chapter 1, Skill 1.2.
Learn: View CBT Nuggets videos.
Discuss: Participate in the discussion, Normalization.
Assignment: Complete CBT Nuggets Virtual Labs and 10. 8
Quiz: Complete the Skill 1.2 Quiz.
Week - To Do List 3
Learn: Read Exam
Ref
70-761
Querying
