Learn SQL with Examples - Simple Select

John A., Architect, Analyst and Trainer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
13 Videos (10m)
    • 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 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.

6 of 7 students recommendSee All

This is a fantastic overview on how to decode simple queries in SQL. As a new learner to SQL, this format was quite clear, helpfully repetative and the visual presentation was elegant.
It goes step by step in increasingly more complex query examples.
Very straight forward. I really like the tool that helps you get the SQL formatting down.





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 qua...

See full profile