Oreilly – Database Fundamentals LiveLessons 2023-9

توضیحات

مشخصات دوره

• ناشر: Oreilly
• مدرس: Eric Johnson
• سطح آموزش: مبتدی تا پیشرفته
• مدت زمان آموزش: 6 ساعت 42 دقیقه

سرفصل های دوره در تاریخ

• Introduction
  1. Database Fundamentals LiveLessons (Video Training): Introduction
• Lesson 1: Understanding Database Concepts
  1. Learning objectives
  2. 1.1 Understand tables
  3. 1.2 Understand and select primary keys
  4. 1.3 Understand foreign keys
• Lesson 2: Understanding Database Storage
  1. Learning objectives
  2. 2.1 Understand database normalization
  3. 2.2 Understand indexes and how they are used in databases
  4. 2.3 Configure non-clustered indexes
  5. 2.4 Configure clustered indexes
• Lesson 3: Creating Database Objects
  1. Learning objectives
  2. 3.1 Understand data definition language (DDL)
  3. 3.2 Choose appropriate data types
  4. 3.3 Create tables
  5. 3.4 Understand and create views
  6. 3.5 Understand and create stored procedures and functions
• Lesson 4: Manipulating Data
  1. Learning objectives
  2. 4.1 Understand data manipulation language (DML)
  3. 4.2 Read data using SELECT statements
  4. 4.3 Query multiple tables with join statements
  5. 4.4 Use UNION and INTERSECT statements
  6. 4.5 Add data using INSERT statements
  7. 4.6 Change data using UPDATE statements
  8. 4.7 Remove data using DELETE statements
• Lesson 5: Understanding Database Security
  1. Learning objectives
  2. 5.1 Understand the need for database security
  3. 5.2 Understand logins and users
  4. 5.3 Set permissions on database objects
  5. 5.4 Understand database roles
• Lesson 6: Understanding Database Backup and Restore
  1. Learning objectives
  2. 6.1 Understand different types of backups
  3. 6.2 Create and verify backups
  4. 6.3 Restore a database
  5. 6.4 Define a backup and recovery strategy
• Summary
  1. Database Fundamentals LiveLessons (Video Training): Summary

پیشنیاز های دوره

• Knowledge of Windows operating system
• IT background with no prior database experience

تصاویر دوره Database Fundamentals LiveLessons

نمونه فیلم دوره

لینک دانلود

دانلود بخش 1 – 1 گیگابایت

دانلود بخش 2 – 526 مگابایت

گذرواژه فایل(ها): www.downloadly.ir

حجم فایل

1.5 گیگابایت