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 `DepartmentID` is a constraint name of `PRIMARY KEY`.

The `DepartmentID` cannot store floating point values.

**(Select all that apply.)** Consider the following code. Which statement below is _true_?
```SQL
CREATE TABLE Dept.Department
(
   DepartmentID  INT PRIMARY KEY,
   DepartmentName VARCHAR(30)
)

```

(Select all that apply.) Consider the following code. Which statement below is true?
<pre><code class="language-SQL">CREATE TABLE Dept.Department
(
 DepartmentID INT PRIMARY KEY,
 DepartmentName VARCHAR(30)
)

</code></pre>

``` SQL
CONSTRAINT FKDeptIDJob FOREIGN KEY (DCode) REFERENCES Dept.Department(DID)
```


``` SQL
CONSTRAINT FKDeptIdJob FOREIGN KEY (DId) REFERENCES Dept.Department(DId)
```

```SQL
CONSTRAINT FKDeptIdJob FOREIGN KEY (DId) REFERENCES Dept.Department(DCode)
```

``` SQL
CONSTRAINT FKDeptIdJob FOREIGN KEY (DCode) REFERENCES Dept.Department(DCode)
```

What is the correct syntax for defining a foreign key in a table that has the `DID` column to reference the `DCode` column in the `Dept.Department` table?

What is the correct syntax for defining a foreign key in a table that has the <code>DID</code> column to reference the <code>DCode</code> column in the <code>Dept.Department</code> table?

The `Name` is not a good candidate for `PRIMARY KEY` because it should allow for duplicate values. It may cause problems when two students have the same name.

The `Name` is not a good candidate for `PRIMARY KEY` because it should allow for `NULL` values.

The `PRIMARY KEY` cannot be defined other than the first column of the table.

The `PRIMARY KEY` cannot be defined for VARCHAR data type.

What is the problem with the following DDL statement?
```SQL
CREATE TABLE Class.Student
(
   Id  INT,
   Name VARCHAR(30) PRIMARY KEY
)
```


What is the problem with the following DDL statement?
<pre><code class="language-SQL">CREATE TABLE Class.Student
(
 Id INT,
 Name VARCHAR(30) PRIMARY KEY
)
</code></pre>

```SQL
CREATE VIEW A 
AS 
SELECT Department.DepartmentID
FROM Dept.Department
```

```SQL
CREATE VIEW B 
AS 
SELECT Dept.Department.DepartmentID FROM Dept.Department
```

```SQL
CREATE VIEW C 
AS 
SELECT DepartmentID 
FROM Dept.Department
```

```SQL
CREATE VIEW D 
AS 
SELECT Department.DepartmentID 
FROM Department
```

**(Select all that apply.)** Considering the following code. Which DDL command below is correct?
```SQL
CREATE TABLE Dept.Department
(
   DepartmentID  INT PRIMARY KEY,
   DepartmentName VARCHAR(30)
)
```

(Select all that apply.) Considering the following code. Which DDL command below is correct?
<pre><code class="language-SQL">CREATE TABLE Dept.Department
(
 DepartmentID INT PRIMARY KEY,
 DepartmentName VARCHAR(30)
)
</code></pre>

Introduction

Database Components

Structuring the Database

Data Retrieval

Data Definition

Data Manipulation

Transforming Data and Functions

Database Administration

Conclusion

Appendix

Quiz: Data Definition