database assignment answers

SQL Tutorial

Sql database, sql references, sql examples, sql exercises.

You can test your SQL skills with W3Schools' Exercises.

We have gathered a variety of SQL exercises (with answers) for each SQL Chapter.

Try to solve an exercise by filling in the missing parts of a code. If you're stuck, hit the "Show Answer" button to see what you've done wrong.

Count Your Score

You will get 1 point for each correct answer. Your score and total score will always be displayed.

Start SQL Exercises

Start SQL Exercises ❯

If you don't know SQL, we suggest that you read our SQL Tutorial from scratch.

Kickstart your career

Get certified by completing the course

COLOR PICKER

Contact Sales

If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail: [email protected]

Report Error

If you want to report an error, or if you want to make a suggestion, send us an e-mail: [email protected]

Top Tutorials

Top references, top examples, get certified.

• SQL Server training
• Write for us!

SQL Practice – common questions and answers for SQL skills

This article will show some important questions and answers to practice SQL.

Introduction

SQL is the base to handle different databases. Even some of the NoSQL databases use an extension of SQL to query data. Data Scientists, BI Analysts, BI Developers, DBAs, Database Developers, Data Engineers, Reporting Analysts, and several other jobs require SQL knowledge as part of the knowledge required. For data management, SQL knowledge is the base to handle databases and the numbers of jobs related to databases are growing each day. The software industry, including databases, is the world’s most in-demand profession. That is why in this article, we will show some questions and answers to practice SQL.

Requirements

In order to start, you need the SQL Server installed and the Adventureworks sample database installed. The following links can help you if you do not have them installed:

• How to install SQL Server developer edition
• Install and configure the AdventureWorks2016 sample database

Q1. Please select all the information of persons table that the name starts with A

A1. You will show all the columns with the select * and the where [FirstName] like ‘a%’ will filter the data to all the persons that the name starts with a. The query used is the following:

The LIKE operator is very common in SQL queries. The like ‘a%’ will show all the first names that start with the letter a. There are several other operators that you need to practice like the EXISTS, IN, =, <>, ANY. The following link provides more information about the operators:

• Operators (Transact-SQL)

Note that the use of * is a bad practice for big tables, but in this case, it is a small table, so it will not impact performance. In general, try to select only the columns required and not all.

Q2. Create a store procedure that receives the first name of the person table as input and the last name as output.

In SQL practice, it is necessary to mention the stored procedures because they are frequently used in SQL Server. The stored procedures are T-SQL sentences that cannot be applied to other databases like Oracle, MySQL, PostgreSQL. The following sample of code shows how to create a stored procedure named GetLastName. It receives the parameter @firstname and returns the last name of the provided firstname. It queries the Person table:

To call the stored procedure using T-SQL, you will need to declare a variable to store the output variable. We use the execute command to call a stored procedure. John is the parameter value for the first name and the last name is the output of the stored procedure:

The result displayed by this store procedure invocation will be something like this:

For more information about creating stored procedures, please refer to this link:

• Learn SQL: User-Defined Stored Procedures
• SQL Server stored procedures for beginners
• CREATE PROCEDURE (Transact-SQL)

Q3. Which query would you execute to delete all the rows from the person table with minimal bulk-logged activity?

A3. The truncate table sentence removes data without logging individual row deletions. It is the most efficient way to remove all the data. The delete command, on the other hand, logs a lot of data if we have multiple rows and can consume a lot of space in the transaction log files. So, the code will be the following:

Truncate table person.person

To practice SQL, try the truncate and delete statements. For more detailed information about the differences between the truncate and the delete sentences, refer to this link:

• The internals of SQL Truncate and SQL Delete statements

Q4. Create a query to show the account number and customerid from the customer table for the customer without sales orders.

A4. The query would be something like this:

The result displayed will be something like this:

We are using the left join to look for all the customers without sales, so the salesorderid will be null. In SQL practice, you need to know the use of the different JOINS like the LEFT JOIN, RIGHT JOIN, CROSS JOIN. We created some articles about the different types of JOINs here. It is very important for you to check, practice, and study all the options:

• Learn SQL: Join multiple tables
• Learn SQL: INNER JOIN vs LEFT JOIN
• SQL CROSS JOIN with examples

