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.

  3. Configure the installation.
    4.  Check the Configuration.

  4. Launch SQL Server Management Studio (SSMS).
    5.  Right-click on Logins, then click Newlogin and the following screen will open:


  5. Start the management.
    6.
    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: