Mastering DB2 Data Manipulation : DB2 Database, Data Studio

سرفصل های دوره

Perform CRUD Operations, Data Handling, Data Operations, Data Functions on DB2 Databases using IBM Data Studio

1. Overview of DB2

1. Introduction.html

2. Introduction to DB2 and its editions.html

3. DB2 architecture and components.html

4. Installation and setup of DB2 environment ( Text Version).html

5. Install DB2 Database Server

2. Introduction to SQL

1. Basics of SQL.html

2. Data types in DB2.html

3. Schema, tables, and views.html

3. Performing CRUD Operations and Data Manipulation

1. Overview of CRUD Operations.html

2. What is ERD

3. Multiple Table Relationships

4. Creating a new database and table

5. Installing IBM Data Studio Client

6. Launching IBM Data Studio Client

7. Creating multiple tables using SQL Scripts

8. Manually Inserting Records into Database Table

9. Inserting Multiple Records using SQL Script File

10. SELECT Statement

11. Updating Records

12. Deleting records

13. LIMIT Clause

14. LIKE Operator

15. Truncating Tables

16. Dropping Tables

Files.zip

4. Sorting and Filtering Data

1. Filtering data with WHERE clause

2. Sorting results with ORDER BY

3. Using DISTINCT to eliminate duplicates

5. Aggregation and Grouping

1. Aggregate Functions

2. GROUP BY Clause.html

3. HAVING Clause.html

6. Joins and Subqueries

1. INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN.html

2. Self-joins.html

3. Subqueries and nested queries.html

4. Correlated subqueries.html

7. Set Operations

1. What are Set Operations.html

2. UNION, UNION ALL.html

3. INTERSECT.html

4. EXCEPT.html

8. Best Practices in Data Manipulation

1. Data integrity and validation.html

2. Using constraints and referential integrity.html

3. Backup and recovery strategies.html

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy