Course Description

  • What is this course about?

    Microsoft SQL Server 2012 is the latest version of Microsoft SQL Server, the extremely popular and widely used database system in the world. Simplilearn’s Querying Microsoft SQL Server 2012 course introduces you to building and using databases in this platform.

    The course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. This course is the foundation for all SQL Server-related disciplines, including Database Administration, Database Development, and Business Intelligence. This course will help you prepare for exam 70-461, known as Querying Microsoft SQL Server 2012.

  • Why is this exam popular?

    SQL Server 2012 is a powerful platform that is widely used in the enterprise and cloud. Many critical systems are based on it. Exam 70-461 is the first step in a series of certifications that can make you a master of this platform.

  • What learning benefits do you get from Simplilearn’s training?

    Simplilearn’s training provides you the knowledge and skills to:
    • Create Database Objects
    • Work with Data
    • Modify Data
    • Troubleshoot & Optimize
    The course will equip you to create and manage databases in SQL Server 2012. You will also learn about the different database objects such as tables, columns, keys and others. You will see how they work together to provide a well-defined structure to store data.

    The course will also explain in detail about the different ways you can query for data already stored in the database as well as methods to add new data, update existing data and delete unwanted ones.

    Simplilearn’s training breaks up the course material into 10 easy-to-follow modules that cover the course-level objectives. Further, demos are provided for all the major concepts covered in a lesson so that participants understand how the steps learned are implemented in real time.

  • What are the career benefits in-store for you?

    Passing the Querying Microsoft SQL Server 2012 (70-461) exam is a requirement to getting MCSA certified, which in turn is a prerequisite to achieving an MCSE certification.

    In high-growth industries, entry-level employees with a Microsoft Certified Solutions Associate (MCSA) certification can annually earn up to $16,000 more than their non-certified peers.

    Better job opportunities also await them.

  • Why Simplilearn?

    • Simplilearn is the World’s Largest Certification Training Provider, with over 500,000+ professionals trained globally
    • Trusted by the Fortune 500 companies as their learning provider for career growth and training
    • 2000+ certified and experienced trainers conduct trainings for various courses across the globe
    • All our Courses are designed and developed under a tried and tested Unique Learning Framework that is proven to deliver 98.6% pass rate in first attempt
    • Accredited, Approved and Recognized as a training organization, partner, education provider and examination center by globally renowned names like Project Management Institute of USA, APMG, CFA Institute, GARP, ASTQB, IIBA and others

