SQL Basics
Practical SQL for industrial and energy professionals who need to answer their own data questions: reading relational tables, writing SELECT queries with filters, groups and joins, and querying production systems safely and read-only.
55m
Total time
4
Competency levels
12
Lessons
What you'll learn
- Describe how relational data is organised into tables, rows, columns, primary keys and foreign keys
- Write SELECT queries using WHERE, GROUP BY, HAVING, ORDER BY and row limits
- Explain the difference between the written clause order and the logical evaluation order of a query
- Handle NULL values correctly and avoid the comparison traps they create
- Choose between inner and left joins, and recognise duplicate and cross-join row explosions
- Apply read-only discipline on production databases and share queries others can trust and reuse
Curriculum
Progress through each competency level in order.
1
Awareness
- 3mHow Relational Data Is OrganisedKnowledge
- 3mThe Anatomy of a SELECT StatementKnowledge
- 7mAwareness Check: Tables and SELECTAssessment
2
Knowledge
- 3mFiltering Rows: WHERE, IN, LIKE, BETWEEN and NULLKnowledge
- 3mAggregation, GROUP BY, HAVING and Logical Evaluation OrderKnowledge
- 8mKnowledge Check: Filtering and GroupingAssessment
3
Skill
- 3mJoins, Duplicates, Sorting and LimitsKnowledge
- 3mAnswer a Real Question with a Query SetAssignment
- 8mSkill Check: Joins and Result SetsAssessment
4
Mastery
- 3mQuerying Production Safely and Sharing Work Others Can TrustKnowledge
- 3mPublish a Reviewed, Reusable Query PackAssignment
- 8mMastery Check: Safe, Trustworthy QueryingAssessment
Ready to build SQL Basics?
Create a free account on iCompetent and start progressing through the levels today.