Querying Microsoft SQL Server 2012

simplilearn

Course

Online

Price on request

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

Simplilearn is the World’s Largest Certification Training Provider, with over 400,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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2017
2016

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 8 years

Subjects

  • SQL
  • Server

Course programme

Course Preview
  • Querying SQL Server 2012 (Exam No. 70-461)
    • Lesson 01 - Introduction to SQL Server 2012
      • 1.1 Introduction to SQL Server 2012
      • 1.2 Objectives
      • 1.3 RDBMS—An Introduction
      • 1.4 RDBMS
      • 1.5 SQL Server
      • 1.6 SQL Server 2012
      • 1.7 SQL Server 2012 Editions
      • 1.8 SQL Server Components
      • 1.9 SQL Server Tools
      • 1.10 SQL Server Management Studio—An Introduction
      • 1.11 SQL Server Management Studio
      • 1.12 Managing Databases
      • 1.13 SSMS Windows
      • 1.14 Exploring SSMS
      • 1.15 Exploring SSMS Demo 01
      • 1.16 Understanding Database Objects
      • 1.17 Database Storage
      • 1.18 Databases Objects
      • 1.19 Creating Database Objects Using SSMS
      • 1.20 Creating Database Objects Using SSMS Demo 02
      • 1.21 Quiz
      • 1.22 Summary
      • 1.23 Summary (contd.)
      • 1.24 Conclusion
    • Lesson 02 - Working with T-SQL
      • 2.1 Working with T-SQL
      • 2.2 Objectives
      • 2.3 Database Structures
      • 2.4 Tables
      • 2.5 Columns
      • 2.6 Rows
      • 2.7 Keys
      • 2.8 Viewing a Table Structure
      • 2.9 Viewing a Table Structure Demo 01
      • 2.10 Introduction to Querying
      • 2.11 Structured Query Language
      • 2.12 T-SQL
      • 2.13 T-SQL Statements
      • 2.14 Statement Parsing
      • 2.15 Writing a Simple Query
      • 2.16 Writing a Simple Query Demo 02
      • 2.17 Managing Database Objects
      • 2.18 CREATE
      • 2.19 ALTER
      • 2.20 DROP
      • 2.21 Add, Modify, and Delete Database Objects
      • 2.22 Add, Modify, and Delete Database Objects Demo 03
      • 2.23 Constraints
      • 2.24 What Are Constraints
      • 2.25 NOT NULL
      • 2.26 DEFAULT
      • 2.27 UNIQUE
      • 2.28 PRIMARY KEY
      • 2.29 FOREIGN KEY Constraint
      • 2.30 FOREIGN KEY Relationships
      • 2.31 Table Level Constraints
      • 2.32 Adding Constraints
      • 2.33 Adding Constraints Demo 04
      • 2.34 Introduction to SELECT
      • 2.35 SELECT Statement
      • 2.36 Column List
      • 2.37 Column Alias
      • 2.38 DISTINCT Clause
      • 2.39 Querying Data from Tables
      • 2.40 Querying Data from Tables Demo 05
      • 2.41 Advanced Use of SELECT
      • 2.42 Using CASE
      • 2.43 Searched CASE
      • 2.44 Advanced Queries
      • 2.45 Advanced Queries Demo 06
      • 2.46 Quiz
      • 2.47 Summary
      • 2.48 Summary (contd.)
      • 2.49 Conclusion
    • Lesson 03 - Understanding SQL Data Types
      • 3.1 Understanding SQL Data Types
      • 3.2 Objectives
      • 3.3 Introduction to SQL Data Types
      • 3.4 SQL Data Types
      • 3.5 Categories of Types
      • 3.6 String Types
      • 3.7 String Data Types—Character Strings
      • 3.8 String Data Types—UNICODE Character Strings
      • 3.9 String Data Types—Binary Strings
      • 3.10 MAX Setting
      • 3.11 Collation
      • 3.12 Using Character, Unicode, and Binary Strings
      • 3.13 Using Character, Unicode, and Binary Strings Demo 01
      • 3.14 Numeric Types
      • 3.15 Numeric Types—Exact
      • 3.16 Numeric Types—Approximate
      • 3.17 Working with Numeric Data
      • 3.18 Working with Numeric Data Demo 02
      • 3.19 Date and Time
      • 3.20 Data Types for Storing Date
      • 3.21 Data Types for Storing Time
      • 3.22 Changing the Date Format
      • 3.23 Working with Date and Time
      • 3.24 Working with Dates and Times Demo 03
      • 3.25 Advanced Data Types
      • 3.26 Understanding Advanced Data Types
      • 3.27 XML Data Types
      • 3.28 Exploring Some Advanced Data Types
      • 3.29 Exploring Some Advanced Data Types Demo 04
      • 3.30 Quiz
      • 3.31 Summary
      • 3.32 Conclusion
    • Lesson 04 - Sorting and Filtering
      • 4.1 Sorting and Filtering
      • 4.2 Objectives
      • 4.3 Sorting Results
      • 4.4 Sort Order for SELECT
      • 4.5 ORDER BY Clause
      • 4.6 Multiple Columns and Direction of Sort
      • 4.7 Sorting with ORDER BY, and Performing Multiple Column and Ascending - Descending Sorts
      • 4.8 Sorting with ORDER BY, and Performing Multiple Column and Ascending - Descending Sorts Demo 01
      • 4.9 Extended Capabilities for Sorting
      • 4.10 TOP Clause
      • 4.11 OFFSET Clause
      • 4.12 FETCH Parameter
      • 4.13 Using TOP, OFFSET, and FETCH
      • 4.14 Using TOP, OFFSET, and FETCH Demo 02
      • 4.15 Filtering Results
      • 4.16 The WHERE Clause
      • 4.17 Logical Operators
      • 4.18 Predicates
      • 4.19 Predicate Operators
      • 4.20 Filter Using WHERE, and Different Predicates and Operators
      • 4.21 Filter Using WHERE, and Different Predicates and Operators Demo 03
      • 4.22 Advanced Filtering
      • 4.23 Using Unicode in Filters
      • 4.24 ANY Clause
      • 4.25 ALL Clause
      • 4.26 Unicode, ANY, and ALL Filters
      • 4.27 Unicode, ANY, and ALL filters Demo 04
      • 4.28 Quiz
      • 4.29 Summary
      • 4.30 Summary (contd.)
      • 4.31 Conclusion
    • Lesson 05 - Query Multiple Tables using JOINs
      • 5.1 Query Multiple Tables Using JOINs
      • 5.2 Objectives
      • 5.3 Working with Multiple Tables
      • 5.4 Normalization
      • 5.5 Multiple Tables
      • 5.6 Combining Tables in a Query
      • 5.7 Querying Multiple Tables without a JOIN
      • 5.8 Querying Multiple Tables without a JOIN Demo 01
      • 5.9 Using JOIN
      • 5.10 Understanding JOIN
      • 5.11 Simple Join
      • 5.12 Using Implicit Join between Tables
      • 5.13 Using Implicit Join between Tables Demo 02
      • 5.14 Introduction to JOINs
      • 5.15 CROSS JOIN
      • 5.16 INNER JOIN
      • 5.17 INNER JOIN (contd.)
      • 5.18 OUTER JOIN
      • 5.19 LEFT OUTER JOIN
      • 5.20 RIGHT OUTER JOIN
      • 5.21 FULL OUTER JOIN
      • 5.22 Using CROSS, INNER, and OUTER JOINs
      • 5.23 Using CROSS, INNER, and OUTER JOINs Demo 03
      • 5.24 Advanced JOINs
      • 5.25 Advanced JOINs
      • 5.26 MERGE Hint
      • 5.27 HASH Hint
      • 5.28 LOOP Hint
      • 5.29 Using MERGE, HASH, and LOOP
      • 5.30 Using MERGE, HASH, and LOOP Demo 04
      • 5.31 Quiz
      • 5.32 Summary
      • 5.33 Conclusion
    • Lesson 06 - Modifying Table Data
      • 6.1 Modifying Table Data
      • 6.2 Objectives
      • 6.3 Adding Data to a Table
      • 6.4 INSERT Statement
      • 6.5 Using a Column List in INSERT
      • 6.6 Adding Multiple Rows
      • 6.7 Using Different Forms of INSERT to Add Data to a Table
      • 6.8 Using Different Forms of INSERT to Add Data to a Table Demo 01
      • 6.9 Other Methods to Add Data
      • 6.10 Inserting Data in Bulk
      • 6.11 Using SELECT
      • 6.12 SELECT INTO
      • 6.13 BULK INSERT
      • 6.14 Using Bulk Adding Methods
      • 6.15 Using Bulk Adding Methods Demo 02
      • 6.16 Modifying Data in a Table
      • 6.17 Using the UPDATE Statement
      • 6.18 Specifying Records to UPDATE
      • 6.19 Modifying Data with UPDATE
      • 6.20 Modifying Data with UPDATE Demo 03
      • 6.21 Removing Data from Tables
      • 6.22 DELETE Statement
      • 6.23 TRUNCATE
      • 6.24 DELETE and TRUNCATE Data from Tables
      • 6.25 DELETE and TRUNCATE Data from Tables Demo 04
      • 6.26 Synchronizing Data between Tables
      • 6.27 Data Synchronization
      • 6.28 MERGE Statement
      • 6.29 Synchronizing Data using MERGE
      • 6.30 Synchronizing Data using MERGE Demo 05
      • 6.31 Quiz
      • 6.32 Summary
      • 6.33 Conclusion
    • Lesson 07 - Programming in SQL Server
      • 7.1 Programming in SQL Server
      • 7.2 Objectives
      • 7.3 Work with Functions
      • 7.4 SQL Server Functions
      • 7.5 Function Categories
      • 7.6 String Functions
      • 7.7 Conversion Functions
      • 7.8 Logical Functions
      • 7.9 Numeric Functions
      • 7.10 Date and Time Functions
      • 7.11 Using Different Functions in SQL Server
      • 7.12 Using Different Functions in SQL Server Demo 01
      • 7.13 Working with Groups and Aggregates
      • 7.14 Grouping Data
      • 7.15 Aggregate Functions
      • 7.16 Grouping and Using Different Aggregates
      • 7.17 Grouping and Using Different Aggregates Demo 02
      • 7.18 Variables and Batches
      • 7.19 What Are Variables
      • 7.20 Using Variables
      • 7.21 Using SELECT to Set Variable Value
      • 7.22 Using Batches
      • 7.23 Using Variables and Batches
      • 7.24 Using Variables and Batches Demo 03
      • 7.25 Control Flow Statements
      • 7.26 What Are Control Flow Statements
      • 7.27 GOTO
      • 7.28 Containers
      • 7.29 IF Statement
      • 7.30 WHILE Statement
      • 7.31 Using Control Flow Statements
      • 7.32 Using Control Flow Statements Demo 04
      • 7.33 Working with Stored Procedures
      • 7.34 Stored Procedures
      • 7.35 Creating a New Stored procedure
      • 7.36 Parameters
      • 7.37 Error Handling
      • 7.38 Working with Stored Procedures
      • 7.39 Working with Stored Procedures Demo 05
      • 7.40 Quiz
      • 7.41 Summary
      • 7.42 Conclusion
    • Lesson 08 - Writing Advanced Queries in T-SQL
      • 8.1 Writing Advanced Queries in T-SQL
      • 8.2 Objectives
      • 8.3 Subqueries
      • 8.4 What Is a Subquery
      • 8.5 Self-Contained Subquery
      • 8.6 Multi-Value Subquery
      • 8.7 Correlated Subquery
      • 8.8 EXISTS Subquery
      • 8.9 Using Subqueries
      • 8.10 Using Subqueries Demo 01
      • 8.11 Table Expressions
      • 8.12 What Are Table Expressions
      • 8.13 Derived Tables
      • 8.14 Using WITH for Common Table Expressions
      • 8.15 Table Valued Functions
      • 8.16 Using Table Valued Expressions
      • 8.17 Using Table Valued Expressions Demo 02
      • 8.18 Set and Conditional Operators
      • 8.19 Set Operators
      • 8.20 UNION
      • 8.21 UNION ALL
      • 8.22 INTERSECT
      • 8.23 EXCEPT
      • 8.24 Conditional Operators
      • 8.25 Using Different Set Operators
      • 8.26 Using Different Set Operators Demo 03
      • 8.27 Window Functions
      • 8.28 What are Window Functions
      • 8.29 Window Functions List
      • 8.30 Using Window Functions
      • 8.31 Using Window Functions Demo 04
      • 8.32 Creating User-Defined Functions
      • 8.33 User-Defined Functions
      • 8.34 Create and Use UDF
      • 8.35 Create and Use UDF Demo 05
      • 8.36 Quiz
      • 8.37 Summary
      • 8.38 Conclusion
    • Lesson 09 - Data Manipulation
      • 9.1 Data Manipulation
      • 9.2 Objectives
      • 9.3 PIVOT and UNPIVOT Operators
      • 9.4 PIVOT Operator
      • 9.5 PIVOT Example with Explanation
      • 9.6 UNPIVOT Operator
      • 9.7 Using PIVOT to Analyze Data
      • 9.8 Using PIVOT to Analyze Data Demo 01
      • 9.9 Grouping Sets
      • 9.10 GROUP BY
      • 9.11 GROUPING SETS Clause
      • 9.12 GROUP BY CUBE
      • 9.13 GROUP BY ROLLUP
      • 9.14 Grouping Sets
      • 9.15 Grouping Sets Demo 02
      • 9.16 Handling Transactions
      • 9.17 Transactions
      • 9.18 Explicit Transaction
      • 9.19 Implicit Transaction
      • 9.20 Using Transactions
      • 9.21 Using Transactions Demo 03
      • 9.22 Quiz
      • 9.23 Summary
      • 9.24 Conclusion
    • Lesson 10 - Advanced Querying
      • 10.1 Advanced Querying
      • 10.2 Objectives
      • 10.3 System Databases
      • 10.4 What Are System Databases
      • 10.5 Master Database
      • 10.6 Model Database
      • 10.7 TempDB Database
      • 10.8 MSDB Database
      • 10.9 System Stored Procedures
      • 10.10 What Are System Stored Procedures
      • 10.11 System Stored Procedure Categories
      • 10.12 Work with System Stored Procedures
      • 10.13 Work with System Stored Procedures Demo 01
      • 10.14 Query Plans
      • 10.15 Query Execution
      • 10.16 Plan Guide and Hints
      • 10.17 Viewing Query Plans
      • 10.18 Viewing Query Plans Demo 02
      • 10.19 Manage Indexes
      • 10.20 Indexes
      • 10.21 Index Types
      • 10.22 Manage Views
      • 10.23 Views
      • 10.24 Using Indexes and Views
      • 10.25 Using Indexes and Views Demo 03
      • 10.26 Windows Azure SQL Database
      • 10.27 What Is Windows Azure SQL Database
      • 10.28 Overview of Windows Azure SQL Database
      • 10.29 Overview of Windows Azure SQL Database Demo 04
      • 10.30 Quiz
      • 10.31 Summary
      • 10.32 Summary (contd.)
      • 10.33 Conclusion

Additional information

  • 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.

See related categories

Querying Microsoft SQL Server 2012

Price on request

The best SQL Server courses

See all

See all