Learn Oracle 12c SQL : Kickstart kit for beginners

Learn Oracle 12c SQL : Kickstart kit for beginners, available at $19.99, has an average rating of 4.64, with 31 lectures, based on 1120 reviews, and has 4065 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone who wants to become DBA,Software tester, developer, Business Analyst or No prior IT skills are required. or Anyone who wants to switch into IT department or You will be able to clear Global certification exam It is particularly useful for Anyone who wants to become DBA,Software tester, developer, Business Analyst or No prior IT skills are required. or Anyone who wants to switch into IT department or You will be able to clear Global certification exam.

Enroll now: Learn Oracle 12c SQL : Kickstart kit for beginners

Summary

Title: Learn Oracle 12c SQL : Kickstart kit for beginners

Price: $19.99

Average Rating: 4.64

Number of Lectures: 31

Number of Published Lectures: 31

Number of Curriculum Items: 31

Number of Published Curriculum Objects: 31

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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

Course Curriculum

Chapter 1: Introduction to SQL

Lecture 1: Introduction to Course

Lecture 2: Introduction to Database

Lecture 3: Prerequisites

Lecture 4: Restricting Data

Chapter 2: How to work with SQL Operators

Lecture 1: Operators- Arithmetic

Lecture 2: Operators- Logical

Lecture 3: Operators- Comparison

Lecture 4: Operators- Set

Lecture 5: Concatenation

Chapter 3: Functions

Lecture 1: Single Row Functions- Character

Lecture 2: Single Row Functions- Date & Number

Lecture 3: Single Row Functions- Conversion

Lecture 4: Single Row Functions- General and Conditional

Lecture 5: Multiple Row Functions

Chapter 4: Categories of Commands

Lecture 1: DDL, DML, DCL

Lecture 2: Practical implementation of DDL and DML

Chapter 5: Joins

Lecture 1: Oracle Joins

Lecture 2: SQL Server Joins

Chapter 6: Subqueries

Lecture 1: Single Row and multiple row subqueries

Lecture 2: correlated subqueries

Chapter 7: Constraints

Lecture 1: Not Null Constraint

Lecture 2: Check Constraint

Lecture 3: Unique key constraint

Lecture 4: Primary key and foreign key constraint

Lecture 5: Difference between Unique key & Primary

Lecture 6: Drop Constraint

Chapter 8: Database Objects

Lecture 1: Views

Lecture 2: Sequences

Lecture 3: Synonyms

Lecture 4: Indexes

Chapter 9: Interview related Stuff

Lecture 1: Interview Questions give away

Instructors

Cheena Sharma
Database admin and Software Test Lead

Rating Distribution

1 stars: 8 votes
2 stars: 19 votes
3 stars: 123 votes
4 stars: 459 votes
5 stars: 511 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu