SQL Server 2017 Express Basics

Update Notice 4/3/2018: Course has been updated to SQL Server 2017!

4.44 (497 reviews)

Udemy

platform

English

language

Databases

What you will learn

Download and install SQL Server 2017 Express

Download and Install SQL Server Management Studio 2017

Write queries that control how many columns are displayed

Write queries that summarize large quantities of data

Understand how to choose different data types

Create a table to represent an entity

Insert records into tables

Create indexes to ensure data integrity

Learn how to restore databases

Learn how clustered indexes operate

Learn about SQL Server execution plans

Learn about a variety of SQL functions

Understand how to use a variety of online resources related to SQL Server

Learn how to read simple execution plans

Learn about physical SQL Server operators like Table Scan and Index Scan

Learn about scalar physical operators

Understand how/why to apply column constraints

Understand the concept of a computed column and why they are useful

Understand how to use a variety of logical conditions

Understand how to use where clauses

Understand how to use where clauses with two logical conditions

Describe the concept of a parameter

Explain the reasons for data conversions

Explain how to use N and $ symbols in data conversions

Understand the difference between clustered and non clustered indexes

Understand how to use key statistics like io/cpu readings

Understand how to differentiate between various icons in the sql plan panel

Understand the concept of a seek

Understand how to read and interpret a variety of online resources related to SQL Server

Understand how to read values from the various panels in SQL Server SSMS

Understand how to sort data on indexes

Understand how to read seek predicates

Understand how to build a nonclustered index with included columns

Understand how to summarize records with group by

Understand how to read various stats related to stream aggregation

Understand the concepts behind clustered index designs

Understand how to use the over clause

Understand how clauses are designed to run logically, step by step

Understand when aliased columns can be used with various clauses

Course Gallery

SQL Server 2017 Express Basics – Screenshot 1 — Screenshot 1 – SQL Server 2017 Express Basics

SQL Server 2017 Express Basics – Screenshot 2 — Screenshot 2 – SQL Server 2017 Express Basics

SQL Server 2017 Express Basics – Screenshot 3 — Screenshot 3 – SQL Server 2017 Express Basics

SQL Server 2017 Express Basics – Screenshot 4 — Screenshot 4 – SQL Server 2017 Express Basics

Loading charts...

SQL Server 2017 Express Basics

What you will learn

Download and install SQL Server 2017 Express

Download and Install SQL Server Management Studio 2017

Write queries that control how many columns are displayed

Write queries that summarize large quantities of data

Understand how to choose different data types

Create a table to represent an entity

Insert records into tables

Create indexes to ensure data integrity

Learn how to restore databases

Learn how clustered indexes operate

Learn about SQL Server execution plans

Learn about a variety of SQL functions

Understand how to use a variety of online resources related to SQL Server

Learn how to read simple execution plans

Learn about physical SQL Server operators like Table Scan and Index Scan

Learn about scalar physical operators

Understand how/why to apply column constraints

Understand the concept of a computed column and why they are useful

Understand how to use a variety of logical conditions

Understand how to use where clauses

Understand how to use where clauses with two logical conditions

Describe the concept of a parameter

Explain the reasons for data conversions

Explain how to use N and $ symbols in data conversions

Understand the difference between clustered and non clustered indexes

Understand how to use key statistics like io/cpu readings

Understand how to differentiate between various icons in the sql plan panel

Understand the concept of a seek

Understand how to read and interpret a variety of online resources related to SQL Server

Understand how to read values from the various panels in SQL Server SSMS

Understand how to sort data on indexes

Understand how to read seek predicates

Understand how to build a nonclustered index with included columns

Understand how to summarize records with group by

Understand how to read various stats related to stream aggregation

Understand the concepts behind clustered index designs

Understand how to use the over clause

Understand how clauses are designed to run logically, step by step

Understand when aliased columns can be used with various clauses

Course Gallery

Related Topics