Microsoft SQL Server 2019 Essential Training

Microsoft SQL Server 2019 Essential Training
Microsoft SQL Server 2019 Essential Training
English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 4h 24m | 615 MB

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
Table of Contents

1 Harness the modern and innovative tools in SQL Server 2019
2 What you should know
3 Core concepts
4 SQL Server 2019 editions
5 Install SQL Server Developer Edition
6 Install Management Studio
7 Enable features with Configuration Manager
8 Management Studio first steps
9 Authentication and user permissions
10 Create a new user account
11 Create the first database
12 Database configuration options
13 Table structures
14 Create a simple table
15 Edit a table’s structure
16 Enter data into a table using the GUI
17 Import data from CSV files
18 Create tables from flat files
19 Install a sample database
20 Understand data types
21 Table column properties
22 Primary key fields
23 Establish a default value
24 Check constraints
25 Unique constraints
26 Foreign keys
27 Create a foreign key column
28 Create relationships between tables
29 Understand the role of T-SQL
30 Use the T-SQL editor
31 Create a table with T-SQL
32 Add data to a table
33 Retrieve records with SELECT
34 Filter returned results with WHERE
35 Sort records
36 Delete records from a table
37 Update records in a table
38 Join related tables
39 LEFT JOIN and RIGHT JOIN
40 Remove a table from the database
41 Create a view of the data
42 Data table indexes
43 Create additional indexes on a table
44 Columnstore indexes
45 View execution plans
46 SQL Server’s Query Store
47 Rebuild indexes
48 Aggregate functions
49 Use built-in functions
50 Leverage user-defined scalar functions
51 Introduction to stored procedures
52 Create stored procedures
53 Parameterized stored procedures
54 Create a full backup of the database
55 Create a differential backup
56 Restore a backup
57 Automate backups
58 Business continuity solutions
59 User roles and permissions
60 Database schemas
61 Dynamic data masking
62 Always On data encryption
63 Explore the role of system databases
64 Prevent excessive tempdb autogrowth
65 Review the SQL Server error log
66 Dynamic management views
67 Database Console Commands (DBCC)
68 Next steps