Búsqueda del centro de recursos

Buscar recursos de currículo por

Palabra clave	Idioma	Uso

AutorDescripción del cursoTítuloInstitución Búsqueda avanzada

Página principal > Business Intelligence (95 Objeto(s) en 12 Tipo(s) de uso Se encontró)

Проектирование хранилищ данных для приложений систем деловой осведомленности (Business Intelligence Systems) - 06/29/2010
Целью настоящего курса лекций является описание возможностей, которые предоставляют современные реляционные СУБД и CASE инструменты для проектирования хранилищ данных в системах бизнес – аналитики.
Case Study, Course Outline, Exercise/Exam

Хранилища данных. Анализ данных. - 08/29/2009
В курсе изучаются технологии OLAP (OnLine Analytical Processing) для разработки многокритериальных иерархических хранилищ данных.
Slides

Microsoft Dynamics Customer Model Departments - 07/17/2008
The Microsoft Dynamics Customer Model describes how people in departments do work within and across organizations.
Professional Development

BI – Business Intelligence - 12/11/2007
Conceitos de Business Intelligence (BI) e suas aplicações.
Demo, Slides

Microsoft Academic Days on Business Applications, Relational Databases, and Security - Strange Bedfellows: Lawyers, Accountants, and Computer Scientists - 2 of 2 (Slides) - 11/30/2007
In this session David L. Baumer discusses how US companies that acquire, process, and transmit personally identifying information are increasingly burdened by statutes and government regulations.
Demo, Slides

Microsoft Academic Days on Business Applications, Relational Databases, and Security - Security Measures Conceived Within Business Process Models - 1 of 2 (Video) - 11/30/2007
In this presentation Joseph Barjis discusses his proposal for an innovative Security-Driven Business Processes Modeling that delivers secure models, bringing security implementation up to the business process level.
Audiovisual Content

Microsoft Academic Days on Business Applications, Relational Databases, and Security - Security Measures Conceived Within Business Process Models - 2 of 2 (Slides) - 11/30/2007
In this presentation Joseph Barjis discusses his proposal for an innovative Security-Driven Business Processes Modeling that delivers secure models, bringing security implementation up to the business process level.
Demo, Slides

Business Intelligence – SQL Learning Suite 2.1 - 11/17/2007
The Microsoft SQL Learning Suite provides platform for those who don't have basic knowledge of SQL. It is intended for two types of users, those with no knowledge of SQL and those that need a quick refresher. The SQL Learning Suite application introduces users to the basic keywords and query syntax of SQL using the interactive GUI features.
Executable Program, Exercise/Exam

Business Intelligence – Datasheets and More - 11/17/2007
This material contains SQL Server 2005 datasheets about: Top 30 Features of SQL Server 2005, Express, Workgroup Edition, Analysis Services, Data Mining, Integration Services, Report Builder, Reporting Services, and Migration Assistant.
Readings

Business Intelligence – Queries - 11/17/2007
These exercises provide hands-on experience using Microsoft SQL Server Management Studio to write and execute intermediate level Structured Query Language (SQL) using the Dillard’s Department Store and Sam’s Club databases.
Exercise/Exam

Business Intelligence – BI Fundamentals – Module 4 of 4 - 1 of 6 (Video) - 11/17/2007
Modules 1, 2 and 3 covered the end result of a BI project discussed the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 4 looks further at the kinds of data that can be examined and how it can be analyzed to help all manner of business users.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 4 of 4 - 2 of 6 (Video) - 11/17/2007
Modules 1, 2 and 3 covered the end result of a BI project discussed the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 4 looks further at the kinds of data that can be examined and how it can be analyzed to help all manner of business users.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 4 of 4 - 3 of 6 (Video) - 11/17/2007
Modules 1, 2 and 3 covered the end result of a BI project discussed the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 4 looks further at the kinds of data that can be examined and how it can be analyzed to help all manner of business users.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 4 of 4 - 4 of 6 (Video) - 11/17/2007
Modules 1, 2 and 3 covered the end result of a BI project discussed the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 4 looks further at the kinds of data that can be examined and how it can be analyzed to help all manner of business users.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 4 of 4 - 5 of 6 (Video) - 11/17/2007
Modules 1, 2 and 3 covered the end result of a BI project discussed the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 4 looks further at the kinds of data that can be examined and how it can be analyzed to help all manner of business users.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 4 of 4 - 6 of 6 (Slides) - 11/17/2007
Modules 1, 2 and 3 covered the end result of a BI project discussed the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 4 looks further at the kinds of data that can be examined and how it can be analyzed to help all manner of business users.
Demo, Slides

