Skip to content
UdemySQLPaid courseIntermediate levelCertificate

SQL - Beyond The Basics (Udemy.com)

Go beyond simple database creation and queries into subqueries, variables, functions and more.

Created by: Infinite Skills

Last updated January 2017

icon
What you will learn

  • create and interact with SQL databases at an intermediate to advanced level
  • utilize subqueries, variables, custom functions and more

How it compares

Against the other 388 rated Udemy courses in SQL on CourseDuck:

  • Rating4.3 out of 5higher than 22% of them
  • Reviews634#187 of 389 by number of reviews
  • Length4.3 hoursshorter than 63% of them
  • Last updatedJanuary 2017earlier than 89% of them

icon
Course Description

In this SQL - Beyond the Basics training course, expert author Guy Vaccaro will dive deeper into SQL and covers advanced techniques. This course is designed for users that already have experience with SQL. You will start by learning a variety of useful skills, including how to convert datatypes, create a temporary table, and declare and use variables. From there, Guy will teach you about sub queries, the CASE statement, and numbering and ranking.

This video tutorial also covers using built in functions, creating and using your own functions, and creating views. Finally, you will learn about stored procedures, such as how to create and run a stored procedure, loop with WHILE and IF, and dynamically build SQL statements. Once you have completed this computer based training course, you will have expanded your skills and be able to make more efficient use of SQL.

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Infinite Skills

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

icon
More courses by Infinite Skills

Free

$19.99

$15.99

$22.99

Free

$11.99

icon
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

icon
Reviews

4.3

634 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Pantelis Simeonidis on 2/14/2024

Overall a very good and informative course. Covered a lot of context with short lectures that don't exhausts you. In my opinion it was lacking in practical exercises and assessments. (p.s. I found the audio sometimes a bit challenging to follow but minor detail.)

By John Crick on 3/7/2022

This course was a good refresher on some of the more complex concepts that I do not use every day, such as cursors. Whilst it is good to see how to write the code, what would have enhanced the course would be to understand why we would use some of these. For example, in what scenarios would we use ranking. What are the benefits? Overall a decent course which was easy to follow and provided decent examples of writing the code.

By Peryno Riley on 3/9/2020

The subject matter and pace is perfect for me. Answers a lot of questions I've had about SQL. Includes queries that I've never considered but will now. I've already realized a solution to an issue I've struggled with in the past. Instant pay-off.

By Simon Ouellette on 10/21/2019

Most was good. But there is still some issues that haven't been explained in details. For example, it's never mentioned explicitly that a declared variable is valid only in the batch within it's declared. I would have liked to know why it is that way. I thus don't really understand why whe should put some calculation within a variable if we can't really use it afterward. In the same direction, I don't understand the benefits of dynamic sql, due to the same fact that variables can't be reuse in a subsequent batch.

By Manny Singh on 5/5/2019

Overall a great introduction to advanced sql concepts. Should have covered other topics such as materialized views, more windows functions, and little bit on database normalization. Some of videos had very low volume so it was bit hard to hear, but overall i am satisfied with the course.

By David Lockwood on 5/26/2018

If your job involves SQL (three years for me) and you aren't at expert/guru status, take this course. This stuff is instantly applicable. Might be my favorite UDemy course so far. You have a sample database to follow along with. The guy covers each skill in a succinct ~five min video. I ended buying this after a couple soul draining hours browsing ggl/stackexchange. Answers there were garbage. Solution i found here was that i can put the same Case in my Select and Group By statement. I've probably applied four or five different items at work already

By AndrĂ¡s Kokavecz on 2/28/2018

I like the way, the style and the pace the instructor is explaining the topic. I think it's in-sync with the nature of this intermediate (non-beginner) course. Good job! One slight improvement could be to indent the SQL code examples a bit better to make it more readable in more complex cases.

By Gary Cully on 12/29/2017

Very useful content that I've seen in many places on web. What distinguishes this course is the presenter's easy-to-understand demonstrations of building queries to solve typical problems. I will use this content immediately in my work. I really received good value from this one.

By A.R.H . on 1/30/2016

I really enjoyed this course. The instructor definitely has a knack for teaching. There is an amazing amount of content covered; just enough to give you a solid footing with SQL. Highly recommended for those needing to fill in the gaps on their knowledge, or if you're just starting out. It's worth the time and money spent.

By Jeremy Springfield on 9/15/2015

This class is very well presented and has wonderful flow from topic to topic. It explores advanced sql topics, which may not get frequent use, but are valuable none the less. The instruct has a great delivery and keeps the material interesting. I did find myself wondering what each component is most useful for. Some real world examples of what each SQL statement generally gets used for would be very helpful as example.

Showing all 10 reviews on CourseDuck

Read all 634 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 86 / 100