LIN | Microsoft SQL Server 2019 Essential Training (2019 EN)

Company: Linkedin Learning
Author: Adam Wilbert
Full Title: Microsoft SQL Server 2019 Essential Training
Year: 2019
Language: English
Genre: Educational: Databases
Skill Level: Beginner
Price: €24.99
-
Files: MP4 (+ Exercise Files, Subtitles .SRT)
Time: 04:24:05
Video: AVC, 1280 x 720 (1.778) at 30.000 fps, 200 kbps
Audio: AAC at 128 Kbps, 2 channels, 48.0 KHz



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:
01. Installing Management Studio
02. Enabling features with SQL Server Configuration Monitor
03. Creating a database
04. Creating tables with Transact-SQL (T-SQL)
05. Creating relationships between tables
06. Creating views
07. Creating user-defined scalar functions
08. Backing up and restoring SQL Server
09. Monitoring and management
10. Security

Our members see more. Join us!
-------------
Our members see more. Join us!