So now that we've got WinCC and SSMs installed, it's time to load our class database. 1
So we're going to create a new database. 2
We'll right click on databases. 3
Under our database server we'll click New database. 4
We are going to give it the name Battery Co. 5
For Battery Company we'll just click okay. 6
And it's going to create a new database and we'll select that. 7
Now it doesn't have any tables. 8
And so in our class resources you'll find a script called Create Battery Code tables dot SQL. 9
And we can double click on this. 10
And it's going to open it in SSMs. 11
And this is a SQL script that creates all of our tables and also inserts all of our data. 12
We're going to be learning what these SQL commands do in this course. 13
For now you just need to make sure Batterico is selected. 14
And then we will select into this file and click execute. 15
And so after a few moments it will finish executing all of these queries. 16
We're going to right click here and hit refresh. 17
And then under tables you'll see that we now have some tables customers departments employees inventories 18
orders states and vendors. 19
And if we want to look at the data in these tables using the user interface, we could just right click 20
select top 1000 rows and it will show us the data in the database. 21
In the next assignment, you will create the battery code database and load the table and data from 22
a SQL file. 23
I'll see you in the next assignment.