PowerBI Data Analyst - Create visualizations and dashboards from scratch
Learn AI, Data Science & Business — Earn Certificates That Get You Hired
Overview
Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
Follow a comprehensive installation and setup guide for MySQL and PostgreSQL on both MacOS and Windows systems. Learn the step-by-step process of installing different database engines, connecting to database servers using various clients, and configuring Visual Studio Code with SQL tools. Explore the specific setup procedures for MySQL and PostgreSQL on each operating system, and gain insights into essential configurations for optimal database management.
Syllabus
Intro
Installing Different Database Engines
What we Need to Install
MySQL Setup Overview & macOS Setup
MySQL Windows Setup
PostgreSQL macOS Setup
PostgreSQL Windows Setup
Connecting to DB Servers with Various Clients
Setting up Visual Studio Code with SQL Tools
Configuring the VS Code Extension & the MySQL Database
Taught by
Academind