Library: Library Resources for HI520: Readings

About this list

This page was created to help you locate items in the PG Library. See your classroom for a complete list of required materials.

Links on this page have character limits and other system restrictions that prevent complete accuracy and compliance with APA Style. Some links are not in APA Style at all. For help with APA citation style, visit Academic Writer.

Readings

Please see the Readings section of your HI520 classroom for a complete list of assigned readings.

Unit 1

Oppel, A. (2010). Databases DeMYSTiFieD (2nd ed.). McGraw-Hill.
Please read:
Chapter 1: Database Fundamentals
Chapter 2: Exploring Relational Database Components
Chapter 5: The Database Life Cycle
Kellenberger, K. &, Everest, L. (2020). Beginning T-SQL: A step-by-step approach (4th ed.). Oracle Press.
Please read:
Chapter 2: Exploring Database Concepts
Sampson, A. (2015). Introduction to SQL: Introduction to the database concept [Video]. Skillsoft.
(10 mins)
Sampson, A. (2015). Introduction to SQL: The relation of data and the various databases [Video]. Skillsoft.
(9 mins)

Unit 2

Oppel, A. (2010). Databases DeMYSTiFieD (2nd ed.). McGraw-Hill.
Please read:
Chapter 2: Exploring Relational Database Components
Chapter 7: Data and Process Modeling
Sampson, A. (2015). Generic design and modeling databases: Database design methodology [Video]. Skillsoft.
(7 mins)
Sampson, A. (2015). Generic design and modeling databases: Overview of creating a conceptual design [Video]. Skillsoft.
(3 mins)
Sampson, A. (2015). Generic design and modeling databases: Creating an ERD for designing a database [Video]. Skillsoft.
(10 mins)
Sampson, A. (2015). Generic design and modeling databases: Defining entities [Video]. Skillsoft.
(7 mins)
Sampson, A. (2015). Generic design and modeling databases: Determining entities [Video]. Sklilsoft.
(3 mins)
Sampson, A. (2015). Generic design and modeling databases: Defining attributes [Video]. Skillsoft.
(8 mins)
Sampson, A. (2015). Generic design and modeling databases: Determining attributes and keys [Video]. Skillsoft.
(7 mins)
Sampson, A. (2015). Generic design and modeling databases: Data modeling [Video]. Skillsoft.
(8 mins)
Sampson, A. (2015). Generic design and modeling databases: Defining relationships [Video]. Skillsoft.
(6 mins)
Sampson, A. (2015). Generic design and modeling databases: Determining relationships in an ERD [Video]. Skillsoft.
(8 mins).

Unit 3

Oppel, A. (2010). Databases DeMYSTiFieD (2nd ed.). McGraw-Hill.
Please read:
Chapter 6: Logical Database Design Using Normalization
Chapter 7: Data and Process Modeling
Sampson, A. (2015). Generic design and modeling databases: Overview of the logical data model [Video]. Skillsoft.
(7 mins)
Sampson, A. (2015). Generic design and modeling databases: Defining the data type [Video]. Skillsoft.
(7 mins)
Sampson, A. (2015). Generic design and modeling databases: Defining keys for tables [Video]. Skillsoft.
(9 mins)
Sampson, A. (2015). Generic design and modeling databases: Defining constraints and nullability [Video]. Skillsoft.
(7 mins)
Sampson, A. (2016). Transact-SQL: NULL value overview [Video]. Skillsoft.
(6 mins)
Sampson, A. (2015). Generic design and modeling databases: First normal form [Video]. Skillsoft.
(8 mins)
Sampson, A. (2015). Generic Design and Modeling Databases: Second Normal Form [Video]. Skillsoft.
(7 mins)
Sampson, A. (2015). Generic design and modeling databases: Third normal form [Video]. Skillsoft.
(6 mins)

Unit 4

