Skip to content
/ SQL-For-Data-Analytics Public

Advanced SQL for Data Analytics. A collection of problem-solving solutions covering complex Joins, Window Functions, CTEs, and Query Optimization. Includes real-world interview questions, schema design, and dataset analysis for MySQL and PostgreSQL

www.kirananalyst.com/about
0 stars 0 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

obitorin07/SQL-For-Data-Analytics

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

56 Commits
Assignments
Assignments
 
 
HACKER_RANK
HACKER_RANK
 
 
Interview_Questions_data_Analytics
Interview_Questions_data_Analytics
 
 
JOINING
JOINING
 
 
SQL Preparation With Problems
SQL Preparation With Problems
 
 
WINDOW FUNCTIONS
WINDOW FUNCTIONS
 
 
cube_rollup
cube_rollup
 
 
real_world_problems_sql
real_world_problems_sql
 
 
time_travel
time_travel
 
 
DELETE_DATA.sql
DELETE_DATA.sql
 
 
INDEX.sql
INDEX.sql
 
 
README.md
README.md
 
 
UNIQUE_INDEX.sql
UNIQUE_INDEX.sql
 
 
add_column.sql
add_column.sql
 
 
aggregate_functions.sql
aggregate_functions.sql
 
 
cartesian_product.sql
cartesian_product.sql
 
 
concatenate_strings_using_concat_and_other.sql
concatenate_strings_using_concat_and_other.sql
 
 
count_Values.sql
count_Values.sql
 
 
create_table.sql
create_table.sql
 
 
create_view.sql
create_view.sql
 
 
distinct_With_count.sql
distinct_With_count.sql
 
 
groupBy avg and using CAST typecasting.sql
groupBy avg and using CAST typecasting.sql
 
 
groupBy avg.sql
groupBy avg.sql
 
 
groupBy count.sql
groupBy count.sql
 
 
groupBy sum and using round.sql
groupBy sum and using round.sql
 
 
groupBy_Counts_WIth_multiple_condition.sql
groupBy_Counts_WIth_multiple_condition.sql
 
 
inner_join_retrieve_name_department.sql
inner_join_retrieve_name_department.sql
 
 
limit and orderby and offset.sql
limit and orderby and offset.sql
 
 
order by clause with TWO args.sql
order by clause with TWO args.sql
 
 
order by clause.sql
order by clause.sql
 
 
restart_sequence_for_SERIAL_AUTO_INCREMENT.sql
restart_sequence_for_SERIAL_AUTO_INCREMENT.sql
 
 
round_value.sql
round_value.sql
 
 
split_part_Function_For_SplitString_Find_Values.sql
split_part_Function_For_SplitString_Find_Values.sql
 
 
sub_query.sql
sub_query.sql
 
 
truncate.sql
truncate.sql
 
 
unique_distinct_values.sql
unique_distinct_values.sql
 
 
update With Conditional CASE statement.sql
update With Conditional CASE statement.sql
 
 
update_date.sql
update_date.sql
 
 
using having and where clause.sql
using having and where clause.sql
 
 

Repository files navigation

SQL Practice Repository

Explore my journey learning SQL from basics to advanced topics with practical examples in MySQL and PostgreSQL.

Contents

  • SQL queries and scripts covering data retrieval, manipulation, and analysis.
  • Exercises ranging from beginner to advanced SQL techniques.

Purpose

Documenting my SQL learning journey and providing a resource for others to learn and practice SQL effectively.

Get Started

  • Browse SQL scripts for learning and practice.
  • Use examples for projects or personal learning.
  • Follow along as I progress from SQL beginner to proficient.

Tags

#SQL #MySQL #PostgreSQL #DataAnalysis #PracticeSQL

Let's learn SQL together!

About

Advanced SQL for Data Analytics. A collection of problem-solving solutions covering complex Joins, Window Functions, CTEs, and Query Optimization. Includes real-world interview questions, schema design, and dataset analysis for MySQL and PostgreSQL

www.kirananalyst.com/about

Topics

mysql sql database postgresql business-intelligence database-management sqlite3 leetcode-solutions query-optimization data-cleaning datanalysis self-taught window-functions sql-interview-questions sql-interview-questions-answers self-taught-programmer joins-group-by-case-window-functions

Resources

Readme
Activity

Stars

0 stars

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published