Database Fundamentals |
|---|
| Course Outline |
|
| Introduction |
Intro.pptx
|
| Day | Modules | Sharing |
|---|
| 1 |
- Understand how data is stored in tables
- Understand relational database concepts
- Understand data manipulation language (DML)
- Understand data definition language (DDL)
|
|
- Choose data types
- Understand tables and how to create them
- Create views
- Create stored procedures and functions
|
|
| 2 |
- Select data
- Insert data
- Update data
- Delete data
|
|
| 3 |
- Understand normalization
- Understand primary, foreign, and composite keys
- Understand indexes
|
|
- Understand database security concepts
- Understand database backups and restore
|
|
| Recommanded Books |
|---|
 | Title | SQL in a Nutshell: A Desktop Quick Reference |
|---|
| ISBN | 978-1-492-08886-8 |
|---|
| Author | Kevin Kline, Regina O. Obe, Leo S. Hsu |
|---|
| Year | 2022 |
|---|
| Publisher | O'Reilly Media |
|---|
 | Title | Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with Data |
|---|
| ISBN | 978-1-718-50106-5 |
|---|
| Author | Anthony DeBarros |
|---|
| Year | 2022 |
|---|
| Publisher | No Starch Press |
|---|
 | Title | SQL for Beginners: Learn Sql Programming Very Easy |
|---|
| ISBN | |
|---|
| Author | new boo |
|---|
| Year | 2022 |
|---|
| Publisher | |
|---|
 | Title | Beginning T-SQL: A Step-by-Step Approach |
|---|
| ISBN | 978-1-484-26605-2 |
|---|
| Author | Kathi Kellenberger, Lee Everest |
|---|
| Year | 2021 |
|---|
| Publisher | Apress |
|---|
 | Title | Pro SQL Server Relational Database Design and Implementation: Best Practices for Scalability and Performance |
|---|
| ISBN | 978-1-484-26496-6 |
|---|
| Author | Louis Davidson |
|---|
| Year | 2021 |
|---|
| Publisher | Apress |
|---|
 | Title | Learning SQL: Master SQL Fundamentals |
|---|
| ISBN | 978-1-492-05761-1 |
|---|
| Author | Alan Beaulieu |
|---|
| Year | 2020 |
|---|
| Publisher | O’Reilly Media |
|---|
 | Title | Microsoft SQL Server 2019: A Beginner’s Guide |
|---|
| ISBN | 978-1-260-45887-9 |
|---|
| Author | Dusan Petkovic |
|---|
| Year | 2020 |
|---|
| Publisher | McGraw-Hill Education |
|---|