[dprabhu11]

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]

Moved to SQL Server forum for better responses.

[arbaz.it]

can you please explain me the basic difference between all the joins

[arbaz.it]

can you please post examples of various topics.

[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.

[arbaz.it]

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]

even i have the same query please reply soon

[dprabhu11]

CREATE TABLE Employee
(Name varchar(10),
phoneno varchar(10))

create table address
(Street Name varchar(10),
Houseno int,
City varchar(10))

[shivaleela]

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]

why do you post up some ebooks for beginner example ebooks like you present above ...thank a lots