We could also use the EXISTS or the IN operators instead of using the JOINS. The performance is different according to the scenario. The performance in queries is out of the scope of this SQL practice. However, we have an entire article about this topic here:

• How to design SQL queries with better performance: SELECT * and EXISTS vs IN vs JOINs

Q5. You have a table with some of the temperatures in Celsius of some patients. Create a function or a stored procedure to get the convert Fahrenheit to Celsius. Would you use a function or a stored procedure?

A5. Basically, the question here is to create a stored procedure or a function to convert from Celsius to Fahrenheit. If you already have a table with some rows in Celsius, the easiest option is to use a function. The function could be something like this:

Invoking a function is easier than a stored procedure. For more information about the use of functions vs stored procedures, refer to this link:

• Functions vs stored procedures in SQL Server

Q6. Create a query to show the top 10 customerIDs of users with more Orders.

A6. For this practice test, we will use the TOP 10 to get the customer IDs with more orders. We will use the SUM to SUM the Order Quantity column. Note that for aggregated functions like the SUM, the alias is needed to define the column name in the query. Also, the Sum is grouped by the customer ID. Usually aggregated functions come with the GROUP BY clause. Finally, we are using the order by to order the result in descendant order:

For more information about aggregated functions like the SUM, MAX, MIN, AVG, refer to this link:

• Aggregate Functions (Transact-SQL)

In this article, we show different questions for SQL practice. We show some questions and answers to practice SQL and improve the knowledge. If you have more questions about this topic, do not hesitate to contact us.

• Recent Posts

• PostgreSQL tutorial to create a user - November 12, 2023
• PostgreSQL Tutorial for beginners - April 6, 2023
• PSQL stored procedures overview and examples - February 14, 2023

Related posts:

• A complete guide to T-SQL Metadata Functions in SQL Server
• Top SQL Server Books
• An overview of the SQL Server Update Join
• FOR XML PATH clause in SQL Server
• Creating and using CRUD stored procedures

• Top Courses
• Online Degrees
• Find your New Career
• Join for Free

Introduction to Relational Databases (RDBMS)

This course is part of multiple programs. Learn more

This course is part of multiple programs

Taught in English

Some content may not be translated

Instructors: Rav Ahuja +1 more

Instructors

Instructor ratings

We asked all learners to give feedback on our instructors based on the quality of their teaching style.

Financial aid available

54,209 already enrolled

(526 reviews)

Recommended experience

Beginner level

Computer and IT literacy. Curiosity about how data is managed.

What you'll learn

Describe data, databases, relational databases, and cloud databases.

Describe information and data models, relational databases, and relational model concepts (including schemas and tables). 

Explain an Entity Relationship Diagram and design a relational database for a specific use case.

Develop a working knowledge of popular DBMSes including MySQL, PostgreSQL, and IBM DB2

Skills you'll gain

• Database (DB) Design
• Relational Database Management System (RDBMS)
• Database Architecture

Details to know

Add to your LinkedIn profile

13 assignments

See how employees at top companies are mastering in-demand skills

Build your subject-matter expertise

• Learn new concepts from industry experts
• Gain a foundational understanding of a subject or tool
• Develop job-relevant skills with hands-on projects
• Earn a shareable career certificate

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 4 modules in this course

Are you ready to dive into the world of data engineering? In this beginner level course, you will gain a solid understanding of how data is stored, processed, and accessed in relational databases (RDBMSes). You will work with different types of databases that are appropriate for various data processing requirements.

You will begin this course by being introduced to relational database concepts, as well as several industry standard relational databases, including IBM DB2, MySQL, and PostgreSQL. Next, you’ll utilize RDBMS tools used by professionals such as phpMyAdmin and pgAdmin for creating and maintaining relational databases. You will also use the command line and SQL statements to create and manage tables. This course incorporates hands-on, practical exercises to help you demonstrate your learning. You will work with real databases and explore real-world datasets. You will create database instances and populate them with tables and data. At the end of this course, you will complete a final assignment where you will apply your accumulated knowledge from this course and demonstrate that you have the skills to: design a database for a specific analytics requirement, normalize tables, create tables and views in the database, load and access data. No prior knowledge of databases or programming is required. Anyone can audit this course at no-charge. If you choose to take this course and earn the Coursera course certificate, you can also earn an IBM digital badge upon successful completion of the course.

