SQL in 10 Minutes, Sams Teach Yourself - Ben Forta

SQL in 10 Minutes, Sams Teach Yourself

(Autor)

Buch | Softcover
288 Seiten
2012 | 4th edition
Sams Publishing (Verlag)
978-0-672-33607-2 (ISBN)
37,35 inkl. MwSt
zur Neuauflage
  • Titel erscheint in neuer Auflage
  • Artikel merken
Zu diesem Artikel existiert eine Nachauflage
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

Ben Forta is Adobe Systems’ Director of Developer Relations and has more than 20 years of experience in the computer industry in product development, support, training, and product marketing. He is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes, spinoff titles on MySQL and SQL Server T-SQL, ColdFusion Web Application Construction Kit and Advanced ColdFusion Application Development (both published by Adobe Press), Sams Teach Yourself Regular Expressions in 10 Minutes, as well as books on Flash, Java, Windows, and other subjects. He has extensive experience in database design and development, has implemented databases for several highly successful commercial software programs and websites, and is a frequent lecturer and columnist on Internet and database technologies. 

Sams Teach Yourself SQL in 10 Minutes, Fourth Edition

1 Understanding SQL
Database Basics


What Is SQL?


Try It Yourself


2 Retrieving Data


The SELECT Statement


Retrieving Individual Columns


Retrieving Multiple Columns


Retrieving All Columns


Retrieving Distinct Rows


Limiting Results


Using Comments


3 Sorting Retrieved Data


Sorting Data


Sorting by Multiple Columns


Sorting by Column Position


Specifying Sort Direction


4 Filtering Data


Using the WHERE Clause


The WHERE Clause Operators


5 Advanced Data Filtering


Combining WHERE Clauses


Using the IN Operator


Using the NOT Operator


6 Using Wildcard Filtering


Using the LIKE Operator


Tips for Using Wildcards


7 Creating Calculated Fields


Understanding Calculated Fields


Concatenating Fields


Performing Mathematical Calculations


8 Using Data Manipulation Functions


Understanding Functions


Using Functions


9 Summarizing Data


Using Aggregate Functions


Aggregates on Distinct Values


Combining Aggregate Functions


10 Grouping Data


Understanding Data Grouping


Creating Groups


Filtering Groups


Grouping and Sorting


SELECT Clause Ordering


11 Working with Subqueries


Understanding Subqueries


Filtering by Subquery


Using Subqueries as Calculated Fields


12 Joining Tables


Understanding Joins


Creating a Join


13 Creating Advanced Joins


Using Table Aliases


Using Different Join Types


Using Joins with Aggregate Functions


Using Joins and Join Conditions


14 Combining Queries


Understanding Combined Queries


Creating Combined Queries


15 Inserting Data


Understanding Data Insertion


Copying from One Table to Another


16 Updating and Deleting Data


Updating Data


Deleting Data


Guidelines for Updating and Deleting Data


17 Creating and Manipulating Tables


Creating Tables


Updating Tables


Deleting Tables


Renaming Tables


18 Using Views


Understanding Views


Creating Views


19 Working with Stored Procedures


Understanding Stored Procedures


Why to Use Stored Procedures


Executing Stored Procedures


Creating Stored Procedures


20 Managing Transaction Processing


Understanding Transaction Processing


Controlling Transactions


21 Using Cursors


Understanding Cursors


Working with Cursors


22 Understanding Advanced SQL Features


Understanding Constraints


Understanding Indexes


Understanding Triggers


Database Security


A Sample Table Scripts


Understanding the Sample Tables


Obtaining the Sample Tables


B Working in Popular Applications


Using Apache Open Office Base


Using Adobe ColdFusion


Using IBM DB2


Using MariaDB


Using Microsoft Access


Using Microsoft ASP


Using Microsoft ASP.NET


Using Microsoft Query


Using Microsoft SQL Server (including Microsoft SQL Server Express)


Using MySQL


Using Oracle


Using Oracle Express


Using PHP


Using PostgreSQL


Using SQLite


Configuring ODBC Data Sources


C SQL Statement Syntax


ALTER TABLE


COMMIT


CREATE INDEX


CREATE PROCEDURE


CREATE TABLE


CREATE VIEW


DELETE


DROP


INSERT


INSERT SELECT


ROLLBACK


SELECT


UPDATE


D Using SQL Datatypes


String Datatypes


Numeric Datatypes


Date and Time Datatypes


Binary Datatypes


E SQL Reserved Words

Erscheint lt. Verlag 15.11.2012
Reihe/Serie Sams Teach Yourself
Verlagsort Indianapolis
Sprache englisch
Maße 135 x 210 mm
Gewicht 380 g
Themenwelt Mathematik / Informatik Informatik Datenbanken
Mathematik / Informatik Informatik Software Entwicklung
ISBN-10 0-672-33607-3 / 0672336073
ISBN-13 978-0-672-33607-2 / 9780672336072
Zustand Neuware
Haben Sie eine Frage zum Produkt?
Mehr entdecken
aus dem Bereich
Der Grundkurs für Ausbildung und Praxis

von Ralf Adams

Buch (2023)
Carl Hanser (Verlag)
29,99