FreeCourseSite com Udemy Oracle SQL Step by Step SQL | F523C368DE02772218B89E58ECE69EA78A433570

FreeCourseSite com Udemy Oracle SQL Step by Step SQL

Name	[FreeCourseSite.com] Udemy - Oracle SQL – Step by Step SQL	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	828.6 MB
Total Files	129
Hash	F523C368DE02772218B89E58ECE69EA78A433570

/00-none/
001-closed-captionssub-titles-for-the-course.pdf	238.9 KB
002-welcome.mp4	11.9 MB
003-how-to-make-best-use-of-the-program.pdf	209.3 KB
/01-software-installation/
004-installing-oracle.mp4	11.8 MB
005-installing-java-sdk.mp4	7.4 MB
006-installing-sql-developer.mp4	10.5 MB
007-running-scripts-necessary-for-the-course.mp4	9.9 MB
008-scripts-for-our-lab-exercises.pdf	170.4 KB
/.../007-running-scripts-necessary-for-the-course/
Create-User.txt	0.2 KB
/02-database-concepts/
009-what-is-a-table.mp4	6.2 MB
010-what-is-a-database.mp4	8.3 MB
011-what-is-a-relational-database-rdbms.mp4	3.8 MB
012-what-is-a-transaction.mp4	5.2 MB
013-what-is-acid.mp4	5.2 MB
014-rdbms-vendors.mp4	2.5 MB
/03-enter-the-dragon-database/
015-building-sql-template....html	0.4 KB
016-how-do-you-talk-with-a-database.mp4	3.4 MB
017-what-are-the-most-common-commands.mp4	2.3 MB
018-what-type-of-data-can-we-store.mp4	6.7 MB
019-data-model-for-our-course.mp4	4.1 MB
/04-lets-see-the-data/
020-what-data-can-i-see.mp4	11.3 MB
021-how-do-i-see-data-select.mp4	5.6 MB
022-how-do-i-see-a-part-of-the-data-select.mp4	6.0 MB
023-lab-1-exercises-with-answers.pdf	282.7 KB
/05-lets-limit-the-data-we-see-filtering/
024-filtering-data-where-command.mp4	6.1 MB
025-comparison-operators.mp4	2.2 MB
026-filtering-data-more-examples....mp4	7.1 MB
027-filters-on-character-and-date-values....mp4	9.5 MB
028-filtering-based-on-a-column-in-a-table....mp4	8.2 MB
029-lab-2-exercises-with-answers.pdf	283.2 KB
/06-logical-operators/
030-between-and-not-between.mp4	4.8 MB
031-in-and-not-in.mp4	5.1 MB
032-like-operator.mp4	14.3 MB
033-all-and-any.mp4	6.2 MB
034-lets-learn-about-null....mp4	4.0 MB
035-is-null-and-is-not-null.mp4	6.0 MB
036-and-and-or.mp4	10.3 MB
037-lab-3-exercises-with-answers.pdf	289.6 KB
/07-arithmetic-operators/
038-they-are-simple-10-20-30.mp4	6.0 MB
039-lab-4-exercises-with-answers.pdf	211.4 KB
/08-lets-sort-the-data-we-see-sorting/
040-order-by-clause.mp4	8.8 MB
041-how-are-null-values-treated-while-sorting-data.mp4	4.5 MB
042-lab-5-exercises-with-answers.pdf	277.9 KB
/09-how-do-we-combine-data-from-2-tables/
043-set-operators.mp4	4.8 MB
044-union-operator.mp4	7.9 MB
045-union-all-operator.mp4	2.8 MB
046-intersect-operator.mp4	3.7 MB
047-minus-operator.mp4	3.8 MB
048-lab-6-exercises-with-answers.pdf	280.4 KB
/10-lets-group-the-data/
049-aggregatesummary-functions.mp4	10.8 MB
050-group-by-clause.mp4	8.5 MB
051-group-by-with-multiple-columns.mp4	14.3 MB
052-group-by-with-having-clause.mp4	8.8 MB
053-lab-7-exercises-with-answers.pdf	298.9 KB
/11-joining-data-from-2-or-more-tables-joins/
054-why-joins.mp4	16.1 MB
055-inner-join.mp4	11.8 MB
056-left-outer-join.mp4	6.3 MB
057-right-outer-join.mp4	6.0 MB
058-full-outer-join.mp4	5.2 MB
059-cross-join.mp4	7.0 MB
060-natural-join.mp4	5.7 MB
061-joining-the-3rd-table.mp4	3.8 MB
062-joining-the-4th-table-and-so-on....mp4	2.9 MB
063-adding-filters-to-joins.mp4	14.0 MB
064-lab-8-exercises-with-answers.pdf	279.2 KB
/12-functions-available-for-us-to-use/
065-dual-what-is-this.mp4	4.3 MB
066-why-do-we-need-functions.mp4	2.6 MB
067-number-related-functions.mp4	12.2 MB
068-character-related-functions.mp4	8.0 MB
069-date-related-functions.mp4	11.0 MB
070-lab-9-exercises-with-answers.pdf	287.2 KB
/13-interesting-things/
071-if-then-else-case-statement.mp4	8.5 MB
072-alternative-name-alias-name.mp4	12.0 MB
073-distinct-values.mp4	8.3 MB
074-pseudo-columns.mp4	9.1 MB
/14-data-definition-language-ddl/
075-lets-create-a-table-create.mp4	5.1 MB
076-lets-change-the-structure-of-a-table-alter.mp4	10.8 MB
077-lets-delete-the-table-drop.mp4	2.0 MB
078-create-table-as-ctas.mp4	6.4 MB
079-lab-11-exercises-with-answers.pdf	383.3 KB
/15-data-manipulation-language-dml/
080-commit-and-rollback.mp4	1.6 MB
081-insert-data-into-a-table-insert.mp4	11.5 MB
082-delete-data-from-a-table-delete.mp4	8.5 MB
083-modify-existing-data-in-a-table-update.mp4	7.8 MB
084-delete-all-the-data-from-a-table-truncate.mp4	6.3 MB
085-lab-12-exercises-with-answers.pdf	298.4 KB
/16-lets-put-some-restrictions-on-a-table-constraints/
086-why-constraints.mp4	2.1 MB
087-no-empty-data-allowed-not-null.mp4	7.9 MB
088-no-duplicate-data-unique.mp4	7.1 MB
089-what-is-not-null-unique-primary-key.mp4	8.1 MB
090-accept-only-few-values-check.mp4	8.1 MB
091-check-data-in-other-table-before-insertingdeleting-foreign-key.mp4	12.5 MB
092-constraints-on-multiple-columns.mp4	6.3 MB
093-adding-constraints-to-an-existing-table.mp4	3.4 MB
094-more-operations-on-constraints....mp4	4.6 MB
095-lab-13-exercises-with-answers.pdf	313.8 KB
/17-views/
096-why-views.mp4	12.8 MB
097-lets-modify-an-existing-view.mp4	4.8 MB
098-lets-update-view-data.mp4	6.7 MB
099-create-view-from-more-than-1-table.mp4	15.4 MB
100-lab-14-exercises-with-answers.pdf	369.3 KB
/18-other-database-objects/
101-alternative-name-for-objects-synonyms.mp4	5.8 MB
102-series-of-numbers-sequence.mp4	7.7 MB
/19-giving-permissions-to-other-users-grant/
103-i-like-him-grant.mp4	13.2 MB
104-i-dont-like-him-revoke.mp4	9.6 MB
105-list-of-all-grants.pdf	199.7 KB
/20-sub-queries/
106-what-is-a-sub-query.mp4	17.4 MB
107-sub-queries-on-multiple-columns-pairwise-comparision.mp4	13.9 MB
108-sub-queries-on-multiple-columns-nonpairwise-comparision.mp4	6.2 MB
109-sub-queries-in-the-from-clause.mp4	15.8 MB
110-sub-queries-in-the-with-clause.mp4	2.9 MB
111-scalar-sub-queries.mp4	4.7 MB
112-correlated-sub-query.mp4	23.3 MB
/21-advanced-topics-index/
113-book-index.mp4	4.5 MB
114-lets-create-an-index....mp4	8.7 MB
115-unique-index.mp4	5.6 MB
116-dropping-and-renaming-an-index.mp4	3.8 MB
/22-bonus-lets-recap-with-a-5-step-process/
117-scripts-for-this-section.pdf	209.3 KB
118-business-requirement.mp4	12.2 MB
119-step-1-lets-select-all-the-columns-needed....mp4	30.2 MB
120-step-2-lets-add-the-necessary-filters....mp4	4.8 MB
121-step-3-lets-perform-the-grouping....mp4	10.7 MB
122-step-4-lets-perform-filtering-at-group-level....mp4	5.6 MB
123-step-5-lets-sort-the-data....mp4	4.9 MB
124-recap-the-10-things-we-have-done....mp4	6.9 MB
/23-where-to-go-from-here/
125-project-work.pdf	217.3 KB
126-advanced-database-concepts-you-can-explore.pdf	209.4 KB
/
[CourseClub.NET].url	0.1 KB
[FreeCourseSite.com].url	0.1 KB
Total files 129