Gain insights into SQL and database fundamentals. Delve into data manipulation, administration, and normalization with practical tasks using SQL functions for backup, recovery, and user management.

Learn SQL - A Practical Guide for SQL Server and Database Fundamentals.png

sqldockerfile.tar.gz

sql_spa-copy

SQL is a must-know language for all types of roles, including development and data science. This course includes hands-on experience with the fundamentals of the SQL Server database including database administration.

The course covers the fundamentals of relational databases and database normalization. It offers a practical learning experience of retrieval, definition, manipulation, presentation and transformation of data through SQL functions. You will also learn database administration for backup, recovery and restore followed by managing the users, roles and privileges.

This course will teach you how to perform tasks related to SQL Server databases with hands-on experience. It covers the complete range of day-to-day operations.

A Practical Guide to SQL  and Database Fundamentals

Prod.Products Table

align-center

## Part A
Select all of the columns from the “Prod.Products” table.



```SQL 
SELECT * 
FROM Prod.Products
```
This is the solution to part A of the challenge. The `SELECT *` statement uses the `FROM` clause to choose all columns in the “Prod.Products” table.

Learn by practicing the SQL queries to extract data from database tables.

ProductID	Name	ProductNumber	Color	StandardCost	ListPrice	Size
1	LL Crankarm	CA-5965	Black	0	100	NULL
2	ML Crankarm	CA-6738	Black	0	300	NULL
3	HL Crankarm	CA-7457	Black	0	100	NULL
4	Chainring Bolts	CB-2903	Silver	0	400	NULL
5	Chainring Nuts	CN-6137	Silver	0	400	NULL

Introduction

Database Components

Structuring the Database

Data Retrieval

Data Definition

Data Manipulation

Transforming Data and Functions

Database Administration

Conclusion

Appendix

Learn Data Retrieval Through Practice

Problem

Prod.Products Table

Part A