wingfox|Database Modeling Management and Tuning

Database Modeling Management and Tuning

Category:

IT&Software

Lecturer:

Abdelrahman Tarek

Lessons:

30/3h (Finish)

Replay

Preview this course

918

English

$39.00 $99.00 61 %off

$37.05

Buy Now

Add to cart

This course includes:

3 hours video

1 downloadable resource

Lifetime Access

Beginner

Database Modeling Management and Tuning

$39.00 $99.00 61%off

Plus's Price $37.05

Add to cart

Buy Now

Database Modeling Management and Tuning

918

English

Category:

IT&Software

Lecturer:

Abdelrahman Tarek

Lessons:

30/3h (Finish)

This course includes:

30 Lessons (Finish)

6. Summary on Chapter One (1m 14s)

7. Create tables and their columns (6m 57s)

8. Delete tables and their columns (3m 48s)

9. Add a new column to an existing table & Using Keywords (4m 24s)

10. Foreign Key Constraint (4m 42s)

11. Practice Section (8m 3s)

20. Summary on task four (2m 8s)

21. Data Validation by Key words Order by , Count & Joins (12m 32s)

22. Data Validation by Functions DISTINCT, Lower , Upper & Length (7m 20s)

23. Data validation by key words group by, IN & NOT IN and representing the duplicates (14m 36s)

24. Practice Section (9m 46s)

25. Summary on task five (1m 34s)

26. Execute and Plan Times of Queries using Explain & Explain Analyze Statements (20m 24s)

27. Apply Index to Improve Performance (7m 10s)

28. Create Summary Tables After Applying some Aggregate Functions on data (13m 21s)

29. Practice Section (10m 11s)

30. Summary on the project (3m 27s)

You must be purchased to post a comment. Buy Now !

we will constantly update the project files

Please download resources on PC

Project files

(397.06KB)

Lecturer

Abdelrahman Tarek

Please select the mode you want

Single

3 people

$x3

$39.00

$37.05

Add to cart

Buy Now