To switch from the current database, you can use the drop-down menu: To create a new script editor, use the New Query button: This text is partially taken from Wikipedia. The main tool of SQL Server Management Studio is Object Explorer, which allows a user to view, retrieve, and manage server objects. It includes a script editor and a graphics program that works with server objects and settings. SQL Server Management Studio (SSMS) is the Microsoft SQL Server utility for configuring, managing and administering database components. Briefly about MS SQL Server Management Studio (SSMS) When creating this tutorial, I have used the MS SQL Server database, version 2014, and MS SQL Server Management Studio (SSMS) to execute scripts. However, if you need to know command in details, then surf the Internet, for example, MSDN. This is a step-by-step tutorial, where you need to perform examples while reading it. In addition, I think that a programming language, especially SQL, should be studied in practice for better understanding. I will explain all the constructions in study cases. In my article, I will review the most important ones:ĭML – Data Manipulation Language, which includes the following constructions: In addition, it is convenient to use scripts when you need to transfer database changes from a test database to a production database. Besides, in my opinion, in the script mode (with due precision), it is easier to specify and control rules for naming objects. If you are constantly working with databases, creating, modifying, and especially rebuilding an object using scripts is much faster than in a visual mode. This is convenient because you can see the whole text, and you do not need to look through numerous tabs to create, for example, an index or a constraint. For example, to create objects (tables, constraints, indexes, etc.), you may simply use integrated development environment (IDE) to work with databases and there is no need in studying visual tools for a particular database type (MS SQL, Oracle, MySQL, Firebird, etc.). I recommend that you should know all the main constructions used in most relational databases such as Oracle, MySQL, and Firebird. To my mind, it is very difficult to keep everything in your head and, by the way, there is no need for this. If there is a need to use complex SQL constructions, then usually I surf the MSDN library, which can be easily found on the internet.
This is the minimum you need to know while working with databases.
#MYSQL MANAGEMENT STUDIO TUTORIAL PROFESSIONAL#
This tutorial includes information about SQL (DDL, DML) that I have gathered during my professional life.
0 kommentar(er)
