Amarnath Reddy
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
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
Softwares used
Instructor Details
Courses : 2
Specification: Oracle SQL – Step by Step SQL
|
12 reviews for Oracle SQL – Step by Step SQL
Add a review
| Price | $10.99 |
|---|---|
| Provider | |
| Duration | 6.5 hours |
| Year | 2018 |
| Level | All |
| Language | English |
| Certificate | Yes |
| Quizzes | No |
$10.99
Cassie Finer –
Hard to understand instruction sometimes. CC would be really helpful!
Aman Sharma –
Till now it is has not fulfilled my expectations, because I was already familiar with the topics. Lets see in further topics,what is there for me!
Igors Stankunovs –
Very well structured and clear course. Many thanks to the lecturer! Great job!
Guru –
This course is very basic. but it has been explained very clearly.
Bishal Mahanta –
I got all the basic knowledge of SQL by following this course, but I was expecting to learn Oracle 11g architecture, like what is user, what is connection, what is role, what is sid in sql developer are still not that clear for me, I didn’t find any lecture on how I can create new user if I want to and how I can create a new database, If any one want to learn just SQL this course will be your starter.
Eric Ndau –
so far so looks excellent
Amit Nagpal –
Excellent course!The concepts are clearly explained with sufficient examples.
Murali Mohan –
Excellent presentation
Umesh Gurung –
It was good. Easy to understand. Very useful to learn the basics.
Sinto K Simon –
Good
Craig Sigerson –
So far so good.
Swapnil Jain –
It was good