GitHub Interactive Learning Peer Discussion

Prior to beginning work on this discussion forum, be sure you have completed both the Week 4 Learning Activity 1 and the Week 4 Learning Activity 2.

This week, you will explore the dynamic landscape of global information systems (GIS), understanding their pivotal role in modern business operations. You will study the essential requirements and components that shape GIS, examining how these systems facilitate seamless communication and collaboration across diverse geographical locations. Additionally, you will apply the systems development life cycle (SDLC) as a structured methodology for developing information systems, dissecting each phase to comprehend its significance in ensuring successful system development and implementation.

Furthermore, your journey will lead you to the intricate realm of enterprise resource planning (ERP) systems, where you will unravel their functionalities and impact on organizational efficiency. By analyzing the core components and functionalities of ERP systems, you will gain insights into how these systems streamline business processes and drive strategic decision-making. Additionally, you will critically evaluate the advantages and disadvantages of cloud-based enterprise systems, equipping yourself with the knowledge to harness the benefits while mitigating potential risks associated with cloud adoption. Get ready for a comprehensive exploration of GIS, SDLC methodologies, ERP systems, and cloud-based enterprise solutions that will empower you with the necessary skills to navigate the complexities of modern information technology. To learn more about this concept, review the Global Business Dynamics video in the online classroom.

Understanding GitHub is crucial in tech-related careers, especially within software development, cybersecurity, and data management. GitHub provides robust tools for version control, project collaboration, and efficient management of software development processes. Version control, one of GitHub’s most powerful features, helps track changes, prevent conflicts, and facilitate team collaboration.

Both labs consist of three tasks, in addition to installing GitHub. As part of discussion forum’s requirements, complete and share the following:

Step 1: GitHub Installation

Install GitHub and ensure your account is working. Please make sure to review the GitHub additional documentation pdf for any issues.

Step 2: Week 4 Learning Activity 1

Complete the following three tasks using GitHub: table (If you are unable to complete the lab or a specific task, please refer to the additional code examples in the PDF instructions provided in the course materials). Please be sure to select the correct database and are in the proper window for each task. Please see below:

Note: If you do not see the query.sql and the Companion you are not in the correct part of the lab.

Long description

A screenshot of a GitHub-integrated SQL lab environment showing a query in progress. The query selects all columns from the software.subscriptions table and limits the result to 50 rows using LIMIT 50. The interface shows SQL code on the left and a hint box on the right explaining the lab task, which is to pull all columns but only 50 rows. The user has successfully completed the task, as indicated by a green checkmark.

• Task 1: Pull all rows and columns from the retail. inventory table.
• Task 2: Ensure you select the correct database and read The Situation for each task.
• Task 3: Use the retail.payments table to pull all rows and columns except the column that contains portions of credit card numbers.

Repeat the above using the retail.payments table again to pull all rows and columns except the credit card number column.

Step 3: Week 4 Learning Activity 2

Complete the following three tasks using GitHub: table (If you are unable to complete the lab or a specific task, please refer to the additional code examples in the PDF instructions provided in the course materials). Please be sure to select the correct database and are in the proper window for each task. Please see below:

Note: If you do not see the query.sql and the Companion you are not in the correct part of the lab.

Long description

A partial screenshot of the output results from the SQL query run on the software.subscriptions table. It displays a table format with subscription IDs, timestamps, and status fields such as “complete” and “basic_month.” This confirms the execution of a correct query returning subscription data, with a visible grade at the bottom showing 66.67%.

This activity also includes three tasks:

Use the hamburger icon on the lower right side to select the correct database.

• Task 1: Pull all columns but only 50 rows from the software.subscription table.
• Task 2: Use the software.subscriptions table to pull all columns for subscriptions that have been canceled.
• Task 3: Use the software.subscription table again to pull all columns for premium year subscriptions.

Submission Requirements

Take 7 screenshots and paste them into a Word document to submit to the discussion for peer review:

• Screenshot of your completed GitHub installation
• Three screenshots showing scores from the three tasks in Week 4 Learning Activity 1
• Three screenshots showing scores from the three tasks in Week 4 Learning Activity 2