Menu

Free Course – Kick off your SQL skills with Oracle Database SQL Workshop

ฟรี Course : Kick off your SQL skills with Oracle Database SQL Workshop

[youtube]https://www.youtube.com/watch?v=Yd6peDlPrNE[/youtube]
Instructed by :  Bluelime Learning Solutions
Credit : Udemy.com

 

Link to : Kick off your SQL skills with Oracle Database SQL Workshop

This Oracle Database SQL Workshop course offers students an introduction to relational databases  like  Oracle Database

technology.
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

What are the requirements?

  • Basic database concepts
  • Basic SQL
  • Basic computer knowledge
  • Basic internet navigation

What am I going to get from this course?

  • Retrieve data from Oracle Database
  • Restrict Data from Oracle Database
  • Sort Data from Oracle Database
  • Identify SQL Statement
  • Understand Oracle Relational Database
  • Use TOAD
  • Manipulate data in Oracle Database
  • Create Database Objects using Data Definition Language
  • Create Views
  • Use SET operators
  • Display data from multiple tables

What is the target audience?

  • Application Developers
  • Database Administrators
  • Forms Developers
  • Functional Implementer
  • PL/SQL Develpper
  • System Analysts


Link to : Kick off your SQL skills with Oracle Database SQL Workshop

No comments

Leave a Reply

Categories

open all | close all

Archives

open all | close all

The website for people working in the oracle.