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
Reviews
No one has reviewed this skill yet. If you have worked through it, yours would be the first.
There are no published reviews for this course yet.
Write a review
Checking your account…
Ready to build SQL Basics?
Create a free account on iCompetent and start progressing through the levels today.