🚨 Get Your Free NFT Certificate Mint by Completing the Web3 Exam! START NOW
watching now
1 Students

Description

What Will You Learn?

  • SQL basics and principles
  • Understanding databases and relational databases
  • How to perform various actions on data: restricting, filtering, grouping, converting, etc.
  • How to use SQL functions

Requirements

  • No prior knowledge necessary
  • NFT Certificate
  • 79 Lessons
  • Beginner
  • English
  • 5.0 Rating
  • +100 XP

Share Course on Social media

Curriculum

Course consist of total 6h 28min of content, in total.

Section 1: Course Introduction
02:04
Section 2: Database Concepts
42:31
Why Oracle Database?
07:00
What is a Table?
03:40
What is a Relational Database?
08:01
Entity Relationship Logic in Databases
03:46
What is SQL?
05:03
The Sample Schema Used in This Course
07:23
Section 3: Preparation for SQL Development
41:13
About the Installation
03:02
Which Way to Have a Database?
09:19
Option 1 : Having The Database with Oracle VirtualBox Software
16:29
How to Install VirtualBox on Mac OSX?
Option 2 : Downloading And Installing Oracle Database
08:58
How to Unlock HR Schema in Oracle?
Section 4: Entering the Database!
32:33
Basic SQL Statements
02:05
How to Get Data - (SELECT Statement)
05:32
Let's Describe Tables
01:19
SQL Coding Tips
03:11
Aliasing The Columns
04:40
Getting Different Rows - DISTINCT Keyword
04:41
Concatenating The Returning Rows
03:43
Arithmetic Expressions
03:20
What is the NULL Value? Is it Dangerous?
04:02
Section 5: Conditional Retrieval
32:21
Getting Data Just We Want - WHERE Clause
04:15
Comparison Operators
03:13
BETWEEN AND Operator
02:20
IN Operator
04:49
Get Me Something LIKE this
07:29
What If Looking For Something NULL
03:33
Logical Operators - AND, OR, NOT Operators
06:42
Section 6: Converting Data & Conversion Functions
36:47
What is a Function?
02:16
Why To Convert Data?
04:54
Conversion Functions
02:34
Converting to a Character - TO_CHAR Function
14:26
Converting to a Date - TO_DATE Function
06:51
NULL Value Conversion - NVL Function
05:46
Section 7: Ordering the Results
11:54
ORDER BY Clause
06:17
ASC and DESC Operators
05:37
Section 8: Single Row Functions
34:38
About Single Row Functions
01:47
Character Functions
11:25
Number Functions
04:53
Nesting Functions
03:38
Date Functions
06:57
DECODE Function
05:58
Section 9: Group Functions
15:07
What are the Group Functions?
01:42
MAX Function
02:04
MIN Function
03:23
Count Function
04:18
AVG Function
01:55
SUM Function
01:45
Section 10: Grouping the Data
15:11
GROUP BY Clause
12:19
HAVING Clause
02:52
Section 11: Selecting From Multiple Tables (Joins)
48:32
What is JOIN?
02:44
Types of Joins
01:00
Let's Join Tables! (Natural Joins)
06:41
Join with USING Clause
07:10
Join with ON Clause
03:25
Join the table with itself! (Self Join)
04:03
Joining Multiple Tables
05:05
What Are Outer Joins?
06:15
What are the left joins? (Left Outer Joins)
03:39
What are the right joins? (Right Outer Joins)
03:27
FULL Outer Joins
02:25
Cross Joins (Cartesian Product)
02:38
Section 12: Subqueries (Query inside a Query)
26:04
What is a subquery?
04:56
Single Row Subqueries
07:20
Multiple Row Subqueries
08:29
Multiple Column Subqueries
05:19
Section 13: SET Operators
12:47
What are SET Operators?
03:59
UNION and UNION ALL Operators
02:54
Intersecting and Extracting the Queries
02:40
More in SET Operations
03:14
Section 14: Manipulating and Playing with the Data (DML Statements)
24:19
What is DML and Why to Use?
01:24
INSERTing New Record!
09:21
Updating the Existing Record
05:23
COMMIT and ROLLBACK Statements
03:34
DELETE Records!
04:37
Section 15: Manipulating Tables - DDL Statements
12:04
How to DROP an Existing Table
02:25
How to Create a Table With Many Ways and Rename it
09:39

About the Instructor

100% of students rated this instructor as excellent!

Code Star Academy is an offshoot from the Oracle Master who is focusing on providing students with high-quality training for modern needs. On BitDegree, their Head of Engineering Omer Faruk Ince is offering an opportunity to learn SQL from scratch. Omer is obsessed with practical examples, and he’ll share hundreds of them to help you get the taste of what it really is to work with SQL.

Code Star Academy’s trainer Omer has been working in software development for over 15 years. In that time, he had a chance and need to learn and operate in different programming languages (such as C, C++, Java, PHP, Python, and others), and then more than 10 years ago he also focused on SQL&PL/SQL programming, as well as Oracle Technologies.

Right now, Omer has a massive database of 15M+ active users entrusted for his supervision! As you can imagine, you don’t offer the management of such a gigantic database just to any random programmer, do you? So, his Omer’s projects speak for him. His experience both in programming and project management allows him to share the essentials of what you need to learn when studying different programming languages and databases. So, join Code Star Academy’s training on BitDegree, and become a coding star, too!

See All Instructor Courses

BitDegree platform reviews