Frank Solomon - The SQL Workshop: A New, Interactive Approach to Learning SQL
Here you can read online Frank Solomon - The SQL Workshop: A New, Interactive Approach to Learning SQL full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2019, publisher: Packt Publishing, genre: Home and family. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:
Romance novel
Science fiction
Adventure
Detective
Science
History
Home and family
Prose
Art
Politics
Computer
Non-fiction
Religion
Business
Children
Humor
Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.
- Book:The SQL Workshop: A New, Interactive Approach to Learning SQL
- Author:
- Publisher:Packt Publishing
- Genre:
- Year:2019
- Rating:3 / 5
- Favourites:Add to favourites
- Your mark:
The SQL Workshop: A New, Interactive Approach to Learning SQL: summary, description and annotation
We offer to read an annotation, description, summary or preface (depends on what the author of the book "The SQL Workshop: A New, Interactive Approach to Learning SQL" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.
Cut through the noise and get real results with a step-by-step approach to learning SQL
Key Features- A structured, straightforward introduction to SQL for beginners
- A SQL tutorial with step-by-step exercises and activities that help build key skills
- Structured to let you progress at your own pace, on your own terms
- Use your physical print copy to redeem free access to the online interactive edition
You already know you want to learn SQL, and the best way to learn SQL is to learn by doing. The SQL Workshop focuses on building up your SQL database management skills so that you can easily store and retrieve data or become the in-house expert on complex queries. Youll learn from real examples that lead to real results.
Throughout The SQL Workshop, youll take an engaging step-by-step approach to understanding SQL programming. You wont have to sit through any unnecessary theory. If youre short on time you can jump into a single exercise each day or spend an entire weekend learning how to create functions and stored procedures. Its your choice. Learning on your terms, youll build up and reinforce key skills in a way that feels rewarding.
Every physical print copy of The SQL Workshop unlocks access to the interactive edition. With videos detailing all exercises and activities, youll always have a guided solution. You can also benchmark yourself against assessments, track progress, and receive content updates. Youll even earn a secure credential that you can share and verify online upon completion. Its a premium learning experience thats included with your printed copy. To redeem, follow the instructions located at the start of your book.
Fast-paced and direct, The SQL Workshop is the ideal companion for SQL beginners. Youll build and iterate on your code like a software developer, learning along the way. This process means that youll find that your new skills stick, embedded as best practice. A solid foundation for the years ahead.
What you will learn- Learn how to create normalized databases
- Explore how to insert data into tables efficiently
- Explore various techniques to retrieve data from multiple tables
- Build advanced queries using techniques like subqueries and views
- Learn advanced SQL programming techniques such as functions and triggers
Our goal at Packt is to help you be successful, in whatever it is you choose to do. The SQL Workshop is an ideal SQL tutorial for the SQL beginner who is just getting started. Pick up a Workshop today, and let Packt help you develop skills that stick with you for life.
Table of Contents- Introduction to SQL
- Manipulating Data
- Database Normalization
- The SELECT Statement
- Shaping Data with the WHERE Clause
- JOINS
- Taking Queries to the Next Level
- SQL Programming
- Security
- Aggregate Functions
- Functions and Transactions
Frank Solomon: author's other books
Who wrote The SQL Workshop: A New, Interactive Approach to Learning SQL? Find out the surname, the name of the author of the book and a list of all author's works by series.
The SQL Workshop: A New, Interactive Approach to Learning SQL — read online for free the complete book (whole text) full work
Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "The SQL Workshop: A New, Interactive Approach to Learning SQL" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.
Font size:
Interval:
Bookmark:
A New, Interactive Approach to Learning SQL
Frank Solomon
Prashanth Jayaram
Awni Al Saqqa
Copyright 2019 Packt Publishing
All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.
Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the authors, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.
Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.
Authors: Frank Solomon, Prashanth Jayaram, and Awni Al Saqqa
Reviewers: Tor Harrington, Pradeep Kumar Gupta, Aaditya Pokkunuri, Shubham Jain, Fiodar Sazanavets, Shashikant Shakya, and Trevoir Williams
Managing Editor: Manasa Kumar
Acquisitions Editors: Alicia Wooding and Karan Wadekar
Production Editor: Salma Patel
Editorial Board: Shubhopriya Banerjee, Bharat Botle, Ewan Buckingham, Megan Carlisle, Mahesh Dhyani, Manasa Kumar, Alex Mazonowicz, Bridget Neale, Dominic Pereira, Shiny Poojary, Abhishek Rane, Brendan Rodrigues, Mugdha Sawarkar, Erol Staveley, Ankita Thakur, Nitesh Thakur, and Jonathan Wray.
First published: December 2019
Production reference: 1271219
ISBN 978-1-83864-235-8
Published by Packt Publishing Ltd.
Livery Place, 35 Livery Street
Birmingham B3 2PB, UK
This section briefly introduces the coverage of this book, the technical skills you'll need to get started, and the software requirements required to complete all of the included activities and exercises.
You already know you want to learn SQL, and the best way to learn SQL is to learn by doing. The SQL Workshop focuses on building up your SQL database management skills so that you can easily store and retrieve data, connect your database to a web application, or become the in-house expert on complex SQL queries. You'll learn from real examples that lead to real results.
Throughout The SQL Workshop, you'll take an engaging step-by-step approach to understanding SQL programming. You won't have to sit through any unnecessary theory. If you're short on time you can jump into a single exercise each day or spend an entire weekend learning how to secure your database from malicious users and attackers. It's your choice. Learning on your terms, you'll build up and reinforce key skills in a way that feels rewarding.
Every physical print copy of The SQL Workshop unlocks access to the interactive edition. With videos detailing all exercises and activities, you'll always have a guided solution. You can also benchmark yourself against assessments, track progress, and receive content updates. You'll even earn a secure credential that you can share and verify online upon completion. It's a premium learning experience that's included with your printed copy. To redeem, follow the instructions located at the start of your book.
Fast-paced and direct, The SQL Workshop is the ideal companion for SQL beginners. You'll build and iterate on your code like a software developer, learning along the way. This process means that you'll find that your new skills stick, embedded as best practice. A solid foundation for the years ahead.
Chapter 1, SQL Basics, explains how to create a simple database and how to create tables within databases. We will also learn how to populate data within a table.
Font size:
Interval:
Bookmark:
Similar books «The SQL Workshop: A New, Interactive Approach to Learning SQL»
Look at similar books to The SQL Workshop: A New, Interactive Approach to Learning SQL. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.
Discussion, reviews of the book The SQL Workshop: A New, Interactive Approach to Learning SQL and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.