List: DataBase | Curated by Mayurkumar Surani

Dec 21, 2023
19 stories
DataBase
In
Women in Technology
by
Tanushree
SQL interview questions you must know - Part 1Below is the list of questions I have faced in various interviews over a 8+ years of my career.
Jul 12, 2023
2
Jul 12, 2023
2
In
TDS Archive
by
Iffat Malik
Commonly Asked Interview Question: Where vs Having vs QualifyBack To Basics | SQL fundamentals for beginners
Sep 22, 2022
1
Sep 22, 2022
1
In
TDS Archive
by
Iffat Malik
Anatomy of SQL Window FunctionsBack To Basics | SQL fundamentals for beginners
Mar 30, 2023
8
Mar 30, 2023
8
In
TDS Archive
by
Thuwarakesh Murallie
Junior Developers Write Multi-Page SQL Queries; Seniors Use Window FunctionsAn elegant way to perform computation within the context of a record
Mar 13, 2023
Mar 13, 2023
In
TDS Archive
by
Thuwarakesh Murallie
These 5 SQL Techniques Cover ~80% of Real-Life ProjectsSpeed up your SQL learning curve.
Mar 8, 2023
4
Mar 8, 2023
4
In
Coders Mojo
by
Naina Chaturvedi
Day 6 of 15 Days of Advanced SQL SeriesWelcome back peeps. Hope all’s well. Last two weeks have been crazy busy at work for me (plus I was traveling).
Nov 3, 2022
Nov 3, 2022
In
TDS Archive
by
Kenneth Leung
PyMySQL — Connecting Python and SQL for Data ScienceEasily access MySQL databases and execute SQL queries in Python
Sep 13, 2022
3
Sep 13, 2022
3
In
TDS Archive
by
Cassie Kozyrkov
How to create a sampling plan for your data projectWhen simple random sampling is not that simple
Aug 17, 2022
1
Aug 17, 2022
1
In
Analytics Vidhya
by
Katie Huang Xiemin
8 Week SQL Challenge: Case Study #2 Pizza RunnerUsing MS SQL Server to analyse Pizza Runner
Aug 2, 2021
10
Aug 2, 2021
10
In
Analytics Vidhya
by
Katie Huang Xiemin
8 Week SQL Challenge: Case Study Week #1 Danny’s DinerUsing SQL to analyse Danny’s Diner data to discover customers’ visiting patterns, spending habits and favourite menu item.
Jul 15, 2021
29
Jul 15, 2021
29
In
DataDrivenInvestor
by
Naina Chaturvedi
Big Query SQL on Google Cloud Platform — Part 1Basics, hacks and techniques…
Oct 28, 2020
Oct 28, 2020
In
TDS Archive
by
Suraj Gurav
3 Ultimate Ways To Find Unique Records In SQLStop using DISTINCT! Start using these quick alternatives to avoid confusions!
Jun 9, 2022
2
Jun 9, 2022
2
In
TDS Archive
by
Emma Ding
Top Mistakes to Avoid in Your 2022 Data Science Job SearchThe 3 Most Common Data Science Job Search Mistakes and Tips to Avoid Them
Jun 3, 2022
3
Jun 3, 2022
3
 This story is no longer available
In
TDS Archive
by
Suraj Gurav
5 Practical SQL Queries You Should Know In 2022Master these time-saving and powerful SQL Queries quickly!
Jun 2, 2022
1
Jun 2, 2022
1
In
Learning SQL
by
Andreas Martinson
The Ultimate List of Free SQL Learning ResourcesYou don’t need to pay money to learn SQL
May 31, 2022
3
May 31, 2022
3
In
TDS Archive
by
Terence Shin, MSc, MBA
Best Practices for Writing Good SQL CodeIntroduction
Apr 14, 2022
1
Apr 14, 2022
1
In
TDS Archive
by
Ivo Bernardo
4 SQL Filtering Concepts to improve your Data Wrangling GameLet’s learn about some common SQL filtering tricks data scientists can use to speed up their queries
Apr 8, 2022
Apr 8, 2022
In
SelectFrom
by
Uğur Savcı
10 SQL Queries You Should Know as a Data ScientistLearn the Most Used SQL Queries in 5 Minutes with Examples
Mar 9, 2022
31
Mar 9, 2022
31