Course Preview

    • Lesson 01 - Introduction to SQL Server 2012

      31:00
      • 1.1 Introduction to SQL Server 2012
        00:22
      • 1.2 Objectives
        00:36
      • 1.3 RDBMS—An Introduction
        00:18
      • 1.4 RDBMS
        02:53
      • 1.5 SQL Server
        01:19
      • 1.6 SQL Server 2012
        00:19
      • 1.7 SQL Server 2012 Editions
        03:11
      • 1.8 SQL Server Components
        01:59
      • 1.9 SQL Server Tools
        02:13
      • 1.10 SQL Server Management Studio—An Introduction
        00:24
      • 1.11 SQL Server Management Studio
        01:26
      • 1.12 Managing Databases
        01:40
      • 1.13 SSMS Windows
        03:24
      • 1.14 Exploring SSMS
        00:11
      • 1.15 Exploring SSMS Demo 01
        02:13
      • 1.16 Understanding Database Objects
        00:15
      • 1.17 Database Storage
        01:40
      • 1.18 Databases Objects
        01:24
      • 1.19 Creating Database Objects Using SSMS
        00:10
      • 1.20 Creating Database Objects Using SSMS Demo 02
        03:21
      • 1.21 Quiz
      • 1.22 Summary
        00:46
      • 1.23 Summary (contd.)
        00:45
      • 1.24 Conclusion
        00:11
    • Lesson 02 - Working with T-SQL

      1:02:45
      • 2.1 Working with T-SQL
        00:23
      • 2.2 Objectives
        00:34
      • 2.3 Database Structures
        00:13
      • 2.4 Tables
        01:41
      • 2.5 Columns
        03:30
      • 2.6 Rows
        01:37
      • 2.7 Keys
        00:45
      • 2.8 Viewing a Table Structure
        00:10
      • 2.9 Viewing a Table Structure Demo 01
        02:01
      • 2.10 Introduction to Querying
        00:14
      • 2.11 Structured Query Language
        01:28
      • 2.12 T-SQL
        00:40
      • 2.13 T-SQL Statements
        01:30
      • 2.14 Statement Parsing
        00:47
      • 2.15 Writing a Simple Query
        00:10
      • 2.16 Writing a Simple Query Demo 02
        00:56
      • 2.17 Managing Database Objects
        00:13
      • 2.18 CREATE
        01:25
      • 2.19 ALTER
        00:42
      • 2.20 DROP
        00:51
      • 2.21 Add, Modify, and Delete Database Objects
        03:32
      • 2.22 Add, Modify, and Delete Database Objects Demo 03
        03:38
      • 2.23 Constraints
        00:12
      • 2.24 What Are Constraints
        01:05
      • 2.25 NOT NULL
        01:02
      • 2.26 DEFAULT
        01:15
      • 2.27 UNIQUE
        00:54
      • 2.28 PRIMARY KEY
        01:10
      • 2.29 FOREIGN KEY Constraint
        01:44
      • 2.30 FOREIGN KEY Relationships
        01:41
      • 2.31 Table Level Constraints
        00:30
      • 2.32 Adding Constraints
        00:11
      • 2.33 Adding Constraints Demo 04
        08:01
      • 2.34 Introduction to SELECT
        00:13
      • 2.35 SELECT Statement
        00:57
      • 2.36 Column List
        00:47
      • 2.37 Column Alias
        00:58
      • 2.38 DISTINCT Clause
        00:56
      • 2.39 Querying Data from Tables
        03:06
      • 2.40 Querying Data from Tables Demo 05
        03:14
      • 2.41 Advanced Use of SELECT
        00:08
      • 2.42 Using CASE
        01:37
      • 2.43 Searched CASE
        01:37
      • 2.44 Advanced Queries
        00:36
      • 2.45 Advanced Queries Demo 06
        02:01
      • 2.46 Quiz
      • 2.47 Summary
        00:53
      • 2.48 Summary (contd.)
        00:44
      • 2.49 Conclusion
        00:13
    • Lesson 03 - Understanding SQL Data Types

      42:36
      • 3.1 Understanding SQL Data Types
        00:21
      • 3.2 Objectives
        00:35
      • 3.3 Introduction to SQL Data Types
        00:08
      • 3.4 SQL Data Types
        02:39
      • 3.5 Categories of Types
        01:02
      • 3.6 String Types
        00:13
      • 3.7 String Data Types—Character Strings
        02:11
      • 3.8 String Data Types—UNICODE Character Strings
        01:32
      • 3.9 String Data Types—Binary Strings
        00:46
      • 3.10 MAX Setting
        00:36
      • 3.11 Collation
        03:22
      • 3.12 Using Character, Unicode, and Binary Strings
        00:12
      • 3.13 Using Character, Unicode, and Binary Strings Demo 01
        04:14
      • 3.14 Numeric Types
        00:17
      • 3.15 Numeric Types—Exact
        02:24
      • 3.16 Numeric Types—Approximate
        00:29
      • 3.17 Working with Numeric Data
        00:10
      • 3.18 Working with Numeric Data Demo 02
        01:47
      • 3.19 Date and Time
        00:11
      • 3.20 Data Types for Storing Date
        00:56
      • 3.21 Data Types for Storing Time
        01:23
      • 3.22 Changing the Date Format
        01:19
      • 3.23 Working with Date and Time
        00:15
      • 3.24 Working with Dates and Times Demo 03
        03:18
      • 3.25 Advanced Data Types
        00:14
      • 3.26 Understanding Advanced Data Types
        03:55
      • 3.27 XML Data Types
        01:45
      • 3.28 Exploring Some Advanced Data Types
        00:09
      • 3.29 Exploring Some Advanced Data Types Demo 04
        05:20
      • 3.30 Quiz
      • 3.31 Summary
        00:43
      • 3.32 Conclusion
        00:10
    • Lesson 04 - Sorting and Filtering

      38:09
      • 4.1 Sorting and Filtering
        00:21
      • 4.2 Objectives
        00:22
      • 4.3 Sorting Results
        00:12
      • 4.4 Sort Order for SELECT
        01:26
      • 4.5 ORDER BY Clause
        01:20
      • 4.6 Multiple Columns and Direction of Sort
        02:14
      • 4.7 Sorting with ORDER BY, and Performing Multiple Column and Ascending - Descending Sorts
        00:18
      • 4.8 Sorting with ORDER BY, and Performing Multiple Column and Ascending - Descending Sorts Demo 01
        02:35
      • 4.9 Extended Capabilities for Sorting
        00:11
      • 4.10 TOP Clause
        01:48
      • 4.11 OFFSET Clause
        01:55
      • 4.12 FETCH Parameter
        02:47
      • 4.13 Using TOP, OFFSET, and FETCH
        00:11
      • 4.14 Using TOP, OFFSET, and FETCH Demo 02
        02:50
      • 4.15 Filtering Results
        00:18
      • 4.16 The WHERE Clause
        01:39
      • 4.17 Logical Operators
        01:59
      • 4.18 Predicates
        01:27
      • 4.19 Predicate Operators
        02:51
      • 4.20 Filter Using WHERE, and Different Predicates and Operators
        00:10
      • 4.21 Filter Using WHERE, and Different Predicates and Operators Demo 03
        03:55
      • 4.22 Advanced Filtering
        00:12
      • 4.23 Using Unicode in Filters
        00:57
      • 4.24 ANY Clause
        01:21
      • 4.25 ALL Clause
        01:00
      • 4.26 Unicode, ANY, and ALL Filters
        00:11
      • 4.27 Unicode, ANY, and ALL filters Demo 04
        02:03
      • 4.28 Quiz
      • 4.29 Summary
        00:41
      • 4.30 Summary (contd.)
        00:43
      • 4.31 Conclusion
        00:12
    • Lesson 05 - Query Multiple Tables using JOINs

      31:45
      • 5.1 Query Multiple Tables Using JOINs
        00:21
      • 5.2 Objectives
        00:26
      • 5.3 Working with Multiple Tables
        00:12
      • 5.4 Normalization
        02:25
      • 5.5 Multiple Tables
        02:51
      • 5.6 Combining Tables in a Query
        00:49
      • 5.7 Querying Multiple Tables without a JOIN
        00:10
      • 5.8 Querying Multiple Tables without a JOIN Demo 01
        02:31
      • 5.9 Using JOIN
        00:18
      • 5.10 Understanding JOIN
        01:49
      • 5.11 Simple Join
        00:52
      • 5.12 Using Implicit Join between Tables
        00:15
      • 5.13 Using Implicit Join between Tables Demo 02
        01:43
      • 5.14 Introduction to JOINs
        00:13
      • 5.15 CROSS JOIN
        00:53
      • 5.16 INNER JOIN
        01:42
      • 5.17 INNER JOIN (contd.)
        01:12
      • 5.18 OUTER JOIN
        01:23
      • 5.19 LEFT OUTER JOIN
        00:56
      • 5.20 RIGHT OUTER JOIN
        00:46
      • 5.21 FULL OUTER JOIN
        00:41
      • 5.22 Using CROSS, INNER, and OUTER JOINs
        00:11
      • 5.23 Using CROSS, INNER, and OUTER JOINs Demo 03
        03:32
      • 5.24 Advanced JOINs
        00:10
      • 5.25 Advanced JOINs
        01:05
      • 5.26 MERGE Hint
        01:10
      • 5.27 HASH Hint
        00:34
      • 5.28 LOOP Hint
        00:27
      • 5.29 Using MERGE, HASH, and LOOP
        00:11
      • 5.30 Using MERGE, HASH, and LOOP Demo 04
        00:54
      • 5.31 Quiz
      • 5.32 Summary
        00:53
      • 5.33 Conclusion
        00:10
    • Lesson 06 - Modifying Table Data

      46:43
      • 6.1 Modifying Table Data
        00:23
      • 6.2 Objectives
        00:38
      • 6.3 Adding Data to a Table
        00:16
      • 6.4 INSERT Statement
        02:00
      • 6.5 Using a Column List in INSERT
        01:51
      • 6.6 Adding Multiple Rows
        00:58
      • 6.7 Using Different Forms of INSERT to Add Data to a Table
        00:11
      • 6.8 Using Different Forms of INSERT to Add Data to a Table Demo 01
        04:27
      • 6.9 Other Methods to Add Data
        00:17
      • 6.10 Inserting Data in Bulk
        00:47
      • 6.11 Using SELECT
        01:44
      • 6.12 SELECT INTO
        01:10
      • 6.13 BULK INSERT
        01:09
      • 6.14 Using Bulk Adding Methods
        00:13
      • 6.15 Using Bulk Adding Methods Demo 02
        05:50
      • 6.16 Modifying Data in a Table
        00:12
      • 6.17 Using the UPDATE Statement
        01:06
      • 6.18 Specifying Records to UPDATE
        01:23
      • 6.19 Modifying Data with UPDATE
        00:15
      • 6.20 Modifying Data with UPDATE Demo 03
        01:37
      • 6.21 Removing Data from Tables
        00:18
      • 6.22 DELETE Statement
        01:12
      • 6.23 TRUNCATE
        02:56
      • 6.24 DELETE and TRUNCATE Data from Tables
        00:12
      • 6.25 DELETE and TRUNCATE Data from Tables Demo 04
        03:38
      • 6.26 Synchronizing Data between Tables
        00:22
      • 6.27 Data Synchronization
        02:22
      • 6.28 MERGE Statement
        01:53
      • 6.29 Synchronizing Data using MERGE
        00:13
      • 6.30 Synchronizing Data using MERGE Demo 05
        05:57
      • 6.31 Quiz
      • 6.32 Summary
        01:02
      • 6.33 Conclusion
        00:11
    • Lesson 07 - Programming in SQL Server

      1:00:34
      • 7.1 Programming in SQL Server
        00:21
      • 7.2 Objectives
        00:26
      • 7.3 Work with Functions
        00:18
      • 7.4 SQL Server Functions
        02:25
      • 7.5 Function Categories
        01:51
      • 7.6 String Functions
        01:59
      • 7.7 Conversion Functions
        02:19
      • 7.8 Logical Functions
        01:05
      • 7.9 Numeric Functions
        00:38
      • 7.10 Date and Time Functions
        01:44
      • 7.11 Using Different Functions in SQL Server
        00:17
      • 7.12 Using Different Functions in SQL Server Demo 01
        05:01
      • 7.13 Working with Groups and Aggregates
        00:16
      • 7.14 Grouping Data
        02:17
      • 7.15 Aggregate Functions
        02:10
      • 7.16 Grouping and Using Different Aggregates
        00:11
      • 7.17 Grouping and Using Different Aggregates Demo 02
        02:20
      • 7.18 Variables and Batches
        00:12
      • 7.19 What Are Variables
        01:27
      • 7.20 Using Variables
        01:48
      • 7.21 Using SELECT to Set Variable Value
        01:03
      • 7.22 Using Batches
        01:25
      • 7.23 Using Variables and Batches
        00:11
      • 7.24 Using Variables and Batches Demo 03
        03:00
      • 7.25 Control Flow Statements
        00:12
      • 7.26 What Are Control Flow Statements
        00:58
      • 7.27 GOTO
        02:18
      • 7.28 Containers
        00:30
      • 7.29 IF Statement
        01:12
      • 7.30 WHILE Statement
        00:51
      • 7.31 Using Control Flow Statements
        00:15
      • 7.32 Using Control Flow Statements Demo 04
        05:08
      • 7.33 Working with Stored Procedures
        00:17
      • 7.34 Stored Procedures
        02:04
      • 7.35 Creating a New Stored procedure
        01:47
      • 7.36 Parameters
        01:25
      • 7.37 Error Handling
        01:37
      • 7.38 Working with Stored Procedures
        00:13
      • 7.39 Working with Stored Procedures Demo 05
        06:11
      • 7.40 Quiz
      • 7.41 Summary
        00:40
      • 7.42 Conclusion
        00:12
    • Lesson 08 - Writing Advanced Queries in T-SQL

      37:48
      • 8.1 Writing Advanced Queries in T-SQL
        00:21
      • 8.2 Objectives
        00:25
      • 8.3 Subqueries
        00:11
      • 8.4 What Is a Subquery
        01:31
      • 8.5 Self-Contained Subquery
        00:53
      • 8.6 Multi-Value Subquery
        01:21
      • 8.7 Correlated Subquery
        00:59
      • 8.8 EXISTS Subquery
        00:30
      • 8.9 Using Subqueries
        00:10
      • 8.10 Using Subqueries Demo 01
        02:50
      • 8.11 Table Expressions
        00:11
      • 8.12 What Are Table Expressions
        01:03
      • 8.13 Derived Tables
        01:00
      • 8.14 Using WITH for Common Table Expressions
        01:14
      • 8.15 Table Valued Functions
        01:22
      • 8.16 Using Table Valued Expressions
        00:11
      • 8.17 Using Table Valued Expressions Demo 02
        03:59
      • 8.18 Set and Conditional Operators
        00:18
      • 8.19 Set Operators
        01:35
      • 8.20 UNION
        00:37
      • 8.21 UNION ALL
        00:31
      • 8.22 INTERSECT
        00:33
      • 8.23 EXCEPT
        00:30
      • 8.24 Conditional Operators
        00:45
      • 8.25 Using Different Set Operators
        00:11
      • 8.26 Using Different Set Operators Demo 03
        02:02
      • 8.27 Window Functions
        00:14
      • 8.28 What are Window Functions
        01:26
      • 8.29 Window Functions List
        01:53
      • 8.30 Using Window Functions
        00:11
      • 8.31 Using Window Functions Demo 04
        03:01
      • 8.32 Creating User-Defined Functions
        00:10
      • 8.33 User-Defined Functions
        01:28
      • 8.34 Create and Use UDF
        00:11
      • 8.35 Create and Use UDF Demo 05
        02:52
      • 8.36 Quiz
      • 8.37 Summary
        00:57
      • 8.38 Conclusion
        00:12
    • Lesson 09 - Data Manipulation

      24:56
      • 9.1 Data Manipulation
        00:23
      • 9.2 Objectives
        00:16
      • 9.3 PIVOT and UNPIVOT Operators
        00:09
      • 9.4 PIVOT Operator
        01:57
      • 9.5 PIVOT Example with Explanation
        01:05
      • 9.6 UNPIVOT Operator
        00:24
      • 9.7 Using PIVOT to Analyze Data
        00:10
      • 9.8 Using PIVOT to Analyze Data Demo 01
        03:48
      • 9.9 Grouping Sets
        00:13
      • 9.10 GROUP BY
        01:18
      • 9.11 GROUPING SETS Clause
        00:50
      • 9.12 GROUP BY CUBE
        00:55
      • 9.13 GROUP BY ROLLUP
        00:44
      • 9.14 Grouping Sets
        00:09
      • 9.15 Grouping Sets Demo 02
        03:36
      • 9.16 Handling Transactions
        00:11
      • 9.17 Transactions
        01:09
      • 9.18 Explicit Transaction
        01:42
      • 9.19 Implicit Transaction
        01:09
      • 9.20 Using Transactions
        00:10
      • 9.21 Using Transactions Demo 03
        03:46
      • 9.22 Quiz
      • 9.23 Summary
        00:43
      • 9.24 Conclusion
        00:09
    • Lesson 10 - Advanced Querying

      30:38
      • 10.1 Advanced Querying
        00:26
      • 10.2 Objectives
        00:23
      • 10.3 System Databases
        00:11
      • 10.4 What Are System Databases
        01:41
      • 10.5 Master Database
        01:01
      • 10.6 Model Database
        01:13
      • 10.7 TempDB Database
        01:21
      • 10.8 MSDB Database
        01:14
      • 10.9 System Stored Procedures
        00:11
      • 10.10 What Are System Stored Procedures
        00:54
      • 10.11 System Stored Procedure Categories
        01:53
      • 10.12 Work with System Stored Procedures
        00:07
      • 10.13 Work with System Stored Procedures Demo 01
        01:37
      • 10.14 Query Plans
        00:12
      • 10.15 Query Execution
        01:03
      • 10.16 Plan Guide and Hints
        01:25
      • 10.17 Viewing Query Plans
        00:06
      • 10.18 Viewing Query Plans Demo 02
        02:17
      • 10.19 Manage Indexes
        00:14
      • 10.20 Indexes
        01:47
      • 10.21 Index Types
        01:20
      • 10.22 Manage Views
        00:09
      • 10.23 Views
        01:05
      • 10.24 Using Indexes and Views
        00:11
      • 10.25 Using Indexes and Views Demo 03
        02:50
      • 10.26 Windows Azure SQL Database
        00:15
      • 10.27 What Is Windows Azure SQL Database
        00:55
      • 10.28 Overview of Windows Azure SQL Database
        00:10
      • 10.29 Overview of Windows Azure SQL Database Demo 04
        03:21
      • 10.30 Quiz
      • 10.31 Summary
        00:38
      • 10.32 Summary (contd.)
        00:19
      • 10.33 Conclusion
        00:09
    • {{childObj.title}}

      • {{childObj.childSection.chapter_name}}

        • {{lesson.title}}
      • {{lesson.title}}

    View More

    View Less

