Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Oracle SQL for Beginners - The fundamentals

Name: Oracle SQL for Beginners - The fundamentals
Rating: 4.3 (117 reviews)

Easy learn Oracle Sql using Livesql. SQL statements explained word by word. Example files included for each lesson.

Created bySultana Iulian

Last updated 6/2018

English

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

12 sections • 84 lectures • 5h 17m total length

What is data?2:13
What is a database?2:38
What is DBMS ?2:31
What is SQL ?3:51
What is a table7:22
LiveSQL6:20
Practice with LiveSQL for Oracle SQL, compare online environments accessible from anywhere with internet to local databases, create tables with scripts, and learn about persistence when logging off.
Data types12:16
Summary1:34

Retrieve data5:33
Basic comparison operators4:06
Comparing 2 columns same table2:39
Comparison operator BETWEEN3:33
Comparison operator IN NOT IN3:05
Comparison operator LIKE6:09
NULL , IS NULL and IS NOT NULL3:35
Identify null values and apply is null or is not null to filter records in Oracle SQL, using a books table with a name column as examples.
Logical operators AND OR NOT5:12
Aritmetic operators3:40
Summary2:25

Create table4:15
Alter table6:23
Constraints5:23
Explore Oracle SQL constraints, including primary key, unique (single and composite), foreign key, and check constraints, and learn how these enforce data integrity and referential integrity.
Unique constraint5:46
Primary key4:25
Foreign key5:46
Check constraint2:49
Disable constraints3:08
Naming convention1:43
Create table as3:25
Create a new table as select to copy all columns and rows from a source table, or copy only selected columns, or create an empty structure with a never-fulfilled condition.
Drop table1:28
Summary2:54

Insert data1:51
Update data2:26
Learn to update existing records in Oracle sql by setting column values and using where clauses, including date and price updates and the effect of omitting where.
Delete data1:48
Sorting data4:57
Set operators5:39
DISTINCT clause3:04
The distinct clause removes duplicates from a select result set. Apply it to one column or multiple columns to enforce unique values or unique combinations, using a where condition.
Summary2:35

Joins6:44
Inner join4:54
Left, right join5:22
Explore left join and right join concepts in Oracle SQL by linking two tables with on conditions, matching records, and understanding when matches exist or are absent.
Full outer join3:07
Natural join2:49
Cross join2:46
Multiple join tables2:39
Old syntax joins2:14
Explore old syntax joins in Oracle SQL, including left and right joins, and see how matched and unmatched rows appear in simple select examples.
Summary4:23

Data types6:27
Dual2:32
Learn to use the Oracle dual table to retrieve a single value and to compute expressions, such as 1 plus 10 plus 100, from dual.
Functions1:51
Numeric functions7:53
Explore Oracle sql numeric functions, including how to use remainder and division to compute values, round numbers, and format salaries with simple examples.
Character functions returning character5:59
Character functions returning number3:09
Datetime functions6:09
Explore Oracle SQL datetime functions to extract day, month, and year, format dates, compute intervals such as months_between, and truncate or round time components.
General comparison functions1:18
Conversion functions5:48
Encoding and decoding functions2:43
Explore encoding and decoding functions in Oracle SQL and learn the decode and size functions. Review the syntax with examples showing bytes per letter.
NULL related functions2:54
Enviroment functions1:29
Agregate functions3:43
Analitic functions1:47
Summary3:42

Overview8:08
View3:27
Sequence5:03
Learn to use sequences in Oracle SQL to generate primary key values and automate key creation by setting start, minimum, maximum, and increment options.
Synonim3:13
Index3:04
Other database objects1:39
Sample schema in livesql2:42
Explore a sample schema in live sql to understand tables, columns, and sequences, and learn basic object models and select operations for Oracle SQL beginners.
Summary1:56
Learn basic Oracle SQL concepts including joining two tables, using the sequence, and applying simple policies for employees with the same name.

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

Oracle SQL for Beginners - The fundamentals

What you'll learn

Explore related topics

Course content

Database basic concepts8 lectures • 39min

Retrieve data, compare data10 lectures • 40min

Table structure definition12 lectures • 47min

Table data manipulation, sorting, set operators7 lectures • 22min

Joins9 lectures • 35min

Functions15 lectures • 57min

Grouping3 lectures • 9min

Database objects8 lectures • 29min

Roles and privilleges3 lectures • 6min

Complex queries4 lectures • 14min

Requirements

Description

Who this course is for: