Learn SQL with Examples - Simple Select
3.7 (13 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
600 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn SQL with Examples - Simple Select to your Wishlist.

Add to Wishlist

Learn SQL with Examples - Simple Select

Online SQL Query Practice tool included
3.7 (13 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
600 students enrolled
Created by John Anthony
Last updated 5/2017
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • The objective is to make the course enjoyable and make an individual to start writing SQL in an hour’s time with clear understanding.
  • The key advantage is this course aims at teaching you on how to decode a problem which is very essential for any programmer / DBA
View Curriculum
Requirements
  • No prior SQL knowledge is required. Completing my earlier course Learn SQL in 6 Days is preferred but not a must.
Description

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

Who is the target audience?
  • "Learn SQL with examples" can be used by any and every technology professional as well as individuals pursuing their graduation / post-graduation in the Computer Science or Information Technology sector.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
13 Lectures
01:05:47
+
Introduction
1 Lecture 01:47

This lecture gives an overview of the course.

Preview 01:47
+
SCHEMA
1 Lecture 08:11
+
EXERCISES
10 Lectures 54:56
List all the Publisher names from the publisher table.
Preview 04:17

List all the Customers first name along with their Address
Exercise 2
04:30

List all the Publisher IDs from the books table.
Exercise 3
03:42

List all the Publisher IDs from the books table.

Exercise 4
04:35

List all the state names in the descending order.
Exercise 5
04:48

List all the Customers first name along with their Address sorted by Customer Name
Exercise 6
05:11

List all Book titles along with the Publisher ID sorted by Publisher ID and then by Book title.
Exercise 7
04:37

List all Book titles along with the Publisher Name sorted by Publisher ID and then by Book title.

Exercise 8
07:35

List all Customer Name, Address, City, State and Country sorted by Country and then by State.
Exercise 9
09:40

List unique City Names of the Publishers
Exercise 10
06:01
+
Conclusion
1 Lecture 00:53
Conclusion
00:53
About the Instructor
John Anthony
3.7 Average rating
91 Reviews
1,869 Students
2 Courses
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.