1 00:00:02,160 --> 00:00:03,910 Now, SQL, as you learned, 2 00:00:03,910 --> 00:00:07,040 is actually just a language. 3 00:00:07,040 --> 00:00:10,180 It's the Structured Query Language, 4 00:00:10,180 --> 00:00:11,990 and it's a language that's being used 5 00:00:11,990 --> 00:00:15,770 by relational database management systems. 6 00:00:15,770 --> 00:00:17,870 And therefore we actually need to install 7 00:00:17,870 --> 00:00:20,375 such a system. I will also just call 8 00:00:20,375 --> 00:00:24,160 it SQL database system from now on, 9 00:00:24,160 --> 00:00:26,560 on our system, on our computer. We need to 10 00:00:26,560 --> 00:00:28,757 install such a SQL database system on our 11 00:00:28,757 --> 00:00:32,100 computer because it will be that system that 12 00:00:32,100 --> 00:00:35,880 then allows us to create tables and databases 13 00:00:35,880 --> 00:00:39,420 that hold those tables in that system. Now, 14 00:00:39,420 --> 00:00:41,870 when it comes to such systems, we've got various 15 00:00:41,870 --> 00:00:43,580 options though, and they offered the 16 00:00:43,580 --> 00:00:45,803 question which one do we want to use? 17 00:00:46,940 --> 00:00:50,680 Well, if you Google for SQL databases or 18 00:00:50,680 --> 00:00:53,774 SQL database systems, you'll find a lot of 19 00:00:53,774 --> 00:00:57,430 results, a lot of options, but here are a couple 20 00:00:57,430 --> 00:01:00,570 of the most popular and commonly used ones. 21 00:01:00,570 --> 00:01:03,520 And that for example, would be MySQL, 22 00:01:03,520 --> 00:01:07,690 PostgresSQL, MicrosoftSQL. And then as I said, 23 00:01:07,690 --> 00:01:09,653 we have a bunch of others as well. 24 00:01:10,850 --> 00:01:13,860 Now MySQL is probably the most 25 00:01:13,860 --> 00:01:17,650 popular database system out there, 26 00:01:17,650 --> 00:01:20,130 SQL database system I should say 27 00:01:20,130 --> 00:01:23,773 though PostgresSQL is also super popular. 28 00:01:24,700 --> 00:01:27,700 Now both these systems are actually open 29 00:01:27,700 --> 00:01:30,720 source and free to use and very popular. 30 00:01:30,720 --> 00:01:33,914 As I said, MicrosoftSQL is also very popular, 31 00:01:33,914 --> 00:01:37,490 but requires a commercial license and is not free 32 00:01:37,490 --> 00:01:40,267 to use. And for development and playing around, 33 00:01:40,267 --> 00:01:43,150 you could use it for free, but if you want to 34 00:01:43,150 --> 00:01:45,619 run it in production for a real website, you 35 00:01:45,619 --> 00:01:49,473 would need to pay for it. For MySQL and Postgres 36 00:01:49,473 --> 00:01:51,830 SQL, you can also use those for free, 37 00:01:51,830 --> 00:01:53,487 for real websites, which are reachable by 38 00:01:53,487 --> 00:01:57,090 visitors from all over the world. 39 00:01:57,090 --> 00:02:00,280 And they offer it's these two database systems. 40 00:02:00,280 --> 00:02:02,750 I want to focus on here and specifically 41 00:02:02,750 --> 00:02:07,150 we are going to use MySQL in this course. 42 00:02:07,150 --> 00:02:10,050 Now the features I show you the come-ons I 43 00:02:10,050 --> 00:02:13,711 show you, the SQL language I will teach you that 44 00:02:13,711 --> 00:02:18,470 generally is the same across all those databases. 45 00:02:18,470 --> 00:02:21,410 There are differences, not all databases, 46 00:02:21,410 --> 00:02:24,450 support all features. Some database systems 47 00:02:24,450 --> 00:02:26,910 bring their own features, but generally, 48 00:02:26,910 --> 00:02:29,900 it's the same idea. It's the same come-ons. 49 00:02:29,900 --> 00:02:32,260 So what you'll learn in this course section, 50 00:02:32,260 --> 00:02:35,045 and then discourse in general about SQL 51 00:02:35,045 --> 00:02:38,767 and MySQL specifically will then also help you 52 00:02:38,767 --> 00:02:42,570 if you decide to use PostgresSQL in the future, 53 00:02:42,570 --> 00:02:46,850 therefore we just go with MySQL, the most popular 54 00:02:46,850 --> 00:02:49,360 relational database system out there, and we're 55 00:02:49,360 --> 00:02:52,220 going to install it and then set up our databases 56 00:02:52,220 --> 00:02:54,713 in there and our tables in there. And so on.