From the course: Database Foundations: Intro to Databases
Unlock the full course today
Join today to access over 24,000 courses taught by industry experts.
Structured Query Language
From the course: Database Foundations: Intro to Databases
Structured Query Language
- [Instructor] Structured Query Language is the common link between all relational database management platforms. So learning how it works on one platform will enable you to apply those same skills to other databases that you come across. Unlike other programming languages that rise and fall in popularity, SQL is probably the most stable and transferable skill that you can have in IT. Here's a couple of reasons why learning SQL might be easier than you think. First, SQL is designed to be human readable. Command keywords often say exactly what they're going to do. The create command creates objects, the insert command inserts rows into a data table. It's very often the case that you can read through a SQL command and know exactly what it's going to do in very plain language. Second, with SQL you tell the database server what you want to happen, and the server figures out how to do it. This is different from many programming…
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.
Contents
-
-
-
-
-
-
(Locked)
Structured Query Language4m 9s
-
(Locked)
Organize a database with schemas6m 4s
-
(Locked)
Table columns3m 41s
-
(Locked)
Create tables8m 43s
-
(Locked)
Alter tables4m 16s
-
(Locked)
Reserved keywords3m 1s
-
(Locked)
Challenge: Create a table43s
-
(Locked)
Solution: Create a table4m 35s
-
(Locked)
Solution: Tables and data types2m 48s
-
(Locked)
-
-
-
-