Kris Wenzel
In this Course you will Learn to:
Use different types of joins to solve real–world query problems.
Understand the key differences between inner and outer joins.
Use non–equi joins to solve interesting problems such as calculating running totals.
Combine columns from two or more tables into a single result.
Know when to use an outer join.
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 joins 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 cannot.
Fun – Having fun learning SQL inner and outer joins!
By the time you ve completed this course you ll have an appreciation of joins, overcome your fear, and able to write queries combining data from multiple tables.
Now that s cool!
Instructor Details
Courses : 4
Specification: Join Together Now: Write T-SQL Joins to query SQL Server
|
30 reviews for Join Together Now: Write T-SQL Joins to query SQL Server
Add a review
| Price | $13.99 |
|---|---|
| Provider | |
| Duration | 2.5 hours |
| Year | 2020 |
| Level | Beginner |
| Language | English |
| Certificate | Yes |
| Quizzes | Yes |
$13.99
Oluyemi Ikumawoyi –
Brilliant
Nama Coulibaly –
Good flow
Jeffrey Hass –
I like it that you introduced database diagrams early in the class and accurately described the thought process of what you need to know before even trying to code a query.
Donald Randle –
Yes this course is a good match, I am experienced with SQL but haven’t worked with the language recently. I find the explainations expressed by the instructor in a very clear, easy to understand manner.
Chris Winkler –
Easy to follow. Good quizzes and assignments.
Chris Winkler –
Easy to follow. Good quizzes and assignments.
Catrina Pinkston –
Great job
Catrina Pinkston –
Great job
Justin Zahn –
Great course. The pace is perfect and the instructor is very clear and easy to understand.
Justin Zahn –
Great course. The pace is perfect and the instructor is very clear and easy to understand.
Wayne Shackel –
A truly outstanding course, really great. I had questions and they were answered. I really enjoyed the assignments. They made you think and gave you a chance to put into practice what you learned.
Wayne Shackel –
A truly outstanding course, really great. I had questions and they were answered. I really enjoyed the assignments. They made you think and gave you a chance to put into practice what you learned.
Ray Alvarez–Torre –
Good experience. I wish the SQL code provided was in a .sql or .txt file instead of .pdf, but it is a minor thing. I also believe that a course like this, having table illustration examples, would be very beneficial. It is much easier to follow the complexities when I can see a picture of the table columns.
Ray Alvarez Torre –
Good experience. I wish the SQL code provided was in a .sql or .txt file instead of .pdf, but it is a minor thing. I also believe that a course like this, having table illustration examples, would be very beneficial. It is much easier to follow the complexities when I can see a picture of the table columns.
Ray Alvarez Torre –
Good experience. I wish the SQL code provided was in a .sql or .txt file instead of .pdf, but it is a minor thing. I also believe that a course like this, having table illustration examples, would be very beneficial. It is much easier to follow the complexities when I can see a picture of the table columns.
T R –
Enjoyed, and learned a lot…
T R –
Enjoyed, and learned a lot…
David Keevis –
Good, full explanation of outer and self joins with solid examples of how to handle diagnosing a poorly designed database and getting at the answers to questions managers ask.
David Keevis –
Good, full explanation of outer and self joins with solid examples of how to handle diagnosing a poorly designed database and getting at the answers to questions managers ask.
Zusunny Dawood–Abadi –
This is a good course but very beginnish. I was disappointed there were no unions and no talk on performance optimization and comparison of different joint types.
Zusunny Dawood Abadi –
This is a good course but very beginnish. I was disappointed there were no unions and no talk on performance optimization and comparison of different joint types.
Zusunny Dawood Abadi –
This is a good course but very beginnish. I was disappointed there were no unions and no talk on performance optimization and comparison of different joint types.
Chris Rush –
Excellent course so far.
Chris Rush –
Excellent course so far.
Christian Schmitz–Moormann –
Clear, concise, not too simplistic
Christian Schmitz Moormann –
Clear, concise, not too simplistic
Christian Schmitz Moormann –
Clear, concise, not too simplistic
S H –
Lots of good stuff here to make sense of what you may know so far, and to build on. Having some knowledge of T SQL and a beginning look at joins would be useful to get the most from the course. Kris offers lots of materials to help if you want to cue this into other areas of T SQL/SQL Server study.
Stacie A Kinjorski Steinman –
It’s very easy to follow and understand.
Mei Wu –
Great instructor with detailed explanations of concepts