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 Certified Associate 1Z0-071
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:

July 20th, 21st, 22nd, 23rd & 24th 2020 Monday, Tuesday, Wednesday, Thursday, Friday 9:00 AM to 1:00 PM Pacific Time Register Now Instructor : Alok Bhatia
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
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)

 

Fill up the following form to get a call back