Einführung in SQL

Author: Alan Beaulieu

Publisher: O'Reilly Germany

ISBN: 3897219387

Category: Computers

Page: 353

View: 1118

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.

Oracle8 Database Administration on Windows NT

Author: Lynnwood Brown

Publisher: Prentice Hall Ptr

ISBN: 9780139274435

Category: Computers

Page: 267

View: 7778

Provides database administrators with step-by-step instructions for running Oracle 8 on Windows NT Server, covering installation, tuning, security, networking, application development with PL/SQL, and the latest Oracle enhancements of the Windows NT platform. Original. (Intermediate).

OCP Instructors Guide for Oracle DBA Certification

A Study Guide to Advanced Oracle Certified Professional Database Administration Techniques

Author: Christopher Foot

Publisher: Rampant TechPress

ISBN: 9780974435534

Category: Computers

Page: 336

View: 338

An instructor’s guide for teaching Oracle DBA certification candidates, this book is highly technical and written for Oracle Certified Professional (OCP) DBA instructors who want to ensure that their students successfully pass their Oracle OCP certification exam. Covering those OCP topics that students find the most challenging, instructors will find targeted Oracle OCP testing content, test taking tips, and actual OCP test content. Other test topics covered include database architectures, design review meetings, software installation, database objects, backup and recovery, and tuning and performance.

Oracle Administration and Management

Author: Michael R. Ault

Publisher: John Wiley & Sons

ISBN: 0471274771

Category: Computers

Page: 1008

View: 6004

Many databases are large and complex, making them very difficult to manage. In turn, data can become difficult to access, expensive to store, and even damaged or destroyed. Oracle 9i offers new functionality for the Oracle database system, ensuring that the database runs quickly, efficiently, and reliably. Shows the best techniques, tips, and tools for Oracle systems New edition focuses on the 9i version, but also covers releases 8 and 8i since many organizations still support these versions Companion Web site includes all of the software scripts to manage a database, plus links to lite and demo versions of database management software and other DBA tools

Oracle Desk Reference

Author: Guy Harrison

Publisher: Prentice Hall Ptr

ISBN: N.A

Category: Computers

Page: 520

View: 4452

The Oracle Professional's Everyday Desk Companion. . . . Instant answers for Oracle 7.3, 8 and 8i If you are tired of wading through Oracle's 20 "core" help manuals or their online equivalent, this new desk reference will be a welcome addition to your work space. Take a look inside this book: you will find virtually everything you may ever need to reference, and a really handy format that makes it easy for you to find it! It's your one-stop source for all this... All SQL commands, functions, operators, datatypes and hints PL/SQL and Oracle PL/SQL packages Data Definition Language (DDL) SQL*Plus, Export, Import and more key utilities Oracle Java including SQLJ, JDBC and Java stored procedures Database configuration parameters Plus a handy Oracle glossary, Internet resource list, and more! All the information you need every day, organized for super-fast access. Whether you are an Oracle developer, administrator or user, you will become more productive and efficient with this book at your side.

Abfragen Von Microsoft SQL Server 2012 - Original Microsoft Training Fur Examen 70-461

Author: Itzik Ben-Gan,Dejan Sarka,Ron Talmage

Publisher: Microsoft Press Deutschland

ISBN: 9783866459618

Category: Electronic books

Page: 745

View: 9328

Erlernen Sie das Abfragen von Microsoft SQL Server 2012 und bereiten Sie sich gleichzeitig auf das Examen 70-461 vor. Das vorliegende Buch bietet Ihnen einen umfassenden Lehrbuchteil, mit dem Sie selbstandig lernen und anhand praktischer Ubungen die prufu

Oracle DBA

Interactive Workbook

Author: Melanie Caffrey,Douglas Scherer

Publisher: Pearson P T R

ISBN: 9780130157423

Category: Computers

Page: 457

View: 5851