Oppel, A. (2010). Databases DeMYSTiFieD (2nd ed.). McGraw-Hill
Please read:
Chapter 7: Data and Process Modeling
Chapter 8: Physical Database Design
Kellenberger, K. &, Everest, L. (2020). Beginning T-SQL: A step-by-step approach (4th ed.). Oracle Press.
Please read Appendix B: Using SSMS
Sampson, A. (2015). Generic design and modeling databases: Overview of the physical data model [Video]. Skillsoft.
(7 mins)
Sampson, A. (2016). Transact-SQL: SQL server management studio [Video]. Skillsoft.
(10 mins)
Sampson, A. (2015). SQL server database fundamentals: Introducing SQL server management studio (SSMS) [Video]. Skillsoft.
(8 mins)

Unit 5

Kellenberger, K. &, Everest, L. (2020). Beginning T-SQL: A step-by-step approach (4th ed.). Oracle Press.
Please read Chapter 10: Manipulating Data
Viescas, J. (2018). SQL queries for mere mortals: A hands-on guide to data manipulation in SQL (4th ed.). Addison-Wesley.
Please read:
Chapter 15: Updating Sets of Data
Chapter 16: Inserting Sets of Data
Chapter 17: Deleting Sets of Data
Sampson, A. (2018). DDL statements: Data definition language (DDL) statements [Video]. Skillsoft.
(3 mins)
Sampson, A. (2016). Transact-SQL: T-SQL statements [Video]. Skillsoft.
(3 mins)
Sampson, A. (2015). SQL server database fundamentals: Creating databases [Video]. Skillsoft.
(9 mins)
Sampson, A. (2015). SQL server database fundamentals: Table design [Video]. Skillsoft.
(9 mins).
Sampson, A. (2015). SQL server database fundamentals: Creating tables [Video]. Skillsoft.
(6 mins)
Sampson, A. (2015). SQL server database fundamentals: Column design [Video]. Skillsoft.
(7 mins)
Sampson, A. (2016). Transact-SQL: Add data using INSERT [Video]. Skillsoft.
(9 mins)
Sampson, A. (2016). Transact-SQL: Modify data using UPDATE and MERGE [Video]. Skillsoft.
(9 mins)
Sampson, A. (2016). Transact-SQL: Remove data using DELETE and TRUNCATE [Video]. Skillsoft.
(4 mins)

Unit 6

Kellenberger, K. &, Everest, L. (2020). Beginning T-SQL: A step-by-step approach (4th ed.). Oracle Press.
Please read:
Chapter 3: Writing Simple SELECT Queries
Chapter 9: Advanced WHERE Clauses
Viescas, J. (2018). SQL Queries for mere mortals: A hands-on guide to data manipulation in SQL (4th ed.). Addison-Wesley
Please read:
Chapter 4: Creating a Simple Query
Chapter 6: Filtering Your Data
Sampson, A. (2016). Transact-SQL: SELECT statements overview [Video]. Skillsoft.
(6 mins)
Sampson, A. (2016). Transact-SQL: Elements of a SELECT statement [Video]. Skillsoft.
(6 mins)
Sampson, A. (2016). Transact-SQL: SELECT DISTINCT syntax [Video]. Skillsoft.
(3 mins)
Sampson, A. (2016). Transact-SQL: Writing SELECT statements in SQL server 2016 [Video]. Skillsoft.
(4 mins)

Unit 7

