"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:
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.
List all the Publisher IDs from the books table.
List all Book titles along with the Publisher Name sorted by Publisher ID and then by Book title.
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.