Einführung in SQL

DOWNLOAD NOW »

Author: Alan Beaulieu

Publisher: O'Reilly Germany

ISBN: 3897219387

Category: Computers

Page: 353

View: 5373

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.

CompTIA Linux+ Powered by Linux Professional Institute Study Guide, 3rd Edition

Exam LX0-101 and Exam LX0-102

DOWNLOAD NOW »

Author: Christine Bresnahan,Richard Blum

Publisher: John Wiley & Sons

ISBN: 1119021219

Category: Computers

Page: 648

View: 7380

CompTIA Authorized Linux+ prep CompTIA Linux+ Study Guide is your comprehensive study guide for the Linux+ Powered by LPI certification exams. With complete coverage of 100% of the objectives on both exam LX0-101 and exam LX0-102, this study guide provides clear, concise information on all aspects of Linux administration, with a focus on the latest version of the exam. You'll gain the insight of examples drawn from real-world scenarios, with detailed guidance and authoritative coverage of key topics, including GNU and Unix commands, system operation, system administration, system services, security, and more, from a practical perspective that easily translates into on-the-job know-how. You'll also get access to helpful study tools, including bonus practice exams, electronic flashcards, and a searchable glossary of key terms that are important to know for exam day. Linux is viewed by many companies and organizations as an excellent, low-cost, secure alternative to expensive operating systems such as Microsoft Windows. The CompTIA Linux+ Powered by LPI exams test a candidate's understanding and familiarity with the Linux Kernel. Review the basic system architecture, installation, and management Understand commands, devices, and file systems Utilize shells, scripting, and data management techniques Navigate user interfaces, desktops, and essential system services As the Linux server market share continue to grow, so too does the demand for qualified and certified Linux administrators. Certification holders must recertify every five years, but LPI recommends recertifying every two years to stay fully up to date with new technologies and best practices. CompTIA Linux+ Study Guide gives you the advantage of exam day confidence.

LPIC-1 Linux Professional Institute Certification Study Guide

Exam 101-400 and Exam 102-400

DOWNLOAD NOW »

Author: Christine Bresnahan,Richard Blum

Publisher: John Wiley & Sons

ISBN: 1119021197

Category: Computers

Page: 696

View: 9040

Thorough LPIC-1 exam prep, with complete coverage and bonusstudy tools LPIC-1Study Guide is your comprehensive source for thepopular Linux Professional Institute Certification Level 1 exam,fully updated to reflect the changes to the latest version of theexam. With 100% coverage of objectives for both LPI 101 and LPI102, this book provides clear and concise information on all Linuxadministration topics and practical examples drawn from real-worldexperience. Authoritative coverage of key exam topics includes GNUand UNIX commands, devices, file systems, file system hierarchy,user interfaces, and much more, providing complete exam prep forthe LPIC-1 candidate. Get access to invaluable study tools,including bonus practice exams, electronic flashcards, and asearchable PDF of key terms featured on the exam. Linux is viewed by many companies and organizations as anexcellent, low-cost, secure alternative to expensive operatingsystems, such as Microsoft Windows. The LPIC-1 tests a candidate'sunderstanding and familiarity with the Linux Kernel. This bookprovides comprehensive preparation and review, helping readers facethe exam with confidence. Review the system architecture, Linux installation, and packagemanagement Understand shells, scripting, and data management morecompletely Practice administrative tasks and essential systemservices Brush up on networking fundamentals and security issues As the Linux server market share continue to grow, so too doesthe demand for qualified and certified Linux administrators.Certification holders must recertify every five years, but LPIrecommends recertifying every two years to stay fully up to datewith new technologies and best practices. As exam day approaches,LPIC-1Study Guide is the one source you will want by yourside.

CompTIA Linux+ Powered by Linux Professional Institute Study Guide

Exam LX0-103 and Exam LX0-104

DOWNLOAD NOW »

Author: Christine Bresnahan,Richard Blum

Publisher: John Wiley & Sons

ISBN: 1119021235

Category: Computers

Page: 688

View: 3090

