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)
- 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.(20 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
mysqliobject (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.
groceriestable from the "Querying the Table" video (https://www.khanacademy.org/computing/computer-programming/sql/sql-basics/pt/querying-the-table):
We have the
groceriestable with the columns
If we wanted just the name of the item and the aisle where we can find it, we would write
SELECT 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)
- Is a sequel also the second part of a movie?(2 votes)
- Hi why do we have to do this!?(2 votes)
- 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.(2 votes)
- i want ti known the importance of SQL(2 votes)
- There are many jobs that use SQL as their primary language. SQL is a programming language you can use for many different things besides finding data quickly (say you are a programmer who is trying to find data on a website, about users like those with social media, banking. Some security jobs also use SQL servers to make sure everything works out. This is the basic stuff, when you get into the more in-depth stuff in SQL, you get to learn lots more and cooler things that will help you detect if something is wrong or how to make things better. You could even use this in statistics, I would think! It'd make your job a ton easier if you are dealing with large amounts of data.(1 vote)
- On a resume, in USA, would I say "proficient in SQL" or "...SEQUEL"(1 vote)
- you would always write "SQL"
but when you say it out loud, you have the choice between "sequel" or "S-Q-L"
i say "S-Q-L" myself(2 votes)
- Who's talking about SQL the topic?(3 votes)
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?