این دوره Oracle SQL را به صورت گام به گام آموزش می دهد. در این آموزش تصویری به معرفی مفاهیم پایگاه داده Oracle SQL می پردازد. در ادامه نحوه کار با پایگاه داده رابطه ای ، ایجاد جداول و اصلاح ساختار آن ، خواندن داده ها از پایگاه داده ، بهبود عملکرد پایگاه داده با استفاده از شاخص و… را خواهید آموخت.
این دوره آموزشی محصول موسسه Udemy است.

سرفصل های دوره:

  • نصب و راه اندازی برنامه
  • نصب Oracle
  • نصب Java SDK
  • نصب و راه اندازی SQL
  • کار با مفاهیم بانک اطلاعاتی
  • نحوه ساخت جداول در پایگاه داده
  • کار با پایگاه داده رابطه ای (RDBMS)
  • تراکنش چیست؟
  • ACID چیست؟
  • کار با رایج ترین دستورات
  • نحوه ذخیره داده ها
  • کار با مدل داده ای
  • نحوه فیلتر کردن داده ها
  • کار با عملگرهای مقایسه ای
  • کار با عملگرهای منطقی
  • کار با اپراتور ها
  • کار با عملگرهای AND و OR
  • کار با عملگرهای ریاضی
  • نحوه مرتب کردن داده ها
  • کار با عبارت ORDER BY
  • کار با دستور SET
  • کار با دستور UNION
  • کار با دستور GROUP BY
  • نحوه GROUP BY با دستور HAVING
  • نحوه Join کردن دستورات
  • DUAL چیست؟
  • کار با توابع مربوط NUMBER
  • تعریف داده ها در DDL
  • نحوه تغییر ساختار جدول با ALTER
  • نحوه دستکاری داده ها
  • کار با دستور INSERT
  • کار با دستور DELETE
  • حذف تمام داده ها از جدول با دستور TRUNCATE
  • و…

عنوان دوره: Udemy Oracle SQL – Step by Step SQL
مدت زمان: 6 ساعت
نویسنده: Amarnath Reddy


توضیحات:

Udemy Oracle SQL - Step by Step SQL

Amarnath Reddy
6 Hours
All Levels

Discover essential SQL skills necessary to transform you into SQL developer which can earn you $70k+ in the IT Industry.
Learn to become a fee-earning SQL developer in just seven weeks.
This fast, easy and effective course will take you from zero sql writing skills to being able to make money as a SQL developer.
This one-stop-shot-style course will teach you everything you need to know, from learning various database concepts to writing SQL to interact with the database.
Throughout the course I will be using the below methodology to make you think and help in forming the SQL statement.
Business Need:
Manager asks you to give you a report containing total sales volume for January month by day and city
Questions in your mind to build your query
Question Answer Give? SELECT What columns? DAY, CITY Summary? SUM(VOLUME) Preposition? FROM Which table contains sales orders data? SALES Filter? WHERE SALES_DATE BETWEEN '01-JAN-2015' and '31-JAN-2015' Grouping? GROUP BY DAY, CITY
Combine the above answers to form the below SQL
SELECT day, city, SUM(volume)
FROM sales
WHERE sales_date BETWEEN '01-JAN-2015' AND '31-JAN-2015'
GROUP BY day, city;
In this course participants will learn
Relational databases Concepts
Retreiving Data from Database
Filtering Data based on business requirements
Creating Tables and modifying its structure
Joining Data from various Tables
Grouping Data and calculating summaries
Enforcing Constraints on Tables
Improving performance using Index
and many more interesting things..
Softwares used
Oracle Database 11g
SQL Developer
What are the requirements?
Any Student with computer operation knowledge is good enough to understand this course
What am I going to get from this course?
Understand Database terminology
Read data from the database
Create data in the database
Enforce restrictions on what type of data can be stored
Improve performance using Index
What is the target audience?
This SQL course is meant for newbies who are not familiar with SQL syntax and/or students looking for a quick refresher on SQL and some important Database concepts. No programming knowledge is needed.