CompTIA Authorized Linux+ prep CompTIA Linux+ Study Guide is your comprehensive study guide for the Linux+ Powered by LPI certification exams. With complete coverage of 100% of the objectives on both exam LX0-103 and exam LX0-104, this study guide provides clear, concise information on all aspects of Linux administration, with a focus on the latest version of the exam. You'll gain the insight of examples drawn from real-world scenarios, with detailed guidance and authoritative coverage of key topics, including GNU and Unix commands, system operation, system administration, system services, security, and more, from a practical perspective that easily translates into on-the-job know-how. You'll also get access to helpful study tools, including bonus practice exams, electronic flashcards, and a searchable glossary of key terms that are important to know for exam day. Linux is viewed by many companies and organizations as an excellent, low-cost, secure alternative to expensive operating systems such as Microsoft Windows. The CompTIA Linux+ Powered by LPI exams test a candidate's understanding and familiarity with the Linux Kernel. Review the basic system architecture, installation, and management Understand commands, devices, and file systems Utilize shells, scripting, and data management techniques Navigate user interfaces, desktops, and essential system services As the Linux server market share continue to grow, so too does the demand for qualified and certified Linux administrators. Certification holders must recertify every five years, but LPI recommends recertifying every two years to stay fully up to date with new technologies and best practices. CompTIA Linux+ Study Guide gives you the advantage of exam day confidence.

The Language of SQL

DOWNLOAD NOW »

Author: Larry Rockoff

Publisher: Addison-Wesley Professional

ISBN: 0134658337

Category: Computers

Page: 240

View: 6690

This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. The Language of SQL, Second Edition Many SQL texts attempt to serve as an encyclopedic reference on SQL syntax -- an approach that is often counterproductive, because that information is readily available in online references published by the major database vendors. For SQL beginners, it’s more important for a book to focus on general concepts and to offer clear explanations and examples of what various SQL statements can accomplish. This is that book. A number of features make The Language of SQL unique among introductory SQL books. First, you will not be required to download software or sit with a computer as you read the text. The intent of this book is to provide examples of SQL usage that can be understood simply by reading. Second, topics are organized in an intuitive and logical sequence. SQL keywords are introduced one at a time, allowing you to grow your understanding as you encounter new terms and concepts. Finally, this book covers the syntax of three widely used databases: Microsoft SQL Server, MySQL, and Oracle. Special “Database Differences” sidebars clearly show you any differences in syntax among these three databases, and instructions are included on how to obtain and install free versions of the databases. This is the only book you need to gain a quick working knowledge of SQL and relational databases. ·Learn How To... Use SQL to retrieve data from relational databases Apply functions and calculations to data Group and summarize data in a variety of useful ways Use complex logic to retrieve only the data you need Update data and create new tables Design relational databases so that data retrieval is easy and intuitive Use spreadsheets to transform your data into meaningful displays Retrieve data from multiple tables via joins, subqueries, views, and set logic Create, modify, and execute stored procedures Install Microsoft SQL Server, MySQL, or Oracle

Learning SQL

Master SQL Fundamentals

DOWNLOAD NOW »

Author: Alan Beaulieu

Publisher: "O'Reilly Media, Inc."

ISBN: 9780596555580

Category: Computers

Page: 338

View: 9651

Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals. Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will: Move quickly through SQL basics and learn several advanced features Use SQL data statements to generate, manipulate, and retrieve data Create database objects, such as tables, indexes, and constraints, using SQL schema statements Learn how data sets interact with queries, and understand the importance of subqueries Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.

Designing with Javascript

Creating Dynamic Web Pages

DOWNLOAD NOW »

Author: Nick Heinle,Bill Peña

Publisher: "O'Reilly Media, Inc."

ISBN: 9781565923607

Category: Computers

Page: 216

View: 2752

A guide for beginners offers an overview of JavaScript basics and explains how to create Web pages, identify browsers, and integrate sound, graphics, and animation into Web applications

Pro Oracle SQL

DOWNLOAD NOW »

Author: Karen Morton,Kerry Osborne,Robyn Sands,Riyaj Shamsudeen,Jared Still

Publisher: Apress

ISBN: 1430262214

Category: Computers

Page: 580

View: 320

Pro Oracle SQL, Second Edition unlocks the power of SQL in the Oracle database—one of the most potent SQL implementations on the market today. To master it requires a multi-pronged approach: learn the language features, learn how and why the language features work, learn the supporting features that Oracle provides to help use the language effectively, and learn to think and work in sets. Karen Morton has updated the content for Oracle version 12c and helps you master powerful aspects of Oracle SQL from the inside-out. You’ll learn analytic functions, the MODEL clause, and advanced grouping syntax—features that will help in creating good queries for reporting and business intelligence applications. Pro Oracle SQL, Second Edition also helps you minimize parsing overhead, read execution plans, test for correct results, understand performance management, and exert control over SQL execution in your database. You’ll learn when to create indexes, how to verify that they make a difference, how to use SQL Baselines and Profiles to optimize and stabilize SQL execution plans, and much more. You’ll also understand how SQL is optimized for working in sets, and that the key to getting accurate results lies in making sure that queries ask clear and precise questions. Pro Oracle SQL, Second Edition helps you work at a truly professional level in the Oracle dialect of SQL. You’ll master the language, the tools to work effectively with the language, and the right way to think about a problem in SQL. Endorsed by the OakTable Network, a group of Oracle technologists well-known for their rigorous and scientific approach to Oracle Database performance Comprehensive—goes beyond the language with a focus on what you need to know to write successful queries and data manipulation statements. Performance focused—teaches you how to measure the performance of your SQL statements and not just the syntax.

