Description
Book SynopsisDavid Kroenke has many years of teaching experience at Colorado State University, Seattle University, and the University of Washington. He has led dozens of seminars for college professors on the teaching of information systems and technology; in 1991, the International Association of Information Systems named him Computer Educator of the Year. In 2009, David was named Educator of the Year by the Association of Information Technology Professionals-Education Special Interest Group (AITP-EDSIG).
David worked for the US Air Force and Boeing Computer Services. He was a principal in the startup of three companies, serving as the vice president of product marketing and development for the Microrim Corporation and as chief of database technologies for Wall Data, Inc. He is the father of the semantic object data model. David's consulting clients have included IBM, Microsoft, and Computer Sciences Corporations, as well as numerous smaller companies. Recently, David h
Table of Contents
Part I: Getting Started
1. Introduction
2. Introduction to Structured Query Language
Part II: Database Design
3.The Relational Model and Normalization
4. Database Design Using Normalization
5. Data Modeling and the Entity-Relationship Model
6. Transforming Data Models in Database Designs
Part III: Database Implementation
7.SQL for Database Construction and Application Processing
8. Database Redesign
Part IV: Multiuser Database Processing
9. Managing Multiuser Databases
10.Managing Databases with SQL Server 2014, Oracle Database 12c, and MySQL 5.7
Online Chapter: 10A.Managing Databases with SQL Server 2014
Online Chapter: 10B.Managing Databases with Oracle 12c
Online Chapter: 10C.Managing Databases with MySQL 5.7
Part V: Database Access Standards
11. The Web Server Environment
12. Big Data, Data Warehouses, and Business Intelligence Systems
Online Appendix A. Getting Started with Microsoft Access 2013
Online Appendix B. Getting Started in Systems Analysis and Design
Online Appendix C. E-R Diagrams and the IDEF1X Standard
Online Appendix D. E-R Diagrams and the UML Standard
Online Appendix E. Getting Started with MySQL Workbench Data Modeling Tools
Online Appendix F. Getting Started with Microsoft Vision 2013
Online Appendix G. Data Structures for Database Processing
Online Appendix H. The Semantic Object Model
Online Appendix I. Getting Started with Web Servers, PHP and the Eclipse PDT
Online Appendix J. Business Intelligence Systems
Online Appendix K. Big Data
