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

It extracts records that are not common between `FirstTable` and `SecondTable`.

It extracts the matching records between `FirstTable` and `SecondTable`.


It extracts all the records from the top three rows.

Consider the following syntax. How does the INNER JOIN clause work?

```SQL
SELECT DISTINCT TOP ColumnName,
       MAX(Column_Name)
FROM FirstTable
       INNER JOIN SecondTable
          ON First_Table.ColumnName = Second_Table.Column_Name
WHERE Condition
GROUP BY ColumnName
ORDER BY ColumnName ASC/DESC

Consider the following syntax. How does the INNER JOIN clause work?
<pre><code class="language-SQL">SELECT DISTINCT TOP ColumnName,
 MAX(Column_Name)
FROM FirstTable
 INNER JOIN SecondTable
 ON First_Table.ColumnName = Second_Table.Column_Name
WHERE Condition
GROUP BY ColumnName
ORDER BY ColumnName ASC/DESC</code></pre>

Indents and line breaks help the database engine to process the code efficiently.

Comments help in understanding the SQL statements.

Database engines process the code from left to right without caring if the code is in uppercase or lowercase.


Which statement is not true about the syntax of SQL statements?

Which statement is not true about the syntax of SQL statements?

The clause searches for the string which is equal to Value.


The clause finds the field where the string `Value` is at the end of the field.

The clause finds the field where the string `Value` is at the start of the field.

The clause finds the field where the string `Value` is in the middle of the field.

Consider the following code. What is the output?
```SQL
SELECT Column_Name1, Column_Name2
FROM Table_Name
WHERE Column_Name3 LIKE '%Value'
```

Consider the following code. What is the output?
<pre><code class="language-SQL">SELECT Column_Name1, Column_Name2
FROM Table_Name
WHERE Column_Name3 LIKE '%Value'
</code></pre>

```SQL
SELECT 
    ProductID,
    ProductNumber,
    Color
FROM Products
```


```SQL
SELECT
    ProductID,
    ProductNumber,
FROM Products
WHERE Color = 'Black'
```

```SQL
SELECT 
	ProductID,
    ProductNumber,
    Color
FROM Products
WHERE Color = 'Black'
```

Which code is used to extract the “ProductID” and “ProductNumber” from the “Products” table where the color is “Black?”


Which code is used to extract the “ProductID” and “ProductNumber” from the “Products” table where the color is “Black?”

Introduction

Database Components

Structuring the Database

Data Retrieval

Data Definition

Data Manipulation

Transforming Data and Functions

Database Administration

Conclusion

Appendix

Quiz: Data Retrieval