SQL Server 101 podcast Podcast

SQL Server 101 podcast

Phillip Burton, SQLServer101.com

Welcome to SQL Server 101. I'm Phillip Burton from sqlserver101.com. This podcast is an audio version of the video courses that I created for Microsoft SQL Server. They aim to get you from beginner level to that needed for the 70-461 certification, and beyond. Learn the skills that could you need to get your next dream job. The 70-461 certification, called "Querying Microsoft SQL Server", is intended for SQL Server database administrators, system engineers and developers with two or more years of experience, who are seeking to validate their skills and knowledge in writing queries. In my courses, I teach the content which is examined in this certification, and in other aspects of SQL Server.

Episode 030: T-SQL Session 4

Episode 030: T-SQL Session 4

Topics in this episode: CASE, ISNULL and Coalesce.

Aug 12, 2020

30 min

Episode 029: T-SQL Session 4

Episode 029: T-SQL Session 4

Topics in this episode: UNION and UNION ALL, and Intersect and Except.

Jul 29, 2020

26 min

Episode 028: T-SQL Session 3

Episode 028: T-SQL Session 3

Topics in this episode: Update functions, Handling multiple rows in a sesson, and Create and alter DML triggers - summary.

Jul 15, 2020

21 min

Episode 027: T-SQL Session 3

Episode 027: T-SQL Session 3

Topics in this episode: Creating an INSTEAD OF trigger, and Nested triggers.

Jul 1, 2020

24 min

Episode 026: T-SQL Session 3

Episode 026: T-SQL Session 3

Topics in this episode: Creating an indexed view, What are triggers?, and Creating an AFTER trigger.

Jun 17, 2020

22 min

Episode 025: T-SQL Session 3

Episode 025: T-SQL Session 3

Topics in this episode: Adding new rows in views, Deleting rows, and Indexed views.

Jun 3, 2020

22 min

Episode 024: T-SQL Session 3

Episode 024: T-SQL Session 3

Topics in this episode: Altering and dropping views, Securing views, Security.

May 20, 2020

22 min

Episode 023: T-SQL Session 3

Episode 023: T-SQL Session 3

Topics in this episode: Foreign key in practice, Summary of constraints, and Creating views.

May 6, 2020

26 min

Episode 022: T-SQL Session 3

Episode 022: T-SQL Session 3

Topics in this episode: Primary key in practice, and Foreign key theory.

Apr 22, 2020

23 min

Episode 021: T-SQL Session 3

Episode 021: T-SQL Session 3

Topics in this episode: Check constraints, and Primary key in theory.

Apr 15, 2020

23 min

Load more