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 table consists of rows as entries and columns as headers.

A schema is a header within a table defined by a data type.

A row may have NULL values in one or more cells.

The cell is where the data is shown, such as someone’s actual first and last names.

**(Select all that apply.)** Which statement is _true_ about the components of the database?


(Select all that apply.) Which statement is true about the components of the database?

The primary key may allow repeated values.

The unique constraint may allow NULL values.

The indexed column may allow repeated values.

**(Select all that apply.)** Which statement is _true_ about the constraints?

(Select all that apply.) Which statement is true about the constraints?

A view may comprise two columns from one table and three columns from another table.

A view may hide the raw elements of the database from the end user.

The original code used to create the view recompiles when a user queries that view.

A view may not consist of only one table.


**(Select all that apply)** Which statement is true about views?

(Select all that apply) Which statement is true about views?

A stored procedure is precompiled SQL syntax, but a trigger is not.

A trigger is specified to add a new table, index, or constraint.

A trigger is specified for `INSERT`, `DELETE`, or `UPDATE` statements.

A trigger is a precompiled SQL syntax that can be reused by its name.

**(Select all that apply)** Which statement is true about the stored procedures and triggers?


(Select all that apply) Which statement is true about the stored procedures and triggers?

“RollNum” as a primary key in the “Student” table.

“RollNum” as a foreign key in the “Student” table.

“RollNum” as a foreign key in the “Registration” table.

“Code” as a primary key in the “Course” table.

“Code”as a foreign key in the “Course” table.

The “Name” column has a `NOT NULL` constraint in the “Student” table.

Let’s say in our database, we have:
- A “Student” table with the columns “RollNum” and “Name.”
- A “Course” table with the columns “Code” and “Title.” `Title`
- A “Registration” table with the columns “RollNum” and “Code.”



**(Select all that apply)**  Which constraint should be defined in our database?

Let’s say in our database, we have:
<ul>
<li>A “Student” table with the columns “RollNum” and “Name.”</li>
<li>A “Course” table with the columns “Code” and “Title.” <code>Title</code></li>
<li>A “Registration” table with the columns “RollNum” and “Code.”</li>
</ul>
(Select all that apply) Which constraint should be defined in our database?

Database Components

Database Components

Test your understanding of database components.

Introduction

Database Components

Structuring the Database

Data Retrieval

Data Definition

Data Manipulation

Transforming Data and Functions

Database Administration

Conclusion

Appendix

Quiz: Database Components