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!
When you get the SQL Server 2008 Tutorials - Unlimited Version, you will have access to all of the following items:
SQL Server 2008 Tutorial Videos
In this MS SQL 2008 training series, we cover the following topics:
* Installation of SQL Server 2008
* SQL 2008 Configuration Manager
* SQL Server Management 2008 Studio (SSMS)
* Working with Databases in SSMS
* Security in MS SQL 2008 Server
* Using Transact SQL in SQL Management Studio
* MS SQL 2008 Administration and Maintenance with SSMS
* Backup and
Restore plus Compression in MSSQL 2008
* Build Entity Relationships in MS SQL Management Studio
* Monitoring SQL 2008 Server with
Profiler
* SQL Views, Functions and
Stored Procedures in MSSQL 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 2000
* Installing MS SQL 2000
* Creating and
Maintaining Databases
* Using Data Transfer in SQL
Server 2000
* Backup and Restore a
database
* Security in
MSSQL 2000
* Performing Administration Tasks with Enterprise Manager
* Miscellaneous Topics in SQL 2000 Server
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
* Installation of SQL Server 2008
* SQL 2008 Configuration Manager
* SQL Server Management 2008 Studio (SSMS)
* Working with Databases in SSMS
*
Security in MS SQL 2008 Server
* Using Transact SQL in SQL Management Studio
* MS SQL
2008 Administration and Maintenance with SSMS
* Backup and Restore
plus Compression in MSSQL 2008
* Build Entity
Relationships in MS SQL Management Studio
* Monitoring SQL 2008 Server with
Profiler
* SQL Views, Functions and
Stored Procedures in MSSQL 2008
Advanced Tutorial SQL 2008 Videos
* Microsoft Reporting Services in MS SQL 2008 - Covers BIDS, SSMS
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 video tutorial - Exporting access database to SQL Server 2008 using SSIS 2008 package
* Microsoft SQL 2008 tutorial - Using database mail with SQL Agent in SQL Server Management Studio
* Create SQL Server integration services package using business intelligence development studio (BIDS 2008)
* Using SQL String Functions like REPLACE, LEN, LEFT, LTRIM, SUBSTRING, CHARINDEX and more in SSMS
* 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
* Working with Subqueries using TSQL in SQL Management Studio
* SQL Date Functions tutorial including GetDate, DateAdd, DatePart and other date related functions
* Managing sql server indexes (clustered, non-clustered) in SQL Server Management Studio 2008 R2

* 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

* 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
- Types of Database Relationships
- Primary and Foreign Keys
- Transact SQL Statements
- 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 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, Training and Reporting on SQL Server 2008.