Upgrading Your T-SQL Interview Skills

Focused View

Jared Westover

1:36:56

16 View

01. Course Overview

01. Course Overview.mp4

01:38

02. Landing a Data Role

02. Introduction.mp4

02:59

03. Importance of Data.mp4

03:45

04. Meeting Our Candidate.mp4

02:31

05. Course Structure.mp4

02:38

03. Exploring Role Expectations

06. Introduction.mp4

02:04

07. Defining a Data Analyst.mp4

03:18

08. Foundational T-SQL Skills.mp4

02:34

09. Where to Focus.mp4

01:37

10. Demo-Creating Our Environment.mp4

04:36

11. Demo-Stack Exchange Database.mp4

02:12

12. Summary.mp4

01:16

04. Evaluating Your Skills

13. Introduction.mp4

02:58

14. Examining a Select Statement.mp4

04:14

15. Combining Tables.mp4

03:41

16. Subqueries and Table Expressions.mp4

02:48

17. Demo-Reviewing Queries.mp4

02:39

18. Beyond the Basics.mp4

02:25

19. Demo-Beyond the Basics.mp4

03:37

20. Summary.mp4

01:35

05. Growing Your T-SQL Skills

21. Introduction.mp4

02:18

22. Remember Anything.mp4

03:16

23. Demo-Explore Anki.mp4

03:18

24. Facing T-SQL Challenges.mp4

02:40

25. Demo-Remove the Salespeople.mp4

03:39

26. Demo-Pivoting Data.mp4

03:31

27. Additional Resources.mp4

02:15

28. Summary.mp4

01:22

06. Testing Your T-SQL Skills

29. Introduction.mp4

02:07

30. Practice Makes Perfect.mp4

03:32

31. Sharpen Your Skills.mp4

03:24

32. Demo-Find the Missing Clause.mp4

03:34

33. Shine on Interview Day.mp4

03:27

34. Review Key Takeaways.mp4

03:28

Description

If you want to do well at an upcoming T-SQL interview, this course is for you! Take your interviewing skills to the next level and learn the ins and outs of T-SQL roles and expectations.

What You'll Learn?

For many, participating in the technical round of an interview can create a lot of anxiety. The experience might resemble a bad dream where you forgot to study for an exam. If you find yourself questioning your skills when applying for roles with a heavy focus on T-SQL, then this course will help!

In this course, Upgrading Your T-SQL Interview Skills, you'll learn how to prepare for the most challenging interview questions.

First, you'll explore the expectations of an entry-level data analyst and how an entry-level role differs from a senior one.

Next, you'll discover the value of knowing your strengths and weaknesses. Taking an honest look at your current skills makes improving possible.

Finally, you'll learn how to grow in weak areas. Focusing on your weaknesses can be uncomfortable, but doing so is a requirement of success.

When you're finished watching this course, you'll gain the skills and knowledge needed to shine at your upcoming T-SQL interview, and have increased confidence to spill over into other aspects of life.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

SQL Server

Oracle SQL

PostgreSQL

Jared Westover

Instructor's Courses

Jared Westover is a Microsoft Certified Solutions Expert in Data Management and Analytics. When he started his education, he didn’t consider any other field than computers. Jared has been working with technology for over 15 years. He focuses on SQL Server and finding ways to tell inspiring stories with raw data. Technology became his first love while working on a Tandy back in the ’80s. Undertaking an epic quest, Jared wanted nothing more than to design video games using C. Working with data gives Jared a chance to combine his passions for technology and creativity. Tracking data, whether steps taken or money spent, has become an obsession. He loves spending time with his wonderful wife Amanda and three children in his spare time. Jared enjoys lifting weights, along with a good Netflix binge.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.