Using Microsoft SQL Server DBMS

  1. Check the SQL Server DBMS Help Pages.

  2. Download the SQL Server Express.
    3.  Check the Download page. 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 page.

  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:







          “Racism isn’t born, folks, it’s taught.    
          I have a two-year-old son.    
          You know what he hates? Naps. End of list.”    
          — Denis Leary