0
1
00:00:05,360 --> 00:00:12,920
So now that we've got WinCC and SSMs installed, it's time to load our class database.
1

2
00:00:12,920 --> 00:00:15,710
So we're going to create a new database.
2

3
00:00:15,710 --> 00:00:17,960
We'll right click on databases.
3

4
00:00:17,960 --> 00:00:21,410
Under our database server we'll click New database.
4

5
00:00:21,410 --> 00:00:24,950
We are going to give it the name Battery Co.
5

6
00:00:24,950 --> 00:00:27,920
For Battery Company we'll just click okay.
6

7
00:00:28,880 --> 00:00:33,620
And it's going to create a new database and we'll select that.
7

8
00:00:33,620 --> 00:00:35,720
Now it doesn't have any tables.
8

9
00:00:35,720 --> 00:00:43,370
And so in our class resources you'll find a script called Create Battery Code tables dot SQL.
9

10
00:00:43,370 --> 00:00:45,560
And we can double click on this.
10

11
00:00:45,560 --> 00:00:49,130
And it's going to open it in SSMs.
11

12
00:00:49,130 --> 00:00:56,180
And this is a SQL script that creates all of our tables and also inserts all of our data.
12

13
00:00:56,180 --> 00:00:59,780
We're going to be learning what these SQL commands do in this course.
13

14
00:00:59,780 --> 00:01:03,590
For now you just need to make sure Batterico is selected.
14

15
00:01:03,590 --> 00:01:08,660
And then we will select into this file and click execute.
15

16
00:01:08,660 --> 00:01:13,730
And so after a few moments it will finish executing all of these queries.
16

17
00:01:13,880 --> 00:01:17,840
We're going to right click here and hit refresh.
17

18
00:01:18,080 --> 00:01:24,530
And then under tables you'll see that we now have some tables customers departments employees inventories
18

19
00:01:24,530 --> 00:01:26,510
orders states and vendors.
19

20
00:01:26,510 --> 00:01:32,510
And if we want to look at the data in these tables using the user interface, we could just right click
20

21
00:01:32,510 --> 00:01:38,390
select top 1000 rows and it will show us the data in the database.
21

22
00:01:41,160 --> 00:01:48,600
In the next assignment, you will create the battery code database and load the table and data from
22

23
00:01:48,600 --> 00:01:49,680
a SQL file.
23

24
00:01:49,710 --> 00:01:51,960
I'll see you in the next assignment.