siva19871025 Goto Github PK

beyond-leetcode-sql

Analysis of SQL Leetcode and classic interview questions. Common pitfalls, anti-patterns and handy tricks are discussed. Sample databases are provided.

complex-sql-exercise

SQL queries of all kind being put together as a single repository

crackingthesqlinterview

compilation of SQL interview Questions - http://xoraus.github.io/CrackingTheSQLInterview/

dataproc-python-demo

Demonstration of Google Cloud Dataproc for running PySpark jobs

dataproc-sparkjob_by_shell_script

Create a spark job then submit to dataproc then store result to the BigQuery

dbeskow-byte1

dsc-sql-interview-questions-lab-staff

dse230_final_plane

example_dataproc_twitter

This repository is used as source code for the medium post about implementing a Twitter recommender system using GCP.

google-cloud-ecommerce_complete_pipeline

ecommerce GCP Streaming pipeline ― Cloud Storage, Compute Engine, Pub/Sub, Dataflow, Apache Beam, BigQuery and Tableau; GCP Batch pipeline ― Cloud Storage, Dataproc, PySpark, Cloud Spanner and Tableau

google-dataproc-job-cost-estimator

Cost estimation for Google Dataproc jobs

leetcode

LeetCode In Action - Python (705+)

pubsub

First demo pubsub

py-dataproc_job_wrapper

A Python wrapper around the Google Dataproc client

python-dataupdate-dataprocessor-kbn

The python module can be used to scrape data and process data from different sources. The python module can output data as either as a dataframe in the country year format or it will output data in excel files This module has primarily been created for processing data for the International Futures (IFs) Project however, it can be used to process data in general. The module can be used to process data from the following sources, 1) World Bank World Development Indicators (WDI) 2) UNESCO Education indicators(UIS) 3) FAO Food Balance Sheets (FAO) 4) IMF Global Finance Statistics (IMF GFS) 5) Health data from the Institute for Health and Metric Evaluation (IHME) 6) Water data from FAO AQUASTAT 7) Energy data from EIA Currently this module can be run as is on Windows. For usage on Macs, the user may have to make changes to the code lines which specify paths.

sql

Curated Repo for SQL commands

sql-1

sql related stuff, interview questions, mySQL complex queries

sql-advanced-queries

SQL Practice Queries

sql-complex-queries

Here I post some SQL queries

sql-data-analysis-and-visualization-projects

SQL data analysis & visualization projects using MySQL, PostgreSQL, SQLite, Tableau, Apache Spark and pySpark.

sql-exercise

Practice with "Real" SQL Problems

sql-interview-prep-question

This repository is for everyone who is preparing for Data Scientist/Data Analyst position interviews. It includes frequently asked SQL coding questions with answers.

sql-interview-questions

List of Top 500 SQL Interview Questions & Answers with queries and more

sql-leetcode-challenge

Contains all the 117 Leetcode questions with their solutions ranging from Easy to Hard in MySQL.

sql-practice

Practice Problems For SQL Queries

sql-query-examples

Northwind Database Query Examples

sqlcheck

Automatically identify anti-patterns in SQL queries

sysinfo

Python based scripts for obtaining system information from Linux.

writing-complex-sql-queries

Answering business questions using complex queries in SQL about the "Chinook" database. Focused on creating views, aggregate functions, and joins. Running Sqlite from within Jupyter Notebook (in Python 3).