Muutke küpsiste eelistusi

E-raamat: SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL

  • Formaat: EPUB+DRM
  • Ilmumisaeg: 19-Nov-2019
  • Kirjastus: ClydeBank Media LLC
  • Keel: eng
  • ISBN-13: 9781945051838
  • Formaat - EPUB+DRM
  • Hind: 11,69 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
  • Formaat: EPUB+DRM
  • Ilmumisaeg: 19-Nov-2019
  • Kirjastus: ClydeBank Media LLC
  • Keel: eng
  • ISBN-13: 9781945051838

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

"THE BEST SQL BOOK FOR BEGINNERS IN 2020 - HANDS DOWN!" *INCLUDES FREE ACCESS TO A SAMPLE DATABASE, SQL BROWSER APP, COMPREHENSION QUIZES & SEVERAL OTHER DIGITAL RESOURCES!* Not sure how to prepare for the data-driven future? This book shows you EXACTLY what you need to know to successfully use the SQL programming language to enhance your career! Are you a developer who wants to expand your mastery to database management? Then you NEED this book. Buy now and start reading today! Are you a project manager who needs to better understand your development team’s needs? A decision maker who needs to make deeper data-driven analysis? Everything you need to know is included in these pages! The ubiquity of big data means that now more than ever there is a burning need to warehouse, access, and understand the contents of massive databases quickly and efficiently.That’s where SQL comes in.SQL is the workhorse programming language that forms the backbone of modern data management and interpretation.Any database management professional will tell you that despite trendy data management languages that come and go, SQL remains the most widely used and most reliable to date, with no signs of stopping. In this comprehensive guide, experienced mentor and SQL expert Walter Shields draws on his considerable knowledge to make the topic of relational database management accessible, easy to understand, and highly actionable.SQL QuickStart Guide is ideal for those seeking to increase their job prospects and enhance their careers, for developers looking to expand their programming capabilities, or for anyone who wants to take advantage of our inevitably data-driven future—even with no prior coding experience! SQL QuickStart Guide is Perfect For: - Professionals looking to augment their job skills in preparation for a data-driven future - Job seekers who want to pad their skills and resume for a durable employability edge - Beginners with zero prior experience - Managers, decision makers, and business owners looking to manage data-driven business insights - Developers looking to expand their mastery beyond the full stack - Anyone who wants to be better prepared for our data-driven future! In SQL QuickStart Guide You’ll Discover: - The basic structure of databases—what they are, how they work, and how to successfully navigate them - How to use SQL to retrieve and understand data no matter the scale of a database (aided by numerous images and examples) - The most important SQL queries, along with how and when to use them for best effect Professional applications of SQL and how to “sell” your new SQL skills to your employer, along with other career-enhancing considerations *LIFETIME ACCESS TO FREE SQL RESOURCES*: Each book comes with free lifetime access to tons of exclusive online resources to help you master SQL, such as workbooks, cheat sheets and reference guides.

