Register Login





|

Top Links: >> 80. Technology >> Internet Technology Summit Program >> 2. Java and Databases
Current Topic: 2.4. MS SQL Server
You have a privilege to create a quiz (QnA) related to this subject and obtain creativity score...
Microsoft SQL Server successfully competes with Oracle DB and is commonly used in Windows environments. In this section we learn how to download, install and work with MS SQL Server.

Before going any further let us STOP Oracle services if they are running.
Go to Services via MS Windows Search or via the Control Panel: Control Panel ? System ? Administrative Tools ? Services

Find the following Oracle Services that are Running: OracleServiceXE and OracleXETNSListener.

Change their Properties from Automatic to Manual and Stop these Oracle Services.

Done!

We will work with MS SQL Server Express ? freely available for download and installation.
Enter the following URL:
https://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx

The download screen gives several choices. Download SQLEXPRWT_x64_ENU.EXE (64-bit PC), MS SQL Server Express With Tools ? SQL Management Studio.
1) Press the green button GET STARTED NOW.
2) Then Sign In with your Microsoft account (create your account, if you did not have one)
3) Select the version to download - MS SQL Server Express With Tools, and the language - English



4) Store a compressed file SQLEXPRWT_x64_ENU.exe in c:\downloads\db ? directory.
5) Un-compress the file and find a new folder SQLEXPRWT_x64_ENU inside the c:\downloads\db ? directory. Click on the SETUP.exe to start installation.
6) Keep default options during the installation and use the same name and password values as for Oracle.
7) After successful installation check the Services window and find SQL Server (SQLEXPRESS) and several other SQL services running.



8) We will use MS SQL Server Management Studio to create and manage database and tables. Find the MS SQL Server Studio icon on the Desktop. If not there ? create a shortcut with the program "C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\Ssms.exe? (could be in your Program Files or Program Files (86) ? directory.

9) Open the Studio and do right mouse click on the Database and select the New Database option.

10) Name this database as its.


Was it clear so far? Highlight the text in question Or

11) Right mouse click on the database its on the left and select the Table option to create a new table.

12) Change the default name (on the right) from Table_1 to UserProfile.

13) Enter the column names: email, FirstName, LastName, mobileNumber, role and lastUpdate. All data types are nchar(60).



14) Save the table and refresh the view to see on the left this new database object dbo.UserProfile table in the its database.

Then create the Accounts table with the following fields: email, password, enabled, lastUpdate. All data types are nchar(60).

15) Insert two-three related records with the same email address in both tables. For lastUpdate use the following format: yyyy-MM-dd:hh-mm. For example: 2015-05-15:13-00.



16) Open New Query window.
17) Type the SELECT statement: SELECT * from its.dbo.UserProfile and press the Ececute control.



18) You will see the names of the table fields with no values. You might see the name of the table underlined in red as Unknown Object. Ignore this message.
19) Now, you can insert two-three records in both tables. You can use NEW QUERY window to enter the INSERT statements.
20) Or with right mouse click on the table name on the left, select the EDIT Top 200 Rows and manually replace NULL values with data.
21) For lastUpdate use the following format: yyyy-MM-dd:hh-mm. For example: 2015-05-15:13-00.



Assignments:

1. Use MS Windows Search to open Local Services window and find SQL Server services. Stop and Start again the services and check connections to the DB in the Studio.
2. In a browser open the web page for MySQL downloads: https://dev.mysql.com/downloads/mysql
3. Download and Install MySQL Community Edition. Create a new MS Word file with the name MySQL-Install-and-work. Describe the installation steps and capture the screens in this document.
4. Download MySQL Workbench (similar to MS SQL Server Management Studio) from the same web page and repeat the points 9 ? 21 above while working with this tool. Provide instructions and capture the screen in the MySQL-Install-and-work document.
5. Provide at the end of the document two QnA with related questions and answers. A correct answer must be first followed by two or three wrong answers.
6. Email this document to dean@ituniversity.us

We invite you to create your own questions and answers (QnA) to increase your rank and win the Top Creativity Prize!

Topic Graph | Check Your Progress | Propose QnA | Have a question or comments for open discussion?

Have a suggestion? - shoot an email
Looking for something special? - Talk to AI
Read: IT of the future: AI and Semantic Cloud Architecture | Fixing Education
Do you want to move from theory to practice and become a magician? Learn and work with us at Internet Technology University (ITU) - JavaSchool.com.

Technology that we offer and How this works: English | Spanish | Russian | French

Internet Technology University | JavaSchool.com | Copyrights © Since 1997 | All Rights Reserved
Patents: US10956676, US7032006, US7774751, US7966093, US8051026, US8863234
Including conversational semantic decision support systems (CSDS) and bringing us closer to The message from 2040
Privacy Policy