Oracle SQL for Beginners - The fundamentals
4.5 (60 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,298 students enrolled

Oracle SQL for Beginners - The fundamentals

Easy learn Oracle Sql using Livesql. SQL statements explained word by word. Example files included for each lesson.
4.6 (60 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,298 students enrolled
Created by Sultana Iulian
Last updated 6/2018
English
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5.5 hours on-demand video
  • 116 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Learn Oracle SQL using Livesql, no software installation required.
  • 84 lectures (5.5 hours of content) teaching you the fundamentals of SQL Statements.
  • Every SQL statement explained word by word.
  • Each lesson contain sample files attached.
Course content
Expand all 84 lectures 05:17:18
+ Retrieve data, compare data
10 lectures 39:57
Retrieve data
05:33
Basic comparison operators
04:06
Comparing 2 columns same table
02:39
Comparison operator BETWEEN
03:33
Comparison operator IN NOT IN
03:05
Comparison operator LIKE
06:09
Logical operators AND OR NOT
05:12
Aritmetic operators
03:40
Summary
02:25
+ Table structure definition
12 lectures 47:25
Alter table
06:23
Primary key
04:25
Foreign key
05:46
Check constraint
02:49
Disable constraints
03:08
Naming convention
01:43
Create table as
03:25
Drop table
01:28
Summary
02:54
+ Table data manipulation, sorting, set operators
7 lectures 22:20
Insert data
01:51
Update data
02:26
Delete data
01:48
Sorting data
04:57
Set operators
05:39
Summary
02:35
+ Joins
9 lectures 34:58
Inner join
04:54
Left, right join
05:22
Natural join
02:49
Cross join
02:46
Multiple join tables
02:39
Old syntax joins
02:14
Summary
04:23
+ Functions
15 lectures 57:24
Data types
06:27
Functions
01:51
Numeric functions
07:53
Character functions returning character
05:59
Character functions returning number
03:09
Datetime functions
06:09
General comparison functions
01:18
Conversion functions
05:48
Encoding and decoding functions
02:43
NULL related functions
02:54
Enviroment functions
01:29
Agregate functions
03:43
Analitic functions
01:47
Summary
03:42
+ Grouping
3 lectures 08:58
GROUP BY Clause
04:33
HAVING Clause
03:30
Summary
00:55
+ Database objects
8 lectures 29:12
View
03:27
Sequence
05:03
Synonim
03:13
Index
03:04
Other database objects
01:39
Sample schema in livesql
02:42
Summary
01:56
+ Roles and privilleges
3 lectures 06:06
Roles/ Privilegies
02:27
GRANT, REVOKE
02:44
Summary
00:55
+ Complex queries
4 lectures 14:08
CASE
03:50
Subqueries
05:09
EXISTS
02:54
Summary
02:15
Requirements
  • No previous experience is required. No software installation
  • All resources needed for this course available online
Description


Learn the basic concepts that you will need to write SQL statements.   

What is SQL?  

SQL (Structured Query Language) is the primary language responsible for managing data and data structures contained within a relational database management system (RDBMS). Put simply, SQL is the language you use to interact with a database.  

Build a strong foundation in SQL with this tutorial for beginners.  

  • Database      basic concepts

  • Retrieving,      filter data

  • Creating      tables, modify tables

  • Manipulate      data, sort data

  • Join      tables

  • SQL      functions

  • Grouping      result set.

  • Database      objects

  • Understanding      users/ roles/privileges

  • Complex      queries 

  • Understanding      the concept of transactional database

  • SQL      types classification

  • Next      steps

Why should you learn SQL?  

  • Because you can earn really good money :  SQL Developers have good incomes.

  • Because SQL is one of the most sought-after skills by hiring      employers : Employers are seeking individuals who know SQL

  • Because you can get an answer to any question you ask about your data stores in a database :Think      of all the questions you ask about your data on a regular basis. What were      our sales last year? What is the average income for our employees? How many goods entered the company this month? Those are all questions that can be answered using      SQL.

  • Because you no longer have to deal with Excel crashing : Ever      crashed Excel because you had a ton of rows in a spreadsheet? Relational      databases are designed to store millions and millions of rows of data. And you will need SQL for communicating with the database.

Content and Overview 

Suitable for beginners, through this course of 84 lectures and 5.5 hours of content, you’ll learn all of the SQL fundamentals and establish a strong understanding of the concepts behind databases. Each lessons have attached files with examples, you can put your new skills into practical use immediately.  

No need for a software installation for starting with the examples. No need for a database installation. You just create an free account on Livesql and you are ready to start, all the steps are described in the course  

The Next Steps lesson with show you what are the next steps if you want to take the experience accumulated in this course to the next level.  

Who this course is for:
  • Anyone who want to learn SQL