Oracle 12c OCP 1Z0-061: SQL Fundamentals
4.3 (28 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.
152 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle 12c OCP 1Z0-061: SQL Fundamentals to your Wishlist.

Add to Wishlist

Oracle 12c OCP 1Z0-061: SQL Fundamentals

SQL Fundamentals:Oracle 12c OCP 1Z0-061
Bestselling
4.3 (28 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.
152 students enrolled
Last updated 4/2017
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 13.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Ability to manage an oracle database that is re-engineered for Cloud computing.
  • Student will have a good review on all SQL Fundamentals.
  • Student will fully understand the 5 subsets of Oracle.
View Curriculum
Requirements
  • There are no prerequisites.
  • The student will need high speed internet to view the courses, no software is needed.
  • Student can review the course as many times as needed
Description
Keeping your exams current is important to any IT professional. With Oracle Database 12c: SQL Fundamentals, you experience the benefits of an Oracle Database that is re-engineered for Cloud computing. Multi-tenant architecture brings enterprises unprecedented hardware and software inefficiencies performance and manageability benefits, and fast and efficient Cloud provisioning. Oracle Database 12c: SQL Fundamentals certifications emphasize the full set of skills that DBAs need in today's competitive marketplace.
 Retrieving Data;SQL Functions;Data Manipulation Language;
Combining Queries will be covered.concepts such as tablespaces, data files, and redo logs. The course also covers installation and configuration of the database itself, reviewing the Oracle CLI and GUI administration and development tools and typical administration tasks, including backup. You can be starting your IT career or taking your current IT skills to the next level in just a few short weeks. Oracle databases are the one of the most popular database platforms in the world. Increase your skills and marketability today by achieving Oracle certification!
Who is the target audience?
  • This is Science & Technology Professionals
  • The course is for students who want to prepare for the Oracle 12c certification exam.
  • The course is for student are interested in Oracle 12c SQL Fundamentals
Students Who Viewed This Course Also Viewed
Curriculum For This Course
59 Lectures
13:33:14
+
Module 1: Introduction To Oracle 12c SQL Fundamentals
9 Lectures 01:56:31

Intro To Oracle 12c SQL Fundamentals Part1
15:20

Intro To Oracle 12c SQL Fundamentals Part2
12:25

Structure Of SQL Part1
07:07

Structure Of SQL Part2
16:58

Basic Select Statements Part1
15:00

Basic Select Statements - Part 2
19:11

Basic Select Statements Demo Part1
11:25

Basic Select Statements Demo Part2
18:01
+
Module 2: Retrieving Data
10 Lectures 02:22:40
Modifying Reported Output Part1
12:44

Modifying Reported Output Part2
17:45

The Where Clause Part1
16:50

The Where Clause Part2
20:58

The Order By Clause Part1
18:54

The Order By Clause Part2
07:12

8. The Order By Clause - Part 3.mp4
13:53

Left And Right Outer Joins
12:55

The Where Clause Demo
06:53

MultiTable Selection Demo
14:36
+
Module 4: Subqueries
9 Lectures 01:26:55
Single Row Subqueries Part1
06:38

Single Row Subqueries Part2
15:23

SingleRow Subqueries Demo
11:51

MultiRow Subqueries Part1
13:29

MultiRow Subqueries Part2
09:02

MultiRow Subqueries Demo
04:23

Other Subquery Types Part1
03:40

Other Subquery Types Part2
16:43

Other Subquery Types Demo
05:46
+
Module 5: Data Manipulation Language
7 Lectures 01:41:46
Adding Data Part1
15:35

Adding Data Part2
13:38

Changing Data Part1
16:30

Changing Data Part2
06:14

Deleting Data
11:28

DML Demo Part1
19:08

DML Demo Part2
19:13
+
Module 6: Data Control Language
6 Lectures 01:29:48
Security Part1
19:44

Security Part2
16:21

Object Privileges Part1
09:53

Object Privileges Part2
18:47

DCL Demo Part1
13:59

DCL Demo Part2
11:04
+
Module 7: Data Definition Language
8 Lectures 02:07:19
Creating Objects In The Database Part1
17:02

Creating Objects In The Database Part2
17:47

Creating Objects In The Database Part3
13:49

Creating Objects In The Database Demo
19:00


Sequenced Demo
15:22

Indexes
14:40

Views
15:07
+
Module 8: Combining Queries
1 Lecture 11:47
Combining Queries
11:47
+
Module 9: Oracle 12C SQL Fundamentals Review
9 Lectures 02:16:28
Oracle 12c SQL Fundamentals Review-Part 1A
19:59

Oracle 12c SQL Fundamentals Review-Part 1B
19:38

Oracle 12c SQL Fundamentals Review-Part 2A
19:23

Oracle 12c SQL Fundamentals Review-Part 2B
15:21

Oracle 12c SQL Fundamentals Review-Part 2C
17:33


Oracle 12c SQL Fundamentals Review-Part 3B
15:10

Oracle 12c SQL Fundamentals Review-Part 3C
10:47

Conclusion
00:51
About the Instructor
iCollege Certifications
4.1 Average rating
1,664 Reviews
11,233 Students
100 Courses
Certification Leader

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

Utilizing state of the art technologies, highly experienced consultants and innovative methodologies, we provide, cutting-edge education products, services and solutions for individuals, corporate organizations, governmental institutions and education providers.

Our collective knowledge and experience in education and training sets the standard for service delivery in learning solutions.