Font size:

SQL Server 2012 includes the SQL Server Management Studio which allows access to SQL Server databases and enables you to access database data. This data can be retrieved and modified through the use of Transact-SQL within the Query Edit window of the Management Studio tool. Using Transact-SQL you can select data from a database’s tables and filter the results to include only the data that you require. Transact-SQL statements also allow you to update, change, and remove data from tables. This course identifies the basic Transact-SQL statements that can be used to retrieve and modify data within SQL Server databases,which includes the DML statements SELECT, INSERT, UPDATE, DELETE, and MERGE. This course also demonstrates how to use joins in queries in combine data from multiple tables and how to use subqueries. This course is one of a series in the SkillSoft learning path that covers the objectives for the exam 70-461: Microsoft SQL Server 2012: Querying. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.
  • describe how the SELECT statement is used to retrieve data
  • describe the characteristics of subqueries
  • use a join condition to define how tables are related
  • retrieve data from SQL Server database in a given scenario
  • alter the data in a given scenario
  • use the MERGE and OUTPUT statements to change the contents of a database in a given scenario
  • modify the contents of a databases in a given scenario
Register Now
Microsoft SQL Server 2012: Querying Basics and Modifying Data Online course
  • Course ID:
    235676
  • Duration:
    90 minutes
  • Price:
    $75