Year-End Discount: 10% OFF 1-year and 20% OFF 2-year subscriptions!

SQL Antipatterns: Avoiding the Pitfalls of Database Programming

5 Assessments
87 Lessons
214 Playgrounds
49 Illustrations

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.

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

In this course, you will cover the four types of SQL antipatterns, which include logical antipatterns, physical antipatterns, query antipatterns, and application development antipatterns. More specifically, you will be able to run the code on the platform to get insight into every iss...

How You'll Learn

Hands-on coding environments

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.

Faster than videos

Videos are holding you back. The average video tutorial is spoken at 150 words per minute, while you can read at 250. That‘s why our courses are text-based.

No set-up required

Start learning immediately instead of fiddling with SDKs and IDEs. It‘s all on the cloud.

Progress you can show

Built in assessments let you test your skills. Completion certificates let you show them off.

Hands-on coding environments

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.

Faster than videos

Videos are holding you back. The average video tutorial is spoken at 150 words per minute, while you can read at 250. That‘s why our courses are text-based.

No set-up required

Start learning immediately instead of fiddling with SDKs and IDEs. It‘s all on the cloud.

Progress you can show

Built in assessments let you test your skills. Completion certificates let you show them off.

Course Contents

1. Introduction
2. Logical Antipattern - Jaywalking
3. Logical Antipattern - Naive Trees
4. Logical Antipattern - ID Required
5. Logical Antipattern - Keyless Entry

Course Assessment

Assessment: Logical Antipatterns - Part 1
7. Logical Antipattern - Entity-Attribute-Value
8. Logical Antipattern - Polymorphic Associations
9. Logical Antipattern - Multicolumn Attributes
10. Logical Antipattern - Metadata Tribbles

Course Assessment

Assessment: Logical Antipatterns - Part 2
12. Physical Antipattern - Rounding Errors
13. Physical Antipattern - 31 Flavors
14. Physical Antipattern - Phantom Files
15. Physical Antipattern - Index Shotgun

Course Assessment

Assessment: Physical Antipatterns
17. Query Antipattern - Fear of the Unknown
18. Query Antipattern - Ambiguous Groups
19. Query Antipattern - Random Selection
20. Query Antipattern - Poor Man’s Search Engine
21. Query Antipattern - Spaghetti Query
22. Query Antipattern - Implicit Columns

Course Assessment

Assessment: Query Antipattern
24. Application Development Antipattern - Readable Passwords
25. Application Development Antipattern - SQL Injection
26. Application Development Antipattern - Pseudokey Neat-Freak
27. Application Development Antipattern - See No Evil
28. Application Development Antipattern - Diplomatic Immunity
29. Application Development Antipattern - Magic Beans

Course Assessment

Assessment: Application Development Antipattern

Join more than 1.6 million learners from companies like

What our learners are saying

What our learners are saying

COURSE BY:

The Pragmatic Programmers

Teams of every size choose
Educative for Business
to train, upskill & onboard their developers