Ahmed Samir (@AhmedSamir)

SQL Queries For Mere Mortals: Thinking In Sets Part 2

Sets Continued In Part One we talk about concept of sets, operations on sets, started with the first one which is intersection. Now in This part we'll complete our journey in sets by talking about the other two operations which are difference and ...

May 9, 2022 · 10 min readsamra.hashnode.dev

SQL Queries For Mere Mortals: Thinking In Sets Part 1

What Is a Set, Anyway? If you remember in high school, you might have studied set theory in a mathematics course. If you were introduced to set algebra, you probably wondered why any of it would ever be useful. A set can be as little as the data...

May 9, 2022 · 8 min readsamra.hashnode.dev

SQL Queries For Mere Mortals: Filtering Your Data

Refining What You See Using WHERE The type of SELECT statement we’ve worked with so far retrieves all the rows from a given table and uses them in the statement’s result set. This is great if you really do need to see all the information the tabl...

1Apr 17, 2022 · 15 min readsamra.hashnode.dev

SQL Queries For Mere Mortals: Creating a Simple Query

Simple Select Statment: Don't write SQL Query immediately after reading the problem statement: Search for nouns in the problem statement as it may be a table name or a column name. Map the extracted nouns with the suitable table and column names....

Mar 19, 2022 · 3 min readsamra.hashnode.dev

Ahmed Samir

About

Available for

Ahmed Samir's blogs

SQL Queries For Mere Mortals: Thinking In Sets Part 2

SQL Queries For Mere Mortals: Thinking In Sets Part 1

SQL Queries For Mere Mortals: Filtering Your Data

SQL Queries For Mere Mortals: Creating a Simple Query

Ahmed Samir

About

Available for

Ahmed Samir's blogs

SQL Queries For Mere Mortals: Thinking In Sets Part 2

SQL Queries For Mere Mortals: Thinking In Sets Part 1

SQL Queries For Mere Mortals: Filtering Your Data

SQL Queries For Mere Mortals: Creating a Simple Query

Ahmed Samir

About

Available for

Ahmed Samir's blogs

SQL Queries For Mere Mortals: Thinking In Sets Part 2

SQL Queries For Mere Mortals: Thinking In Sets Part 1

SQL Queries For Mere Mortals: Filtering Your Data

SQL Queries For Mere Mortals: Creating a Simple Query

Search Hashnode

Ahmed Samir

About

Available for

Ahmed Samir's blogs

SQL Queries For Mere Mortals: Thinking In Sets Part 2

SQL Queries For Mere Mortals: Thinking In Sets Part 1

SQL Queries For Mere Mortals: Filtering Your Data

SQL Queries For Mere Mortals: Creating a Simple Query