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 SSMS


sql 2008 Management Studio


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 sql-server-management-studio
* 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 management studio 2008 r2
* Monitoring Activity in SQL Server 2008
* Working with Database Tuning Advisor in SQL Server 2008 microsoft sql server management

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 What is SQL Server 2008
62. What is detaching database in sql server-0062.sql MS SQL 2008 Video Training
63. What are sql server transaction techniques-0063.sql sql server management studio express
64. Procedure to rebuild all indexes using information_schema-0064.sql MS SQL Server Video Training
65. How to delete from sql server 2008 table-0065.sql sql server management studio


66. Useful DBCC Tsql commands sql 2008-0066.sql SQL Server Tutorial
67. How to concat values in Sql Server-0067.sql SSMS Tutorial
68. Using sql group by having with sum count-0068.sql SSMS
69. Advanced string functions CONCAT LTRIM RTRIM-0069.sql MSSQL SSMS
70. Examples of sub-query statements in SQL Server-0070.sql SQL Server SSMS

 

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.