Oracle : SQL Step by Step[Be Ready for work/job in 100 mins]
3.5 (1 rating)
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.
120 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle : SQL Step by Step[Be Ready for work/job in 100 mins] to your Wishlist.

Add to Wishlist

Oracle : SQL Step by Step[Be Ready for work/job in 100 mins]

SQL Basics to Expert with lot of practice sessions
3.5 (1 rating)
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.
120 students enrolled
Created by Testing World
Last updated 8/2016
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Ready to work on oracle database
  • Ready to face database testing interviews
View Curriculum
Requirements
  • Machine with Windows OS
  • Oracle 9i or later version
Description

SQL : Structured Query Language-is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).

Originally based upon relational algebra and tuple relational calculus, SQL consists of a data definition language, data manipulation language, and Data Control Language. The scope of SQL includes data insert, query, update and delete, schema creation and modification, and data access control. Although SQL is often described as, and to a great extent is, a declarative language (4GL), it also includes procedural elements.

Who is the target audience?
  • Freshers looking opportunity in databse
  • Professionals looking to learn database
Students Who Viewed This Course Also Viewed
Curriculum For This Course
22 Lectures
01:30:48
+
Jump into SQL : Basic Select queries
5 Lectures 19:04

Select data conditionally using Where AND / OR
05:04

Select data conditionally using IN and BETWEEN
05:12

Data Sorting
03:55

Fetch unique data from table
02:00
+
Advance Select Queries
4 Lectures 16:03
Select data with wild card character
04:39

Subqueries
02:23


Group Data
05:42
+
Delete data from table
1 Lecture 05:55
+
Select data from multiple table using JOINS
4 Lectures 21:47
Inner Join
06:44

Outer Join
05:36

Self Join
05:33

Cross or Cartesian join
03:54
+
Data Constraints
3 Lectures 10:37
Not Null constraint
04:22

Primary Key
03:12

+
Working with Tables
3 Lectures 10:20
Create Table
05:36

Insert data into table
02:09

Update data in table
02:35
+
Advance SQL Concepts
2 Lectures 07:02
Views
03:11

Index
03:51
About the Instructor
Testing World
4.0 Average rating
1,895 Reviews
16,673 Students
48 Courses
Director of Testing World

Handling Testing World Operations

Involve in Testing Course Video update and management

Handling online and Face to face classes of Testing World

Masters In Computer Science

Expertise in manual testing & Automation testing using Selenium, QTP, LoadRunner, Jmeter and Mobile Automation

Found of Testing World

Trained more than 4000 students online 

Actively involved in corporate training