\documentclass[10pt,a4paper]{article}

% Packages
\usepackage{fancyhdr}           % For header and footer
\usepackage{multicol}           % Allows multicols in tables
\usepackage{tabularx}           % Intelligent column widths
\usepackage{tabulary}           % Used in header and footer
\usepackage{hhline}             % Border under tables
\usepackage{graphicx}           % For images
\usepackage{xcolor}             % For hex colours
%\usepackage[utf8x]{inputenc}    % For unicode character support
\usepackage[T1]{fontenc}        % Without this we get weird character replacements
\usepackage{colortbl}           % For coloured tables
\usepackage{setspace}           % For line height
\usepackage{lastpage}           % Needed for total page number
\usepackage{seqsplit}           % Splits long words.
%\usepackage{opensans}          % Can't make this work so far. Shame. Would be lovely.
\usepackage[normalem]{ulem}     % For underlining links
% Most of the following are not required for the majority
% of cheat sheets but are needed for some symbol support.
\usepackage{amsmath}            % Symbols
\usepackage{MnSymbol}           % Symbols
\usepackage{wasysym}            % Symbols
%\usepackage[english,german,french,spanish,italian]{babel}              % Languages

% Document Info
\author{thatjeffsmith (thatjeffsmith)}
\pdfinfo{
  /Title (sqldev-kb-shortcuts-os-x.pdf)
  /Creator (Cheatography)
  /Author (thatjeffsmith (thatjeffsmith))
  /Subject (SQLDev KB Shortcuts OS X Cheat Sheet)
}

% Lengths and widths
\addtolength{\textwidth}{6cm}
\addtolength{\textheight}{-1cm}
\addtolength{\hoffset}{-3cm}
\addtolength{\voffset}{-2cm}
\setlength{\tabcolsep}{0.2cm} % Space between columns
\setlength{\headsep}{-12pt} % Reduce space between header and content
\setlength{\headheight}{85pt} % If less, LaTeX automatically increases it
\renewcommand{\footrulewidth}{0pt} % Remove footer line
\renewcommand{\headrulewidth}{0pt} % Remove header line
\renewcommand{\seqinsert}{\ifmmode\allowbreak\else\-\fi} % Hyphens in seqsplit
% This two commands together give roughly
% the right line height in the tables
\renewcommand{\arraystretch}{1.3}
\onehalfspacing