Relational Database Concepts

In this module, you will first learn about the fundamental aspects of data structures and file formats, along with the differences between relational and non-relational databases. You’ll explore various types of data models and discuss fundamental concepts in database management. Additionally, you’ll explore Entity-Relationship Diagrams (ERD) along with their components and relationships. You will also gain expertise in diverse database topics. Finally, you’ll gain a clear understanding of Db2 and PostgreSQL.

What's included

14 videos 3 readings 4 assignments 3 plugins

14 videos • Total 86 minutes

• Course Introduction • 4 minutes • Preview module
• Review of Data Fundamentals • 7 minutes
• Information and Data Models • 6 minutes
• ERDs and Types of Relationships • 4 minutes
• Mapping Entities to Tables • 5 minutes
• Data Types • 5 minutes
• Relational Model Concepts • 6 minutes
• Database Architecture • 6 minutes
• Distributed Architecture and Clustered Databases • 4 minutes
• Database Usage Patterns • 6 minutes
• Introduction to Relational Database Offerings • 7 minutes
• Db2 • 10 minutes
• MySQL • 6 minutes
• PostgreSQL • 4 minutes

3 readings • Total 5 minutes

• Course Overview • 3 minutes
• Summary and Highlights • 1 minute

4 assignments • Total 50 minutes

• Practice Quiz: Fundamental Relational Database Concepts • 10 minutes
• Practice Quiz: Introducing Relational Database Products • 10 minutes
• Graded Quiz: Fundamental Relational Database Concepts • 15 minutes
• Graded Quiz: Introducing Relational Database Products • 15 minutes

3 plugins • Total 26 minutes

• Helpful Tips For Course Completion • 1 minute
• Hands-on Lab: Relational Model Concepts • 10 minutes
• Hands-on Lab: Advanced Relational Model Concepts • 15 minutes

Using Relational Databases

In this module, you’ll explore the types of SQL statements, like Data Definition Language (DDL) and Data Manipulation Language (DML). You’ll learn how to create, modify, and manage tables using DDL statements and understand data movement utilities for efficient data loading and management. Additionally, you’ll dive into key database objects such as schemas, primary keys, foreign keys, and indexes, gaining insights into their roles in data organization, integrity, and retrieval. You’ll also understand the importance of normalization for reducing redundancy and ensuring data consistency, while also understanding various constraints within the relational model to maintain data accuracy and reliability.

11 videos 2 readings 4 assignments 3 app items 4 plugins

11 videos • Total 51 minutes

• Types of SQL Statements (DDL vs. DML) • 2 minutes • Preview module
• Creating Tables • 5 minutes
• CREATE TABLE Statement • 3 minutes
• ALTER, DROP, and Truncate Tables • 3 minutes
• Data Movement Utilities • 6 minutes
• Loading Data • 3 minutes
• Database Objects and Hierarchy (Including Schemas) • 6 minutes
• Primary Keys and Foreign Keys • 3 minutes
• Overview of Indexes • 5 minutes
• Normalization • 6 minutes
• Relational Model Constraints - Advanced • 4 minutes

2 readings • Total 4 minutes

• Summary and Highlights • 2 minutes
• Practice Quiz: Creating Tables and Loading Data • 10 minutes
• Practice Quiz: Designing Keys, Indexes, and Constraints • 10 minutes
• Graded Quiz: Creating Tables and Loading Data • 15 minutes
• Graded Quiz: Designing Keys, Indexes, and Constraints • 15 minutes

3 app items • Total 95 minutes

• Hands-on Lab: Create Tables and Load Data in Datasette • 20 minutes
• Hands-on Lab: Normalization, Keys, and Constraints in Relational Database • 60 minutes
• (Optional) Obtain IBM Cloud Feature Code and Activate Trial Account • 15 minutes

4 plugins • Total 72 minutes