Business Intelligence – BI Fundamentals – Module 3 of 4 - 1 of 20 (Video) - 11/17/2007
Modules 1 and 2 covered the end result of a BI project and learned the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 3 examines the tools that make building, delivering, and maintaining a BI solution a reality.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 3 of 4 - 2 of 20 (Video) - 11/17/2007
Modules 1 and 2 covered the end result of a BI project and learned the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 3 examines the tools that make building, delivering, and maintaining a BI solution a reality.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 3 of 4 - 3 of 20 (Video) - 11/17/2007
Modules 1 and 2 covered the end result of a BI project and learned the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 3 examines the tools that make building, delivering, and maintaining a BI solution a reality.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 3 of 4 - 4 of 20 (Video) - 11/17/2007
Modules 1 and 2 covered the end result of a BI project and learned the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 3 examines the tools that make building, delivering, and maintaining a BI solution a reality.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 3 of 4 - 5 of 20 (Video) - 11/17/2007
Modules 1 and 2 covered the end result of a BI project and learned the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 3 examines the tools that make building, delivering, and maintaining a BI solution a reality.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 3 of 4 - 6 of 20 (Video) - 11/17/2007
Modules 1 and 2 covered the end result of a BI project and learned the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 3 examines the tools that make building, delivering, and maintaining a BI solution a reality.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 3 of 4 - 7 of 20 (Video) - 11/17/2007
Modules 1 and 2 covered the end result of a BI project and learned the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 3 examines the tools that make building, delivering, and maintaining a BI solution a reality.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 3 of 4 - 8 of 20 (Video) - 11/17/2007
Modules 1 and 2 covered the end result of a BI project and learned the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 3 examines the tools that make building, delivering, and maintaining a BI solution a reality.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 3 of 4 - 9 of 20 (Video) - 11/17/2007
Modules 1 and 2 covered the end result of a BI project and learned the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 3 examines the tools that make building, delivering, and maintaining a BI solution a reality.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 3 of 4 - 10 of 20 (Video) - 11/17/2007
Modules 1 and 2 covered the end result of a BI project and learned the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 3 examines the tools that make building, delivering, and maintaining a BI solution a reality.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 3 of 4 - 11 of 20 (Video) - 11/17/2007
Modules 1 and 2 covered the end result of a BI project and learned the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 3 examines the tools that make building, delivering, and maintaining a BI solution a reality.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 3 of 4 - 12 of 20 (Video) - 11/17/2007
Modules 1 and 2 covered the end result of a BI project and learned the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 3 examines the tools that make building, delivering, and maintaining a BI solution a reality.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 3 of 4 - 13 of 20 (Video) - 11/17/2007
Modules 1 and 2 covered the end result of a BI project and learned the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 3 examines the tools that make building, delivering, and maintaining a BI solution a reality.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 3 of 4 - 14 of 20 (Video) - 11/17/2007
Modules 1 and 2 covered the end result of a BI project and learned the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 3 examines the tools that make building, delivering, and maintaining a BI solution a reality.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 3 of 4 - 15 of 20 (Video) - 11/17/2007
Modules 1 and 2 covered the end result of a BI project and learned the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 3 examines the tools that make building, delivering, and maintaining a BI solution a reality.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 3 of 4 - 16 of 20 (Video) - 11/17/2007
Modules 1 and 2 covered the end result of a BI project and learned the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 3 examines the tools that make building, delivering, and maintaining a BI solution a reality.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 3 of 4 - 17 of 20 (Video) - 11/17/2007
Modules 1 and 2 covered the end result of a BI project and learned the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 3 examines the tools that make building, delivering, and maintaining a BI solution a reality.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 3 of 4 - 18 of 20 (Video) - 11/17/2007
Modules 1 and 2 covered the end result of a BI project and learned the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 3 examines the tools that make building, delivering, and maintaining a BI solution a reality.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 3 of 4 - 19 of 20 (Video) - 11/17/2007
Modules 1 and 2 covered the end result of a BI project and learned the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 3 examines the tools that make building, delivering, and maintaining a BI solution a reality.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 3 of 4 - 20 of 20 (Slides) - 11/17/2007
Modules 1 and 2 covered the end result of a BI project and learned the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 3 examines the tools that make building, delivering, and maintaining a BI solution a reality.
Demo, Slides

