Sql Server Understanding Database Fundamentals 98 364

Focused View

2:06:22

14 View

01 Course Overview

01 Course Overview.mp4

01:51

02 Introduction

02 Introduction and What Is Microsoft SQL Server.mp4

01:16

03 SQL Server Versions Editions and SQL Server 2012 2014.mp4

02:19

04 SQL Server 2016 2017.mp4

01:17

05 Course Objectives Structure and Module Summary.mp4

01:56

03 Understanding Core Database Concepts

06 Introduction and What Is a Database.mp4

01:20

07 Types of Databases and Relation Database Concepts.mp4

02:16

08 Data Manipulation Language.mp4

02:52

09 Data Definition Language.mp4

03:11

10 Demo Tables and Columns.mp4

02:58

11 Module Summary.mp4

01:03

04 How to Create Database Objects

12 Introduction and What Are Data Types.mp4

01:48

13 Exact and Approximate Numerics.mp4

04:12

14 Unicode and Binary Strings.mp4

01:35

15 Date Time Character Strings and Other Data Types.mp4

04:09

16 Demo Data Types.mp4

02:34

17 Tables and Views.mp4

01:29

18 Demo Tables and Views.mp4

04:14

19 Stored Procedures and Functions.mp4

03:17

20 Demo Stored Procedures and Functions.mp4

03:22

21 Module Summary.mp4

00:49

05 Manipulating Data

22 Introduction and Selecting Data.mp4

02:38

23 Demo SELECT Statements.mp4

04:49

24 UPDATE Statement.mp4

00:51

25 Demo UPDATE Statement.mp4

02:03

26 DELETE and TRUNCATE Statements.mp4

01:00

27 Demo DELETE and TRUNCATE Statements.mp4

01:33

28 INSERT Statement.mp4

00:48

29 Demo INSERT Statement.mp4

02:23

30 Module Summary.mp4

00:49

06 Understanding Data Storage

31 Introduction and Normalization.mp4

02:05

32 Forms of Normalizaton.mp4

03:27

33 Primary Foreign and Composite Keys.mp4

01:34

34 Demo Primary Foreign and Composite Keys.mp4

01:55

35 Module Summary.mp4

01:09

07 How to Administer a Database

36 Introduction and Authentication.mp4

02:46

37 Users.mp4

03:02

38 Database Permissions.mp4

02:27

39 Objects and Permissions.mp4

02:02

40 Database Roles.mp4

02:06

41 Demo Users Roles and Permissions.mp4

05:52

42 Maintenance Tasks.mp4

04:36

43 Demo Maintenance Processes.mp4

06:21

44 Backups and Disaster Recovery.mp4

04:08

45 Demo Backup Restore and Recovery Models.mp4

13:29

46 Module and Course Summary.mp4

02:41

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.