#Sql

Tags: 10 posts

November 27, 2025 • 2 min read

Advanced SQL: Window Functions & CTEs

Advanced SQL: Window Functions & CTEs Building on our SQL basics, this post explores powerful features that allow for complex data analysis directly within the database. Common Table Expressions (CTEs) CTEs provide a way to write auxiliary …
Read More
SQL Database
November 25, 2025 • 8 min read

SQL Basics & Query Patterns

SQL Basics & Query Patterns Master the fundamentals of SQL with practical examples and essential patterns for data retrieval, filtering, and manipulation. This guide covers core concepts that form the foundation of database operations. …
Read More
SQL Database
December 1, 2019 • 1 min read

Hackerrank SQL - Aggregation

Following problems are discussed here. To solve the same, please visit hackerrank website{:target="_blank"}. Weather Observation Station 17 Weather Observation Station 18 Weather Observation Station 19 Weather Observation Station 20 …
Read More
tsql
December 1, 2019 • 2 min read

Hackerrank SQL - Advanced Select

Following problems are discussed here. To solve the same, please visit hackerrank website{:target="_blank"}. New Companies Binary Tree Nodes Occupations The PADS Type of Triangle New Companies select company.company_code, company.founder, …
Read More
tsql
January 1, 2019 • 2 min read

T-SQL - Working with subqueries and APPLY

Note : The following scripts are the part of the course on edx titled as: Querying Data with Transact-SQL - Querying Data with Transact-SQL These queries works on AdventureWorks database and information regarding the same can be accessed by visiting …
Read More
tsql
January 1, 2019 • 6 min read

T-SQL - Using Functions and aggregating data

``Note : The following scripts are the part of the course on edx titled as: Querying Data with Transact-SQL - `` [Querying Data with Transact-SQL](https://www.edx.org/course/querying-data-with-transact-sql-0) `` These queries works on AdventureWorks …
Read More
tsql
January 1, 2019 • 3 min read

T-SQL - Querying multiple tables with Joins

Note : The following scripts are the part of the course on edx titled as: Querying Data with Transact-SQL - Querying Data with Transact-SQL These queries works on AdventureWorks database and information regarding the same can be accessed by visiting …
Read More
tsql
January 1, 2019 • 1 min read

T-SQL - Querying multiple tables using Set Operators

Note : The following scripts are the part of the course on edx titled as: Querying Data with Transact-SQL - Querying Data with Transact-SQL These queries works on AdventureWorks database and information regarding the same can be accessed by visiting …
Read More
tsql
January 1, 2019 • 5 min read

T-SQL - Introduction (Part 2)

Note : The following scripts are the part of the course on edx titled as: Querying Data with Transact-SQL - Querying Data with Transact-SQL These queries works on AdventureWorks database and information regarding the same can be accessed by visiting …
Read More
tsql
January 1, 2019 • 6 min read

T-SQL - Introduction (Part 1)

Note : The following scripts are the part of the course on edx titled as: Querying Data with Transact-SQL - Querying Data with Transact-SQL These queries works on AdventureWorks database and information regarding the same can be accessed by visiting …
Read More
tsql
Back to All Tags