SQL, Structured Query Language, is a language used by software developers, data scientists, and anyone who works
Question:
SQL, Structured Query Language, is a language used by software developers, data scientists, and anyone who works with data. There are various database management systems (DBMS) that support SQL, but each product has its SQL implementation. In this task, we will be using SQL Financial Accounting to learn SQL. SQL Financial Accounting is the most popular free and open-source database management system in the world. If you use a different DBMS (e.g., SQL Server), you can still benefit from this task as 90% of the skills you'll learn in this task can be transferred to other database management systems.
ASSIGNMENT COMPONENTS:
Store data in relational databases and queries to extract valuable information. This will be divided into four-part:
Task A: Installing SQL Financial Accounting on Windows
Task B: Creating Databases
Task C: Customer Databases
Task D: Sales Databases
You are required to perform SQL statements and instruct the SQL Financial Accounting server to perform the below operations:
• Data query: requesting specific information from the existing database.
• Join and Select operations
• Data manipulation: adding, deleting, changing, sorting, and other operations to modify the data, the values, or the visuals.
• Data identity: defining data types, e.g., changing numerical data to integers. This also includes determining a schema or the relationship in the database
Database Systems A Practical Approach to Design Implementation and Management
ISBN: 978-0132943260
6th Edition Global
Authors: Thomas Connolly, Carolyn Begg