Chapter 13: SQL Basics
Welcome to Chapter 13, "SQL Basics". In this chapter, we dive into the specifics of SQL's data definition language (DDL) and data manipulation language (DML), with an emphasis on hands-on exercises. You'll learn about creating databases, defining tables, populating them with data, and running basic queries to extract valuable insights.
In addition to the practical skills mentioned above, the chapter will also cover some important theoretical concepts related to SQL. We will explore normalization, which is the process of organizing data in a database to reduce redundancy and dependency. This will help you design more efficient and scalable databases that can handle large amounts of data.
Moreover, we will examine the concept ...
Get Python and SQL Bible now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
