JUSTCOMP Blog Bilişim Günlüğü

Learnkey – Database Specialist Design

Database (Veritabanı) öğrenmek veya öğretmek istiyorsanız Learnkey - Database Specialist Design görsel eğitim seti tam size göre! 3 CD ve yaklaşık 9 saatlik eğitimden oluşan bu görsel set Uzman Wayne Snyder'ın eğitici ve can sıkmayan sunumu ile öğrenci ve öğretmenlere ciddi bir kaynak durumunda! Bu seti 12. sınıfta Database Programming with ASP.NET dersinin giriş kısmında kullandım ve öğrencilerimin çok faydalandıklarını söyleyebilirim!

Şimdi de 3 CD içindeki konu başlıklarına göz atalım:

Session 1

• Section A: Introduction to Databases
  • What is a Database?
  • Flat File Databases
  • Relational Databases
  • RDMS & Disadvantages
• Section B: Relational Database Fundamentals
  • Application Components
  • Client & Server Tiers
  • Relational Model
  • Entities & Primary Keys
  • Data Modeling
  • Entry Types
  • Database Terminology
• Section C: Database Planning
  • Database Strategy
  • Design Application
  • Requirements Document
  • Interview Strategy
  • DBMS Selection
  • Application Interface
• Section D: Database Design Methodology
  • Design Problems
  • Anomalies
  • Phases of DB Design
  • Identify Entities
  • Identify Attributes & Domains
  • Relationships
  • Identify Relationships
  • Candidate & Primary Keys
  • Entity-Relationship Model
  • IE Model
  • Relationship Types
  • Chen Data Model
• Section E: Database Normalization
  • Normal Forms
  • First Normal Form Rules
  • Primary Key
  • Second Normal Form Rules
  • Using Second Normal Form
  • Third Normal Form Rules
  • Boyce-Codd Normal Form
  • Data Normalization

Session 2

• Section A: Logical Database Design
  • Identify Relationships
  • Resolve Many to Many Relationships
  • Complex Relationships
  • Recursive Relationships
  • Relationship Attributes
  • Redundant Relationships
  • Database Definition Language
  • Domain Definitions
  • Validate Logical Model
  • Referential Integrity
  • Foreign Key Constraints
  • Cascade, Set Null & Set Default
  • Data Integrity
• Section B: Physical Database Design
  • Using DDL & DBMS
  • Syntax Requirements
  • Enterprise Constraints
  • Using Constraints
  • Multiple Constraints
  • Constraints & Updates
  • Foreign Key Constraints
  • Secondary Indexes
  • Denormalization
  • Denormalize Foreign Keys
  • Creating User Views
  • Grant Statement
• Section C: Intro to SQL
  • Standards
  • Structured Query Language
  • Data Types

Session 3

• Section A: SQL
  • DDL
  • Create Schema & Alter Command
  • Alter & Drop Domain
  • DML & Insert & Delete
  • Update & Select
  • Using Select & Distinct
  • Where Clause
  • Using Where
  • Using Multiple Boolean Statements
  • Using Like Statements
  • Order-By Clause
  • DCL, Grant & Revoke
• Section B: Relational Algebra
  • Selection & Projection
  • Cartesian Product & Union
  • Difference & Intersection
  • Theta-Join & Equi-Join
  • Natural Join & Outer Join
  • Relationship Diagram
  • Using & Refining Joins
  • Distinct Join & Three-way Join
  • Using Outer Join
• Section C: Transactions & Database Security
  • Transaction
  • ACID Properties
  • Dirty Read 7 Non-repeatable Read
  • Phantom Reads
  • Serialability
  • Locking Timestamp & Optimistic Control
  • Security

Bu seti satın almanızı tavsiye etmekle beraber bir fikir edinmek için trackerdan indirebilirsiniz!