Now it's time to start using Pulse.
Chris, let's start by using Pulse Chris in the terminal.
Let me make that bigger so that we can see more.
And, of course, full screen pulse Chris ships with a few command line helpers in this case are used
to create DB come up and hear above, which will create a new database.
We also have to use here the minus you flag at the use of Pulse Chris, because this is the only one
which has the pulse world right now.
Afterwards, we write the name of the database.
It answer now it will ask for the password.
In my case, it is test.
All right.
Looks like it got created successfully.
Let's verify that we answer into the Post Grossmont user PostgreSQL approval to have the database test,
which we created before Typekit the password and now we are successfully connected to our thought,
the base test.
But there is nothing in there.
So let's create a table before already prepared a statement for creating a table.
All it does is it creates a table users with an I.D., which is an auto increment, which means the
first user gets the one, the second one, the I.D. two and so on.
We have a name column in here, which is just text with 355 Charles Max, which means you can't store
more into this column the same as well.
It's for the email column hit enter the table got created successfully.
We can verify that by using another command which you can use in Postgres, which is Backslash D.T.,
which is for display tables.
All right, our users table is set up.
So let's insert our first row through the command line.
This is the statement which I prepared already.
It's just as simple insert comment, which will enter a name and the email with John and John at tho
dot com.
Make sure you sync quotes in here.
And also don't forget the semicolon at the end of each statement.
Otherwise post-Christmas won't execute to come out, hit enter and it got inserted successfully.
Let's verify that again by using the select query and select star.
We want everything from the user stable semicolon and enter.
All right, looks good.
We have inserted our first entry into the database.
This is basically using SQL through the command line, but we also have P.G. Oppman, which we got for
free by installing PostgreSQL on Windows.
So let's try Pacman research for PGA apartment, and there it is PJ applying for a permit and depending
on your hardware, it might take a while.
All right.
Now it asks for a passport, in my case, it is test because this is the passport which I have chosen
throughout the installation process.
It's answer.
And now we have collected, OK, map the service.
We have post Chris Askew, our version 14 running.
And here is our test database, which we have created through the command line.
Open that up as well.
Other schemas.
Tables we will see I use a table, but if you double click on it, nothing will happen.
You can now inspect it further by expanding the tree and you will see we also see our columns in here.
But we have to we actually see what's in there already.
To do so, just right click on users and choose view at data and all rows.
This will open up the capital, and we will also see what's already in our database.
So now how can we insert another entry in here?
Turns out just double clicking into this field and typing in.
Let's go with Jane and the email is Jane at the dot com.
OK, so how do we save it now?
Because to save about this great art impeachment, the save button does something else than saving something
through the database.
It might save the entire entries in here into a file, which is usually not what we want.
We want to save it to the database and to do so.
This icon comes to the rescue.
Does this the icon to save the data, which we edited here to our database?
So let's click on that.
Well, saving data about the saved successfully.
All right.
We have saved successfully our data.
You can also just insert different other careers as well.
Just right click on users and open the query tool.
Now you will end up with a clean slate.
Solo, we could for now just entered the Select Command Again Select Star from Users column.
And now we hit the play button.
And we got our results again, so this is all what you need right now for using.
If you want to troubleshoot anything, Google is your best friend.
We don't need more throughout the course, just creating entries and creating thought the basis is totally
enough.
You cannot only create entries.
You could also create an entire table to do so.
Just right click on Table Go to create and then table.
Then you can use the wizard to create the table.
Make sure you choose the right holder, which is pull squares in our case because we didn't set up another
one.
And then you can choose a name for it.
Let's go with email or log in, which is also something which we need for the Smart Brain project.
You can select Table Table Space, but you don't have to enter Kinect to comment on the column section.
You can insert columns just by clicking on the plus icon.
Choosing a name.
Let's go with idea as well, because usually each table has its own idea.
And there we have also the serial.
In here, and it is our primary key.
And this is the way you could create another column and another column and as much columns as you want
to.
All right, we won't discard this changes because we don't need them right now.
And this is it.
This is using Pascual through the command line and also with P.J..
And for now, you set up to tackle the smart brain project with everything installed on windows.
Well done coming this far.
Bye bye.