Database Fundamentals

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

Introduction

001. Database Fundamentals LiveLessons (Video Training) Introduction

Lesson 1 Understanding Database Concepts

001. Learning objectives

002. 1.1 Understand tables

003. 1.2 Understand and select primary keys

004. 1.3 Understand foreign keys

Lesson 2 Understanding Database Storage

001. Learning objectives

002. 2.1 Understand database normalization

003. 2.2 Understand indexes and how they are used in databases

004. 2.3 Configure non-clustered indexes

005. 2.4 Configure clustered indexes

Lesson 3 Creating Database Objects

001. Learning objectives

002. 3.1 Understand data definition language (DDL)

003. 3.2 Choose appropriate data types

004. 3.3 Create tables

005. 3.4 Understand and create views

006. 3.5 Understand and create stored procedures and functions

Lesson 4 Manipulating Data

001. Learning objectives

002. 4.1 Understand data manipulation language (DML)

003. 4.2 Read data using SELECT statements

004. 4.3 Query multiple tables with join statements

005. 4.4 Use UNION and INTERSECT statements

006. 4.5 Add data using INSERT statements

007. 4.6 Change data using UPDATE statements

008. 4.7 Remove data using DELETE statements

Lesson 5 Understanding Database Security

001. Learning objectives

002. 5.1 Understand the need for database security

003. 5.2 Understand logins and users

004. 5.3 Set permissions on database objects

005. 5.4 Understand database roles

Lesson 6 Understanding Database Backup and Restore

001. Learning objectives

002. 6.1 Understand different types of backups

003. 6.2 Create and verify backups

004. 6.3 Restore a database

005. 6.4 Define a backup and recovery strategy

Summary

001. Database Fundamentals LiveLessons (Video Training) Summary

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: LiveLessons