دانلود فیلم آموزش SQL توسط پایگاه داده اوراکل

Requirements
Basic database concepts
Basic SQL
Basic computer knowledge
Basic internet navigation
Description
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

Who is the target audience?
Application Developers
Database Administrators
Forms Developers
Functional Implementer
PL/SQL Develpper
System Analysts
Courses :
Database Setup
Retrieving Data using SQL SELECT Statement
Restricting and Sorting Data
Using Single -Row Functions to Customize Output
Displaying Data From Multiple Tables Using Joins
Using the SET operators
Introduction to Data Definition Language |Data Manipulation Language