Personal Note For Python Connection with SQL Server/ MySQL

Introduction to Basic SQL Language

• CREATE TABLE

  • DATA STRUCTURE
  • CREATE/DROP DATABASE & TABLE
  • ADD/DELET DATA
  • SUB QUERY

• Function

  • Create Function
  • Aggregate Analytics Function (GROUP BY Function)
  • While Loop

• JOIN TABLE

  • UNION
  • JOIN

Python Connect to MySQLWorkbench

• Python Package Introduction: MySQL.Connector
• MySQL and Python Comparison (JOIN and MERGE)
• MySQL and Python Comparison (Aggregate Function and Groupby)
• MySQL and Python Comparison (Create Function and Apply Lambda)

Python Connect to SQL Server

• Useful Link to Download SQL Server on Apple Chip MacBook: https://medium.com/geekculture/how-to-install-sql-server-in-mac-m1-41121e110214

• Use Docker to set the virtual environment and use SQL Server in Azure Data Studio.

• Azure Data Studio let us write SQL in jupyter notebook file, which I believe is the most freidenly IDE when learning data-related language.

• Still Updating....