• Reading: Overview of Optional Lesson • 2 minutes
• (Optional) Hands-on Lab: Create Db2 service instance • 15 minutes
• (Optional)Hands-on Lab: Create Tables and Load Data in Db2 • 30 minutes
• (Optional) Hands-on Lab: Normalization, Keys, and Constraints in Relational Databases (with Db2) • 25 minutes

MySQL and PostgreSQL

In this module, you will learn about the fundamental aspects of MySQL and PostgreSQL and identify Relational Database Management System (RDBMS) tools. You will explore the process of creating databases and tables and the definition of keys, constraints, and connections in MySQL. Additionally, you will discover important processes in PostgreSQL using command line, pgAdmin, and views. Moreover, you will gain essential skills such as database loading techniques and insights into securing sensitive data and streamlining data retrieval.

7 videos 2 readings 4 assignments 6 app items

7 videos • Total 34 minutes

• Getting Started with MySQL • 7 minutes • Preview module
• Creating Databases and Tables in MySQL • 3 minutes
• Populating MySQL Databases and Tables • 5 minutes
• Using Keys and Constraints in MySQL • 3 minutes
• Getting Started with PostgreSQL • 7 minutes
• Creating Databases and Loading Data in PostgreSQL • 4 minutes
• Views • 3 minutes

2 readings • Total 3 minutes

• Practice Quiz: MySQL • 10 minutes
• Practice Quiz: PostgreSQL • 10 minutes
• Graded Quiz: MySQL • 15 minutes
• Graded Quiz: PostgreSQL • 15 minutes

6 app items • Total 115 minutes

• Hands-on Lab: Getting Started with MySQL Command Line • 20 minutes
• Hands-on Lab: Create Tables and Load Data in MySQL using phpMyAdmin • 20 minutes
• Hands-on Lab: Keys and Constraints in MySQL using phpMyAdmin • 20 minutes
• Hands-on Lab: Getting Started with PostgreSQL Command Line • 20 minutes
• Hands-on Lab: Create Tables and Load Data in PostgreSQL using pgAdmin • 20 minutes
• Hands-on Lab: Views in PostgreSQL • 15 minutes

Final Project and Assessment

In this module, you will navigate the database design process, refine your practical skills, and understand essential steps. You will discover the role of Entity Relationship Diagrams (ERDs) and get an opportunity to engage in a hands-on database design lab, where you will use your theoretical knowledge to create databases. As you progress, you will receive an optional final assignment and project submission stages. For those seeking an advanced challenge, a final project using Db2 is available. A glossary is available for quick reference to key terms used throughout the module.

1 video 2 readings 1 assignment 1 peer review 2 app items 2 plugins

1 video • Total 7 minutes

• Approach to Database Design (Including ERD) • 7 minutes • Preview module
• Congratulations and Next Steps • 2 minutes
• Thanks from the Course Team • 2 minutes

1 assignment • Total 45 minutes

• Final Exam • 45 minutes

1 peer review • Total 60 minutes

• Project Submission and Peer Review • 60 minutes

2 app items • Total 135 minutes

• Hands-on Lab: Database Design Using ERDs • 45 minutes
• Final Project: Database Design and Implementation • 90 minutes

2 plugins • Total 45 minutes

• Reading: Project Overview • 20 minutes
• Course Glossary • 25 minutes

IBM is the global leader in business transformation through an open hybrid cloud platform and AI, serving clients in more than 170 countries around the world. Today 47 of the Fortune 50 Companies rely on the IBM Cloud to run their business, and IBM Watson enterprise AI is hard at work in more than 30,000 engagements. IBM is also one of the world’s most vital corporate research organizations, with 28 consecutive years of patent leadership. Above all, guided by principles for trust and transparency and support for a more inclusive society, IBM is committed to being a responsible technology innovator and a force for good in the world. For more information about IBM visit: www.ibm.com

Recommended if you're interested in Data Management

Relational Database Administration (DBA)

Getting Started with Data Warehousing and BI Analytics

ETL and Data Pipelines with Shell, Airflow and Kafka

Introduction to NoSQL Databases

Why people choose coursera for their career.

Learner reviews

Showing 3 of 526

526 reviews

Reviewed on Sep 22, 2022

Very good however some parts need updating where the various portals have cahnged.

