|
Installation of sql server - 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 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 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
Management Studio (SSMS) - SSMS has replaced the enterprise
manager from sql 2000. SQL server 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 tables are at the heart of any relational
database management system (RDBMS). In addition to
creating a sql database, we point out other vital 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 server. In this video
seminar, we hit 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 tutorial, we will use the adventureworks 2008 sample
database to learn how to use basic sql statements. 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 administration, maintenance and job
automation - Job automation and maintenance are important if you
want to learn sql server administration. We cover
concepts like events, alerts and operators. We continue
with sql server 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 management studio
and then TSQL code, we discover sql server backup choices
i.e. full, differential and log backup. Next item on the
training agenda is how to restore a database and we walk you
through some scenarios as well. (Running time 38
mins)
Entity relationships in a sql database design -
Database relationships are critical when it comes to understanding
sql server 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 database tutorial, we dig deeper into
tools like event viewer, perfmon, sql profiler, dmv's and sql
server 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 stored
procedures that are used for efficient database
programming. Using database mail, we send an email
notifications from sql server. (Running time 45 mins)
If
you would like additional information on these video lessons, please
visit this page:
http://www.learningsqlserver2008.com/products.htm
| 