Introduction TheOracle DBA Interactive Workbookpresents an introduction to Oracle database administration in a unique and highly effective format. It is organized more like a teaching aid than a reference manual in that to learn basic administration techniques, you are challenged to work through a set of guided tasks rather than to read through descriptions. There is a list of additional reading material in Appendix B that you can reference if you wish to delve deeper into any of the topics covered in this book. This book is intended for beginners in the world of Oracle database administration. It will take you through a set of tasks, starting with creating a database to using some of the Oracle database tuning, and backup and recovery utilities. Those experienced with Oracle databases will recognize that a workbook covering the topic of database administration will be an extremely useful introduction for the beginner, but it cannot be used as a deep study of the Oracle database environment. After working through this book, you will have been launched into the exciting and interesting (sometimes nerve-racking) world of database administration, but it will take years of experience to become a senior database administrator. Who this book is for This book is intended for anyone who needs a quick and detailed introduction to Oracle database administration tasks. It is not the intention of this book to provide an in-depth study of the Oracle database server. The foundation for this book was developed to supplement the Introduction to Oracle Database Administration class in the Database Track at Columbia University's Computer Technology and Applications (CTA) program in New York City. The book's sidebars and answers often reflect questions that students have asked in class. The student body entering the CTA program range from those who have years of experience in the IT field but no experience with Oracle, to those with absolutely no experience in IT and even no experience with PCs. The Introduction to Oracle Database Administration class is offered as an elective in the fourth and final term of the CTA program's curriculum. So, while it is geared for beginners with little or no previous experience with Oracle database administration, it is expected that the reader will have some experience working with an Oracle database. The reader should be comfortable with relational database concepts as well as SQL. If you are unfamiliar with any of these subjects, refer to theOracle SQL Interactive Workbookin the Prentice Hall Oracle Interactive Workbook series. What you'll need There are software as well as knowledge requirements necessary to complete the exercise sections of the workbook. Software Oracle 7.3.4, 8.0, or 8i. Access to the WWW. Note that prior to beginning the workbook labs, you should already have installed the Oracle Server software (it will make it easier to get through the labs if you do not install the default database, however) and the Net8 or SQL*Net components. Since the instructions vary greatly depending on the platform, you should consult your Oracle documentation (Installation Guide and Getting Started) for installation information. Oracle 7.3.4, 8.0, or 8i You can use either Oracle Standard Edition or Oracle Enterprise Edition. Since you will be performing actions that may affect other databases, you should not work through the tasks in this book in an environment where there are critical data, programs, etc.! Since Oracle frequently improves and changes its products, new versions are released all the time. However, the concepts covered in this book are fundamental to the Oracle RDBMS (hereafter called the Oracle Server) and are unlikely to change significantly in the near future. Even if your version of the database is slightly different than the one listed here, you should still be able to make use of this book. The tasks and descriptions represent core issues of Oracle Server architecture and are therefore universal to all three versions of the Oracle Server. There are occasional notes to point out a specific issue regarding a specific version. Additionally, you should be familiar with SQL*Plus, the tool supplied with the database to interact with it in a command-line fashion. Access to the WWW You will need access to the Internet and the WWW so that you can access the companion Web site for this book through-- http://www.phptr.com/scherer Here you will find the files that are necessary for completing the exercises. Knowledge To complete the exercises, you should be familiar with relational database concepts and understand what an Entity Relationship Diagram is. You should also be comfortable using SQL to access and manipulate database objects such as tables, constraints, sequences, and so on. If you are not familiar or comfortable with these subjects, then it is recommended that you refer to the Oracle SQL Interactive Workbook in the Prentice Hall Oracle Interactive Workbook series. You should also feel comfortable working in your operating system's command-line environment. How this Book Is Organized The intent of this workbook is to teach you about Oracle database administration by presenting you with a series of tasks and challenges, followed by detailed solutions to those challenges. At times, an individual task acts as a complete unit of work, while other tasks are developed through a series of simple actions. Each chapter has a series of labs that introduce topics. The labs are composed of tasks, which are typical to the daily work of a database administrator. Beyond the labs, topics are further explored through questions and answers. What follows is the common layout of the chapters: Chapter Objectives A list of subjects the chapter will cover. Chapter Text An overview of chapter subjects. Lab Objectives A list of subjects the lab will cover. Lab Text An introduction to the lab subject, occasionally including steps that prepare the Oracle Server for the exercises. Exercises Questions that require hands-on interaction with the Oracle Server. The exercises will guide you through learning the subject introduced in the lab text. Exercise Answers Answers and discussion of the exercise subject. Self-Review Questions Multiple-choice questions to review lab material. Test Your Thinking Project questions to supplement the lab material. Depending on the breadth of the subject, a given chapter may have more than one lab, and a given lab may have more than one set of exercises. The exercises are not meant to be closed-book quizzes to test your knowledge. On the contrary, they are intended to act as your guide and walk you through a task. You are encouraged to flip back and forth from the question section to the answer section so that, if need be, you can read the discussions as you go along. The chapters and their exercises must be completed in sequence as the material in later chapters builds on what is presented earlier. Chapter 1, "The Database Administrator's Job," introduces you to the world of database administration. Chapter 2, "Creating Your Database," walks you through the steps of manually creating your own database. Chapter 3, "Oracle Networking: Configuring Basic Net8/SQL*Net Components," guides you through setting up the components necessary for remote users to connect to your database over a network. Chapter 4, "Tablespaces," teaches you how to create and manipulate tablespaces, and introduces you to logical storage constructs. Chapter 5, "Segments and Extents," provides a more in-depth look at these higher level logical storage constructs, which were introduced in Chapter 4. Chapter 6, "Data Blocks," examines data blocks, the smallest unit of Oracle storage. Chapter 7, "Redo Logs," teaches you the basics of how redo logs operate and how they are written to. Chapter 8, "Datafiles," describes how to view information about and manipulate datafiles. Chapter 9, "User Creation," teaches you how to create and alter user accounts. Chapter 10, "Privilege and Resource Groups," introduces you to the concepts and effects of privileges, roles, and resource limits and shows you how to assign them to user accounts. Chapter 11, "Auditing," examines Oracle's mechanism for recording different types of database activity for purposes of maintaining database security and/or keeping records of billable activity. Chapter 12, "Rollback Segments," presents a study of the use and operation of rollback segments and how they provide an Oracle database with read-consistency and "undo" information. Chapter 13, "Locking," guides you through exercises that demonstrate the importance of Oracle locking mechanisms and introduces you to the concepts of data "consistency" and "concurrency." Chapter 14, "Logical Backup and Recovery," covers logical data backups and recoveries using the Oracle-provided import (IMP) and export (EXP) utilities. Chapter 15, "Physical Backup and Recovery," teaches you about different types of database failures, walks you through a simulation of a physical database failure and recovery, and explains the importance of archiving your redo log files. Chapter 16, "Application and SQL Optimization," provides a look at optimizing standalone and application SQL code through Oracle-provided facilities such as AUTOTRACE, SQLTRACE, and TKPROF. Chapter 17, "Database Tuning and Optimization," presents an introductory look at the other side of tuning an Oracle database by showing you how to gather information about and, if necessary, tune your memory and disk I/O through the use of the Oracle-provided utilities, UTLBTAT.SQL and UTLESTAT.SQL. About the companion web site The companion Web site is located at http://www.phptr.com/scherer Here you will find two very important items: Files you will download for specific tasks in the workbook. Answers to the Test Your Thinking questions. Also, check the Web site for periodically updated information about the book. IMPORTANT notes about COMPLETING THE exercises Complete the chapters and exercises in the order they're given. If the labs, exercises, and steps are not done in their proper sequence, you may have to start from the first chapter and work your way back into the material. This is similar to performing these tasks in a real-world environment. Database administration is less forgiving than application coding. In database administration, you cannot simply recompile your code and try the application again. If you leave out a step, you may lose a portion of the database in a way that is unrecoverable--losing your work. The only exception to this is Chapter 3, "Oracle Networking: Configuring Basic Net8/SQL*Net Components," which can be completed after all of the other chapters. In Chapter 2, you will learn about the command SHUTDOWN IMMEDIATE. After successfully completing Chapter 2, you should, from then on perform a SHUTDOWN IMMEDIATE on your database before rebooting or shutting down your computer. For Chapters 2, 3, 13, 15, and 17, you should allocate enough time to finish from beginning to end. It can take from 45 minutes to a couple of hours to complete the exercises in each chapter. The other chapters will flow better if you complete them in one sitting, but it is not as critical to your database if you are unable to do so. Check off the steps as you complete them. The most frequent error students make in the CTA course is not following each step, no matter how insignificant it seems. Learn to walk before you run. If you think there's a better way to accomplish an activity, don't try it out until you've completed the entire Oracle DBA Interactive Workbook. Some of the steps are in the text and some are explicitly in the exercises. If you check off each step as you go along, you will be more inclined to perform each task, and will have a way to trace whether you've missed a step if you run into trouble. The questions require you to think like an Oracle DBA. For example, you may be asked to look into an Oracle-provided script and report what you think it will do based on the information in the script. In another example, you may perform an exercise to make the database freeze. You're then asked to figure out what the problem is and what the next step should be to fix the problem, based on the knowledge that you've gained by that point in the book. Of course, the solution is given to you, but do your best to consider the problem before reading the provided answer. In either case, make your solution to the problem fall within the scope of the problem set in the chapter. This will be good practice for your work as a DBA, when you will be required to stay focused under pressure. For those completing the tasks in Windows, you should have administrative rights to the machine where the database is located.

