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

Suppose, we have a “Products” table with columns containing multiple values in its cells. To overcome this issue, we convert them into separate records, but this causes us to repeat the values in the “ProductID” column, which represents the primary key for the table. Which normal form does the above-mentioned problem disturbs?

Suppose, we have a “Products” table with columns containing multiple values in its cells. To overcome this issue, we convert them into separate records, but this causes us to repeat the values in the “ProductID” column, which represents the primary key for the table. Which normal form does the above-mentioned problem disturbs?

We’ll check if the table contains multiple values in a cell.

We’ll check if the primary key of the table has duplicate values.

We’ll check every column of the table to see if it is dependent on the primary key.

We’ll check if there is no foreign key in the table.

If the transitive dependencies in a database table disturb the third normal form, how can they be detected? 

If the transitive dependencies in a database table disturb the third normal form, how can they be detected?

If we create a column “PersonID” for the “Persons” table, what will be the suitable data type for this column?


If we create a column “PersonID” for the “Persons” table, what will be the suitable data type for this column?

The `DECIMAL` data type can hold a maximum of 38 digits, and `FLOAT` can hold up to 128 digits.

Both `DECIMAL` and `FLOAT` are fixed-precision data types.

It is necessary to provide length when creating a column with the `DECIMAL` data type, whereas in the case of `FLOAT`, the database engine already handles it.

**(Select all that apply.)** What is not true about the `DECIMAL` and `FLOAT` data type?


(Select all that apply.) What is not true about the <code>DECIMAL</code> and <code>FLOAT</code> data type?

**(True or False)** The Boyce-Codd normal form is a stricter version of 3NF, in which records within a table are considered unique. These unique values are based upon a composite key, which we create by combining columns.

(True or False) The Boyce-Codd normal form is a stricter version of 3NF, in which records within a table are considered unique. These unique values are based upon a composite key, which we create by combining columns.

Test your knowledge of database normalization and data types.

Introduction

Database Components

Structuring the Database

Data Retrieval

Data Definition

Data Manipulation

Transforming Data and Functions

Database Administration

Conclusion

Appendix

Quiz: Structuring the Database