SQL (Structured Query Language) is a common tool for retrieving data from relational databases such as SQL Server, MySQL, MariaDB, and PostgreSQL. This course provides an introduction to this core programming language. Learn how to request data from a server, limit and sort the responses, aggregate data from multiple tables with joins, and edit and delete data. Instructor Scott Simpson also shows how to perform simple math operations and transform data into different formats.
Learn. Build. Teach.
Scott Simpson has a master's in education and currently creates technology courses as an author at LinkedIn.
Scott has been interested in computers since he was about seven years old, and for most of that time, he's been teaching friends, family, and strangers how to use them. This geeky hobby turned into a job with Apple during college, and after completing his master's degree in education at San Diego State University, he has helped to shape the Developer segment here at lynda.com as a content producer. Scott enjoys building web apps and exploring new technologies. He can be found on Twitter at @scotty82.
- Scott Simpson has a master's in education and currently creates technology courses as an author at LinkedIn.
Skills covered in this course
- [Scott] Our world is driven by data and a lot of that data is stored in databases. In order to unlock the information and insights stored in databases, we need a way of asking for data. One common language for asking about and modifying data in databases is SQL. SQL in some form or another is used in database products across the spectrum. From small SQLite databases in mobile devices to my MySQL servers, hosting data for blogs and other apps, to enterprise scale Oracle and Microsoft SQL server databases running multi-billion dollar corporations. But the same basic language underlies all of these. In this course, I'll explain what SQL is, and take you through an introduction to the language. You'll see how to ask questions of databases in a structured way to get the information that you need. We'll focus on the language itself, not any particular tool. And the amount of setup you'll need to do in order to get started is minimal. The goal for this course is to get you comfortable…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download the exercise files for this course. Get started with a free trial today.
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.
Watch this course anytime, anywhere. Get started with a free trial today.