From the course: Programming Foundations: Databases
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Writing SQL queries
- [Instructor] Now I want to shift gears a little bit and show you how we manipulate data in the database using SQL, I've taken a moment to finish creating the database and I've added some data that will let us see how the database will work, one common task you'll need to do with SQL is write queries. A query returns specific information that we ask for. Over the next few videos we'll take a look at some basic SQL queries and statements. These videos are intended more as a demonstration than a tutorial on the specifics of SQL. If you'd like to learn more about SQL in particular take a look at learning SQL programming here on LinkedIn Learning, when we ask for information from a database we'll use the select statement. This tells the database we want to see information from specific fields, I'll write a select statement here and to start out I'll use the asterisk or star character which SQL treats as a wildcard, or a character that indicates all possible values in order to ask 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.