Oracle SQL Tutorials

REGISTER: Sign me up

free course

Oracle SQL Tutorials

Oracle Database is a program designed to hold lots of information, or data. There are all kinds of different databases and they all have their uses. Some of the most common ones are MySQL, SQL Server, Sybase, and MongoDB. All of these have different uses. The differences will be easier to understand after you learn more about each kind of database. This course will go over all of the major parts of database programming using Oracle SQL. We will be using Oracle 11g, but these videos should still work with other versions, including the most recent 12c.

Saiba mais.

Start now for free!

This course is available to subscribers! Get to know the plans.

This course has a free digital certificate of completion.

workload

4h

premium access

7 days

created on

11/12/2017

Complete course
with certificate!

On completion of this course, you will receive a digital certificate.

Increase your chances of being hired by qualifying your skills with certificates.

Why choose Learncafe?

Here at Learncafe you can access your course whenever you want. Courses are available 24 hours a day, every day of the week.

As well as being an easy-to-use platform, on any device with Internet access, you also receive a Digital Certificate when you complete your course.

Syllabus:

Aula #1 - Oracle SQL Tutorial 1 - Intro to Oracle Database
Aula #2 - Oracle SQL Tutorial 2 - Entities and Attributes
Aula #3 - Oracle SQL Tutorial 3 - Downloading Oracle Database and Installing SQL Developer
Aula #4 - Oracle SQL Tutorial 4 - Beginner Terms - Database Design Primer 1
Aula #5 - Oracle SQL Tutorial 5 - Database Integrity - Database Design Primer 2
Aula #6 - Oracle SQL Tutorial 6 - Relationships and Primary and Foreign Keys - Database Design Primer 3
Aula #7 - Oracle SQL Tutorial 7 - Normalization - Database Design Primer 4
Aula #8 - Oracle SQL Tutorial 8 - Indexes - Database Design Primer 5
Aula #9 - Oracle SQL Tutorial 9 - Intro to Queries
Aula #10 - Oracle SQL Tutorial 10 - Whitespace, Case Sensitivity, and Comments
Aula #11 - Oracle SQL Tutorial 11 - CREATE TABLE
Aula #12 - Oracle SQL Tutorial 12 - Intro to Constraints
Aula #13 - Oracle SQL Tutorial 13 - How to Add Column Constraints (Attributes)
Aula #14 - Oracle SQL Tutorial 14 - Column-Level and Table-Level Constraints
Aula #15 - Oracle SQL Tutorial 15 - How to Add Primary Key Constraints
Aula #16 - Oracle SQL Tutorial 16 - Parent Child Relationships
Aula #17 - Oracle SQL Tutorial 17 - Designing Our Foreign Keys
Aula #18 - Oracle SQL Tutorial 18 - How to Create Foreign Keys
Aula #19 - Oracle SQL Tutorial 19 - ON DELETE (SET NULL and CASCADE)
Aula #20 - Oracle SQL Tutorial 20 - How to Create Composite Primary Keys
Aula #21 - Oracle SQL Tutorial 21 - How to Create / Drop Indexes
Aula #22 - Oracle SQL Tutorial 22 - Why Primary Keys Shouldn't Change
Aula #23 - Oracle SQL Tutorial 23 - Intro to Data Types
Aula #24 - Oracle SQL Tutorial 24 - Important Data Types
Aula #25 - Oracle SQL Tutorial 25 - ASCII and Unicode
Aula #26 - Oracle SQL Tutorial 26 - UTF-8 and UTF-16
Aula #27 - Oracle SQL Tutorial 27 - CHAR Part 1
Aula #28 - Oracle SQL Tutorial 28 - CHAR Part 2
Aula #29 - Oracle SQL Tutorial 29 - NCHAR Part 1
Aula #30 - Oracle SQL Tutorial 30 - UTF-8 and UTF-16 Character Sets
Aula #31 - Oracle SQL Tutorial 31 - NCHAR Part 2
Aula #32 - Oracle SQL Tutorial 32 - VARCHAR2 and NVARCHAR2
Aula #33 - Oracle SQL Tutorial 33 - NUMBER Data Type
+ Show more

Get to know
the personin charge:

Learncafe in English

Learning is never too much. We create this profile so you can access various free courses. From the available material, you can acquire new knowledge on topics such as: education, health, among other areas. All works and materials have the rights reserved to their respective authors.

view profile see courses
0 people signed up for this course.

General evaluation of the course:


Modules & lessons

Module 1: Oracle SQL Tutorials

view all

Choose a plan:

Free Plan Grátis
  • 4 CLASS HOURS
  • 30 free access days*
  • No grace period**
  • Certificate of completion***
  • Immediate access
Inscrever Agora
* O prazo de acesso ao conteúdo do curso é válido durante a vigência da mensalidade ou compra avulsa.
** O prazo de carência refere-se ao tempo total de espera para que um usuário possa iniciar um outro curso na plataforma.
*** O certificado de conclusão do curso é oferecido separadamente para compra avulsa em dois formatos: digital para download e impresso via Correios.

Start studying in just a few clicks:

The knowledge you've been looking for to improve your
career is just a few clicks away!

Sign up now

Sign up for Learncafe

+200.000 study hours
+300.000 videos available
+30.000 fixation exercises
+9.000 available courses
Ei, espera! Que tal você concorrer a 20 mil?