0
Your cart

Your cart is empty

Books > Computing & IT > Computer programming

Buy Now

The The SQL Workshop - Learn to create, manipulate and secure data and manage relational databases with SQL (Paperback) Loot Price: R909
Discovery Miles 9 090
The The SQL Workshop - Learn to create, manipulate and secure data and manage relational databases with SQL (Paperback): Frank...

The The SQL Workshop - Learn to create, manipulate and secure data and manage relational databases with SQL (Paperback)

Frank Solomon, Prashanth Jayaram, Awni Al Saqqa

 (sign in to rate)
Loot Price R909 Discovery Miles 9 090 | Repayment Terms: R85 pm x 12*

Bookmark and Share

Expected to ship within 10 - 15 working days

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.

General

Imprint: Packt Publishing Limited
Country of origin: United Kingdom
Release date: December 2019
Authors: Frank Solomon • Prashanth Jayaram • Awni Al Saqqa
Dimensions: 93 x 75 x 20mm (L x W x T)
Format: Paperback
Pages: 288
ISBN-13: 978-1-83864-235-8
Categories: Books > Computing & IT > Computer hardware & operating systems > General
Books > Computing & IT > Computer programming > General
Books > Computing & IT > Applications of computing > Databases > General
Promotions
LSN: 1-83864-235-8
Barcode: 9781838642358

Is the information for this product incomplete, wrong or inappropriate? Let us know about it.

Does this product have an incorrect or missing image? Send us a new image.

Is this product missing categories? Add more categories.

Review This Product

No reviews yet - be the first to create one!

You might also like..

Problem Solving with C++ - Global…
Walter Savitch Paperback R2,551 Discovery Miles 25 510
Programming Logic & Design
Joyce Farrell Paperback R800 Discovery Miles 8 000
C++ Programming - Program Design…
D. Malik Paperback R1,751 R1,615 Discovery Miles 16 150
Program Construction - Calculating…
Roland Backhouse Paperback R1,467 Discovery Miles 14 670
Programming Logic & Design…
Joyce Farrell Paperback R1,336 R1,239 Discovery Miles 12 390
C++ How to Program: Horizon Edition
Harvey Deitel, Paul Deitel Paperback R1,917 Discovery Miles 19 170
Dark Silicon and Future On-chip Systems…
Suyel Namasudra, Hamid Sarbazi-Azad Hardcover R4,186 Discovery Miles 41 860
Temporal Data Mining via Unsupervised…
Yun Yang Paperback R1,242 Discovery Miles 12 420
Starting Out with Python, Global Edition
Tony Gaddis Paperback R2,592 R2,367 Discovery Miles 23 670
News Search, Blogs and Feeds - A Toolkit
Lars Vage, Lars Iselid Paperback R1,412 Discovery Miles 14 120
Essential Java for Scientists and…
Brian Hahn, Katherine Malan Paperback R1,341 Discovery Miles 13 410
FORTRAN 90 for Scientists and Engineers
Brian Hahn Paperback R1,440 Discovery Miles 14 400

See more

Partners