From the course: Intermediate SQL for Data Scientists
Join today to access over 25,300 courses taught by industry experts.
Data manipulation commands - SQL Tutorial
From the course: Intermediate SQL for Data Scientists
Data manipulation commands
- [Instructor] This is an intermediate SQL course, so I assume that you have some familiarity with SQL, but I do want to make sure that we all have some common understanding and a little bit of a refresher just in case it's been a little bit of time since you've seen some of the more common SQL commands that we'll be using in this course. So for starters, I just want to point out that there are two types of SQL commands that we're going to focus on. One type is called data manipulation commands, and the others are data definition commands. In this video, we're going to focus on data manipulation commands. Now, the first data manipulation command I want to start with is called insert. And here's an example of an insert statement. And I'm going to walk through this one section or one clause of the insert statement at a time. But I want to show you the entire command, which is used to insert one row of data into a table called company regions. So we start with the first part of the…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.