SQL Server 101 podcast

Share on

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…

Phillip Burton, SQLServer101.com

Aug 12, 2020 LATEST EPISODE
every other week NEW EPISODES
25m AVG DURATION
30 EPISODES

Search for episodes from SQL Server 101 podcast with a specific topic:

All Episodes

Latest episodes from SQL Server 101 podcast

Episode 030: T-SQL Session 4

Play Episode Listen Later Aug 12, 2020 30:13

Topics in this episode: CASE, ISNULL and Coalesce.

coalesce

Episode 029: T-SQL Session 4

Play Episode Listen Later Jul 29, 2020 26:41

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

union intersect

Episode 028: T-SQL Session 3

Play Episode Listen Later Jul 15, 2020 21:20

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

dml

Episode 027: T-SQL Session 3

Play Episode Listen Later Jul 1, 2020 24:36

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

nested

Episode 026: T-SQL Session 3

Play Episode Listen Later Jun 17, 2020 22:35

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

Episode 025: T-SQL Session 3

Play Episode Listen Later Jun 3, 2020 22:30

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

deleting indexed

Episode 024: T-SQL Session 3

Play Episode Listen Later May 20, 2020 22:01

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

security securing altering

Episode 023: T-SQL Session 3

Play Episode Listen Later May 6, 2020 26:15

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

foreign

Episode 022: T-SQL Session 3

Play Episode Listen Later Apr 22, 2020 23:18

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

primary foreign sql server

Episode 021: T-SQL Session 3

Play Episode Listen Later Apr 15, 2020 23:20

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

primary

Episode 020: T-SQL Session 3

Play Episode Listen Later Apr 8, 2020 28:40

Topics in this episode: Unique constraints, and Default constraints.

unique default

Episode 019: T-SQL Session 3

Play Episode Listen Later Jan 13, 2019 25:05

Topics in this episode: Updating data Objectives of Session 3 Problems What are constraints?

updating objectives

Episode 018: T-SQL Session 2

Play Episode Listen Later Oct 3, 2018 21:14

Topics in this episode: Missing data; Deleting data

missing deleting

Episode 017: T-SQL Session 2

Play Episode Listen Later Sep 19, 2018 31:35

Topics in this episode: Creating a third table; JOINing three tables

Episode 016: T-SQL Session 2

Play Episode Listen Later Sep 5, 2018 24:13

Topics in this episode: Writing a JOIN queryl different types of JOIN

writing

Episode 015: T-SQL Session 2

Play Episode Listen Later Aug 22, 2018 25:27

Topics in this episode: Designing a connection; Importing data and showing tables graphically

designing importing

Episode 014: T-SQL Session 2

Play Episode Listen Later Aug 8, 2018 27:04

Topics in this episode: Exercise; Designing second table

exercise designing

Episode 013: T-SQL Session 2

Play Episode Listen Later Jul 25, 2018 29:41

Topics in this episode: WHERE and GROUPING; HAVING

grouping

Episode 012: T-SQL Session 2

Play Episode Listen Later Jul 11, 2018 23:35

Topics in this episode: WHERE queries

Episode 011: T-SQL Session 2

Play Episode Listen Later Jun 27, 2018 27:50

Topics in this episode: Creation of the Employee Table; Objectives for Session 2; Adding additional columns

objectives

Episode 010: T-SQL Session 1

Play Episode Listen Later Jun 13, 2018 30:44

Topics in this episode: More date functions; date offsets; converting from dates to strings

Episode 009: T-SQL Session 1

Play Episode Listen Later Jun 6, 2018 26:18

Topics in this episode: Joining a string to a number; Date data types; Setting dates and date extraction

Episode 008: T-SQL Session 1

Play Episode Listen Later Jun 3, 2018 23:51

Topics in this episode: NULL - an introduction; Joining two strings together

null

Episode 007: T-SQL Session 1

Play Episode Listen Later Jun 2, 2018 25:03

Topics in this episode: Strings and String Functions

strings

Episode 006: T-SQL Session 1

Play Episode Listen Later Jun 1, 2018 24:20

Topics in this episode: Mathematical functions; converting between number types

mathematical

Episode 005: T-SQL Session 1

Play Episode Listen Later May 31, 2018 25:37

Topics in this episode: Integer and non-integer numbers

integer

Episode 004: T-SQL Session 1

Play Episode Listen Later May 30, 2018 26:29

Topics in this episode: Retrieving data; deleting data and table; creating table and temporary variables.

retrieving

Episode 003: T-SQL Session 1

Play Episode Listen Later May 29, 2018 21:19

Topics in this episode: Creating our first queries; creating a table; entering data

Episode 002: T-SQL Session 1

Play Episode Listen Later May 28, 2018 20:43

Topics in this episode: Curriculum; Opening SQL Server; Looking at Management Studio; Create a database

curriculum management studio

Episode 001: T-SQL Session 1

Play Episode Listen Later May 18, 2018 37:57

Topics in this episode: Introduction; Installing SQL Server and Visual Studio

server sql visual studio t sql

Claim SQL Server 101 podcast

In order to claim this podcast we'll send an email to with a verification link. Simply click the link and you will be able to edit tags, request a refresh, and other features to take control of your podcast page!

Claim Cancel