Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

Microsoft SQL Server 101

Shaun Stuart

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
41 Videos (4h 50m)
    • Introduction

      2:24
    • What Is A Database Management System?

      5:42
    • Microsoft SQL Server

      5:33
    • Microsoft SQL Server Licensing

      1:36
    • SQL Server Managment Studio (SSMS)

      8:29
    • SQL Server System Databases

      4:30
    • Data And Log Files

      15:23
    • Data and Log File Growth Settings

      6:14
    • Filegroups And Full Text Indexes

      4:38
    • Database Settings

      6:28
    • Recovery Models and Backup Types

      11:09
    • Backup And Restore Demo

      6:55
    • An Introduction To SQL Server Agent

      13:47
    • Management Features In SSMS

      14:43
    • The Dedicated Administrator Connection

      5:55
    • Database Objects: Tables

      7:30
    • Database Objects: Views

      4:58
    • Database Objects: Indexes

      22:30
    • Database Objects: Stored Procedures And Other Objects

      15:14
    • Security: Built-In Security Roles and Schemas

      22:24
    • Security: Schema Demo

      3:44
    • Reducing Database Size With Data Compression

      6:04
    • High Availability Solutions: Clustering

      5:14
    • High Availability Solutions: Replication

      4:42
    • High Availability Solutions: Log Shipping

      1:58
    • High Availability Solutions: Mirroring

      7:18
    • High Availability Solutions: AlwaysOn

      2:00
    • Suggested Maintenance Jobs: Backups

      12:11
    • Suggested Maintenance Jobs: Advanced Backup Methods

      2:45
    • Suggested Maintenance Jobs: Backup History Maintenance

      6:42
    • Suggested Maintenance Jobs: Index And Statistics Maintenance

      16:04
    • Suggested Maintenance Jobs: Cycle Error Logs

      3:04
    • Suggested Maintenance Jobs: Database Mail Maintenance

      2:00
    • Suggested Maintenance Jobs: DBCC CHECKDB

      5:12
    • Suggested Maintenance Jobs: Data Compression Maintenance

      1:40
    • Troubleshooting: Finding The SQL Server Version Number

      2:55
    • Troubleshooting: Why Can't I Log In?

      3:36
    • Troubleshooting: Why Is My Query Taking So Long?

      7:02
    • Troubleshooting: What Is SQL Server Waiting On?

      5:13
    • Troubleshooting: Creating A Performance Baseline

      3:30
    • Conclusion

      1:03

About This Class

By the end of this course, you will understand basic database concepts. You will know how to use SQL Server Management Studio (SSMS) to manage your SQL Server. You will know how to perform and schedule basic database maintenance tasks. You will know how to perform basic troubleshooting. Basic knowledge of T-SQL Is helpful, but not required.

10

Students

--

Projects

0

Reviews (0)

Hello, I'm Shaun.

See full profile

Technology SQL Server Data Science