Business Intelligence – BI Fundamentals – Module 2 of 4 - 1 of 6 (Video) - 11/17/2007
Module 1 started by showing the end result of a BI project: the output being used by a variety of different users in the organization. Module 2 takes students a level deeper and peeks under the covers at the concepts involved in building a BI solution.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 2 of 4 - 2 of 6 (Video) - 11/17/2007
Module 1 started by showing the end result of a BI project: the output being used by a variety of different users in the organization. Module 2 takes students a level deeper and peeks under the covers at the concepts involved in building a BI solution.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 2 of 4 - 3 of 6 (Video) - 11/17/2007
Module 1 started by showing the end result of a BI project: the output being used by a variety of different users in the organization. Module 2 takes students a level deeper and peeks under the covers at the concepts involved in building a BI solution.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 2 of 4 - 4 of 6 (Video) - 11/17/2007
Module 1 started by showing the end result of a BI project: the output being used by a variety of different users in the organization. Module 2 takes students a level deeper and peeks under the covers at the concepts involved in building a BI solution.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 2 of 4 - 5 of 6 (Video) - 11/17/2007
Module 1 started by showing the end result of a BI project: the output being used by a variety of different users in the organization. Module 2 takes students a level deeper and peeks under the covers at the concepts involved in building a BI solution.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 2 of 4 - 6 of 6 (Slides) - 11/17/2007
Module 1 started by showing the end result of a BI project: the output being used by a variety of different users in the organization. Module 2 takes students a level deeper and peeks under the covers at the concepts involved in building a BI solution.
Demo, Slides

Business Intelligence – BI Fundamentals – Module 1 of 4 - 14 of 14 (Slides) - 11/17/2007
This module introduces the concepts of Business Intelligence, or BI. It does this by presenting the different types of users in an organization and describing how they use BI. It shows a demonstration of the kinds of tools that could be used by each group of users in order to gain benefits from a BI solution.
Demo, Slides

Business Intelligence – BI Fundamentals – Module 1 of 4 - 1 of 14 (Video) - 11/17/2007
This module introduces the concepts of Business Intelligence, or BI. It does this by presenting the different types of users in an organization and describing how they use BI. It shows a demonstration of the kinds of tools that could be used by each group of users in order to gain benefits from a BI solution.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 1 of 4 - 2 of 14 (Video) - 11/17/2007
This module introduces the concepts of Business Intelligence, or BI. It does this by presenting the different types of users in an organization and describing how they use BI. It shows a demonstration of the kinds of tools that could be used by each group of users in order to gain benefits from a BI solution.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 1 of 4 - 3 of 14 (Video) - 11/17/2007
This module introduces the concepts of Business Intelligence, or BI. It does this by presenting the different types of users in an organization and describing how they use BI. It shows a demonstration of the kinds of tools that could be used by each group of users in order to gain benefits from a BI solution.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 1 of 4 - 4 of 14 (Video) - 11/17/2007
This module introduces the concepts of Business Intelligence, or BI. It does this by presenting the different types of users in an organization and describing how they use BI. It shows a demonstration of the kinds of tools that could be used by each group of users in order to gain benefits from a BI solution.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 1 of 4 - 5 of 14 (Video) - 11/17/2007
This module introduces the concepts of Business Intelligence, or BI. It does this by presenting the different types of users in an organization and describing how they use BI. It shows a demonstration of the kinds of tools that could be used by each group of users in order to gain benefits from a BI solution.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 1 of 4 - 6 of 14 (Video) - 11/17/2007
This module introduces the concepts of Business Intelligence, or BI. It does this by presenting the different types of users in an organization and describing how they use BI. It shows a demonstration of the kinds of tools that could be used by each group of users in order to gain benefits from a BI solution.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 1 of 4 - 7 of 14 (Video) - 11/17/2007
This module introduces the concepts of Business Intelligence, or BI. It does this by presenting the different types of users in an organization and describing how they use BI. It shows a demonstration of the kinds of tools that could be used by each group of users in order to gain benefits from a BI solution.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 1 of 4 - 8 of 14 (Video) - 11/17/2007
This module introduces the concepts of Business Intelligence, or BI. It does this by presenting the different types of users in an organization and describing how they use BI. It shows a demonstration of the kinds of tools that could be used by each group of users in order to gain benefits from a BI solution.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 1 of 4 - 9 of 14 (Video) - 11/17/2007
This module introduces the concepts of Business Intelligence, or BI. It does this by presenting the different types of users in an organization and describing how they use BI. It shows a demonstration of the kinds of tools that could be used by each group of users in order to gain benefits from a BI solution.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 1 of 4 - 10 of 14 (Video) - 11/17/2007
This module introduces the concepts of Business Intelligence, or BI. It does this by presenting the different types of users in an organization and describing how they use BI. It shows a demonstration of the kinds of tools that could be used by each group of users in order to gain benefits from a BI solution.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 1 of 4 - 11 of 14 (Video) - 11/17/2007
This module introduces the concepts of Business Intelligence, or BI. It does this by presenting the different types of users in an organization and describing how they use BI. It shows a demonstration of the kinds of tools that could be used by each group of users in order to gain benefits from a BI solution.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 1 of 4 - 12 of 14 (Video) - 11/17/2007
This module introduces the concepts of Business Intelligence, or BI. It does this by presenting the different types of users in an organization and describing how they use BI. It shows a demonstration of the kinds of tools that could be used by each group of users in order to gain benefits from a BI solution.
Audiovisual Content

