Oracle SQL: A Beginner's Tutorial : A Beginner's Tutorial

This introduction to SQL for the Oracle database begins by discussing exactly how data is stored and maintained in a relational database, familiarizing readers with SQL INSERT, UPDATE, and DELETE statements. The guide then discusses how to construct basic queries, choose an appropriate output, and how to create and use groups. Readers will also learn how to use joins to query data from multiple tables, how to create predefined views that can be stored in a database, and how to utilize the metadata of a database. Appendices round out the book, covering the various indexing techniques available in the Oracle database and discussing how to install Oracle Database Express Edition and list the Oracle built-in data types. Questions -- Chapter 14: Nested and Inner Classes -- An Overview of Nested Classes -- Static Nested Classes -- Member Inner Classes -- Local Inner Classes -- Anonymous Inner Classes -- Behind Nested and Inner Classes -- Summary -- Questions -- Chapter 15: Swing Basics -- AWT Components -- Useful AWT Classes -- Basic Swing Components -- Summary -- Questions -- Chapter 16: Swinging Higher -- Layout Managers -- Event Handling -- Working with Menus -- The Look and Feel -- Fast Splash Screens -- System Tray Support -- Desktop Help Applications -- Summary -- Questions -- Chapter 17: Polymorphism -- Defining Polymorphism -- Polymorphism in Action -- Polymorphism in a Drawing Application -- Polymorphism and Reflection -- Summary -- Questions -- Chapter 18: Annotations -- An Overview of Annotations -- Standard Annotations -- Common Annotations -- Standard Meta-Annotations -- Custom Annotation Types -- Summary -- Questions -- Chapter 19: Internationalization -- Locales -- Internationalizing Applications -- An Internationalized Swing Application -- Summary -- Questions -- Chapter 20: Applets -- A Brief History of Applets -- The Applet API -- Security Restrictions -- Writing and Deploying Applets -- How AppletViewer Works -- Passing Parameters to an Applet -- SoundPlayerApplet -- JApplet -- Applet Deployment in a JAR File -- Faster Loading -- Summary -- Questions -- Chapter 21: Java Networking -- An Overview of Networking -- The Hypertext Transfer Protocol (HTTP) -- java.net.URL -- java.net.URLConnection -- java.net.Socket -- java.net.ServerSocket -- A Web Server Application -- Summary -- Questions -- Chapter 22: Java Database Connectivity -- Introduction to JDBC -- Four Steps to Data Access -- Closing JDBC Objects -- Reading Metadata -- The SQLTool Example -- Summary -- Questions -- Chapter 23: Java Threads -- Introduction to Java Threads Table of Contents......Page 3 Introduction......Page 7 Chapter 1 Storing and Maintaining Data......Page 11 Chapter 2 Basic Queries......Page 19 Chapter 3 Query Output......Page 31 Chapter 4 Grouping......Page 47 Chapter 5 Joins......Page 53 Chapter 6 Subqueries......Page 69 Chapter 7 Compound Queries......Page 79 Chapter 8 Views......Page 85 Chapter 9 Built-in Functions......Page 91 Chapter 10 PL/SQL......Page 103 Chapter 11 The Data Dictionary......Page 113 Appendix A Installing Oracle Database XE......Page 119 Appendix B Oracle Built-in Data Types......Page 127 Appendix C Indexes......Page 129 Index......Page 133 A Books24x7's TOP 10 title for 4 consecutive years! Java is an easy language to learn. However, you need to master more than the language syntax to be a professional Java programmer. For one, object-oriented programming (OOP) skill is key to developing robust and effective Java applications. In addition, knowing how to use the vast collection of libraries makes development more rapid. This book introduces you to important programming concepts and teaches how to use the Java core libraries. It is a guide to building real-world applications, both desktop and Web-based. The coverage is the. Cover Page; Title Page; Copyright Page; Table of Contents; Introduction; Java, the Language and the Technology; An Overview of Object-Oriented Programming; About This Book; Downloading and Installing Java; Downloading Program Examples and Answers; Chapter 1: Your First Taste of Java; Your First Java Program; Java Code Conventions; Integrated Development Environments (IDEs); Summary; Questions; Chapter 2: Language Fundamentals; ASCII and Unicode; Separators; Primitives; Variables; Constants; Literals; Primitive Conversions; Operators; Comments; Summary; Questions; Chapter 3: Statements. Djoni Darmawikarta. Date Of Publication From Resource Description Page (safari, Viewed Dec. 3, 2013).