Get to grips with SQL fundamentals and learn how to efficiently create, read and update information stored in databases Key Features Understand the features and syntax of SQL and use them to query databases Learn how to create databases and tables and manipulate the data within them Create advanced queries and apply them on realistic databases with hands-on activities Book DescriptionMany software applications are backed by powerful relational database systems, meaning that the skills to be able to maintain a SQL database ...
Read More
Get to grips with SQL fundamentals and learn how to efficiently create, read and update information stored in databases Key Features Understand the features and syntax of SQL and use them to query databases Learn how to create databases and tables and manipulate the data within them Create advanced queries and apply them on realistic databases with hands-on activities Book DescriptionMany software applications are backed by powerful relational database systems, meaning that the skills to be able to maintain a SQL database and reliably retrieve data are in high demand. With its simple syntax and effective data manipulation capabilities, SQL enables you to manage relational databases with ease. The SQL Workshop will help you progress from basic to advanced-level SQL queries in order to create and manage databases successfully. This Workshop begins with an introduction to basic CRUD commands and gives you an overview of the different data types in SQL. You'll use commands for narrowing down the search results within a database and learn about data retrieval from single and multiple tables in a single query. As you advance, you'll use aggregate functions to perform calculations on a set of values, and implement process automation using stored procedures, functions, and triggers. Finally, you'll secure your database against potential threats and use access control to keep your data safe. Throughout this Workshop, you'll use your skills on a realistic database for an online shop, preparing you for solving data problems in the real world. By the end of this book, you'll have built the knowledge, skills and confidence to creatively solve real-world data problems with SQL.What you will learn Create databases and insert data into them Use SQL queries to create, read, update, and delete data Maintain data integrity and consistency through normalization Customize your basic SQL queries to get the desired output Refine your database search using the WHERE and HAVING clauses Use joins to fetch data from multiple tables and create custom reports Improve web application performance by automating processes Secure a database with GRANT and REVOKE privileges Who this book is forThis Workshop is suitable for anyone who wants to learn how to use SQL to work with databases. No prior SQL or database experience is necessary. Whether you're an aspiring software developer, database engineer, data scientist, or systems administrator, this Workshop will quickly get you up and running.
Read Less
Add this copy of The SQL Workshop: Learn to create, manipulate and to cart. $34.08, like new condition, Sold by GreatBookPricesUK5 rated 5.0 out of 5 stars, ships from Castle Donington, DERBYSHIRE, UNITED KINGDOM, published 2019 by Packt Publishing Limited.
Choose your shipping method in Checkout. Costs may vary based on destination.
Seller's Description:
Fine. In Stock. 100% Money Back Guarantee. Brand New, Perfect Condition, allow 4-14 business days for standard shipping. To Alaska, Hawaii, U.S. protectorate, P.O. box, and APO/FPO addresses allow 4-28 business days for Standard shipping. No expedited shipping. All orders placed with expedited shipping will be cancelled. Over 3, 000, 000 happy customers.
Add this copy of The Sql Workshop: Learn to Create, Manipulate and to cart. $27.04, good condition, Sold by Dream Books Co. rated 5.0 out of 5 stars, ships from Denver, CO, UNITED STATES, published 2019 by Packt Publishing.
Choose your shipping method in Checkout. Costs may vary based on destination.
Seller's Description:
Good. Gently used with minimal wear on the corners and cover. A few pages may contain light highlighting or writing but the text remains fully legible. Dust jacket may be missing and supplemental materials like CDs or codes may not be included. May be ex-library with library markings. Ships promptly!
Add this copy of The Sql Workshop: Learn to Create, Manipulate and to cart. $27.15, good condition, Sold by Goodwill Indust. of San Diego rated 5.0 out of 5 stars, ships from San Diego, CA, UNITED STATES, published 2019 by Packt Publishing.
Choose your shipping method in Checkout. Costs may vary based on destination.
Seller's Description:
Good. You can tell this book has been read; any issues are minor to moderate. Can include shelf wear scuffs corner dings or edge curls. It stand lays flat. The majority of pages are undamaged with minimal creasing or markings. Used books do not often come with working access codes or accompanying discs.
Add this copy of The SQL Workshop: Learn to create, manipulate and to cart. $38.03, like new condition, Sold by GreatBookPrices rated 4.0 out of 5 stars, ships from Columbia, MD, UNITED STATES, published 2019 by Packt Publishing Limited.
Choose your shipping method in Checkout. Costs may vary based on destination.
Seller's Description:
Fine. In Stock. 100% Money Back Guarantee. Brand New, Perfect Condition, allow 4-14 business days for standard shipping. To Alaska, Hawaii, U.S. protectorate, P.O. box, and APO/FPO addresses allow 4-28 business days for Standard shipping. No expedited shipping. All orders placed with expedited shipping will be cancelled. Over 3, 000, 000 happy customers.
Add this copy of The Sql Workshop: Learn to Create, Manipulate and to cart. $63.37, good condition, Sold by Bonita rated 4.0 out of 5 stars, ships from Santa Clarita, CA, UNITED STATES, published 2019 by Packt Publishing.
