Library: Library Resources for IT350: Required Readings

Note on this list

This list is for IT350 courses in terms 2004A (October 14, 2020) and forward.

Required Texts

Churcher, C. (2012). Beginning database design: From novice to professionals (2nd ed.). Springer.
more...less...
Beginning Database Design, Second Edition provides short, easy-to-read explanations of how to get database design right the first time. This book offers numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers. Through the help of use cases and class diagrams modeled in the UML, you'll learn to discover and represent the details and scope of any design problem you choose to attack. Database design is not an exact science. Many are surprised to find that problems with their databases are caused by poor design rather than by difficulties in using the database management software. Beginning Database Design, Second Edition helps you ask and answer important questions about your data so you can understand the problem you are trying to solve and create a pragmatic design capturing the essentials while leaving the door open for refinements and extension at a later stage. Solid database design principles and examples help demonstrate the consequences of simplifications and pragmatic decisions. The rationale is to try to keep a design simple, but allow room for development as situations change or resources permit. Provides solid design principles by which to avoid pitfalls and support changing needs Includes numerous examples of good and bad design decisions and their consequences Shows a modern method for documenting design using the Unified Modeling Language
Celko, J. (2015). Joe Celko's SQL for smarties: Advanced SQL programming (5th ed.). Morgan Kaufmann Publishers.
more...less...
SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 20 years later and in its fifth edition, this classic reference still reigns supreme as the only book written by a SQL master that teaches programmers and practitioners to become SQL masters themselves! These are not just tips and techniques; also offered are the best solutions to old and new challenges. Joe Celko conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance. New to the fifth edition, Joe features new examples to reflect the ANSI/ISO Standards so anyone can use it. He also updates data element names to meet new ISO-11179 rules with the same experience-based teaching style that made the previous editions the classics they are today. You will learn new ways to write common queries, such as finding coverings, partitions, runs in data, auctions and inventory, relational divisions and so forth. SQL for Smarties explains some of the principles of SQL programming as well as the code. A new chapter discusses design flaws in DDL, such as attribute splitting, non-normal forum redundancies and tibbling. There is a look at the traditional acid versus base transaction models, now popular in NoSQL products. You'll learn about computed columns and the DEFERRABLE options in constraints. An overview of the bi-temporal model is new to this edition and there is a longer discussion about descriptive statistic aggregate functions. The book finishes with an overview of SQL/PSM that is applicable to proprietary 4GL vendor extensions.
Kellenberger, K., & Shaw, S. (2014). Beginning T-SQL. Apress.
more...less...
Beginning T-SQL is a performance-oriented introduction to the T-SQL language underlying the Microsoft SQL Server database engine. T-SQL is essential in writing SQL statements to get data into and out of a database. T-SQL is the foundation for business logic embedded in the database in the form of stored procedures and functions. Beginning T-SQL starts you on the path to mastering T-SQL, with an emphasis on best-practices and sound coding techniques leading to excellent performance. This new edition is updated to cover the essential features of T-SQL found in SQL Server 2014, 2012, and 2008. Beginning T-SQL begins with an introduction to databases, normalization, and to SQL Server Management Studio. Attention is given to Azure SQL Database and how to connect to remote databases in the cloud. Each subsequent chapter teaches an aspect of T-SQL, building on the skills learned in previous chapters. Exercises in most chapters provide an opportunity for the hands-on practice that leads to true learning and distinguishes the competent professional. Important techniques such as windowing functions are covered to help write fast executing queries that solve real business problems. A stand-out feature in this book is that most chapters end with a "Thinking About Performance" section. These sections cover aspects of query performance relative to the content just presented. They'll help you avoid beginner mistakes by knowing about and thinking about performance from Day 1. Imparts best practices for writing T-SQL Helps you avoid common errors Shows how to write scalable code for good performance What you'll learn Grasp the fundamentals of relational theory, upon which T-SQL is based Write accurate queries that are scalable and perform well Combine set-based and procedural processing, obtaining the best from both worlds Embed business logic in your database through stored procedures and functions Simplify your work with new and advanced features, such as common table expressions and windowing functions Enhance performance by knowing when to apply features such as temporary tables, and when not to Who this book is for Beginning T-SQL is for developers and database administrators with little to no T-SQL experience who will be writing database applications and queries against SQL Server databases. Table of Contents 1. Getting Started 2. Exploring Database Concepts 3. Writing Simple SELECT Queries 4. Using Built-In Functions and Expressions 5. Joining Tables 6. Building on Subqueries and Unions 7. Grouping and Summarizing Data 8. Writing Window Functions 9. Advanced WHERE Clauses 10. Query Techniques 11. Manipulating Data 12. Managing Transactions 13. Learning Procedural T-SQL 14. Moving Logic to the Database 15. Working with XML 16. Working with Data Types 17. Writing Advanced Queries 18. Where to Next?
Cherry, D. (2015). Securing SQL Server: Protecting your database from attackers. Syngress Publishing.
more...less...
SQL server is the most widely-used database platform in the world, and a large percentage of these databases are not properly secured, exposing sensitive customer and business data to attack. In Securing SQL Server, Third Edition, you will learn about the potential attack vectors that can be used to break into SQL server databases as well as how to protect databases from these attacks. In this book, Denny Cherry - a Microsoft SQL MVP and one of the biggest names in SQL server - will teach you how to properly secure an SQL server database from internal and external threats using best practices as well as specific tricks that the author employs in his role as a consultant for some of the largest SQL server deployments in the world. Fully updated to cover the latest technology in SQL Server 2014, this new edition walks you through how to secure new features of the 2014 release. New topics in the book include vLANs, setting up RRAS, anti-virus installs, key management, moving from plaintext to encrypted values in an existing application, securing Analysis Services Objects, Managed Service Accounts, OS rights needed by the DBA, SQL Agent Security, Table Permissions, Views, Stored Procedures, Functions, Service Broker Objects, and much more.
van Rijmenam, M. (2014). Think bigger: Developing a successful big data strategy for your business. AMACOM.
more...less...
Every day, an increasing amount of our movements, transactions, and choices are becoming digitized and stored up into what has become known as "big data"--revolutionizing the way we do business today. And it's all there for your company to strategically utilize for giant profits! But where to begin?Think Bigger provides a roadmap for organizations looking to develop a profitable big data strategy. Sharing best practices from companies that have implemented a big data strategy including Walmart, InterContinental Hotel Group, Walt Disney, and Shell, this must-have resource for any business not wanting to fall far behind the competition covers the most important big data trends affecting organizations, as well as crucial types of analyses. Big data is changing the way businesses--and even governments--are operated and managed. And now, you too can revolutionize your business by learning how to properly employ the vast amount of digitalized information that is already available to you.
Lakhe, B. (2016). Practical Hadoop migration: How to integrate your RDBMS with the Hadoop ecosystem and re-architect relational applications to NoSQL. Apress.
more...less...
Re-architect relational applications to NoSQL, integrate relational database management systems with the Hadoop ecosystem, and transform and migrate relational data to and from Hadoop components. This book covers the best-practice design approaches to re-architecting your relational applications and transforming your relational data to optimize concurrency, security, denormalization, and performance. Winner of IBM's 2012 Gerstner Award for his implementation of big data and data warehouse initiatives and author of Practical Hadoop Security, author Bhushan Lakhe walks you through the entire transition process. First, he lays out the criteria for deciding what blend of re-architecting, migration, and integration between RDBMS and HDFS best meets your transition objectives. Then he demonstrates how to design your transition model. Lakhe proceeds to cover the selection criteria for ETL tools, the implementation steps for migration with SQOOP- and Flume-based data transfers, and transition optimization techniques for tuning partitions, scheduling aggregations, and redesigning ETL. Finally, he assesses the pros and cons of data lakes and Lambda architecture as integrative solutions and illustrates their implementation with real-world case studies. Hadoop/NoSQL solutions do not offer by default certain relational technology features such as role-based access control, locking for concurrent updates, and various tools for measuring and enhancing performance. Practical Hadoop Migration shows how to use open-source tools to emulate such relational functionalities in Hadoop ecosystem components. What You'll Learn Decide whether you should migrate your relational applications to big data technologies or integrate them Transition your relational applications to Hadoop/NoSQL platforms in terms of logical design and physical implementation Discover RDBMS-to-HDFS integration, data transformation, and optimization techniques Consider when to use Lambda architecture and data lake solutions Select and implement Hadoop-based components and applications to speed transition, optimize integrated performance, and emulate relational functionalities Who This Book Is For Database developers, database administrators, enterprise architects, Hadoop/NoSQL developers, and IT leaders. Its secondary readership is project and program managers and advanced students of database and management information systems.
deRoos, D., Zikopoulos, P. C., Brown, B., Coss, R., MeInyk, R. B. (2014). Hadoop for dummies. John Wiley & Sons.
more...less...
Let Hadoop For Dummies help harness the power of yourdata and rein in the information overload Big data has become big business, and companies and organizationsof all sizes are struggling to find ways to retrieve valuableinformation from their massive data sets with becoming overwhelmed.Enter Hadoop and this easy-to-understand For Dummiesguide. Hadoop For Dummies helps readers understand thevalue of big data, make a business case for using Hadoop, navigatethe Hadoop ecosystem, and build and manage Hadoop applications andclusters. Explains the origins of Hadoop, its economic benefits, and itsfunctionality and practical applications Helps you find your way around the Hadoop ecosystem, programMapReduce, utilize design patterns, and get your Hadoop cluster upand running quickly and easily Details how to use Hadoop applications for data mining, webanalytics and personalization, large-scale text processing, datascience, and problem-solving Shows you how to improve the value of your Hadoop cluster,maximize your investment in Hadoop, and avoid common pitfalls whenbuilding your Hadoop cluster From programmers challenged with building and maintainingaffordable, scaleable data systems to administrators who must dealwith huge volumes of information effectively and efficiently, thishow-to has something to help you with Hadoop.
Bhushan, M. (2018). Big data and Hadoop: Learn by example. BPB Publications.

