Explore our course

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

  • Querying SQL Server 2012 (Exam No. 70-461)
    • Lesson 01 - Introduction to SQL Server 2012 31:00
      • 1.1 Introduction to SQL Server 201200:22
      • 1.2 Objectives00:36
      • 1.3 RDBMS—An Introduction00:18
      • 1.4 RDBMS02:53
      • 1.5 SQL Server01:19
      • 1.6 SQL Server 201200:19
      • 1.7 SQL Server 2012 Editions03:11
      • 1.8 SQL Server Components01:59
      • 1.9 SQL Server Tools02:13
      • 1.10 SQL Server Management Studio—An Introduction00:24
      • 1.11 SQL Server Management Studio01:26
      • 1.12 Managing Databases01:40
      • 1.13 SSMS Windows03:24
      • 1.14 Exploring SSMS00:11
      • 1.15 Exploring SSMS Demo 0102:13
      • 1.16 Understanding Database Objects00:15
      • 1.17 Database Storage01:40
      • 1.18 Databases Objects01:24
      • 1.19 Creating Database Objects Using SSMS00:10
      • 1.20 Creating Database Objects Using SSMS Demo 0203:21
      • 1.21 Quiz
      • 1.22 Summary00:46
      • 1.23 Summary (contd.)00:45
      • 1.24 Conclusion00:11
    • Lesson 02 - Working with T-SQL 1:02:45
      • 2.1 Working with T-SQL00:23
      • 2.2 Objectives00:34
      • 2.3 Database Structures00:13
      • 2.4 Tables01:41
      • 2.5 Columns03:30
      • 2.6 Rows01:37
      • 2.7 Keys00:45
      • 2.8 Viewing a Table Structure00:10
      • 2.9 Viewing a Table Structure Demo 0102:01
      • 2.10 Introduction to Querying00:14
      • 2.11 Structured Query Language01:28
      • 2.12 T-SQL00:40
      • 2.13 T-SQL Statements01:30
      • 2.14 Statement Parsing00:47
      • 2.15 Writing a Simple Query00:10
      • 2.16 Writing a Simple Query Demo 0200:56
      • 2.17 Managing Database Objects00:13
      • 2.18 CREATE01:25
      • 2.19 ALTER00:42
      • 2.20 DROP00:51
      • 2.21 Add, Modify, and Delete Database Objects03:32
      • 2.22 Add, Modify, and Delete Database Objects Demo 0303:38
      • 2.23 Constraints00:12
      • 2.24 What Are Constraints01:05
      • 2.25 NOT NULL01:02
      • 2.26 DEFAULT01:15
      • 2.27 UNIQUE00:54
      • 2.28 PRIMARY KEY01:10
      • 2.29 FOREIGN KEY Constraint01:44
      • 2.30 FOREIGN KEY Relationships01:41
      • 2.31 Table Level Constraints00:30
      • 2.32 Adding Constraints00:11
      • 2.33 Adding Constraints Demo 0408:01
      • 2.34 Introduction to SELECT00:13
      • 2.35 SELECT Statement00:57
      • 2.36 Column List00:47
      • 2.37 Column Alias00:58
      • 2.38 DISTINCT Clause00:56
      • 2.39 Querying Data from Tables03:06
      • 2.40 Querying Data from Tables Demo 0503:14
      • 2.41 Advanced Use of SELECT00:08
      • 2.42 Using CASE01:37
      • 2.43 Searched CASE01:37
      • 2.44 Advanced Queries00:36
      • 2.45 Advanced Queries Demo 0602:01
      • 2.46 Quiz
      • 2.47 Summary00:53
      • 2.48 Summary (contd.)00:44
      • 2.49 Conclusion00:13
    • Lesson 03 - Understanding SQL Data Types 42:36
      • 3.1 Understanding SQL Data Types00:21
      • 3.2 Objectives00:35
      • 3.3 Introduction to SQL Data Types00:08
      • 3.4 SQL Data Types02:39
      • 3.5 Categories of Types01:02
      • 3.6 String Types00:13
      • 3.7 String Data Types—Character Strings02:11
      • 3.8 String Data Types—UNICODE Character Strings01:32
      • 3.9 String Data Types—Binary Strings00:46
      • 3.10 MAX Setting00:36
      • 3.11 Collation03:22
      • 3.12 Using Character, Unicode, and Binary Strings00:12
      • 3.13 Using Character, Unicode, and Binary Strings Demo 0104:14
      • 3.14 Numeric Types00:17
      • 3.15 Numeric Types—Exact02:24
      • 3.16 Numeric Types—Approximate00:29
      • 3.17 Working with Numeric Data00:10
      • 3.18 Working with Numeric Data Demo 0201:47
      • 3.19 Date and Time00:11
      • 3.20 Data Types for Storing Date00:56
      • 3.21 Data Types for Storing Time01:23
      • 3.22 Changing the Date Format01:19
      • 3.23 Working with Date and Time00:15
      • 3.24 Working with Dates and Times Demo 0303:18
      • 3.25 Advanced Data Types00:14
      • 3.26 Understanding Advanced Data Types03:55
      • 3.27 XML Data Types01:45
      • 3.28 Exploring Some Advanced Data Types00:09
      • 3.29 Exploring Some Advanced Data Types Demo 0405:20
      • 3.30 Quiz
      • 3.31 Summary00:43
      • 3.32 Conclusion00:10
    • Lesson 04 - Sorting and Filtering 38:09
      • 4.1 Sorting and Filtering00:21
      • 4.2 Objectives00:22
      • 4.3 Sorting Results00:12
      • 4.4 Sort Order for SELECT01:26
      • 4.5 ORDER BY Clause01:20
      • 4.6 Multiple Columns and Direction of Sort02:14
      • 4.7 Sorting with ORDER BY, and Performing Multiple Column and Ascending - Descending Sorts00:18
      • 4.8 Sorting with ORDER BY, and Performing Multiple Column and Ascending - Descending Sorts Demo 0102:35
      • 4.9 Extended Capabilities for Sorting00:11
      • 4.10 TOP Clause01:48
      • 4.11 OFFSET Clause01:55
      • 4.12 FETCH Parameter02:47
      • 4.13 Using TOP, OFFSET, and FETCH00:11
      • 4.14 Using TOP, OFFSET, and FETCH Demo 0202:50
      • 4.15 Filtering Results00:18
      • 4.16 The WHERE Clause01:39
      • 4.17 Logical Operators01:59
      • 4.18 Predicates01:27
      • 4.19 Predicate Operators02:51
      • 4.20 Filter Using WHERE, and Different Predicates and Operators00:10
      • 4.21 Filter Using WHERE, and Different Predicates and Operators Demo 0303:55
      • 4.22 Advanced Filtering00:12
      • 4.23 Using Unicode in Filters00:57
      • 4.24 ANY Clause01:21
      • 4.25 ALL Clause01:00
      • 4.26 Unicode, ANY, and ALL Filters00:11
      • 4.27 Unicode, ANY, and ALL filters Demo 0402:03
      • 4.28 Quiz
      • 4.29 Summary00:41
      • 4.30 Summary (contd.)00:43
      • 4.31 Conclusion00:12
    • Lesson 05 - Query Multiple Tables using JOINs 31:45
      • 5.1 Query Multiple Tables Using JOINs00:21
      • 5.2 Objectives00:26
      • 5.3 Working with Multiple Tables00:12
      • 5.4 Normalization02:25
      • 5.5 Multiple Tables02:51
      • 5.6 Combining Tables in a Query00:49
      • 5.7 Querying Multiple Tables without a JOIN00:10
      • 5.8 Querying Multiple Tables without a JOIN Demo 0102:31
      • 5.9 Using JOIN00:18
      • 5.10 Understanding JOIN01:49
      • 5.11 Simple Join00:52
      • 5.12 Using Implicit Join between Tables00:15
      • 5.13 Using Implicit Join between Tables Demo 0201:43
      • 5.14 Introduction to JOINs00:13
      • 5.15 CROSS JOIN00:53
      • 5.16 INNER JOIN01:42
      • 5.17 INNER JOIN (contd.)01:12
      • 5.18 OUTER JOIN01:23
      • 5.19 LEFT OUTER JOIN00:56
      • 5.20 RIGHT OUTER JOIN00:46
      • 5.21 FULL OUTER JOIN00:41
      • 5.22 Using CROSS, INNER, and OUTER JOINs00:11
      • 5.23 Using CROSS, INNER, and OUTER JOINs Demo 0303:32
      • 5.24 Advanced JOINs00:10
      • 5.25 Advanced JOINs01:05
      • 5.26 MERGE Hint01:10
      • 5.27 HASH Hint00:34
      • 5.28 LOOP Hint00:27
      • 5.29 Using MERGE, HASH, and LOOP00:11
      • 5.30 Using MERGE, HASH, and LOOP Demo 0400:54
      • 5.31 Quiz
      • 5.32 Summary00:53
      • 5.33 Conclusion00:10
    • Lesson 06 - Modifying Table Data 46:43
      • 6.1 Modifying Table Data00:23
      • 6.2 Objectives00:38
      • 6.3 Adding Data to a Table00:16
      • 6.4 INSERT Statement02:00
      • 6.5 Using a Column List in INSERT01:51
      • 6.6 Adding Multiple Rows00:58
      • 6.7 Using Different Forms of INSERT to Add Data to a Table00:11
      • 6.8 Using Different Forms of INSERT to Add Data to a Table Demo 0104:27
      • 6.9 Other Methods to Add Data00:17
      • 6.10 Inserting Data in Bulk00:47
      • 6.11 Using SELECT01:44
      • 6.12 SELECT INTO01:10
      • 6.13 BULK INSERT01:09
      • 6.14 Using Bulk Adding Methods00:13
      • 6.15 Using Bulk Adding Methods Demo 0205:50
      • 6.16 Modifying Data in a Table00:12
      • 6.17 Using the UPDATE Statement01:06
      • 6.18 Specifying Records to UPDATE01:23
      • 6.19 Modifying Data with UPDATE00:15
      • 6.20 Modifying Data with UPDATE Demo 0301:37
      • 6.21 Removing Data from Tables00:18
      • 6.22 DELETE Statement01:12
      • 6.23 TRUNCATE02:56
      • 6.24 DELETE and TRUNCATE Data from Tables00:12
      • 6.25 DELETE and TRUNCATE Data from Tables Demo 0403:38
      • 6.26 Synchronizing Data between Tables00:22
      • 6.27 Data Synchronization02:22
      • 6.28 MERGE Statement01:53
      • 6.29 Synchronizing Data using MERGE00:13
      • 6.30 Synchronizing Data using MERGE Demo 0505:57
      • 6.31 Quiz
      • 6.32 Summary01:02
      • 6.33 Conclusion00:11
    • Lesson 07 - Programming in SQL Server 1:00:34
      • 7.1 Programming in SQL Server00:21
      • 7.2 Objectives00:26
      • 7.3 Work with Functions00:18
      • 7.4 SQL Server Functions02:25
      • 7.5 Function Categories01:51
      • 7.6 String Functions01:59
      • 7.7 Conversion Functions02:19
      • 7.8 Logical Functions01:05
      • 7.9 Numeric Functions00:38
      • 7.10 Date and Time Functions01:44
      • 7.11 Using Different Functions in SQL Server00:17
      • 7.12 Using Different Functions in SQL Server Demo 0105:01
      • 7.13 Working with Groups and Aggregates00:16
      • 7.14 Grouping Data02:17
      • 7.15 Aggregate Functions02:10
      • 7.16 Grouping and Using Different Aggregates00:11
      • 7.17 Grouping and Using Different Aggregates Demo 0202:20
      • 7.18 Variables and Batches00:12
      • 7.19 What Are Variables01:27
      • 7.20 Using Variables01:48
      • 7.21 Using SELECT to Set Variable Value01:03
      • 7.22 Using Batches01:25
      • 7.23 Using Variables and Batches00:11
      • 7.24 Using Variables and Batches Demo 0303:00
      • 7.25 Control Flow Statements00:12
      • 7.26 What Are Control Flow Statements00:58
      • 7.27 GOTO02:18
      • 7.28 Containers00:30
      • 7.29 IF Statement01:12
      • 7.30 WHILE Statement00:51
      • 7.31 Using Control Flow Statements00:15
      • 7.32 Using Control Flow Statements Demo 0405:08
      • 7.33 Working with Stored Procedures00:17
      • 7.34 Stored Procedures02:04
      • 7.35 Creating a New Stored procedure01:47
      • 7.36 Parameters01:25
      • 7.37 Error Handling01:37
      • 7.38 Working with Stored Procedures00:13
      • 7.39 Working with Stored Procedures Demo 0506:11
      • 7.40 Quiz
      • 7.41 Summary00:40
      • 7.42 Conclusion00:12
    • Lesson 08 - Writing Advanced Queries in T-SQL 37:48
      • 8.1 Writing Advanced Queries in T-SQL00:21
      • 8.2 Objectives00:25
      • 8.3 Subqueries00:11
      • 8.4 What Is a Subquery01:31
      • 8.5 Self-Contained Subquery00:53
      • 8.6 Multi-Value Subquery01:21
      • 8.7 Correlated Subquery00:59
      • 8.8 EXISTS Subquery00:30
      • 8.9 Using Subqueries00:10
      • 8.10 Using Subqueries Demo 0102:50
      • 8.11 Table Expressions00:11
      • 8.12 What Are Table Expressions01:03
      • 8.13 Derived Tables01:00
      • 8.14 Using WITH for Common Table Expressions01:14
      • 8.15 Table Valued Functions01:22
      • 8.16 Using Table Valued Expressions00:11
      • 8.17 Using Table Valued Expressions Demo 0203:59
      • 8.18 Set and Conditional Operators00:18
      • 8.19 Set Operators01:35
      • 8.20 UNION00:37
      • 8.21 UNION ALL00:31
      • 8.22 INTERSECT00:33
      • 8.23 EXCEPT00:30
      • 8.24 Conditional Operators00:45
      • 8.25 Using Different Set Operators00:11
      • 8.26 Using Different Set Operators Demo 0302:02
      • 8.27 Window Functions00:14
      • 8.28 What are Window Functions01:26
      • 8.29 Window Functions List01:53
      • 8.30 Using Window Functions00:11
      • 8.31 Using Window Functions Demo 0403:01
      • 8.32 Creating User-Defined Functions00:10
      • 8.33 User-Defined Functions01:28
      • 8.34 Create and Use UDF00:11
      • 8.35 Create and Use UDF Demo 0502:52
      • 8.36 Quiz
      • 8.37 Summary00:57
      • 8.38 Conclusion00:12
    • Lesson 09 - Data Manipulation 24:56
      • 9.1 Data Manipulation00:23
      • 9.2 Objectives00:16
      • 9.3 PIVOT and UNPIVOT Operators00:09
      • 9.4 PIVOT Operator01:57
      • 9.5 PIVOT Example with Explanation01:05
      • 9.6 UNPIVOT Operator00:24
      • 9.7 Using PIVOT to Analyze Data00:10
      • 9.8 Using PIVOT to Analyze Data Demo 0103:48
      • 9.9 Grouping Sets00:13
      • 9.10 GROUP BY01:18
      • 9.11 GROUPING SETS Clause00:50
      • 9.12 GROUP BY CUBE00:55
      • 9.13 GROUP BY ROLLUP00:44
      • 9.14 Grouping Sets00:09
      • 9.15 Grouping Sets Demo 0203:36
      • 9.16 Handling Transactions00:11
      • 9.17 Transactions01:09
      • 9.18 Explicit Transaction01:42
      • 9.19 Implicit Transaction01:09
      • 9.20 Using Transactions00:10
      • 9.21 Using Transactions Demo 0303:46
      • 9.22 Quiz
      • 9.23 Summary00:43
      • 9.24 Conclusion00:09
    • Lesson 10 - Advanced Querying 30:38
      • 10.1 Advanced Querying00:26
      • 10.2 Objectives00:23
      • 10.3 System Databases00:11
      • 10.4 What Are System Databases01:41
      • 10.5 Master Database01:01
      • 10.6 Model Database01:13
      • 10.7 TempDB Database01:21
      • 10.8 MSDB Database01:14
      • 10.9 System Stored Procedures00:11
      • 10.10 What Are System Stored Procedures00:54
      • 10.11 System Stored Procedure Categories01:53
      • 10.12 Work with System Stored Procedures00:07
      • 10.13 Work with System Stored Procedures Demo 0101:37
      • 10.14 Query Plans00:12
      • 10.15 Query Execution01:03
      • 10.16 Plan Guide and Hints01:25
      • 10.17 Viewing Query Plans00:06
      • 10.18 Viewing Query Plans Demo 0202:17
      • 10.19 Manage Indexes00:14
      • 10.20 Indexes01:47
      • 10.21 Index Types01:20
      • 10.22 Manage Views00:09
      • 10.23 Views01:05
      • 10.24 Using Indexes and Views00:11
      • 10.25 Using Indexes and Views Demo 0302:50
      • 10.26 Windows Azure SQL Database00:15
      • 10.27 What Is Windows Azure SQL Database00:55
      • 10.28 Overview of Windows Azure SQL Database00:10
      • 10.29 Overview of Windows Azure SQL Database Demo 0403:21
      • 10.30 Quiz
      • 10.31 Summary00:38
      • 10.32 Summary (contd.)00:19
      • 10.33 Conclusion00:09
  • Free Course
    • {{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.

    View More View Less

    Contact Us

    +1-844-532-7688

    (Toll Free)

    People Also Bought

    CompTIA Linux+ CompTIA Linux+ Course Explore
    Configuring Windows 8 Configuring Windows 8 Course Explore
    Mac OS X Mavericks Mac OS X Mavericks Course Explore
    Microsoft<sup>®</sup> SharePoint 2013 Microsoft® SharePoint 2013 Course Explore
    All-in-One MySQL Suite All-in-One MySQL Suite Course Explore
    Choose your Location

    Let us know your convenient schedule

    Name *
    Email *
    Phone Number
    Date (MM/DD/YYYY)
    • Disclaimer
    • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.
    Help and Support