Microsoft Windows 7: Visual QuickStart Guide

Peachpit Press
10
Free sample

This concise guide covers every edition of Windows 7 in Visual QuickStart style, with plenty of screenshots, numbered steps, tips, and sidebars. You'll learn how to use new and updated features, including the redesigned taskbar; jump lists; libraries; federated search; desktop gadgets; window-management shortcuts; and the improved versions of Internet Explorer, Mail, Messenger, Photo Gallery, Movie Maker, and Media Player. You'll also find information on setup; installation; upgrading from other Windows versions; troubleshooting; hardware; and organizing your documents, music, photos, and videos. Laptop and mobile users will learn how to connect from the road, jump onto a public wireless network, and conserve battery power. Author Chris Fehily also walks you through setting up a network or homegroup, connecting to the internet, configuring routers and firewalls, and hooking up printers and other devices. You'll learn how to use security features to protect your PC and network and share files while keeping personal stuff private.
Read more

About the author

Chris Fehily is a writer and consultant based in San Francisco.
Read more
3.3
10 total
Loading...

Additional Information

Publisher
Peachpit Press
Read more
Published on
Sep 8, 2009
Read more
Pages
576
Read more
ISBN
9780132712569
Read more
Read more
Language
English
Read more
Genres
Computers / Operating Systems / Windows Desktop
Read more
Content Protection
This content is DRM protected.
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.
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


Book + 2 Hours of Free Video + Content Update Program


My Microsoft® Windows® 10 is an easy, full-color tutorial on the latest operating system from Microsoft. It includes 2 hours of FREE step-by-step video tutorials to help you learn how to navigate and customize the new Windows 10 desktop.

In addition, this book is part of Que’s exciting new Content Update Program. As Microsoft updates features of Windows 10, sections of this book will be updated or new sections will be added to match the updates to the software. The updates will be delivered to you via a FREE Web Edition of this book, which can be accessed with any Internet connection. To learn more, visit www.quepublishing.com/CUP.

How to access the free video and web edition: Follow the instructions within the book to learn how to register your book to access the 2 hours of FREE step-by-step video and the FREE Web Edition.

Author Katherine Murray has been writing about technology for more than 25 years and has worked with every consumer version of Windows since Windows 3.1. Murray will help you learn how to:

Master Windows 10 innovations you like and keep the older techniques you’re comfortable with Let Cortana, your new personal digital assistant, help you find what you need Adjust the Start menu so it works the way you want (not the other way around!) Learn to use Windows 10 on PC or tablet Streamline your browsing experience with Microsoft® Edge, the new state-of-the-art web browser Find, download, install, and work with the best new Windows Store apps Copy, move, and share files using File Explorer Use the Skype app to make super-easy, free video calls Access all your favorite media with the new Groove Music and Movies & TV apps
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


©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.