How to generate SQL Insert / Update queries from Excel

How to generate SQL Insert / Update queries from Excel, available at $19.99, with 31 lectures, and has 770 subscribers.

You will learn about 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 This course is ideal for individuals who are Beginner SQL Developers or Beginners to Oracle Database Administrators It is particularly useful for Beginner SQL Developers or Beginners to Oracle Database Administrators.

Enroll now: How to generate SQL Insert / Update queries from Excel

Summary

Title: How to generate SQL Insert / Update queries from Excel

Price: $19.99

Number of Lectures: 31

Number of Published Lectures: 31

Number of Curriculum Items: 31

Number of Published Curriculum Objects: 31

Original Price: $29.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Beginner SQL Developers
Beginners to Oracle Database Administrators

Target Audiences

Beginner SQL Developers
Beginners to Oracle Database Administrators

Excel is a spreadsheet program from Microsoft and a component of its Office product group for business applications. Microsoft Excel enables users to format, organize and calculate data in a spreadsheet.

By organizing data using software like Excel, data analysts and other users can make information easier to view as data is added or changed. Excel contains a large number of boxes called cells that are ordered in rows and columns. Data is placed in these cells.

Excel is most commonly used in business settings. For example, it is used in business analysis, human resource management, operations management and performance reporting. Excel uses a large collection of cells formatted to organize and manipulate data and solve mathematical functions. Users can arrange data in the spreadsheet using graphing tools, pivot tables and formulas. The spreadsheet application also has a macro programming language called Visual Basic for Applications.

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.

SQL can execute queries against a database
SQL can retrieve data from a database
SQL can insert records in a database
SQL can update records in a database
SQL can delete records from a database
SQL can create new databases
SQL can create new tables in a database
SQL can create stored procedures in a database
SQL can create views in a database
SQL can set permissions on tables, procedures, and views

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.

Course Curriculum

Chapter 1: Setting database management system

Lecture 1: Overview of generating SQL Statements using Excel

Lecture 2: Introduction

Lecture 3: Install Oracle RDBM

Lecture 4: Unlock sample Oracle Schema

Lecture 5: Please Read

Lecture 6: Download Toad

Lecture 7: Install Toad

Lecture 8: What is TOAD

Lecture 9: Toad quick tour

Lecture 10: Connect Toad to Oracle

Lecture 11: Install Java JDK

Lecture 12: Install Oracle SQL Developer

Lecture 13: Connect SQL Developer to Oracle

Lecture 14: What is TNSNames

Lecture 15: How to create TNSNmaes

Chapter 2: Setting up Microsoft Excel

Lecture 1: Please Read

Lecture 2: Office 365 setup

Lecture 3: What is Office 365

Lecture 4: Accessing Excel via Office 365

Chapter 3: Create Bulk SQL Queries with Excel

Lecture 1: Overview

Lecture 2: Exploring Sample Data

Lecture 3: Create a new table

Lecture 4: Prep the data

Lecture 5: Build Bulk SQL Insert queries – Part 1

Lecture 6: Build Bulk SQL Insert queries – Part 2

Lecture 7: Build Bulk SQL Update queries – Part 1

Lecture 8: Build Bulk SQL Update queries – Part 2

Lecture 9: Build Bulk Update SQL queries to delete rows – part1

Lecture 10: Build Bulk Update SQL queries to delete rows – part 2

Lecture 11: Conclusion

Lecture 12: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 0 votes
5 stars: 0 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu