Getting Started with Your First SQL Server Instance

Focused View

Kevin Hill

2:00:44

0 View

01. Course Overview

01. Course Overview.mp4

01:22

02. Introducing SQL Server

01. Introduction.mp4

00:45

02. SQL Server Beginnings.mp4

03:32

03. Current and Future Versions.mp4

03:45

04. SQL Server Services.mp4

02:38

05. Databases and Files.mp4

04:34

06. The SQL Triad.mp4

03:43

07. Tools and Utilities.mp4

04:52

08. Logical Structures.mp4

04:23

09. Versions vs. Editions.mp4

02:02

10. Summary and Additional Resources.mp4

00:57

03. Installing SQL Server 2017 Developer Edition

01. Introduction.mp4

00:46

02. Prerequisites and Downloads.mp4

03:50

03. Demo- Installing SQL Server.mp4

17:32

04. Management Studio Install.mp4

01:23

05. Demo- SSMS Install and Instance Verification.mp4

08:05

06. Summary and Additional Resources.mp4

01:43

04. Understanding the Different SQL Server Tools and Utilities

01. Overview.mp4

00:41

02. Configuration Manager - Services.mp4

06:36

03. Configuration Manager - Networking.mp4

04:37

04. SSMS - Open and Connect.mp4

04:22

05. SSMS - Instance Properties.mp4

04:39

06. SSMS - Databases.mp4

06:44

07. SSMS - Security.mp4

03:07

08. SSMS - Maintenance Plans.mp4

01:46

09. SSMS - Errorlogs and Database Mail.mp4

02:00

10. SSMS - SQL Agent and Jobs.mp4

02:09

11. SSMS - More Options.mp4

00:39

05. Configuring Your SQL Server Instance

01. Welcome and Overview.mp4

00:53

02. Demo Introduction.mp4

01:04

03. Demo- Backup Compression and Maintenance Plan.mp4

04:14

04. Demo- CheckDB Plan.mp4

02:41

05. Demo- MAX Memory and Cost Threshold.mp4

02:52

06. Demo- Instant File Initialization.mp4

03:38

06. Summary and Resources

01. Summary and Resources.mp4

02:10

Description

This course will teach you the basics of SQL Server architecture, installation, tools, and configuration in order to help you understand SQL Server administration.

What You'll Learn?

At the core of SQL Server is a thorough knowledge of database administration. In this course, Getting Started with Your First SQL Server Instance, you’ll learn the basics of installing and configuring SQL Server 2017. First, you’ll learn SQL Server history and architecture. Next, you’ll explore how to install SQL Server 2017. Then, you’ll discover how to use the SQL Server Tools. Finally, you’ll discover how to do basic SQL Server configuration. When you’re finished with this course, you’ll have a basic knowledge of SQL Server that will help you move forward in your understanding of database administration.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft SQL

Kevin Hill

Instructor's Courses

Kevin Hill is a career SQL Server DBA living in Dallas, TX. His specialties include HA/DR, Best Practice configuration, Performance tuning and teaching new and accidental DBAs

Pluralsight

View courses Pluralsight

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.