From the course: Learning Azure SQL Querying

The most common SQL statements - Azure Tutorial

From the course: Learning Azure SQL Querying

Start my 1-month free trial Buy for my team

The most common SQL statements

“

- [Instructor] The most common data operations you'll be performing against your relational database are create, read, update, and delete, which is shortened to CRUD. All of the keywords in SQL don't line up perfectly with this acronym, but to create new records, you will use an insert statement. To read data from your database, you will use a SELECT statement. And then the last two CRUD operations do have keywords that line up. To update existing data in your database, you'll use an UPDATE statement. And finally, to delete any data, you'll use a DELETE statement. There are also SQL statements that allow you to create and modify the schema of your tables, such as create table or drop table for deleting an entire table. In this course, we're going to use some sample data that is preloaded for us so we aren't going to edit the existing schema. But if you'd like to learn more about how to do this, then after this course, search our catalog for Create a Table in SQL. In this course, we're going to use the built-in SQL client that's included within the Azure SQL Portal and it doesn't overwhelm you with tons of features, but most of the larger SQL clients that you can connect to your database have the ability to change the schema of your database using a graphical user interface. These editors will write the SQL for you behind the scenes. So if you're just starting out with SQL, this is the easiest way to make changes to the design of your tables or add new ones. Check out my deep dive course on Azure SQL if you want to see how to connect this Azure Data Studio client to your Azure SQL database for making schema changes to your database. Now, if you want to edit your schema through SQL commands, keep in mind that those statements can differ slightly depending on which database management system you're using, so let's talk about the different database vendors.

Contents