This Oracle Database SQL Workshop course offers students an introduction to relational databases like Oracle Database
Students will learn the concepts of relational databases and the powerful SQL programming language. This course provides the
essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables,
and create database objects.
Learning SQL is a very useful skill to have as every business and organisation is so dependent on data. There are not enough skilled SQL professionals hence the demand and pay rate for SQL professionals is quite high.
SQL stands for structured query language. It is an international standard language
used to query and manipulate databases. There are different types of database
vendors like Oracle, Microsoft ,MySQL and so on . They all support SQL and
performs certain operations in the same way. Keywords like CREATE,SELECT,UPDATE,
DELETE,WHERE and FROM are used the same way with various database vendors.
This course will teach you the skills you need to get your foot in the door
as an SQL professional. With the skills you learn on this course you can work
confidently as a data analyst or even progress to be a database administrator.
This course will take from scratch to more advanced SQL using TOAD
Students will Learn To:
Identify what a SQL statement is.
Understand the Oracle Relational Database.
Use TOAD to connect to Oracle database and perform SQL tasks
Manipulate data in relational tables
Display data from multiple tables
Use of the DESCRIBE command
Create reports of sorted and restricted data
Retrieve row and column data from tables with the SELECT statement
Students will use TOAD as the main environment tool for writing SQL.
How to retrieve data using SELECT Statement
How to restrict and sort data
How to use Single Row functions
How to display data from multiple tables using joins
How to use SET operators
How to use Data Definition Language
How to use Data Manipulation Language
How to use Clauses