Reviewed on Sep 28, 2021

Really great and gives a foundation of relational databases.

Reviewed on Aug 29, 2023

This is best course I have came across . very good content . Easy to understand and more practical.

New to Data Management? Start here.

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions

When will i have access to the lectures and assignments.

Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:

The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.

The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I subscribe to this Certificate?

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

What is the refund policy?

If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy Opens in a new tab .

More questions

How to Create Your Own Database to Practice SQL

• sql practice
• sql queries

Table of Contents

Why You Need Your Own Database for Practice

Step 1: install required software, step 2: create a sql database, step 3: create custom tables, step 4: import data from csvs, example 1: what is the distinct count of customers, example 2: what is the average number of invoices per customer, the long-term benefits of regular practice, practice sql on your own database.

Welcome to the step-by-step guide to creating your own SQL database from scratch, designed with beginners in mind. This guide not only helps you set up your database but also introduces you to essential SQL practice exercises to get you started on your learning journey. Follow along to gain SQL hands-on practice and foster a deeper understanding of SQL functionalities. Set a solid foundation for more advanced SQL training!

Everyone has a different style of learning, but one thing we all need is SQL hands-on practice. It is one thing to read about SELECT statements, JOINS , and GROUP BY clauses, but it is an entirely different experience to use them in queries and see the results.

This is a lot like when I took 3 years of Spanish in school. One thing I found both fascinating and frustrating was that I could understand the teacher but struggled to form sentences to respond. This is not unusual; it often happens because we practice learning new words but neglect using them.

Learning by doing is one of the most effective ways to acquire a new skill. So, what is the most effective way to practice “speaking” SQL?

That is our focus in this article. If you’re interested in more on the best ways to learn SQL, be sure to check out this article here .

LearnSQL.com offers several comprehensive courses that include interactive exercises for SQL practice. You go through hundreds of exercises, covering dozens of hours to help you master SQL. For example, the SQL Basics course includes 129 practice exercises and 10 hours of hands-on learning. In addition, the course Data Types in SQL includes 89 exercises and another 10 hours of instruction.

These courses are a great way to learn the “new words” of SQL, and the practice exercises help you use them in writing your queries. However, while structured learning is a great resource, you can take your learning to a whole new level by setting up your own SQL database for practice. In this article, I will walk you through the tools and steps you need to accomplish this task.

When you have your own database, you get the freedom to customize it however you want, from the table structure to the actual data it houses. You can create real-world scenarios tailored to your learning objectives. Your data stays with you, and you may explore and even make mistakes, without any judgment or fear of breaking something.

Plus, the ability to stimulate real-world scenarios allows you to practice SQL for job-specific conditions, making you better prepared for the professional world. Looking for a job in e-commerce ? Set up your database with an order table, a customer table, and a product table. Interested in a career in finance ? Great! Create a table for accounts receivable and another for accounts payable. The flexibility in creating your own database is unmatched by other ways to practice SQL.

If setting up a database sounds intimidating to you, don’t worry! It is very simple in practice. Different databases have different nuances. We won’t spend time here explaining them, but you can learn more about some of the most popular databases in 2023 in this article .

A Step-by-Step Guide to Setting up Your SQL Database

OK, let’s get started setting up your database for SQL training. The first thing you need to do is to download a database tool. One that I use that works on Windows, Linux, and Mac is DBeaver, which may be downloaded here . Best of all, it’s free!

Want some other tool? Check the article on the best SQL IDEs .

Once you’ve downloaded and installed the software, launch the application. You should see a screen that looks like this:

In the top toolbar, click on “Help” and then “Create Sample Database.” You then see a prompt asking if you would like to create a sample database. Click “Yes.”

You should now see a sample database listed under your connections under the Database Navigator panel.

This sample database comes with already created tables and views you can query immediately. Later in this article, there are a few examples of SQL queries for practice with your new database. For now, let’s look at how we may further customize this database.

Let’s go back to our example of practicing with e-commerce data. I’m going to rename my database to ecommerce_data by right-clicking on the database name and selecting “rename.”

To create a new table for orders , we execute a CREATE TABLE statement. In this statement, we define the table name of orders and then define the column names and the data types.

