Learn Oracle 12c SQL : Kickstart kit for beginners
4.8 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
17 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn Oracle 12c SQL : Kickstart kit for beginners to your Wishlist.

Add to Wishlist

Learn Oracle 12c SQL : Kickstart kit for beginners

Journey from Beginner to Expert
4.8 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
17 students enrolled
Created by Cheena S
Last updated 6/2017
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Complete SQL from beginner to expert level .
  • Be able to interact with database and manipulate its data with various utilities
  • Prepare for Global certification exam
  • Understand all interview related question
View Curriculum
Requirements
  • No prior Experience or knowledge is required, only need your dedication.
Description

With the blend of my experience and Knowledge of more than 15 years, I have specially designed this course which will help you to not only clear global certification exam but also  to clear any SQL  interviews. This course has covered all basic to advance level topics. I totally understand that you can be non IT person that's why this course is meant  to address all sort of levels. I being technical recruited strongly recommend this course in which I am also handing out free interview Questions with answers. I have covered all basic to advance topics in this course, keeping the explanation as layman and simple as possible. 

Who is the target audience?
  • Anyone who wants to become DBA,Software tester, developer, Business Analyst
  • No prior IT skills are required.
  • Anyone who wants to switch into IT department
  • You will be able to clear Global certification exam
Students Who Viewed This Course Also Viewed
Curriculum For This Course
31 Lectures
03:47:35
+
Introduction to SQL
4 Lectures 21:50

Introduction to Database
08:54

Prerequisites
03:46

+
How to work with SQL Operators
5 Lectures 23:18

Operators- Logical
03:46

Operators- Comparison
04:58

Operators- Set
06:40

Concatenation
02:46
+
Functions
5 Lectures 48:45
Single Row Functions- Character
15:11

Single Row Functions- Date & Number
08:30

Single Row Functions- Conversion
07:03

Single Row Functions- General and Conditional
08:28

Multiple Row Functions
09:33
+
Categories of Commands
2 Lectures 20:44
DDL, DML, DCL
06:49

Practical implementation of DDL and DML
13:55
+
Joins
2 Lectures 21:52
Oracle Joins
14:03

SQL Server Joins
07:49
+
Subqueries
2 Lectures 14:44
Single Row and multiple row subqueries
10:41

correlated subqueries
04:03
+
Constraints
6 Lectures 35:00
Not Null Constraint
08:12

Check Constraint
07:04

Unique key constraint
06:09

Primary key and foreign key constraint
06:55

Difference between Unique key & Primary
01:34

Drop Constraint
05:06
+
Database Objects
4 Lectures 31:30
Views
10:26

Sequences
06:23

Synonyms
03:48

Indexes
10:53
+
Interview related Stuff
1 Lecture 09:52
About the Instructor
Cheena S
4.8 Average rating
6 Reviews
17 Students
1 Course
DATABASE ADMINISTRATOR

I have been working as DBA from last 15 years and I am Globally Certified in database.I have good expertise in Database. I also work as DBA recruiter also. I know industry requirements and will be teaching you accordingly. Will also prepare you Interviews and technical stuff.