Oracle SQL - Step by Step SQL




Oracle SQL - Step by Step SQL

Update 04/06/2022: 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

Discover essential SQL skills necessary to transform you into SQL developer which can earn you 70k+ in the IT Industry

Url: View Details

What you will learn
  • Understand Database terminology
  • Retrieving Data from Database using SQL Commands (Select)
  • Filtering Data based on business requirements using SQL Command (Where)

Rating: 4.52326

Level: All Levels

Duration: 6.5 hours

Instructor: Amarnath Reddy


Courses By:   0-9  A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z 

About US

The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of hugecourses.com.


© 2021 hugecourses.com. All rights reserved.
View Sitemap