Learn SQL with Examples - Simple Select | John A. | Skillshare

Learn SQL with Examples - Simple Select

John A., Architect, Analyst and Trainer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
13 Lessons (10m)
    • 1. Introduction

      1:47
    • 2. Schema

      8:11
    • 3. Exercise 1

      4:17
    • 4. Exercise 2

      4:30
    • 5. Exercise 3

      3:42
    • 6. Exercise 4

      4:35
    • 7. Exercise 5

      4:48
    • 8. Exercise 6

      5:11
    • 9. Exercise 7

      4:37
    • 10. Exercise 8

      7:35
    • 11. Exercise 9

      9:40
    • 12. Exercise 10

      6:01
    • 13. Conclusion

      0:53

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.