Latest Courses
ISTQB Artificial Intelligence Tester Sample ExamsCheck course
JAVA Programming Online Practice ExamCheck course
Programming for Kids and Beginners: Learn to Code in PythonCheck course
Practice Exams | Codeigniter 4 developer certificationCheck course
WordPress Practice Tests & Interview Questions (Basic/Adv)Check course
Git &Github Practice Tests & Interview Questions (Basic/Adv)Check course
Machine Learning and Deep Learning for Interviews & ResearchCheck course
Laravel | Build Pizza E-commerce WebsiteCheck course
101 - F5 CERTIFICATION EXAMCheck course
Master Python by Practicing 100 QuestionCheck course
ISTQB Artificial Intelligence Tester Sample ExamsCheck course
JAVA Programming Online Practice ExamCheck course
Programming for Kids and Beginners: Learn to Code in PythonCheck course
Practice Exams | Codeigniter 4 developer certificationCheck course
WordPress Practice Tests & Interview Questions (Basic/Adv)Check course
- 40% Stored Procedures Unpacked: Learn to Code T-SQL Stored Procs

Stored Procedures Unpacked: Learn to Code T-SQL Stored Procs

$17.99Track price

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

Before I Tell You All About This Life–Changing Program, Let’s Talk About Who This is Really For…

You are in the right place if you’re an ambitious professional who wants to learn stored procedures to expand their SQL skill set, open job opportunities, and advance their career.

Whether You’re…

A developer looking to secure your app with stored procedures.

A consultant looking to expand your tool set

An IT professional looking to read and understand database code

An analyst looking to parametrize PowerBI queries

You’re in the right place and I’m going to tell you exactly how Stored Procedure Unpacked gives you the tools, inspiration, and unparalleled support on your journey to level up your SQL skills.

In this Course you will Learn to:

Use stored procedures to implement business logic.

Develop stored procedures from scratch!

Learn some basic  troubleshooting skills.

Know the right way to use cursors.

Apply database transaction techniques to commit or rollback your database changes.

Trap and handle errors.

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 write stored procedures to take your SQL to the next level.

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: Stored Procedures Unpacked: Learn to Code T-SQL Stored Procs

Duration

3.5 hours

Year

2020

Level

All

Certificate

Yes

Quizzes

Yes

19 reviews for Stored Procedures Unpacked: Learn to Code T-SQL Stored Procs

3.9 out of 5
5
7
7
0
0
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. Prophecy

    Good lesson

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

    Good basic course. Section on cursors & transactions was very useful. Only basic error trapping and handling covered. Virtually no T SQL covered. Pace of each lesson was appropriate little time wasted on typing code which was a plus. Makes available all code examples and slides as resources which is helpful.

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

    At first I had doubts that I could cover all this material in such a short course, but the way it is laid out with the assignments makes it a great learning tool. I feel comfortable writing my own code with cursors now and reviewing others.

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

    The title of the lecture obscures some of the details on the screen.. But so far apart for that minor irritation it matches what I need.

    Helpful(0) Unhelpful(0)You have already voted this
  5. Juan M. Garcia

    very consized and interesting, great job.

    Helpful(0) Unhelpful(0)You have already voted this
  6. Christian Schmitz–Moormann

    Clear, focused, good to follow.

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

    Very good, very brief overview of SQL Server Stored Procedures. Extensive and varied use of debugging tools.

    Helpful(0) Unhelpful(0)You have already voted this
  8. Christian Schmitz Moormann

    Clear, focused, good to follow.

    Helpful(0) Unhelpful(0)You have already voted this
  9. P.J. Thierry

    did the course, but using SSMS 18 urged for some searching how to debug. using visual studio is the way to go as smss 18 does not support debugging anymore

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

    This was a good basic intro so far. I really like that you stayed focused and didn’t spend tons of time getting side tracked explaining unnecessary topics.

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

    seems to be interesting. important to do easy steps forward.

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

    Good intro course, however, the instructor uses tools, like the debugger, that are now deprecated in SSMS v18. Multiple questions, including several related to this deprecated feature, are left unanswered. So, at best, this course is useful if you are using SSMS 17.9 or below, but you might want to look elsewhere if you want to get responses to your questions and/or you want all the course content to be relevant with the most up to date SSMS software.

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

    some real time examples should have discussed here

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

    good explanations and a few practice exercises

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

    Good content

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

    good

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

    So far so good, slow and clear explanation!

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

    very good and practical and for beginners. Very good

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

    Would have liked to have more exercises, and more explanation on purpose of several used 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.

    Stored Procedures Unpacked: Learn to Code T-SQL Stored Procs
    Stored Procedures Unpacked: Learn to Code T-SQL Stored Procs

    $17.99

    Price tracking

    Java Code Geeks
    Logo
    Register New Account
    Reset Password
    Compare items
    • Total (0)
    Compare