Basic SQL CRUD

A View acts just like a saved SELECT statement. Learn about the CREATE and DROP commands in SQL and how to create Views so that data tables do not have to continually be created in order to simply get a new view of the existing data.

Learn different methods to CREATE and DROP tables in SQL. Many of these methods will copy data from existing tables into the new table as well.

As a precaution against making inadvertent changes, we wrap statements within transactions. Learn how to set up basic transactions, and how to commit or roll back changes within transactions.

Looking at a couple utilities (in Microsoft SQL Server and Google BigQuery) that help import data into a database and export data from a database. Since this lesson focuses on utilities and not writing code, any questions pertaining to these should go to the support personnel of the respective companies that maintain these tools.

In this lesson, we look at ways to pull back a small set of the data from a table so we can quickly review what the data looks like. We explore TOP N, LIMIT N, FETCH FIRST/NEXT N, OFFSET, PERCENT, and WITH TIES.

Learn several SQL statements for inserting data into tables and deleting data from tables. An emphasis is placed on embedding these statements within transactions, when allowed, in order to alleviate the concerns of accidentally inserting or deleting the wrong data.

Learn multiple SQL statements for updating data records in tables. Also consider when to update and when to insert and delete. An emphasis is placed on embedding these statements within transactions, when allowed, in order to alleviate the concerns of accidentally damaging the data.

This lesson focuses on Microsoft SQL Server. Examining the impact of transactions on the data and on other users. Using save points to handle multiple changes within a transaction. Laying the groundwork for later learning on automated processes.

Learn the SQL MERGE INTO command, which combines inserting, updating, and deleting in one statement. Explanation is given for each section of the statement and for good uses and limitations of the statement. An emphasis is placed on embedding these statements within transactions, when allowed, to mitigate destroying large blocks of data in multiple ways. This is a stretch lesson for this course.

We'll take a look back at all we covered in this course.

With Basic SQL SELECT and Basic SQL CRUD, you have encountered the basics of the main statements to create, read, update, and delete data from a database. Come again and be on the lookout for my other courses!