Product Testimonial - SQL Server Tutorial
"I am very pleased to join this learning website, it saved me hours of time by watching these online MS SQL Server Tutorial videos. Also an economical way of learning SQL Server 2008. Thanks"
// Bilal, Toronto
SQL Server Tutorial - Members Only!
SQL Server 2008 Tutorial Videos
In this MS SQL 2008 training series, we cover the following topics:
* 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 MS SQL
2008 Server
* Transact SQL in SQL Server 2008
Tutorial
* MS SQL 2008 Server Administration
and Maintenance
* Backup and Restore plus
Compression in SQL Server 2008
* Entity Relationships
in a MS SQL 2008 Database
* Monitoring SQL 2008
Server
* SQL Views, Functions and Stored
Procedures in MS SQL 2008
If you would like additional information on these SQL Server Tutorial lessons, please visit this page:
http://sqlserver2008tutorial.com/sql-server-versions/ms-sql-2008.html#Details
If you would like to see FREE video tutorials (SQL
Server 2008), please visit the FAQ page here:
http://sqlserver2008tutorial.com/sql-tutorials.html
After
you become a member, we will send you instructions on how to download the MS sql
2008 training material from our download site.
SQL Server 2000 Tutorial Videos
In this SQL 2000 training series, we cover the following topics:
* Overview of sql server 2000
* Installing SQL Server 2000
* Creating and
Maintaining Databases
* Using Data Transfer in SQL
Server 2000
* Backup and Restore a
database
* Security in SQL Server
2000
* Performing Administration
Tasks
* Miscellaneous Topics in SQL Server 2000
If you would like additional information on these SQL video lessons, please visit this page:
http://learningcomputer.com/buytutorial_moredetails_1.html
After you become a member, we will send you instructions on how to download
the MS sql 2000 training material from our download site.
SQL Server 2008 PowerPoint Presentations
* SQL Server 2008 Tutorial - Configuration Manager
* SQL Server 2008 Tutorial - Entity Relationships
* SQL Server 2008 Tutorial - Installation
* SQL Server 2008 Tutorial - Maintenance and Job Automation
* SQL Server 2008 Tutorial - Misc Topics
* SQL Server 2008 Tutorial - Profiling and Monitoring Tools
* SQL Server 2008 Tutorial - Working with Databases
Advanced Tutorial SQL 2008 Videos
* Microsoft Reporting Services in MS SQL 2008 - Covers BIDS,
Report Server, Report Manager and other SSRS topics
* MS SQL Server 2008 training - performance tuning and query optimization using SQL Profiler
* SQL 2008 training video - Using sqlserver sqlcmd instead of osql
* SQL Server video tutorial - Exporting access database to SQL Server 2008 using SSIS 2008 package
* Microsoft 2008 SQL Server tutorial - Using database mail with SQL Server 2008 Agentl
* SQL Server training - Create SQL Server integration services package using business intelligence development studio (BIDS 2008)
* SQL String Functions like REPLACE, LEN, LEFT, LTRIM, SUBSTRING, CHARINDEX and more sql functions
* Tutorial on SQL joins - Using Customers database with sql joins including INNER join, OUTER LEFT AND RIGHT joins
* Microsoft Reporting Services in SQL 2008 - Cover BIDS, Report Server, Report Manager and other SSRS topics
SQL Server Tutorial Video - Working with Subqueries using TSQL in SQL Server 2008
* SQL Date Functions tutorial including GetDate, DateAdd, DatePart and other date related functions
* Managing sql server indexes (clustered, non-clustered) in SQL Server 2008

* How to setup Database Mirroring tutorial in SQL Server 2008
* Aggregate-Functions SQL training like COUNT, AVG , MIN, MAX and GROUP BY in SQL Server

SQL Server Tutorial - Monitoring Activity in SQL Server 2008
Working with Database Tuning Advisor in SQL Server 2008

