You are not logged in. Please login or register.

Copyright Disclaimer: This site does not store any files on its server. We only link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.

Otomatic
Active Member
From: Russian Federation
Registered: 20.04.2016
Posts: 90
Reputation: 702

Re: error during the installation

[SHARE] Oracle SQL - Step by Step SQL

Download

File Size: 72 mb X 125 Lessons

Password: http://downloadcourses.net

Enjoy

RAR file contains


		1. Oracle SQL - Step by Step SQL.zip
		2. ReadMe.Important!.txt
		3. Changelog.txt
		4. Documentation.html
		5. Oracle SQL - Step by Step SQL Update.zip
		

VirusTotal.com Scan


		SHA256:	82f9fcfcd19672052822b5bb1f9ec2147491ad1b82cf29f16f2211631b96d329
		File name:	Oracle SQL - Step by Step SQL.rar
		Detection ratio:	0 / 53 / Clean 
		Analysis date:	08.06.2016 17:29 UTC
		

Description


		

Update 10/06/2016: Added new exercises

Update 01/04/2016: Closed Captions/Sub Titles are added to the Lectures.

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 SQL�course will teach you everything you need to know about SQL, from learning various database concepts to writing SQL to interact with the database.

Throughout this SQL�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 SQL�query

  • 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
  • Retrieving Data from Database using SQL Commands (Select)
  • Filtering Data based on business requirements using SQL Command (Where)
  • Creating Tables and modifying its structure using SQL commands (Create,�Alter)
  • Joining Data from various Tables using SQL Joins
  • Grouping Data and calculating summaries using SQL�GROUP BY and SQL�Aggregate functions
  • Combining data from 2 or more tables using SQL keywords (UNION, UNION ALL, INTERSECT, MINUS)
  • Enforcing Constraints on Tables using SQL commands (Create. Alter)
  • Creating views using SQL command (Create View)
  • Creating other database objects (SYNONYMS, SEQUENCES) using the SQL commands
  • Controlling the access to the users using SQL commands (GRANT, REVOKE)
  • Improving performance using SQL command (create�Index )
  • Project Work at the summarize the�SQL concepts we learnt.
  • and many more interesting things..

Softwares used

  • Oracle Database 11g
  • SQL Developer

Related Threads

Pagination


Offline

Log In to See All Replies

10.09.2016 01:08

Gazile
Active Member
From: Panama
Registered: 06.10.2015
Posts: 394
Reputation: 440

Oracle SQL - Step by Step SQL -

Great share, Thank you and +5 reps added.


Online

18.09.2016 06:38

Mandivensept1987
Active Member
From: Peru
Registered: 11.03.2016
Posts: 349
Reputation: 17

Oracle SQL - Step by Step SQL -

Nice share! already gave U +5 Rep.


It is good to love many things, for therein lies the true strength, and whosoever loves much performs much, and can accomplish much, and what is done in love is well done.

Offline

22.09.2016 05:38

Flaved
Member
From: Kenya
Registered: 12.08.2016
Posts: 381
Reputation: 374

Oracle SQL - Step by Step SQL -

$trikes again. Thanks brother!


I am both happy and sad at the same time, and I'm still trying to figure out how that could be.

Offline

23.09.2016 10:29

Fous2001
Member
From: San Marino
Registered: 12.07.2016
Posts: 303
Reputation: 757

Oracle SQL - Step by Step SQL -

+repped for the share


Offline

03.10.2016 00:09

Vichill1997
VIP
From: Bahrain
Registered: 31.01.2016
Posts: 69
Reputation: 91

Oracle SQL - Step by Step SQL -

Thank you in advance for the share


Online

11.10.2016 07:30

Purned
Member
From: Dominican Republic
Registered: 07.02.2016
Posts: 239
Reputation: 74

Oracle SQL - Step by Step SQL -

Max Rep


Offline

19.10.2016 12:42

Bestinge
Noob
From: Croatia
Registered: 25.03.2016
Posts: 398
Reputation: 537

Oracle SQL - Step by Step SQL -

This is a really good share and very clean. Reps and thank you.


A classic is a book that has never finished saying what it has to say.

Online

25.10.2016 02:40

Trabut1994
Active Member
From: Bahamas
Registered: 19.09.2015
Posts: 320
Reputation: 135

Oracle SQL - Step by Step SQL -

Thanks for the effort! :)


Offline

Board footer

Udemy Courses

Powered by FluxBB