A dynamic SOQL and SOSL query builder on Salesforce.com platform

This project analyzes ride share app data. Demonstrates use of Python, Matplotlib, reading csv files, converting to dataframes, performing aggregate functions, and creating bubble plot and pie chart visualizations of data.

Basic MS-SQL queries to help beginners understand SQL concepts.

I show examples working in database with SQL. Here I gave information about both reading and creating a database. I explained each step with comment lines.

basic sequel codes (with proper syntaxes and definitions) for Data Analysis and Business Intelligence.

Extending sqlite extension-functions to support median aggregate function as a window function. See https://www.sqlite.org/contrib. Forked from https://gitlab.com/liamh/extension-functions

Using Mysql to better estimate the prices of different properties.

Use SQL knowledge to explore the tables and create queries for each tasks using sqlalchemy and pandas to print and store query results.

Creating an employee database from flat files with PostgreSQL to address upcoming vacancies

Usage of MySQL - Joins,String/Date functions,aggregation concepts,conditional queries,subqueries,Window functions

Few more basic additional MS-SQL queries in addition to my previous repository to help beginners understand the concepts more deeply.Here we make use of readily available database 'WideWorldImportersDW-Full.bak' to perform our SQL queries.

Group by, Where, Aggregate function in MSSQL Server

Hide the group footer for a specific group level in a Data Grid control.

Learning about SQL commands

How To Create SQL Custom User-Defined Aggregate Functions

core data (complex search and filter)

SQL Case Studies Solutions for #8WeekSQLChallenge

In this repository, I have solved all the questions present on LeetCode for SQL (MySQL)

Customize the grid's footer menu and calculate custom totals.