Unit 1 / Module 1

Read:

Chapter 10: “Query Basics” in Beginning Database Design: From Novice to Professionals
Chapter 3: “Writing Simple SELECT Queries” in Beginning T-SQL
Chapter 5: “Joining Tables” in Beginning T-SQL

Videos:

Unit 2/ Module 2

Read:

Chapter 14: “Implementing Logic in the Database” in Beginning T-SQL
Chapter 6: ”VIEWs, Derived, and other Virtual Tables” in Joe Celko's SQL for Smarties: Advanced SQL Programming

Videos:

Unit 3/ Module 3

Read:

Chapter 7: “Grouping and Summarizing Data” in Beginning T-SQL
Chapter 23: ”Basic Aggregate Functions” in Joe Celko's SQL for Smarties: Advanced SQL Programming
Chapter 24: “Advance Descriptive Statistics” in Joe Celko's SQL for Smarties: Advanced SQL Programming

Videos:

Unit 4/ Module 4

Read:

Chapter 1: “Identifying Security Requirements” in Securing SQL Server: Protecting Your Database from Attackers
Chapter 5: “SQL Password Security” in Securing SQL Server: Protecting Your Database from Attackers
Chapter 6: “Securing the Instance” in Securing SQL Server: Protecting Your Database from Attackers