Business Intelligence – BI Fundamentals – Module 1 of 4 - 13 of 14 (Video) - 11/17/2007
This module introduces the concepts of Business Intelligence, or BI. It does this by presenting the different types of users in an organization and describing how they use BI. It shows a demonstration of the kinds of tools that could be used by each group of users in order to gain benefits from a BI solution.
Audiovisual Content

Business Intelligence – BI Fundamentals – BI Videos - 1 of 21 (Slides) - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.
Professional Development, Tutorial

Business Intelligence – BI Fundamentals – BI Videos - 2 of 21 (Video) - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.
Audiovisual Content

Business Intelligence – BI Fundamentals – BI Videos - 3 of 21 (Video) - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.
Audiovisual Content

Business Intelligence – BI Fundamentals – BI Videos - 4 of 21 (Video) - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.
Audiovisual Content

Business Intelligence – BI Fundamentals – BI Videos - 5 of 21 (Video) - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.
Audiovisual Content

Business Intelligence – BI Fundamentals – BI Videos - 6 of 21 (Video) - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.
Audiovisual Content

Business Intelligence – BI Fundamentals – BI Videos - 7 of 21 (Video) - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.
Audiovisual Content

Business Intelligence – BI Fundamentals – BI Videos - 8 of 21 (Video) - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.
Audiovisual Content

Business Intelligence – BI Fundamentals – BI Videos - 9 of 21 (Video) - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.
Audiovisual Content

Business Intelligence – BI Fundamentals – BI Videos - 10 of 21 (Video) - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.
Audiovisual Content

Business Intelligence – BI Fundamentals – BI Videos - 11 of 21 (Video) - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.
Audiovisual Content

Business Intelligence – BI Fundamentals – BI Videos - 12 of 21 (Video) - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.
Audiovisual Content

Business Intelligence – BI Fundamentals – BI Videos - 13 of 21 (Video) - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.
Audiovisual Content

Business Intelligence – BI Fundamentals – BI Videos - 14 of 21 (Video) - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.
Audiovisual Content

Business Intelligence – BI Fundamentals – BI Videos - 15 of 21 (Video) - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.
Audiovisual Content

Business Intelligence – BI Fundamentals – BI Videos - 16 of 21 (Video) - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.
Audiovisual Content

Business Intelligence – BI Fundamentals – BI Videos - 17 of 21 (Video) - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.
Audiovisual Content

Business Intelligence – BI Fundamentals – BI Videos - 18 of 21 (Video) - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.
Audiovisual Content

Business Intelligence – BI Fundamentals – BI Videos - 19 of 21 (Video) - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.
Audiovisual Content

Business Intelligence – BI Fundamentals – BI Videos - 20 of 21 (Video) - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.
Audiovisual Content

Business Intelligence – BI Fundamentals – BI Videos - 21 of 21 (Video) - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.
Audiovisual Content

Business Intelligence – BI Reference Materials - 11/17/2007
This material provides hands-on experience connecting and querying databases using Visual Basic .NET. In addition there are Case Studies and White Papers about using Business Intelligence on the Microsoft Platform.
Case Study, Exercise/Exam, Readings

Business Intelligence – Structured Query Language (SQL) - 11/17/2007
These exercises provide hands-on experience using Microsoft SQL Server Management Studio to write and execute Structured Query Language (SQL) against the Hallux Productions database.
Exercise/Exam, Lab

Business Intelligence – Database Administration - 11/17/2007
This material contains the steps needed to install and configure the Business Intelligence demo server for use in the classroom.
Lab, Project

Business Intelligence – Data Modeling - 11/17/2007
This material demonstrates how to create Entity Relationship Diagrams (ERDs) using Microsoft Visio Professional 2003. The diagrams generated using Visio are not “traditional” ERDs, but are based on the same concepts, contain similar structures, and include some very powerful features.
Audiovisual Content, Exercise/Exam

