Introduction

What is SQL Server

SQL Server Editions

Download SQL Server

Install SQL Server Management Studio

Install Sample Database

Connect SSMS to SQL Server

What is Visual Studio

Install Visual Studio

Install Visual Studio Data Tools - SSDT

Visual studio workloads

Install SSIS Visual Studio Extension

What is SSIS

What is ETL

Install Source Database

Create a new SSIS Project

Create destination database

Configure data source and data destination

Data Transformation

Running SSIS Package

What is Python

Installing Python on Windows

Installing Python on Macs

Create a virtual environment on Windows

Activate a virtual environment on Windows

Activate a virtual environment on Macs

Updating Pip

Create a virtual environment on Macs

Install Visual Studio Code

Install Beautiful Soup

What is web scraping

What we will scrape

Building the web scraping script part 1

Building the web scraping script part 2

Prototyping the script Part 1

Prototyping the script Part 2

Prototyping the script Part 4

Prototyping the script Part 3

Prototyping the script Part 5

Testing the script

Install Python Packages

Create a Python File

Send emails from Python

Create Variables

Create functions Part 1

Testing the Script

Create functions Part 2

Create functions Part 3

What is an API

YouTube Data API

Building the first Scraper Part 1

Testing the first scraper

Building the first Scraper Part 3

Building the first Scraper Part 2

Using Google Sheets to save scraped data

Building the second Scraper

Testing the second scraper

Install Oracle

Unlock Sample Schema

Connect SQL Developer to Oracle

Install Oracle SQL Developer

Creating database user

Creating repository

Configuring third party database connection part 2

Capturing source data

Converting captured model to Oracle

Configuring third party database connection part 1

Generating scripts to create target database

Moving data from SQL Server into Oracle

Translating third party T-SQL Objects to Oracle