BDC_LAB#1.md

Databases Laboratory Work #1

Setting environment

Prerequisites:

• Microsoft SQL Server 2017 and up
• Oracle 11g/12c

Objectives:

• Instalation of the software
• Ability to work with database software

General Requirements:

Laboratory work is considered as successfully passed after fulfilling the following steps:

1. During laboratory work should be completed 50% of requirements in order to get high mark (9-10)
2. You must elaborate a Report which will contain your work-flow and your conclusions. - Laboratory work Dead Line is due to next laboratory, and the report must be sent to my email in an appropriate format (readme file, md in git).
3. You must pass the quiz

Note:

More details you'll provide in your report, less questions I'll give to you during presentation of your report.

Try to use google us much as you can.

If you don't understand google explanation then try to ask for a help from colleagues or friends.

Send me email with your questions.

Note2: Use as an email subject the following pattern: [UTM][FAF-141 Labs][BDC] Name Surname

Laboratory Requirements:

References:

• SQL Server installation
• SSMS
• Creating a Database Connection
• Installing SQL Server 2012 Standard Edition
• Oracle 11g
• Oracle SQL developer

[Useful links]

• https://www.microsoft.com/en-us/sql-server/sql-server-downloads

• https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks

• https://archive.codeplex.com/?p=msftdbprodsamples