Part - ILaying the Foundation * Introducing SQL Server * Modeling the Logical
Database Schema * Installing and Configuring SQL Server * Using SQL Server's
Developer Tools
Part - II
Developing SQL Server Databases * Implementing the Physical Database Schema *
Retrieving Data with Select * Merging Data Using Relational Algebra * Searching
Full-Text Indexes * Creating Views * Modifying Data * Transactional Integrity *
Programming with Transact-SQL * Developing Stored Procedures * Building
User-Defined Functions * Implementing Triggers * Advanced Server - Side
Programming
Part - III
Data Connectivity * Transferring Databases * Working with Distributed Queries
* Migrating Data with DTS * Replicating Databases * ADO and ADO.NET * XML and
Web Publishing
Part - IV
Administering SQL Server * Configuring SQL Server * Maintaining the Database
* Automating Database Maintenance with SQL Server Agent * Recovery Planning *
Securing Databases
Part - V
Advanced Issues * Advanced Performance * Advanced Availability * Advanced
Scalability * Analysis Services * Advanced Portability.
Revised and updated by one of the co-developers of the (310-035) Programmer exam, this edition offers complete coverage of the Sun Certified Programmer for Java 2 exam objectives and newly added, complete coverage of both portions of the Sun Certified Java 2 Developers exam. More than 250 challenging practice questions have been completely revised to closely model the format, tone, topics, and difficulty of the real exam. An integrated study system based on proven pedagogy, exam coverage includes step-by-step exercises, special Exam Watch notes, On-the-Job elements, and Self Tests with in-depth answer explanations to help reinforce and teach practical skills. The Only Certification Study System Based on 300,000+ Hours of IT Training Experience.
Table of contents : Part I: The Programmer’s Exam
· Language Fundamentals
· Declarations and Access Control
· Operators and Assignments
· Flow Control, Exceptions and Assertions
· Object Orientation, Overloading and Overriding, Constructors and Return Types Java.lang-The Math Class, Strings and Wrappers
· Objects and Collections
· Inner Classes
· Threads
Part II: The Developer’s Exam
· Introduction to the SCJD
· Coding Standards
· Clarity and Maintainability
· Designing and Graphical User Interface
· Networking Issues
· Database Issues
· Exam Documentation
· Final Submission and Essay
About Author : Kathy Sierra is a senior Java instructor at Sun Microsystems, Inc. and is actively involved in the development of Sun’s programmer and developer exams. She is the founder of javaranch.com, considered the largest Java certification preparation Web site. Kathry is a contributing author to Mike Meyers’ Java 2 Certification Passport.
Bert Bates is a Sun Certified Java Programmer 1.4, a Java instructor, and has been developing software for more than 20 years. He participated in the development of Sun’s ePractice exam simulation for 310-035.