SQL Server 2005 Express Absolute Beginner Video #1 - What is a Database - 01/23/2007
This introduction covers the questions and terminology SQL Server beginners need to create and manage databases, such as: What is a SQL Server database? How is a SQL Server database different from an Excel spreadsheet? What do SQL Server databases do in my website or software applications? What’s SQL Server Express’ relation to Visual Studio Express?
Audiovisual Content, Tutorial

SQL Server 2005 Express Absolute Beginner Video #2 – Understanding Database Tables & Records - 01/23/2007
SQL Server beginners will learn about tables and definitions of data types, properties, keys, etc. in this second video. Find out how table rows, columns, and fields interrelate and whether columns can be empty.
Audiovisual Content, Tutorial

SQL Server 2005 Express Absolute Beginner Video #3 – More about Column Data Types & Other Properties - 01/23/2007
SQL Server beginners will explore data integrity, learn which data types to use for what, and avoid common data type pitfalls.
Audiovisual Content, Tutorial

SQL Server 2005 Express Absolute Beginner Video #4 – Designing Relational Database Tables - 01/23/2007
Why are relational databases the most popular? SQL Server beginners will learn to differentiate between primary and foreign keys, design relational database tables, and learn about normalization rules and de-normalization.
Audiovisual Content, Tutorial

SQL Server 2005 Express Absolute Beginner Video #5 – Manipulating Database Data - 01/23/2007
SQL Server beginners will learn about ADO.NET objects and execution of SQL statement from ADO.NET. Explore SQL and learn about insert, update, and delete statements. Visit http://www.microsoft.com/express/sql/previous/default.aspx for more information about this product.
Audiovisual Content, Project, Tutorial

SQL Server 2005 Express Absolute Beginner Video #6 – More Structured Query Language - 01/23/2007
SQL Server beginners will discover more SQL statements like sub-select and learn stored procedures and their counterparts in C# and VB methods.
Audiovisual Content, Tutorial

SQL Server 2005 Express Absolute Beginner Video #7 – Understanding Security & Network Connectivity - 01/23/2007
SQL Server beginners will learn to differentiate between SQL Server database files and SQL Server processes. Explore scenarios for connecting to SQL Server Express databases, enabling and disabling user instances, login permissions, and other security precautions.
Audiovisual Content, Project, Tutorial

SQL Server 2005 Express Absolute Beginner Video #8 – Connecting your Web Application - 01/23/2007
SQL Server beginners will walk through the entire workflow of creating a database driven Web application and use visual tools to quickly create an administration application. Visit http://www.microsoft.com/express/sql/previous/default.aspx for more information about this product.
Audiovisual Content, Project, Tutorial

SQL Server 2005 Express Absolute Beginner Video #9 – Using SQL Server Management Studio Express - 01/23/2007
SQL Server Management Studio Express will typically be your main interface into SQL Server Express. This lesson demonstrates the essential techniques and skills you’ll need to successfully connect to database instances, navigate the query window and scripting database objects, attaching, detaching and backing up databases, and much more.
Audiovisual Content, Tutorial

SQL Server 2005 Express Absolute Beginner Video #10 – Getting Started with Reporting Services - 01/23/2007
SQL Server Reporting Services allows you to design and deploy nicely formatted and interactive reports representative of your data. This video demonstrates how to set up Reporting Services and the Business Intelligence Development Studio to build reports using the wizards and designers, and deploy them to your Report Server.
Audiovisual Content, Tutorial

SQL Server 2005 Express Absolute Beginner Video #11 – Embedding, Packaging & Deploying SQL Server Express Reporting Services - 01/23/2007
Building on the previous lesson, we dive into building reports from scratch and modifying the reports that were created using the wizards and designers. We also demonstrate how to embed your reports into your ASP.NET Web Form applications.
Audiovisual Content, Tutorial

SQL Server 2005 Express Absolute Beginner Video #12 – Creating & Using Stored Procedures - 01/23/2007
This video expands on the topic of Stored Procedures which was introduced several lessons ago. In this video we explain the basic syntax to create and update stored procedures, including using input and output parameters, declaring variables and adding other T-SQL programming elements and the Visual Basic and C# syntax required to utilize stored procedures in your own applications.
Audiovisual Content, Tutorial

SQL Server 2005 Express Absolute Beginner Video #13 – Enabling Full-Text Search in your Text Data - 01/23/2007
Full-Text search allows you to save large portions of text – even Microsoft Word documents, or other file formats – into your database and perform complex queries based on this textual data while expecting great performance. This lesson demonstrates how to creating full-text indexes, configuring the index population settings and performing queries.
Audiovisual Content, Tutorial

Business Intelligence - 03/08/2006
A brief (but dense) set of slides containing introductory material on Business Intelligence. Includes reference to software tools.
Slides