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
Общее время
4
Уровни компетенций
12
Уроки
Чему вы научитесь
- 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
Программа
Проходите уровни компетенций по порядку.
1
Awareness
- 3mHow Relational Data Is OrganisedЗнания
- 3mThe Anatomy of a SELECT StatementЗнания
- 7mAwareness Check: Tables and SELECTОценка
2
Knowledge
- 3mFiltering Rows: WHERE, IN, LIKE, BETWEEN and NULLЗнания
- 3mAggregation, GROUP BY, HAVING and Logical Evaluation OrderЗнания
- 8mKnowledge Check: Filtering and GroupingОценка
3
Skill
- 3mJoins, Duplicates, Sorting and LimitsЗнания
- 3mAnswer a Real Question with a Query SetЗадание
- 8mSkill Check: Joins and Result SetsОценка
4
Mastery
- 3mQuerying Production Safely and Sharing Work Others Can TrustЗнания
- 3mPublish a Reviewed, Reusable Query PackЗадание
- 8mMastery Check: Safe, Trustworthy QueryingОценка
Ready to build SQL Basics?
Создайте бесплатный аккаунт на iCompetent и начните проходить уровни уже сегодня.