Go4Expert

Go4Expert (http://www.go4expert.com/)
-   SQL Server (http://www.go4expert.com/forums/sql-server-forum/)
-   -   Beginners Sql server 2000 (http://www.go4expert.com/forums/beginners-sql-server-2000-t7946/)

dprabhu11 20Dec2007 18:11

Beginners Sql server 2000
 
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 20Dec2007 20:26

Re: Beginners Sql server 2000
 
Moved to SQL Server forum for better responses.

arbaz.it 14Feb2008 14:50

Re: Beginners Sql server 2000
 
can you please explain me the basic difference between all the joins

arbaz.it 14Feb2008 14:51

Re: Beginners Sql server 2000
 
can you please post examples of various topics.

arbaz.it 14Feb2008 14:52

Re: Beginners Sql server 2000
 
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 14Feb2008 14:53

Re: Beginners Sql server 2000
 
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 14Feb2008 14:56

Re: Beginners Sql server 2000
 
even i have the same query please reply soon

dprabhu11 7Mar2008 12:42

Creation o table
 
CREATE TABLE Employee
(Name varchar(10),
phoneno varchar(10))

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

shivaleela 18Mar2008 23:38

Re: Beginners Sql server 2000
 
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 24Sep2009 09:13

Re: Beginners Sql server 2000
 
why do you post up some ebooks for beginner example ebooks like you present above ...thank a lots


All times are GMT +5.5. The time now is 00:33.