1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Beginners Sql server 2000

Discussion in 'SQL Server' started by dprabhu11, Dec 20, 2007.

  1. dprabhu11

    dprabhu11 New Member

    Joined:
    Dec 20, 2007
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    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

    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

    Chapter 5. Understanding DML commands

    Lesson 21 INSERT

    Lesson 22 SELECT

    Lesson 23 UPDATE

    Lesson 24 DELETE

    Chapter 6. Constraints

    Lesson 25 Understanding Constraints

    Lesson 26 Domain Constraints

    Lesson 27 Entity Constraints

    Lesson 28 Referential integrity constraints

    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

    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


    Chapter 10. Views

    Lesson 42 Creating and Using a view

    Lesson 43 Partitioned View

    Lesson 44 Advantages of views


    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

    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

    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
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,276
    Likes Received:
    364
    Trophy Points:
    83
    Moved to SQL Server forum for better responses.
     
  3. arbaz.it

    arbaz.it New Member

    Joined:
    Feb 13, 2008
    Messages:
    104
    Likes Received:
    0
    Trophy Points:
    0
    can you please explain me the basic difference between all the joins
     
  4. arbaz.it

    arbaz.it New Member

    Joined:
    Feb 13, 2008
    Messages:
    104
    Likes Received:
    0
    Trophy Points:
    0
    can you please post examples of various topics.
     
  5. arbaz.it

    arbaz.it New Member

    Joined:
    Feb 13, 2008
    Messages:
    104
    Likes Received:
    0
    Trophy Points:
    0
    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.
     
  6. arbaz.it

    arbaz.it New Member

    Joined:
    Feb 13, 2008
    Messages:
    104
    Likes Received:
    0
    Trophy Points:
    0

    please also tell me which should be primary and which should be foreign key in this
     
  7. aisha.ansari84

    aisha.ansari84 New Member

    Joined:
    Feb 13, 2008
    Messages:
    82
    Likes Received:
    1
    Trophy Points:
    0
    even i have the same query please reply soon
     
  8. dprabhu11

    dprabhu11 New Member

    Joined:
    Dec 20, 2007
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    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:
     
  9. shivaleela

    shivaleela New Member

    Joined:
    Mar 18, 2008
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    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
     
  10. dragon2901

    dragon2901 New Member

    Joined:
    Sep 21, 2009
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    0
    why do you post up some ebooks for beginner example ebooks like you present above ...thank a lots
     
  11. bishnu

    bishnu New Member

    Joined:
    Aug 21, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Hi,
    I have good knowlodge in SQL,but i want to know more about Sql server (statements & syntax). so plz mail me some article's or any links so tht i can learn all these.

    id:-bishnuprasadsahoo1@gmail.com

    :confused:
     
  12. caliqadar

    caliqadar New Member

    Joined:
    Sep 23, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Hello,
    I have no good knowlodge in SQL,and i want to know more about Sql server 2000 (statements & syntax), installation giudes. so plz mail me some article's or any links so tht i can learn all these.
     
  13. mountainman

    mountainman Banned

    Joined:
    Feb 6, 2012
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    0
    Good. thanks for sharing
     

Share This Page