Subquery Magic: Write awesome SQL, Master T-SQL Sub Queries

Name: Subquery Magic: Write awesome SQL, Master T-SQL Sub Queries
Brand: Udemy
SKU: 46937
Price: 10.99 USD
Availability: InStock

$10.99Track price

Kris Wenzel 47 SQL Udemy

Add your review

Description
Instructor Details
Additional information
Reviews (17)

8.6/10 (Our Score)

Product is rated as #38 in category SQL

In this Course you will Learn to:

Know and understand subqueries

Identify subqueries in SQL

Use subqueries in your select statement

Use subqueries in the WHERE clause with EXISTS and IN

Use subqueries with SUM, MAX and other Aggregate functions in GROUP BY and HAVING

Write correlated subqueries (this is a big deal)

Nothing is worse than

Being excited to learn something new but not knowing where to start.

Wasting time learning the wrong features.

Being overwhelmed with options and not know which to use.

Imagine Having…

Knowledge – Knowing how to quickly use subqueries to take your SQL to the next level.

Confidence – Feeling good that you re on the right track.

Accomplishment – Having a sense of accomplishment that you’ve learned something most can not.

Fun – Actually having fun learning SQL subqueries!

By the time you ve completed this course you ll have an appreciation of subqueries, overcome your fear, and able to write correlated queries to make your SQL more robust.

Instructor Details

Kris WenzelLet me teach you SQL using simple to understand English.

Votes: 0

Courses : 4

Hello my name is Kris. I m here because I am passionate about helping non-techie people to overcome their fear of learning SQL. Let Me Help you Get Started on the Right Foot! I know what it is like to not know where to start or whether the time spent learning is worth the effort. That is why I am here to help you to: Get started in an easy to follow step-by-step manner. Use your time wisely so you focus on what is important to learn to get the most value from your time. Answer your questions. Really! Just post a comment and I ll respond. I m here to help. It wasn t long ago that I was helping a colleague with some reporting. She didn t know where to start and soon got overwhelmed and lost as she didn t know SQL. I felt really bad, as she was under pressure to get some summary information to her boss, the built-in reports were falling short, and to make them better would require her to know SQL. At that time that seemed impossible! It in dawned on me, it doesn t have to be that way. Then I discovered a way for anyone with the desire to easily learn SQL. I worked with my co-worker, started to teach her what I learned and soon she was able to write reports and answer her boss questions without getting stressed or ploughing hours into manipulating data in Excel. It hasn t always been easy. Sometimes the information seems abstract or too conceptual. In this case I ve found out that a visual explanation is best. I really like to use diagrams or videos to explain hard-to-grasp ideas. Having video, pictures, and text really help to reinforce the point and enable learning. I know that you want to: be confident writing SQL understand more complicated topics such as joins and sub-queries become fluent in database terms and concepts understand query optimization and performance tuning start your path to become a DBA Through my conversation style, easy to understand lessons, videos, and info-graphics, I ll help you to do this an more. It will take action on your part, but I'm here to help you along the way! So How Did I Become Such A Geek? My journey to SQL starts when back in 1979 when I was in a freshman in High School. Back then I was really interested in computers and joined a Computer Explorer s post hosted by Dow Chemical. We met once a week at the office and got to work on their mini-computers. It was awesome! I learned how to program and really took an interest to it. So much so, that I took my savings and bought a early home computer (Radio Shack TRS-80 Model I). It didn t do much, as it only had 16K of memory, but it was enough for me to learn programming. We ll that was over thirty years ago and I ve loved them ever since. In college I studied computer engineering at University of Michigan (go blue!). I got to learn hardware and software design. One class I really found fascinating was my database theory class. We studied relational database theory and it was great. Before this class I didn t know about databases and every time we wanted to work with data, we would have to write huge programs to do so. Once I learned about databases I realize how powerful they were. We ll I kept at it and now some twenty five years later, I m ready to share my experiences with you.

Specification: Subquery Magic: Write awesome SQL, Master T-SQL Sub Queries

Duration	3 hours
Year	2020
Level	Beginner
Certificate	Yes
Quizzes	Yes

17 reviews for Subquery Magic: Write awesome SQL, Master T-SQL Sub Queries

4.5 out of 5

★★★★★

Write a review

Show all Most Helpful Highest Rating Lowest Rating

★★★★★
Steve MacLeod – June 18, 2019
Great content and delivery!
Helpful(0) Unhelpful(0)You have already voted this
★★★★★
Deepika Rajan – August 24, 2019
provides a solid foundation on subqueries. And the trainer explains in a simple yet logical manner. Love it so far.
Helpful(0) Unhelpful(0)You have already voted this
★★★★★
Wayne Shackel – September 5, 2019
Outstanding, very good examples, very good course.
Helpful(0) Unhelpful(0)You have already voted this
★★★★★
Mogili Suman Sai Rajesh – December 4, 2019
Good explanation over correlated sub queries.
Helpful(0) Unhelpful(0)You have already voted this
★★★★★
MaryAnn McDaniel – December 12, 2019
This sounds like it’s going to address the weakness that I was hoping it would. So far the pace is good and the content clear. Excited to hear more
Helpful(0) Unhelpful(0)You have already voted this
★★★★★
Zusunny Dawood–Abadi – January 4, 2020
Good insights
Helpful(0) Unhelpful(0)You have already voted this
★★★★★
Zusunny Dawood Abadi – January 4, 2020
Good insights
Helpful(0) Unhelpful(0)You have already voted this
★★★★★
Sergio R Aceves – January 8, 2020
I lerned a lot form this cures, it realy teache you the basics of subquerys. If I coudl say something to make it better is to include exersices, for the students to practice
Helpful(0) Unhelpful(0)You have already voted this
★★★★★
Gaurav Srivastava – January 10, 2020
Incredibly helpful course. I reference quite often. Highly recommend!
Helpful(0) Unhelpful(0)You have already voted this
★★★★★
Ferdinand Espiritu – January 11, 2020
This is the knowledge I needed to modify this existing legacy scripts at work, which has complex nested correlated subqueries and derived tables. I just wish there was a tool out there to easily breakdown and visualize the scripts. Thanks again.
Helpful(0) Unhelpful(0)You have already voted this
★★★★★
Mike Franke – January 21, 2020
Good course. I’m picking up some SQL tricks from it, which is what I was hoping to do. (Unit 14 needs a little editing. 🙂 )
Helpful(0) Unhelpful(0)You have already voted this
★★★★★
Christian Schmitz–Moormann – January 29, 2020
Good material for this not totally basic topic. Clear explanations, solid learning path.
Helpful(0) Unhelpful(0)You have already voted this
★★★★★
Christian Schmitz Moormann – January 29, 2020
Good material for this not totally basic topic. Clear explanations, solid learning path.
Helpful(0) Unhelpful(0)You have already voted this
★★★★★
Pradeesh S – January 30, 2020
Well and good explanation. Good for Beginner level learners.
Helpful(0) Unhelpful(0)You have already voted this
★★★★★
Victor Latorre Castello – February 11, 2020
Muy lento, poco contenido para su duraci n.
Helpful(0) Unhelpful(0)You have already voted this
★★★★★
Bill Kelly – March 27, 2020
I found the explanations and examples very helpful. Thanks!
Helpful(0) Unhelpful(0)You have already voted this
★★★★★
Mei Wu – July 31, 2020
Excellent instructions. Highly recommended!
Helpful(0) Unhelpful(0)You have already voted this