what do i need to know before operating Sql database?

Question

what do i need to know before operating Sql database?

Answer 1

First you need to know what type of server you are going to run.



Microsoft SQL Server, Oracle, IBM DB2, Oracle MySQL.



Once you make that decision, then you will need to choose the correct edition. If you are using SQL Server and you want to put it on your local machine, then you will probably just want the Express Edition.



You will then need to install it and you will be ready to use it.



From that point, you will need to know the tool that is used to interact with the server. For SQL Server it would be Management Studio (SSMS). You would use this tool to connect to the database.



After you are connected, there are many tasks that you can do by simply right-clicking in SSMS.



The next steps would be to Create a Database. Either from scratch, or some kind of sample database. http://msftdbprodsamples.codeplex.com/



Then you will need to know some SQL. SQL is the language that is used to talk to a relational database. The databases mentioned above are all examples of relational databases.



At that point you can spend your career learning more about the database.

Answer 2

you ought to administration version substitute using, Script Saving functionality on an same time as changing database. regulate Database and shop the script each and every time to adhere it on your code this script may well be achieved on the time of upgradation of executable. I quite have good sq. server database shape it is integrated with my application, version administration functionality besides as diverse good factors like vehicle backup, fix, secure practices, shrinking database & 12 months ending. its working stabally.

Answer 3

knowledge of basic sql statements :

select, insert, delete