Working with Data

SQL Server 2014    |    Beginner
  • 6 videos | 44m 8s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 18 users Rating 4.7 of 18 users (18)
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

  • 8m 41s
    After completing this video, you will be able to describe how data is inserted into a database and use INSERT statements to insert one or more rows into a SQL Server database. FREE ACCESS
  • 9m 9s
    In this video, learn how to use BULK INSERT to insert data into a SQL Server database. FREE ACCESS
  • Locked
    3.  Updating Data
    4m 34s
    Upon completion of this video, you will be able to describe how data is updated to a SQL Server database and use appropriate UPDATE statements. FREE ACCESS
  • Locked
    4.  Deleting Data
    6m
    In this video, learn how to use the DELETE command to delete data from single or multiple SQL Server tables. FREE ACCESS
  • Locked
    5.  Transactions
    8m 57s
    In this video, find out how to use transactions with SQL server to ensure data integrity and referential integrity. FREE ACCESS
  • Locked
    6.  Exercise: Using DML Statements
    6m 48s
    Learn how to use DML statements to query, update, and delete data in a SQL Server database. 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Oracle Database 12c R2 SQL: Using the Set Operators
Rating 4.6 of 39 users Rating 4.6 of 39 users (39)
Course Working with Microsoft Azure SQL: Using Transact-SQL for Queries & Transactions
Rating 4.7 of 11 users Rating 4.7 of 11 users (11)
Course Database Fundamentals: Understanding Relational Database Management Systems
Rating 4.5 of 173 users Rating 4.5 of 173 users (173)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Database Design
Rating 4.3 of 221 users Rating 4.3 of 221 users (221)
Course Normalization Concepts
Rating 4.6 of 184 users Rating 4.6 of 184 users (184)
Course Concepts & Conceptual Design
Rating 4.5 of 241 users Rating 4.5 of 241 users (241)