Glossary term
What is SQL?
In Apex Flow Academy, "SQL" means: A language for asking questions of tables, such as counting rows or adding up a column by group. It is taught in Data Analytics From Scratch: Answer Real Business Questions and Node.js: Build the Back End and APIs. Related terms include Data cleaning, SQLite, Audit and Pivot table.
- 2 courses teach it
- plain-word definition
The facts
What is SQL?
A language for asking questions of tables, such as counting rows or adding up a column by group. (From Data Analytics From Scratch: Answer Real Business Questions. 1 other course defines it for their own subject, so each definition follows.)
What does SQL mean in Data Analytics From Scratch: Answer Real Business Questions?
A language for asking questions of tables, such as counting rows or adding up a column by group.
What does SQL mean in Node.js: Build the Back End and APIs?
The language you use to talk to a database, in short sentences such as SELECT and INSERT.
Where is SQL taught?
SQL is defined in Data Analytics From Scratch: Answer Real Business Questions and Node.js: Build the Back End and APIs.
Data Analytics From Scratch: Answer Real Business QuestionsNode.js: Build the Back End and APIs
Which lessons cover SQL?
These lessons name it in their title or objectives:
- Data Analytics From Scratch: Answer Real Business Questions, lesson 1.1: The Six-Stage Loop and Your Practice Shop
- Data Analytics From Scratch: Answer Real Business Questions, lesson 2.3: Fix Text, Date and Number Problems
- Data Analytics From Scratch: Answer Real Business Questions, lesson 3.1: Summarize With Count, Sum, Mean and Median
- Data Analytics From Scratch: Answer Real Business Questions, lesson 3.2: Group and Compare With GROUP BY and Pivot Tables
- Node.js: Build the Back End and APIs, lesson 3.1: Talk to SQLite with SQL
- Node.js: Build the Back End and APIs, lesson 3.2: Keep user input out of your SQL
Which terms are related to SQL?
Next to SQL in the course glossaries: Data cleaning, SQLite, Audit, Pivot table, Personal data, Mean, Fingerprint (hash), Median, Database and SQL injection.
Data cleaningSQLiteAuditPivot tablePersonal dataMeanFingerprint (hash)MedianDatabaseSQL injection
The hard questions, answered straight
Bold questions people really ask. Each answer comes from the course data or a settled Academy fact.
Do I need experience before I learn SQL?
It depends on the course. Each course that teaches it lists its own prerequisites, and all are listed at beginner and intermediate level:
- Data Analytics From Scratch: Answer Real Business Questions: You can save and find a file on your computer.
- Node.js: Build the Back End and APIs: Basic JavaScript: variables, functions, objects, arrays, conditions and loops.