IIRF Online > Development > Database Design & Development > SQL Server > Microsoft SQL Server 2012 Certification Training Exam 70-461
Microsoft SQL Server 2012 Certification Training Exam 70-461 by Udemy
To Study And Pass The Microsoft 70-461 Exam and Gain Certification For MCSA or MCSE
Course Highlights
- To Study And Pass The Microsoft 70-461 Exam and Gain Certification For MCSA or MCSE
Skills you will learn!
Curriculum
7 Topics
Important - Download These First - Working Files
What To expect From This Course
Course Overview
Understanding Databases
Transact-SQL Basics
Microsoft SQL Certification
How To Access Your Working Files
8 Topics
SQL Server 2012 Evaluation
SQL Server 2012 Installation
Windows 8 Server 2012 Interface
Windows 7 Interface
SQL Server Sample Database
Attaching The Sample Database
Getting Help
Installing SQL Books Online
8 Topics
Management Studio Basics
Connecting To SQL Server
Customizing SSMS
Utilizing Diagrams
Saving Diagrams
Text And Graphical Tools
Using Sample Code Files
About the Semicolon
11 Topics
0401 What Are Objects?
0402 Understanding Tables
0403 Understanding Data Integrity
0404 Understanding Data Types
0405 Understanding Primary Keys
0406 Understanding Constraints
0407 Understanding NULL
0408 Understanding Views
0409 Understanding Stored Procedures
0410 Understanding Triggers
0411 Understanding Synonyms
7 Topics
0501 Creating A Table
0502 Graphical Table Creation
0503 Changing A Table
0504 Graphical Table Alterations
0505 Deleting A Table
0506 Graphical Table Deletion
0507 Creating A Primary Key
7 Topics
0601 Four Basic Queries
0602 Thinking In SQL
0603 Options And More Options
0604 Good Query Structure
0605 Comments
0606 The USE Command
0607 The GO Command
7 Topics
0701 SELECT Basics
0702 SELECT Structure
0703 Using WHERE
0704 Using TOP To Limit Rows
0705 Ordering Results
0706 Working With NULLs
0707 T-SQL Concatenation
17 Topics
0801 Column Aliasing
0802 Using DISTINCT
0803 Using SUM
0804 Using AVG
0805 Using COUNT
0806 Using Group By
0807 Using HAVING
0808 SELECT INTO
0809 Using LIKE And IN
0810 Understanding UNION
0811 INTERSECT And EXCEPT
0812 Using Synonyms - Part 1
0813 Using Synonyms - Part 2
0814 Offset-Fetch
0815 What Is Ranking?
0816 Using Ranking
0817 More Ranking Examples
7 Topics
0901 Understanding Joins
0902 Join Query Structure
0903 Creating Inner Joins - Part 1
0904 Creating Inner Joins - Part 2
0905 Join Creation Through GUI
0906 Creating Outer Joins
0907 Creating Cross Joins
8 Topics
1001 The INSERT Statement
1002 Using INSERT - Part 1
1003 Using INSERT - Part 2
1004 The UPDATE Statement
1005 Using UPDATE
1006 The DELETE Statement
1007 Using DELETE - Part 1
1008 Using DELETE - Part 2
5 Topics
1101 Understanding Subqueries
1102 Subquery Versus Join
1103 Creating A Scalar Subquery
1104 Creating A Multi-Valued Subquery
1105 Creating A Correlated Subquery
7 Topics
1201 Utilizing Memory
1202 What Is A Derived Table?
1203 Creating A Derived Table
1204 Table Variables - Part 1
1205 Table Variables - Part 2
1206 Common Table Expressions
1207 Temporary Tables
21 Topics
1301 Programmability In T-SQL
1302 What Is A Stored Procedure?
1303 Why Use Stored Procedures?
1304 A Simple Stored Procedure
1305 Input Parameters
1306 Multiple Input Parameters
1307 Output Parameters - Part 1
1308 Output Parameters - Part 2
1309 Using Case Logic - Part 1
1310 Using Case Logic - Part 2
1311 Handling Errors
1312 Stored Procedure Security
1313 Working With Functions
1314 Using Built-In Functions
1315 Creating A Scalar Function
1316 Creating A Table Valued Function
1317 What Is Dynamic SQL?
1318 Dynamic SQL Example
1319 Understanding GUIDs
1320 GUID Examples - Part 1
1321 GUID Examples - Part 2
4 Topics
1401 Using Triggers
1402 Inserted And Deleted Tables
1403 Trigger Examples - Part 1
1404 Trigger Examples - Part 2
5 Topics
1501 What Are Transactions?
1502 Understanding Concurrency
1503 Explicit And Implicit Transactions
1504 Cross Platform Concerns
1505 Transaction And Locking Example
4 Topics
1601 Using Metadata
1602 Using Catalog Views
1603 Using Information Schema Views
1604 Using System Stored Procedures
5 Topics
1701 XML Basics
1702 Outputting XML From Queries
1703 Using FOR XML RAW
1704 Using FOR XML AUTO
1705 Using FOR XML PATH
6 Topics
1801 Optimization Basics
1802 Query Execution Plans - Part 1
1803 Query Execution Plans - Part 2
1804 SQL Server Extended Events - Part 1
1805 SQL Server Extended Events - Part 2
1806 SQL Server Profiler
3 Topics
1901 Exam Basics
1902 Taking Your Exam
1903 When It Is Over
1 Topic
2001 Wrap-Up
Microsoft SQL Server 2012 Certification Training Exam 70-461
Related SQL Server Courses
Thank You!
Your review has been submitted successfully.