Muutke küpsiste eelistusi

E-raamat: SQL for Data Analysis: Advanced Techniques for Transforming Data into Insights

4.39/5 (63 hinnangut Goodreads-ist)
  • Formaat: EPUB+DRM
  • Ilmumisaeg: 09-Sep-2021
  • Kirjastus: O'Reilly Media
  • Keel: eng
  • ISBN-13: 9781492088738
Teised raamatud teemal:
  • Formaat - EPUB+DRM
  • Hind: 40,37 €*
  • * 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.
SQL for Data Analysis: Advanced Techniques for Transforming Data into InsightsSuurem pilt
  • Formaat: EPUB+DRM
  • Ilmumisaeg: 09-Sep-2021
  • Kirjastus: O'Reilly Media
  • Keel: eng
  • ISBN-13: 9781492088738
Teised raamatud teemal:

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. 

With the explosion of data, computing power, and cloud data warehouses, SQL has become an even more indispensable tool for the savvy analyst or data scientist. This practical book reveals new and hidden ways to improve your SQL skills, solve problems, and make the most of SQL as part of your workflow.

You'll learn how to use both common and exotic SQL functions such as joins, window functions, subqueries, and regular expressions in new, innovative ways--as well as how to combine SQL techniques to accomplish your goals faster, with understandable code. If you work with SQL databases, this is a must-have reference.

