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 и начните проходить уровни уже сегодня.