Oracle SQL Hands On Practical Step By Step Training

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.

Homepage

https://www.udemy.com/course/sql-for-beginners-easy-to-follow-video-lectures/