Oracle SQL for Beginners The fundamentals

Oracle SQL for Beginners – The fundamentals, available at $34.99, has an average rating of 4.5, with 84 lectures, based on 101 reviews, and has 1416 subscribers.

You will learn about 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. This course is ideal for individuals who are Anyone who want to learn SQL It is particularly useful for Anyone who want to learn SQL.

Enroll now: Oracle SQL for Beginners – The fundamentals

Summary

Title: Oracle SQL for Beginners – The fundamentals

Price: $34.99

Average Rating: 4.5

Number of Lectures: 84

Number of Published Lectures: 84

Number of Curriculum Items: 84

Number of Published Curriculum Objects: 84

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will 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.

Who Should Attend

Anyone who want to learn SQL

Target Audiences

Anyone who want to learn SQL

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.

 

Course Curriculum

Chapter 1: Database basic concepts

Lecture 1: What is data?

Lecture 2: What is a database?

Lecture 3: What is DBMS ?

Lecture 4: What is SQL ?

Lecture 5: What is a table

Lecture 6: LiveSQL

Lecture 7: Data types

Lecture 8: Summary

Chapter 2: Retrieve data, compare data

Lecture 1: Retrieve data

Lecture 2: Basic comparison operators

Lecture 3: Comparing 2 columns same table

Lecture 4: Comparison operator BETWEEN

Lecture 5: Comparison operator IN NOT IN

Lecture 6: Comparison operator LIKE

Lecture 7: NULL , IS NULL and IS NOT NULL

Lecture 8: Logical operators AND OR NOT

Lecture 9: Aritmetic operators

Lecture 10: Summary

Chapter 3: Table structure definition

Lecture 1: Create table

Lecture 2: Alter table

Lecture 3: Constraints

Lecture 4: Unique constraint

Lecture 5: Primary key

Lecture 6: Foreign key

Lecture 7: Check constraint

Lecture 8: Disable constraints

Lecture 9: Naming convention

Lecture 10: Create table as

Lecture 11: Drop table

Lecture 12: Summary

Chapter 4: Table data manipulation, sorting, set operators

Lecture 1: Insert data

Lecture 2: Update data

Lecture 3: Delete data

Lecture 4: Sorting data

Lecture 5: Set operators

Lecture 6: DISTINCT clause

Lecture 7: Summary

Chapter 5: Joins

Lecture 1: Joins

Lecture 2: Inner join

Lecture 3: Left, right join

Lecture 4: Full outer join

Lecture 5: Natural join

Lecture 6: Cross join

Lecture 7: Multiple join tables

Lecture 8: Old syntax joins

Lecture 9: Summary

Chapter 6: Functions

Lecture 1: Data types

Lecture 2: Dual

Lecture 3: Functions

Lecture 4: Numeric functions

Lecture 5: Character functions returning character

Lecture 6: Character functions returning number

Lecture 7: Datetime functions

Lecture 8: General comparison functions

Lecture 9: Conversion functions

Lecture 10: Encoding and decoding functions

Lecture 11: NULL related functions

Lecture 12: Enviroment functions

Lecture 13: Agregate functions

Lecture 14: Analitic functions

Lecture 15: Summary

Chapter 7: Grouping

Lecture 1: GROUP BY Clause

Lecture 2: HAVING Clause

Lecture 3: Summary

Chapter 8: Database objects

Lecture 1: Overview

Lecture 2: View

Lecture 3: Sequence

Lecture 4: Synonim

Lecture 5: Index

Lecture 6: Other database objects

Lecture 7: Sample schema in livesql

Lecture 8: Summary

Chapter 9: Roles and privilleges

Lecture 1: Roles/ Privilegies

Lecture 2: GRANT, REVOKE

Lecture 3: Summary

Chapter 10: Complex queries

Lecture 1: CASE

Lecture 2: Subqueries

Lecture 3: EXISTS

Lecture 4: Summary

Chapter 11: Transactional database, Types of SQL statements

Lecture 1: Transactional database

Lecture 2: Types of SQL statements

Lecture 3: Summary

Chapter 12: Next steps

Lecture 1: Next steps

Lecture 2: Install an Oracle database locally

Instructors

Sultana Iulian
Oracle developer

Rating Distribution

1 stars: 0 votes

2 stars: 2 votes

3 stars: 18 votes

4 stars: 33 votes

5 stars: 48 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!