SQL 2008 Server tutorial videos



Product Testimonial

"The SQL 2008 Tutorial videos are truly informative, in a clear language that is easily understandable even to us non-english native speakers. Excellent value for money!"

// Magnus, Stockholm, Sweden



We have 3 seperate SQL Server 2008 training products. Here are the product details:

1. Unlimited access to our SQL 2008 videos and SQL Server training materials (1 year)

This option will give you unlimited access to our member section. This section includes new sql server video lessons, transact sql scripts, job interview questions, database tips and tricks etc. in addition to sql server 2000 videos and SQL 2008 Server videos. As our trainers come up with new database training material on sql server, you will be the first one to access this unreleased content. This is an excellent way to learn sql server 2008 online.

More information on the Unlimited Package can be found here, at Members page


2. SQL 2008 Server tutorials video - DVD Format:  

The sql server 2008 training dvd has all the sql server video tutorials and Microsoft powerpoint presentations on a DVD. This SQL 2008 Server training dvd will be mailed to you after the purchase is completed.

This product includes the following 11 lessons:

• Installation of SQL Server 2008
• SQL Server 2008 Configuration Manager
• SQL Server Management 2008 Studio (SSMS)
• Working with Databases in SQL Server 2008
• Security in SQL 2008 Server
• Transact SQL in SQL Server 2008
• SQL 2008 Server Administration, Maintenance and Job Automation
• Backup and Restore plus Compression in SQL Server 2008
• Entity Relationships in a SQL 2008 Database
• Monitoring SQL Server 2008
• SQL Views, SQL Functions and Stored Procedures in SQL 2008



3. SQL 2008 Server tutorials video - Download Format:   


Using the download sql server format, all the training videos and powerpoint presentations are available from one of our ftp sites. After the purchase, you will be emailed instructions on how to download all the files directly to your computer. With this option, you do not have to wait for snail mail and will have instant access to the SQL 2008 Server tutorials online.

This product includes the following 11 lessons:

• Installation of SQL 2008 Server
• SQL Server 2008 Configuration Manager
• SQL Server Management 2008 Studio (SSMS)
• Working with Databases in SQL Server 2008
• Security in SQL 2008 Server
• Transact SQL in SQL Server 2008
• SQL 2008 Server Administration, Maintenance and Job Automation
• Backup and Restore plus Compression in SQL Server 2008
• Entity Relationships in a SQL 2008 Database
• Monitoring SQL Server 2008
• SQL Views, SQL Functions and Stored Procedures in SQL 2008



 

FREE SQL 2008 Server training videos

Feel free to checkout the following training demos on SQL Server 2008:



 




Detailed information on SQL Server 2008 Training:


SQL Server 2008 is the newest relational database management system from Microsoft. It delivers a powerful, reliable and scalable enterprise solution in the high end database platforms. SQL Server 2008 extends the functionality of sql server 2005 with new features like data compression and policy based management. It enables you to store data from structured and unstructured documents, such as images and music, directly within the database. MS sql server 2008 delivers a rich set of integrated services that enable you to do more with your data such as query, search, migrate, synchronize, report, and analyze.


This video tutorial takes a practical approach towards learning MS sql 2008 server basics. It is organized and presented by a senior level database professional with more than 10 years of Industry experience. The training videos not only cover DBA (database administrator) topics like performance tuning, routine database maintenance, job scheduling, backing up and restoring databases, monitoring and profiling but also discusses database development in detail. The development area focuses on tasks like creating tables, sql views, sql functions, sql stored procedures, relationships and ERD (entity relationship diagrams) plus TSQL code including sql select, sql insert, sql update and sql delete commands. We have also made an effort to discuss Industry wide Best Practices along the way as they relate to sql 2008 server.

The video series consists of more than 6 hours of professional instruction which will help you learn ms sql server 2008 easier and faster than reading a book. The actual sql 2008 server training comes either on DVD or Download format that will run on Windows Media Player. Finally included in these videos are free powerpoint presentations to help you in the learning process. The files can be downloaded from one of our FTP sites. We will give you ftp site info after product is bought.

This content is produced by and property of our partner site
learningcomputer.com


SQL Server 2008 Installation Guide

