SQL Short Course (Database Programming)

Questing Vole Press
8
Free sample

Get up to speed fast with SQL, the language of databases. Bestselling author Chris Fehily teaches you just the parts of SQL that you need to know. Quick, learn-by-example lessons start with simple data retrieval and sorting, move on to filtering and grouping, and then build to more-advanced topics, including joins, subqueries, views, and transactions. Whether you're an analyst, developer, data scientist, or Microsoft Office user, you'll find straightforward, practical answers. You can download the sample database to follow along with the examples.


- Covers Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, and Microsoft Access.

- Learn the core language for standard SQL, and variations for the most widely used database systems.

- Organize your database in terms of the relational model.

- Master tables, columns, rows, and keys.

- Retrieve, sort, and format data.

- Filter the data that you don't want to see.

- Convert and manipulate data with SQL's built-in functions and operators.

- Use aggregate functions to summarize data.

- Create complex SQL statements by using joins, subqueries, constraints, conditional logic, and metadata.

- Create, alter, and drop tables, indexes, and views.

- Insert, update, delete, and merge data.

- Execute transactions to maintain the integrity of your data.

- Avoid common pitfalls involving nulls.

- Troubleshoot and optimize queries.

- Plenty of tips, tricks, and timesavers.

- Fully cross-referenced, linked, and searchable.


Contents

1. Introduction

2. Database Basics

3. SQL Basics

4. Retrieving Data from a Table

5. Sorting Rows

6. Filtering Rows

7. Combining and Negating Conditions

8. Pattern Matching

9. More Ways to Filter Rows

10. Operators and Functions

11. Working with Functions

12. Evaluating Conditional Values

13. Summarizing Data

14. Grouping Data

15. Joining Tables

16. Working with Joins

17. Subqueries

18. Combining Queries

19. Inserting Rows

20. Updating and Deleting Rows

21. Creating and Changing Tables

22. Indexes

23. Views

24. Transactions

A. The Sample Database

B. Running SQL Programs

C. Data Types


Read more

About the author

Chris Fehily is a statistician and author based in San Francisco.

Read more
3.8
8 total
Loading...

Additional Information

Publisher
Questing Vole Press
Read more
Published on
Sep 23, 2014
Read more
Pages
268
Read more
ISBN
9781937842338
Read more
Features
Read more
Language
English
Read more
Genres
Computers / Databases / General
Computers / Databases / Servers
Computers / Desktop Applications / Databases
Computers / Programming Languages / SQL
Read more
Content Protection
This content is DRM free.
Read more
Read Aloud
Available on Android devices
Read more
Eligible for Family Library

Reading information

Smartphones and Tablets

Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.

Laptops and Computers

You can read books purchased on Google Play using your computer's web browser.

eReaders and other devices

To read on e-ink devices like the Sony eReader or Barnes & Noble Nook, you'll need to download a file and transfer it to your device. Please follow the detailed Help center instructions to transfer the files to supported eReaders.
This cookbook of advanced techniques is for anyone who knows the basics of SQL and wants to move beyond simple SELECT-FROM-WHERE queries. You'll find solutions to problems that analysts, app developers, and database programmers often face, from simple tasks, like picking random rows, to complex operations, like traversing hierarchies. Each recipe includes a discussion of the underlying logic, important concepts, and best practices. Take full advantage of standard (ANSI/ISO) SQL, or use DBMS-specific features that dramatically extend the power of standard SQL. Use the scores of code examples directly in real-world DBMS applications, or as a source of insight for related problems.


- Covers Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, and Microsoft Access.

- Implement cross-platform solutions in standard SQL, or DBMS-specific solutions for your particular system.

- Full-color SQL code listings help you see the elements and structure of the language.

- Download the sample database and code listings to follow along with the author's examples.

- Plenty of tips, tricks, and timesavers.

- Fully cross-referenced, linked, and searchable.


Contents

Introduction

1. Running SQL Programs

2. Calculating Running Statistics

3. Generating Sequences

4. Finding Sequences, Runs, and Regions