Kellenberger, K. &, Everest, L. (2020). Beginning T-SQL: A step-by-step approach (4th ed.). Oracle Press.
Please read:
Chapter 4: Using Built-in Functions and Expressions
Chapter 7: Grouping and Summarizing Data
Viescas, J. (2018). SQL Queries for Mere Mortals: A hands-on guide to data manipulation in SQL (4th ed.). Addison-Wesley.
Please read:
Chapter 12: Simple Totals
Chapter 13: Grouping Data
Sampson, A. (2016). Transact-SQL: T-SQL expressions [Video]. Skillsoft.
(5 mins)
Sampson, A. (2016). Transact-SQL: Calculated expressions [Video]. Skillsoft.
(8 mins)
Sampson, A. (2016). Transact-SQL: Aggregate functions [Video]. Skillsoft.
(4 mins)
Sampson, A. (2016). Transact-SQL: Group by overview [Video]. Skillsoft. )
(8 mins
Sampson, A. (2016). Transact-SQL: Group by workflow [Video]. Skillsoft.
(5 mins)
Sampson, A (2016). Transact-SQL: Having clause [Video]. Skillsoft.
(7 mins)

Unit 8

Kellenberger, K. &, Everest, L. (2020). Beginning T-SQL: A step-by-step approach (4th ed.). Oracle Press.
Please read Chapter 5: Joining Tables
Viescas, J. (2018). SQL Queries for mere mortals: A hands-on guide to data manipulation in SQL (4th ed.). Addison-Wesley.
Please read:
Chapter 7: Thinking in Sets
Chapter 8: INNER JOINs
Chapter 9: OUTER JOINs
Sampson, A. (2016). Transact-SQL: Joins overview [Video]. Skillsoft.
(8 mins)
Sampson, A. (2016). Transact-SQL: Querying with inner joins [Video]. Skillsoft.
(7 mins)
Sampson, A. (2016). Transact-SQL: Querying with left outer joins [Video]. Skillsoft.
(7 mins)
Sampson, A. (2016). Transact-SQL: Querying with right outer joins [Video]. Skillsoft.
(8 mins)

Unit 9

Kellenberger, K. &, Everest, L. (2020). Beginning T-SQL: A step-by-step approach (4th ed.). Oracle Press.
Please read Chapter 6: Building on Subqueries, Common Table Expressions, and Unions
Viescas, J. (2018). SQL Queries for mere mortals: A hands-on guide to data manipulation in SQL (4th ed.). Addison-Wesley
Please read:
Chapter 10: UNIONs
Chapter 11: Subqueries
Sampson, A. (2016). Transact-SQL: Subqueries overview [Video]. Skillsoft.
(6 mins)
Sampson, A. (2016). Transact-SQL: Writing effective scalar subqueries [Video]. Skillsoft.
(5 mins)
Sampson, A. (2016). Transact-SQL: Writing correlated subqueries [Video]. Skillsoft
(9 mins)
Sampson, A. (2016). Transact-SQL: Multi-valued subqueries [Video]. Skillsoft.
(7 mins)
Sampson, A. (2016). Transact-SQL: Writing queries that use the UNION operator [Video]. Skillsoft.
(8 mins)
Summers, J. (2013). Microsoft SQL server 2012: CTE functions [Video]. Skillsoft.
(2 mins)

Unit 10

Kellenberger, K. &, Everest, L. (2020). Beginning T-SQL: A step-by-step approach (4th ed.). Oracle Press.
Please read Chapter 6: Building on Subqueries, Common Table Expressions, and Unions
Clark, G.E. (2015). Microsoft SQL server 2014: Creating a report in report builder [Video]. Skillsoft.
(6 mins)
Clark, G.E. (2015). Microsoft SQL server 2014: Modifying an existing report in report builder [Video]. Skillsoft.
(3 mins)
Clark, G.E. (2015). Microsoft SQL server 2014: Filtering, grouping, and sorting data in report builder [Video]. Skillsoft.
(8 mins)
Clark, G.E. (2015). Microsoft SQL server 2014: Adding interactive features in report builder [Video]. Skillsoft.
(5 mins)
Clark, G.E. (2015). Microsoft SQL server 2014: Adding images, charts, gauges, and indicators in report builder [Video]. Skillsoft.
(11 mins)

Library Resources for HI520

Purdue University Global
Library
Library Guides
Library Resources for HI520
Readings

About this list

Readings

Unit 1

Unit 2

Unit 3

Unit 4

Unit 5

Unit 6

Unit 7

Unit 8

Unit 9

Unit 10

SEARCH

EBSCO DISCOVERY SERVICE

SUPPORT

ABOUT

Library Resources for HI520

Purdue University GlobalLibraryLibrary GuidesLibrary Resources for HI520Readings

About this list

Readings

Unit 1

Unit 2

Unit 3

Unit 4

Unit 5

Unit 6

Unit 7

Unit 8

Unit 9

Unit 10

SEARCH

EBSCO DISCOVERY SERVICE

SUPPORT

ABOUT

Purdue University Global
Library
Library Guides
Library Resources for HI520
Readings