Exam & Certification

  • What are the eligibility requirements to take the 70-461 exam?

    There are no eligibility requirements to take up this course. Register at the Microsoft website and select your exam to schedule with Pearson VUE.

  • Who should take this exam?

    This exam is intended for SQL Server database administrators, system engineers, database developers, and business intelligence professionals with two or more years of experience. Through this exam, they can validate their skills and knowledge in writing queries.

Reviews

Manish Temkar
Manish Temkar

Good one fr quick starters.

Bridget Ochoa
Bridget Ochoa

This online course helps SQL Server users to authenticate their knowledge and skills and optimize the use of SQL Server 2012 to the fullest.

Read more Read less
Annika Cabrera
Annika Cabrera

This online course is very useful in terms of wide coverage of SQL Server 2012 topics and examples. It is well designed and delivered.

    FAQs

    • How do I enroll for the Online training?

      You can enroll for the training online. Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.

      1. Visa debit/credit card
      2. American express and Diners club card
      3. Master Card, or
      4. Through PayPal

    • What will I get along with this training?

      You will have access to the online e-learning and practice tests along with the training.

    • Can I cancel my enrollment? Do I get a refund?

      Yes, you can cancel your enrollment. We provide you complete refund after deducting the administration fee. To know more please go through our Refund Policy.

    • Do you provide any course completion certificate?

      Yes, we offer course completion certificate after you successfully complete the training program.

    • Where and how can I access the e-learning content? Are there any limitations?

      Once you register with us for a course by paying the course fee, you can have 24/7 access to the e-learning content on our website. An automated course purchase confirmation mail from our side will guide you through the process.

    • I am not able to access the online course. Whom should I contact for a solution?

      Please raise a request via our Help and Support portal to have your issue resolved.

    • Do you provide money back guarantee for the training programs?

      Yes. We do offer a money-back guarantee for many of our training programs. You can refer to the Refund Policy and raise refund requests via our Help and Support portal.

    • Do you provide any course completion certificate?

      Yes, we offer course completion certificate after you successfully complete the training program.

    • I want to know more about the training program. Whom do I contact?

      Please join our Live Chat for instant support, call us, or Request a Call Back to have your query resolved.

    • Disclaimer
    • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.