You can now run SELECT * FROM orders , but you will see an empty table. The next step is to insert rows into this table using an INSERT statement.

Now, you will see your new data when you run a SELECT statement.

Inserting individual rows of data is tedious depending on how much data you want to set up in your database. Another option is to import whole CSV files rather than writing INSERT statements. To do this, right-click on the table name under your sample database and select “Import Data.”

From here, select a CSV from your computer to upload. If you do not see your table listed under your sample database, right-click on the database name and click “Refresh.” You should then see the newly created tables.

There you have it! Your own database to practice SQL.

If you’re unsure about creating your own data, you can also find several resources online with public datasets for download. You can then import these files into your database. A good, clean data set often used is the superstore data from Tableau. This Excel sheet includes 3 separate tabs to create 3 tables of store purchase data. Another great resource for finding data sets is our article, “ Where Can I Find Free Online Data Sets to Practice SQL? .”

Practice Queries

Let’s walk through a few examples to get you started in using your new database. This is only the beginning; you’ll be on to exploring your data in no time. For an added challenge, try answering the question on your own before reading the SQL query.

The questions below use the customer and invoice tables in the DBeaver sample database.

For this example, we only need to query the customer table. Use COUNT() and DISTINCT to answer this question.

This query counts the number of unique CustomerIds in the customer table. We now see there are 59 customers in our database.

Next, let’s see how many invoices each customer has on average.

To answer this question, use the invoice table and create a list of all customer IDs with how many invoices each has.

At a glance, it looks like most customers have 6 or 7 invoices. Let’s calculate the average across all customer IDs by placing the above in a subquery and calculating the average:

The query returns 6.98 invoices, on average, for each customer.

These examples are just to get you started. Get familiar with what data lives in each table and how the tables relate to one another. Then, begin asking yourself questions and creating hypotheses. Finally, begin exploring the data by writing queries to answer those questions and test your hypotheses.

A great resource to reference is our SQL for Data Analysis Cheat Sheet . This is a curated list of SQL commands to help you get started. Once you get started, it’ll be hard to stop!

There are numerous advantages to practicing SQL regularly. You improve your problem-solving skills, make yourself more marketable for higher-paying jobs, and get better equipped to handle complex databases. Trust me, practice does make perfect, and the more real-world problems you solve, the better you become.

Regular SQL practice significantly enhances your analytical thinking . As you delve deeper into your SQL database setup and start working with more complex queries, you learn to analyze data from various angles. This not only helps in extracting precise information but also in understanding the intricate relationships between different data sets.

Moreover, the ability to dissect and interpret complex data is a highly valued skill in many professions today. This puts you a step ahead in your career journey .

As you practice SQL through hands-on exercises, you find yourself becoming more autonomous and confident in your abilities. You learn to trust your judgment and develop a knack for finding solutions to complex problems. This is an indispensable trait in the ever-evolving tech landscape.

Furthermore, by setting up your own SQL database for practice, you foster a deep understanding of the database structure and nuances. This is a substantial asset in both learning and professional environments.

Dedicating time to SQL practice exercises is an investment in your future. The world is becoming increasingly data-driven . Proficiency in SQL is often a prerequisite in many fields, not just in IT but also in marketing , finance, healthcare , and more. By committing to regular practice, you are not just learning a skill but are paving the path to opportunities in a wide array of industries, opening doors to potential roles that are both fulfilling and financially rewarding.

So, there you have it! Your own SQL database setup for practice is not only possible but incredibly beneficial. You get customization, privacy, and the ability to simulate real-world scenarios.

If you’re looking to upskill further, remember to check out the extensive courses offered by LearnSQL.com . The All Forever package provides lifetime access to all the courses and tracks plus any new courses released in the future! This option, by far, gives you the most bang for your buck with a huge discount.

Start your SQL journey now by setting up your personal database. Dive into it, practice daily, and you’ll be amazed at how far you go. Happy querying!

You may also like

How Do You Write a SELECT Statement in SQL?

What Is a Foreign Key in SQL?

Enumerate and Explain All the Basic Elements of an SQL Query

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing: Proofread your work by experts and improve grade at Lowest cost