The complete beginner's guide to SQL. SQL QuickStart Guide is ideal for those seeking to increase their job prospects and enhance their careers, for developers looking to expand their programming capabilities, or for anyone who wants to take advantage of our inevitably data-driven future—even with no prior coding experience! Author Walter Shields has worked with SQL and databases for over eighteen years, helping organizations such as Target Corporation, Anthem and the NYC Transit Authority.
Introduction 1(12)
My Story
3(1)
Why I Wrote This Book
4(1)
A Word of Encouragement for the Pure Beginner
5(1)
The Scope and Focus of This Book
5(1)
SQL and Your Career
6(2)
Chapter by
Chapter
8(5)
PART I CREATING YOUR SQL LEARNING ENVIRONMENT
1 Understanding Database Structure
13(20)
Fundamental Terminology
13(3)
Fundamental Elements of Relational Databases
16(7)
Types of Data
23(4)
Relational Database Management Systems
27(1)
The SELECT Statement
28(1)
Queries, Statements, Clauses, and Keywords
29(1)
Introducing SQLite
30(3)
2 SQL Tools And Strategies
33(6)
Introducing the sTunes Database
33(1)
Introducing DB Browser for SQLite
34(1)
Installing DB Browser for SQLite
34(1)
How to Test Your SQL Knowledge
34(1)
Strategies for Success
35(4)
3 Exploring A Database In Sqlite
39(12)
Environment Orientation
39(1)
Opening the sTunes Database
40(1)
Investigating the Structure of the Database
41(1)
Viewing the Individual Records
42(1)
The Execute SQL Tab
43(2)
Data Analysis Checkpoint
45(6)
PART II WRITING SQL STATEMENTS
4 Getting Started With Queries
51(14)
Adding Comments to Queries
51(1)
The Structure of a Basic Query
52(1)
Start Writing Your Query
53(3)
Coding Syntax Versus Coding Convention
56(1)
Adding an Alias to Your Columns
57(1)
Using the ORDER BY Clause
58(3)
Selecting the Top Ten Records Using LIMIT
61(1)
Data Analysis Checkpoint
62(3)
5 Turning Data Into Information
65(26)
Comparison, Logical, and Arithmetic Operators
66(1)
Filtering Records by Numbers with the WHERE Clause
67(5)
Filtering Records by Text
72(2)
Using the LIKE Operator to Search for Wildcards
74(3)
Filtering Records by Date
77(1)
The DATE () Function
78(1)
Using the AND and OR Operators with Two Separate Fields
79(1)
The OR Operator
80(1)
Using Parentheses with AND and OR to Specify the Order of Operations
81(3)
The CASE Statement
84(5)
Data Analysis Checkpoint
89(2)
6 Working With Multiple Tables
91(24)
What Are Joins?
91(3)
How Joins Interact with Relational Database Structure
94(1)
Using Joins with an Alias
95(3)
Join Types and Their Differences
98(7)
Inner Joins with More Than Two Tables
105(3)
Using Left Outer Joins with NULL, IS, and NOT
108(3)
Turning a Right Join into a Left Join
111(2)
Data Analysis Checkpoint
113(2)
7 Using Functions
115(30)
Adding Calculations to Your Queries
115(1)
Types of Functions in SQL
116(2)
Manipulating Text Data with String Functions
118(2)
Concatenating Strings of Text
120(2)
Truncating Text
122(3)
Additional String Functions
125(2)
Date Functions
127(4)
Aggregate Functions
131(1)
Nesting Functions with the ROUND () Function
132(1)
Using Aggregate Functions with the GROUP BY Clause
133(2)
Using the WHERE and HAVING Clauses with Grouped Queries
135(3)
The WHERE Clause Versus the HAVING Clause
138(1)
Using GROUP BY with Multiple Fields
139(1)
A Final Word on Functions
140(1)
Data Analysis Checkpoint
140(5)
PART III MORE ADVANCED SQL TOPICS
8 Subqueries
145(12)
Introduction to Subqueries Using Aggregate Functions
145(2)
Using a Subquery in the SELECT Statement
147(2)
Using a WHERE Clause in a Subquery
149(1)
Subqueries without Aggregate Functions
150(1)
Returning Multiple Values from a Subquery
151(1)
Subqueries and the DISTINCT Clause
152(3)
Data Analysis Checkpoint
155(2)
9 Views
157(10)
Turning Previous Queries into Views
157(2)
Why We Use Views
159(1)
How to Modify a View
160(1)
Creating a View from Joins
160(3)
Removing a View Using the DROP Statement
163(1)
Data Analysis Checkpoint
164(3)
10 Data Manipulation Language (DML)
167(8)
Data Analysis Versus Database Management
167(1)
Inserting Data into a Database
168(3)
Updating Data and the SET Keyword
171(1)
Deleting Data
172(1)
Data Analysis Checkpoint
173(2)
Conclusion
175(8)
It Is All About Asking Good Questions
175(1)
Finding Your Niche
175(1)
Choosing the Right Database Occupation
176(1)
Is It All about the Money?
176(1)
Is SQL Knowledge Universal?
177(1)
Switching Careers
178(1)
Selling Your New Skills to Your Company
178(1)
Beyond SQL: Data Visualization Software
179(1)
Interview Advice
179(1)
SQL Certifications
180(1)
Final Thoughts and Parting Words
180(3)
Appendix I
183(20)
Chapter 3 Data Analysis Checkpoint
183(1)
Chapter 4 Data Analysis Checkpoint
184(3)
Chapter 5 Data Analysis Checkpoint
187(3)
Chapter 6 Data Analysis Checkpoint
190(1)
Chapter 7 Data Analysis Checkpoint
191(2)
Chapter 8 Data Analysis Checkpoint
193(4)
Chapter 9 Data Analysis Checkpoint
197(2)
Chapter 10 Data Analysis Checkpoint
199(4)
Appendix II
203(10)
Chapter 4 Keywords
203(1)
Chapter 5 Keywords
203(3)
Chapter 6 Keywords
206(1)
Chapter 7 Keywords
207(1)
Chapter 8 Keywords
208(1)
Chapter 9 Keywords
209(1)
Chapter 10 Keywords
209(4)
About The Author 213(2)
About Clydebank Media 215(2)
Glossary 217(4)
References 221(2)
Index 223