What is SQL Server? MS SQL 2008 Video Training
What is SQL Server?
Microsoft SQL Server is a Relational Database Management System (RDBMS) from Microsoft. MSSQL is an Enterprise level database application like Oracle or MySQL. As such it is able to store and manage millions of data rows for a medium to large size corporations. Initially the product was developed by Microsoft in collaboration with Sybase. There are several different versions of SQL Server in production, the most common ones are SQL Server 2005 and SQL Server 2008. If you want to try a free MS SQL version, please visit this site.
In SQL Server, you can do programming using Transact SQL aka TSQL. SQL Server 2008 has a lot of components and moving parts associated with it. We make it easier for you to get a handle on "What are all these SQL Server components?"
When you buy our Unlimited tutorial package, you will have access to our complete suite of MSSQL training materials. The complete details are listed throughout this page, but there are a few highlights:
Server Training Testimonial|
I am very pleased to join this learning website , it saved my hours of time by
watching these online training videos. Also an economical way of learning SQL Server 2008.
Bilal - Toronto
Unlimited Training Package on SQL Server
If you buy the Unlimited Training package, you will have access to the following training materials:
Unlimited Training package includes Microsoft SQL 2008 Server video training.
In this tutorial video series, we cover What is MSSQL and new features in the product. This SQL tutorial is also available separately in a Training DVD or Online download format. (Buy Now page)
FREE samples from SQL Server video training:
-Using SQL Profiler in MS SQL 2008
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)
What is 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)
How to use SQL 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)
What is 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)
How to do SQL backup and restore plus compression feature - 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)
Why and How to Monitor 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:
What is SQL Server? Related websites
Configuration Manager using SQL Server 2008|
Database Relationships in SQL 2008
SQL Server 2008 - Installation and setting up
MSSQL 2008 - Database Administration, Maintenance and Job Automation
What is SQL Server 2008 - Misc Topics
Monitoring Tools in MS SQL 2008 like perfmon, activity monitor, dmv's and sql profiler
Working with Databases and options like alter database, sp_helpdb and sp_dboption
Unlimited Training package includes Additional video training on MS SQL 2008.
- MS SQL Server 2008 video training - performance tuning and query optimization using SQL Profiler
- SQL 2008 video training - Using sqlserver sqlcmd instead of osql
- SQL Server training - Exporting access database to SQL Server 2008 using SSIS 2008 package
- Microsoft 2008 SQL training video - Using database mail with SQL Server 2008 Agentl
- SQL training - Create SQL Integration Services package using Business Intelligence Development Studio (BIDS 2008)
- SQL String Functions like REPLACE, LEN, LEFT, LTRIM, SUBSTRING, CHARINDEX and more sql functions
- How to do SQL Server joins - Using Customers database with sql joins including INNER join, OUTER LEFT AND RIGHT joins
- What is Microsoft Reporting Services in SQL 2008 - Cover BIDS, Report Server, Report Manager and other SSRS topics
- Working with Subqueries using TSQL in SQL Server 2008
- What are MSSQL Date Functions including GetDate, DateAdd, DatePart and other date related functions
- Managing SQL indexes (clustered, non-clustered) in SQL Server 2008
- How to setup Database Mirroring in Microsoft SQL Server 2008
- How to use Aggregate SQL Functions like COUNT, AVG , MIN, MAX and GROUP BY
- SQL 2008 video training - Monitoring Activity with sp_who2
- Working with SQL Tuning Advisor to find optimal indexes
More on the way ....
|Copyright © 2012. Search Engine Optimization Dallas || Partner site: What is SQL Azure || Powered by: Digital Fusion|