[FreeCourseSite com] Udemy - Oracle SQL – Step by Step SQL
File List
| File | Size |
|---|---|
| 00-none/001-closed-captionssub-titles-for-the-course.pdf | 233.34 KB |
| 00-none/002-welcome.mp4 | 11.36 MB |
| 00-none/003-how-to-make-best-use-of-the-program.pdf | 204.41 KB |
| 01-software-installation/004-installing-oracle.mp4 | 11.23 MB |
| 01-software-installation/005-installing-java-sdk.mp4 | 7.04 MB |
| 01-software-installation/006-installing-sql-developer.mp4 | 10.05 MB |
| 01-software-installation/007-running-scripts-necessary-for-the-course.mp4 | 9.4 MB |
| 01-software-installation/008-scripts-for-our-lab-exercises.pdf | 166.42 KB |
| 01-software-installation/attached_files/007-running-scripts-necessary-for-the-course/Create-User.txt | 197 B |
| 02-database-concepts/009-what-is-a-table.mp4 | 5.92 MB |
| 02-database-concepts/010-what-is-a-database.mp4 | 7.92 MB |
| 02-database-concepts/011-what-is-a-relational-database-rdbms.mp4 | 3.63 MB |
| 02-database-concepts/012-what-is-a-transaction.mp4 | 4.97 MB |
| 02-database-concepts/013-what-is-acid.mp4 | 4.95 MB |
| 02-database-concepts/014-rdbms-vendors.mp4 | 2.35 MB |
| 03-enter-the-dragon-database/015-building-sql-template....html | 426 B |
| 03-enter-the-dragon-database/016-how-do-you-talk-with-a-database.mp4 | 3.28 MB |
| 03-enter-the-dragon-database/017-what-are-the-most-common-commands.mp4 | 2.21 MB |
| 03-enter-the-dragon-database/018-what-type-of-data-can-we-store.mp4 | 6.38 MB |
| 03-enter-the-dragon-database/019-data-model-for-our-course.mp4 | 3.9 MB |
| 04-lets-see-the-data/020-what-data-can-i-see.mp4 | 10.76 MB |
| 04-lets-see-the-data/021-how-do-i-see-data-select.mp4 | 5.3 MB |
| 04-lets-see-the-data/022-how-do-i-see-a-part-of-the-data-select.mp4 | 5.7 MB |
| 04-lets-see-the-data/023-lab-1-exercises-with-answers.pdf | 276.03 KB |
| 05-lets-limit-the-data-we-see-filtering/024-filtering-data-where-command.mp4 | 5.78 MB |
| 05-lets-limit-the-data-we-see-filtering/025-comparison-operators.mp4 | 2.1 MB |
| 05-lets-limit-the-data-we-see-filtering/026-filtering-data-more-examples....mp4 | 6.74 MB |
| 05-lets-limit-the-data-we-see-filtering/027-filters-on-character-and-date-values....mp4 | 9.11 MB |
| 05-lets-limit-the-data-we-see-filtering/028-filtering-based-on-a-column-in-a-table....mp4 | 7.81 MB |
| 05-lets-limit-the-data-we-see-filtering/029-lab-2-exercises-with-answers.pdf | 276.53 KB |
| 06-logical-operators/030-between-and-not-between.mp4 | 4.54 MB |
| 06-logical-operators/031-in-and-not-in.mp4 | 4.86 MB |
| 06-logical-operators/032-like-operator.mp4 | 13.68 MB |
| 06-logical-operators/033-all-and-any.mp4 | 5.93 MB |
| 06-logical-operators/034-lets-learn-about-null....mp4 | 3.78 MB |
| 06-logical-operators/035-is-null-and-is-not-null.mp4 | 5.7 MB |
| 06-logical-operators/036-and-and-or.mp4 | 9.78 MB |
| 06-logical-operators/037-lab-3-exercises-with-answers.pdf | 282.83 KB |
| 07-arithmetic-operators/038-they-are-simple-10-20-30.mp4 | 5.72 MB |
| 07-arithmetic-operators/039-lab-4-exercises-with-answers.pdf | 206.47 KB |
| 08-lets-sort-the-data-we-see-sorting/040-order-by-clause.mp4 | 8.43 MB |
| 08-lets-sort-the-data-we-see-sorting/041-how-are-null-values-treated-while-sorting-data.mp4 | 4.29 MB |
| 08-lets-sort-the-data-we-see-sorting/042-lab-5-exercises-with-answers.pdf | 271.39 KB |
| 09-how-do-we-combine-data-from-2-tables/043-set-operators.mp4 | 4.61 MB |
| 09-how-do-we-combine-data-from-2-tables/044-union-operator.mp4 | 7.5 MB |
| 09-how-do-we-combine-data-from-2-tables/045-union-all-operator.mp4 | 2.67 MB |
| 09-how-do-we-combine-data-from-2-tables/046-intersect-operator.mp4 | 3.5 MB |
| 09-how-do-we-combine-data-from-2-tables/047-minus-operator.mp4 | 3.62 MB |
| 09-how-do-we-combine-data-from-2-tables/048-lab-6-exercises-with-answers.pdf | 273.78 KB |
| 10-lets-group-the-data/049-aggregatesummary-functions.mp4 | 10.34 MB |
| 10-lets-group-the-data/050-group-by-clause.mp4 | 8.08 MB |
| 10-lets-group-the-data/051-group-by-with-multiple-columns.mp4 | 13.62 MB |
| 10-lets-group-the-data/052-group-by-with-having-clause.mp4 | 8.35 MB |
| 10-lets-group-the-data/053-lab-7-exercises-with-answers.pdf | 291.92 KB |
| 11-joining-data-from-2-or-more-tables-joins/054-why-joins.mp4 | 15.37 MB |
| 11-joining-data-from-2-or-more-tables-joins/055-inner-join.mp4 | 11.27 MB |
| 11-joining-data-from-2-or-more-tables-joins/056-left-outer-join.mp4 | 5.98 MB |
| 11-joining-data-from-2-or-more-tables-joins/057-right-outer-join.mp4 | 5.72 MB |
| 11-joining-data-from-2-or-more-tables-joins/058-full-outer-join.mp4 | 4.95 MB |
| 11-joining-data-from-2-or-more-tables-joins/059-cross-join.mp4 | 6.65 MB |
| 11-joining-data-from-2-or-more-tables-joins/060-natural-join.mp4 | 5.42 MB |
| 11-joining-data-from-2-or-more-tables-joins/061-joining-the-3rd-table.mp4 | 3.58 MB |
| 11-joining-data-from-2-or-more-tables-joins/062-joining-the-4th-table-and-so-on....mp4 | 2.73 MB |
| 11-joining-data-from-2-or-more-tables-joins/063-adding-filters-to-joins.mp4 | 13.37 MB |
| 11-joining-data-from-2-or-more-tables-joins/064-lab-8-exercises-with-answers.pdf | 272.66 KB |
| 12-functions-available-for-us-to-use/065-dual-what-is-this.mp4 | 4.08 MB |
| 12-functions-available-for-us-to-use/066-why-do-we-need-functions.mp4 | 2.48 MB |
| 12-functions-available-for-us-to-use/067-number-related-functions.mp4 | 11.62 MB |
| 12-functions-available-for-us-to-use/068-character-related-functions.mp4 | 7.66 MB |
| 12-functions-available-for-us-to-use/069-date-related-functions.mp4 | 10.46 MB |
| 12-functions-available-for-us-to-use/070-lab-9-exercises-with-answers.pdf | 280.51 KB |
| 13-interesting-things/071-if-then-else-case-statement.mp4 | 8.1 MB |
| 13-interesting-things/072-alternative-name-alias-name.mp4 | 11.44 MB |
| 13-interesting-things/073-distinct-values.mp4 | 7.89 MB |
| 13-interesting-things/074-pseudo-columns.mp4 | 8.66 MB |
| 14-data-definition-language-ddl/075-lets-create-a-table-create.mp4 | 4.91 MB |
| 14-data-definition-language-ddl/076-lets-change-the-structure-of-a-table-alter.mp4 | 10.32 MB |
| 14-data-definition-language-ddl/077-lets-delete-the-table-drop.mp4 | 1.91 MB |
| 14-data-definition-language-ddl/078-create-table-as-ctas.mp4 | 6.13 MB |
| 14-data-definition-language-ddl/079-lab-11-exercises-with-answers.pdf | 374.27 KB |
| 15-data-manipulation-language-dml/080-commit-and-rollback.mp4 | 1.56 MB |
| 15-data-manipulation-language-dml/081-insert-data-into-a-table-insert.mp4 | 10.93 MB |
| 15-data-manipulation-language-dml/082-delete-data-from-a-table-delete.mp4 | 8.07 MB |
| 15-data-manipulation-language-dml/083-modify-existing-data-in-a-table-update.mp4 | 7.41 MB |
| 15-data-manipulation-language-dml/084-delete-all-the-data-from-a-table-truncate.mp4 | 6.01 MB |
| 15-data-manipulation-language-dml/085-lab-12-exercises-with-answers.pdf | 291.44 KB |
| 16-lets-put-some-restrictions-on-a-table-constraints/086-why-constraints.mp4 | 2.03 MB |
| 16-lets-put-some-restrictions-on-a-table-constraints/087-no-empty-data-allowed-not-null.mp4 | 7.5 MB |
| 16-lets-put-some-restrictions-on-a-table-constraints/088-no-duplicate-data-unique.mp4 | 6.8 MB |
| 16-lets-put-some-restrictions-on-a-table-constraints/089-what-is-not-null-unique-primary-key.mp4 | 7.74 MB |
| 16-lets-put-some-restrictions-on-a-table-constraints/090-accept-only-few-values-check.mp4 | 7.7 MB |
| 16-lets-put-some-restrictions-on-a-table-constraints/091-check-data-in-other-table-before-insertingdeleting-foreign-key.mp4 | 11.91 MB |
| 16-lets-put-some-restrictions-on-a-table-constraints/092-constraints-on-multiple-columns.mp4 | 6.02 MB |
| 16-lets-put-some-restrictions-on-a-table-constraints/093-adding-constraints-to-an-existing-table.mp4 | 3.26 MB |
| 16-lets-put-some-restrictions-on-a-table-constraints/094-more-operations-on-constraints....mp4 | 4.4 MB |
| 16-lets-put-some-restrictions-on-a-table-constraints/095-lab-13-exercises-with-answers.pdf | 306.46 KB |
| 17-views/096-why-views.mp4 | 12.24 MB |
| 17-views/097-lets-modify-an-existing-view.mp4 | 4.61 MB |
| 17-views/098-lets-update-view-data.mp4 | 6.43 MB |
| 17-views/099-create-view-from-more-than-1-table.mp4 | 14.73 MB |
Trackers
No trackers found.