English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 1h 21m | 177 MB
Microsoft SQL Server can be an intimidating system. In this course, instructor Adam Wilbert provides a quick overview of how SQL Server works—which can go a long way to making you feel more comfortable as you start exploring its powerful capabilities. Adam goes over the most important features of SQL Server 2017, helping to familiarize you with how the server operates. He introduces the main working environment—SQL Server Management Studio—and walks through how to start creating tables and manipulating data.
Topics include:
- Reviewing the different editions of SQL Server
- Configuring and starting the server
- Touring the SQL Server Management Studio (SSMS) interface
- Creating a new database on the server
- Creating a data table
- Joining tables together with keys
- Writing Transact-SQL commands
Table of Contents
Introduction
Welcome
What you should know
Getting Started
Installing SQL Server
Understand the editions of SQL Server
What is SQL Server
Working with the Server
Configure and start the server
Locate SQL Server documentation
Log in to the server
SQL Server Management Studio (SSMS)
Create a data table
Create a new database on the server
Install a sample database
Join tables together with keys
Tour the SSMS interface
Understand SQL data types
Write Transact-SQL Commands
Add data with an INSERT statement
Create a SELECT statement
Create a view of the data
Use functions to calculate values
Write an UPDATE statement
Conclusion
Next steps
Resolve the captcha to access the links!