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 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

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.

Learning about SQL commands

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

Group by, Where, Aggregate function in MSSQL Server

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

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

Using Mysql to better estimate the prices of different properties.

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.

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

How To Create SQL Custom User-Defined Aggregate Functions

core data (complex search and filter)

SQL Case Studies Solutions for #8WeekSQLChallenge

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