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)
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
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..
|
Email address subscribed successfully.
A activation email has been sent to you.
Please click the link in that email to activate your subscription.