Save For Later

Developing SQL Server Databases

Save For Later

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
  • OpenCourser is an affiliate partner of Pluralsight and may earn a commission when you buy through our links.

    From Pluralsight
    Hours 23
    Instructors Gerald Britton, Gail Shaw, Mike McQuillan, Ryan Booz, Pinal Dave, Viktor Suha, Hugo Barona
    Language English
    Subjects IT & Networking

    Similar Courses

    Sorted by relevance

    Careers

    An overview of related careers and their average salaries in the US. Bars indicate income percentile (33rd - 99th).

    Microsoft SQL Engineer for Mobility $73k

    Microsoft CSR $81k

    Microsoft SQL Server DBA $103k

    SDE in Microsoft $106k

    Microsoft SQL DBA $108k

    Microsoft SQL Server Database Administrator $109k

    Microsoft SQL Server Developer $109k

    SDE @ Microsoft 5 $110k

    Microsoft Engineer 3 $126k

    Microsoft SQL Database Administrator Lead $128k

    Microsoft SQL Developer $130k

    Senior Microsoft SQL Database Administrator $148k

    Courses in this Paths

    Listed in the order in which they should be taken

    Starts Course Information

    On Demand

    Designing and Implementing SQL Server Tables and Views

    In this course, Designing and Implementing SQL Server Tables and Views, you will gain the foundational knowledge you need to match business requirements to the objects to be...

    Pluralsight

    Save

    On Demand

    Designing and Implementing SQL Server Database Indexes

    Poor database performance is a problem for applications and annoys users. Poor performance often comes down to poor indexing of critical tables. In this course, Designing and...

    Pluralsight

    Save

    On Demand

    Programming SQL Server Database Stored Procedures

    Ever wondered how to create repeatable, consistent, secure code in SQL Server? If you have, it sounds like you need to learn about stored procedures. In this course, Programming...

    Pluralsight

    Save

    On Demand

    Programming SQL Server Database Triggers and Functions

    As a SQL Server Database Developer, it is often necessary to have business-layer logic that exists within the database to ensure clean, consistent data. Although constraints and...

    Pluralsight

    Save

    On Demand

    Managing SQL Server Database Concurrency

    Are you sometimes unsure about what type of database transaction or what isolation level makes sense for your application? Have you ever run into blocking problems or the dreaded...

    Pluralsight

    Save

    On Demand

    Using Memory-optimized Tables and Native Stored Procedures

    The In-Memory OLTP feature adds a new memory optimized RDBMS engine and a native compiled stored procedure. This new addition adds higher concurrency to the SQL Server and enables...

    Pluralsight

    Save

    On Demand

    Optimizing SQL Server Statistics and Indexes

    Index maintenance is a complex topic, and one that's crucial for a well-performing database. In this course, Optimizing SQL Server Statistics and Indexes, you will learn...

    Pluralsight

    Save

    On Demand

    Analyzing SQL Server Query Plans

    Every database server runs different workloads and queries, and it's important for a SQL Server Performance Tuning Expert to identify queries that are negatively impacting...

    Pluralsight

    Save

    On Demand

    Managing SQL Server Database Performance

    SQL Server performance troubleshooting and optimization are often overwhelming, complex, and take a very long time in production environments. However, this should not be the...

    Pluralsight

    Save

    On Demand

    Managing Azure SQL Server Database Performance

    When we talk about managing and tuning database performance, we know that these tasks used to require expertise and used to be time-consuming. Sometimes we would not achieve the...

    Pluralsight

    Save

    Pluralsight

    From Pluralsight
    Hours 23
    Instructors Gerald Britton, Gail Shaw, Mike McQuillan, Ryan Booz, Pinal Dave, Viktor Suha, Hugo Barona
    Language English
    Subjects IT & Networking

    Careers

    An overview of related careers and their average salaries in the US. Bars indicate income percentile (33rd - 99th).

    Microsoft SQL Engineer for Mobility $73k

    Microsoft CSR $81k

    Microsoft SQL Server DBA $103k

    SDE in Microsoft $106k

    Microsoft SQL DBA $108k

    Microsoft SQL Server Database Administrator $109k

    Microsoft SQL Server Developer $109k

    SDE @ Microsoft 5 $110k

    Microsoft Engineer 3 $126k

    Microsoft SQL Database Administrator Lead $128k

    Microsoft SQL Developer $130k

    Senior Microsoft SQL Database Administrator $148k

    Similar Courses

    Sorted by relevance