Businesses are gathering data today at exponential rates and yet few people know how to access it meaningfully. If you're a business or IT professional, this short hands-on guide teaches you how to pull and transform data with SQL in significant ways. You will quickly master the fundamentals of SQL and learn how to create your own databases.

Author Thomas Nield provides exercises throughout the book to help you practice your newfound SQL skills at home, without having to use a database server environment. Not only will you learn how to use key SQL statements to find and manipulate your data, but you'll also discover how to efficiently design and manage databases to meet your needs.

You'll also learn how to:

Explore relational databases, including lightweight and centralized models
Use SQLite and SQLiteStudio to create lightweight databases in minutes
Query and transform data in meaningful ways by using 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 using normalized design principles
Manage data by learning how to INSERT, DELETE, and UPDATE records

�ber die Autorin bzw. den Autor

Thomas Nield has a business analyst background and works in Revenue Management at Southwest Airlines. Early in his career he became fascinated with technology and bought dozens of books to master programming in Java, C#, and database design. He is passionate about sharing what he learns and enabling others with new skillsets, even if they do not work in IT. He enjoys making technical content relatable and relevant to those unfamiliar or intimidated by it.

��ber diesen Titel� kann sich auf eine andere Ausgabe dieses Titels beziehen.

Anbieterinformationen

Kennys.ie is the largest exporter of books from Ireland currently exporting to approximately 100 countries around the world. Kennys Bookshop houses hundreds of thousands of books and specialises in collection development and library services, supplying booksellers and state and university libraries on a global scale including the U.S.A.,Japan and Europe. Kennys.ie is Ireland's Largest Online Bookshop.

Zur Homepage des Verk�ufers