Oracle SQL Starting Point

Learn how to use Oracle SQL
Rating: 3.9 out of 5 (81 ratings)
7,422 students
Oracle SQL Starting Point
Rating: 3.9 out of 5 (81 ratings)
7,423 students
Learn how to install Oracle, SQL Developer and gain a sound understanding of SQL, SQL PLus and SQL Developer

Requirements

  • Basic PC knowledge
Description

·Oracle SQL. 

You will learn how to use the industry  standard tool for working with a Relational Database.  You will also learn many other things, from  constructing simple queries to creating your own  tables.

·Oracle SQL*Plus. 

After the course you should have a  good understanding of SQL*Plus, from starting it, to  creating simple reports on it.

·Oracle SQL Developer.

We will go over the SQL Developer components and see how it hangs together

Who this course is for:
  • Beginner Oracle SQL
Course content
8 sections • 35 lectures • 4h 10m total length
  • Course Overview
    01:32
  • Section 1 Introduction
    00:24
  • Relational Database Constructs
    07:07
  • Relational Database Properties
    05:35
  • Section 2 Introduction
    01:29
  • Introduction to SQL part 1 of 5
    03:43
  • Introduction to SQL part 2 of 5
    12:55
  • Introduction to SQL part 3 of 5
    14:32
  • Introduction to SQL part 4 of 5
    07:45
  • Introduction to SQL part 5 of 5
    10:26
  • End of section 2 lab exercises
    02:10
  • Section 3 Introduction
    01:45
  • Row and Group Functions part 1 of 4
    11:26
  • Row and Group Functions part 2 of 4
    12:19
  • Row and Group Functions part 3 of 4
    10:39
  • Row and Group Functions part 4 of 4
    11:19
  • End of Section 3 Lab exercises
    02:28
  • Section 4 Introduction
    01:45
  • Querying More Than One Table part 1 of 3
    13:19
  • Querying More Than One Table part 2 of 3
    12:49
  • Querying More Than One Table 3 of 3
    05:14
  • End of Section 4 lab exercises
    01:19
  • Section 5 Introduction
    00:32
  • Modifying Data and the Database part 1 of 3
    11:11
  • Modifying Data and the Database part 2of 3
    13:44
  • Modifying Data and the Database part 3 of 3
    12:31
  • End of Section 5 Lab execrises
    01:46
  • Section 6 Introduction
    00:49
  • More SQL PLUS
    11:40
  • SQL Developer Overview part 1 of 3
    10:30
  • SQL Developer Overview part 2 of 3
    10:36
  • SQL Developer Overview part 3 of 3
    13:28
  • End of Section 6 execrises
    01:07
  • Install oracle software and create a test database
    07:14
  • Install SQL Developer
    03:33

Instructor
Instructor at Udemy
Kal Younes
  • 3.8 Instructor Rating
  • 137 Reviews
  • 10,249 Students
  • 2 Courses

Hello

I am Kal Younes, I have been working in the IT industry for over twenty five years. I have started as a developer using earlier programing languages such as Pascal, COBOL and RPG. I have worked form many international companies across the world, from banking to finance houses, from software to service, from oil to refining. I have gain considerable experience. The applications I have developed to co-developed where used across the world to provide better service to customer and make their lives easier. Following through my career I move to Unix system administration working for a large world wide well known mobile phone and communication systems manufacturer. This was the beginning of mobile phone era and we have installed many mobile phone systems around the world. While I was a Unix administrator I had access to Oracle database and had the opportunities to learn while I am working. I had to support the Oracle databases and got certified professorial Oracle certifications from Oracle 8i, Oracle 9i, oracle 10g and Oracle 11g. Using Oracle database I became and Oracle database administrator supporting thousands or database for some of the larges banks in world. While I was working with the banking industry, I had the opportunities to gain other RDBMS technologies such as SQL Server and MySQL and Sybase. Also learned other scripting and programming languages such as Java, SQL, PSQL, Perl and more. I hope this qualify me to provide a service to help others become more productive in their lives and have a better future.