Oreilly – Database Fundamentals LiveLessons 2023-9

Oreilly – Database Fundamentals LiveLessons 2023-9 Downloadly IRSpace

Apr 17, 2025 - 19:46 Updated: Apr 21, 2025 - 09:49

0 0

Oreilly – Database Fundamentals LiveLessons 2023-9

Database Fundamentals LiveLessons course. In this training course, you will learn the basic concepts of databases and learn how to work with them. Also, you will get the necessary preparation to take Microsoft’s MTA 98-364 exam.

SQL Server database expert Eric Johnson guides you from basic database concepts such as tables and indexes to the fundamentals of database design and layout. Building on this foundation, you will learn how to perform more advanced skills such as database management, backup and security. The course topics are organized in such a way that they are easy to understand and you can easily learn these skills. This video course, along with additional study, will help you gain the hands-on experience you need to take the exam and demonstrate your mastery of database fundamentals.

What you will learn:

Understand database storage concepts
Perform database normalization
Create database objects
Manipulate data in databases
Secure the database
Backup and restore databases

This course is suitable for people who:

Developers and system administrators who have no prior experience working with databases

Course details

Publisher: Oreilly
Instructor: Eric Johnson
Training level: beginner to advanced
Training duration: 6 hours 42 minutes

Course headings in history

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

Course prerequisites

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

Images of Database Fundamentals LiveLessons course

Database Fundamentals LiveLessons

Sample video of the course

Installation guide

After Extract, view with your favorite Player.

English subtitle

Quality: 720p

download link

Download part 1 – 1 GB

Download part 2 – 526 MB

File(s) password: www.downloadly.ir

Size

1.5 GB

Oreilly – Database Fundamentals LiveLessons 2023-9