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