Oracle SQL Developer Training

Oracle SQL Developer aracını öğrenebileceğiniz kurs.Professional e-Learning : www.dijibil.com
4.2 (117 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.
9,838 students enrolled
Instructed by Cihan O Office Productivity / Oracle
Free
Start Learning Now
  • Lectures 32
  • Contents Video: 1.5 hours
  • Skill Level Intermediate Level
  • Languages Turkish
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2011 Turkish

Course Description

Bu kurs ile Oracle firmasının geliştirdiği Oracle SQL Developer aracını indirme ve kurulumdan başlamak üzere genel hatlarıyla öğrenebileceksiniz. Kurs içeriğinde SQL Developer ile PL/SQL yönetimi ve hazır PL/SQL nesne oluşturma araçlarını kullanmayı öğrenerek Oracle ile daha etkin çalışmaya başlayacaksınız.

Professional e-Learning : www.dijibil.com

What are the requirements?

  • Temel Oracle ve yazılım bilgisi.

What am I going to get from this course?

  • Oracle SQL Developer istemci aracını detaylarıyla öğreneceksiniz.

What is the target audience?

  • Oracle'ı merak eden ve geliştirici olmak isteyenler.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Oracle SQL Developer Download and Installing
08:18
Create Connection
04:29
Section 2: Working with Database Objects
Create Table with SQL
02:16
Creating Tables Using Table Dialog
05:41
02:29


Adding a new column to the table
00:56
Deleting a Table
01:17
Section 3: Data Access
Receive Columns
03:13
Getting rows
03:23
Oracle SQL Query Builder
01:52
JOIN 's Understanding
01:25
ON CLAUSE with the JOIN Operation
03:29
WHERE CLAUSE with the JOIN Operation
00:54
Writing a Query That Joins Multiple Tables
02:33
Character Functions
02:40
Numeric Functions
02:21
Date Functions
03:44
Date Formatting
01:18
NVL Function
02:31
Use of Group Functions
02:00
Grouped Data Reports
02:20
Use the HAVING clause
02:04
Section 4: Data Processing
Add Single Line Data
01:10
Adding Multi-Line Data
00:47
Update Data
02:06
Delete Data
01:02
Excel to Export
01:20
Export to DDL
01:54
Section 5: Adding Components PLSQL
Create DML Trigger
01:45
Manage Trigger
02:34
Create Stored Procedure
07:35
Use of Function
02:29

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Cihan O, Software and Database Trainer

Yazılım, veritabanı ve veri güvenliği üzerine araştırmalar yapıyorum. SQL Server ve Oracle üzerine eğitim setleri hazırlayıp profesyonel gerçek ortam eğitimleri veriyorum.

Şu ana kadar yüzlerce eğitim ve video eğitim hazırladım. Bunların bir kısmı prensibim gereği ücretsiz olarak yayınlanmaktadır.

Ready to start learning?
Start Learning Now