Enter phone no. to receive critical updates and urgent messages !

Error goes here

Please upload all relevant files for quick & complete assistance.

New User? Start here.

Unlock Accurate Database Answers And Make Way For Top Grades

Witness a difference in your grades with incredible answers on topics like ‘Databases and business intelligence', 'Cloud Computing',' Geospatial Databases and Information Retrieval, and more. Click here to fuel your academic success in database assignments instantly.

AssumptionWrite a Report  Demonstrate Queries On The Database. Technology Stack Linux Apache, Mysql, Php i Have Been Tasked With Reverse Engineering a Web Based Relational Database For Commercial Accommodation Booking. Booking.com is world’s one of the most popular platform for ticket booking, hotel booking, flight ticket, rent taxies on the airport. The aim of this assignment to design the probable database of this website. To...

Business Rules1. Show Current Price Of Apple For All Exchanges 2. Show Maximum Price Of a Share In Usa Market  3. Show Minimum Price For Apple For All Data (From All Exchanges)  4. Find Broker Who Has Maximum Number Of Appointments  5. Find Customer Which Booked The Maximum Number Of Appointments  6. Show All Uk Stocks Having Price Higher Than Average For Asian Market Today  7. Show All Stocks Having ...

BackgroundData Analytics/Fundamentals of Data Analytics Student Name: Date: 1stApril 2021 1. BACKGROUND The purpose of this assignment is to implement the data distance techniques and the Association Rules Mining using the Apriori and FP-Growth algorithms for the frequent item sets. 2. QUESTIONS Question 1: (20points) Given two objects represented by two tuples: Tuple 1is your date of birth in the format (first digit Year, last digit Year, MM, D...

Page 1 of 15 [1589] Arden University © reserves all rights of copyright and all other intellectual property rights in the learning materials and this publication. N o part of any of the learning materials or this publication may be reproduced, shared (including in private social med ia groups), stored in a retrieval system or transmitted in any form or means, including without limitation electronic, mechanica...

ScenarioRetail4profit is expanding business lines and strategy and as an online e-commerce company established ten years ago, the aim of the business is to make profit. The aim of the company is to ensure quality services to its customers. It has grown over the years into a company with a turnover of £50 million.  The company is headquartered in london, where the company was originally founded, with regional offices across the cou...

Task 1: Develop Data Model1. Read the requirements carefully and identify the purpose of this database, and draw a list of use cases (this is pretty much already given to you in the requirements). 2. As you develop your data model, note any assumption you make and any question you have for your client. 3. Develop a data model for Eye Candy Cinemas from all the information given above. The EntityRelationship Diagram is to include: the entiti...

DescriptionThe goal is develop a database for the Wedgewood Pacific Corporation using MS SQL Server. 1. In MS SQL Server, create a new database called Wpc. 2. Create the Department and Employee tables shown below along with the Project and Assignment tables shown on the next page, and set the relationships between the tables explained below: A. To set a column to be a Primary Key, right-click on the column name (while in the design mode) and ...

Service Ticket System OverviewJim has just taken the position of the Director of the IT department. Understanding that the top priority of his position is to provide quality IT services to internal employees, he wants to digitize IT services by first adopting an IT Service Ticket system (STS) to manage service requests and keep track of service quality. Currently, the IT department offers support services (e.g., installation, setup, upgrade, ...

Query 1The Queries – Using the Rousseau’s Furniture database that we will put together during class time. Write a single statement for each query requested below. Include helpful comments. Remember to verify the result of your query is the correct result! Query 1Write a select statement that will list a customer's company name, their first and last names and their city in that order. Only include customer...

Student List MetadataYou asked several different employees (developers and architects--to walk you through the data provided) and you created a matrix of information (meta-data) about the data from the spreadsheets. The student id is school specific. We have no control over how this ID is created or what it looks like. For some schools, this value might be numeric, but for others there is a good chance that it will contain string data. Dif...

Table Creation and Loadinga) Provide (see submission area) the Create statements for tables Doctor, Patient and Appointment with appropriate primary and foreign keys. b) Develop tables in Oracle and load the data, provide table structure and content  (see submission) provide table content and table structure of each table All queries MUST be based SOLELY on the information provided and each question must use a SINGLE query . No views...

