Description
Businesses are gathering data today at exponential rates and yet few people understand how to get admission to it meaningfully. If you’re a business or IT professional, this short hands-on guide teaches you the best way to pull and turn into data with SQL in significant ways. You’ll quickly master the fundamentals of SQL and learn to create your own databases.
Author Thomas Nield provides exercises right through the book that can assist you practice your newfound SQL skills at home, with no need to use a database server environment. Not only will you learn to use key SQL statements to find and manipulate your data, but you’ll also discover the best way to efficiently design and manage databases to meet your needs.
You’ll also learn to:
- Explore relational databases, including lightweight and centralized models
- Use SQLite and SQLiteStudio to create lightweight databases in minutes
- Query and turn into data in meaningful ways by the use of SELECT, WHERE, GROUP BY, and ORDER BY
- Join tables to get a more complete view of your business data
- Build your own tables and centralized databases by the use of normalized design principles
- Manage data by learning the best way to INSERT, DELETE, and UPDATE records