From the course: MySQL Data Analysis
Unlock this course with a free trial
Join today to access over 24,800 courses taught by industry experts.
Brief history and SQL flavors - MySQL Tutorial
From the course: MySQL Data Analysis
Brief history and SQL flavors
- [Instructor] Let's talk briefly about how SQL came to be and how it's evolved into the various flavors we see today. The language has been around since the 1970s when it was created to handle the manipulation and retrieval of data stored in relational database management systems. Since then, we've developed standards for SQL, which are updated by the major standards boards roughly every three to five years. Vendors are constantly trying to outdo each other by adding new features on top of these universal standards. This is what creates these various flavors of SQL. Let's talk a little bit about those most common flavors that you'll see. You've got your Enterprise Solutions, Oracle and Microsoft SQL Server. Then you've got some free solutions, MySQL, Postgre, and SQLite. The most important thing to remember about all of these languages is that these different flavors are much more similar than they are different. They're all built on the same universal standard, and the differences…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
(Locked)
Introduction19s
-
(Locked)
Why learn SQL1m 9s
-
(Locked)
Brief history and SQL flavors2m 25s
-
(Locked)
MySQL installation overview1m 21s
-
(Locked)
Mac download: Community Server4m 20s
-
(Locked)
Mac download: MySQL Workbench2m 15s
-
PC download: Community Server plus Workbench7m 37s
-
(Locked)
Connecting Workbench to the server1m 56s
-
(Locked)
MySQL Workbench interface1m 37s
-
(Locked)
Preparing Workbench for the course4m 41s
-
(Locked)
Creating the maven movies database1m 40s
-
(Locked)
-
-
-
-
-