FreeTutorials Us oracle-sql-step-by-step-approach

1. 00-none/002-welcome.mp411.36MB
2. 01-software-installation/004-installing-oracle.mp411.23MB
3. 01-software-installation/005-installing-java-sdk.mp47.04MB
4. 01-software-installation/006-installing-sql-developer.mp410.05MB
5. 01-software-installation/007-running-scripts-necessary-for-the-course.mp49.4MB
6. 02-database-concepts/009-what-is-a-table.mp45.92MB
7. 02-database-concepts/010-what-is-a-database.mp47.92MB
8. 02-database-concepts/011-what-is-a-relational-database-rdbms.mp43.63MB
9. 02-database-concepts/012-what-is-a-transaction.mp44.97MB
10. 02-database-concepts/013-what-is-acid.mp44.95MB
11. 02-database-concepts/014-rdbms-vendors.mp42.35MB
12. 03-enter-the-dragon-database/016-how-do-you-talk-with-a-database.mp43.28MB
13. 03-enter-the-dragon-database/017-what-are-the-most-common-commands.mp42.21MB
14. 03-enter-the-dragon-database/018-what-type-of-data-can-we-store.mp46.38MB
15. 03-enter-the-dragon-database/019-data-model-for-our-course.mp43.9MB
16. 04-lets-see-the-data/020-what-data-can-i-see.mp410.76MB
17. 04-lets-see-the-data/021-how-do-i-see-data-select.mp45.3MB
18. 04-lets-see-the-data/022-how-do-i-see-a-part-of-the-data-select.mp45.7MB
19. 05-lets-limit-the-data-we-see-filtering/024-filtering-data-where-command.mp45.78MB
20. 05-lets-limit-the-data-we-see-filtering/025-comparison-operators.mp42.1MB
21. 05-lets-limit-the-data-we-see-filtering/026-filtering-data-more-examples....mp46.74MB
22. 05-lets-limit-the-data-we-see-filtering/027-filters-on-character-and-date-values....mp49.11MB
23. 05-lets-limit-the-data-we-see-filtering/028-filtering-based-on-a-column-in-a-table....mp47.81MB
24. 06-logical-operators/030-between-and-not-between.mp44.54MB
25. 06-logical-operators/031-in-and-not-in.mp44.86MB
26. 06-logical-operators/032-like-operator.mp413.68MB
27. 06-logical-operators/033-all-and-any.mp45.93MB
28. 06-logical-operators/034-lets-learn-about-null....mp43.78MB
29. 06-logical-operators/035-is-null-and-is-not-null.mp45.7MB
30. 06-logical-operators/036-and-and-or.mp49.78MB
31. 07-arithmetic-operators/038-they-are-simple-10-20-30.mp45.72MB
32. 08-lets-sort-the-data-we-see-sorting/040-order-by-clause.mp48.43MB
33. 08-lets-sort-the-data-we-see-sorting/041-how-are-null-values-treated-while-sorting-data.mp44.29MB
34. 09-how-do-we-combine-data-from-2-tables/043-set-operators.mp44.61MB
35. 09-how-do-we-combine-data-from-2-tables/044-union-operator.mp47.5MB
36. 09-how-do-we-combine-data-from-2-tables/045-union-all-operator.mp42.67MB
37. 09-how-do-we-combine-data-from-2-tables/046-intersect-operator.mp43.5MB
38. 09-how-do-we-combine-data-from-2-tables/047-minus-operator.mp43.62MB
39. 10-lets-group-the-data/049-aggregatesummary-functions.mp410.34MB
40. 10-lets-group-the-data/050-group-by-clause.mp48.08MB
41. 10-lets-group-the-data/051-group-by-with-multiple-columns.mp413.62MB
42. 10-lets-group-the-data/052-group-by-with-having-clause.mp48.35MB
43. 11-joining-data-from-2-or-more-tables-joins/054-why-joins.mp415.37MB
44. 11-joining-data-from-2-or-more-tables-joins/055-inner-join.mp411.27MB
45. 11-joining-data-from-2-or-more-tables-joins/056-left-outer-join.mp45.98MB
46. 11-joining-data-from-2-or-more-tables-joins/057-right-outer-join.mp45.72MB
47. 11-joining-data-from-2-or-more-tables-joins/058-full-outer-join.mp44.95MB
48. 11-joining-data-from-2-or-more-tables-joins/059-cross-join.mp46.65MB
49. 11-joining-data-from-2-or-more-tables-joins/060-natural-join.mp45.42MB
50. 11-joining-data-from-2-or-more-tables-joins/061-joining-the-3rd-table.mp43.58MB
51. 11-joining-data-from-2-or-more-tables-joins/062-joining-the-4th-table-and-so-on....mp42.73MB
52. 11-joining-data-from-2-or-more-tables-joins/063-adding-filters-to-joins.mp413.37MB
53. 12-functions-available-for-us-to-use/065-dual-what-is-this.mp44.08MB
54. 12-functions-available-for-us-to-use/066-why-do-we-need-functions.mp42.48MB
55. 12-functions-available-for-us-to-use/067-number-related-functions.mp411.62MB
56. 12-functions-available-for-us-to-use/068-character-related-functions.mp47.66MB
57. 12-functions-available-for-us-to-use/069-date-related-functions.mp410.46MB
58. 13-interesting-things/071-if-then-else-case-statement.mp48.1MB
59. 13-interesting-things/072-alternative-name-alias-name.mp411.44MB
60. 13-interesting-things/073-distinct-values.mp47.89MB
61. 13-interesting-things/074-pseudo-columns.mp48.66MB
62. 14-data-definition-language-ddl/075-lets-create-a-table-create.mp44.91MB
63. 14-data-definition-language-ddl/076-lets-change-the-structure-of-a-table-alter.mp410.32MB
64. 14-data-definition-language-ddl/077-lets-delete-the-table-drop.mp41.91MB
65. 14-data-definition-language-ddl/078-create-table-as-ctas.mp46.13MB
66. 15-data-manipulation-language-dml/080-commit-and-rollback.mp41.56MB
67. 15-data-manipulation-language-dml/081-insert-data-into-a-table-insert.mp410.93MB
68. 15-data-manipulation-language-dml/082-delete-data-from-a-table-delete.mp48.07MB
69. 15-data-manipulation-language-dml/083-modify-existing-data-in-a-table-update.mp47.41MB
70. 15-data-manipulation-language-dml/084-delete-all-the-data-from-a-table-truncate.mp46.01MB
71. 16-lets-put-some-restrictions-on-a-table-constraints/086-why-constraints.mp42.03MB
72. 16-lets-put-some-restrictions-on-a-table-constraints/087-no-empty-data-allowed-not-null.mp47.5MB
73. 16-lets-put-some-restrictions-on-a-table-constraints/088-no-duplicate-data-unique.mp46.8MB
74. 16-lets-put-some-restrictions-on-a-table-constraints/089-what-is-not-null-unique-primary-key.mp47.74MB
75. 16-lets-put-some-restrictions-on-a-table-constraints/090-accept-only-few-values-check.mp47.7MB
76. 16-lets-put-some-restrictions-on-a-table-constraints/091-check-data-in-other-table-before-insertingdeleting-foreign-key.mp411.91MB
77. 16-lets-put-some-restrictions-on-a-table-constraints/092-constraints-on-multiple-columns.mp46.02MB
78. 16-lets-put-some-restrictions-on-a-table-constraints/093-adding-constraints-to-an-existing-table.mp43.26MB
79. 16-lets-put-some-restrictions-on-a-table-constraints/094-more-operations-on-constraints....mp44.4MB
80. 17-views/096-why-views.mp412.24MB
81. 17-views/097-lets-modify-an-existing-view.mp44.61MB
82. 17-views/098-lets-update-view-data.mp46.43MB
83. 17-views/099-create-view-from-more-than-1-table.mp414.73MB
84. 18-other-database-objects/101-alternative-name-for-objects-synonyms.mp45.5MB
85. 18-other-database-objects/102-series-of-numbers-sequence.mp47.32MB
86. 19-giving-permissions-to-other-users-grant/103-i-like-him-grant.mp412.56MB
87. 19-giving-permissions-to-other-users-grant/104-i-dont-like-him-revoke.mp49.18MB
88. 20-sub-queries/106-what-is-a-sub-query.mp416.58MB
89. 20-sub-queries/107-sub-queries-on-multiple-columns-pairwise-comparision.mp413.24MB
90. 20-sub-queries/108-sub-queries-on-multiple-columns-nonpairwise-comparision.mp45.9MB
91. 20-sub-queries/109-sub-queries-in-the-from-clause.mp415.06MB
92. 20-sub-queries/110-sub-queries-in-the-with-clause.mp42.76MB
93. 20-sub-queries/111-scalar-sub-queries.mp44.47MB
94. 20-sub-queries/112-correlated-sub-query.mp422.18MB
95. 21-advanced-topics-index/113-book-index.mp44.31MB
96. 21-advanced-topics-index/114-lets-create-an-index....mp48.33MB
97. 21-advanced-topics-index/115-unique-index.mp45.31MB
98. 21-advanced-topics-index/116-dropping-and-renaming-an-index.mp43.59MB
99. 22-bonus-lets-recap-with-a-5-step-process/118-business-requirement.mp411.68MB
100. 22-bonus-lets-recap-with-a-5-step-process/119-step-1-lets-select-all-the-columns-needed....mp428.81MB
101. 22-bonus-lets-recap-with-a-5-step-process/120-step-2-lets-add-the-necessary-filters....mp44.61MB
102. 22-bonus-lets-recap-with-a-5-step-process/121-step-3-lets-perform-the-grouping....mp410.23MB
103. 22-bonus-lets-recap-with-a-5-step-process/122-step-4-lets-perform-filtering-at-group-level....mp45.37MB
104. 22-bonus-lets-recap-with-a-5-step-process/123-step-5-lets-sort-the-data....mp44.66MB
105. 22-bonus-lets-recap-with-a-5-step-process/124-recap-the-10-things-we-have-done....mp46.59MB