وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

T-SQL Data Manipulation Playbook

سرفصل های دوره

Querying is one of the most common operations when working with a database. But to query, you need data. This training covers how to insert, update, and delete data in your Microsoft SQL Server database using T-SQL Data Manipulation Language, or DML.


1. Course Overview
  • 1. Course Overview

  • 2. Working with the T-SQL Data Manipulation Language
  • 1. Version Check
  • 2. Working with the T-SQL Data Manipulation Language
  • 3. Understanding and Differentiating the T-SQL Sub-languages
  • 4. What Is the T-SQL Data Manipulation Language
  • 5. The Database for This Training - StackOverflow or StackExchange
  • 6. What You Need to Know About SELECT for DML
  • 7. What You Need to Know About WHERE for DML
  • 8. Takeaway

  • 3. Adding Data Using T-SQL Statements
  • 1. Adding Data Using T-SQL Statements
  • 2. Adding New Records with the INSERT Statement
  • 3. An Insert Statement with Columns and Values
  • 4. An Insert Statement with All Values
  • 5. An Insert Statement with NULL and DEFAULT
  • 6. An Insert Statement with an Identity
  • 7. An Insert Statement with Constraints
  • 8. Adding Multiple Records from a Data File with BULK INSERT
  • 9. Takeaway

  • 04. Modifying Data Using T-SQL Statements
  • 01. Modifying Data Using T-SQL Statements
  • 02. Modifying Records with the UPDATE Statement
  • 03. Using UPDATE to Modify Data in One Row
  • 04. Using UPDATE to Modify Data in Multiple Rows
  • 05. Retrieving Number of Affected Rows with @@Rowcount
  • 06. Modifying Data Using UPDATE with Constraints
  • 07. UPDATE Using Variables
  • 08. FROM and JOIN within an UPDATE
  • 09. A Few More Details on UPDATE
  • 10. Takeaway

  • 5. Removing Data Using T-SQL Statements
  • 1. Removing Data Using T-SQL Statements
  • 2. Removing Records with the DELETE Statement
  • 3. Removing a Specific Record with DELETE
  • 4. Removing Multiple Records with DELETE
  • 5. Deleting Data Using JOINs
  • 6. Removing Data with Constraints and Cascade Deleting of Data
  • 7. Clearing Tables Using TRUNCATE and How It Differs from DELETE
  • 8. Takeaway

  • 6. Maintaining Data Integrity with Transactions
  • 1. Maintaining Data Integrity with Transactions
  • 2. Transaction Properties
  • 3. Understanding T-SQL Transactions
  • 4. Creating Transactions Using BEGIN and COMMIT
  • 5. Querying Data Locked in a Transaction with NOLOCK
  • 6. Undoing Transactions Using ROLLBACK
  • 7. Partially Undoing Transactions Using Savepoints
  • 8. Distributed Transactions at a High Level
  • 9. Takeaway

  • 7. Using Advanced T-SQL Techniques
  • 1. Using Advanced T-SQL Techniques
  • 2. Using INSERT with Multiple Values
  • 3. SELECT within an INSERT Statement
  • 4. Using SELECT to Retrieve a Specific Field in an INSERT
  • 5. Retrieving Records on INSERT Using the OUTPUT Clause
  • 6. Utilizing MERGE to Perform Operations on a Target Table
  • 7. BULK INSERT Using a Format File
  • 8. Takeaway

  • 8. Final Takeaway
  • 1. Final Takeaway
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 14672
    حجم: 419 مگابایت
    مدت زمان: 174 دقیقه
    تاریخ انتشار: ۲۹ خرداد ۱۴۰۲
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید