We may earn an affiliate commission when you visit our partners.
Xavier Morera
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.
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.
Read more
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.
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.
Read more
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.
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/r8f06m/t
What's inside
Syllabus
Course Overview
Working with the T-SQL Data Manipulation Language
Adding Data Using T-SQL Statements
Modifying Data Using T-SQL Statements
Read more
Syllabus
Course Overview
Working with the T-SQL Data Manipulation Language
Adding Data Using T-SQL Statements
Modifying Data Using T-SQL Statements
Read more
Removing Data Using T-SQL Statements
Maintaining Data Integrity with Transactions
Using Advanced T-SQL Techniques
Final Takeaway
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Expands knowledge of T-SQL by exploring INSERT, UPDATE, and DELETE statements
Introduces students to the use of advanced T-SQL techniques in data manipulation
Demonstrates how to use transactions to maintain database integrity
Part of a larger curriculum for T-SQL Data Manipulation
Suitable for learners who seek to develop their T-SQL data manipulation skills
Assumes learners have a foundational understanding of SQL Server and T-SQL
Save this course
Save T-SQL Data Manipulation Playbook to your list so you can find it easily later:
Save
Save
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in T-SQL Data Manipulation Playbook with these
activities:
SQL Server Fundamentals
Show steps
Revisit the fundamental concepts of SQL and databases to strengthen your foundation for T-SQL Data Manipulation Language.
Browse courses on
Database Fundamentals
Show steps
-
Review the basic concepts of SQL, including data types, tables, and relationships.
-
Practice writing simple SQL queries to retrieve data.
T-SQL Fundamentals: A Guide for Developers
Show steps
Delve deeper into the concepts of T-SQL by reading a comprehensive book that covers fundamentals, data manipulation, and advanced techniques.
Show steps
-
Read the chapters on data manipulation, including INSERT, UPDATE, and DELETE statements.
-
Complete the practice exercises and quizzes provided in the book to test your understanding.
SQL Server Database Design Document
Show steps
Apply your knowledge of data manipulation to design and document a SQL Server database, enhancing your understanding of data structures and relationships.
Browse courses on
Database Design
Show steps
-
Choose a scenario or project that requires data storage.
-
Design the database schema, including tables, columns, and relationships.
-
Create a database design document that outlines your design decisions.
Show all three activities
SQL Server Fundamentals
Show steps
Revisit the fundamental concepts of SQL and databases to strengthen your foundation for T-SQL Data Manipulation Language.
Browse courses on
Database Fundamentals
Show steps
Show steps
Show steps
- Review the basic concepts of SQL, including data types, tables, and relationships.
- Practice writing simple SQL queries to retrieve data.
T-SQL Fundamentals: A Guide for Developers
Show steps
Delve deeper into the concepts of T-SQL by reading a comprehensive book that covers fundamentals, data manipulation, and advanced techniques.
Show steps
Show steps
Show steps
- Read the chapters on data manipulation, including INSERT, UPDATE, and DELETE statements.
- Complete the practice exercises and quizzes provided in the book to test your understanding.
SQL Server Database Design Document
Show steps
Apply your knowledge of data manipulation to design and document a SQL Server database, enhancing your understanding of data structures and relationships.
Browse courses on
Database Design
Show steps
Show steps
Show steps
- Choose a scenario or project that requires data storage.
- Design the database schema, including tables, columns, and relationships.
- Create a database design document that outlines your design decisions.
Show all three activities
Career center
Learners who complete T-SQL Data Manipulation Playbook will develop knowledge and skills
that may be useful to these careers:
Data Architect
Data Architect
Data Architects design and manage data architectures. This course provides a comprehensive understanding of T-SQL, enabling you to effectively design and implement data solutions. By gaining proficiency in T-SQL, you'll enhance your ability to build scalable and efficient data architectures.
Database Designer
Database Designer
Database Designers create and manage database schemas. This course provides a comprehensive understanding of T-SQL, enabling you to effectively design and implement database structures. By gaining proficiency in T-SQL, you'll enhance your ability to build robust and scalable databases.
ETL Developer
ETL Developer
ETL Developers extract, transform, and load data from various sources into a target data warehouse or database. This course provides a comprehensive understanding of T-SQL, enabling you to effectively perform data manipulation and transformation tasks. By gaining proficiency in T-SQL, you'll enhance your ability to build robust and efficient ETL pipelines.
Database Administrator
Database Administrator
Database Administrators are responsible for managing and maintaining databases, including adding, modifying, and removing data. This course provides comprehensive training on T-SQL Data Manipulation Language, which is essential for performing these tasks effectively.
Data Warehouse Engineer
Data Warehouse Engineer
Data Warehouse Engineers design, build, and maintain data warehouses. This course provides a solid foundation in T-SQL, which is widely used in data warehousing for data transformation, cleansing, and aggregation. By completing this course, you'll enhance your ability to work with large datasets and build efficient data warehouses.
Data Engineer
Data Engineer
Data Engineers design, build, and maintain data pipelines. This course provides a solid foundation in T-SQL, which is widely used in data engineering for data manipulation and transformation. By completing this course, you'll enhance your ability to work with data and build robust data pipelines.
Data Scientist
Data Scientist
Data Scientists use SQL to access and manipulate data for analysis. This course provides a strong foundation in T-SQL, which is essential for extracting and preparing data for modeling and analysis. With this knowledge, you'll be well-equipped to contribute to data science projects.
Data Analyst
Data Analyst
Data Analysts use SQL to query, transform, and analyze data to find insights. This course provides a solid foundation in T-SQL, which is the language used to interact with Microsoft SQL Server databases. With this knowledge, you'll be able to extract valuable information from data, a skill that is in high demand in various industries.
Information Security Analyst
Information Security Analyst
Information Security Analysts use T-SQL to analyze security logs and data for threat detection and incident response. This course provides a solid foundation in T-SQL, which is commonly used in security monitoring and forensic analysis. By completing this course, you'll gain valuable skills for identifying and responding to security incidents.
BI Analyst
BI Analyst
BI Analysts use SQL to analyze data and create reports for decision-making. This course provides a solid foundation in T-SQL, which is widely used in business intelligence for data extraction, analysis, and reporting. By completing this course, you'll enhance your ability to extract insights from data and create valuable reports.
Business Analyst
Business Analyst
Business Analysts often use SQL to gather and analyze data to support decision-making. This course provides a solid foundation in T-SQL, which is widely used in business intelligence and data analysis. By completing this course, you'll enhance your ability to extract and interpret data, a valuable skill for Business Analysts.
Software Engineer
Software Engineer
Software Engineers with knowledge of SQL can build and maintain database-driven applications. This course provides a comprehensive understanding of T-SQL, enabling you to effectively interact with relational databases. By gaining proficiency in T-SQL, you'll expand your skillset and increase your marketability as a Software Engineer.
Software Developer
Software Developer
Software Developers may need to work with databases and may find it beneficial to have a basic understanding of T-SQL. This course provides a comprehensive overview of T-SQL, enabling you to effectively communicate with database administrators and contribute to the development of database-driven applications.
IT Manager
IT Manager
IT Managers may need to work with databases and may find it beneficial to have a basic understanding of T-SQL. This course provides a comprehensive overview of T-SQL, enabling you to effectively communicate with database administrators and make informed decisions regarding data management.
Project Manager
Project Manager
Project Managers who work on data-related projects may find it helpful to have a basic understanding of T-SQL. This course provides a solid foundation in T-SQL, enabling you to better understand the technical aspects of data management and communicate effectively with project stakeholders.
For more career information including salaries, visit:
OpenCourser.com/course/r8f06m/t
Reading list
We've selected 12 books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
T-SQL Data Manipulation Playbook.
Save
Provides a comprehensive overview of T-SQL, including data manipulation language (DML) statements. It covers the basics of T-SQL syntax, data types, operators, and control flow.
Provides a solid foundation in the fundamentals of Transact-SQL programming, covering everything from data types and operators to stored procedures and transactions.
Provides a comprehensive overview of SQL Server execution plans, covering everything from how to read and understand them to how to use them to improve performance.
Provides a comprehensive overview of best practices for SQL Server, covering everything from database design to performance tuning.
Provides a comprehensive overview of the internal workings of SQL Server, covering everything from data structures to query processing.
Provides a comprehensive overview of T-SQL stored procedures, covering everything from basic syntax to advanced concepts such as performance tuning and security.
Provides a comprehensive overview of T-SQL views, covering everything from basic syntax to advanced concepts such as performance tuning and security.
Provides a comprehensive overview of T-SQL indexes, covering everything from basic syntax to advanced concepts such as performance tuning and security.
Great introduction to T-SQL for beginners, covering everything from basic syntax to more advanced concepts such as stored procedures and functions.
Provides a comprehensive guide to data manipulation in SQL Server, including DML statements. It covers the basics of T-SQL syntax, data types, operators, and control flow.
Save
Provides a collection of recipes for common T-SQL tasks, including data manipulation language (DML) statements. It includes recipes for inserting, updating, and deleting data, as well as for working with transactions and data integrity.
Save
This reference provides a comprehensive overview of T-SQL data manipulation language (DML) statements. It includes detailed information on syntax, parameters, and usage.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/r8f06m/t
Share
Similar courses
Here are nine courses similar to
T-SQL Data Manipulation Playbook.
Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Writing SQL in PL/SQL
OpenCourser.com/course/caexo1/oracle
Oracle Database Program with PL/SQL Exam Number: 1Z0-149 ...
Most relevant
Hospital management database using SQL server
OpenCourser.com/course/0awcc5/hospital
Hospital management database using SQL server
Most relevant
Designing Effective DML Triggers in SQL Server
OpenCourser.com/course/06j90l/designing
Designing Effective DML Triggers in SQL Server
Most relevant
Introduction to SQL
OpenCourser.com/course/0t1qcg/introduction
Introduction to SQL
Most relevant
SQL: A Practical Introduction for Querying Databases
OpenCourser.com/course/54rc5b/sql
SQL: A Practical Introduction for Querying Databases
Most relevant
70-461, 761: Querying Microsoft SQL Server with Transact-SQL
OpenCourser.com/course/qq8nay/70
70-461, 761: Querying Microsoft SQL Server with Transact...
Most relevant
Guided Project: Get Started with MongoDB CRUD Operations
OpenCourser.com/course/at0zvh/guided
Guided Project: Get Started with MongoDB CRUD Operations
Most relevant
Database Design and Basic SQL in PostgreSQL
OpenCourser.com/course/ghigjn/database
Database Design and Basic SQL in PostgreSQL
Most relevant
Integrating Angular 11 with ASP.NET Core RESTful Services
OpenCourser.com/course/ca4dk2/integrating
Integrating Angular 11 with ASP.NET Core RESTful Services
Most relevant
Time
174 hours
Level
Intermediate
Via
Pluralsight
Instructor
Xavier Morera
Language
English
This course belongs to a
collection
called
Querying Data with T-SQL from SQL Server. It's comprised of seven courses:
Good to know
Expands knowledge of T-SQL by exploring INSERT, UPDATE, and DELETE statements
Introduces students to the use of advanced T-SQL techniques in data manipulation
Demonstrates how to use transactions to maintain database integrity
Part of a larger curriculum for T-SQL Data Manipulation
Suitable for learners who seek to develop their T-SQL data manipulation skills
Assumes learners have a foundational understanding of SQL Server and T-SQL
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser