| Purdue
Global University Database Concepts -- IT
234
Course Description : This course prepares you to learn database
programming. You will be exposed to more advanced concepts of database
management systems and SQL programming language. This course will provide
you with the business context in which data is used and how it is
transformed into information. You will identify the information needs and
general usage of data within the modern business context and link the use
of relational database management systems to the data needs of the
organization. Quarter Credit Hours: 5 | Prerequisite: IT163
Information for Students
Syllabus -- see Brightspace
Netiquette
Annoucements:
Weekly Seminar Slides
Welcome and
Introduction
Week 1
Week 2
Week 3
Week 4
Week 5
Week 6
Week 7
Week 8
Week 9
Week 10
Links:
Data Lifecycle Management
Data
Lifecycle, Best Practices
Data Lifecycle Management (DLM)
Data Protection and Information Lifecycle Management
SQL Tutorial
Learn SQL
SQL Basics for
Beginners
SQL Query Cheet Sheet
SQL
Tutorial
SQL Tutorial for
Beginners
Interactive SQL Course
Data Storage
Data Storage: Emerging Technologies
Data Lakes vs. Data Warehouses
Data Security
Most Common Passwords
Spreadsheets vs. Databases
Relational Databases
Definition and Overview of ODBMS
Object-Oriented Databases and Advantages
JSON Databases
JSON
Interchange Standard
JSON vs. XML
What is JSON?
Data Maintenance vs. Data Cleansing
Tips to Maintaining Your Data
Data Management
History of Data Management
Data Management: A Cheat Sheet
Data Retention, Archiving and Disposing
Dos and Don'ts of Data Archiving
Data
Retention Best Practices
Data Retention
101
The Essentials of Data Retention: Policies, Plans, and Templates
Safe Data Destruction 101: Why Data Destruction is Necessary
Dispose of Information Properly
Secure Data Disposal and Destruction: 6 Methods
Data Disposal Laws
Database course at Buffalo State
|
