This course was last updated on 10/2021.
We analyzed factors such as the rating (0.0/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.
✓ Insert single and multiple rows into a table by using the INSERT VALUES statement
✓ Insert the result of a query into a table by using the INSERT SELECT statement
✓ Insert the result of a stored procedure or a dynamic batch into a table by using the INSERT EXEC statement
✓ Use a query result to create and populate a table by using the SELECT INTO statement
✓ Use the UPDATE statement to modify rows in a table
✓ Update data by using joins
✓ Describe the circumstances in which you get nondeterministic updates
✓ Update data through table expressions such as Common Table Expression (CTE) or subqueries
✓ Update data by using variables
✓ Describe the implications of the all-at-once property of SQL on updates
✓ Use the DELETE and TRUNCATE statements to delete rows from a table
✓ Use a DELETE statement based on joins
✓ Use a DELETE statement based on table expressions such as CTE and subquery
• To be able to perform the hands-on exercises, you need an instance of SQL Server 2016 or 2019 and SQL Server Management Studio (SSMS)
• You need some experience writing Transact-SQL code
• You need to install the sample database AcotexDB
• You should have an understanding of filtering and sorting data
• An understanding of creating tables and enforcing data integrity
• This course is NOT for entry-level SQL developers. Other modules of my future courses will be tailored for beginners
• The course is ideal for practicing SQL professionals and individuals with some skills in writing SQL code
• This course is narrowly focused on a single, but one of the most important skill set for any T-SQL developer: Modifying data by using INSERT, UPDATE, and DELETE statements. The course ensures specialization of these topics by using in-depth, different T-SQL statements
• Individuals preparing for the Microsoft T-SQL querying exams will go through the exam objectives for Inserting, Updating, and Deleting data
The course costs $14.99. And currently there is a 25% discount on the original price of the course, which was $84.99. So you save $70 if you enroll the course now.
YES, Query Transact-SQL (T-SQL) 2016/2019: For data modification has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.
Samuel Osei-Tutu has created 9 courses that got 39 reviews which are generally positive. Samuel Osei-Tutu has taught 938 students and received a 4.0 average review out of 39 reviews. Depending on the information available, we think that Samuel Osei-Tutu is an instructor that you can trust.
Microsoft Certified Professional, Consultant and Author
A Mining Engineer by profession and a data aficionado by nature. I have been using spreadsheet applications and databases or over 30 years. My spreadsheet journey started in the era of Lotus 123 and my first SQL Server training I received was in version 6.5. Since then I have not looked back and have continued polishing my skills with every release of SQL Server and Office. My training as a Mining Engineer and love for data have naturally led to my assignment of processing large amount of data in the resources and similar industries. I have earned a number of Microsoft certifications, beginning in 1998 when I earned my first certification in Microsoft Access. I currently hold certifications is SQL Server, Microsoft Excel (MOSE). In my career, I have taught many individual and company staff as face-to-face instructor. These include Bank of Ghana staff, Ghana Institute of Management and Public Administration (GIMPA), Ghana Motors (Ghamot) and many others. In Australia I have established database systems for some leading mining, consulting, and utilities companies such as AngloGold Ashanti, Barrick Gold, Western Power Corporation, Citic Pacific Mining, WorleyParsons etc. My broad industrial experience is a plus for my teaching engagements as I am able to draw on some real world, practical examples.
I have published two books (1) “Microsoft Excel 2013/2016: Get Your Hands Dirty” and (2) Microsoft Excel 2013/2016 Pivot Tables: Get Your Hands Dirty”
I love engaging with people and I hope my courses will give you the skills and knowledge to help you move along in this competitive world.