SQL in 10 Minutes, Sams Teach Yourself

Author: Ben Forta

Publisher: Sams Publishing

ISBN: 013304808X

Category: Computers

Page: 256

View: 1414

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

Sams Teach Yourself SQL in 10 Minutes

Author: Ben Forta

Publisher: Sams Publishing

ISBN: 9780672325670

Category: Computers

Page: 242

View: 2312

Explains how to use Structured Query Language to work within a relational database system, including information retrieval, security, data manipulation, and user management.

MariaDB Crash Course

Author: Ben Forta

Publisher: Addison-Wesley Professional

ISBN: 0132842351

Category: Computers

Page: 304

View: 3126

MariaDB is a database server that offers drop-in replacement functionality for MySQL. Built by some of the original authors of MySQL, with assistance from the broader community of free and open source software developers, MariaDB offers a rich set of feature enhancements to MySQL, including alternate storage engines, server optimizations, and patches. MariaDB Crash Course teaches you all you need to know to be immediately productive with MariaDB. Master trainer Ben Forta introduces all the essentials through a series of quick, easy-to-follow, hands-on lessons. Instead of belaboring database theory and relational design, Forta focuses on teaching solutions for the majority of users who simply want to interact with data. Learn how to: Retrieve and sort data Filter data using comparisons, regular expressions, and full text search Join relational data Create and alter tables Insert, update, and delete data Leverage the power of stored procedures and triggers Use views and cursors Manage transactional processing Create user accounts and manage security via access control

SQL kurz und gut

Author: Jonathan Gennick

Publisher: N.A

ISBN: 9783897215221

Category: Database management

Page: 208

View: 2927

Microsoft SQL Server T-SQL in 10 Minutes, Sams Teach Yourself

Author: Ben Forta

Publisher: Sams Teach Yourself

ISBN: 9780672337925

Category: Computers

Page: 368

View: 8255

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes, Second Edition is the only compact, hands-on introduction to T-SQL, this guide is now fully updated through SQL Server 2016 and the newest version of SQL Server Express. Building on his global best-seller Sams Teach Yourself SQL in 10 Minutes, Ben Forta covers all you need to know to successfully use T-SQL in any database development or DBA role -- including everything that makes T-SQL different from standard SQL. Through carefully-structured, highly-focused lessons, Forta guides you from simple data retrieval through complex topics, helping you become productive quickly and painlessly. Coverage includes: Working with T-SQL in modern SQL Server environments Retrieving data, and then sorting and filtering it Performing wildcard filtering and using advanced data filtering techniques Creating calculated fields Using data manipulation functions Summarizing and grouping data Building subqueries, joining tables, and combining queries Inserting, updating, and deleting data Creating and manipulating tables Using views Programming with T-SQL Working with stored procedures, cursors, and triggers Managing transaction processing Working with Internet formats Globalizing and localizing T-SQL code Optimizing security and performance

Sams Teach Yourself Regular Expressions in 10 Minutes

Author: Ben Forta

Publisher: Sams Publishing

ISBN: 9780768689952

Category: Computers

Page: 160

View: 8910

RegEx is supported in all major development environments (for use in editing and working with code) and will thus appeal to anyone using these tools. In addition, every JavaScript developer should be using RegEx, but most don't as it has never been taught to them properly before. Developers using ASP, C#, ColdFusion, Java JSP, PHP, Perl, Python, and more can (and should) be using RegEx, and so every one of them is a potential reader too. The reader of this book will learn how to: Match characters sets Match repeating characters (using minimums and maximums if needed) Match (or ignore) based on case Build sub-expressions Use all of the special characters Work with excape sequences Use POSIX classes to simplify complex expressions Use back-references Use look-behind operators Sams Teach Yourself Regular Expressions in 10 Minutes is a tutorial book organized into a series of easy-to-follow 10-minute lessons. These well targeted lessons teach you in 10 minutes what other books might take hundreds of pages to cover. Instead of dwelling on syntax, terminology, and arcane examples and scenarios, this book takes a very hands-on approach to solving the needs of the majority of RegEx users who simply need to manipulate data.

Einführung in SQL

Author: Alan Beaulieu

Publisher: O'Reilly Germany

ISBN: 3897219387

Category: Computers

Page: 353

View: 5265

SQL kann Spaß machen! Es ist ein erhebendes Gefühl, eine verworrene Datenmanipulation oder einen komplizierten Report mit einer einzigen Anweisung zu bewältigen und so einen Haufen Arbeit vom Tisch zu bekommen. Einführung in SQL bietet einen frischen Blick auf die Sprache, deren Grundlagen jeder Entwickler beherrschen muss. Die aktualisierte 2. Auflage deckt die Versionen MySQL 6.0, Oracle 11g und Microsoft SQL Server 2008 ab. Außerdem enthält sie neue Kapitel zu Views und Metadaten. SQL-Basics - in null Komma nichts durchstarten: Mit diesem leicht verständlichen Tutorial können Sie SQL systematisch und gründlich lernen, ohne sich zu langweilen. Es führt Sie rasch durch die Basics der Sprache und vermittelt darüber hinaus eine Reihe von häufig genutzten fortgeschrittenen Features. Mehr aus SQL-Befehlen herausholen: Alan Beaulieu will mehr vermitteln als die simple Anwendung von SQL-Befehlen: Er legt Wert auf ein tiefes Verständnis der SQL-Features und behandelt daher auch den Umgang mit Mengen, Abfragen innerhalb von Abfragen oder die überaus nützlichen eingebauten Funktionen von SQL. Die MySQL-Beispieldatenbank: Es gibt zwar viele Datenbankprodukte auf dem Markt, aber welches wäre zum Erlernen von SQL besser geeignet als MySQL, das weit verbreitete relationale Datenbanksystem? Der Autor hilft Ihnen, eine MySQL-Datenbank anzulegen, und nutzt diese für die Beispiele in diesem Buch. Übungen mit Lösungen: Zu jedem Thema finden Sie im Buch gut durchdachte Übungen mit Lösungen. So ist sichergestellt, dass Sie schnell Erfolgserlebnisse haben und das Gelernte auch praktisch umsetzen können.

