Microsoft SQL Server 2019 Essential Training
Offered By: LinkedIn Learning
Course Description
Overview
Master the fundamentals of SQL Server 2019. Learn how to create new databases, tables, and queries; manage query performance; create and restore a backup of a database; and more.
Syllabus
Introduction
- Harness the modern and innovative tools in SQL Server 2019
- What you should know
- Core concepts
- SQL Server 2019 editions
- Install SQL Server Developer Edition
- Install Management Studio
- Enable features with Configuration Manager
- Management Studio first steps
- Authentication and user permissions
- Create a new user account
- 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
- 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
- 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
- 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
- Aggregate functions
- Use built-in functions
- Leverage user-defined scalar functions
- Introduction to stored procedures
- Create stored procedures
- Parameterized stored procedures
- Create a full backup of the database
- Create a differential backup
- Restore a backup
- Automate backups
- Business continuity solutions
- User roles and permissions
- Database schemas
- Dynamic data masking
- Always On data encryption
- Explore the role of system databases
- Prevent excessive tempdb autogrowth
- Review the SQL Server error log
- Dynamic management views
- Database Console Commands (DBCC)
- Next steps
Taught by
Adam Wilbert
Related Courses
Creating Programmatic SQL Database ObjectsMicrosoft via edX Developing SQL Databases
Microsoft via edX Advanced Relational Database and SQL
Coursera Project Network via Coursera SQL Functions
Coursera Project Network via Coursera Master C# And SQL By Building Applications
Udemy