Skip to content
Write a review
UdemySQLPaid courseIntermediate levelCertificate

70-461 Session 3: Querying Microsoft SQL Server (T-SQL code) (Udemy.com)

Using T-SQL in SSMS, add constraints, create views, add triggers. SQL Server 2012, 2014, 2016, 2017, 2019, 2022

4.8
1,094 reviews

Created by: Phillip Burton

Last updated January 2025

icon
What you will learn

  • identify structural problems in databases
  • create UNIQUE, CHECK, PRIMARY KEY, FOREIGN KEY constraints to more to stop erroneous data from being added.
  • create views, to allow for encapsulation of SELECT statements and provide higher security.
  • create triggers, to allow for code to be automatically run after or instead of a DML command.
  • complete objectives 2, 3, 4 and 5 and work towards other objectives from Microsoft Certification 70-461 "Querying Microsoft SQL Server 2012"

How it compares

Against the other 388 rated Udemy courses in SQL on CourseDuck:

  • Rating4.8 out of 5higher than 97% of them
  • Reviews1,094#138 of 389 by number of reviews
  • Length3.6 hoursshorter than 70% of them
  • Last updatedJanuary 2025more recently than 64% of them

icon
Course Description

This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012/2014". Please note - this certificate is no longer being offered by Microsoft. However, the exam requirements allow you to have a good understanding of T-SQL.

We'll start off by creating views, which enable us to store these SELECT queries for future use. We'll add security and create indexed views.

We'll then create AFTER and INSTEAD OF triggers, which allow for code to be automatically run when INSERTing, DELETEing or UPDATEing data. We'll look at what happens when triggers run triggers, and how to handle multiple rows in a session.

We'll look at the database that we previously developed, and see what is wrong with it. To solve these problems, we'll add some constraints, such as UNIQUE, CHECK, PRIMARY KEY and FOREIGN KEY constraints. This will stop erroneous data from being added some data.

No prior knowledge other than what we covered in Sessions 1 and 2 is required. However, prior experience with Excel or Access would be beneficial.

There are regular quizzes to help you remember the information.

Once finished, you will know what how to write triggers, views and constraints, and we'll have expanded on our current knowledge of T-SQL.
Read More Intermediate Intermediate Level product length iconTime: 3.6h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Phillip Burton

Hi. I'm Phillip, and I'm proud to Teach with Udemy as a Udemy Instructor Partner. I have been teaching on Udemy since 2015, and I have over 1,000,000 students and more than 60 video courses, including over a dozen Bestseller courses.

My courses include Microsoft Power BI and Fabric, Tableau, SQL Server, Power Platform (Power Apps, Power Automate, etc.), Azure, Microsoft Office, and more. The majority of my courses align with the requirements for official certifications from Microsoft, Oracle, and Tableau - so with a bit of practice, you could enter the exam or assessment and put it on your CV or resume.

I have been a Computing Consultant providing expert services in the development of computer systems and data analysis. I am one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards. My interests are working with data, including Microsoft Power BI, Excel, Access, SQL Server, and the Power Platform.

Read More

icon
More courses by Phillip Burton

$18.99

$22.99

$22.99

$99.99

$13.99

Free

All courses by Phillip Burton

icon
More SQL courses

$94.99

$16.99

$13.99

$10.99

$34.99

$64.99

All SQL courses

icon
Reviews

4.8

1,094 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Natalia Fedoriv on 8/12/2024

Everything is explained clearly and understandably. However, it's not for beginners. Additional knowledge is required to complete it. It is recommended to first complete Session 1 and 2

By Dan Direen on 9/27/2020

I found this course to be well presented and explained. Thank you!

By Chris Anderson on 9/7/2020

Useful course with lots of useful information

By Sreenivasa.s06@wipro.com on 8/26/2020

Nice course, explained it very well for a beginner to understand.

By Jason Prull on 8/21/2020

The content content covered a wide range of valuable data management tools for analysts. I would recommend this course for any basic users who are looking for guidance on how to reach that next level of competency. I will admit the pacing is a bit slow for me, so I viewed at speed 1.25x.

By Rohit Porwal on 8/21/2020

great

By Amey Janorkar on 7/15/2020

nice contents

By Manishankar Essakia Pillai on 6/17/2020

Nice course !!

By Gustavo Ruiz Rodriguez on 5/3/2020

Muy buen curso, me hizo recordar muchas sentencias de SQL.

By Winlet Kgaphola on 4/23/2020

so far the course makes sense especially the section that spoke about views

By Donna Vito on 4/20/2020

I enjoyed the course. The material was presented in a way I can understand. Thank you very much!

By Elizabeth Maria Rivero Alvarez on 4/9/2020

todo bien

Showing 12 of 58 reviews

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 96 / 100

70-461 Session 3: Querying Microsoft SQL Server (T-SQL code)
Visit course on Udemy Write a review
  • Video Duration: icon 3.6h
  • Price: $12.99
  • Provider: icon Udemy
  • Updated: icon January 2025
  • Level: Intermediate Intermediate
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com