Oracle SQL Developer 2.1 : Design and Develop Databases Using Oracle SQL Developer and Its Feature-rich, Powerful User-extensible Interface with This Book and EBook
Saved in:
| Title: | Oracle SQL Developer 2.1 : Design and Develop Databases Using Oracle SQL Developer and Its Feature-rich, Powerful User-extensible Interface with This Book and EBook |
|---|---|
| Description: | Database design and development using this feature-rich, powerful user-extensible interfaceKey FeaturesInstall, configure, customize, and manage your SQL Developer environmentIncludes the latest features to enhance productivity and simplify database developmentCovers reporting, testing, and debugging conceptsMeet the new powerful Data Modeling tool ñ Oracle SQL Developer Data ModelerDetailed code examples and screenshots for easy learningBook DescriptionAs technology rapidly evolves, many developers are looking for valuable tools to assist them with their daily tasks. When dealing with databases, a clean, easy-to-navigate interface for working and browsing is essential. Oracle SQL Developer is a graphical user interface that makes life much easier by allowing you to browse database objects, run SQL statements and scripts, and create, edit, and debug PL/SQL statements in the most efficient way. It enhances productivity and simplifies your database development tasks. Although the SQL Developer journey looks simple and easy, there are many areas that can go undiscovered, leaving you just scratching the surface. It's easy to get started and master this powerful tool with this book to hand. It will provide you with in-depth details about all aspects of using SQL Developer to assist you in your day-to-day database tasks and activities. You will learn to utilize SQL Developer's extensible environment to support your ongoing needs This book offers detailed instructions for installing, configuring, and effectively using Oracle SQL Developer. You will learn how to utilize every feature of this development tool and make the most out of it. While none of the tasks are complex, the book progresses from the easy, most commonly used features, such as browsing objects and writing queries in the SQL Worksheet, to the more involved and possibly less frequently used features, such as Tuning and Testing SQL and PL/SQL, and adding User Extensions, and finally to those features used by a smaller more targeted audience, such as Migrations, Oracle APEX, and the Data Modeler. Throughout the book there are tips and suggestions gathered as a result of working with the current SQL Developer user base. This book will also show you how to assess the health of your database with built-in as well as customized reports. By the end of the book you will be confident in making the best use of SQL Developer, and be able to set up and maintain a productive environment for quick and easy database development.What you will learnBuild complex queries based on a number of tables using visual Query BuilderAssess the health of your database, data structure of your application, and data in that application with built-in as well as user-defined reportsCreate, compile, and debug PL/SQL code and explore available features to facilitate writing PL/SQL codeIntegrate your SQL Developer with open source version control systems CVS and Subversion, which allow checking out of files from a repository, editing, and checking them back inEnter and execute your SQL, PL/SQL, and SQL•Plus statements with the SQL Worksheet interfaceProduce easily replicable scripts that copy and move data from one database instance to another, or from one schema to anotherCreate advanced database connections using a variety of connection and authentication types available for Oracle as well as non-Oracle databasesCreate, review, and update database schema designs with SQL Developer Data ModelerAugment your environment with features that are specific to your needs by extending your SQL Developer with XML structured user-defined extensionsMonitor and manage your Application Express applications by integrating with SQL DeveloperSet up an easy and quick migration environment for your database schema by using the migrat |
| Authors: | Susan Harper |
| Resource Type: | eBook. |
| Subjects: | Database design--Software, SQL (Computer program language) |
| Categories: | COMPUTERS / Information Technology |
| Database: | eBook Collection (EBSCOhost) |
| FullText | Links: – Type: ebook-pdf – Type: ebook-epub Text: Availability: 0 |
|---|---|
| Header | DbId: nlebk DbLabel: eBook Collection (EBSCOhost) An: 334488 RelevancyScore: 1025 AccessLevel: 6 PubType: eBook PubTypeId: ebook PreciseRelevancyScore: 1024.62744140625 |
| IllustrationInfo | |
| ImageInfo | – Size: thumb Target: https://rps2images.ebscohost.com/rpsweb/othumb?id=NL$334488$PDF&s=r – Size: medium Target: https://rps2images.ebscohost.com/rpsweb/othumb?id=NL$334488$PDF&s=d |
| Items | – Name: Title Label: Title Group: Ti Data: Oracle SQL Developer 2.1 : Design and Develop Databases Using Oracle SQL Developer and Its Feature-rich, Powerful User-extensible Interface with This Book and EBook – Name: Abstract Label: Description Group: Ab Data: Database design and development using this feature-rich, powerful user-extensible interfaceKey FeaturesInstall, configure, customize, and manage your SQL Developer environmentIncludes the latest features to enhance productivity and simplify database developmentCovers reporting, testing, and debugging conceptsMeet the new powerful Data Modeling tool ñ Oracle SQL Developer Data ModelerDetailed code examples and screenshots for easy learningBook DescriptionAs technology rapidly evolves, many developers are looking for valuable tools to assist them with their daily tasks. When dealing with databases, a clean, easy-to-navigate interface for working and browsing is essential. Oracle SQL Developer is a graphical user interface that makes life much easier by allowing you to browse database objects, run SQL statements and scripts, and create, edit, and debug PL/SQL statements in the most efficient way. It enhances productivity and simplifies your database development tasks. Although the SQL Developer journey looks simple and easy, there are many areas that can go undiscovered, leaving you just scratching the surface. It's easy to get started and master this powerful tool with this book to hand. It will provide you with in-depth details about all aspects of using SQL Developer to assist you in your day-to-day database tasks and activities. You will learn to utilize SQL Developer's extensible environment to support your ongoing needs This book offers detailed instructions for installing, configuring, and effectively using Oracle SQL Developer. You will learn how to utilize every feature of this development tool and make the most out of it. While none of the tasks are complex, the book progresses from the easy, most commonly used features, such as browsing objects and writing queries in the SQL Worksheet, to the more involved and possibly less frequently used features, such as Tuning and Testing SQL and PL/SQL, and adding User Extensions, and finally to those features used by a smaller more targeted audience, such as Migrations, Oracle APEX, and the Data Modeler. Throughout the book there are tips and suggestions gathered as a result of working with the current SQL Developer user base. This book will also show you how to assess the health of your database with built-in as well as customized reports. By the end of the book you will be confident in making the best use of SQL Developer, and be able to set up and maintain a productive environment for quick and easy database development.What you will learnBuild complex queries based on a number of tables using visual Query BuilderAssess the health of your database, data structure of your application, and data in that application with built-in as well as user-defined reportsCreate, compile, and debug PL/SQL code and explore available features to facilitate writing PL/SQL codeIntegrate your SQL Developer with open source version control systems CVS and Subversion, which allow checking out of files from a repository, editing, and checking them back inEnter and execute your SQL, PL/SQL, and SQL•Plus statements with the SQL Worksheet interfaceProduce easily replicable scripts that copy and move data from one database instance to another, or from one schema to anotherCreate advanced database connections using a variety of connection and authentication types available for Oracle as well as non-Oracle databasesCreate, review, and update database schema designs with SQL Developer Data ModelerAugment your environment with features that are specific to your needs by extending your SQL Developer with XML structured user-defined extensionsMonitor and manage your Application Express applications by integrating with SQL DeveloperSet up an easy and quick migration environment for your database schema by using the migrat – Name: Author Label: Authors Group: Au Data: <searchLink fieldCode="AR" term="%22Susan+Harper%22">Susan Harper</searchLink> – Name: TypePub Label: Resource Type Group: TypPub Data: eBook. – Name: Subject Label: Subjects Group: Su Data: <searchLink fieldCode="DE" term="%22Database+design--Software%22">Database design--Software</searchLink><br /><searchLink fieldCode="DE" term="%22SQL+%28Computer+program+language%29%22">SQL (Computer program language)</searchLink> – Name: SubjectBISAC Label: Categories Group: Su Data: <searchLink fieldCode="ZK" term="%22COMPUTERS+%2F+Information+Technology%22">COMPUTERS / Information Technology</searchLink> |
| PLink | https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=nlebk&AN=334488 |
| RecordInfo | BibRecord: BibEntity: Classifications: – Code: 005.7565 Scheme: ddc Type: prePub Languages: – Code: eng Text: English Subjects: – SubjectFull: Database design--Software Type: general – SubjectFull: SQL (Computer program language) Type: general Titles: – TitleFull: Oracle SQL Developer 2.1 : Design and Develop Databases Using Oracle SQL Developer and Its Feature-rich, Powerful User-extensible Interface with This Book and EBook Type: main BibRelationships: HasContributorRelationships: – PersonEntity: Name: NameFull: Susan Harper – PersonEntity: Name: NameFull: Susan Harper IsPartOfRelationships: – BibEntity: Dates: – D: 01 M: 01 Type: published Y: 2009 – D: 04 M: 02 Type: profile Y: 2014 Identifiers: – Type: isbn-print Value: 9781847196262 – Type: isbn-electronic Value: 9781847196279 Titles: – TitleFull: Oracle SQL Developer 2.1 : Design and Develop Databases Using Oracle SQL Developer and Its Feature-rich, Powerful User-extensible Interface with This Book and EBook Type: main |
| ResultId | 1 |
