Buy Tutorials/SQL Server 2000 FTP Format

SQL Server is a powerful client/server database from Microsoft. SQL Server 2000 builds upon the modern, extensible foundation of SQL Server 7.0, a critical release in Microsoft’s database lineup and one in which much of the SQL Server product was both re-architected and rewritten. In the time since its release, SQL Server 2000 has become the preferred database of many Customer Relationship Management (CRM), Business Intelligence (BI), Enterprise Resource Planning (ERP), and other line-of-business application vendors and customers because of its performance, scalability, manageability, programmability and value.

Experienced SQL Server DBA's make more than $100,000 a year. Demand for DBA's in the job market is growing every day. Get your career jump started today as a DBA!!

This DBA video tutorial consists of more than 2 hours of professional instruction by a SQL Server Database Administrator. This video tutorial comes on a 2 CD set in .AVI format that will run on any computer with Windows Media Player or RealNetworks Real Player. Also included in the videos are powerpoint presentations to help you in the learning process. This content is produced by and property of http://www.learningcomputer.com All Rights Reserved

Check out feedback from buyers of this product!!

Comments Member ID  Item ID
Excellent video...would order again on other topics. chrissy9555 280144903155
it was vergy good, the tutorial was very good. It was worth buying rchennakeshava 280140147111
A++ trowe6753 280118937371
A+++, 5 out of 5 , excellant packing, received on time and worth for the money aarud 280100602929
AAAAA++++++++++++++++************* zacky65 280093808351
Worth every penny. Thanks! slavo 280090167387
·:*¨¨*:·.THANKS .·:*¨¨*:·.5 STARS!.·:*¨¨*:·. pleasure to work with .·:*¨¨*:·. akhtar973 280086946997
Good support and respond shovon_nhfil 280083243647
Very Informative. A+ whealers 280081369336
great deal centrasale 280076386779
very responsible, concern and prompt. will certainly do business again humera1230 280001026269
As ordered. Good service. Great product l8rnow 7233956742
Greate Service!!! Excellent Seller skyrogi 7221455820
GREAT EBAYER! GOOD TRANSACTION A+++++++++++ ezauctions786 7217009446
Great! Item as advertised! Would buy from again! realpoet01 7206339838
Very good training software whsgifts 7181380657
Fast ship; exactly as advertised sborrok 7179746408
very good item good transaction ilu420 7173749645
Item as descirbe great ebayer eseller01 9700181762

Watch FREE samples of this video series from this location: Right Click on the link below, select Save Target as ... , choose a location on your hard drive and click Save!!

http://www.learningcomputer.com/sqlvideos/Sample1.avi

http://www.learningcomputer.com/sqlvideos/Sample2.avi

Here is more detailed information on the individual lessons:

  1. Overview of SQL Server 2000:
  2. We start with a little background about SQL Server 2000 from Microsoft. We cover three important administration tools: Enterprise Manager, Query Analyzer and the Profiler. Also discussed in this video segment are different versions of Net libraries used with SQL Server 2000 – (Running time is 18.56 mins)

  3. Installing SQL Server 2000:
  4. In this video, we install SQL Server 2000 Enterprise Manager on a Windows 2000 Server machine. The minimum hardware requirements are also discussed. During the setup process, the setup wizard will ask you to select many options which are explained in this lesson – (Running time is 21.51 mins)

  5. Creating and Maintaining Databases:
  6. Using Enterprise Manager we create a new database and then create a new table in this database. In addition we discuss t-SQL (Transact SQL) as another option in creating a new database. After the database is creating, one may need to change the options for the database which are explained in this video. We also discuss concepts of RAID which is used for disk optimization and redundancy – (Running time is 22.06 mins)

  7. Data Transfer in SQL Server 2000:
  8. Data is the life blood of any database. As such data transfer is an important topic. In this lesson we discuss DTS (Data Transformation Services), bcp (Bulk Copy Program) utility, and BULK INSERT command. Examples include a Microsoft Access database and a text file (Running time is 17.54 mins)

  9. Backup and Restore a database:
  10. An extremely important topic regarding Database Administration. The types of backups discussed include the following: Full, Differential, Transaction Log and File/File group. Examples include Northwind which is a sample database from Microsoft. (Running times are 9.31 and 11.34 mins)

  11. Security in SQL Server 2000:
  12. In today’s world of hackers and viruses, securing the corporate database is a vital task for any DBA. We discuss the Security architecture in SQL Server. The topics covered in this video include: authentication, authorization, database role, server roles and permissions. (Running time is 18.24 mins)

  13. Performing Administration Tasks:
  14. A significant part of a Database Admin’s job including running database jobs. SQL Server Agent makes these tasks easier by scheduled jobs. Here we create and schedule a job to backing up a database. We also discuss notification services via email from SQL Server. (Running time is 18.55 mins)

  15. Miscellaneous Topics:
  16. In the final video, we talk about topics like SQL Server configuration, ODBC data sources, monitoring user activity, creating a maintenance plan and using a trace in Profiler. – (Running times are 8:37 mins and 13:43 mins)