Comprehensive Video Tutorials

Database Specialist Design (Exam 1D0-441) Online Course (12 months Access)

CareerVision Training
Online

£ 288 - ($ 5.820)
+ IVA

Información importante

  • Curso
  • Online
  • Duración:
    Flexible
  • Cuándo:
    A definir
  • Campus online
Descripción

The following course, offered by Career vision, will help you improve your skills and achieve your professional goals. During the program you will study different subjects which are deemed to be useful for those who want to enhance their professional career. Sign up for more information!

Información importante
Sedes

Dónde se enseña y en qué fechas

inicio Ubicación
A definir
Online

¿Qué aprendés en este curso?

Access
IT
Database
Database training
Design

Temario

The Database Design course from LearnKey is fundamental training for those with no previous experience in database design. Expert instructor Wayne Snyder begins with basics of relational databases and uses examples, sample programs and clear step-by-step instruction to teach you database design methodology. At the conclusion of this course, you'll be familiar with the concepts underlying enterprise data model design.

  • Increase your potential with technical mastery and proficiency.
  • Enhance employment opportunities with database design skills.
  • This course meets the requirements to pass CIW exam 1D0-441.

  • Overview
  • Flat File Database
  • Relational Databases
  • RDBMS Benefits
  • RDBMS
  • RDBMS Disadvantages
  • Application Components
  • Two and Three Tier
  • Terminology and Entities
  • Primary Key
  • Data Model
  • Design Language
  • Strong and Weak Entities
  • Relationships
  • DB Design Life Cycle
  • Requirements Document
  • The Interviews
  • Choosing a DBMS
  • Application Interface
  • Design Problems
  • Design Phases
  • Conceptual Design
  • Sample Data Types
  • Model
  • Design Steps
  • Identify Relationships
  • Candidate/Primary Keys
  • Entity-Relationship Model
  • Information Engineering
  • Strong and Weak Entities
  • Relationships
  • Information Engineers
  • Chen Data Model
  • Overview
  • Normal Forms
  • First Normal Form Rules
  • Primary Key
  • First Normal Form
  • Second Normal Form
  • 2NF Rules
  • Functional Dependencies
  • Third Normal Form
  • Boyce-Codd Normal Form
  • Data Normalization
  • Identify Relationships
  • M:N Relationships
  • Complex Relationships
  • Recursive Relationships
  • Relationship Attributes
  • Redundant Relationships
  • DDL
  • Validate Logical Model
  • Data Integrity
  • Referential Integrity
  • Foreign Key Constraints
  • Insert, Update, Delete
  • Enterprise Data Model
  • Using a DDL
  • Create Table Code
  • Create Table
  • Enterprise Constraints
  • Multiple Constraints
  • Constraints and Updates
  • Foreign Key Constraints
  • Secondary Indexes
  • Denormalization
  • Nonkey Attributes
  • Foreign Keys
  • Aggregation
  • User and Employee View
  • Access Rules
  • Overview
  • SQL Subsets
  • SQL-supported Data Types
  • Overview
  • Schema
  • Alter and Drop
  • Insert
  • Delete
  • Update
  • Select
  • Select From
  • Select Distinct
  • Where Clause and amp; Operators
  • Between
  • Or, Not, Like, and amp; Wildcards
  • Brackets
  • Order By
  • Grant and Revoke
  • Overview
  • Selection and Projection
  • Cartesian Product
  • Union
  • Difference
  • Intersection
  • Theta Join and Equijoin
  • Natural and Outer Join
  • Database Diagram
  • Inner Join
  • Distinct and Join
  • Join Multiple Tables
  • Transaction
  • ACID Properties
  • Lost Update
  • Dirty Read
  • Nonrepeatable Read
  • Phantoms
  • Serializability
  • Control Methods
  • Concurrency Control
  • Database Security
  • Security Techniques
  • Transaction
  • ACID Properties
  • Lost Update
  • Dirty Read
  • Nonrepeatable Read
  • Phantoms
  • Serializability
  • Control Methods
  • Concurrency Control
  • Database Security
  • Security Techniques