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


The code outputs the number of columns with the `TotalIDs` alias.

The code outputs the records in the `Cust.Customers` table including NULL with the `TotalIDs` alias.

The code outputs the number of records in the `Cust.Customers` table excluding `NULL` values with the `TotalIDs` alias.


The code outputs all the rows in the `Cust.Customers` table with the `TotalIDs` alias.

What is the output of the following code?
```SQL
SELECT COUNT(Customer) AS TotalIDs 
FROM Cust.Customers
```
 

What is the output of the following code?
<pre><code class="language-SQL">SELECT COUNT(Customer) AS TotalIDs 
FROM Cust.Customers
</code></pre>

``` SQL
SELECT *
FROM Sales.ProductSales
WHERE UnitPrice = (SELECT MAX(UnitPrice) FROM Sales.ProductSales)
```

``` SQL
SELECT FROM Sales.ProductSales
WHERE UnitPrice = MAX(UnitPrice) FROM Sales.ProductSales
```

``` SQL
SELECT *
FROM Sales.ProductSales
```

We want to obtain all columns/headers for the sales that had the highest total from the `Sale.ProductSales` table. Which code will achieve the above-mentioned scenario?

We want to obtain all columns/headers for the sales that had the highest total from the <code>Sale.ProductSales</code> table. Which code will achieve the above-mentioned scenario?

It returns matching values between two or more tables in the result set but also returns non-matching values from the primary table.

It returns matching values between two or more tables in the result set and non-matching values in each table.

It returns only matching values between two or more tables in the result set.

It returns the non-matching values from the secondary table.

What is a property of the `INNER JOIN` clause?

What is a property of the <code>INNER JOIN</code> clause?

**(True or False)** The `CAST` and `CONVERT` functions allow us to convert data from one data type to another. Though they both perform the same function, `CONVERT` will enable input parameters to output the result to a different style, whereas `CAST` does not.


(True or False) The <code>CAST</code> and <code>CONVERT</code> functions allow us to convert data from one data type to another. Though they both perform the same function, <code>CONVERT</code> will enable input parameters to output the result to a different style, whereas <code>CAST</code> does not.

SQL Server has a function where we can specify how many rows we’d like returned, whether a number or percentage. What is that function called?

SQL Server has a function where we can specify how many rows we’d like returned, whether a number or percentage. What is that function called?

**(True or False)** Accidental aliases are written using the `AS` keyword after the column name.

(True or False) Accidental aliases are written using the <code>AS</code> keyword after the column name.

Looking at the query below. What is the correct order of execution?
```SQL
SELECT *
FROM Sales.ProductSales
WHERE UnitPrice = (SELECT MAX(UnitPrice) FROM Sales.ProductSales)
```

Looking at the query below. What is the correct order of execution?
<pre><code class="language-SQL">SELECT *
FROM Sales.ProductSales
WHERE UnitPrice = (SELECT MAX(UnitPrice) FROM Sales.ProductSales)
</code></pre>

Transforming data and functions

Transforming data and functions

Test your knowledge of the database functions.

Introduction

Database Components

Structuring the Database

Data Retrieval

Data Definition

Data Manipulation

Transforming Data and Functions

Database Administration

Conclusion

Appendix

Quiz: Transforming Data and Functions