SQL für Dummies

Author: Allen G. Taylor

Publisher: John Wiley & Sons

ISBN: 3527810897

Category: Computers

Page: 440

View: 3405

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.

MySQL Tutorial

Die kompakte Einführung in die Arbeit mit MySQL

Author: Luke Welling,Laura Thomson

Publisher: Pearson Deutschland GmbH

ISBN: 9783827321695

Category:

Page: 286

View: 996


Oracle 8i DBA

Architecture and Administration Certification Bible

Author: Damir Bersinic,Todd Ross,Yury Sabinin

Publisher: Wiley

ISBN: 9780764548178

Category: Computers

Page: 1167

View: 9009

This book delivers comprehensive coverage of exam objectives, presented according to Oracle's certification guide. Because Oracle's exam scoring provides section scores according to exact objectives, this organization of the book allows you to refocus. Each exam objective is covered in a chapter complete with self-assessment opportunities. Four appendices include a listing and description of Oracle's initialization parameters and other elements to be tested on the exam. These appendices provide information useful post-exam in real-work implementation of Oracle Systems.

Oracle SQL Interactive Workbook

Author: Alice Rischert

Publisher: Prentice Hall Professional

ISBN: 9780131002777

Category: Computers

Page: 851

View: 3227

Oracle SQL Interactive Workbook, Second Edition is the only integrated book-and-Web learning solution that teaches all the Oracle 9i SQL skills you need, hands on, through labs, exercises, and projects-complete with a Web-based training site! Fully updated for Oracle 9i, author Alice Rischert covers all types of joins (including the new ANSI join syntax); SQL functions; subqueries set operators; sequences, views, and indexes; data dictionary; dynamic SQL; security; optimization; the SQL*Plus and iSQL*Plus environments; and much more.

