1
00:00:00,080 --> 00:00:06,560
In this section, we're going to learn to use SQL Server Management Studio to create, analyze and manage

2
00:00:06,560 --> 00:00:07,520
databases.

3
00:00:07,550 --> 00:00:14,420
We'll learn what a relational database is and get an overview of the Structured Query Language or SQL

4
00:00:14,420 --> 00:00:20,960
features will create a diagram of an existing database and learn about tables, relationships and data.

5
00:00:21,200 --> 00:00:27,050
Then I'll introduce you to the Production Defect Tracking Project, which are requirements for a database

6
00:00:27,050 --> 00:00:33,320
enabled Wincc SCADA application that allows production staff to enter, repair and manage production

7
00:00:33,320 --> 00:00:34,010
defects.

8
00:00:34,010 --> 00:00:40,040
You'll be creating and populating a new SQL database for our defect tracking project based on these

9
00:00:40,040 --> 00:00:40,910
requirements.

10
00:00:40,910 --> 00:00:42,410
So let's get started.