Popular Posts

  • SQL Tutorial
    SQL is short for Structured Query Language and is a widely used database language, providing means of data manipulation (store, retrieve, up...
  • SQL SUM
    The SQL SUM aggregate function allows selecting the total for a numeric column. The SQL SUM syntax is displayed below: SELECT SUM(Column1) F...
  • SQL GROUP BY
    The SQL GROUP BY statement is used along with the SQL aggregate functions like SUM to provide means of grouping the result dataset by certai...
  • SQL AVG
    The SQL AVG aggregate function selects the average value for certain table column. Have a look at the SQL AVG syntax: SELECT AVG(Column1) FR...
  • SQL Database Table
    The foundation of every Relational Database Management System is a database object called table. Every database consists of one or more tabl...
  • SQL SELECT INTO
    The SQL SELECT INTO statement is used to select data from a SQL database table and to insert it to a different table at the same time. The g...
  • SQL AND & OR
    The SQL AND clause is used when you want to specify more than one condition in your SQL WHERE clause, and at the same time you want all con...
  • SQL DISTINCT
    The SQL DISTINCT clause is used together with the SQL SELECT keyword, to return a dataset with unique entries for certain database table col...
  • Exercise 11.2: Inheritance - Overriding
    Steps to follow: 1. Modify Main.java as shown below in Code-11.2.a under personpackage directory. (You are welcome to do this work using ei...
  • JSP Scripting Elements
    JSP scripting elements let you insert Java code into the servlet that will be generated from the current JSP page. There are three forms: ...

Wednesday, March 18, 2009

Sql Server tutorials for beginners

Tutorials

Chapter 1 : What is SQL Server?
Chapter 2 : Compare SQL Server and MS Access
Chapter 3 : What is MSDE ?
Chapter 4 : SQL Server Editions
Chapter 5 : SQL Server service
Chapter 6 : SQL Server Instances
Chapter 7 : How to start and stop SQL Server service ?
Chapter 8 : Manage SQL Server services using SQL Service Manager
Chapter 9 : SQL Server 2005 Express
Chapter 10 : Limitations of SQL Server Express
Chapter 11 : Download SQL Server Express 2005
Chapter 12 : Installing SQL Server Express
Chapter 13 : Selecting authentication mode while installing
Chapter 14 : What is SQL Management Studio?
Chapter 15 : SQL Management Studio Editions
Chapter 16 : Connecting to SQL Server Database using Management Studio
Chapter 17 : How to use Management Studio ?
Chapter 18 : Manage the Databases
Chapter 19 : how to create a new database using Management Studio
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)