Learn the key steps for preparing your data for analysis Perform time series analysis using SQL's date and time manipulations Use cohort analysis to investigate how groups change over time Use SQL's powerful functions and operators for text analysis Detect outliers in your data and replace them with alternate values Establish causality using experiment analysis, also known as A/B testing
About the Authors xiii
About the Technical Reviewer xv
Acknowledgments xvii
Introduction: The Mixed Reality Future xix
Part I: Getting Started 1(54)
Chapter 1 Gear Up: The Necessary Hardware and Software Tools
3(26)
Making Sure Your PC Is Ready
3(2)
Understanding the HoloLens and Other Windows Mixed Reality Hardware
5(5)
Inside-Out Tracking and Spatial Mapping
6(2)
Spatial Sound
8(1)
Transparent vs. Immersive Headsets
8(2)
Downloading and Installing the Required and Optional Software Tools
10(17)
Installing Visual Studio
11(4)
Installing Unity
15(9)
Downloading the Mixed Reality Toolkit
24(3)
Summary
27(2)
Chapter 2 Unity Crash Course
29(26)
What Is Unity?
29(1)
Free vs. Paid Tiers of Unity
30(1)
Your First Unity App
30(24)
Step 1: Create a New Unity Project
31(3)
Step 2: Save Your Scene
34(1)
Step 3: Create a Ground Plane
35(2)
Step 4: Rename Your Plane
37(1)
Step 5: Reset Ground Plane Position
38(1)
Step 6: Zoom to Your Ground Plane
38(1)
Step 7: Scale Your Ground Plane
39(1)
Step 8: Create the Ball
40(1)
Step 9: Rename Your Ball
41(1)
Step 10: Reset the Ball's Position
41(1)
Step 11: Zoom to Your Ball
42(1)
Step 12: Raise the Ball's Position
42(1)
Step 13: Color the Ground Blue
42(5)
Step 14: Add Physics to the Ball
47(1)
Step 15: Enable Keyboard Control
48(5)
Step 16: Testing Your App
53(1)
Summary
54(1)
Part II: Building Holographic Experiences 55(118)
Chapter 3 Creating Your First Hologram
57(28)
Getting Unity Ready for Mixed Reality Development
57(11)
Step 1: Import Mixed Reality Toolkit to a New Unity Project
58(3)
Step 2: Use Mixed Reality Toolkit to Prepare Your Scene for Mixed Reality Development
61(7)
Your First Hologram
68(16)
Step 1: Create a Cube
69(1)
Step 2: Zoom to Your Cube
70(1)
Step 3: Move the Cube Away from the Camera
70(1)
Step 4: Resize the Cube
71(1)
Step
5. Test Your App
72(1)
Step 6: Install Your App on the HoloLens
73(11)
Summary
84(1)
Chapter 4 Introduction to the Mixed Reality Toolkit
85(26)
What Is the Mixed Reality Toolkit?
85(1)
The Three MRTK Repositories
86(1)
Mixed Reality Toolkit Setup
86(6)
1. Importing MRTK Asset Files
86(3)
2. Unity Package Manager
89(3)
Mixed Reality Toolkit Components
92(17)
MRTK: Input System
94(3)
MRTK: Hand Tracking
97(1)
MRTK: Solvers
98(2)
MRTK: Multi-scene Manager
100(2)
MRTK: Spatial Awareness
102(1)
MRTK: Diagnostic Tool
103(1)
MRTK: Boundary System
103(1)
MRTK: UX Controls
104(1)
MRTK: Camera System
105(1)
MRTK: Profiles
106(3)
MRTK: Standard Shader
109(1)
MRTK Online
109(1)
What Is GitHub?
109(1)
MRTK Help and Documentation
109(1)
Summary
110(1)
Chapter 5 Interacting with Holograms
111(34)
Input Methods
111(1)
Gaze Tutorial
112(8)
Step 1: Set Up Unity Scene
113(1)
Step 2: Add Scenes to the Build Menu
114(1)
Step 3: Try the Scene
114(2)
Step 4: Understanding the Scene
116(4)
Step 5: Use Gaze in Your Project
120(1)
Gestures Tutorial
120(11)
Step
1. Load Test Scene
120(1)
Step
2. Try It Out,
121(1)
Step
3. Bounds Control
122(4)
Step 4: Press and Touch Interactions
126(2)
Step 5: Object Manipulator
128(3)
Step 6: Implementing Gestures in Your Application
131(1)
Voice Command Tutorial
131(11)
Step 1: Load the Example Scene
132(1)
Step
2. Try It Out!
133(1)
Step 3: Understanding the Scene
134(3)
Step 4: Add Your Own Voice Command
137(3)
Step 5: Using Voice Commands in Your Own Project
140(1)
Best Practices for Voice Commands
141(1)
Other Hardware Input
142(1)
Summary
143(2)
Chapter 6 Using Spatial Awareness
145(12)
What Is Spatial Awareness?
145(1)
Spatial Awareness Tutorial
146(6)
Step 1: Set Up Unity Scene
146(1)
Step
2. Try It Out!
147(1)
Step
3. Understanding the Scene
148(2)
Step
4. Using Spatial Mapping in Your Application
150(2)
Occlusion
152(2)
Step 1: Apply Occlusion
152(1)
Step 2: Try It Out!
153(1)
Scene Understanding
154(1)
Summary
155(2)
Chapter 7 Spatial Sound
157(16)
Spatial Sound Tutorial
158(12)
Step 1: Set Up Unity Scene
158(1)
Step 2: Try It Out!
159(2)
Step 3: Understanding the Scene
161(4)
Step 4: Enabling Spatial Sound in Your Application
165(5)
Spatial Sound Design Considerations
170(1)
When to Use Spatial Sound
170(1)
What to Avoid When Using Spatial Sound
171(1)
Summary
171(2)
Part III: Growing As a Holographic Developer 173(100)
Chapter 8 Azure Spatial Anchors
175(14)
What Is Azure Spatial Anchors?
175(1)
Azure Spatial Anchors Tutorial
176(12)
Step 1: Creating new Unity Scene
176(1)
Step 2: Installing Inbuilt Unity Packages
176(1)
Step 3: Download and Import Tutorial Assets
177(1)
Step 4: Preparing the Scene
178(1)
Step 5: Configuring the Buttons to Operate the Scene
179(7)
Step 6: Connecting the Scene to the Azure Resource
186(1)
Step 7: Test the Application in Device
187(1)
Summary
188(1)
Chapter 9 Shared Experiences
189(30)
What Are Shared Experiences?
189(1)
Multiuser Capabilities Tutorial
189(1)
Setting Up Photon Unity Networking
189(10)
Step 1: Creating New Unity Scene
190(1)
Step 2: Enabling Additional Capabilities
190(1)
Step 3: Installing Inbuilt Unity Packages
191(1)
Step 4: Importing the Tutorial Assets
192(1)
Step 5: Importing the PUN Assets
193(2)
Step 6: Creating the PUN Application
195(1)
Step 7: Connecting the Unity Project to the PUN Application
196(3)
Connecting Multiple Users
199(8)
Step 1: Preparing the Scene
199(2)
Step 2: Create and Configure the User
201(2)
Step 3: Create the Avatar
203(1)
Step 4: Create the Prefab
204(2)
Step 5: Configuring PUN to Instantiate the User Prefab
206(1)
Sharing Object Movements with Multiple Users
207(2)
Step 1: Preparing the Scene
207(1)
Step 2: Configuring PUN to Instantiate the Objects
207(2)
Integrating Azure Spatial Anchors into a Shared Experience
209(8)
Step 1: Preparing the Scene
210(1)
Step 2: Configuring the Buttons to Operate the Scene
210(4)
Step 3: Connecting the Scene to the Azure Resource
214(3)
Trying the Experience with Spatial Alignment
217(1)
Summary
218(1)
Chapter 10 Awe-Inspiring Experiences
219(30)
What Makes an App Awe Inspiring?
219(1)
Optimization and Performance
220(16)
How to Monitor for Performance
222(2)
Best Practices for Performance
224(8)
Simplygon
232(1)
Stabilization Plane
233(3)
Design and Magic
236(11)
Best Practices for Design
237(6)
Adding Magic: Vuforia
243(4)
Summary
247(2)
Chapter 11 Turning Holograms into Money
249(8)
Publishing Your App to the Microsoft Store
250(1)
Freelancing and Contracts
251(3)
Where to Find Mixed Reality Freelance Opportunities
252(1)
Increasing Your Chances of Winning a Contract
253(1)
Future Opportunities Today
254(1)
Summary
254(3)
Chapter 12 Community Resources
257(16)
HoloDevelopers Slack Team
257(3)
What Is Slack?
257(1)
What Is the HoloDevelopers Slack Team
258(1)
How to Join the HoloDevelopers Slack Team
259(1)
Participating in the HoloDevelopers Slack Team
260(1)
Other Online Communities and Resources
260(5)
HoloLens Developers Facebook Group
261(1)
Unity and Unity HoloLens Forum
262(1)
HoloLens Subreddit
263(1)
Next Reality News
264(1)
YouTube
265(1)
Local Events and Meetups
265(4)
Europe Meetups
266(1)
North America Meetups
267(1)
Asia Pacific Meetups
268(1)
Hackathons
269(1)
Notable Industry Events
270(1)
Summary
271(2)
Index 273
Cathy Tanimura has a passion for connecting people and organizations to the data they need to make an impact. She has been analyzing data for over 20 years across a wide range of industries, from finance to B2B software to consumer services. She has experience analyzing data with SQL across most of the major proprietary and open source databases. She has built and managed data teams and data infrastructure at a number of leading tech companies. Cathy is also a frequent speaker at top conferences, on topics including building data cultures, data-driven product development, and inclusive data analys
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97814920887386e.html
Märksõnad: