![]() |
|
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
SQL 2008 Server tutorial videosProduct 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) 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 | |
|
|
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.
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. 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. 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. | |
|
|
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. 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. 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. 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. 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. | |
|
|
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 (manymany). 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. 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 dmvs
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. 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. Visit our YouTube channel here and watch more SQL 2008 tutorialshttp://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 |