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

 **(Select all that apply.)** Which command is _not_ used for data manipulation?

(Select all that apply.) Which command is not used for data manipulation?


```SQL
UPDATE TableName
SET ColumnName1 = 'Value'
```

``` SQL
UPDATE Table_Name

SET 
     ColumnName1 = 'New Value 1' 
     ColumnName2 = 'New Value 2'
WHERE 
     ColumnName1 = 'Old Value' 

```SQL
UPDATE ColumnName1 MODIFY ColumnName1 = 'Value'
```

``` SQL
UPDATE Table_Name

MODIFY 
     ColumnName1 = 'New Value 1' 
     ColumnName2 = 'New Value 2'
WHERE 
     ColumnName1 = 'Old Value' 

**(Select all that apply.)** What is the correct syntax of the `UPDATE` command to change a column in the database?

(Select all that apply.) What is the correct syntax of the <code>UPDATE</code> command to change a column in the database?

What happens when we use the `DELETE` command without the `WHERE` clause?

What happens when we use the <code>DELETE</code> command without the <code>WHERE</code> clause?

```SQL
INSERT INTO Table_Name
(ColumnName1,ColumnName2)
VALUES
('Value1',1), 
('Value2',2),
('Value3',3)
```

```SQL
INSERT INTO Table_Name
(ColumnName1,ColumnName2)
SET 
 ('Value1',1), 
 ('Value2',2),
 ('Value3',3)
```

```SQL
UPDATE TableName
SET
('Value1',1), 
 ('Value2',2),
 ('Value3',3)     
```

Introduction

Database Components

Structuring the Database

Data Retrieval

Data Definition

Data Manipulation

Transforming Data and Functions

Database Administration

Conclusion

Appendix

Quiz: Data Manipulation