5. Limiting the Number of Rows Returned

6. Assigning Ranks

7. Calculating a Trimmed Mean

8. Picking Random Rows

9. Handling Duplicates

10. Creating a Telephone List

11. Retrieving Metadata

12. Working with Dates

13. Calculating a Median

14. Finding Extreme Values

15. Changing Running Statistics Midstream

16. Pivoting Results

17. Working with Hierarchies


Perfect for end users, analysts,  data scientists, and app developers, this best-selling guide will get you up and running with SQL, the language of databases. You'll find general concepts, practical answers, and clear explanations of what the various SQL statements can do. Hundreds of examples of varied difficulty encourage you to experiment and explore. Full-color SQL code listings help you see the elements and structure of the language. You can download the sample database to follow along with the author's examples.


- Covers Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, and Microsoft Access.

- Learn the core language for standard SQL, and variations for the most widely used database systems.

- Organize your database in terms of the relational model.

- Master tables, columns, rows, and keys.

- Retrieve, sort, and format data.- Filter the data that you don't want to see.

- Convert and manipulate data with SQL's built-in functions and operators.

- Use aggregate functions to summarize data.

- Create complex SQL statements by using joins, subqueries, constraints, conditional logic, and metadata.

- Create, alter, and drop tables, indexes, and views.

- Insert, update, delete, and merge data.

- Execute transactions to maintain the integrity of your data.

- Avoid common pitfalls involving nulls.

- Troubleshoot and optimize queries.

- Plenty of tips, tricks, and timesavers.

- Fully cross-referenced, linked, and searchable.


Contents

Introduction

1. Running SQL Programs

2. The Relational Model

3. SQL Basics

4. Retrieving Data from a Table

5. Operators and Functions

6. Summarizing and Grouping Data

7. Joins

8. Subqueries

9. Set Operations

10. Inserting, Updating, and Deleting Rows

11. Creating, Altering, and Dropping Tables

12. Indexes

13. Views

14. Transactions


Sams Teach Yourself SQL in 10 Minutes, Fourth Edition

New full-color code examples help you see how SQL statements are structured


Whether you're an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And Sams Teach Yourself SQL in 10 Minutes offers the straightforward, practical answers you need to help you do your job.


Expert trainer and popular author Ben Forta teaches you just the parts of SQL you need to know–starting with simple data retrieval and quickly going on to more complex topics including the use of joins, subqueries, stored procedures, cursors, triggers, and table constraints.


You'll learn methodically, systematically, and simply–in 22 short, quick lessons that will each take only 10 minutes or less to complete.


With the Fourth Edition of this worldwide bestseller, the book has been thoroughly updated, expanded, and improved. Lessons now cover the latest versions of IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, SQLite, MariaDB, and Apache Open Office Base. And new full-color SQL code listings help the beginner clearly see the elements and structure of the language.

10 minutes is all you need to learn how to...

Use the major SQL statements Construct complex SQL statements using multiple clauses and operators Retrieve, sort, and format database contents Pinpoint the data you need using a variety of filtering techniques Use aggregate functions to summarize data Join two or more related tables Insert, update, and delete data Create and alter database tables Work with views, stored procedures, and more Table of Contents

1 Understanding SQL

2 Retrieving Data

3 Sorting Retrieved Data

4 Filtering Data

5 Advanced Data Filtering

6 Using Wildcard Filtering

7 Creating Calculated Fields

8 Using Data Manipulation Functions

9 Summarizing Data

10 Grouping Data

11 Working with Subqueries

12 Joining Tables

13 Creating Advanced Joins

14 Combining Queries

15 Inserting Data

16 Updating and Deleting Data

17 Creating and Manipulating Tables

18 Using Views

19 Working with Stored Procedures

20 Managing Transaction Processing

21 Using Cursors

22 Understanding Advanced SQL Features

Appendix A: Sample Table Scripts

Appendix B: Working in Popular Applications

Appendix C : SQL Statement Syntax

Appendix D: Using SQL Datatypes

