This blog is for how to setup and use the SQL Programming Language Introduction course that has been mentioned in the last 2 Blogs.
Before you can start this course you need to have done all the following:
- Download SQL Server Express 2012. Click here.
- Installed SQL Server Express 2012 or later (course is based on SQLServer 2012 or Oracle 11g). Click here for instructions.
- Downloaded the SQL Programming Language Introduction Course Documents. Click here.
- Downloaded the SQL Programming Language Introduction Course Exercises and answers. Click here.
- Downloaded the SQL Programming Language Introduction Course Database Scripts to create the Course Enviroments to do the exercise on. Click here.
- Downloaded the SQL Programming Language Introduction Example Answers SQL Scripts. Click here.
- Downloaded the SQL Programming Language Introduction SQL Script Solutions/Answers. Click here.
Instructions on how to get set up for SQL Programming Language Introduction Course:
The following screenshots and instructions are for setup and configuration with SQL Server Management Studio (SQL SMS) so you are ready to follow the course that has been provided in previous blog, and is available to download in links above in prerequisites.
- Run Microsoft Studio Manager 2012
2. SQL Server Management Studio 2012 will load and present you with a connection window to your database server.
Server Name: is the name of your SQL server.
(1) Authentication: drop this box down with arrow on right hand side to allow the selection of “SQL Server Authentication”. This means you will have to enter the user name a password for the SQL server you installed and setup (important you remembered the password you entered into the setup).
(2) Login: Type “SA”. This stands for “System Administrator” and is the highest level of security on your SQL Server.
(3) Password: This is the password you entered in the setup when install your SQL Server.
(4) Remember this password: I always tick this box to save myself retyping the password every time i want to sign into the SQL database. If you are in a business, never tick this as anyone can use it to sign in without typing anything.
(5) “Connect”: press connect once all details are entered correctly and you will be signed into the SQL server and be able to move onto the next stage and work with your database setup.
3. You will now see down the left hand side of your SQL Server Management Studio application all the system databases. This now tells you that you have signed in successfully.
4. Now press “New Query” which will open you up a white window on the right hand side of application with a yellow tab saying “SQLQuery……sql” on it. This is now ready for you to Paste into it the text you need to have to create your database. Query windows are what you can write SQL commands and other formulas and execute, to make different pieces of information and the way they display within or outside the SQL SMS application.
5. Now move away from SQL SMS application over to where you downloaded the database setup files mentioned in prerequisites above. Right click on file “SQLServer-Eastwind.sql”, and open with “Notepad”.
6. In Notepad, click into file contents and then press CTRL-A on your keyboard (will highlight all text blue. Press CTRL-C to copy all the text.
7. Click into blank SQLQuery window on SQL SMS application and then press CTRL-V to paste all the text from Notepad into the window.
8. Now press “Execute” on application to get the following display like below. You should see all a message below that says that the rows are affected and finished with no errors.
9. Now look at the database on left hand side of application and there will be still be no new database called Eastwind.
Press refresh button as shown in screen shot below. You will now be able to expand the databases folder with the + symbol next to it, and then see “EastWind” database as show in screen shot below.
10. Expand even more the contents of the “EastWind” database with the + symbol next to “EastWind” database. Now you will see the tables with the database like screen shot below. These tables contain the information that you want to store within the course.
11. Now you can test the SQL database and follow the course by typing SQL commands into the Query windows and executing.
12. You can see an example of a simple lookup command in the screenshot below to show you that the SQL database is working and display the information within the “Customers” table to you.
You are now ready.
How to use the SQL Programming Language Introduction Course:
This course gives you an overview of what SQL databases are and shows you how to start using them.
You need to start reading the main course document and then start incorporating the other download documents mentioned in prerequisites (at top of page) to complete the main document.
When you get to the “Hands-On Exercises”, then you need to refer to the Exercise Document also mentioned in prerequisites (at top of page) to complete these exercises.
Then carry on with the next chapter in the main course document.
If you want to check your answers to the questions after you do them the answers are in the back of the Exercise Document…… but try not to cheat, as you are only cheating yourself.
I will Blog another learning soon on maybe another topic.
If you have any questions or suggestions, just contact me on this website.