1 / 14

Introduction to SQL Server 2000 & Relational Databases

Introduction to SQL Server 2000 & Relational Databases. Palak Patel. What is SQL Server 2000?. SQL Server is a client/server based relational database management system Runs on Windows 2000 Professional, Server, Advanced Server, NT 4, Windows 9x/ME or Windows CE

kata
Download Presentation

Introduction to SQL Server 2000 & Relational Databases

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Introduction to SQL Server 2000 & Relational Databases Palak Patel

  2. What is SQL Server 2000? • SQL Server is a client/server based relational database management system • Runs on Windows 2000 Professional, Server, Advanced Server, NT 4, Windows 9x/ME or Windows CE • Included in BackOffice product family • Include in .Net Servers family

  3. Server Side Database Engine Security Fault-tolerance Performance Concurrency Reliable backup Client Side User Interface Forms Reports Queries Client/Server

  4. Desktop Databases

  5. Client/Server Database

  6. Types of Databases • Relational • Flat-File • Hierarchical • Relational Vs. Flat-file

  7. Database Objects • Table • Row • Column • Data Type • Stored Procedure • Trigger • Rule • Default • View • Index

  8. Data-Warehousing Decision Support Systems (DSS) Online Analytical Processing (OLAP) Relatively fixed data Long running queries Online Transaction Processing (OLTP) Continuously changing data Updates relatively small transactions Data-Warehousing Vs. Transaction Processing SQL Server works well with either applications

  9. Background on SQL Server & SQL • History • Position in the Market • History of SQL – IBM 1970 • SQL and SEQUEL • ANSI-SQL, T-SQL / PL-SQL SQL Language • DDL Data Definition Language • DML Data Manipulation Language Brief History of Windows and Versions of Windows 2000

  10. Versions of SQL Server 2000 • SQL Server CE • Runs on Windows CE • Replicate data from Standard and Enterprise Edition • Personal • Runs on Windows 9x/ME/2000 Pro • No license required if you have Standard or Enterprise Edition • Developer • Designed for Developers to be used on Single Machine • Runs on Windows NT/2000 • Standard • Comes with most of the features for workgroups and departments • Lacks dome enterprise level features • Runs on Windows NT/2000 Server • Enterprise: • All features including clustering support, log shipping, parallel computing support, enhanced read-aheads, partitioning support, HTTP support, Very Large Database (VLDB) Support • Runs on Windows NT/2000 Server

  11. SQL Server 2000 Clients • Directly Supported: • Windows 9x/ME • Windows 2000 • Windows NT • Does not ship with 16-bit drivers, however you can use drivers from old version of SQL Server • When correctly configured with Web Server, any client can access it

  12. Differences on Windows 9x

  13. Tasks of SQL Sever Developer • Analyze the business situation and design a solution • Design database and objects • Design security of SQL Server databases • Design data replication scenarios • Programming using T-SQL • Design user interface, queries, reports • Testing • Populating • Hand the project documentation over to administrator

  14. Tasks of a SQL Server DBA • Install and configure SQL Server • Plan and create databases • Backup the databases • Restore databases when required • Setup and manage users for SQL Servers • Manage Security for SQL Server users • Setup / Manage task, alerts, operators • Setup / Manage replication environment • Performance Tune SQL Server • Troubleshoot SQL Server related problems

More Related