Lynda | Microsoft SQL Server 2019 Essential Training

Prom3th3uS

Moderator
Staff member
Forum Moderator
+Lifetime VIP+
Contributor
Oct 21, 2018
412
255
43
Unknown
Credits
7,627


Author: Adam Wilbert
Language: English
Released: 5/17/2019
Duration: 4h 24m
Subtitle: Included
Torrent Contains: 143 Files, 1 Folders
Course Source: https://www.lynda.com/SQL-Server-tutorials/Microsoft-SQL-Server-2019-Essential-Training/5010659-2.html

Description:

Master the fundamentals of SQL Server 2019, the industry-leading database management platform from Microsoft. 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.

Topics Include:

• Installing Management Studio
• Enabling features with SQL Server Configuration Monitor
• Creating a database
• Creating tables with Transact-SQL (T-SQL)
• Creating relationships between tables
• Creating views
• Creating user-defined scalar functions
• Backing up and restoring SQL Server
• Monitoring and management
• Security.

Skill Level: Beginner