Using Microsoft SQL Server Database


  1. Check the SQL Server Help Pages.

  2. Download the SQL Server Express.
  3. Check the Download. SQL Server Express is the free edition, ideal for development and production for desktop, web, and small server applications.

  4. Configure the installation.
  5. Check the Configuration.

  6. Launch SQL Server Management Studio (SSMS).
  7. Right-click on , then click and the following screen will open:


  8. Start the management.
    1. Create a database: Connect to SQL Server instance and right-click on the databases folder. Click on new database and the following screen will appear:


        Add


    2. Start entering SQL commands: Right-click your server instance in Object Explorer, and then select New Query:





          “Each generation imagines itself to be more    
          intelligent than the one that went before it    
          and wiser than the one that comes after it.”    
          — George Orwell