Microsoft Certification’s


SQL Server Basics

History:

. 1.0(OS/2) 1989
. 4.21(WinNT) 1993
. 6.0  1995
. 6.5  1996
. 7.0  1998 Introduced OLAP Tools
. 8.0  SQL Server 2000
. 9.0  SQL Server 2005
. 10.0  SQL Server 2008
 

In MS SQL Server 2008:
* Fully Relational Database
* Unlimited Data Storage (524,272 TB per Database)
* 32,767 Concurrent User Connections at same time
* 32 767 Database on a Server
* up to 2,147,483,647 tables
* 1,024 columns per table

Getting Hands on

* SQL Server Enterprise 180-days Evaluation Full working copy.
  www.microsoft.com/sql
* Microsoft Virtual PC
         www.microsoft.com/windows/virtual-pc/
* Virtual Box
  www.virtualbox.org

SQL Server 2008 Editions:
 . Core Editions
 . Specialized Editions
 . Free Editions
* Core Editions:
 * Standard
    .Small to large businesses
    . Up to 4 CPU
    . Maximum OS RAM
 * Enterprise
    . Enterprise workloads & Business Intelligence
    . CPU’s & RAM limited by Operating System
 * Specialized Editions
     . Workgroup
    . Remote Offices needing local instance of data
    . 2 CPU’s Max
    . 4 GB RAM Max
  . Web
    . Web Application Hosting
    . 4 CPU’s Max
    . OS Max on RAM
 * Specialized Editions
  . Developer
  . Linensed for development and testing only.
  . OS Max for CPU’s
  . OS Max for RAM
 * Free Editions
  . Express
   . Entry level for learning and ISV Redistribution
   . 1 CPU Max
   . 1 GB Max
   . 4GB Max database size
  Free Editions

  . Compact 3.5
  . Embedded database for developing desktop and mobile apps
  . OS Max for CPU’s
  . OS Max for RAM
  
Hardware and Software Requirements for Installing SQL Server 2008

Visit: http://msdn.microsoft.com/en-us/library/ms143506.aspx

 

Microsoft’s SQL Server 2008 Certifications :  SQL Server Divided Into Three Areas

* Administration
 . Installing, Configuring & Maintaining

* Development
 . Database Programming

* Businness Intelligence
 . Analysis Services, Reporting Services & Integration Services

* One MCTS Exam In Each Area Of Expertise
 . Administration MCTS
  . Exam 70-432 SQL Server 2008 Installation & Maintenance
 

. Development MCTS
  . Exam 70-433 SQL Server 2008 Database Development
 

. Business Intelligence MCTS
  . Exam 70-488 SQL Server 2008 Business Intelligence
   Development & Maintenance

* One MCITP Exam In Each Area Of Expertise
 . MCITP: Database Administrator 2008
  * Exam 70-450 PRO: Designing, Optimizing and Maintaining A

DatabaseServer
     Infrastructure Using MS SQL Server 2008
 . MCITP: Database Developer 2008
  * Exam 70-451 PRO: Designing Database Solutions and Data
    Access Using MS SQL Server 2008

. MCITP: Business Intelligence Developer 2008
  * Exam 70-452 PRO: Designing A Business Intelligence
    Infrastructure Using MS SQL Server 2008

Microsoft Certified Master (MCM)

Microsoft Certified Architect (MCA)

 

Khan sql-dba mcitp

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s