We may earn an affiliate commission when you visit our partners.

Developing SQL Server Databases

Pinal Dave, Gail Shaw, Gerald Britton, Mike McQuillan, Ryan Booz, Hugo Barona, and Viktor Suha

Microsoft SQL Server is a relational database management system. It's main purpose is to store and retrieve data as needed by other software applications. This skill will teach you how to design and implement databases for Microsoft SQL Server.

What You'll Learn

Designing and implementing tables, views, and other database objects

Implementing indexes

Concurrency management

Basic Optimization

Basic performance tuning and query analysis

Enroll now

Or start your subscription today

And complete this course over a free trial

Help others find this collection page by sharing it with your friends and followers:

Facebook

Copy Link

What's inside

Eight courses

Designing and Implementing SQL Server Tables and Views

(2 hours)

Every great database starts with a great design and tables and views are the bedrock of that design. This course will show you how to create tables and views that use the right data types, constraints, and indexes to meet all business requirements.

View more details for this course

Designing and Implementing SQL Server Database Indexes

(2 hours)

This course introduces SQL Server indexes. You will learn common index types and how to index to support your workloads.

View more details for this course

Programming SQL Server Database Stored Procedures

(2 hours)

So, you use SQL Server. Learn how to reduce code, maximize performance, and simplify security in your databases with stored procedures.

View more details for this course

Managing SQL Server Database Concurrency

(1 hours)

This course delves into database transactions, isolation levels, locking, and more when managing SQL Server Database.

View more details for this course

Using Memory-optimized Tables and Native Stored Procedures

(1 hours)

The objective of this course is to help your SQL Server-based applications run at rapid speed by leveraging In-Memory OLTP Technologies, including Memory-optimized Tables and Native Stored Procedures.

View more details for this course

Optimizing SQL Server Statistics and Indexes

(1 hours)

How should indexes be maintained? Do columnstore indexes need maintenance? What should I do about statistics? This course answers these questions and more. Learn how to maintain your indexes to keep your database running smoothly.

View more details for this course

Analyzing SQL Server Query Plans

(2 hours)

Every database server runs different workloads and queries. You will learn how to analyze query plans and troubleshoot SQL Server performance problems.

View more details for this course

Managing SQL Server Database Performance

(3 hours)

SQL Server performance problems are real and troubleshooting can be a challenge. This course will cover what factors affect performance and how to troubleshoot and optimize performance both on-premise and with Azure SQL Database.

View more details for this course

Save this collection

Save Developing SQL Server Databases to your list so you can find it easily later:

Save

Time

17 hours

Via

Pluralsight

Institution

Instructors

Pinal Dave

Gail Shaw

Gerald Britton

Mike McQuillan

Ryan Booz

Hugo Barona

Viktor Suha

Share and help others discover this collection.

Facebook

Link

Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.