Summary
In this chapter, we had a hands-on overview of SQL and NoSQL databases. We looked into their usage, their best practices, and even various strategies to achieve near-perfect latency.
We learned about how to create a table, insert the data into a table, and how to select data from a table in various databases. Furthermore, we have explored complex aggregation over data, along with the resulting visualizations through sample data analytics.
Understanding the different types of databases and their evolutions, along with the various types of query languages and data modeling from this chapter, will help you to get to grips with the essence of big data file formats in the coming chapters. To start with big data, you will need to learn about the use of file formats. Such concepts can be assimilated by understanding the nitty-gritty of databases.
In the next chapter, you will learn about big data file formatting, along with compression, partitioning, and read-write strategy...