Oracle Sql : Hands On Practical Step By Step Training

Learn how to build SQL Query and manipulate data from a database step by step using TOAD for oracle to connect .

What you'll learn
Connect to Oracle database with TOAD
Write SQL Queries from scratch
Write SQL Queries to sort data returned from database.
Insert data into table
Update records in database
Requirements
Sample Oracle Database
Toad For Oracle Editor
Description
This course teaches beginners what SQL is and how it works. The course materials are all videos making it easy to follow along. The course is less than 2 hours long and structured in a logical and easy to follow functional way. This course is easy to follow and will teach a beginner how to create , read , update and delete data from a database. (C.R.U.D) which are the four main things that SQL is used for on a database. The video courses includes: SQL SUB LANGUAGES Creating Tables Updating Data Deleting Data Reading Data Restricting and Sorting Data Adding Data to Database Operators Data types and Constraints

Overview

Section 1: Setting Up Your Lab

Lecture 1 Introduction

Lecture 2 Download and Install Oracle Database

Lecture 3 How to Unlock Sample HR Account

Lecture 4 Download and Install Toad For Oracle

Lecture 5 Connecting to Database with Toad

Section 2: How SQL Works

Lecture 6 SQL Sub Languages

Lecture 7 Creating Tables Part 1

Lecture 8 Creating Tables Part 2

Lecture 9 View and dual table

Lecture 10 Reading Data Using Select

Lecture 11 Restricting and Sorting Data

Lecture 12 Adding Data To Tables

Lecture 13 Updating and Deleting Data

Lecture 14 How to Alter , Truncate and Drop A Table

Lecture 15 Operators

Lecture 16 Data Types and Constraints

Section 3: Conclusion

Lecture 17 Conclusion

Lecture 18 Thank You

This course is suitable for IT Professionals and anyone who wants to learn SQL quickly with easy to follow videos.