From the course: Getting Started as a Full-Stack Web Developer

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

SQL: The database query language

SQL: The database query language

From the course: Getting Started as a Full-Stack Web Developer

Start my 1-month free trial Buy for my team

SQL: The database query language

“

- [Presenter] If you're going to use a database in your site and you've probably eventually will, you need to know its language. Fortunately, most databases today speak a dialect of the same one, Structured Query Language better known as SQL or sequel. Before we get into the language, here's an overview of how a website interacts with its database. A website that doesn't use a database mostly just connects the web server to your hosts file system which contains text and media files. Code is usually stored in the file system then interpreted as Python, PHP or whatever. Before being sent back to the user by the web server. Databases are mostly used to store a site's text content. When you add a page to a WordPress site, you're not creating a text file in the web hosts file system, you're actually adding records to its database. All of this happens through a database server. There are dozens available but the two most popular…

Contents