Sams Teach Yourself Oracle PL/SQL in 10 Minutes

Author: Ben Forta

Publisher: Sams Publishing

ISBN: 013396678X

Category: Computers

Page: 288

View: 4798

Covers Oracle DBMS versions 10, 11, 12, and XE Sams Teach Yourself Oracle PL/SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through the book’s 26 lessons of 10 minutes or less, you’ll learn what you need to know to take advantage of Oracle’s PL/SQL language. This handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the use of joins, subqueries, regular expression and full text-based searches, stored procedures, cursors, triggers, table constraints, and much more. 10 minutes is all you need to learn how to... Use PL/SQL in the Oracle environments and tools Construct complex PL/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 string, date-time, and math functions to manipulate your data Join two or more related tables Insert, update, and delete data Create and alter database tables Work with views, stored procedures, cursors, triggers, and more

SQL für Dummies

Author: Allen G. Taylor

Publisher: John Wiley & Sons

ISBN: 3527810897

Category: Computers

Page: 440

View: 6211

Daten und Datenbanken sind quasi überall. Mit der Standardabfragesprache SQL können Daten in relationalen Datenbanken einfach, strukturiert und zielsicher abgefragt werden. Erfahren Sie in diesem Buch, welches kein Vorwissen voraussetzt, wie man Datenbanken erstellt, wie man Daten ordnet und abfragt und wie man SQL-Anweisungen in Programme und Websites einbindet. Nutzen Sie dieses Buch auch als Nachschlagewerk. Ganz wichtig: Sie lernen auch, wie Sie Ihre Datenbanken und Daten schützen und wie Sie typische Fehler vermeiden.

Sams Teach Yourself MySQL in 10 Minutes

Author: Chris Newman

Publisher: Sams Publishing

ISBN: 0672328631

Category: Computers

Page: 277

View: 3116

Describes the features and functions of MySQL 5.0 and includes quick reference lists and tables.

Sams Teach Yourself Microsoft SQL Server 7 in 10 Minutes

Author: William Robison

Publisher: N.A

ISBN: 9780672316630

Category: Computers

Page: 224

View: 1109

Sams Teach Yourself Microsoft SQL Server 7 in 10 Minutes is a short but detailed reference to Microsoft SQL Server 7. This book brings together the most common commands and tasks that programmers and database administrators need to perform. Concise, goal-oriented lessons allow you to get up to speed quickly and efficiently. Application developers and administrators who are new to Microsoft SQL Server will learn to store, retrieve, and manipulate data in a Microsoft SQL Server database. This book serves as a reference guide even after you have become proficient.

Sams Teach Yourself Visual Basic.NET in 21 Days

Author: Duncan Mackenzie,Kent Sharkey

Publisher: Sams Publishing

ISBN: 9780672320668

Category: Computers

Page: 663

View: 7413

Offers a tutorial for creating applications with Visual Basic within the .NET platform, covering topics including user interfaces, object-oriented programming, application deployment, and XML.

Sams Teach Yourself XML in 10 Minutes

Author: Andrew H. Watt

Publisher: Sams Publishing

ISBN: 9780672324710

Category: Computers

Page: 292

View: 5761

Provides an overview of XML and related concepts including basic syntax, DTDs, XML Schema, DOM, SAX, XSL, and XPath.

SQL von Kopf bis Fuss

Author: Lynn Beighley

Publisher: O'Reilly Germany

ISBN: 3955619443

Category: Computers

Page: 608

View: 6289

Ihre Daten erdrücken Sie? Ihre Tabellen verheddern sich regelmäßig? Wir haben ein Mittel, wie Sie Ihre Datenbanken in den Griff bekommen: SQL von Kopf bis Fuß nimmt Sie mit auf eine Reise durch die SQL-Welt, es geleitet Sie von einfachen INSERT-Anweisungen und SELECT-Abfragen zu knallharten Datenbank-Manipulationen mit Indizes, Joins und Transaktionen. Erwarten Sie dennoch Spaß, gehen Sie davon aus, etwas zu lernen, und machen Sie sich darauf gefasst, dass Sie Ihre Daten wie ein Profi abfragen, normalisieren und verknüpfen werden, noch bevor Sie dieses Buch ausgelesen haben. SQL von Kopf bis Fuß ist in einem visuell abwechslungsreichen Format gestaltet, das sich an den neuesten Forschungsergebnissen aus Kognitionswissenschaft und Lerntheorie orientiert und Ihnen das Lernen so einfach wie möglich machen soll. Das Buch bietet Ihnen ein unterhaltsames Lernerlebnis und spielt Ihnen SQL direkt ins Hirn - und zwar so, dass es sitzt.

Sams Teach Yourself Beginning Databases in 24 Hours

Author: Ronald R. Plew,Ryan K. Stephens

Publisher: Sams Publishing

ISBN: 9780672324925

Category: Computers

Page: 456

View: 2522

Discusses how to choose the correct database, how to design a database, how to organize data, how to query and update data, how to create reports, and how to build applications that use databases.

Sams Teach Yourself HomeSite 4 in 24 Hours

Author: Ben Forta

Publisher: Sams

ISBN: 9780672315602

Category: Computers

Page: 338

View: 9183

Explains how to use the HTML editor to simplify Web page development, including creating tables and forms, and deploying sites and applications to remote servers