Appendix E: SQL Reserved Words


Perfect for end users, analysts,  data scientists, and app developers, this best-selling guide will get you up and running with SQL, the language of databases. You'll find general concepts, practical answers, and clear explanations of what the various SQL statements can do. Hundreds of examples of varied difficulty encourage you to experiment and explore. Full-color SQL code listings help you see the elements and structure of the language. You can download the sample database to follow along with the author's examples.


- Covers Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, and Microsoft Access.

- Learn the core language for standard SQL, and variations for the most widely used database systems.

- Organize your database in terms of the relational model.

- Master tables, columns, rows, and keys.

- Retrieve, sort, and format data.- Filter the data that you don't want to see.

- Convert and manipulate data with SQL's built-in functions and operators.

- Use aggregate functions to summarize data.

- Create complex SQL statements by using joins, subqueries, constraints, conditional logic, and metadata.

- Create, alter, and drop tables, indexes, and views.

- Insert, update, delete, and merge data.

- Execute transactions to maintain the integrity of your data.

- Avoid common pitfalls involving nulls.

- Troubleshoot and optimize queries.

- Plenty of tips, tricks, and timesavers.

- Fully cross-referenced, linked, and searchable.


Contents

Introduction

1. Running SQL Programs

2. The Relational Model

3. SQL Basics

4. Retrieving Data from a Table

5. Operators and Functions

6. Summarizing and Grouping Data

7. Joins

8. Subqueries

9. Set Operations

10. Inserting, Updating, and Deleting Rows

11. Creating, Altering, and Dropping Tables

12. Indexes

13. Views

14. Transactions


Perfect for new and experienced users, this no-fluff guide to the Google Nexus 7 tablet is packed with tips and details on apps, services, settings, and documents. You'll also find step-by-step instructions for dictating, networking, sharing, troubleshooting, going online, and using Google Now.


New apps and features covered include Camera, Clock, Google Keep, Android Device Manager, Play Games, Quick Settings, Lock-screen widgets, multiple users, restricted profiles, HDMI screen mirroring, external displays, Miracast, wireless charging, app verification, gesture typing, printing, cellular (LTE/HSPA+) connections, privacy options, Hangouts, the notification light, the remodeled Google Play store, and the updated versions of Chrome, Gmail, and Maps.


- Covers all Nexus 7 models and Android 4.4 (KitKat).

- Covers all Google Play edition (pure Android) tablets, including the LG G Pad 8.3.

- Master the Home screen, Lock screen, and multitouch gestures.- Secure your data from thieves, snoops, and rogue apps.

- Locate a lost or stolen Nexus remotely.

- Work with onscreen or wireless keyboards.

- Get instant search results for documents, pictures, music, mail, apps, contacts, and more.

- Summon Google Now to get personalized information when you need it.

- Ask Google Search to find nearby businesses, set alarms, search the web, and more.

- Dictate anywhere that you can type.

- Connect to wireless networks with a few taps.

- Set up cellular, Bluetooth, and VPN connections.

- Mirror your tablet's screen to your TV.

- Back up your data to the cloud.

- Transfer files to and from your Windows PC or Apple Mac computer.

- Sync your documents, mail, contacts, appointments, reminders, notes, and messages wirelessly across your computers and mobile devices.

- See all your notifications in one place.

- Browse the web with Chrome.

- Watch and subscribe to videos on the YouTube app.

- Send, receive, and manage your email with Gmail or Email.

- Chat with family and friends on Hangouts.

- Post to Twitter or Facebook right from the app you're using.

- Manage your day-to-day life with Calendar, People, Google Keep, and Clock.

- Find your way with Maps.

- Download apps, games, and updates from the Google Play store.

- Connect to Google's online multiplayer social gaming network.

- Play music, movies, TV shows, and other media downloaded from the Google Play store.

- Capture, edit, and share photos and videos with Camera and Gallery.

- Care for your Nexus and troubleshoot problems.

- Plenty of tips, tricks, and timesavers.- Fully cross-referenced, linked, and searchable.


