Microsoft SQL Server 2019 Essential Training
4.7 /5- Offered byLinkedin Learning
Microsoft SQL Server 2019 Essential Training at Linkedin Learning Overview
Duration | 4 hours |
Total fee | ₹1,150 |
Mode of learning | Online |
Difficulty level | Beginner |
Credential | Certificate |
Microsoft SQL Server 2019 Essential Training at Linkedin Learning Highlights
- Earn a certificate of completion from LinkedIn Learning
Microsoft SQL Server 2019 Essential Training at Linkedin Learning Course details
- In this course, instructor Adam Wilbert equips beginners with the core skills they need to create and manage SQL Server databases
- Adam begins with the basics, showing how to install SQL Server and log into a local database server
- He then discusses how to create new databases, design tables, define relationships, write queries, and use stored procedures and built-in functions
- Plus, he demonstrates how to perform crucial database administration tasks, such as backups and restores, security enhancements, and performance monitoring
Microsoft SQL Server 2019 Essential Training at Linkedin Learning Curriculum
Introduction
Harness the modern and innovative tools in SQL Server 2019
What you should know
Get Started
Core concepts
SQL Server 2019 editions
Install SQL Server Developer Edition
Install Management Studio
Enable features with Configuration Manager
Log into the Server
Management Studio first steps
Authentication and user permissions
Create a new user account
Create Databases
Create the first database
Database configuration options
Table structures
Create a simple table
Edit a table's structure
Enter data into a table using the GUI
Import data from CSV files
Create tables from flat files
Install a sample database
Table Design for Healthy Databases
Understand data types
Table column properties
Primary key fields
Establish a default value
Check constraints
Unique constraints
Foreign keys
Create a foreign key column
Create relationships between tables
Structured Query Language
Understand the role of T-SQL
Use the T-SQL editor
Create a table with T-SQL
Add data to a table
Retrieve records with SELECT
Filter returned results with WHERE
Sort records
Delete records from a table
Update records in a table
Join related tables
LEFT JOIN and RIGHT JOIN
Remove a table from the database
Query Performance
Create a view of the data
Data table indexes
Create additional indexes on a table
Columnstore indexes
View execution plans
SQL Server's Query Store
Rebuild indexes
Microsoft SQL Server 2019 Essential Training at Linkedin Learning Faculty details
Other courses offered by Linkedin Learning
Student Forum
Anything you would want to ask experts?