Working with Data

SQL Server 2014    |    Beginner
  • 6 Videos | 46m 38s
  • Includes Assessment
  • Earns a Badge
Likes 36 Likes 36
Discover how to update and delete data from a SQL Server database and how to use transactions to ensure data and referential integrity.

WHAT YOU WILL LEARN

  • describe how data is inserted into a database and use INSERT statements to insert one or more rows into a SQL Server database
    use BULK INSERT to insert data into a SQL Server database
    describe how data is updated to a SQL Server database and use appropriate UPDATE statements
  • use DELETE to delete data from single or multiple SQL Server tables
    use transactions with SQL server to ensure data and referential integrity
    use DML statements to query, update, and delete data in a SQL Server database

IN THIS COURSE

  • Playable
    1. 
    Inserting Data
    8m 41s
    UP NEXT
  • Playable
    2. 
    Bulk Inserts
    9m 9s
  • Locked
    3. 
    Updating Data
    4m 34s
    FREE ACCESS
  • Locked
    4. 
    Deleting Data
    6m
    FREE ACCESS
  • Locked
    5. 
    Transactions
    8m 57s
    FREE ACCESS
  • Locked
    6. 
    Exercise: Using DML Statements
    6m 48s
    FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

CHANNEL Database Security
Likes 40 Likes 40  
COURSE SQL Transactions
Likes 51 Likes 51  
COURSE SQL Databases Using SQLAlchemy: Using the SQLAlchemy ORM
Likes 0 Likes 0  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Components, Procedures, & Functions
Likes 41 Likes 41  
COURSE Concepts & Conceptual Design
Likes 141 Likes 141  
COURSE Database Design
Likes 109 Likes 109