1 Before you begin

 

Nearly every act of our lives generates data. Every purchase we make, every mile we travel, and every internet link we click adds to a colossal amount of ever-growing data, which for many organizations has become their most valued asset. This data is often stored in a relational database, which keeps the data secure, scalable, and available to be constantly read and modified by innumerable users.

But how exactly can these users work with the data in a relational database? More important, how can you read and write data that is critical to your organization? The answer, and the subject of this book, is Structured Query Language, more commonly known as SQL.

1.1 Why SQL matters

Now, you may be wondering whether SQL is important enough for you to invest an entire month of lunches in it. Be assured that learning this language is undoubtedly one of the best skills anyone who uses data can acquire. Even though much of the data of our modern lives is stored in relational databases from different brands, such as Oracle, Microsoft, and IBM, nearly all use SQL to work with data and have been using it for quite some time.

1.2 Is this book for you?

 

1.2.1 The many uses for SQL

 
 

1.2.2 The many flavors of SQL

 
 
 

1.2.3 A word about AI and SQL

 
 
 
 

1.3 How to use this book

 
 
 

1.3.1 The main chapters

 
 

1.3.2 Hands-on labs

 
 

1.3.3 Further exploration

 
 
 

1.4 Setting up your lab environment

 
 

1.4.1 Installing MySQL and MySQL Workbench

 

1.4.2 Executing the lab scripts

 
 

1.5 Online resources

 
 
 

1.6 Being immediately effective with SQL

 
 
sitemap

Unable to load book!

The book could not be loaded.

(try again in a couple of minutes)

manning.com homepage