Search Results

The The SQL Workshop

Download or Read eBook The The SQL Workshop PDF written by Frank Solomon and published by Packt Publishing Ltd. This book was released on 2019-12-30 with total page 287 pages. Available in PDF, EPUB and Kindle.
The The SQL Workshop
Author :
Publisher : Packt Publishing Ltd
Total Pages : 287
Release :
ISBN-10 : 9781838649081
ISBN-13 : 1838649085
Rating : 4/5 (81 Downloads)

Book Synopsis The The SQL Workshop by : Frank Solomon

Book excerpt: Get to grips with SQL fundamentals and learn how to efficiently create, read and update information stored in databases Key FeaturesUnderstand the features and syntax of SQL and use them to query databasesLearn how to create databases and tables and manipulate the data within themCreate advanced queries and apply them on realistic databases with hands-on activitiesBook Description Many 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 learnCreate databases and insert data into themUse SQL queries to create, read, update, and delete dataMaintain data integrity and consistency through normalizationCustomize your basic SQL queries to get the desired outputRefine your database search using the WHERE and HAVING clausesUse joins to fetch data from multiple tables and create custom reportsImprove web application performance by automating processesSecure a database with GRANT and REVOKE privilegesWho this book is for This 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.


The The SQL Workshop Related Books

The The SQL Workshop
Language: en
Pages: 287
Authors: Frank Solomon
Categories: Computers
Type: BOOK - Published: 2019-12-30 - Publisher: Packt Publishing Ltd

DOWNLOAD EBOOK

Get to grips with SQL fundamentals and learn how to efficiently create, read and update information stored in databases Key FeaturesUnderstand the features and
Learning SQL
Language: en
Pages: 338
Authors: Alan Beaulieu
Categories: Computers
Type: BOOK - Published: 2009-04-11 - Publisher: O'Reilly Media

DOWNLOAD EBOOK

Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you u
SQL Practice Problems
Language: en
Pages: 118
Authors: Sylvia Moestl Vasilik
Categories:
Type: BOOK - Published: 2016-11-09 - Publisher: Createspace Independent Publishing Platform

DOWNLOAD EBOOK

Real-world practice problems to bring your SQL skills to the next level It's easy to find basic SQL syntax and keyword information online. What's hard to find i
Practical SQL, 2nd Edition
Language: en
Pages: 466
Authors: Anthony DeBarros
Categories: Computers
Type: BOOK - Published: 2022-01-25 - Publisher: No Starch Press

DOWNLOAD EBOOK

Analyze data like a pro, even if you’re a beginner. Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard pro
Sams Teach Yourself SQL in 24 Hours
Language: en
Pages: 540
Authors: Ryan Stephens
Categories: Computers
Type: BOOK - Published: 2008-05-30 - Publisher: Sams Publishing

DOWNLOAD EBOOK

In just 24 lessons of one hour or less, you will learn professional techniques to design and build efficient databases and query them to extract useful informat
Scroll to top