Using SQL databases

…Before we move on from talking about data, I…want to talk in a little bit more detail about…SQL databases. SQL, or structured query language, often referred to…as SQL as well, is the standard language for managing…and retrieving information from databases. By taking a deeper…look at it, you're gonna get a better overall feel…for how data management works. Web applications typically use SQL…or some form of it to update, create, delete or…retrieve information from a relational database. Relational…databases are the most common form of data…storages by web applications. They store related data…in one or more tables. If you've never…dealt with a database before, just picture a…spreadsheet. Data is stored in rows and columns…with the columns describing the data and the…rows storing the data itself. Using simple SQL…queries or SQL queries, if you will, web…applications can parse and use this data within the…application. SQL uses simple logical syntax that's very…easy for most people to learn. Common statements like…

Resume Transcript Auto-Scroll

Author

Released

12/17/2013

You use it every day, for banking, researching, shopping, and social media, but do you really know how the web works? In this course, author James Williamson introduces the technology that makes the web run, the terminology involved, and how it all comes together to power the websites we know and love. He covers the alphabet soup of technologies involved (HTML, CSS, URL, DNS, HTTP, and IPv6), and explains what separates the front end (what we see) from the back end (what we don't) on the web. This course is your "plain English" guide to the world of domains, databases, servers, and the technology that makes the web work.