SQL Server 2017 Express Basics
Update Notice 4/3/2018: Course has been updated to SQL Server 2017!
4.45 (487 reviews)
2,274
students
6 hours
content
Mar 2018
last update
$59.99
regular price
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
Screenshots
Related Topics
939708
udemy ID
8/24/2016
course created date
11/21/2019
course indexed date
Bot
course submited by