Oracle Cloud: Basic Oracle SQL with hands on Experience

Name: Oracle Cloud: Basic Oracle SQL with hands on Experience
Rating: 4.7 (51 reviews)

This training course is suitable for oracle database administration and any Oracle professional who want to learn SQL

(51 ratings)

10,788 students

Created by Zulqarnain Hayat

Last updated 4/2018

English

English [Auto]

What you'll learn

Who want to start their career as Oracle Database Administrator or Oracle Developer

Requirements

This is a basic Oracle SQL course, so there aren't any major prerequisites that you need to know before you can get started

Description

SQL language is an important skill for any Oracle professional and is the first step in suitable a true Oracle expert. As with any database platform, Oracle has its own take on the SQL language that builds on top of industry standards. In this course, I cover the basics required to code with SQL in an Oracle Database 12c environment. Learn how to select and filter data, and manipulate data using functions, including SUBSTR, UPPER, MIN, MAX, AVG, SUM, and more. Then find out how to combine data from two or more tables in a single statement with joins. Discover how to modify data with DML and DDL commands like DELETE and UPDATE, and group data with aggregate functions also include such as constraints and subqueries advance concepts. This training course is suitable for beginning database developers with no prior experience with SQL or Oracle.

Following are including:

Using Oracle SQL*Developer, the free development environment
Selecting data from tables
Filtering data
Using functions to manipulate data
Joining data from tables
Creating tables
Updating values
Truncating data
Grouping and ordering result sets
Working with primary keys
Checking constraints

Who this course is for:

Oracle Developer, Oracle Database Administrator

Zulqarnain Hayat

Enterprise Database Architect

4.1 Instructor Rating
3,922 Reviews
180,642 Students
29 Courses

I have done Master in Computer science (IT) and additionally I have more than 17 years of professional experience UNIX administration, Oracle database administration with different flavors (Solaris, Linux, Oracle Linux, Red Hat) and working as role Database specialist.I have completed command over following functions and skills.

Key Skills:

· Oracle Database Administration

· MS SQL Server Administrations

· MYSQL/MariaDB Administration

· Sun Solaris Administration (Certified)

· Linux Administration (Red Hat ,CENTOS,UBUNTU)

· Oracle Application Server Administration

· Banner UDC technology stack DBA track

· Application Administration (LAMP,LEMP)

· Oracle EBS Administration

· Oracle Database Administration (RAC, Data Guard)

· Oracle Business Intelligence Administration

· Hyperion /ESBASE/WEB LOGIC

· Windows Server Administration

· Oracle Data Warehouse Builder

· SQL Server Administration

· Project Management

· Problem solving skills and approach

· Systems audit and control

· Oracle OAM 11G,OSSO 10G EBS R12

· Data Center Design and Implementation

· VMware Infrastructure

· EMC Storage and Legato Networker Administration