A database system is an overall collection of different database software components and databases containing the following parts:Database application programsClient componentsDatabase server(s)DatabasesA database application program is … [Read more...] about Database Systems: An Overview
Basic Concepts and Installation - SQL Server 2012
Relational Database Systems
The component of Microsoft SQL Server called the Database Engine is a relational database system. The notion of relational database systems was first introduced by E. F. Codd in his article "A Relational Model of Data for Large Shared Data Banks" in … [Read more...] about Relational Database Systems
Database Design ,Normal Forms ,Entity-Relationship Model
Designing a database is a very important phase in the database life cycle, which precedes all other phases except the requirements collection and the analysis. If the database design is created merely intuitively and without any plan, the resulting … [Read more...] about Database Design ,Normal Forms ,Entity-Relationship Model
SQL Server Editions – SQL Server 2012
As you plan your installation, you need to know which SQL Server editions exist so that you can choose the most appropriate edition. Microsoft supports the following editions of SQL Server 2012:Express Edition - The lightweight version of SQL … [Read more...] about SQL Server Editions – SQL Server 2012
General Recommendations for Installing SQL Server 2012
During the installation process, you have to make many choices. As a general guideline, it is best to familiarize yourself with their effects before installing your system. At the beginning, you should answer the following questions:Which SQL … [Read more...] about General Recommendations for Installing SQL Server 2012
Planning the Installation of SQL Server 2012
SQL Server contains a tool called Installation Center (see Figure 2-2), which appears when you start the installation of the software. This tool supports you during the planning, installation, and maintenance phases of your database system.To … [Read more...] about Planning the Installation of SQL Server 2012
Installing SQL Server 2012 Step by Step
If you have done an installation of a complex software product before, you probably recognize that feeling of uncertainty that accompanies starting the installation for the first time. This feeling comes from the complexity of the product to be … [Read more...] about Installing SQL Server 2012 Step by Step
SQL Server Management Studio
SQL Server 2012 provides various tools that are used for different purposes, such as system installation, configuration, auditing, and performance tuning. (All these tools will be discussed in different chapters of this tutorial.) The administrator's … [Read more...] about SQL Server Management Studio
Administering Database Servers
The administrative tasks that you can perform by using SQL Server Management Studio are, among others, the following:Register serversConnect to a serverCreate new server groupsManage multiple serversStart and stop serversThe following … [Read more...] about Administering Database Servers
Creating Databases Without Using Transact-SQL
You can create a new database by using Object Explorer or the Transact-SQL language. As the name suggests, you also use Object Explorer to explore the objects within a server. From the Object Explorer pane, you can inspect all the objects within a … [Read more...] about Creating Databases Without Using Transact-SQL
Managing Tables Without Using Transact-SQL
After you create a database, your next task is to create all tables belonging to it. As with database creation, you can create tables by using either Object Explorer or Transact-SQL. Again, only Object Explorer is discussed here.To create a table … [Read more...] about Managing Tables Without Using Transact-SQL
Query Editor, Solution Explorer, SQL Server Debugging
SQL Server Management Studio gives you a complete authoring environment for all types of queries. You can create, save, load, and edit queries. SQL Server Management Studio allows you to work on queries without being connected to a particular server. … [Read more...] about Query Editor, Solution Explorer, SQL Server Debugging
