Latest Courses
Integrate Free Jitsi Video Conference Api In PHP CodeIgniterCheck course
The Theory of Deep Learning - Become a Data ScientistCheck course
Build a Complete Youtube Video App: Swift2.2 & 3 and XcodeCheck course
Shopify Mastery | Build a Shopify Store in Just 1 HourCheck course
Java Regular Expression FoundationCheck course
Agile Software Testing - Techniques and ToolsCheck course
Python Programming Skills Test With ExplanationCheck course
Beginners Eclipse Java IDE Training CourseCheck course
Xamarin Android - A Master Guide to App Development in C#Check course
Python for beginnersCheck course
Integrate Free Jitsi Video Conference Api In PHP CodeIgniterCheck course
The Theory of Deep Learning - Become a Data ScientistCheck course
Build a Complete Youtube Video App: Swift2.2 & 3 and XcodeCheck course
Shopify Mastery | Build a Shopify Store in Just 1 HourCheck course
Java Regular Expression FoundationCheck course
- 30% Join Together Now:  Write T-SQL Joins to query SQL Server

Join Together Now: Write T-SQL Joins to query SQL Server

$19.99 $13.99Track price

Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare
8.2/10 (Our Score)
Product is rated as #128 in category SQL

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

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: Join Together Now: Write T-SQL Joins to query SQL Server

Duration 2.5 hours
Year 2020
Level Beginner
Certificate Yes
Quizzes Yes

30 reviews for Join Together Now: Write T-SQL Joins to query SQL Server

4.4 out of 5
11
16
3
0
0
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. Avatar

    Oluyemi Ikumawoyi

    Brilliant

    Helpful(0) Unhelpful(0)You have already voted this
  2. Avatar

    Nama Coulibaly

    Good flow

    Helpful(0) Unhelpful(0)You have already voted this
  3. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  4. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  5. Avatar

    Chris Winkler

    Easy to follow. Good quizzes and assignments.

    Helpful(0) Unhelpful(0)You have already voted this
  6. Avatar

    Chris Winkler

    Easy to follow. Good quizzes and assignments.

    Helpful(0) Unhelpful(0)You have already voted this
  7. Avatar

    Catrina Pinkston

    Great job

    Helpful(0) Unhelpful(0)You have already voted this
  8. Avatar

    Catrina Pinkston

    Great job

    Helpful(0) Unhelpful(0)You have already voted this
  9. Avatar

    Justin Zahn

    Great course. The pace is perfect and the instructor is very clear and easy to understand.

    Helpful(0) Unhelpful(0)You have already voted this
  10. Avatar

    Justin Zahn

    Great course. The pace is perfect and the instructor is very clear and easy to understand.

    Helpful(0) Unhelpful(0)You have already voted this
  11. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  12. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  13. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  14. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  15. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  16. Avatar

    T R

    Enjoyed, and learned a lot…

    Helpful(0) Unhelpful(0)You have already voted this
  17. Avatar

    T R

    Enjoyed, and learned a lot…

    Helpful(0) Unhelpful(0)You have already voted this
  18. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  19. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  20. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  21. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  22. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  23. Avatar

    Chris Rush

    Excellent course so far.

    Helpful(0) Unhelpful(0)You have already voted this
  24. Avatar

    Chris Rush

    Excellent course so far.

    Helpful(0) Unhelpful(0)You have already voted this
  25. Avatar

    Christian Schmitz–Moormann

    Clear, concise, not too simplistic

    Helpful(0) Unhelpful(0)You have already voted this
  26. Avatar

    Christian Schmitz Moormann

    Clear, concise, not too simplistic

    Helpful(0) Unhelpful(0)You have already voted this
  27. Avatar

    Christian Schmitz Moormann

    Clear, concise, not too simplistic

    Helpful(0) Unhelpful(0)You have already voted this
  28. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  29. Avatar

    Stacie A Kinjorski Steinman

    It’s very easy to follow and understand.

    Helpful(0) Unhelpful(0)You have already voted this
  30. Avatar

    Mei Wu

    Great instructor with detailed explanations of concepts

    Helpful(0) Unhelpful(0)You have already voted this

    Add a review

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Join Together Now:  Write T-SQL Joins to query SQL Server
    Join Together Now: Write T-SQL Joins to query SQL Server

    $19.99 $13.99

    Price tracking

    Register New Account
    Reset Password
    Compare items
    • Total (0)
    Compare