SQL Cells

Execute SQL queries against the built-in database with sample tables.

• Write SQL queries to explore the database
• Use SELECT * FROM employees to see employee data
• Browse available tables in the left sidebar
• Click the sync button to update Python with SQL data
• Run cells with Shift+Enter or Ctrl+Enter

Python Cells

Execute Python code with pandas support for data analysis.

• Tables from SQL are available as pandas DataFrames
• Use employees.head() to preview data
• Use employees.describe() for statistics
• Run pandas operations: filtering, grouping, merging
• Variables persist between cell executions
• View variables in the Variables panel (toggle on toolbar)

Keyboard Shortcuts

• Shift+Enter - Run current cell and advance to next cell
• Ctrl+Enter - Run current cell and stay in the same cell
• Up Arrow - Navigate to previous cell (when at first line)
• Down Arrow - Navigate to next cell (when at last line)
• Drag cell headers to reorder cells

Tips

• Create multiple notebooks using tabs
• Mix SQL and Python cells to combine query and analysis
• Use the "Run All" button to execute all cells in sequence
• Download notebooks as .ipynb files to open in Jupyter or JupyterLab
• Toggle sidebar and variables panel for more workspace