Miguel Corral Jr. corralm

## .zshrc
export ZSH="$HOME/.oh-my-zsh"
ZSH_THEME="robbyrussell"

# plugins
plugins=(
  git
  macos
  vscode
  zsh-autosuggestions
  zsh-safe-rm

## sql_practice.ipynb

      
              1 file
            
          
              1 fork
            
          
                0 comments
              
            
              2 stars
            
          
                corralm
                / sql_practice.ipynb
            
            
              Last active
              April 25, 2026 05:25
            
              
                [Medium] SQL Queries on Employee db
              
          
      Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## top_10_salaries.py
# single-line query
%sql SELECT salary FROM salaries ORDER BY salary DESC LIMIT 10

# multi-line query (use double %%)
%%sql
SELECT salary
FROM salaries
ORDER BY salary DESC
LIMIT 10

## tips.py
# limits displayed results; entire set is still pulled into memory
%config SqlMagic.displaylimit=<int>

# limits the result set (good for large sets that can slow down your browser)
%config SqlMagic.autolimit=<int>

# return Pandas DataFrames instead of regular result sets
%config SqlMagic.autopandas=True

## sqlalchemy.csv

          
            Dialect
            Driver
            Conda Install Driver

            
              MySQL
              PyMySQL
              conda install -c anaconda pymysql

            
              PostgreSQL
              Pyscopg2
              conda install -c conda-forge psycopg2

            
              SQLite
              Pysqlite
              conda install -c prometeia pysqlite

            
              Oracle
              Cx Oracle
              conda install -c anaconda cx_oracle

            
              Microsoft SQL Server
              Pyodbc
              conda install -c conda-forge pyodbc

## sql_pandas.py
# assign to variable (single-line)
top_10_salaries = %sql SELECT salary FROM salaries ORDER BY salary DESC LIMIT 10

# assign to variable (multi-line)
%%sql top_10_salaries <<
SELECT salary
FROM salaries
ORDER BY salary DESC
LIMIT 10

## sql_connection.py
# load the ipython-sql extension
%load_ext sql

# Option1: Show credentials
%sql mysql+pymysql://user:pass@localhost:3306/employees

# Option2: Hide password using getpass
import getpass
user = 'miguel'
password = getpass.getpass()
	export ZSH="$HOME/.oh-my-zsh"
	ZSH_THEME="robbyrussell"

	# plugins
	plugins=(
	git
	macos
	vscode
	zsh-autosuggestions
	zsh-safe-rm
	# single-line query
	%sql SELECT salary FROM salaries ORDER BY salary DESC LIMIT 10

	# multi-line query (use double %%)
	%%sql
	SELECT salary
	FROM salaries
	ORDER BY salary DESC
	LIMIT 10
	# limits displayed results; entire set is still pulled into memory
	%config SqlMagic.displaylimit=<int>

	# limits the result set (good for large sets that can slow down your browser)
	%config SqlMagic.autolimit=<int>

	# return Pandas DataFrames instead of regular result sets
	%config SqlMagic.autopandas=True
Dialect	Driver	Conda Install Driver
MySQL	PyMySQL	conda install -c anaconda pymysql
PostgreSQL	Pyscopg2	conda install -c conda-forge psycopg2
SQLite	Pysqlite	conda install -c prometeia pysqlite
Oracle	Cx Oracle	conda install -c anaconda cx_oracle
Microsoft SQL Server	Pyodbc	conda install -c conda-forge pyodbc
	# assign to variable (single-line)
	top_10_salaries = %sql SELECT salary FROM salaries ORDER BY salary DESC LIMIT 10

	# assign to variable (multi-line)
	%%sql top_10_salaries <<
	SELECT salary
	FROM salaries
	ORDER BY salary DESC
	LIMIT 10
	# load the ipython-sql extension
	%load_ext sql

	# Option1: Show credentials
	%sql mysql+pymysql://user:pass@localhost:3306/employees

	# Option2: Hide password using getpass
	import getpass
	user = 'miguel'
	password = getpass.getpass()