CourseChapTopicID | CourseChapTopicName | |
18 | Module 1: Understanding Core Database Concepts |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
308 | 18 | Understand how data is stored in tables |
Learn
| | |
309 | 18 | Understand relational database concepts |
Learn
| | |
310 | 18 | Understand data manipulation language (DML) . |
Learn
| | |
311 | 18 | Understand data defi nition language (DDL) . |
Learn
| | |
|
19 | Module2: Creating Database Objects |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
312 | 19 | Choose data types . |
Learn
| | |
313 | 19 | Understand tables and how to create them |
Learn
| | |
314 | 19 | Create views using T-SQL |
Learn
| | |
315 | 19 | Create views using a graphical designer |
Learn
| | |
316 | 19 | Create stored procedures and functions |
Learn
| | |
|
20 | Module 3: Manipulating Data |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
317 | 20 | Select data utilizing SELECT with simple queries |
Learn
| | |
318 | 20 | Select data utilizing SELECT with complex queries . |
Learn
| | |
319 | 20 | Insert data . |
Learn
| | |
320 | 20 | Update data |
Learn
| | |
321 | 20 | Delete data |
Learn
| | |
|
21 | Module 4: Understanding Data Storage |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
322 | 21 | Understand normalization |
Learn
| | |
323 | 21 | Understand primary, foreign, and composite keys |
Learn
| | |
324 | 21 | Understand index |
Learn
| | |
|
22 | Module 5: Administering a Database |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
325 | 22 | Understand database security concepts |
Learn
| | |
326 | 22 | Understand database backup and restore |
Learn
| | |
|
23 | Module 6: Database Concepts Review |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
327 | 23 | Database administration fundamentals review |
Learn
| | |
|