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
For more information about the course and dates, please mail us info@syncitlearning.com or you can reach over the phone at 510-779-9040
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)
Yes, you are very welcome to take the training again at no cost.
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.
Yes, we provide attendance certificate after completion of training.
You don’t need to purchase any books, just bring your laptop. We offer you study material and stationery.
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.
Yes, $295 fee. You can audit the 1st class but after that you have to pay the fee.
Generally Oracle (SQL) training is for 5 days only. Monday to Friday, 9am to 1pm Pacific Time.
