Unlimited Training
package includes Microsoft SQL 2008 Server video training. In this
tutorial video series, we cover new features in MS SQL
Server 2008. This SQL tutorial is also available
separately in a training DVD or online download format
FREE sample videos from the Server 2008 video training series:
-Using SQL Profiler in MS SQL 2008 Server
-Installation and setup of Microsoft SQL Server 2008
-Using Transact SQL statement like SELECT, INSERT, UPDATE and my
fav DELETE in SQL Server 2008
-Data Compression a new feature in SQL 2008 Server
-SQL Aggregate functions like COUNT, SUM, AVG, GROUP BY in 2008 sql
server (Available
in Unlimited SQL Training Package)
- Deploying Business Intelligence with Microsoft Reporting Services
2008 (SSRS) (Available in Unlimited SQL Training Package)
-Achieving High Availability with Database Mirroring in MS SQL 2008
Server(Available in Unlimited SQL Training Package)
Here is
brief information on the individual lessons:
|
Installation of SQL Server 2008
- We kick off this training video series with setting up SQL Server 2008 enterprise edition
running on Windows platform. First we show you how to get the
free MS SQL 2008 server download from Microsoft's web site. We also discuss options like
installation center, setup support rules and feature selection. (Running time: 11 +
23 mins)
SQL 2008 Server configuration manager
- In MS SQL 2008, configuration manager is primarily used
for setting up SQL Server 2008 services and managing network protocols. In this
sql tutorial, we go over all these topics and also mention some of the
industry best practices form a security point of view. (Running
time: 17 mins)
Using SQL Server 2008 Management Studio (SSMS) - SSMS in SQL 2008
and SQL 2005 has replaced the enterprise manager from SQL 2000. SQL Server 2008 management studio is an
essential tool used equally by SQL Developers and SQL DBA's alike. Important tabs like
object explorer, security, server objects, replication and management are explained. (Running
time: 32 mins)
Working with SQL Server 2008 database - SQL Databases and sql tables are
at the heart of any relational database management system (RDBMS). In addition to creating a
sql database, we point out other vital sql server 2008 options like
auto shrink, recovery model, tsql scripts, alter database, template explorer, etc. (Running
time: 33 mins)
Security in SQL Server 2008 - Database
security is a critical focus
when working with a database system like MS SQL 2008 Server or MS SQL 2005 Server. In this video
seminar, we hit Microsoft sql server concepts like principals, logins, schemas, server roles,
database roles, catalog views, object permissions, user access to securables. (Running
time: 28 mins)
Using SQL statements on SQL 2008 - In this
SQL 2008 video training, we will use the adventureworks 2008 sample database
to learn how to use basic sql statements to manipulate sql server data.
We only scratch the surface of SQL Server 2008 query language by looking
at select sql, insert sql, update sql and delete sql tsql statements. (Running
time: 32 mins)
SQL Server 2008 administration, maintenance and job automation - Job automation and maintenance are important if you want to learn sql server 2008 administration.
We cover ms sql 2008 concepts like events, alerts and operators. We continue with SQL Server 2008 agent,
job activity monitor, database mail and setting up maintenance plans. (Running
time: 46 mins)
SQL backup and restore plus compression feature in SQL Server 2008 - Using first the sql
server management studio and then
TSQL code, we discover SQL Server 2008 backup choices i.e. full, differential and log backups.
Next item on the training agenda is how to restore a database
and we walk you through some real life scenarios as well. (Running
time: 38 mins)
Entity relationships in a sql 2008 database design -
Database relationships are critical when it comes
to understanding SQL Server 2008 architecture. Using the adventureworks 2008 sql database, we
discuss 1 to 1, 1 to many, many to many relationships. In addition we
go over inner and outer sql joins and referential integrity. (Running
time: 28 mins)
Monitoring SQL Server 2008 - As a SQL Server
DBA, monitoring the database server
is an essential daily task.
In this elaborate and vital database tutorial, we dig
deeper into tools like event viewer, perfmon (Windows Performance Monitor), sql 2008
server profiler, dmv's (dynamic management views) and SQL Server 2008 error logs. We end the lesson with
a comparison of two tsql scripts using Profiler traces. (Running
time: 68 mins)
Using SQL Views, Functions and SQL Stored Procedures - In this last video session, we
brush up a bit on other important objects besides a database
table. We go over sql views which can help you with complex sql
select queries. Next we explain sql functions and sql server stored procedures that are used for
efficient database programming. Using database mail, we send an email notifications from SQL Server 2008. (Running
time: 45 mins)
If you would like additional
information on these video lessons, please visit this page:
http://www.learningsqlserver2008.com/products.htm
|