Contents

1. Getting Started with Your Nexus 7

2. Touring Your Nexus

3. Securing Your Nexus

4. Typing & Editing

5. Wireless & Network Connections

6. Managing Your Accounts & Data

7. Connecting to Computers

8. Getting Notifications

9. Google Now

10. Google Search

11. Browsing the Web with Chrome

12. Watching YouTube Videos

13. Email, Messaging & Keeping in Touch

14. Organizing Your Life

15. Shopping for Apps, Games & Media

16. Maps & Navigation

17. Shooting, Viewing & Managing Photos

18. Nexus Care & Troubleshooting


This cookbook of advanced techniques is for anyone who knows the basics of SQL and wants to move beyond simple SELECT-FROM-WHERE queries. You'll find solutions to problems that analysts, app developers, and database programmers often face, from simple tasks, like picking random rows, to complex operations, like traversing hierarchies. Each recipe includes a discussion of the underlying logic, important concepts, and best practices. Take full advantage of standard (ANSI/ISO) SQL, or use DBMS-specific features that dramatically extend the power of standard SQL. Use the scores of code examples directly in real-world DBMS applications, or as a source of insight for related problems.


- Covers Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, and Microsoft Access.

- Implement cross-platform solutions in standard SQL, or DBMS-specific solutions for your particular system.

- Full-color SQL code listings help you see the elements and structure of the language.

- Download the sample database and code listings to follow along with the author's examples.

- Plenty of tips, tricks, and timesavers.

- Fully cross-referenced, linked, and searchable.


Contents

Introduction

1. Running SQL Programs

2. Calculating Running Statistics

3. Generating Sequences

4. Finding Sequences, Runs, and Regions

5. Limiting the Number of Rows Returned

6. Assigning Ranks

7. Calculating a Trimmed Mean

8. Picking Random Rows

9. Handling Duplicates

10. Creating a Telephone List

11. Retrieving Metadata

12. Working with Dates

13. Calculating a Median

14. Finding Extreme Values

15. Changing Running Statistics Midstream

16. Pivoting Results

17. Working with Hierarchies


Neighbors with hand-labeled DVD collections. Teenagers with 5000-song iPods. Entire countries sharing the same copy of Windows. Who are these people? They're file sharers and they account for a third of worldwide internet traffic. Their swag is anything that can be digitized and copied.


But file-sharing networks aren't only for pirates. Musicians and writers use them to gauge their popularity. Artists and filmmakers use them to boost recognition. Government employees use them to secretly download WikiLeaks archives. TV producers use them to confirm audience measurements. Politicians and judges use them to make policy and rulings. Traders and marketers use them to spot trends.


- Learn how BitTorrent and peer-to-peer networks work.

- Set up a BitTorrent client and find files to download.

- Open, play, read, or run what you download.

- Know the risks of file sharing and avoid fakes, scams, and viruses.


Reviews

"A remarkably calm look at the technical, social, economic and cultural issues arising from file-sharing, and it's also a damned practical guide to navigating the strange world of file-sharing technology."

- Cory Doctorow, boingboing.net


"Chris Fehily won't exactly call [middle-class consumers] suckers, but he will show them -- as well as college students, crackers, digital anarchists and others -- the Pirate Way."

- J.D. Lasica, socialmedia.biz


"An essential primer on file sharing for those not in the know."

- Leo M, Brain Scratch

Contents

1. The Terrain

2. Understanding BitTorrent

3. File Types

4. Malware

5. Archives

6. Installing a BitTorrent Client

7. BitTorrent Search Engines

8. Finding Torrents

9. Customizing Your Client

10. Downloading Torrents

11. Movies and TV Shows

12. Pictures

13. Music and Spoken Word

14. Books, Documents, and Fonts

15. Applications and Games


©2018 GoogleSite Terms of ServicePrivacyDevelopersArtistsAbout Google|Location: United StatesLanguage: English (United States)
By purchasing this item, you are transacting with Google Payments and agreeing to the Google Payments Terms of Service and Privacy Notice.