70-461 Session 3: Querying Microsoft SQL Server 2012 (T-SQL)

70-461 Session 3: Querying Microsoft SQL Server 2012 (T-SQL)

70-461 Session 3: Querying Microsoft SQL Server 2012 (T-SQL). With the help of this course you can Using T-SQL code in SSMS, add constraints, store queries in views, add triggers. SQL Server 2012, 2014, 2016 (70-761).

This course was created by Phillip Burton. It was rated 4.2 out of 5 by approx 10925 ratings. There are approx 10465 users enrolled with this course, so don’t wait to download yours now. This course also includes 3.5 hours on-demand video, 2 Articles, 1 Supplemental Resource, Full lifetime access, Access on mobile and TV & Certificate of Completion.

What Will You 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”

This course is the foundation for the Microsoft Certificate 70-461: “Querying Microsoft SQL Server 2012”.

In Session 1, we learned all about dates, strings and number data types, and in Session 2 we constructed SELECT queries using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY, and JOINing multiple tables together.

We’ll now use that data to create views, which enable us to store these SELECT queries for future use, and triggers, which allow for code to be automatically run when INSERTing, DELETEing or UPDATEing data.

We’ll look at the database that we developed in session 2, and see what is wrong with it. We’ll add some constraints, such as UNIQUE, CHECK, PRIMARY KEY and FOREIGN KEY constraints, to stop erroneous data from being added some data. By doing this, we will complete objectives 2, 3, 4 and 5 from the 70-461 exam.

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.

Rating:
4.3

Download Links

Get Download Link

Related Courses

Microsoft 70-464 Developing Microsoft SQL Server 2012 Da…

Querying Microsoft SQL Server Databases using T-SQL

Administering Microsoft SQL Server 2012 Databases – 70-462

Microsoft 70-462: Administering SQL Server 2012 Databases

Microsoft SQL Server 2012 Certification Training Exam 70-462

Microsoft SQL Server 2012 Certification Training Exam 70-463

Writing Advanced SQL Queries on Microsoft SQL Server

SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Sub Query Magic: Write T-SQL Subqueries Using SQL Server

T-SQL For Beginners: Learn to Query SQL Server Databases

70-461 Session 5: Querying Microsoft SQL Server 2012 (T-SQL)

70-461 Session 5: Querying Microsoft SQL Server 2012 (T-SQL)

70-461 Session 4: Querying Microsoft SQL Server 2012 (T-SQL)

70-461 Session 4: Querying Microsoft SQL Server 2012 (T-SQL)

70-461 Session 7: Querying Microsoft SQL Server (T-SQL)

70-461 Session 7: Querying Microsoft SQL Server (T-SQL)

70-461 Session 2: Querying Microsoft SQL Server (T-SQL)

70-461 Session 2: Querying Microsoft SQL Server (T-SQL)

70-461 Session 6: Querying Microsoft SQL Server (T-SQL)

70-461 Session 6: Querying Microsoft SQL Server (T-SQL)

70-461 Session 1: Querying Microsoft SQL Server ’12-16 T-SQL

70-461 Session 1: Querying Microsoft SQL Server ’12-16 T-SQL

Microsoft 70-461: Querying SQL Server 2012

Microsoft 70-461: Querying SQL Server 2012

Querying Microsoft SQL Server 2012 – (Exam No. 70-461)

Querying Microsoft SQL Server 2012 – (Exam No. 70-461)

Microsoft MCSA 70-461 Querying Microsoft SQL Server Test

Microsoft MCSA 70-461 Querying Microsoft SQL Server Test

Microsoft SQL Server 2012 Certification Training Exam 70-461

Microsoft SQL Server 2012 Certification Training Exam 70-461
Go To Top