How to generate SQL Insert Update queries from Excel

[mitsumi]

How to generate SQL Insert / Update queries from Excel
.MP4 | Video: 1280x720, 30 fps(r) | Audio: AAC, 44100 Hz, 2ch | 0.97 GB
Duration: 2.5 hours | Genre: eLearning Video | Language: English

Create bulk SQL Queries from Excel

What you'll learn

    Install Oracle Relational Database Management System
    Install TOAD
    Install Oracle SQL Developer
    Accessing Microsoft Excel
    Using Sample data
    Create database table
    Prep Data
    Create Bulk SQL Insert queries
    Create Bulk SQL Update queries
    Query database

Requirements

    Basic understanding of SQL
    Basic understanding of Oracle

Description

As a database developer and administrator you will create queries frequently. Sometimes you also need to generate bulk  SQL queries to insert or update multiple records; Microsoft Excel can be used to generate bulk queries that you can execute on a database server.

SQL is the standard language used to interact with databases.

In this course i will show you how to build SQL scripts from scratch step by step that you will use during the course to execute insert and update bulk tasks. The skills you will learn on this course will help you confidently approach any bulk SQL request task you in a live production environment.

Who this course is for:

    Beginner SQL Developers
    Beginners to Oracle Database Administrators
       

               
 

Download link:

Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction