Analytics
Exploratory Data Analysis
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.
Pluralsight Teams₹4,166.75 per user/month, billed annually
₹50,004
CompleteBilled Monthly
₹2,370/mo
Why choose Core Tech?
verifiedGet this course for free with the Coursera Plus subscription.
✓ Compare courses before making a decision
Check Latest Price →Price may vary. Check latest price on provider site.
Course Insight
Suitable for intermediate learners. Works well as a continuation after mastering Data Science fundamentals. It bridges the gap toward advanced, production-level engineering.
Intermediate FriendlySelf-Paced Learning
SKILLS TO
MASTER
ModelingTrending
Predictive Machine LearningSQL Querying
Relational Data ManagementCareers:Relevant for professionals pursuing roles within Data Science.
💡This course fits perfectly into our comprehensiveData Science Learning Path. Explore the ecosystem to see how it compares to other foundational skills.
Quick Facts
Below sections are verified from last major sync. For real-time updates and today's latest lectures, Check official page here.
What You’ll Learn
- Course Overview : 1min.
- Working with the T-SQL Data Manipulation Language : 28mins.
- Adding Data Using T-SQL Statements : 29mins.
- Modifying Data Using T-SQL Statements : 24mins.
- Removing Data Using T-SQL Statements : 26mins.
- Maintaining Data Integrity with Transactions : 30mins.
- Using Advanced T-SQL Techniques : 29mins.
- Final Takeaway : 4mins.
See side-by-side differences in what you’ll learn
Description
In this course, T-SQL Data Manipulation Playbook, you'll learn foundational knowledge required to add records, modify data, and remove records in your SQL Server database.
First, you'll learn how to add data using the INSERT statement. Next, you'll discover how to modify data using UPDATE, and how to remove data using the DELETE statement.
Moving on, you'll explore how to maintain database integrity with transactions. Finally, you'll examine some more advanced T-SQL statements that are not that common, but can help you with your daily work.
When you're finished with this course, you'll have the skills and knowledge of the T-SQL Data Manipulation Language needed to insert, update, and delete data in Microsoft SQL Server.
See how this course compares with alternatives
FAQs
Top Alternatives
Highly-rated courses worth your attention
⭐ 4(98+ learners)