watching now
3 Students
69 Lessons
Beginner

What Will You Learn?

  • You'll understand Database terminology
  • You'll develop stable skills in Oracle SQL
  • You'll get ready to create solutions for arising SQL problems
  • You will understand SQL code written by other people and feel confident in modifying it

Curriculum

10h 50m
Section 2: DDL Commands
54:10
What are the Data Types in Oracle SQL
07:30
What are the SQL Statements in Oracle SQL
02:10
How to Create a First Table in Oracle Data Base
05:40
How to Modify the Table Structure in Oracle Data Base
07:00
How to Drop and Rename the Table in Oracle Data Base
05:10
How to work with Insert (DML Statements) in Oracle SQL
13:31
How to work with Update (DML Statement) in Oracle SQL
07:00
How to work with Delete (DML Statement) in Oracle SQL
06:09
Section 3: TCL Commands
52:11
How to work with Commit (TCL Commands) in Oracle SQL
23:41
How to work with Rollback (TCL Commands) in Oracle SQL
16:31
How to work with SavePoint (TCL Commands) in Oracle SQL
02:00
How to work with Truncate (TCL Statement) in Oracle SQL
09:59
Section 4: Clauses
45:04
How to work with Select and Where Clause in Oracle SQL
11:40
How to work with Group By Clause in Oracle SQL
10:51
How to work with Having Clause in Oracle SQL
13:01
How to work with Order By Clause in Oracle SQL
06:42
How to work with Distinct Clause in Oracle SQL
02:50
Section 5: Operators
52:13
How to work with Arithmetic Operators in Oracle SQL
15:41
How to work with Logical Operators in Oracle SQL
05:30
How to work with Relational Operators in Oracle SQL
04:30
How to work with Special Operators in Oracle SQL
13:01
How to work with Set Operators in Oracle SQL
13:31
Section 6: Functions
1:51:35
How to work with Number Functions in Oracle SQL
20:19
How to work with String Functions in Oracle SQL
19:43
How to work with Translate Function in Oracle SQL
08:02
How to work with Replace Function in Oracle SQL
01:58
How to work with Decode Function in Oracle SQL
14:11
How to work with Case Function in Oracle SQL
12:51
How to work with Substring Function in Oracle SQL
10:31
How to work with Instring Function in Oracle SQL
05:40
How to work with Date Functions in Oracle SQL
10:05
How to work with Conversion Functions in Oracle SQL
04:15
How to work with General Functions in Oracle SQL
01:40
How to work with Aggregate Functions in Oracle SQL
02:20
Section 7: Constraints
56:42
How to work with Primary Key in Oracle SQL
13:20
How to work with Composite Primary Key in Oracle SQL
12:31
How to work with Unique Key in Oracle SQL
04:35
How to work with Not Null in Oracle SQL
02:35
How to work with Check in Oracle SQL
03:20
How to work with Default in Oracle SQL
06:50
How to work with Foreign Key in Oracle SQL
13:31
Section 8: Joins
58:24
How to work with Simple Join in Oracle SQL
32:52
How to work with Outer Join in Oracle SQL
12:21
How to work with Self Join in Oracle SQL
13:11
Section 9: Synonyms
27:01
What is Synonyms in Oracle SQL
04:20
How to work with Private Synonym in Oracle SQL
15:41
How to work with Public Synonym in Oracle SQL
07:00
Section 10: Views
1:00:41
How to work with Simple View in Oracle SQL
10:50
How to work with Complex View in Oracle SQL
06:40
How to work with Force View in Oracle SQL
05:40
How to work with Vertical View in Oracle SQL
01:20
How to work with Horizontal View in Oracle SQL
01:45
How to work with Functional View in Oracle SQL
03:15
How to work with Partition View in Oracle SQL
02:10
How to work with Materialized View in Oracle SQL
08:46
How to work with Inline View in Oracle SQL
20:15
Section 11: Indexes
16:35
How to work with Simple Index in Oracle SQL
03:30
How to work with Complex Index in Oracle SQL
01:28
How to work with Unique Index in Oracle SQL
07:17
How to work with Functional Index in Oracle SQL
01:43
How to work with Bitmap Index in Oracle SQL
02:37
Section 12: Clusters
04:55
How to work with Clusters in Oracle SQL
04:55
Section 13: Sequences
10:11
How to work with Sequences in Oracle SQL
10:11
Section 14: Sub Queries
52:48
How to work with Sub Queries in Oracle SQL
40:02
How to work with Sub Queries with Examples
12:46

Description

Requirements

  • Beginners knowledge of SQL
  • Willingness to work hard for success

About the Instructor

Reviews 0
Students 3
Courses 1

KUNCHAM Software Solutions Pvt Ltd is an Indian based company who offer a huge and ever-growing range of high-quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video-based education.

We are globally renowned Corporate Training and Software Development Company which provides a broad spectrum of IT services to fortune 100 companies. enhancing value to its clients in all spheres

We are a life skills training organization offering solutions to training needs of various organizations across all functions. Our team of experienced and energetic trainers would walk you through various modules such as Communication Skills, Change Management, Leadership, Team Building, Flexibility, Motivation and many more to enable you to unleash your potential and work towards enhanced performance.

All our training programs carry the distinct flavor of experiential training and looking beyond the classroom. We focus on interactive corporate training and learning experiences and facilitate change within an organization and individual context.

Effective training leaves each individual with a strong desire to apply the learning in professional or personal life. Learning happens easily and effectively when trainees are motivated, engaged and are energetic. The training that we offer is lively, interactive, filled with fun and thought-provoking; we make learning inspirational and memorable!

What’s more, this unique focus on Quality has enabled us to complete training for professionals. No small feat, indeed! Our working as Partners and not as Vendors too has leveraged client-service provider association.

As People Committed to Quality, our constant endeavor is to provide value additions to our client at every level. Consequently, we offer a wide range of corporate training courses on various technologies which include:

Microsoft Technologies: MS.Net 4.0/4.5 C#, WPF, F#, HTML 5, SharePoint 2010, SilverLight, MS Project 2010 etc...

Oracle Corporation Technologies: Java, J2EE, J2ME, Oracle ADF, Oracle BPEL etc...

Server Based: SCOM, SCCM, Windows 10, Active Directory Server, IIS, Exchange Server 2010, WebSphere Server, WebLogic Server, WebLogic Portal etc...

SAP: BI, BW, ABAP, BO, BASIS, FICO, HR, MM, PP, SD, SRM, CRM Security, Treasury Management etc...

Database Business Intelligence (BI), DataWarehouse: SQL Server 2012 Admin, SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services), Oracle 11g (SQL, PL/SQL, DBA), Oracle RAC Admin, Forms, Reports, Cognos, Informatica, DataStage, Business Object, OBIEE, Teradata etc...

BitDegree platform reviews

Our students say Excellent
4.5 out of 5
trustpilot logo 1 trustpilot logo