Intended audience:

a. Anyone who wants to learn SQL. If you want to learn how to query data for reporting or analytics.
b. Anyone who might know the basics of SQL, but needs a bit more exposure to advanced techniques and concepts.

Prerequisites:

a. Absolutely no programming experience is required to master the content in this course.

What you will gain from this course:

a. Have the ability to solve any SQL problem
b. Master the content required to pass the Oracle Database 12c SQL Fundamentals Exam # 1Z0-061 (This is only available in Japan so you will be taking the 1Z0-071 certification which is a higher level certification anyways)
c. Master the content required to pass the Exam 1Z0-061 — Oracle Database 12c: SQL Fundamentals
d. Become job-ready to start contributing as a database analyst day 1
e. Program in the SQL language to solve a variety of database problems
f. Code along with the instructor to practice and implement everything you learn
g. Become a SQL guru and understand how the Oracle database works
h. Obtain the skills that are necessary to land a job as a SQL database analyst

Topics:

a. SQL Principles using Oracle
b. How to use a SQL client like TOAD and SQLPlus
c. Use SQL to query data in a database
d. Understand keys, unique constraints indexes, foreign keys
e. Use SQL string, numeric, and date functions
f. Using The Dual Table
g. Using Functions in WHERE And Character Based Single Row Functions
h. Numeric and Date Data type
i. Conversion and Date Formatting and Date Functions
j. NULL / NULLIF Functions
k. Comparison Operators (=,<,>,ANY,ALL)
l. SQL Operators (LIKE, IN, BETWEEN, IS NULL)
m. Logical Operators (AND, OR, NOT)
n. Substitution Variables
o. DML: Update, insert, and delete data
p. Write subqueries, joins, unions, and other advanced SQL concepts
q. SELECT within SELECT (Subqueries)
r. Relating Tables Together Using JOINs
s. Joins Continued INNER & OUTER Joins
t. Correlated Subqueries with EXISTS & NOT EXIST operators
u. CASE Statements
v. Grouping Functions MIN, MAX, AVG, COUNT etc.
w. Top-N Queries (And Intro to ANALYTIC Functions)
x. The Row Limiting Clause (New!)
y. GROUP BY Clause & HAVING Clause
z. Creating Views

Course Commencement Dates:

 

September 21st, 22nd, 23rd, 24th & 25th 2020 Monday, Tuesday, Wednesday, Thursday, Friday 9:00 AM to 1:00 PM Pacific Time Register Now Instructor : Alok Bhatia
July 20th, 21st, 22nd, 23rd & 24th 2020 Monday, Tuesday, Wednesday, Thursday, Friday 9:00 AM to 1:00 PM Pacific Time Sold Out Instructor : Alok Bhatia
May 18th, 19th, 20th, 21st & 22nd 2020 Monday, Tuesday, Wednesday, Thursday, Friday 9:00 AM to 1:00 PM Pacific Time Sold Out Instructor : Alok Bhatia


Fee Structure:

Regular price: $295

Class Timings:  9:00 A.M. 1:00 P.M. Pacific Time

Address: 4580 Auto Mall Parkway #121, Fremont, CA, 94538

First class as trial (FREE)

 

Study material Provided

 

Quizzes and mock exams

 

Retake classes for free

 

Placement Help (through other agencies)

 

How long is the training? What are the timings?

Generally Oracle (SQL) training is for 5 days only. Monday to Friday, 9am to 1pm Pacific Time.

Is there a fee for the course?

Yes, $295 fee. You can audit the 1st class but after that you have to pay the fee.

Will I get software from you, installed on my machine?

Oracle provides access to the cloud Oracle database using ApexSQL client. As such, you don’t need software from any training company. All the training companies provide training on this Oracle instance on the cloud. So, yes in a way we do provide you access to the software.

What books will I need to purchase (or what I need to bring to class)?

You don’t need to purchase any books, just bring your laptop. We offer you study material and stationery.

Do you provide any certificate after I complete this training?

Yes, we provide attendance certificate after completion of training.

Will the training be online or in-person?

This training will be conducted in-person as well as online. We recommend take training in-person, unless you are not local. If you are not able to come any day(s) or all days you will benefit as much from online training. Even though it is online, please do keep in mind this is still a live training.

If I want to take the training again after having taken it once, can I?

Yes, you are very welcome to take the training again at no cost.

Do you give placement assistance?

No.

Fill up the following form to get a call back