Beginners Sql server 2000

dprabhu11's Avatar, Join Date: Dec 2007
Newbie Member
Hi every one,

Iím glad to welcome the viewers and experts to my blog.

This is prabhu from world expert database SME (Subject Matter Expert) working for a reputed e-learning concern on SQL Server 2000.
My motto is to educate the learners about SQL server 2000 comprehensively and effectively from scratch.
Iím looking forward to your valuable suggestions and comments to give the best output to my learners. As an initiative, herewith Iím providing the lesson list of SQL server 2000.

The lesson list covers the basics of SQL server 2000, DML, DDL ,TCL commands, Triggers, Views, Stored Procedure, Functions and so on.

Your comments on these segments and the lesson list are gladly welcome.


Chapter 1. Fundamentals

Lesson 1 History of SQL

Lesson 2 What is SQL

Lesson 3 Why We Learn SQL Server

Lesson 4 Whatís new in SQL Server 2000

Lesson 5 Course Objective

Chapter 2. Setting up Environment

Lesson 6 Software and Hardware Requirements

Lesson 7 Installation Types

Lesson 8 Installing SQL Server 2000

Lesson 9 Testing and Trouble Shooting Environment

Chapter 3. Working with Database

Lesson 10 Types of database

Lesson 11 Flat file and Relational Database

Lesson 12 Creating a Database in the Enterprise Manager

Lesson 13 Creating a Database using Database Wizard

Lesson 14 Creating a Database using Query analyzer

Lesson 15 Dropping Database

[B]Chapter 4. Understanding Data types and tables

Lesson 16 Data types

Lesson 17 Types of SQL commands

Lesson 18 Creating tables

Lesson 19 Deleting tables

Lesson 20 Altering Tables

[B]Chapter 5. Understanding DML commands

Lesson 21 INSERT

Lesson 22 SELECT

Lesson 23 UPDATE

Lesson 24 DELETE

[B]Chapter 6. Constraints

Lesson 25 Understanding Constraints

Lesson 26 Domain Constraints

Lesson 27 Entity Constraints

Lesson 28 Referential integrity constraints

[B]Chapter 7. Data Joins and its Types

Lesson 29 Inner joins or Equi joins

Lesson 30 Cross Joins or Cartesian Joins

Lesson 31 Outer Joins

Lesson 32 Self Joins

[B]Chapter 8. Aggregate and scalar Functions

Lesson 33 Group or Aggregate Functions

Lesson 34 String Functions

Lesson 35 Numerical Functions

Lesson 36 Date Functions

Chapter 9. Indexes


Lesson 37 Introduction

Lesson 38 Creating Indexs

Lesson 39 Clustered Indexes

Lesson 40 Non-Clustered Indexes

Lesson 41 Dropping an Indexes and What are the requirements for Indexed views


[B]Chapter 10. Views

Lesson 42 Creating and Using a view

Lesson 43 Partitioned View

Lesson 44 Advantages of views


[B]Chapter 11. Locking

Lesson 45 Introduction to Lock Types

Lesson 46 Shared Locks and Update Locks

Lesson 47 Exclusive locks and Intent Locks

Lesson 48 Schema locks and Bulk Update Locks

Lesson 49 Key-Range Locks
[B]
Chapter 12. Transact SQL

Lesson 50 An Overview of Transact SQL

Lesson 51 T-SQL Operators

Lesson 52 Programming Structure

Lesson 53 Control Statements

Lesson 54 Looping statements

Chapter 13. Implementing Stored Procedures

Lesson 55 Creating and using Stored Procedure

Lesson 56 Stored Procedure with Input and Output Parameters

Lesson 57 Securing Your Stored Procedure

Lesson 58 System and Extended Stored Procedure

[B]Chapter 14. Triggers and SQL profiler

Lesson 59 Overview Triggers

Lesson 60 When to use Triggers

Lesson 61 Nested and Recursive Triggers

Lesson 62 Triggers and Transactions

Lesson 63 Introduction to SQL Profiler

Lesson 64 Creating Trace
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Moved to SQL Server forum for better responses.
arbaz.it's Avatar, Join Date: Feb 2008
Ambitious contributor
can you please explain me the basic difference between all the joins
arbaz.it's Avatar, Join Date: Feb 2008
Ambitious contributor
can you please post examples of various topics.
arbaz.it's Avatar, Join Date: Feb 2008
Ambitious contributor
can you help me create a database table consisting of name ,phone no,address.

the address is stored in a seperate table consisting of street name, house no, city etc.
arbaz.it's Avatar, Join Date: Feb 2008
Ambitious contributor
Quote:
Originally Posted by arbaz.it
can you help me create a database table consisting of name ,phone no,address.

the address is stored in a seperate table consisting of street name, house no, city etc.

please also tell me which should be primary and which should be foreign key in this
aisha.ansari84's Avatar, Join Date: Feb 2008
Contributor
even i have the same query please reply soon
dprabhu11's Avatar, Join Date: Dec 2007
Newbie Member
CREATE TABLE Employee
(Name varchar(10),
phoneno varchar(10))

create table address
(Street Name varchar(10),
Houseno int,
City varchar(10))
shivaleela's Avatar, Join Date: Mar 2008
Newbie Member
Hi,

i have good knowlodge in SQL,but i want to i learn STORED PROCEDUR ,TRIGGERS,FUNCTION.so plz mail me some article's or any links so tht i cn learn all these.

id:-shivaleela.s@gmail.com

plz help me........ .......

regards,
shivaleela
dragon2901's Avatar, Join Date: Sep 2009
Newbie Member
why do you post up some ebooks for beginner example ebooks like you present above ...thank a lots