YoVDO

Master SQL with Python: Maintaining Data in Oracle Using Merge - Lesson 14

Offered By: Bryan Cafferky via YouTube

Tags

SQL Courses Python Courses Oracle Courses pandas Courses Database Management Courses

Course Description

Overview

Learn how to keep data current in Oracle tables using the Merge statement in this 29-minute video tutorial. Discover techniques for inserting, updating, and deleting rows to maintain up-to-date data for analysis. Explore the integration of pandas with Oracle, making the coding and implementation process straightforward. Gain access to demonstration code that can be applied to various tasks, including querying Oracle tables. Find the content and resources on GitHub, and consider watching the companion video on using SQL Server with ODBC for a comprehensive understanding of enterprise database management with Python.

Syllabus

Introduction
What is Merge
Create Table
Save Table
Read SQL
All Tables
Transactions
Columns
Merge
Oracle Connection
Demo
Summary


Taught by

Bryan Cafferky

Related Courses

Computational Investing, Part I
Georgia Institute of Technology via Coursera
Введение в машинное обучение
Higher School of Economics via Coursera
Математика и Python для анализа данных
Moscow Institute of Physics and Technology via Coursera
Introduction to Python for Data Science
Microsoft via edX
Python for Data Science
University of California, San Diego via edX