3 in 1: The Complete Simulated Three CISCO Exams for the CISCO CCNA/CCENT ICND1 Certification Exam 640-822 with 160 Most Difficult Questions and Answers with Comprehensive Explanations (First Edition Nov 2010)

Author: Thaar Al_taiey

Publisher: Thaar AL_Taiey

ISBN: 0983121206

Category:

Page: 146

View: 5613

A book that Simulates Three CISCO Exams for the CISCO CCNA/CCENT ICND1 Certification Exam 640-822 with 160 Most Difficult Questions and Answers with Comprehensive Explanations.

Expert Oracle Practices

Oracle Database Administration from the Oak Table

Author: Pete Finnigan,Alex Gorbachev,Tim Gorman,Charles Hooper,Jonathan Lewis,Niall Litchfield,Robyn Sands,Joze Senegacnik,Riyaj Shamsudeen,Jeremiah Wilton,Graham Wood,Connie Green,Karen Morton,Randolf Geist,Uri Shaft,Melanie Caffrey

Publisher: Apress

ISBN: 1430226684

Category: Computers

Page: 592

View: 6242

This book is an anthology of effective database management techniques representing the collective wisdom of the OakTable Network. With an emphasis upon performance—but also branching into security, national language, and other issues—the book helps you deliver the most value for your company’s investment in Oracle Database technologies. You’ll learn to effectively plan for and monitor performance, to troubleshoot systematically when things go wrong, and to manage your database rather than letting it manage you. What you’ll learn Adopt a rational approach to database management; eliminate guesswork Add value to your organization as a database professional Manage and optimize performance Exploit different platform technologies Secure your organization's data Gain deep understanding of database internals and structures Who this book is for This book is aimed at Oracle database administrators who want to further their careers by implementing sound and proven database administration practices—and especially repeatable and predictable practices—in their daily work. Table of Contents Battle Against Any Guess A Partly Cloudy Future Developing a Performance Methodology The DBA as Designer Running Oracle on Windows Managing SQL Performance PL/SQL and the CBO Understanding Performance Optimization Methods Choosing a Performance Optimization Method Managing the Very Large Database Statistics Troubleshooting Latch Contention Measuring for Robust Performance User Security Securing Data