SQL für Dummies

DOWNLOAD NOW »

Author: Allen G. Taylor

Publisher: John Wiley & Sons

ISBN: 3527810897

Category: Computers

Page: 440

View: 8730

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.

SQL kurz und gut

DOWNLOAD NOW »

Author: Jonathan Gennick

Publisher: N.A

ISBN: 9783897215221

Category: Database management

Page: 208

View: 9913

Oracle 11g: PL/SQL Programming

DOWNLOAD NOW »

Author: Joan Casteel

Publisher: Cengage Learning

ISBN: 1285531574

Category: Computers

Page: 528

View: 1453

Learn how to most effectively use PL/SQL programming language with one of the most popular and widely-used software programs in large companies today -- Oracle11g. ORACLE 11G: PL/SQL PROGRAMMING & ORACLE CD, 2E uses Oracle 11g to provide an overview of the PL/SQL programming language from a developer's perspective. The author begins with a step-by-step expanded introduction to fundamental PL/SQL concepts before progressing to the writing and testing of PL/SQL code. This edition also covers more advanced topics, such as Dynamic SQL and code tuning, as well as developments in bulk processing, compound triggers, PL/SQL compiler features and hiding source code. Updates reflect the latest Oracle 11g release with the most recent figures and examples using the user-friendly SQL Developer tool. A wealth of real-world examples, a straightforward presentation, and accompanying Oracle CD make this book is an invaluable resource in preparing for the new Oracle Certification exam or mastering the PL/SQL programming language with Oracle. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

SQL for Microsoft Access

DOWNLOAD NOW »

Author: Cecelia L. Allison,Neal A. Berkowitz

Publisher: Jones & Bartlett Learning

ISBN: 144963155X

Category: Computers

Page: 374

View: 9553

SQL for Microsoft Access (2nd Edition) provides a guide to getting the most out of Microsoft Access through the use of Structured Query Language. Step-by-step examples demonstrate how to use SQL script to create tables, add records to tables, and retrieve and manage records. Readers will also learn about calculated fields, Access projects, and the integration of SQL script in VBA and ASP code. Explore the relational database structure and the basics of SQL. Understand how table joins, unions, and subqueries are used to retrieve records from multiple tables simultaneously. Learn how to filter records and group data. Discover how to create parameter queries that prompt users for data. Test your knowledge and comprehension with the end-of-chapter quizzes and projects.

Oracle PL/SQL Language

Pocket Reference

DOWNLOAD NOW »

Author: Steven Feuerstein,Bill Pribyl,Chip Dawes

Publisher: "O'Reilly Media, Inc."

ISBN: 9780596004729

Category: Electronic books

Page: 121

View: 2719

Provides a reference to basic language elements including block structure and declarations, statements for program control, and the calling of functions.

Oracle SQL, A Beginner’s Tutorial, Second Edition

DOWNLOAD NOW »

Author: Djoni Darmawikarta

Publisher: N.A

ISBN: 1771970308

Category: Computers

Page: 148

View: 678

Initially developed at IBM in the early 1970s, SQL was formalized by the American National Standards Institute (ANSI) in 1986. Since then the SQL standard has been revised seven times. SQL consists of a data definition language (DDL) and a data manipulation language (DML). The DDL is used to create, delete, and alter the structure of a table and other database objects. The DML is used to insert, retrieve, and update data in a table or tables. Many database vendors implement a version of SQL that is not 100% compliant with the standard. They often add unique features to their SQL, resulting in an SQL dialect. This book is for you if you want to learn SQL the easy way. This book uses the free edition of the Oracle database to show how SQL works.

Oracle PL/SQL kurz & gut

DOWNLOAD NOW »

Author: Steven Feuerstein,Bill Pribyl,Chip Dawes

Publisher: O'Reilly Germany

ISBN: 386899680X

Category: Computers

Page: 184

View: 2920

