Practical Guide to Database Design
-10%
portes grátis
Practical Guide to Database Design
Hogan, Rex
Taylor & Francis Ltd
03/2018
414
Dura
Inglês
9781138578067
15 a 20 dias
Descrição não disponível.
1. Overview of Databases 1.1 What's a "Database"? 1.2 Guranteed Accuracy and Availability of Data 1.3 Dynamic alteration of design 1.4 Dynamic Queries - any data, any time 1.5 Referential Integrity Enforcement 1.6 Backup/Recovery 1.7 Failover 1.8 Typical Installation 2. Normalization 2.1 Introduction 2.2 The "Language of Normalization" 2.3 Creating the Entity/Attribute List 2.4 Cleaning Up the Entity/Attribute List 2.5 Normalization 2.6 Creating the Data Model 2.7 Fourth Normal Form 2.8 Fifth Normal Form 3. Database Implementation 3.1 Logical to Physical Design 3.2 Usage Path Analysis 3.3 Table Key and Column Data Types 3.4 Indexes 3.5 Table Creation 4. Normalization and Physical Design Exercise 4.1 Introduction 4.2 Creating the Entity/Attribute List 4.3 First Normal Form 4.4 The Logical Data Model 4.5 Second Normal Form 4.6 Third Normal Form 4.7 The Physical Data Model 5. The erwin Data Modeling Tool 5.1 What is a Data Modeling Tool? 5.2 Why do I need a Data Modeling Tool? 5.3 Reverse Engineering 5.4 Change Management 5.5 Download and Install erwin Trial Software 5.6 Create the University Logical Data Model 5.7 Create the University Physical Data Model 5.9 Create a SQL Server University Database 6. Using Microsoft Access 6.1 Overview 6.2 Modifications to the Database Design 6.3 Loading Data Into Tables 6.4 Creating Queries 6.5 Using Forms 6.6 Generating Reports 6.7 Deploying Access for a Team of Users 6.8 The Role of Pass-Thru Queries 7. Using SQL Server 7.1 Overview 7.2 Database Creation/Installation 7.3 Creating Databases 7.4 User Roles 7.5 Authorized Users 7.6 Backup/Recovery 7.7 Loading Data Into Tables 7.8 Creating Views 7.9 Manual Queries and Edits 7.10 Using Stored Procedures 7.11 Using SQL Server Agent 8. Using Perl to Extract and Load Data 8.1 Why Perl? 8.2 Perl vs. Python 8.3 Windows vs Unix 8.4 Review key matching features 8.5 Monitor SQL Server logs 8.6 Monitoring Windows Logs 8.7 Other Applications and Uses 8.8 Loading Data into Tables 8.9 Summary 9. Building User Interfaces 9.1 Used in Typical Office Environment 9.2 Use Microsoft Access as GUI 9.3 .NET Framework 9.4 PHP 9.5 JAVA 10. Creating the University Database Application 10.1 Create tables for University environment 10.2 Create Relationships to Enforce Referential Integrity 10.3 Design a Screen to Add New Students 10.4 Create a Screen to Enroll Students in a Class 10.5 Create a Screen to Assign Grades 10.6 Create Screens to Enter Midterm and Final Grades 10.7 Create a "Main" Menu 10.8 Developing Applications for University Administrators 11. PHP Implementation and Used 11.1 Why PHP? 11.2 System Components 11.3 Design of Web-based Interface 11.4 Script Logic
Este título pertence ao(s) assunto(s) indicados(s). Para ver outros títulos clique no assunto desejado.
1. Overview of Databases 1.1 What's a "Database"? 1.2 Guranteed Accuracy and Availability of Data 1.3 Dynamic alteration of design 1.4 Dynamic Queries - any data, any time 1.5 Referential Integrity Enforcement 1.6 Backup/Recovery 1.7 Failover 1.8 Typical Installation 2. Normalization 2.1 Introduction 2.2 The "Language of Normalization" 2.3 Creating the Entity/Attribute List 2.4 Cleaning Up the Entity/Attribute List 2.5 Normalization 2.6 Creating the Data Model 2.7 Fourth Normal Form 2.8 Fifth Normal Form 3. Database Implementation 3.1 Logical to Physical Design 3.2 Usage Path Analysis 3.3 Table Key and Column Data Types 3.4 Indexes 3.5 Table Creation 4. Normalization and Physical Design Exercise 4.1 Introduction 4.2 Creating the Entity/Attribute List 4.3 First Normal Form 4.4 The Logical Data Model 4.5 Second Normal Form 4.6 Third Normal Form 4.7 The Physical Data Model 5. The erwin Data Modeling Tool 5.1 What is a Data Modeling Tool? 5.2 Why do I need a Data Modeling Tool? 5.3 Reverse Engineering 5.4 Change Management 5.5 Download and Install erwin Trial Software 5.6 Create the University Logical Data Model 5.7 Create the University Physical Data Model 5.9 Create a SQL Server University Database 6. Using Microsoft Access 6.1 Overview 6.2 Modifications to the Database Design 6.3 Loading Data Into Tables 6.4 Creating Queries 6.5 Using Forms 6.6 Generating Reports 6.7 Deploying Access for a Team of Users 6.8 The Role of Pass-Thru Queries 7. Using SQL Server 7.1 Overview 7.2 Database Creation/Installation 7.3 Creating Databases 7.4 User Roles 7.5 Authorized Users 7.6 Backup/Recovery 7.7 Loading Data Into Tables 7.8 Creating Views 7.9 Manual Queries and Edits 7.10 Using Stored Procedures 7.11 Using SQL Server Agent 8. Using Perl to Extract and Load Data 8.1 Why Perl? 8.2 Perl vs. Python 8.3 Windows vs Unix 8.4 Review key matching features 8.5 Monitor SQL Server logs 8.6 Monitoring Windows Logs 8.7 Other Applications and Uses 8.8 Loading Data into Tables 8.9 Summary 9. Building User Interfaces 9.1 Used in Typical Office Environment 9.2 Use Microsoft Access as GUI 9.3 .NET Framework 9.4 PHP 9.5 JAVA 10. Creating the University Database Application 10.1 Create tables for University environment 10.2 Create Relationships to Enforce Referential Integrity 10.3 Design a Screen to Add New Students 10.4 Create a Screen to Enroll Students in a Class 10.5 Create a Screen to Assign Grades 10.6 Create Screens to Enter Midterm and Final Grades 10.7 Create a "Main" Menu 10.8 Developing Applications for University Administrators 11. PHP Implementation and Used 11.1 Why PHP? 11.2 System Components 11.3 Design of Web-based Interface 11.4 Script Logic
Este título pertence ao(s) assunto(s) indicados(s). Para ver outros títulos clique no assunto desejado.
