Please note that when SQL queries are run, results are generated in the form of data. Questions using the queries completed in steps 1–5. Word document that includes the SQL queries used to explore the database tables and answer the following Īccess the data dictionary titled “AdventureWorks 2014 Sample OLTP Database,” located in Class Resources,Īnd use SELECT and FROM statements to find the answer to each of the questions below. Toĭo this, you must utilize SELECT and FROM statements like the example provided below.ĮXAMPLE: SELECT * FROM. Your supervisor also wants you to gain an understanding of the content included in the company database. Orientation process, you have been asked to learn a little about the company by reading the “Adventure Works This assignment uses a GCU-provided virtual machine that will be specified by your instructor.įor this assignment, assume you have just been hired by Adventure Works Cycles company. The purpose of this assignment is to practice navigating and identifying database tables and related fields. What are youĮxcited about learning? What do you think will be most challenging?įeb 24, 2022, 12:00 AM Mar 2, 2022, 11:59 PM 35
Take a moment to explore your new classroom and introduce yourself to your fellow classmates. Oracle: The Same, But Different?” by Stansfield, located on the Segue Examine the process of database management within a typical IT department.
Evaluate the pros and cons of using various database software programs to address business problems.ĥ. Define basic components of databases: structures, tables, and metadata.Ĥ. Schemas and write queries to retrieve data from various tables.ġ. Students will become familiar with basic SQL commands as they explore database User roles within a database environment, and shows how databases are used to facilitate solutions to realworld business problems. This topic provides an introduction to database management system concepts and components, describes
This resource can be used throughout the course to assist with assignment completion. Download and save a copy of the file using the link provided. Use the “AdventureWorks 2014 Sample OLTP Database” dictionary to complete the assignments for thisĬourse. Use this link to download the resource versions as directed by your instructor. This course requires the use of the AdventureWorks OLTP downloads. This document provides a history of changes to the course. Virtual machines are located in LopesCloud and will be utilized for This course requires the use of LopesCloud. Grand Canyon University 2022 © Prepared on: Feb 21, 2022 You will use this resource throughout the course to assist with assignment ISBN-13:Įxplore the SQL Tutorial website. Emphasis is on appropriate application and implementation of database functions in relation to Students examineĭatabase design types, development, staging, production environments, and maintenance of a database This course introduces the basic role and uses of databases within business enterprises.