Lecture 1
Closed Captions/Sub Titles for the course
1 page
Lecture 2
Welcome
05:45
Lecture 3
How to make best use of the program
1 page
Section 1: Software Installation
Lecture 4
Installing Oracle
04:07
Lecture 5
Installing Java SDK
02:20
Lecture 6
Installing SQL Developer
03:21
Lecture 7
Running scripts necessary for the course
02:12
Lecture 8
Scripts for our Lab Exercises
4 pages
Section 2: Database Concepts
Lecture 9
What is a File?
02:05
Lecture 10
What is a Table?
02:23
Lecture 11
What is a Database?
03:15
Lecture 12
What is a Relational Database (RDBMS)?
01:47
Lecture 13
What is a Transaction?
02:27
Lecture 14
What is ACID??
02:40
Lecture 15
RDBMS Vendors
01:17
Lecture 16
Database Normalization
1 page
Lecture 17
CODD Rules
2 pages
Section 3: Enter the Dragon (Database)
Lecture 18
How do you talk with a Database?
01:59
Lecture 19
What are the most common commands?
02:43
Lecture 20
What type of Data can we store?
03:12
Lecture 21
Data Model for our Course
01:46
Section 4: Lets see the Data...
Lecture 22
What data can I see?
03:45
Lecture 23
How do I see data (SELECT) ?
02:51
Lecture 24
How do I see a part of the data (SELECT) ?
02:57
Lecture 25
Lab 1 (Exercises with Answers)
2 pages
Section 5: Lets limit the data we see (Filtering)
Lecture 26
Filtering Data (WHERE command)
03:21
Lecture 27
Comparison Operators
01:38
Lecture 28
Filtering Data (More Examples...)
03:34
Lecture 29
Filters on Character and Date values...
04:39
Lecture 30
Filtering based on a column in a table...
04:02
Lecture 31
Lab 2 (Exercises with Answers)
2 pages
Section 6: Logical Operators
Lecture 32
BETWEEN and NOT BETWEEN
02:32
Lecture 33
IN and NOT IN
02:52
Lecture 34
LIKE operator
04:17
Lecture 35
ALL and ANY
03:33
Lecture 36
Lets learn about NULL
02:08
Lecture 37
IS NULL and IS NOT NULL
03:18
Lecture 38
AND and OR
05:27
Lecture 39
Lab 3 (Exercises with Answers)
2 pages
Section 7: Arithmetic operators
Lecture 40
They are simple!!! (10 + 20 = 30)
02:42
Lecture 41
Lab 4 (Exercises with Answers)
2 pages
Section 8: Lets sort the data we see (Sorting)
Lecture 42
ORDER BY clause
04:04
Lecture 43
How are NULL values treated while Sorting Data?
02:06
Lecture 44
Lab 5 (Exercises with Answers)
2 pages
Section 9: How do we combine data from 2 tables?
Lecture 45
SET Operators
02:39
Lecture 46
UNION operator
04:22
Lecture 47
UNION ALL operator
01:28
Lecture 48
INTERSECT operator
02:00
Lecture 49
MINUS operator
02:24
Lecture 50
Lab 6 (Exercises with Answers)
2 pages
Section 10: Lets group the data...
Lecture 51
Aggregate/Summary Functions
05:28
Lecture 52
GROUP BY clause
04:08
Lecture 53
GROUP BY with multiple columns
05:00
Lecture 54
GROUP BY with HAVING clause
03:21
Lecture 55
Lab 7 (Exercises with Answers)
2 pages
Section 11: Joining data from 2 or more tables (JOINS)
Lecture 56
Why Joins?
03:53
Lecture 57
Inner Join
05:08
Lecture 58
Left Outer Join
02:43
Lecture 59
Right Outer Join
02:35
Lecture 60
Full Outer Join
02:26
Lecture 61
Cross Join
02:58
Lecture 62
Natural Join
02:22
Lecture 63
Lab 8 (Exercises with Answers)
2 pages
Section 12: Functions available for us to use...
Lecture 64
DUAL (What is this?)
02:37
Lecture 65
Why do we need functions?
01:28
Lecture 66
NUMBER related functions
03:47
Lecture 67
CHARACTER related functions
04:07
Lecture 68
DATE related functions
04:56
Lecture 69
Lab 9 (Exercises with Answers)
1 page
Section 13: Interesting THINGS!!!
Lecture 70
IF THEN ELSE (CASE statement)
03:19
Lecture 71
Alternative Name (ALIAS name)
04:03
Lecture 72
DISTINCT values
03:18
Lecture 73
PSEUDO Columns
03:26
Section 14: Lets Recap with a 5 Step Process
Lecture 74
Business Requirement
03:12
Lecture 75
Step 1: Let's Select all the columns needed...
05:41
Lecture 76
Step 2: Let's add the necessary Filters...
00:58
Lecture 77
Step 3: Let's perform the Grouping...
01:52
Lecture 78
Step 4: Let's perform Filtering at Group level...
01:04
Lecture 79
Step 5: Lets Sort the data...
00:54
Lecture 80
Recap the 10 things we have done...
01:51
Section 15: Data Definition Language (DDL)
Lecture 81
Let's create a table (CREATE)
02:57
Lecture 82
Let's change the structure of a table (ALTER)
04:50
Lecture 83
Let's delete the table (DROP)
01:01
Lecture 84
Lab 11 (Exercises with Answers)
2 pages
Section 16: Data Manipulation Language (DML)
Lecture 85
COMMIT and ROLLBACK
01:28
Lecture 86
Insert data into a table (INSERT)
05:14
Lecture 87
Delete data from a table (DELETE)
03:32
Lecture 88
Modify existing data in a table (UPDATE)
03:49
Lecture 89
Delete all the data from a table (TRUNCATE)
03:01
Lecture 90
Lab 12 (Exercises with Answers)
2 pages
Section 17: Lets put some restrictions on a table (Constraints)
Lecture 91
Why constraints?
01:51
Lecture 92
No empty data allowed (NOT NULL)
03:35
Lecture 93
No Duplicate data (UNIQUE)
03:06
Lecture 94
What is NOT NULL + UNIQUE = PRIMARY KEY
03:25
Lecture 95
Accept only few values (CHECK)
03:26
Lecture 96
Check data in other table before inserting/deleting (FOREIGN KEY)
04:46
Lecture 97
Constraints on multiple columns
03:13
Lecture 98
Adding constraints to an existing table
02:04
Lecture 99
More operations on Constraints...
02:11
Lecture 100
Lab 13 (Exercises with Answers)
2 pages