Microsoft SQL Server is a relational database management
system (RDBMS) produced by Microsoft. Its primary query language is
Transact-SQL, an implementation of the ANSI/ISO standard Structured
Query Language (SQL). SQL
Server 2005, the latest version, provides a single management
console for anywhere administration, and an extensible management
infrastructure that can be easily programmed using SQL Management
Objects.
The following are five great Free Training
web resources
for learning how to use and administer Microsoft SQL Server 2005.
SQL
Server 2005 Samples and Sample Databases:
Here
are over 100 code samples for SQL Server 2005, along with three sample
databases. While
targeted at beginners, even expert programmers will find these
useful. The samples download provides over 100
samples for SQL Server 2005, demonstrating the following components:
Database Engine,
including
administration, data access, Full-Text
Search, Common Language Runtime (CLR) integration, Server Management
Objects (SMO), Service Broker, and XML
Analysis
Services
Integration Services
Notification
Services
Reporting Services
Replication
Five Free SQL Server 2005 Video
Tutorials LearnSqlServer.com has made
available five free video tutorials on SQL
Server 2005. They make available several free SQL Server training
videos at any given time for different skill levels ("100" for
beginners, "500" for guru-level), and each month rotate these so you
can see more of their training for free.
SQL Server 2005 SP1 CTP Available for
Download SQL Server Express users will gain Reporting
Services and FullText
Search with the first service pack for SQL Server 2005.
This article gives a detailed, illustrated description of the first
Community Technical Preview of SQL Server 2005 SP1, which
updates all editions and online books.
SQL Server 2005 for the Database Developer This technical article explains and describes many
of the new features in SQL Server 2005. It
covers topics such as Choosing between Transact-SQL and managed
code, Web services, ADO.NET and ADO.NET notification support.
Eclipse is a general purpose professional open source IDE (integrated development
environment) for programming and application development. It is primarily used with
the Java programming language and is becoming the most popular Java development
environment and IDE. I have spent some time searching the Internet for the best
Eclipse tutorials and learning materials available for no cost. Here are my selections,
categorized between the Best Video Eclipse Tutorials
and the Best Eclipse Tutorials. Many of these
will show and teach you how to install and start programming immediately using Java
and Eclipse.
Tools for building HTML/Javascript and so-called AJAX-style applications are
sparse. Mozilla has traditionally had the best tools in Venkman and its DOM Inspector,
but recently development has been stagnant and these tools do not offer integration
with active code development. The Eclipse AJAX Toolkit Framework brings these types
of tools into the Eclipse IDE -- making use of the Java XPCOM to Java bridge and
leveraging the robust features of Eclipse, while leaving the environment pluggable
for more enhancements.
This course is taught as a two day seminar, and incorporates installation of the
Eclipse Platform Java Development Tools and the CodeRally package, for which you’ll
develop some samples plug-in tools for Eclipse. The courseware is created as part
of the Open Source “ECESIS” project which is hosted by Eclipse.
The streaming video version of the Eclipse Course lessons are available online at:
SYS-CON.TV Webcast: Eclipse IDE For Students, Useful Eclipse Tips and Tricks
Lesson 10 In the popular "Java Basics" SYS-CON.TV Education Series by Yakov Fain.
In this chapter he helps you to download and install the Eclipse IDE, create your
first project project, and after this we'll be creating all our programs there.
Using open source to develop Web applications, EJBs, and Web services. In this tutorial,
you'll learn how to develop and deploy a JSP Web application with WTP in less than
an hour. I'll also cover the creation and deployment of a basic servlet and editing
JSP with WTP.
This site contains some tutorials and example programs that will help programmers
who are new to Eclipse and the Standard Widget Toolkit (SWT) install Eclipse correctly
and run some simple Java/SWT programs. The main focus of this site is illustrating
the use of the SWT for developing Java-based desktop applications
There are several steps that must be completed to set up Eclipse and further steps
to start up a new Java project. This tutorial explains each step with words and
graphics from the Eclipse IDE.
This tutorial is about building Java 2 Platform, Enterprise Edition (J2EE)
components using Eclipse as an Integrated Development Environment (IDE) and JBOSS
as the Application Server. Tutorial covers step-by-step development of J2EE components,
starting from setting up Eclipse, JBOSS and Lomboz. Lomboz uses Xdoclet (Attribute
Oriented Programming) for rapid development of J2EE components. All of the tools
used in this tutorial can be downloaded free of charge.
This tutorial explains basics about EJB3 and shows a simple work through to set
up a EJB 3 project, create a entity bean and a session bean façade using
Eclipse and Ant.
Javadoc Configuration Tutorial - how to configure Eclipse so that java documentation
can be created for projects and packages, and shows how to view Java documentation
for the standard Java API.
Eclipse Export Tutorial- how to export a project as a zip file, how to export
a project as a file syste and how to export a java application as a JAR file.
Eclipse Import Tutorial - how to import a project into a workspace, how
to import files and packages into a workspace.
Eclipse Extenal JAR Tutorial - how to create a JAR file for a package, how to
put an external JAR file on the project classpath, and how to access java documentation
stored in a JAR file.
This Eclipse tutorial is for students who are currently taking a Java
course that uses Eclipse and for Java programmers who want to develop Java projects
using Eclipse (20 pages, pdf format). It covers the following topics:
One of the benefits that Eclipse provides is the ability to run code interactively
by using its integrated debugger. Examining variables and expressions while executing
code step-by-step is an invaluable tool for investigating problems with your code.
In this article, the Eclipse Workbench will be explored in more detail. Specifically,
the Workbench "parts" — the views and editors that make up most Workbench
applications — will be reviewed.
At the completion of the tutorial, you will understand the concept of the Java Servlet
and be familiar with the ways to create Java Servlet using Eclipse 3.1.2. In this
tutorial, we are going to create one dynamic web application.
This tutorial tries to highlight the advantages of using Eclipse for programming
in Java. It serves as a detailed guideline for beginner users. No specific or advanced
Java knowledge is required in order to follow this tutorial. In few minutes you
will be able to master some main Eclipse techniques that will boost your productivity.
Java Development
on Eclipse, Part 1
Steve Holzner contends that Eclipse makes it easier to create Java code from scratch.
In this excerpt from Chapter 2 of his book, Eclipse, Steve shows how Eclipse makes
it easy to create new methods, classes, and packages, and more.
Java Development on Eclipse, Part 2
In the conclusion to this two-part excerpt from Eclipse, author Steve Holzner covers
creating Javadocs, refactoring, and adding to your Java skills.
An Introduction to the Eclipse IDE
Eclipse, an open source Java-based IDE, brings together all of the tools a developer
needs to be successful at Web application development: an extensible IDE, a standards-based
compiler, remote debugging, Ant-based builds, JUnit-based testing, and plug...
Eclipse Web Tools
Jeffrey Liu and Lawrence Mandel introduce the Eclipse Web Tools Platform (WTP),
which offers an Eclipse-based set of web app tools to create and manipulate EJBs,
web services, data stores, and JSPs.
Eclipse Plugins Exposed, Part 1: A First Glimpse
An OnJava.com monthly column is about writing plugins in Eclipse. The prerequisites
for starting to write Eclipse plugins are knowing how to use Eclipse and write Java
programs, and having a good understanding of the Standard Widget Toolkit (SWT) and
Swing. In this first installment of the column, let's explore the Eclipse plugin
environment.
Integrating Ant with Eclipse, Part 1
In this except from Ant: The Definitive Guide, 2nd Edition, Steve Holzner shows
how to integrate Ant with the Eclipse IDE.
Integrating Ant with Eclipse, Part 2
In this excerpt from Ant: The Definitive Guide, 2nd Edition, Steve Holzner shows
how to customize your Ant/Eclipse integration.
Working with Hibernate in Eclipse
Jim Elliott explores Hibernate Synchronizer -- a plugin that automatically updates
your Java code when you change your mapping document. Jim takes you through the
plugin's installation, configuration, code generation, and more.
This site
repository hosts several freely available books and ebooks covering the
following areas and topics: Algorithms, BSD, C++, CORBA, DOS, Hardware,
LDAP, Linux, Mobile,
Network, OpenGL, SQL, Security, Unix, Windows, X Window System, and
XML. The Development
folder contains books and ebooks for these topics: Application and System Design,
Software Architecture, Compilers, Design
Patterns, Debugging, Embedded Systems Design, Error Handling, Extreme
Programming, Game Development, UML, Software Development Methods and
Tools, Object-Oriented Design, Parsing Techniques, and Refactoring.
This C# (CSharp) Tutorial Course
consists of a comprehensive review and
demonstration of the
main components of the C# language, along with a review of software
application development in .NET (dotNET). It provides you with lab
exercises with solutions, and online
quizzes.
This tutorial is a comprehensive tour of
C#, which is one of the primary
languages used to develop applications for the Microsoft .NET platform.
It is written for experienced programmers who have no C# or .NET
experience. The
tutorial begins with an brief overview of software development in .NET.
It then turns to the core of the C# language, covering basic topics and
object-oriented language features. Free
registration is required to access this course.
C#
Tutorial Course Overview C#
Tutorial Modules (free
registration needed for access) 1.
.NET Overview Learn about the languages, libraries,
servers, services, and tools that
make up .NET and then look at the .NET
software development model consisting of C# source code, compiler,
intermediate
language, and the Common Language Runtime execution engine. Topic
ExercisesQuiz 2.
Basics This module teaches core
C# functionality such as application
entry point, simple types, variables, basic input and output,
operators, arrays, control constructs, comments etc. TopicExercisesQuiz 3.
Classes Get introduced to C# classes and learn about
instance fields and methods, access control, and object creation. TopicExercisesQuiz
4.
Initialization Understand how
C# supports initialization via default values,
variable initializers, and instance constructors. Topic
ExercisesQuiz 5.
Static How to define static fields and methods and
how to access
static members using any of the three initialization alternatives:
default values, static variable initializers, and static
constructor. TopicExercisesQuiz
6.
Reference Types Review the topics
concerning references: assignment,
parameter, aggregation, array, null, memory management, and garbage
collection. TopicExercisesQuiz 7.
Properties Properties model the
traits of an object or a class. As a design, learn how properties
maintain
encapsulation and allow the execution of validation code. TopicExercisesQuiz 8.
Indexers Indexers used used to index a
collection of data elements. The elements are accessed
using the same square bracket syntax used for an array. TopicExercisesQuiz 9.
Inheritance This module discusses the
syntax and the meaning of
inheritance including access levels, method hiding, method chaining,
and construction. TopicExercisesQuiz
10.
Binding Learn about inheritance: type compatibility,
type conversion, method binding, method overriding, and abstract
methods. Also review how to use dynamic binding to
achieve polymorphic behavior. TopicExercisesQuiz 11.
Interface Discover how to define and
implement interfaces, how to code
generic code against an interface, and how to use inheritance with
interfaces. TopicExercisesQuiz
12.
Exceptions This module teaches C# error exception
notifications and demonstrates to how to handle an exception
and its related control
flow, and how to implement a
custom exception type. TopicExercisesQuiz 13.
Namespace How to
create a namespace, access a type defined inside a namespace,
and how to apply 'using keyword' to get access to namespace
members. TopicExercisesQuiz
14.
Delegates and Events A delegate acts as a proxy for
invoking a method. This module teaches how to define a delegate type,
use a
delegate to implement a callback, and use composition to create a
delegate
with multiple targets.
TopicExercisesQuiz
This is web-based tutorial course that teaches the history
of markup languages, the evolving family of XML technologies, and the
basics of XML syntax. It is geared specifically towards the programmer
who needs a quick introduction to XML technology before diving into the
complexity that lurks beneath the surface of the various XML
specifications. It introduces programmers to the past, present, and
future of XML
technology in an interactive, tutorial-based fashion. Free
registration is required to access this course.
After
successfully completing this tutorial, you should understand:
The history
of markup
languages and understand why they are so popular today
