70-461 Session 4: Querying Microsoft SQL Server (T-SQL)
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Using TSQL, merge databasets together, create procedures & incorporate error handling. SQL Server 2012-2017, inc. 70-761Description
If you are in UfB, welcome.
If you are not, don't buy this course. Instead, please look at my 70-461 Session 1-7: Querying Microsoft SQL Server (SQL code) course instead, which includes this course and 6 other courses.
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, JOINed multiple tables together and used DML commands, and in Session 3 we created views, constraints and triggers to encapsulate language and improve security.
We will further encapsulate our routines by creating procedures, allowing us to EXECUTE parameterised commands with just one statement, and we'll add some error handling with TRY, CATCH and THROW.
We'll also combine datasets together, by looking at UNION and UNION ALL, INTERSECT and EXCEPT, CASE, ISNULL and Coalesce, and the mighty MERGE statement. By doing this, we will complete objectives 11, 12, 13 and parts of 6 and 18 from the 70-461 exam.
No prior knowledge other than what we covered in Sessions 1 to 3 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 procedures, add error handling, and combine datasets together, and we'll have expanded on our current knowledge of T-SQL.
Requirements
- Requirements
- You need to know all about data types and functions.
- You also need to know about how to create SELECT statements and INSERT, DELETE and UPDATE statements.
- It would be helpful if you knew about views, triggers and triggers
- If you don't, then please take my Sessions 1-3 courses first.
- There is a 30-day money back guarantee of this Udemy course.
- Why not have a look at the curriculum below and see what you can learn?
Microsoft SQL Server 2012 Certification Training Exam 70-461
- 4.5
-
![]()
![]()
![]()
![]()
![]()
To Study And Pass The Microsoft 70-461 Exam and Gain Certification For MCSA or MCSE You will learn about SELECT statements, how to modify data, and use joins and subqueries....
70-461 Session 3: Querying Microsoft SQL Server (T-SQL)
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Using T-SQL in SSMS, add constraints, store queries in views, add triggers. SQL Server 2012, 2014, 2016, 2017 (70-761) If you are in UfB, welcome....
70-461 Session 4: Querying Microsoft SQL Server (T-SQL)
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Using TSQL, merge databasets together, create procedures & incorporate error handling. SQL Server 2012-2017, inc. 70-761 If you are in UfB, welcome....
70-461 Session 5: Querying Microsoft SQL Server (write SQL)
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Using SQL, create analytical functions, grouping sets, ranking functions, spatial aggregates. SQL Server 12-17 (70-761) If you are in UfB, welcome....
