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

This collection is no longer available.

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

Facebook

Copy Link

What's inside

Three 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

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

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

Save this collection

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

Save

Time

1079 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.