In this sql server video tutorial, we walk you through the process of installing sql server enterprise edition on Windows Vista. We talk about the hardware and software requirements; next we show you the software download location on Microsoft's website. In the beginning, it installs the .NET framework and updated windows installer. After the reboot, we continue onto an Install wizard screen with additional resources and tools. We go over the installation center, setup support rules, feature selection and do a stand-alone installation. On the feature dialog box, one can select different SQL 2008 Server services to install. We recommend using Best Practice settings for service accounts; data file and log file locations. After the final steps, the machine is rebooted and we are all set at this point. This video is in two parts due to the necessary Reboot.
(Running times are 11 and 23 mins)


SQL Server 2008 Configuration Manager

We go over configuration manager in SQL 2008 Server. This tool is primarily used for two things: Configuring sql server services and also managing the network protocols. We jump into this sql 2005 server training and cover starting, stopping and restarting different services like database engine, sql agent, SSIS (sql server integration services), browser etc. We talk about sql 2008 server best practices of using a domain service account and also bring up startup mode settings. As far as network protocols are concerned, we go over server and client configurations. TCP/IP is the preferred protocol due to ease and frequency of use. You can enable and disable protocols and their ports here as it relates to security. Important point is that the server and clients are using the same settings, whatever you may decide to use.
(Running time is 17 mins)


SQL Server Management 2008 Studio (SSMS):

SSMS or sql server management 2008 studio is an all inclusive tool for managing SQL Server. It is equally important for database administrators and developers. We start this SQL 2008 Server management studio tutorial, b y mentioning important commands on the file and toolbar menu. Next we discuss how to register a server and export the server list. We tackle the mighty object explorer that can connect to different database services and is at the heart of SSMS 2008. In object explore, everything is laid out in a hierarchy of folders which are split by function. When you are working with database, it trickles down to tables, columns, field properties etc. We mention important tabs like sql security, server objects, replication and database administration. Finally we finish the lesson with out of the box reporting capabilities, scripting options and long awaited Intellisense feature.
(Running time is 32 mins)



 

Working with Databases in sql server

In this video training session, we cover related topics to SQL 2008 Server databases. We discuss some of the best practices on sql 2008 server regarding database management in general. The first demonstration shows you how to create a database using SSMS. Next we go over some of the database options and settings like File location, auto shrink option, recovery model etc. We switch gears and create a database using Transact SQL code. A nice feature in sql server is the ability to generate sql scripts that help with administration tasks. We execute the auto generated code to create another database. Commands like ALTER DATABASE, sp_helpdb, sp_dboption are explained next with some examples to change database settings in SQL 2008. Template explorer is a huge time saver when it comes to unfamiliar code. We create a database using template explorer and end this video session with some highlights of the Help section. 
(Running time is 33 mins)


Security in SQL 2008 Server

There are many layers of Security in sql server 2008, some of which are physical, OS, surface area, user permissions, domain access, file and folder security. In this sql 2008 server tutorials video, we discuss principals which are entities that can request sql server resources. At the server level there can be Windows or sql server principals. At the database level, there can be user, role or application principals. Next we talk about different type of roles: server or database. Server roles are always fixed like the sysadmin role. Database roles can be fixed like dbo or flexible that can be user defined. We also talk about tsql statements and catalog views that related to security. The demo includes creating a sql server login which is assigned to database roles. Next we assign the user access to a securable like database table and test different permission scenarios.
(Running time is 28 mins)


Transact SQL in SQL Server 2008

If you want to be good at working with databases, strong knowledge of tsql is a must. Transact SQL is the universal database language. In this SQL Server video on using sql commands,  we will use AdventureWorks2008 which is a sample database from Microsoft. We start SQL 2008 Server examples with the SELECT statement which is used to return data. This is by far the most commonly used sql command. The basic syntax of a SQL statement is discussed with examples from Person and SalesOrderHeader tables including some best practices. A quick trick to copy a table is using SELECT * INTO command which is shown next. We mention logical and standard operators. Demo on sql insert statement is used to populate data in the Person table. The next two statements are sql update and sql delete which are very powerful in nature. Using a WHERE clause is Extremely important with these two. We show you how to update data in Person table. Funny story regarding Delete statement is also mentioned. 
(Running time is 32 mins)


SQL 2008 Server Administration, Maintenance and Job Automation