Videos:

Unit 5/ Module 4

Read:

Chapter 6: “Securing the Instance” in Securing SQL Server: Protecting Your Database from Attackers
Chapter 9: “SQL Injection Attacks” Securing SQL Server: Protecting Your Database from Attackers

Videos:

Unit 6/ Module 4

Read:

Chapter 4: “Database Encryption” in Securing SQL Server: Protecting Your Database from Attackers
Chapter 5: “SQL Password Security” in Securing SQL Server: Protecting Your Database from Attackers
Chapter 9: “SQL Injection Attacks” in Securing SQL Server: Protecting Your Database from Attackers
Chapter 15: “Securing Data” in Securing SQL Server: Protecting Your Database from Attackers

Videos:

Unit 7/ Module 5

Read:

Chapter 11: “User Interface” in Beginning Database Design: From Novice to Professionals

Videos:

Unit 8/ Module 6

Read:

Chapter 1: “The History of Big Data” in Think Bigger: Developing a Successful Big Data Strategy for Your Business
Chapter 2: “What Is Big Data?” in Think Bigger: Developing a Successful Big Data Strategy for Your Business
Chapter 3: “Big Data Trends” in Think Bigger: Developing a Successful Big Data Strategy for Your Business
Chapter 4: “Big Data Technologies” in Think Bigger: Developing a Successful Big Data Strategy for Your Business
Chapter 2: “Common Use Cases for Big Data in Hadoop” in Hadoop for Dummies

Videos:

Unit 9/ Module 6

Read:

Chapter 5: “The Hadoop Ecosystem” in Practical Hadoop Migration: How to Integrate Your RDBMS with the Hadoop Ecosystem and Re-Architect Relational Applications to NoSQL
Chapter 1: “Introducing Hadoop and Seeing What It's Good for” in Hadoop for Dummies
Bhushan - Chapter 3: “Basics of Hadoop” in Big Data and Hadoop: Learn by Example
Bhushan - Chapter 4: “Hadoop Installation (Step by Step)” in Big Data and Hadoop: Learn by Example
Bhushan - Chapter 6: “Hadoop Related Tools-I (Hbase & Cassandra)” in Big Data and Hadoop: Learn by Example

Videos:

Unit 10/ Module 6

Read:

Chapter 5: “Reading and Writing Data” in Hadoop for Dummies
Chapter 6: “MapReduce Programming” in Hadoop for Dummies
Chapter 7: “Frameworks for Processing Data in Hadoop—YARN and MapReduce” in Hadoop for Dummies

Videos:

Library Resources for IT350

Purdue Global
Library
Library Guides
Library Resources for IT350
Required Readings

Note on this list

Required Texts

Unit 1 / Module 1

Unit 2/ Module 2

Unit 3/ Module 3

Unit 4/ Module 4

Unit 5/ Module 4

Unit 6/ Module 4

Unit 7/ Module 5

Unit 8/ Module 6

Unit 9/ Module 6

Unit 10/ Module 6

Find

Support

About

Library Resources for IT350

Purdue GlobalLibraryLibrary GuidesLibrary Resources for IT350Required Readings

Note on this list

Required Texts

Unit 1 / Module 1

Unit 2/ Module 2

Unit 3/ Module 3

Unit 4/ Module 4

Unit 5/ Module 4

Unit 6/ Module 4

Unit 7/ Module 5

Unit 8/ Module 6

Unit 9/ Module 6

Unit 10/ Module 6

Find

Support

About

Purdue Global
Library
Library Guides
Library Resources for IT350
Required Readings