MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

SQL Server: Transact-SQL Basic Data Modification

Course Summary

If you need to modify data in a SQL Server database, then you need to know how to use the INSERT, UPDATE and DELETE statements. This course starts by explaining how to find information about the tables and columns you want to modify. It then explains the

  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
        ◦ Course Structure
    ● Setting Up a Transact-SQL Learning Environment
        ◦ Module Introduction
        ◦ SQL Server 2012 Express with Tools
        ◦ SQL Server 2012 Express Abridged Requirements
        ◦ Demo: Checking Hardware and OS Specifications
        ◦ Demo: Checking .NET 3.5 SP1 Prerequisites
        ◦ Demo: Installing SQL Server 2012 Express with Tools
        ◦ SQL Server Management Studio (SSMS)
        ◦ Demo: Using SSMS
        ◦ SQL Server Data Tools (SSDT)
        ◦ Demo: Installing SSDT
        ◦ AdventureWorks Sample Database
        ◦ Demo: Attaching the AdventureWorks Sample Database
        ◦ Basic Data Modification Query in SSMS and SSDT
        ◦ Demo: Execute a Data Modification Query in SSMS
        ◦ Demo: Execute a Data Modification Query in SSDT
    ● Exploring Table Metadata
        ◦ Module Introduction
        ◦ Using sp_help
        ◦ Identity and RowGuidCol sp_help Information
        ◦ Constraint sp_help Information
        ◦ Demo: sp_help
        ◦ Catalog Views
        ◦ Demo: Catalog Views
        ◦ Catalog Views (2)
        ◦ Demo: Catalog Views (2)
        ◦ Triggers
        ◦ Demo: Trigger Catalog View
        ◦ sys.dm_sql_referencing_entities
        ◦ Demo: sys.dm_sql_referencing_entities
    ● Inserting Data
        ◦ Module Introduction
        ◦ Demo: Backing up and restoring your sample database
        ◦ Basic Row Insert
        ◦ Demo: Basic Row Insert
        ◦ Column List
        ◦ Demo: Column List Usage
        ◦ Specifying Data Values
        ◦ Transact-SQL Row Constructors
        ◦ Demo: Transact-SQL Row Constructors
        ◦ Handling Defaults
        ◦ Demo: Handling Defaults
        ◦ Populating via Derived Table and EXECUTE
        ◦ Demo: Populating via Derived Table and EXECUTE
    ● Updating Data
        ◦ Module Introduction
        ◦ Simple Update
        ◦ Demo: Simple UPDATE
        ◦ UPDATE with FROM
        ◦ Demo: UPDATE with FROM
        ◦ Defaults
        ◦ Demo: Handling Defaults
        ◦ Compound assignment operators
        ◦ Demo: Compound assignment operators
        ◦ Updating with Sub-Query Values
        ◦ Demo: Updating with Sub-Query Values
        ◦ Updating Views
        ◦ Demo: Updating Views
    ● Deleting Data
        ◦ Module Introduction
        ◦ Basic DELETE
        ◦ Demo: Basic DELETE
        ◦ WHERE and FROM clause with DELETE
        ◦ Demo: WHERE and FROM clauses with DELETE
        ◦ Demo: DELETE vs. TRUNCATE TABLE
    ● Beyond the Basics
        ◦ Module Introduction
        ◦ MERGE
        ◦ Demo: MERGE
        ◦ Data Modifications with CTEs
        ◦ Demo: Data Modifications with CTES
        ◦ Updating Large-Value Data Types
        ◦ Demo: Updating Large-Value Data Types
        ◦ Minimal Logging Operations
        ◦ Referencing Sequence Objects
        ◦ Demo: Referencing Sequence Objects
        ◦ OUTPUT Clause
        ◦ Demo: OUTPUT Clause
        ◦ Consistent Data Type Usage
        ◦ Batching Modifications with TOP
        ◦ Demo: Batching Modifications with TOP
        ◦ Explicit Transactions
        ◦ Demo: Using Explicit Transactions
        ◦ Error Handling
        ◦ Demo: Error Handling

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top