Quality Seal Emagister EMAGISTER CUM LAUDE

Querying Microsoft SQL Server 2012

simplilearn
Online

Price on request
You can also call the Study Centre
81510... More
Compare this course with other similar courses
See all

Important information

  • Course
  • Online
Description

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.

Important information

Opinions

There are no opinions on this course yet

What you'll learn on the course

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.


Compare this course with other similar courses
See all