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

Which recovery model has the attribute of recycling the transaction log?

Which recovery model has the attribute of recycling the transaction log?

The backup is not affected by the size of the data.

A transaction log backs up all the activity that has happened in the database.

Some transaction logs are initially larger but can become smaller as more frequent backups are taken

Which statement is _not_ true about backup?

Which statement is not true about backup?

It can add or remove linked servers using SQL commands.

It provides the ability to end processes running in an SQL Server instance.


It can perform any action on the server. It’s essentially the highest level of access.


What is a property of a db_securityadmin?

What is a property of a db_securityadmin?

```SQL
ALTER SERVER ROLE serveradmin ADD MEMBER [Server User]
```

```SQL
ALTER SERVER ROLE serveradmin ADD MEMBER Server User
```

```SQL
UPDATE SERVER ROLE serveradmin CREATE MEMBER [Server User]
```

```SQL
ADD SERVER ROLE serveradmin CREATE MEMBER [Server User]

Which statement is used to assign the `serveradmin` role to the `Server User`?

Which statement is used to assign the <code>serveradmin</code> role to the <code>Server User</code>?

Database Administration

Database Administration

Test your knowledge of database administration.

Introduction

Database Components

Structuring the Database

Data Retrieval

Data Definition

Data Manipulation

Transforming Data and Functions

Database Administration

Conclusion

Appendix

Quiz: Database Administration