Sergey Filimonov Filimoa

Setting up github and bitbucket on the same computer (Windows)

Guide for Windows

mix3d asked for some help using this guide with windows so here we go. This was tested with Windows 10. Run all commands in Git Bash once it's installed.

Github will be the main account and bitbucket the secondary.

Git for Windows

Download and install Git for Windows
- In the installer, select everything but decide if you want a desktop icon (2nd step)

Installing Postgres via Brew

Pre-Reqs

Brew Package Manager

In your command-line run the following commands:

brew doctor
brew update

Prepare for SQL interview questions

Tutorial

SQL tutorial: https://tutorial.techaltum.com/SQLServer.html

Sample questions and solutions

SQl subquery: https://www.dofactory.com/sql/subquery
SQL Query Questions and Answers for Practice: http://www.complexsql.com/sql-query-questions-and-answers-for-practice/
Database/SQL Interview Questions: https://www.programmerinterview.com/index.php/database-sql/introduction/
50 SQL Query Questions And Answers For Practice: https://www.techbeamers.com/sql-query-questions-answers-for-practice/

	import heapq

	def schedule(tasks):
	heap = []
	def offer(begin, end):
	while heap and heap[0] <= begin:
	heapq.heappop(heap)
	heapq.heappush(heap, end)
	return len(heap)

	"""
	Based off Stripe's checkout repo, see the link for the Flask analogue.

	https://github.com/stripe-samples/checkout-one-time-payments/blob/master/server/python/server.py

	Assumes project is structured like:

	src/
	backend/
	app.py

	#!/usr/bin/env ipython -i
	import datetime
	import json
	from typing import Optional

	import sqlalchemy as sa
	from sqlalchemy.orm import declarative_base, sessionmaker
	from sqlalchemy.dialects.postgresql import JSONB

	from pydantic import BaseModel, Field, parse_obj_as

	import re
	from typing import Dict
	from io import StringIO
	from dateutil import parser

	from sqlalchemy import create_engine
	import pandas as pd

	def is_date(string):
	if string.isnumeric():