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