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

Episode 023: T-SQL Session 3

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.

Technology

Tech News

Podcasting

Gadgets

Software How-To

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

Episode 029: T-SQL Session 4

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

Episode 028: T-SQL Session 3

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

Episode 027: T-SQL Session 3

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

Episode 025: T-SQL Session 3

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

Episode 023: T-SQL Session 3

Download our free app to listen on your phone