Learn Oracle 12c SQL : Kickstart kit for beginners

Offered byUDEMY

Learn Oracle 12c SQL : Kickstart kit for beginners
at
UDEMY
Overview

Journey from Beginner to Expert

Duration	4 hours
Total fee	₹499
Mode of learning	Online
Official Website	Go to Website
Credential	Certificate

Learn Oracle 12c SQL : Kickstart kit for beginners
at
UDEMY
Highlights

30-Day Money-Back Guarantee
Certificate of completion
Full lifetime access
Learn from 1 downloadable resource

Learn Oracle 12c SQL : Kickstart kit for beginners
at
UDEMY
Course details

Who should do this course?

Anyone who wants to become DBA, Software tester, developer, Business Analyst

What are the course deliverables?

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

More about this course

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.

Learn Oracle 12c SQL : Kickstart kit for beginners
at
UDEMY
Curriculum

Introduction to SQL

Introduction to Course

Introduction to Database

Prerequisites

Restricting Data

How to work with SQL Operators

Operators- Arithmetic

Operators- Logical

Operators- Comparison

Operators- Set

Concatenation

Functions

Single Row Functions- Character

Single Row Functions- Date & Number

Single Row Functions- Conversion

Single Row Functions- General and Conditional

Multiple Row Functions

Categories of Commands

DDL, DML, DCL

Practical implementation of DDL and DML

Joins

Oracle Joins

SQL Server Joins

Subqueries

Single Row and multiple row subqueries

correlated subqueries

Constraints

Not Null Constraint

Check Constraint

Unique key constraint

Primary key and foreign key constraint

Difference between Unique key & Primary

Drop Constraint

Database Objects

Views

Sequences

Synonyms

Indexes

Interview related Stuff

Interview Questions give away

Learn Oracle 12c SQL : Kickstart kit for beginners
at
UDEMY
Faculty details

Cheena Sharma

Designation : Database admin and Software Test Lead Description : I have been working as DBA from last 15 years and I am Globally Certified in database. I have good expertise in Database. I work as DBA recruiter also. I know industry requirements and will be teaching you accordingly. Will also prepare you Interviews and technical stuff.Also I got opportunity to work as QA Lead , Now I am training Immense number of students on practical implementation of all advanced concepts of Software testing