| [FreeTutorials.Us] oracle-sql-step-by-step-approach/01-software-installation/attached_files/007-running-scripts-necessary-for-the-course/Create-User.txt |
197 B |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/00-none/001-closed-captionssub-titles-for-the-course.pdf |
233 KB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/00-none/002-welcome.mp4 |
11.4 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/00-none/003-how-to-make-best-use-of-the-program.pdf |
204 KB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/01-software-installation/004-installing-oracle.mp4 |
11.2 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/01-software-installation/005-installing-java-sdk.mp4 |
7 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/01-software-installation/006-installing-sql-developer.mp4 |
10.1 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/01-software-installation/007-running-scripts-necessary-for-the-course.mp4 |
9.4 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/01-software-installation/008-scripts-for-our-lab-exercises.pdf |
166 KB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/02-database-concepts/009-what-is-a-table.mp4 |
5.9 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/02-database-concepts/010-what-is-a-database.mp4 |
7.9 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/02-database-concepts/011-what-is-a-relational-database-rdbms.mp4 |
3.6 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/02-database-concepts/012-what-is-a-transaction.mp4 |
5 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/02-database-concepts/013-what-is-acid.mp4 |
5 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/02-database-concepts/014-rdbms-vendors.mp4 |
2.3 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/03-enter-the-dragon-database/015-building-sql-template....html |
426 B |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/03-enter-the-dragon-database/016-how-do-you-talk-with-a-database.mp4 |
3.3 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/03-enter-the-dragon-database/017-what-are-the-most-common-commands.mp4 |
2.2 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/03-enter-the-dragon-database/018-what-type-of-data-can-we-store.mp4 |
6.4 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/03-enter-the-dragon-database/019-data-model-for-our-course.mp4 |
3.9 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/04-lets-see-the-data/020-what-data-can-i-see.mp4 |
10.8 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/04-lets-see-the-data/021-how-do-i-see-data-select.mp4 |
5.3 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/04-lets-see-the-data/022-how-do-i-see-a-part-of-the-data-select.mp4 |
5.7 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/04-lets-see-the-data/023-lab-1-exercises-with-answers.pdf |
276 KB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/05-lets-limit-the-data-we-see-filtering/024-filtering-data-where-command.mp4 |
5.8 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/05-lets-limit-the-data-we-see-filtering/025-comparison-operators.mp4 |
2.1 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/05-lets-limit-the-data-we-see-filtering/026-filtering-data-more-examples....mp4 |
6.7 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/05-lets-limit-the-data-we-see-filtering/027-filters-on-character-and-date-values....mp4 |
9.1 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/05-lets-limit-the-data-we-see-filtering/028-filtering-based-on-a-column-in-a-table....mp4 |
7.8 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/05-lets-limit-the-data-we-see-filtering/029-lab-2-exercises-with-answers.pdf |
277 KB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/06-logical-operators/030-between-and-not-between.mp4 |
4.5 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/06-logical-operators/031-in-and-not-in.mp4 |
4.9 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/06-logical-operators/032-like-operator.mp4 |
13.7 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/06-logical-operators/033-all-and-any.mp4 |
5.9 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/06-logical-operators/034-lets-learn-about-null....mp4 |
3.8 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/06-logical-operators/035-is-null-and-is-not-null.mp4 |
5.7 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/06-logical-operators/036-and-and-or.mp4 |
9.8 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/06-logical-operators/037-lab-3-exercises-with-answers.pdf |
283 KB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/07-arithmetic-operators/038-they-are-simple-10-20-30.mp4 |
5.7 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/07-arithmetic-operators/039-lab-4-exercises-with-answers.pdf |
206 KB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/08-lets-sort-the-data-we-see-sorting/040-order-by-clause.mp4 |
8.4 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/08-lets-sort-the-data-we-see-sorting/041-how-are-null-values-treated-while-sorting-data.mp4 |
4.3 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/08-lets-sort-the-data-we-see-sorting/042-lab-5-exercises-with-answers.pdf |
271 KB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/09-how-do-we-combine-data-from-2-tables/043-set-operators.mp4 |
4.6 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/09-how-do-we-combine-data-from-2-tables/044-union-operator.mp4 |
7.5 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/09-how-do-we-combine-data-from-2-tables/045-union-all-operator.mp4 |
2.7 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/09-how-do-we-combine-data-from-2-tables/046-intersect-operator.mp4 |
3.5 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/09-how-do-we-combine-data-from-2-tables/047-minus-operator.mp4 |
3.6 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/09-how-do-we-combine-data-from-2-tables/048-lab-6-exercises-with-answers.pdf |
274 KB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/10-lets-group-the-data/049-aggregatesummary-functions.mp4 |
10.3 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/10-lets-group-the-data/050-group-by-clause.mp4 |
8.1 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/10-lets-group-the-data/051-group-by-with-multiple-columns.mp4 |
13.6 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/10-lets-group-the-data/052-group-by-with-having-clause.mp4 |
8.3 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/10-lets-group-the-data/053-lab-7-exercises-with-answers.pdf |
292 KB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/11-joining-data-from-2-or-more-tables-joins/054-why-joins.mp4 |
15.4 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/11-joining-data-from-2-or-more-tables-joins/055-inner-join.mp4 |
11.3 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/11-joining-data-from-2-or-more-tables-joins/056-left-outer-join.mp4 |
6 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/11-joining-data-from-2-or-more-tables-joins/057-right-outer-join.mp4 |
5.7 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/11-joining-data-from-2-or-more-tables-joins/058-full-outer-join.mp4 |
4.9 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/11-joining-data-from-2-or-more-tables-joins/059-cross-join.mp4 |
6.7 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/11-joining-data-from-2-or-more-tables-joins/060-natural-join.mp4 |
5.4 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/11-joining-data-from-2-or-more-tables-joins/061-joining-the-3rd-table.mp4 |
3.6 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/11-joining-data-from-2-or-more-tables-joins/062-joining-the-4th-table-and-so-on....mp4 |
2.7 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/11-joining-data-from-2-or-more-tables-joins/063-adding-filters-to-joins.mp4 |
13.4 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/11-joining-data-from-2-or-more-tables-joins/064-lab-8-exercises-with-answers.pdf |
273 KB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/12-functions-available-for-us-to-use/065-dual-what-is-this.mp4 |
4.1 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/12-functions-available-for-us-to-use/066-why-do-we-need-functions.mp4 |
2.5 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/12-functions-available-for-us-to-use/067-number-related-functions.mp4 |
11.6 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/12-functions-available-for-us-to-use/068-character-related-functions.mp4 |
7.7 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/12-functions-available-for-us-to-use/069-date-related-functions.mp4 |
10.5 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/12-functions-available-for-us-to-use/070-lab-9-exercises-with-answers.pdf |
281 KB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/13-interesting-things/071-if-then-else-case-statement.mp4 |
8.1 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/13-interesting-things/072-alternative-name-alias-name.mp4 |
11.4 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/13-interesting-things/073-distinct-values.mp4 |
7.9 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/13-interesting-things/074-pseudo-columns.mp4 |
8.7 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/14-data-definition-language-ddl/075-lets-create-a-table-create.mp4 |
4.9 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/14-data-definition-language-ddl/076-lets-change-the-structure-of-a-table-alter.mp4 |
10.3 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/14-data-definition-language-ddl/077-lets-delete-the-table-drop.mp4 |
1.9 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/14-data-definition-language-ddl/078-create-table-as-ctas.mp4 |
6.1 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/14-data-definition-language-ddl/079-lab-11-exercises-with-answers.pdf |
374 KB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/15-data-manipulation-language-dml/080-commit-and-rollback.mp4 |
1.6 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/15-data-manipulation-language-dml/081-insert-data-into-a-table-insert.mp4 |
10.9 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/15-data-manipulation-language-dml/082-delete-data-from-a-table-delete.mp4 |
8.1 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/15-data-manipulation-language-dml/083-modify-existing-data-in-a-table-update.mp4 |
7.4 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/15-data-manipulation-language-dml/084-delete-all-the-data-from-a-table-truncate.mp4 |
6 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/15-data-manipulation-language-dml/085-lab-12-exercises-with-answers.pdf |
291 KB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/16-lets-put-some-restrictions-on-a-table-constraints/086-why-constraints.mp4 |
2 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/16-lets-put-some-restrictions-on-a-table-constraints/087-no-empty-data-allowed-not-null.mp4 |
7.5 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/16-lets-put-some-restrictions-on-a-table-constraints/088-no-duplicate-data-unique.mp4 |
6.8 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/16-lets-put-some-restrictions-on-a-table-constraints/089-what-is-not-null-unique-primary-key.mp4 |
7.7 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/16-lets-put-some-restrictions-on-a-table-constraints/090-accept-only-few-values-check.mp4 |
7.7 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/16-lets-put-some-restrictions-on-a-table-constraints/091-check-data-in-other-table-before-insertingdeleting-foreign-key.mp4 |
11.9 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/16-lets-put-some-restrictions-on-a-table-constraints/092-constraints-on-multiple-columns.mp4 |
6 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/16-lets-put-some-restrictions-on-a-table-constraints/093-adding-constraints-to-an-existing-table.mp4 |
3.3 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/16-lets-put-some-restrictions-on-a-table-constraints/094-more-operations-on-constraints....mp4 |
4.4 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/16-lets-put-some-restrictions-on-a-table-constraints/095-lab-13-exercises-with-answers.pdf |
306 KB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/17-views/096-why-views.mp4 |
12.2 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/17-views/097-lets-modify-an-existing-view.mp4 |
4.6 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/17-views/098-lets-update-view-data.mp4 |
6.4 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/17-views/099-create-view-from-more-than-1-table.mp4 |
14.7 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/17-views/100-lab-14-exercises-with-answers.pdf |
361 KB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/18-other-database-objects/101-alternative-name-for-objects-synonyms.mp4 |
5.5 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/18-other-database-objects/102-series-of-numbers-sequence.mp4 |
7.3 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/19-giving-permissions-to-other-users-grant/103-i-like-him-grant.mp4 |
12.6 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/19-giving-permissions-to-other-users-grant/104-i-dont-like-him-revoke.mp4 |
9.2 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/19-giving-permissions-to-other-users-grant/105-list-of-all-grants.pdf |
195 KB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/20-sub-queries/106-what-is-a-sub-query.mp4 |
16.6 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/20-sub-queries/107-sub-queries-on-multiple-columns-pairwise-comparision.mp4 |
13.2 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/20-sub-queries/108-sub-queries-on-multiple-columns-nonpairwise-comparision.mp4 |
5.9 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/20-sub-queries/109-sub-queries-in-the-from-clause.mp4 |
15.1 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/20-sub-queries/110-sub-queries-in-the-with-clause.mp4 |
2.8 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/20-sub-queries/111-scalar-sub-queries.mp4 |
4.5 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/20-sub-queries/112-correlated-sub-query.mp4 |
22.2 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/21-advanced-topics-index/113-book-index.mp4 |
4.3 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/21-advanced-topics-index/114-lets-create-an-index....mp4 |
8.3 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/21-advanced-topics-index/115-unique-index.mp4 |
5.3 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/21-advanced-topics-index/116-dropping-and-renaming-an-index.mp4 |
3.6 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/22-bonus-lets-recap-with-a-5-step-process/117-scripts-for-this-section.pdf |
204 KB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/22-bonus-lets-recap-with-a-5-step-process/118-business-requirement.mp4 |
11.7 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/22-bonus-lets-recap-with-a-5-step-process/119-step-1-lets-select-all-the-columns-needed....mp4 |
28.8 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/22-bonus-lets-recap-with-a-5-step-process/120-step-2-lets-add-the-necessary-filters....mp4 |
4.6 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/22-bonus-lets-recap-with-a-5-step-process/121-step-3-lets-perform-the-grouping....mp4 |
10.2 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/22-bonus-lets-recap-with-a-5-step-process/122-step-4-lets-perform-filtering-at-group-level....mp4 |
5.4 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/22-bonus-lets-recap-with-a-5-step-process/123-step-5-lets-sort-the-data....mp4 |
4.7 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/22-bonus-lets-recap-with-a-5-step-process/124-recap-the-10-things-we-have-done....mp4 |
6.6 MB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/23-where-to-go-from-here/125-project-work.pdf |
212 KB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/23-where-to-go-from-here/126-advanced-database-concepts-you-can-explore.pdf |
205 KB |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/[FreeCoursesOnline.Us].txt |
138 B |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/FreeCoursesOnline.Us.url |
225 B |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/[FreeTutorials.Us].txt |
75 B |
| [FreeTutorials.Us] oracle-sql-step-by-step-approach/Freetutorials.Us.url |
119 B |
Magnet link
