In order to work with the data on the back-end, web developers need to be familiar with a separate language that let's their code ask, or query, databases for information. Depending on where you are in the front-end/back-end spectrum, you'll need to know how to access the data and include it through a server side language into your layouts. Get some experience working with SQL as well as one of the document store database systems.
- In order to work with data on the back-end, web developers need to be familiar with a separate language that lets their code ask or query databases for information. Depending on where you work in the stack, you'll need to know how to access data and include it through a server side language in your layout. Now thankfully, there's a bit of standardization in this environment. Most servers use a variant of a Relational DataBase Management System, or RDBMS called Sequel, or SQL. This language works by creating a series of tables, like Excel spreadsheets, with different fields, which can link together to create relationships between the data.
That's why these are called relational. The most popular implementations are Oracle, MySQL, MS SQL, and PostGresQL. Take a look at Foundations of Programming: Data Structures, for a deeper look at the ways that computer programs store data internally. However, like with many things about web development, there are other popular ideas. One of the biggest is NoSQL. Whereas SQL encourages developers to separate data into different tables, NoSQL allows records with no specific structure.
This is a very different way of doing things but it's popular in database languages, like Google's Big Table, which powers things like their search engine, Google analytics, maps, and Gmail. Sometimes these languages are referred to as document stores because they're great for storing large documents. If you want to learn to create a web application with a NoSQL structure, take a look at AngularJS 1: Building a Data-Driven App. It uses a NoSQL database called Firebase from Google.
Other popular NoSQL languages include MongoDB, Couch Base, and Couch DB. Now there are other ideas out there, like wide column stores and key value stores, but learning at least the Sequel RDBDMS, as well as one of the NoSQL platforms will give you a great overview of the options.
- Types of web developers
- Servers and databases
- Getting web development training
- Choosing the right tools
- Getting a job