Data Manipulation Playbook
Learn with valuetechacademy
6 modules
T-SQL
Lifetime access
Learn to insert records to a table, modify existing records in the table, removing records from the table and handling transactions
Overview
Learn to insert records to a table, modify existing records in the table, removing records from the table and handling transactions. SQL Queries in this course can be practiced using SQL Server Management Studio(SSMS) or Azure data studio.
- Learn how to add records, modify data, and remove records using Microsoft SQL.
- First, you will learn how to add data to a database table using 10 different ways in SQL.
- Next, you will discover how to modify data, and how to remove data in a database table using different ways in Microsoft SQL.
- Finally, you will learn how to maintain database integrity with transactions.
- The ultimate practical course that helps you master the different ways to manipulate data
- using Microsoft SQL
Key Highlights
The ultimate practical course that helps you master the different ways to manipulate data using SQL
First, you will learn how to add data to a database table using 10 different ways in SQL.
Next, you will discover how to modify data, and how to remove data in a database table using different ways in Microsoft SQL.
Finally, you will learn how to maintain database integrity with transactions.
What you will learn
Add data - 10 different ways
You will learn how to add data to a database table using 10 different ways in SQL
Modify data - 12 different ways
You will discover how to modify data in a database table using 12 different ways in Microsoft SQL.
Remove data - 9 different ways
Learn how to remove data in a database table using different ways in Microsoft SQL.
Transactions
Learn how to maintain database integrity with transactions.
Modules
1.Course Introduction
1 attachment • 1.16 mins
About this course
2.Module 1- Add Data
11 attachments • 52.61 mins
1.Insert SINGLE or MULTIPLE values
2.Insert data with IDENTITY
3.Insert data with CONSTRAINTS
4.Insert data using BULK INSERT
5.Insert data using SELECT
6.Insert a specific field using SELECT
7.Insert data using OUTPUT clause
8.Insert data using SELECT INTO
9.Insert data using STORED PROCEDURE
10.Insert data using MERGE
Module 1 - SQL Scripts
3.Module 2- Modify Data
13 attachments • 58.04 mins
1.Update data in rows
2.Update data in multiple columns
3.Update data in table with constraints
4.Update data using Join
5.Update data using variables
6.Update data using expression
7.Update data using cursors
8.Update data using OUTPUT clause
9.Update data using ROWCOUNT
10.Update data using Subquery
11.Update data using MERGE
12.Update data using dynamic query
Module 2 - SQL Scripts
4.Module 3- Remove Data
10 attachments
1.Delete specific or multiple records
2.Delete data using multiple column values
3.Delete data using TOP command
4.Delete data with Constraints
5.Delete data using JOIN
6.Delete data with Identity
7.Delete data using OUTPUT clause
8.Delete data using MERGE
9.Delete data using SUBQUERY
Module 3 -SQL Scripts
5.Module 4- Transactions
4 attachments
1.Using BEGIN AND 2.using ROLLBACK
3.Using COMMIT
4.Using SAVE
Module 4 - SQL Scripts
6.Course completion
1 attachment
Thank You!
FAQs
How can I enrol in a course?
Enrolling in a course is simple! Just browse through our website, select the course you're interested in, and click on the "Enrol Now" button. Follow the prompts to complete the enrolment process, and you'll gain immediate access to the course materials.
Can I access the course materials on any device?
Yes, our platform is designed to be accessible on various devices, including computers, laptops, tablets, and smartphones. You can access the course materials anytime, anywhere, as long as you have an internet connection.
How can I access the course materials?
Once you enrol in a course, you will gain access to a dedicated online learning platform. All course materials, including video lessons, lecture notes, and supplementary resources, can be accessed conveniently through the platform at any time.
Can I interact with the instructor during the course?
Absolutely! we are committed to providing an engaging and interactive learning experience. You will have opportunities to interact with them through our community. Take full advantage to enhance your understanding and gain insights directly from the expert.
About the creator
Learn with valuetechacademy
Rate this Course
$ 29.00
$69
Order ID:
This course is in your library
What are you waiting for? It’s time to start learning!
Wait up!
We see you’re already enrolled in this course till Lifetime. Do you still wish to enroll again?
