Library: Library Resources for IT234: Required Readings

Readings

The following e-books can be found in the Skillsoft Books database. Direct links are below. See the Reading section of each module within your classroom for exact chapters.

Unit 1/Module 1

Davidson, L. (2016). Pro SQL server relational database design and implementation (5th ed). Apress.
Read: Chapter 4: “Conceptual and Logical Data Model Production”

Videos

Unit 2/Module 1

Taylor, A. (2019). SQL for dummies (9th ed.). John Wiley & Sons.
Read: Chapter 1: “Relational Database Fundamentals”
Davidson, L. (2016). Pro SQL server relational database design and implementation (5th ed). Apress.
Read: Chapter 5: “Normalization” in Pro SQL Server Relational Database Design and Implementation, Fifth Edition
Kellenberger, K. (2014). Beginning T-SQL, third edition. Apress.
Read: Chapter 2: “Exploring Database Concepts”

Videos

Unit 3/Module 2

Davidson, L. (2016). Pro SQL server relational database design and implementation (5th ed). Apress.
Read: Chapter 6: “Physical Model Implementation Case Study”
Taylor, A. (2019). SQL for dummies (9th ed.). John Wiley & Sons.
Read: Chapter 5: “Building a Multi-table Relational Database”

Videos

Unit 4/Module 2

Taylor, A. (2019). SQL for dummies (9th ed.). John Wiley & Sons.
Read Chapter 3: "The Components of SQL"

Videos

Unit 5/Module 2

Taylor, A. (2019). SQL for dummies (9th ed.). John Wiley & Sons.
Read: Chapter 6: “Manipulating Database Data"

Videos

Unit 6/Module 3

Kellenberger, K., & Shaw, S. (2014). Beginning T-SQL (3rd ed.). Apress.
Read Chapter 4: “Using Built-In Functions and Expressions”
Taylor, A. (2019). SQL for dummies (9th ed.). John Wiley & Sons.
Read: Chapter 6: “Manipulating Database Data”

Videos

Unit 7/Module 3

Taylor, A. (2019). SQL for dummies (9th ed.). John Wiley & Sons.
Read: Chapter 6: “Manipulating Database Data”

Videos

Unit 8/Module 4

Kellenberger, K., & Shaw, S. (2014). Beginning T-SQL (3rd ed.). Apress.
Read Chapter 5: “Joining Tables”
Taylor, A. (2019). SQL for dummies (9th ed.). John Wiley & Sons.
Read: Chapter 11: “Using Relational Operators” and Chapter 12: “Delving Deep with Nested Queries”

Videos

Unit 9/Module 4

Taylor, A. (2019). SQL for dummies (9th ed.). John Wiley & Sons.
Read: Chapter 14: “Providing Database Security” and Chapter 15: “Protecting Data”
Kellenberger, K., & Shaw, S. (2014). Beginning T-SQL (3rd ed.). Apress.
Read Chapter 13: “Managing Transactions” and Chapter 14: “Implementing Logic in the Database”

Videos

Unit 10/Module 5

Harrison, G. (2015). Next generation databases: NoSQL, NewSQL, and big data. Apress.
Read Chapter 1: “Three Database Revolutions” and Chapter 12: “Databases of the Future”

Videos

Library Resources for IT234

Purdue Global
Library
Library Guides
Library Resources for IT234
Required Readings

Readings

Unit 1/Module 1

Unit 2/Module 1

Unit 3/Module 2

Unit 4/Module 2

Unit 5/Module 2

Unit 6/Module 3

Unit 7/Module 3

Unit 8/Module 4

Unit 9/Module 4

Unit 10/Module 5

Find

Support

About

Library Resources for IT234

Purdue GlobalLibraryLibrary GuidesLibrary Resources for IT234Required Readings

Readings

Unit 1/Module 1

Unit 2/Module 1

Unit 3/Module 2

Unit 4/Module 2

Unit 5/Module 2

Unit 6/Module 3

Unit 7/Module 3

Unit 8/Module 4

Unit 9/Module 4

Unit 10/Module 5

Find

Support

About

Purdue Global
Library
Library Guides
Library Resources for IT234
Required Readings