% Commands
\newcommand{\SetRowColor}[1]{\noalign{\gdef\RowColorName{#1}}\rowcolor{\RowColorName}} % Shortcut for row colour
\newcommand{\mymulticolumn}[3]{\multicolumn{#1}{>{\columncolor{\RowColorName}}#2}{#3}} % For coloured multi-cols
\newcolumntype{x}[1]{>{\raggedright}p{#1}} % New column types for ragged-right paragraph columns
\newcommand{\tn}{\tabularnewline} % Required as custom column type in use

% Font and Colours
\definecolor{HeadBackground}{HTML}{333333}
\definecolor{FootBackground}{HTML}{666666}
\definecolor{TextColor}{HTML}{333333}
\definecolor{DarkBackground}{HTML}{BB0000}
\definecolor{LightBackground}{HTML}{FCF7F7}
\renewcommand{\familydefault}{\sfdefault}
\color{TextColor}

% Header and Footer
\pagestyle{fancy}
\fancyhead{} % Set header to blank
\fancyfoot{} % Set footer to blank
\fancyhead[L]{
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{C}
    \SetRowColor{DarkBackground}
    \vspace{-7pt}
    {\parbox{\dimexpr\textwidth-2\fboxsep\relax}{\noindent
        \hspace*{-6pt}\includegraphics[width=5.8cm]{/web/www.cheatography.com/public/images/cheatography_logo.pdf}}
    }
\end{tabulary}
\columnbreak
\begin{tabulary}{11cm}{L}
    \vspace{-2pt}\large{\bf{\textcolor{DarkBackground}{\textrm{SQLDev KB Shortcuts OS X Cheat Sheet}}}} \\
    \normalsize{by \textcolor{DarkBackground}{thatjeffsmith (thatjeffsmith)} via \textcolor{DarkBackground}{\uline{cheatography.com/24419/cs/6041/}}}
\end{tabulary}
\end{multicols}}

\fancyfoot[L]{ \footnotesize
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{LL}
  \SetRowColor{FootBackground}
  \mymulticolumn{2}{p{5.377cm}}{\bf\textcolor{white}{Cheatographer}}  \\
  \vspace{-2pt}thatjeffsmith (thatjeffsmith) \\
  \uline{cheatography.com/thatjeffsmith} \\
        \uline{\seqsplit{www}.thatjeffsmith.com}
  \end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}}  \\
   \vspace{-2pt}Published 10th November, 2015.\\
   Updated 10th May, 2016.\\
   Page {\thepage} of \pageref{LastPage}.
\end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Sponsor}}  \\
  \SetRowColor{white}
  \vspace{-5pt}
  %\includegraphics[width=48px,height=48px]{dave.jpeg}
  Measure your website readability!\\
  www.readability-score.com
\end{tabulary}
\end{multicols}}




\begin{document}
\raggedright
\raggedcolumns

% Set font size to small. Switch to any value
% from this page to resize cheat sheet text:
% www.emerson.emory.edu/services/latex/latex_169.html
\footnotesize % Small font.

\begin{multicols*}{2}

\begin{tabularx}{8.4cm}{x{3.76 cm} x{4.24 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{\{\{fa-database\}\} SQL Worksheet}}  \tn
% Row 0
\SetRowColor{LightBackground}
Execute Query & Control + Enter or fn*+ F9 \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
Execute Script & F5 \tn 
% Row Count 3 (+ 1)
% Row 2
\SetRowColor{LightBackground}
Explain Plan & F10 \tn 
% Row Count 4 (+ 1)
% Row 3
\SetRowColor{white}
Autotrace & F6 \tn 
% Row Count 5 (+ 1)
% Row 4
\SetRowColor{LightBackground}
SQL Recall & cmd + Up/Down \tn 
% Row Count 6 (+ 1)
% Row 5
\SetRowColor{white}
Recall Recall Append & cmd + Shift + Up/Down \tn 
% Row Count 8 (+ 2)
% Row 6
\SetRowColor{LightBackground}
SQL History & F8 \tn 
% Row Count 9 (+ 1)
% Row 7
\SetRowColor{white}
Completion Insight & Ctrl + Spacebar \tn 
% Row Count 10 (+ 1)
% Row 8
\SetRowColor{LightBackground}
Toggle Comment & cmd + option + / \tn 
% Row Count 11 (+ 1)
% Row 9
\SetRowColor{white}
Toggle Case & Ctrl + ' \tn 
% Row Count 12 (+ 1)
% Row 10
\SetRowColor{LightBackground}
Switch to Results & fn + cmd + down \tn 
% Row Count 13 (+ 1)
% Row 11
\SetRowColor{white}
Switch to Editor & fn + cmd + up \tn 
% Row Count 14 (+ 1)
% Row 12
\SetRowColor{LightBackground}
Open Unshared Worksheet & cmd + shift + N \tn 
% Row Count 16 (+ 2)
% Row 13
\SetRowColor{white}
DESC & ctrl + F12 \tn 
% Row Count 17 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{All function keys on Mac might require keying the 'fn' button first. Otherwise,  enable "Use all F1, F2, etc. keys as standard function keys" in your keyboard preferences. \newline  \newline You can also go into the Preferences and define the shortcut keys to any sequence, and export, import, and share these preferences with other users.}  \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{5.52 cm} x{2.48 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{\{\{fa-terminal\}\} SQLcl}}  \tn
% Row 0
\SetRowColor{LightBackground}
Run buffer immediately & Ctrl + R \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
Go to top of buffer & Ctrl + W \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
Go to bottom of buffer & Ctrl + S \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
Go to start of line & Ctrl + A \tn 
% Row Count 4 (+ 1)
% Row 4
\SetRowColor{LightBackground}
Go to end of line & Ctrl + E \tn 
% Row Count 5 (+ 1)
% Row 5
\SetRowColor{white}
Recall Previous SQL & Up or Down \tn 
% Row Count 6 (+ 1)
% Row 6
\SetRowColor{LightBackground}
File/SQL Completion & Tab \tn 
% Row Count 7 (+ 1)
% Row 7
\SetRowColor{white}
Clear Screen & Ctrl + L \tn 
% Row Count 8 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Developed with OS X 10.11}}  \tn
\SetRowColor{LightBackground}
\mymulticolumn{1}{p{8.4cm}}{\vspace{1px}\centerline{\includegraphics[width=5.1cm]{/web/www.cheatography.com/public/uploads/thatjeffsmith_1447187474_osx-logo.png}}} \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}


% That's all folks
\end{multicols*}

\end{document}