How to get Start Microsoft SQL Server? Part - 2

How to get Start Microsoft SQL Server? Part - 2

How to get Start Microsoft SQL Server? Part - 2: Welcome to the Microsoft SQL Server for beginners to professional tutorial here at https://raghawendraps.blogspot.com/ portal; you can read articles online here related to Microsoft SQL Server from beginners to professional. I will try my best to help you. As we know that Microsoft SQL Server is a leading RDBMS (Relational Database Management System) and most of organizations are using it. If you are looking for an easy and efficient way to learn and become master of SQL Server then absolutely you are in the right place.

Microsoft SQL Server for beginner’s tutorial is divided into many parts having huge practical and activities here. Once completed entire tutorial then you will be able to do installation of Microsoft SQL server into our PC and Laptops, configuration, querying data efficiently from tables or views in SQL server database, Create, Alter, Delete and Drop database objects like Database, Tables, Views, Indexes, Triggers, UDFs (User Defined Functions), Synonyms, SPs (Stored Procedures) and Sequences etc.


How to Download Microsoft SQL Server Express (Microsoft SQL Server for beginners: Part – 2)

To start with it we need to download and use a free version/Express edition of Microsoft SQL Server. I am going to use Microsoft SQL Server 2012 Express.

Download Microsoft SQL Server 2012 Express edition >>>
The first thing I would like to know you that you need to get start with a FREE version or copy of Microsoft SQL Server 2012 Express Edition, in this way please click here to navigate to download it absolutely free from Microsoft official Servers, once opened Microsoft page please click on the orange “Download” button (if you are unable to reach at Microsoft’s official website then follow the link: https://www.microsoft.com/en-us/download/details.aspx?id=29062). Referring the below snapshot –

When you click on the download button a popup window will appear “Choose the download you want”, you have to click the check box next to “ENU\x64\SQLEXPRWT_x64_ENU.exe” if you have a 64-bit machine. Referring the below snapshot –

If you have 32-bit machine then download the file named “ENU\x86\SQLEXPR_x86_ENU.exe”. Referring the below snapshot –

And then click on “Next” button to download the executable file. Referring the below snapshot –

Once downloaded executable file, please run it as administrator and follow the on – screen instructions to install Microsoft SQL Server 2012 Express Edition.

Be ensuring to install both the database engine and SQL Server Management Studio (SSMS) which is the tool that we will be used to complete our queries.

Download and Attach AdventureWorks database into SQL Server Management Studio (SSMS) >>>

Once you have the Microsoft SQL Server 2012 Express Edition successfully installed on your machine, you will need to download the sample AdventureWorks2012 database. in this way please click here to navigate to download it absolutely free from Google drive location, once opened Drive location page please click on the “Download Anyway” button (if you are unable to reach at Drive location then follow the link: https://drive.google.com/uc?id=1Rk2B3Uj1vj_14gnjhbJ2upEFpN6iQHYm&export=download). Referring the below snapshot –

And download the file named “AdventureWorks2012_Data.zip”. Once downloaded please extract the files in the zipped folder. Move the file “.mdf” extention to the SQL Servers root folder – C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA. Referring the below snapshot –

Open SQL Server Management Studio (SSMS) once the file is finished downloading. Once SSMS is open please connect to your newly installed SQL Server Express instance. You can type “.\SQLEXPRESS” in the “Server Name” field when first opening SQL Server Management Studio. Referring the below snapshot –

Once connected SQL Server Management Studio 2012 please click on the folder named “Databases”, and then select “Attach”. Referring the below snapshot –

The “Attach Databases” screen will appear as shown below –

Click on the “Add” button to open the “Location Database Files” screen where you will select the file named “AdventureWorks2012_Data.mdf”. This is the AdventureWorks SQL database file that we downloaded previously. Referring the below snapshot –

Click on “OK” button once you have selected the correct file. Information will populate into the “Attach Databases” screen based on what *.mdf file you have selected. Since we downloaded the database file but not any log file associated with it please click on the row with the word “Log” in the “File Type” column. As an extra step to make sure you selected the correct file, the log row will contain the text “Not Found” in the “Message” column. After confirming you have selected the correct row please click “Remove” button and then press “OK” button. Referring the below snapshot –

Now right click on the “Databases” folder and select refresh, expand the “Databases” folder. The AdventureWorks2012 database will appear in the expanded list and now it’s ready as you can start your next work. Referring the below snapshot –

We will discuss upcoming topics in next part. So please take care of you.

Assuming this tutorial post has well acquainted aspiring to the complete requirement. If you want to download PDF format file of this tutorial then please click here to download PDF.

Also requesting, if you have any ideas or suggestions for me or you need some important blogs/Videos or guidelines related to SQL Server, Excel, WordPress, SEO, Websites technologies then please feel free to write me on below comment section or you can go through the Contact Page. I will definitely come back to you with your desired requirements.

You can see more relevant tutorials on Microsoft SQL Server at https://raghawendrashukla.com/ portal by following links given below –

Basic knowledge of Microsoft SQL Server! Part – 3

How to get Start Microsoft SQL Server? Part – 2

What are 12 rules of Dr. Edgar Frank “Ted” Codd? Part – 1

You can read more articles from here by clicking on below links:

How to create Google Adsense Account and Link with Own Website or YouTube Channel Step by Step

How to create Partition in Windows 10 | Partition of Hard Disk Drive after Windows Installations

How to apply for a Passport step by step Guidelines

How to Create a PayPal account Step by Step

Microsoft Office Excel

How to protect ourselves from Corona virus?

Disclaimer: We are approaching to make the information available on this website as authentic as possible. We are not responsible for any error that may have crept in the result or typos being published in this website and for any loss to anyone or anything caused by any short comes, defect or inaccuracy of the information on this website. The tutorial or posts published in this website is only for the immediate information to learners and does not to be a constituted to be a legal document.

Hope this tutorial post was helpful for you and you liked very well, I am happy to serve you better. If you liked really this tutorial post, please don’t forget to share on social media.

What are 12 rules of Dr. Edgar Frank “Ted” Codd? Part – 1

What are 12 rules of Dr. Edgar Frank “Ted” Codd?

Dr. Edgar Frank “Ted” Codd (E. F. Codd)

Welcome to the Microsoft SQL Server for beginners to professional tutorial here at https://raghawendraps.blogspot.com/ portal; you can read articles online here related to Microsoft SQL Server from beginners to professional. I will try my best to help you. As we know that Microsoft SQL Server is a leading RDBMS (Relational Database Management System) and most of organizations are using it. If you are looking for an easy and efficient way to learn and become master of SQL Server then absolutely you are in the right place.

Microsoft SQL Server for beginner’s tutorial is divided into many parts having huge practical and activities here. Once completed entire tutorial then you will be able to do installation of Microsoft SQL server into our PC and Laptops, configuration, querying data efficiently from tables or views in SQL server database, Create, Alter, Delete and Drop database objects like Database, Tables, Views, Indexes, Triggers, UDFs (User Defined Functions), Synonyms, SPs (Stored Procedures) and Sequences etc.

Today I will discuss about 12 rules of a RDBMS (Relational Data Base Management Systems) which has been taken from a link is mentioned below -

Let’s start -

Dr. E.F. Codd's 12 Rules: Dr Edgar F. Codd did some extensive research in Relational Model of database systems and came up with twelve rules of his own which according to him, a database must obey in order to be a true relational database.

These rules can be applied on a database system that is capable of managing is stored data using only its relational Capabilities. This is a foundation rule, which provides a base to imply other rules on it.

Rule 1: Information rule: This rule states that all information (data), which is stored in the database, must be a value of some table cell. Everything in a database must be stored in table formats. This information can be user data or meta-data.

Rule 2: Guaranteed Access rule: This rule states that every single data element (value) is guaranteed to be accessible logically with combination of table-name, primary-key (row value) and attribute-name (column value). No other means, such as pointers, can be used to access data.

Rule 3: Systematic Treatment of NULL values: This rule states the NULL values in the database must be given a systematic treatment. As a NULL may have several meanings, i.e. NULL can be interpreted as one the following: data is missing, data is not known, data is not applicable etc.

Rule 4: Active online catalog: This rule states that the structure description of whole database must be stored in an online catalog, i.e. data dictionary, which can be accessed by the authorized users. Users can use the same query language to access the catalog which they use to access the database itself.

Rule 5: Comprehensive data sub-language rule: This rule states that a database must have a support for a language which has linear syntax which is capable of data definition, data manipulation and transaction management operations. Database can be accessed by means of this language only, either directly or by means of some application. If the database can be accessed or manipulated in some way without any help of this language, it is then a violation.

Rule 6: View updating rule: This rule states that all views of database, which can theoretically be updated, must also be updatable by the system.

Rule 7: High-level insert, update and delete rule: This rule states the database must employ support high-level insertion, Updation and deletion. This must not be limited to a single row that is, it must also support union, intersection and minus operations to yield sets of data records.

Rule 8: Physical data independence: This rule states that the application should not have any concern about how the data is physically stored. Also, any change in its physical structure must not have any impact on application.

Rule 9: Logical data independence: This rule states that the logical data must be independent of its user’s view (application). Any change in logical data must not imply any change in the application using it. For example, if two tables are merged or one is split into two different tables, there should be no impact the change on user application. This is one of the most difficult rule to apply.

Rule 10: Integrity independence: This rule states that the database must be independent of the application using it. All its integrity constraints can be independently modified without the need of any change in the application. This rule makes database independent of the front-end application and its interface.

Rule 11: Distribution independence: This rule states that the end user must not be able to see that the data is distributed over various locations. User must also see that data is located at one site only. This rule has been proven as a foundation of distributed database systems.

Rule 12: Non-subversion rule: This rule states that if a system has an interface that provides access to low level records, this interface then must not be able to subvert the system and bypass security and integrity constraints.        

Click here source link

We will discuss upcoming topics in next part. So please take care of you.

Assuming this tutorial post has well acquainted aspiring to the complete requirement. If you want to download this tutorial in PDF format file, then please - click here to download PDF.

Also requesting, if you have any ideas or suggestions for me or you need some important blogs/Videos or guidelines related to SQL Server, Excel, WordPress, SEO, Websites technologies then please feel free to write me on below comment section. I will definitely come back to you with your desired requirements.

You can see more relevant tutorials on Microsoft SQL Server at https://raghawendrashukla.com portal by following links given below –

Operators, ERD and T-SQL Statements in SQL Server Part -7

Data Types and Wild Card Characters in Microsoft SQLServer Part - 6

Data Integrity and Key Constraints in Microsoft SQL ServerPart - 5

MicrosoftSQL Server Language Part – 4

Basicknowledge of Microsoft SQL Server! Part – 3

Howto get Start Microsoft SQL Server? Part – 2

Whatare 12 rules of Dr. Edgar Frank “Ted” Codd? Part – 1

You can read more articles from here by clicking on below links -

BestHosting Provider Site Ground’s Big Deal

Howto create Google Adsense Account and Link with Own Website or YouTube ChannelStep by Step

Howto create Partition in Windows 10 | Partition of Hard Disk Drive after WindowsInstallations

Howto apply for a Passport step by step Guidelines

Howto Create a PayPal account Step by Step

MicrosoftOffice Excel

Howto protect ourselves from Corona virus?

Disclaimer: We are approaching to make the information available on this website as authentic as possible. We are not responsible for any error that may have crept in the result or typos being published in this website and for any loss to anyone or anything caused by any short comes, defect or inaccuracy of the information on this website. The tutorial or posts published in this website is only for the immediate information to learners and does not to be a constituted to be a legal document.

Hope this tutorial post was helpful for you and you liked very well, I am happy to serve you better. If you liked really this tutorial post, please don’t forget to share on social media like – face book, Whatsapp, LinkedIn, twitter, Instagram etc