SQL Tutorials For Easy Learning
SQL is a powerful tool with a great deal of flexibility. It is used for accessing
and extracting information from databases and is probably the most important
programming language presently in use.
The latest Microsoft SQL Server 2005 includes SQL tutorials to help you gain
the skills and knowledge necessary to get started with your projects. These
give step-by step lessons so you can work effectively from beginning to end.
SQL tutorials cover the following areas: -
- Server Tools SQL tutorials shows how you can provide an intense and flexible
work surface. This tutorial teaches you how to organize the SQL Server Management
Studio and is divided into four lessons. This includes allocating more space
on the desktop by moving unwanted windows out of view, quickly accessing information
which you need, managing script projects and using the recently added features
of the SQL Editor
- Analysis Services - These SQL tutorials show you how to use Analysis Services
and sample databases are provided for you to install and practice with using
a fictitious company for all illustrations.
- Database Engine - there is two SQL tutorials in this section, which teaches
how to use Database Engine. The first is for persons who are new to SQL Server
and it is divided into two lessons, these lessons include connecting to the
database engine from your computer and from a second computer, enabling protocols
and others to connect, configuring ports and firewall settings. The second
includes creating database objects, configuring secure access and accessing
and changing data.
- Data Mining - this includes three SQL tutorials about Data Mining. The first
shows how to build and work with many different types of mining models and
uses sample databases as a foundation for the scenarios. In the second you
will make predictions to decide whether a customer will purchase a bicycle
using Data Mining Extensions query language. The last tutorial in this section
shows how mining models are used to make predictions as to which goods are
usually bought at the same time
- Creating a Simple ETL Package - these SQL tutorials show how to remove data
from a flat file, reformat the data and insert into a fact table, plus demonstrations
on package configurations, logging, looping, and error flow.
- Notification Services - these SQL Tutorials show you how to build a weather
forecast application, update and apply changes to allow you receive weather
forecasts for different cities.
- Reporting Services - these SQL tutorials introduce the Reporting Services
and explain how to find and open each of them. Using Report Designer to establish
data source connections, produce layouts to contain your data and define a
simple query
|