Forum Discussion

MahmoudR's avatar
MahmoudR
Copper Contributor
Jun 29, 2019

How the connection done between SQL & Application

Hello Dears,

 

First of all I do not know exactly if the context of my question is right or not but I do not have much information about some points in SQL and I need for them some answers

 

1- we download SQL Server as Database but how it connect with the Application which will be appear for the end user or the employees who will use the system to carry out their business?! so how the connection between the database and the GUI is done? can any one explain to me

 

2- there are many version of SQL which version should i start with to improve my SQL Skills?!

  • shah_chandra's avatar
    shah_chandra
    Copper Contributor
    Jul 04, 2019

    Hi MahmoudR ,

     

    As per your first question it depends on the application how the connections are made to the application, basically every application has the "connectionstring" set in their application to handle the connection. For more information about connectionstrings you can see on "https://www.connectionstrings.com/sql-server/".

     

    And for your second question, you can choose any version, if it is a higher version there are some new functions for easier scripting, but to improve your skills in SQL you can any of versions which seems comfortable to you.

     

     

Resources