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: Database Administration

Quiz: Database Administration

Test your knowledge of database administration.

We'll cover the following...

Database Administration

1.

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

A.

Full recovery model

B.

Simple recovery model

C.

Bulk-logged recovery model

D.

Transaction log recovery model

1 / 4

...