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
Topics in this episode: CASE, ISNULL and Coalesce.
Aug 12, 2020
30 min
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
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
Topics in this episode: Creating an INSTEAD OF trigger, and Nested triggers.
Jul 1, 2020
24 min
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
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
Topics in this episode: Altering and dropping views, Securing views, Security.
May 20, 2020
22 min
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
Topics in this episode: Primary key in practice, and Foreign key theory.
Apr 22, 2020
23 min
Episode 021: T-SQL Session 3
Topics in this episode: Check constraints, and Primary key in theory.
Apr 15, 2020
23 min
Load more