1 00:00:00,510 --> 00:00:03,010 Now it's time to start using Pulse. 2 00:00:03,270 --> 00:00:06,990 Chris, let's start by using Pulse Chris in the terminal. 3 00:00:08,760 --> 00:00:11,340 Let me make that bigger so that we can see more. 4 00:00:11,790 --> 00:00:19,320 And, of course, full screen pulse Chris ships with a few command line helpers in this case are used 5 00:00:19,320 --> 00:00:23,610 to create DB come up and hear above, which will create a new database. 6 00:00:24,630 --> 00:00:31,950 We also have to use here the minus you flag at the use of Pulse Chris, because this is the only one 7 00:00:32,159 --> 00:00:33,930 which has the pulse world right now. 8 00:00:34,850 --> 00:00:37,770 Afterwards, we write the name of the database. 9 00:00:38,250 --> 00:00:41,400 It answer now it will ask for the password. 10 00:00:41,700 --> 00:00:43,350 In my case, it is test. 11 00:00:46,030 --> 00:00:46,600 All right. 12 00:00:46,630 --> 00:00:48,730 Looks like it got created successfully. 13 00:00:49,150 --> 00:00:59,050 Let's verify that we answer into the Post Grossmont user PostgreSQL approval to have the database test, 14 00:00:59,050 --> 00:01:07,600 which we created before Typekit the password and now we are successfully connected to our thought, 15 00:01:07,600 --> 00:01:08,320 the base test. 16 00:01:09,100 --> 00:01:10,390 But there is nothing in there. 17 00:01:10,480 --> 00:01:17,590 So let's create a table before already prepared a statement for creating a table. 18 00:01:18,640 --> 00:01:25,750 All it does is it creates a table users with an I.D., which is an auto increment, which means the 19 00:01:25,750 --> 00:01:30,370 first user gets the one, the second one, the I.D. two and so on. 20 00:01:31,300 --> 00:01:39,850 We have a name column in here, which is just text with 355 Charles Max, which means you can't store 21 00:01:39,860 --> 00:01:43,000 more into this column the same as well. 22 00:01:43,000 --> 00:01:48,790 It's for the email column hit enter the table got created successfully. 23 00:01:49,390 --> 00:01:55,690 We can verify that by using another command which you can use in Postgres, which is Backslash D.T., 24 00:01:56,020 --> 00:01:58,030 which is for display tables. 25 00:01:59,500 --> 00:02:01,840 All right, our users table is set up. 26 00:02:02,110 --> 00:02:06,220 So let's insert our first row through the command line. 27 00:02:07,760 --> 00:02:10,240 This is the statement which I prepared already. 28 00:02:11,140 --> 00:02:19,600 It's just as simple insert comment, which will enter a name and the email with John and John at tho 29 00:02:19,600 --> 00:02:20,320 dot com. 30 00:02:21,790 --> 00:02:23,650 Make sure you sync quotes in here. 31 00:02:23,920 --> 00:02:27,760 And also don't forget the semicolon at the end of each statement. 32 00:02:28,030 --> 00:02:35,020 Otherwise post-Christmas won't execute to come out, hit enter and it got inserted successfully. 33 00:02:35,800 --> 00:02:42,430 Let's verify that again by using the select query and select star. 34 00:02:42,460 --> 00:02:48,160 We want everything from the user stable semicolon and enter. 35 00:02:49,480 --> 00:02:51,310 All right, looks good. 36 00:02:51,520 --> 00:02:54,550 We have inserted our first entry into the database. 37 00:02:55,930 --> 00:03:03,190 This is basically using SQL through the command line, but we also have P.G. Oppman, which we got for 38 00:03:03,190 --> 00:03:06,340 free by installing PostgreSQL on Windows. 39 00:03:06,910 --> 00:03:17,320 So let's try Pacman research for PGA apartment, and there it is PJ applying for a permit and depending 40 00:03:17,320 --> 00:03:19,450 on your hardware, it might take a while. 41 00:03:21,410 --> 00:03:22,040 All right. 42 00:03:22,100 --> 00:03:28,130 Now it asks for a passport, in my case, it is test because this is the passport which I have chosen 43 00:03:28,130 --> 00:03:29,630 throughout the installation process. 44 00:03:30,320 --> 00:03:31,040 It's answer. 45 00:03:32,210 --> 00:03:35,330 And now we have collected, OK, map the service. 46 00:03:35,930 --> 00:03:39,290 We have post Chris Askew, our version 14 running. 47 00:03:39,860 --> 00:03:43,550 And here is our test database, which we have created through the command line. 48 00:03:44,480 --> 00:03:45,650 Open that up as well. 49 00:03:46,800 --> 00:03:47,690 Other schemas. 50 00:03:50,320 --> 00:03:59,620 Tables we will see I use a table, but if you double click on it, nothing will happen. 51 00:04:00,880 --> 00:04:07,180 You can now inspect it further by expanding the tree and you will see we also see our columns in here. 52 00:04:07,750 --> 00:04:11,590 But we have to we actually see what's in there already. 53 00:04:12,490 --> 00:04:18,880 To do so, just right click on users and choose view at data and all rows. 54 00:04:22,079 --> 00:04:27,870 This will open up the capital, and we will also see what's already in our database. 55 00:04:28,980 --> 00:04:32,820 So now how can we insert another entry in here? 56 00:04:33,990 --> 00:04:38,430 Turns out just double clicking into this field and typing in. 57 00:04:38,640 --> 00:04:46,620 Let's go with Jane and the email is Jane at the dot com. 58 00:04:48,540 --> 00:04:51,930 OK, so how do we save it now? 59 00:04:52,320 --> 00:04:59,400 Because to save about this great art impeachment, the save button does something else than saving something 60 00:04:59,400 --> 00:05:00,270 through the database. 61 00:05:00,780 --> 00:05:07,260 It might save the entire entries in here into a file, which is usually not what we want. 62 00:05:07,680 --> 00:05:11,520 We want to save it to the database and to do so. 63 00:05:12,240 --> 00:05:14,160 This icon comes to the rescue. 64 00:05:14,640 --> 00:05:20,070 Does this the icon to save the data, which we edited here to our database? 65 00:05:20,070 --> 00:05:21,120 So let's click on that. 66 00:05:21,130 --> 00:05:25,230 Well, saving data about the saved successfully. 67 00:05:26,250 --> 00:05:26,760 All right. 68 00:05:26,970 --> 00:05:29,190 We have saved successfully our data. 69 00:05:30,240 --> 00:05:35,700 You can also just insert different other careers as well. 70 00:05:36,090 --> 00:05:38,880 Just right click on users and open the query tool. 71 00:05:42,790 --> 00:05:44,890 Now you will end up with a clean slate. 72 00:05:44,980 --> 00:05:55,890 Solo, we could for now just entered the Select Command Again Select Star from Users column. 73 00:05:57,010 --> 00:05:58,630 And now we hit the play button. 74 00:06:01,180 --> 00:06:08,590 And we got our results again, so this is all what you need right now for using. 75 00:06:10,210 --> 00:06:13,270 If you want to troubleshoot anything, Google is your best friend. 76 00:06:14,440 --> 00:06:21,550 We don't need more throughout the course, just creating entries and creating thought the basis is totally 77 00:06:21,550 --> 00:06:21,910 enough. 78 00:06:22,660 --> 00:06:24,910 You cannot only create entries. 79 00:06:25,600 --> 00:06:28,720 You could also create an entire table to do so. 80 00:06:28,720 --> 00:06:32,530 Just right click on Table Go to create and then table. 81 00:06:33,910 --> 00:06:36,910 Then you can use the wizard to create the table. 82 00:06:37,450 --> 00:06:43,060 Make sure you choose the right holder, which is pull squares in our case because we didn't set up another 83 00:06:43,060 --> 00:06:43,270 one. 84 00:06:43,990 --> 00:06:46,630 And then you can choose a name for it. 85 00:06:47,050 --> 00:06:54,580 Let's go with email or log in, which is also something which we need for the Smart Brain project. 86 00:06:55,810 --> 00:07:03,880 You can select Table Table Space, but you don't have to enter Kinect to comment on the column section. 87 00:07:04,210 --> 00:07:07,720 You can insert columns just by clicking on the plus icon. 88 00:07:12,690 --> 00:07:13,500 Choosing a name. 89 00:07:14,790 --> 00:07:19,380 Let's go with idea as well, because usually each table has its own idea. 90 00:07:20,700 --> 00:07:24,720 And there we have also the serial. 91 00:07:27,490 --> 00:07:32,680 In here, and it is our primary key. 92 00:07:36,220 --> 00:07:41,860 And this is the way you could create another column and another column and as much columns as you want 93 00:07:41,860 --> 00:07:42,130 to. 94 00:07:44,290 --> 00:07:47,890 All right, we won't discard this changes because we don't need them right now. 95 00:07:49,090 --> 00:07:49,900 And this is it. 96 00:07:50,170 --> 00:07:54,680 This is using Pascual through the command line and also with P.J.. 97 00:07:54,940 --> 00:08:02,620 And for now, you set up to tackle the smart brain project with everything installed on windows. 98 00:08:03,250 --> 00:08:04,780 Well done coming this far. 99 00:08:05,650 --> 00:08:06,160 Bye bye.