From the course: Programming Foundations: Databases
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Basic SQL
- Once we have a database, we'll need to actually talk to it. A common language used to do this is called SQL, often called Sequel, and it stands for structured query language. Most relational database management system tools, also called RDBMS tools, support ANSI SQL. That's the version of SQL defined by the American National Standards Institute, which is generally considered to be the standard or minimum most widely supported set of commands for the SQL language. Though many tools offer their own flavor or version of the language that extends ANSI SQL to add features specific to that DBMS. Two examples of this are T-SQL or Transact-SQL used by Microsoft SQL Server and MySQL, an open-source DBMS that includes a few other useful features on top of the SQL standard. SQL allows us to write statements which the DBMS interprets, and that's how we interact with the data in the database, from apps, or even within the DBMS itself. In this role of interacting with data, SQL is called a data…
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.