If you would like to see FREE video tutorials (SQL Server 2008),
please visit the FAQ page here:
http://sqlserver2008tutorial.com/sql-tutorials.html
SQL Server Tutorial and Queries with TRANSACT SQL
1. Using
WAITFOR DELAY SQL to add time delay
2. Using
sp_change_users_login in sql 2008 server
3. Finding
cpu utilization with TSQL code
4. Removing
data from a BIG table in MS SQL 2008
5.
How to kill orphan processes with mssearch in sqlserver
6. Using
xp_fixeddrives SQL stored procedure to find drive space
on your database server
7. Getting
a baseline query optimization with SQL Query DBCC
DROPCLEANBUFFERS
8. SQL Command
to make a quick copy of a table in sql 2008
9. TSQL
script code to drop or delete a database
10. How
to create a database using Transact SQL (tsql) code
11. Using Advanced
SQL xp_cmdshell stored procedure_0011
12. Change
recovery model all databases in one shot_0012
13. How
to write a SQL Query to add, modify and drop
columns
in MS SQL 2008_0013
14. Start
and stop MS SQL Server services with SQL_0014
15. Basic SQL
Command select, sql insert, sql update and sql delete syntax_0015
16. How
to use while loop sql server_0016
17. Using
if else then sql code in sql server_0017
18. Extented
stored procedures like xp_readerrorlog and
xp_fixeddrives_0018
19. How
to create a sql server login with sql syntax_0019
20.
Check to see if record exists in a MS SQL table_0020
21. Set
transaction isolation level to read uncommitted_0021
22. Drop
and create SQL operators using tsql code_0022
23. Performance
tuning tip SQL Server with DBCC/Statistics_0023
24. Moving
tempdb in MS SQL 2008 server using alter database sql
command_0024
25.
How do I find missing indexes with dynamic management br views in SQL 2008 Server_0025
26. Inserting
data to sql table with a nested sub select query_0026
27. Aggregate
functions SQL MIN, MAX, SUM, SQL COUNT_0027
28. MS
SQL 2008 example on using a cursor_0028
29. How
to loop in sql stored procedurer with while loop_0029
30.
Get list of columns and user tables using SQL catalog br views_0030
31. Change
owner for SQL Server jobs to SA-0031
32. Create
table in ms sql server using SQL CREATE TABLE-0032
33. How
to input text file to sql table using bulk insert sql br command-0033
34. SQL
String Functions LEN, LEFT, RIGHT, LOWER, UPPER, and
SQL REPLACE-0034
35.
Using sql case statements for conditional logic-0035
36. Find
indexes using sys indexes catalog view-0036
37. Create
temporary table in SQL Server-0037
38. Using
SQL table variable vs temporary table-0038
39. How
to Alter index in SQL 2008 with br dm_db_index_physical_stats-0039
40.
Steps to find and remove duplicates SQL Server-0040
41. SQL
Server left outer join-0041.sql
42. Using
WHERE clause in SQL SERVER 2008-0042.sql
43. How to
backup SQL Server database-0043.sql
44. SQL Script to restore sql server database-0044.sql
45.
How to do Inner join SQL 2008 Server-0045.sql
46. How
to declare sql variables-0046.sql
47. Create
index clustered index example-0047.sql
48. Primary keys
foreign keys-0048.sql
49. SQL
coalesce function sql server example-0049.sql
50. Using sql stored procedure xp_fileexist-0050.sql
51. How to find unique values in a field-0051.sql
52. String functions including REPLACE, SUBSTRING, CHARINDEX and
LEFT-0052.sql
53. More
extended procedures like xp_fixeddrives-0053.sql
54. Performance
tuning tips part-1-0054.sql
55.
Performance tuning tips part-2-0055.sql
56. Using sql cast conver in sql server-0056.sql
57. How to send email sql server using sp_send_dbmail-0057.sql
58. SQL Server date functions sql convert date-0058.sql
59.
Create a view in SQL server 2008-0059.sql
60.
Monitor activity at the process level SQL Server-0060.sql
61.
How to alter database to modify data file-0061.sql
62. What is detaching database in sql server-0062.sql
63. What are sql server transaction techniques-0063.sql
64. Procedure to rebuild all indexes using information_schema-0064.sql
65. How to delete from sql server 2008 table-0065.sql
66. Useful DBCC Tsql commands sql 2008-0066.sql
67. How to concat values in Sql Server-0067.sql
68. Using sql group by having with sum count-0068.sql
69. Advanced string functions CONCAT LTRIM RTRIM-0069.sql
70. Examples of sub-query statements in SQL Server-0070.sql
Supplemental Information on SQL 2008 Training
SQL 2008 Training - Types of Database Relationships
SQL 2008 Training - Primary and Foreign Keys
SQL 2008 Training - Transact SQL Statements
SQL 2008 Training - Stored Procedures - Views - Triggers
New Blog on SQL Azure Tutorial topics:
http://sqlazuretutorials.com/wordpress/
Please allow 24 hours for regular order processing. If you have any problems ordering
the SQL Server Tutorial products or have a follow-up question, please contact us
at support@SQLServer2008tutorial.com.
Sql Server 2008 Tutorial.com is part of Kash Data Consulting LLC.
We are a consulting company based in Dallas, Texas and specialize in Development,
Administration and Reporting on SQL Server 2008.