0% completed

All LessonsFree Lessons (4)

Introduction

Course Roadmap Importance of Databases and SQL

Database Components

Tables, Schemas, Columns, and Keys Constraints and Views Stored Procedures and Triggers Quiz: Database Components

Structuring the Database

Introducing Database Normalization Advancing Database Normalization SQL Data Types Quiz: Structuring the Database

Data Retrieval

Query Execution Process Guidelines for Writing Query Basic Query Syntax Learn Data Retrieval Through Practice Quiz: Data Retrieval

Data Definition

Data Definition Language (DDL)Learn DDL Through Practice Running the DDL Script Quiz: Data Definition

Data Manipulation

Data Manipulation Language (DML)

Learn DML Through Practice

Running the DML Script

Quiz: Data Manipulation

Transforming Data and Functions

Aggregates and Joins Learn Aggregates and Joins Through Practice Data Presentation Learn Data Presentation Through Practice Data Transformation Learn Data Transformation Through Practice Quiz: Transforming Data and Functions

Database Administration

Backup, Recovery, and Database Restore Learn Backup, Recovery, and Restore Through Practice Login, Users, and Roles Learn Server Logins, Users, and Roles Through Practice Quiz: Database Administration

Conclusion

Appendix

Downloading and Installing SQL Server Express Download SQL Server Management Studio (SSMS)The Basics of SSMS and Its Features Attaching AdventureWorks database

A Practical Guide to SQL and Database Fundamentals/

...

/

Quiz: Data Manipulation

Quiz: Data Manipulation

Test your knowledge of DML commands.

We'll cover the following...

Data Manipulation

1.

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

A.

UPDATE

B.

DELETE

C.

CREATE

D.

ALTER

1 / 4