Main content
Computer programming
Course: Computer programming > Unit 3
Lesson 1: SQL basicsS-Q-L or SEQUEL?
How is it pronounced? Why? Let's discuss...
Want to join the conversation?
- What did I do wrong on this challenge? I can't figure it out. It asked me SUM up the minutes across all todo tasks.
CREATE TABLE todo_list (id INTEGER PRIMARY KEY, item TEXT, minutes INTEGER);
INSERT INTO todo_list VALUES (1, "Wash the dishes", 15);
INSERT INTO todo_list VALUES (2, "vacuuming", 20);
INSERT INTO todo_list VALUES (3, "Learn some stuff on KA", 30);
INSERT INTO todo_list VALUES (4, "Make bed", 5);
SELECT item, SUM(minutes) FROM todo_list;(27 votes)- just exclude the item from your query then you are good to go: SELECT SUM(minutes) FROM todo_list;(82 votes)
- Does anyone know what the airline acronym stood for?(9 votes)
- The airplane company was Hawker Siddeley.
I couldn't find anything on their trademark SEQUEL, but I'm not sure if it was actually an acronym. It could just be the word.(21 votes)
- Is this course more close to Oracle MySQL, or MS SQL? Or,maybe, there isn't much of a difference?(3 votes)
- What is taught in this course (SELECT FROM, INSERT INTO, WHERE, ORDER BY, SUM) is exactly the same in all: SQLite, Oracle SQL, MySQL, MS SQL, differences come later in more complex functions, data types, privileges, joining tables etc... http://docs.oracle.com/cd/E12151_01/doc.150/e12155/oracle_mysql_compared.htm#i1027526(27 votes)
- Does anyone know of a good tutorial that would help build a "Hello World" website, that goes through the SQL database setup and procedures to serve content from the database to HTML? I've got LAMP up and running, and have a solid understanding of JS, HTML, CSS, introductory knowledge of PHP and SQL, but I want to pull it all together.(7 votes)
- A good starter project would be to use the PHP
mysqli
object (http://php.net/manual/en/book.mysqli.php) to connect to a MySQL database and output the data from the database as a table. Then, as you learn more, you can add ways for users to interact with this data.(9 votes)
- how do I select two different colum headings in
Select * from name
what would I replace star with.(3 votes)- Good question! I went back to the preceding videos and could not find an example. To get individual columns, just list the column names that you want with commas between them.
Using thegroceries
table from the "Querying the Table" video (https://www.khanacademy.org/computing/computer-programming/sql/sql-basics/pt/querying-the-table):
We have thegroceries
table with the columnsid
,name
,quantity
, andaisle
.
If we wanted just the name of the item and the aisle where we can find it, we would writeSELECT name, aisle FROM groceries;
If we want to know how much of each item we have (a very common query), we could write:SELECT name, quantity FROM groceries;
(9 votes)
- Hello, I've learnt programming for six months. But I have a serious question: Who made the video?
(Sal should be a man, but he has a woman voice.)(1 vote)- I believe Pamela is speaking in this one :)(11 votes)
- Hi why do we have to do this!?(1 vote)
- Unless you are taking these courses for school, you are not obligated to complete any of the KACP lessons, challenges, or projects.
If you are taking these courses for school, this sounds like a question for your teacher.(5 votes)
- Is a sequel also the second part of a movie?(2 votes)
- Sequel refers to the second part of something, not just a movie(3 votes)
- I understand R and this is my first time learning SQL. They both look the same to me. What is the difference and what are the pros and cons of each of them?(2 votes)
- SQL all the way.(2 votes)
Video transcript
At this point, you've probably heard me
pronounce SQL two ways-- sequel or S-Q-L. Some of you might even be mad that I'm pronouncing it
one way or the other, and you may have
very good reason for believing that your favorite pronunciation
is the correct one. So what's the deal? Well, SQL was originally invented
at IBM in the early 1970s. And the first version
was called SEQUEL, and it stood for
Structured English QUEry Language. That acronym, SEQUEL,
was later changed to SQL, because SEQUEL was already
trademarked by an airplane company, and companies really don't like
getting into trademark lawsuits. Nowadays, many of us still
pronounce it sequel, because it's shorter to say, and we've got historical reasons
to claim that it's the right way. However, when I surveyed
developers across the world, I found that in non-English languages,
many of them pronounce it S-Q-L, or, for example,
ese cu ele in Spanish. Since our videos get translated
here on Khan Academy, I figured I'd make it easier for translators to match
the pace of our videos, by pronouncing SQL the long way. But in everyday life,
I'm used to calling it sequel, so both of them come out of me. Now you know,
it can be S-Q-L or sequel, and you'll probably hear both
the rest of your life. The world is a messy place, but at least you now have a way of
structuring your queries about it, right?