SQL Antipatterns: Avoiding the Pitfalls of Database Programming
Beginner
87 Lessons
6h 45min
Certificate of Completion
Takeaway Skills
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.
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
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
How You'll Learn
You don’t get better at swimming by watching others. Coding is no different. Practice as you learn with live code environments inside your browser.
Videos are holding you back. Educative‘s interactive, text-based lessons accelerate learning — no setup, downloads, or alt-tabbing required.
Learn faster and smarter with adaptive AI tools embedded in every Educative course.
Built-in assessments let you test your skills. Completion certificates let you show them off.