Regular database administration and maintenance is necessary as your databases grow over time. Along with that, job automation helps you focus on other responsibilities where sql 2008 is able to handle routine sql server dba jobs on its own. In this online video tutorial on microsoft sql server 2008, we discuss concepts like events, alerts, operators, and administration jobs. In the initial demo we go over SQL configuration manager as it relates to sql server services. Next we cover sql server agent and demonstrate how to create an alert for when transaction log is full. This alert in turn sends a notification to the sql operator and also kicks off a SQL job ‘Backup AW Log’. We discuss job steps in detail and the TSQL code involved in these dba jobs. Next we go over SQL 2008 Server job activity monitor and view job history to see if the jobs completed successfully. We end this lesson with database mail and sql server maintenance plans. Using maintenance plan, you can easily configure regular maintenance tasks.
(Running time is 46 mins)


Database Backup and Restore plus Compression in SQL Server 2008

As a DBA, doing database backups is of utmost important especially in my position. We start off this training session on SQL 2008 Server by going over some terminology like backup database, restore database, full backup, differential backup, transaction log backup, filegroups and compression in sql server. Next we look at the various types of backups available in sql server. There are essentially three ways to do backups in SQL 2008 Server, management studio, TSQL and sql server maintenance plans. Using sample database AdventureWorks2008, we modify some data and do Full Backup, Differential Backup and Log Backups one by one. We also show you how to do backups using tsql code. We go over the long overdue compression feature in SQL 2008. After backups, the next item is how to Restore (Recover) the database. Once more there are various ways to restore the database and we illustrate you that using demonstrations. We end the lesson with some best practices backup strategies and backups using maintenance plans.
(Running time is 38 mins)



 

Database Relationships in SQL 2008 Server  

A database is not much without relationships between tables. We kick off this vital microsoft sql 2008 server tutorial by going over ERD (Entity Relationship Diagram) which displays a database structure or schema. We tackle terms like entity (table), attribute (field or column), record (row), primary and foreign keys. We will use AdventureWorks2008 once again as the source of our data. We discuss one to one relationship (1-1), one to many relationship (1-many) and many to many relationship (many–many). In the demos, we give you an idea about you how to create a database diagram, create a sql table with a primary key and establish a relationship with a foreign key. We use SSMS and TSQL to go over these concepts. Joins are of prime importance to deal with database relationships. We bring up inner and outer (left and right) joins and go over Sales Order and Customer data using database joins. We finally end the lesson with Referential Integrity in SQL 2008.
(Running time 28 mins)


Monitoring SQL Server 2008 with SQL Profiler

Monitoring and Profiler your database server is a critical tasks especially if you are the DBA. We kick off this sql server video tutorial looking at task manager, event viewer and performance monitor. We look at some system counters that are specifically geared towards sql server. Next we look at some canned reports that give you vital information at the server and database level. We use the activity monitor so get a feel for server activity. Moving onto sql server error logs, you can troubleshoot errors in database Engine and SQL agent. In addition to graphical tools, one can use sql code and dmv’s to get vital stats. We end this training session with the most important monitoring tool, the sql profiler. We show you how to create a template, change events and columns. In order to see this in action, we create two SQL 2008 scripts that select and update customer data on AdventureWorks2008.
(Running time 68 mins)

SQL Views, SQL Functions and SQL Stored Procedures in SQL 2008

We begin this learning sql 2008 server training with sql views tutorial.  A sql view is nothing more than a virtual table and is primarily used to simplify complex transact sql and can also be used as a security mechanism. The example of a sql view presented here includes data from employee table in adventureworks2008 database. Next we talk about sql functions which help in processing and returning data back to the calling program. We use the AVG function to build our user defined function on sales order and product data. Finally we go over sql stored procedures which are the preferred option for sql programming. They help in faster execution and code reuse and encapsulation. We combine the database mail feature with sql stored procedure to generate a list of terminated employees and send the list via an email.
(Running time 45 mins)


Visit our YouTube channel here and watch more SQL 2008 tutorials

http://www.youtube.com/user/baghul




Partner Sites

- Masters Degree in School Psychology
- Criminal Justice Degree
- Teaching Degree in Texas
- Search engine optimization Dalllas Texas
- Florida teacher certification



Copyright © 2000 - 2011. Search Engine Optimization Dallas || Partner site:  Free IT Training || Powered by: Digital Fusion