Skip to content

DEV Community

SQL: Zero to Ninja (A Series for Web Developers) Series' Articles

Back to Mohamed Idris's Series

May 29

Part 01: What is a Database and SQL?

#sql #database #learning

4 min read

May 29

Part 02: SELECT, Your First Questions

#database #sql #learning

4 min read

May 29

Part 03: WHERE, Filtering Rows

#sql #database #learning

4 min read

May 29

Part 04: ORDER BY and LIMIT, Sorting and Paging

#database #sql #learning

4 min read

May 29

Part 05: Counting and Grouping (Aggregates)

#sql #database #learning

4 min read

May 29

Part 06: JOINs, Connecting Tables

#sql #database #learning

5 min read

May 29

Part 07: Writing Data with INSERT, UPDATE, DELETE

#database #sql #learning

5 min read

May 29

Part 08: Designing Tables, Data Types and Constraints

#database #sql #learning

5 min read

May 29

Part 09: Relationships and Normalization

#database #sql #learning

5 min read

May 29

Part 10: Subqueries and CTEs

#database #sql #learning

5 min read

May 29

Part 11: Indexes and Performance

#database #sql #learning

5 min read

May 29

Part 12: Transactions

#database #sql #learning

4 min read

May 29

Part 13: SQL Injection and Staying Safe

#database #sql #learning

4 min read

May 29

Part 14: Window Functions (Ninja Mode)

#database #sql #learning

5 min read