Die vierte Auflage dieser beliebten Taschenreferenz liefert Ihnen die wichtigsten Informationen, die Sie für die Arbeit mit Oracle PL/SQL benötigen, und deckt jetzt auch die neuen Features von Oracle Database 11g ab. Das Buch bietet eine Zusammenfassung der Sprachelemente und Funktionen von PL/SQL und behandelt unter anderem folgende Themen: - Blockstruktur, Bezeichner, Variablen, Datentypen und Deklarationen - Anweisungen zur Ablaufsteuerung, zur Cursor-Verwaltung und zum Exception-Handling - Aufruf von PL/SQL-Funktionen in SQL - Datensätze, Prozeduren, Funktionen, Trigger und Packages - Kompilationsoptionen, objektorientierte Features und Collections

Oracle PL/SQL Programmierung

DOWNLOAD NOW »

Author: Steven Feuerstein,Bill Pribyl

Publisher: O'Reilly Verlag DE

ISBN: 9783897211841

Category: ORACLE 9i

Page: 1058

View: 2015

Incident Response

DOWNLOAD NOW »

Author: Kenneth R. Van Wyk,Richard Forno

Publisher: Oreilly & Associates Incorporated

ISBN: 9780596001308

Category: Computers

Page: 214

View: 1105

"Incident Response is a complete guide for organizations of all sizes and types who are addressing their computer security issues."--BOOK JACKET.

Building Wireless Community Networks

DOWNLOAD NOW »

Author: Rob Flickenger

Publisher: O'Reilly Media

ISBN: 9780596002046

Category: Drahtloses lokales Netz

Page: 125

View: 720

This nuts-and-bolts guide to building the infrastructure needed for community wireless networks displays real-world examples and describes the experiences of others using 802.11b. Includes sample configuration files and working examples.

Network troubleshooting tools

DOWNLOAD NOW »

Author: Joseph D. Sloan

Publisher: O'Reilly Media

ISBN: 9780596001865

Category: Computers

Page: 346

View: 8259

Over the years, thousands of tools have been developed for debugging TCP/IP networks. They range from very specialized tools that do one particular task, to generalized suites that do just about everything except replace bad Ethernet cables. Even better, many of them are absolutely free. There's only one problem: who has time to track them all down, sort through them for the best ones for a particular purpose, or figure out how to use them? "Network Troubleshooting Tools" does the work for you--by describing the best of the freely available tools for debugging and troubleshooting. You can start with a lesser-known version of "ping" that diagnoses connectivity problems, or take on a much more comprehensive program like MRTG for graphing traffic through network interfaces. There's "tkined" for mapping and automatically monitoring networks, and Ethereal for capturing packets and debugging low-level problems. This book isn't just about the tools available for troubleshooting common network problems. It also outlines a systematic approach to network troubleshooting: how to document your network so you know how it behaves under normal conditions, and how to think about problems when they arise, so you can solve them more effectively. The topics covered in this book include: Understanding your network Connectivity testing Evaluating the path between two network nodes Tools for capturing packets Tools for network discovery and mapping Tools for working with SNMP Performance monitoring Testing application layer protocols Software sources If you're involved with network operations, this book will save you time, money, and needless experimentation.

Programming Visual Basic .NET

DOWNLOAD NOW »

Author: Dave Grundgeiger

Publisher: Oreilly & Associates Incorporated

ISBN: N.A

Category: Computers

Page: 446

View: 3203

Programming Visual Basic .NETis the complete guide to application development using Visual Basic .NET. Targeted at programmers with some prior programming experience, the book covers the major areas of application development for Microsoft's new .NET platform. After starting with the traditional "hello world" application, the book discusses the two basic building blocks of any .NET application built with Visual Basic--the Visual Basic .NET programming language and the .NET Framework. Topics covered include: Visual Basic language elements Visual Basic's object-oriented language features Programming with attributes The Common Language Runtime Garbage Collection and the Finalize and Dispose methods Programmatically reading from and writing to .NET configuration files The remainder of the book focuses on the three major kinds of applications that can be developed with the .NET Framework: Windows Forms applications, ASP.NET applications, and web services. In each case, the book shows you how to build an application using Visual Studio .NET as well as using a text editor and the Visual Basic command-line compiler. This gives you an "under the hood" look at what Visual Studio is doing and allows you to gain a greater understanding of how a .NET application works--an understanding that you can take advantage of in building your own applications. Individual development topics covered in these chapters include: Developing Multiple Document Interface (MDI) Windows Forms applications. Handling form and control placement and resizing Working with Windows Forms menus Working with Windows Common Dialogs Taking advantage of .NET printer services programmatically Using ASP.NET HTML controls and Web controls Understanding security in ASP.NET Creating, discovering, and consuming web services Accessing data in your .NET applications using ADO.NET Published just in time for the first release of Visual Studio .NET,Programming Visual Basic .NETis sure to become a key component of developers' .NET libraries.