Learn how to build SQL Query and manipulate data from a database step by step using TOAD for oracle to connect .
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.
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.
Course Content
- Setting Up Your Lab –> 5 lectures • 23min.
- How SQL Works –> 11 lectures • 1hr 27min.
- Conclusion –> 2 lectures • 2min.
Requirements
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