Join James Williamson for an in-depth discussion in this video Using SQL databases, part of Web Development Foundations: Web Technologies.
…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…
- Working with web clients and servers
- Exploring HTTP
- How browsers work
- Structuring HTML
- Controlling presentation with CSS
- Dealing with data
- Working with a content management system (like WordPress)
- Using cloud services
Skill Level Beginner
1. Introduction to the Web
2. Front-End Technology
3. Back-End Technology
4. Assembly Technologies
Next steps2m 17s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.