Resources Corporate Training Government Higher Education
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 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
  • 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