Learn SQL with Examples - Simple Select Premium class

John A., Architect, Analyst and Trainer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
13 Videos (1h 7m)
    • Introduction

    • Schema

    • Exercise 1

    • Exercise 2

    • Exercise 3

    • Exercise 4

    • Exercise 5

    • Exercise 6

    • Exercise 7

    • Exercise 8

    • Exercise 9

    • Exercise 10

    • Conclusion


About This Class

"Learn SQL with Examples" Video Course aims at providing an insight on how to write SQL queries. We find lot of material to teach people the syntax but we do not see much on assisting individuals in analysing a problem statement and arriving at a SQL query. So we took the initiative to come out with a simple course on how to decode a problem and write SQL. We have a six step approach to analysing a problem statement and arrive at a SQL statement as given below:

  • Decode the problem statement
  • Visualize the expected output from the problem statement
  • Identify the tables in which the output report fields exist
  • Identify the columns which are required for the output
  • Build the query
  • Finally execute it and see the result

This course requires approximately one hours to complete.

We made this course graphical with less written material so that individuals can grasp the concept much faster. The graphical representation and the six step method makes the course enjoyable. We have taken 10 simple exercises and explained how to arrive at the required SQL query.

This course is designed in such a way that one can start writing SQL in hours with confidence.

We are providing a free tool jaquerybrowser to try-out the exercises which will boost the learner's confidence.





John A.

Architect, Analyst and Trainer

John Anthony has a Masters in Computer Application with around 20 years of experience in the industry. The instructor has worked on real time projects in India and USA and has successfully designed, developed projects for clients in India as well as Abroad. Also, he has life-time experience on small, medium as well as large size projects.

As an entrepreneur John Anthony has managed IT businesses for around two decades. During his tenure as an entrepreneur, he has worked with highly qualified finance professionals and made important financial decisions to foster business growth.