Unit Learning Outcomes Assessed.Assignment Task (100%):  This is an individual assignment. Choose a business process that is performed by an organisation, such as Automating a technical support system (Help Desk) Booking a seat at a theatre Buying a car insurance policy For your chosen process: Briefly describe the business process that you selected and its functionality. Construct a Data Flow Diagrams (DFD) for it. C...

Current SituationYour team has joined a chain of national Health Care provider in New Zealand called ?HCareNZ?. The company runs health centers across the country and provides valuable services with their customers. At the time of your appointment, the company was going through the process of evaluating cloud computing and has decided to move their technology infrastructure, platforms, data, and software applications to the cloud. However, the...

Part 1: Database DesignAs reported by the BBC, women are still severely underrepresented in public statues in the UK. The Public Statues and Sculpture Association lists 122 public statues of women. The WikiData knowledge base only lists 98 items described as statues of women in the UK, but many are not geolocated – i.e., the precise latitude and longitude of the location are not available. The Assignment_1--Statues-Wikidata.csv datase...

Undertake Analysis and Clarify Business Rules and Constraints for YAHUASAssignment Brief This module will equip students with the database system skills, knowledge and techniques that will enable them to work effectively in a commercial environment. The module will consider the problems and decisions that face database designers and administrators and provide strategies that will enable their resolution.Students will develop a detailed know...

Writing an essay is a common task in high school, college, and university assignments. It is a

Don't know about essay outlines? If not, you are not doing anything right. An outline is essentiall

Students in their academic journeys often get tasks to craft essays on a wide range of topics i

Conclusions play a vital role in any academic writing. They involve summarising your research findi

Navigation Menu

Search code, repositories, users, issues, pull requests..., provide feedback.

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly.

To see all available qualifiers, see our documentation .

infytq-solutions

Here are 13 public repositories matching this topic..., omkar98 / infytq-answers.

Solutions to InfyTQ Assignments, quiz and tests.

• Updated Sep 16, 2023

SUDARSHANTADAGE / InfyTQ-Answers

Solution of all InfyTQ Assignments, Exercise, Quiz

• Updated Nov 22, 2020

Anupam-2105 / Infosys-Springboard

Here in this repository, you can find solution to Infosys Springboard DBMS Part-1 assignments, quiz and exercises.

• Updated Oct 23, 2023
• Rich Text Format

iamwatchdogs / Infytq-Programming-Fundamentals-using-Python-Part-1

Solution for all the quizzes, exercises and assignments for the Infytq's course Programming Fundamental using python part-1 in this repository.

• Updated Mar 4, 2023

manthan89-py / InfyTq-Coding-Questions

This repository contains python solution of INFYTQ FINAL ROUND CODING question solution. You can add Java Solution of question or some other question which was not added here.

• Updated May 14, 2021

akshitagupta15june / Infytq_day9

It contains problem of day 9 infytq of all levels.

• Updated Aug 23, 2020

surajkarna / INFYTQ-Data-Structures-using-Python-1

This is my official repository of the INFYTQ's DATA STRUCTURES AND ALGORITHM USING PYTHON.

• Updated Feb 15, 2023

ashwanisng / infyTQ-java

• Updated Jan 20, 2021

salonisingh77 / Infytq-previous-year-coding-questions

Infytq previous year coding questions easy solutions

• Updated Jan 18, 2022

2002Dhanush / INFYTQ-PYTHON-SOLUTIONS

Solutions of InfyTQ Assignments

• Updated Aug 14, 2023
• Jupyter Notebook

dlyaswanth / InfyTq-PF

Answers for Programming Fundamentals

• Updated Oct 23, 2020

avibhawnani / InfytQ--Solutions

InfyTQ Answers

• Updated Apr 2, 2022

saurabhc24 / InfyTQAnswers

This repository contains solutions to quizes, exercises and assignments of InfyTQ certification.

Improve this page

Add a description, image, and links to the infytq-solutions topic page so that developers can more easily learn about it.

Curate this topic

Add this topic to your repo

To associate your repository with the infytq-solutions topic, visit your repo's landing page and select "manage topics."