Get familiar with SQL antipatterns in this course and learn to deal with such antipatterns. You can also execute the codes to get to the depth.
Beginner
87 Lessons
6h 45min
Certificate of Completion
Get familiar with SQL antipatterns in this course and learn to deal with such antipatterns. You can also execute the codes to get to the depth.
AI-POWERED
AI-POWERED
This course includes
This course includes
Course Overview
Structured Query Language (SQL) is widely used to manage relational databases and perform various data-related operations. Non-expert programmers commonly try to solve a problem with a risky and ineffective solution, also known as an antipattern. Such common bad practices initially look like a good solution and are easier to implement but cause more problems. This course explains the best fixes by addressing multiple antipatterns. This course covers the following four types of SQL antipatterns: logical, ph...Show More
TAKEAWAY SKILLS
Sql
Database
What You'll Learn
Learn the best practices for writing SQL queries.
Increase your SQL skills by inspecting SQL antipatterns.
Get introduced to SQL antipatterns and solutions.
Learn issues corresponding to create, read, update, and delete (CRUD) operations in SQL database.
What You'll Learn
Learn the best practices for writing SQL queries.
Show more
Course Content
Introduction
Logical Antipattern - Jaywalking
Logical Antipattern - Naive Trees
Logical Antipattern - ID Required
Logical Antipattern - Keyless Entry
Assessment: Logical Antipatterns - Part 1
Assessment
Logical Antipattern - Entity-Attribute-Value
5 Lessons
Logical Antipattern - Polymorphic Associations
4 Lessons
Logical Antipattern - Multicolumn Attributes
3 Lessons
Logical Antipattern - Metadata Tribbles
3 Lessons
Assessment: Logical Antipatterns - Part 2
Assessment
Physical Antipattern - Rounding Errors
3 Lessons
Physical Antipattern - 31 Flavors
3 Lessons
Physical Antipattern - Phantom Files
3 Lessons
Physical Antipattern - Index Shotgun
3 Lessons
Assessment: Physical Antipatterns
Assessment
Query Antipattern - Fear of the Unknown
3 Lessons
Query Antipattern - Ambiguous Groups
3 Lessons
Query Antipattern - Random Selection
3 Lessons
Query Antipattern - Poor Man’s Search Engine
4 Lessons
Query Antipattern - Spaghetti Query
3 Lessons
Query Antipattern - Implicit Columns
3 Lessons
Assessment: Query Antipattern
Assessment
Application Development Antipattern - Readable Passwords
4 Lessons
Application Development Antipattern - SQL Injection
4 Lessons
Application Development Antipattern - Pseudokey Neat-Freak
3 Lessons
Application Development Antipattern - See No Evil
3 Lessons
Application Development Antipattern - Diplomatic Immunity
3 Lessons
Application Development Antipattern - Magic Beans
3 Lessons
Assessment: Application Development Antipattern
Assessment
Course Author
Trusted by 1.4 million developers working at companies
Anthony Walker
@_webarchitect_
Emma Bostian 🐞
@EmmaBostian
Evan Dunbar
ML Engineer
Carlos Matias La Borde
Software Developer
Souvik Kundu
Front-end Developer
Vinay Krishnaiah
Software Developer
Eric Downs
Musician/Entrepeneur
Kenan Eyvazov
DevOps Engineer
Anthony Walker
@_webarchitect_
Emma Bostian 🐞
@EmmaBostian
See how Educative uses AI to make your learning more immersive than ever before.
Instant Code Feedback
AI-Powered Mock Interviews
Adaptive Learning
Explain with AI
AI Code Mentor