Oracle SQL from Zero to Hero

[0dayddl]

6.22 GB | 22min 47s | mp4 | 1280X720 | 16:9
Genre:eLearning |Language:English​

Files Included :

Spoiler

1 -Introduction.mp4 (78.21 MB)
10 -Introduction to Oracle SQL.mp4 (111.01 MB)
11 -Retrieving Data ( Part 1 ).mp4 (93.16 MB)
12 -Retrieving Data ( Part 2 ).mp4 (75.32 MB)
13 -Retrieving Data ( Part 3 ).mp4 (71.19 MB)
14 -Restricting Data.mp4 (123.68 MB)
15 -Sorting and Limiting Retrieved Rows.mp4 (70.27 MB)
16 -Using Substitution Variables.mp4 (90.66 MB)
17 -Using Single-Row Functions.mp4 (82.31 MB)
18 -Working with DATE Data Type.mp4 (72.08 MB)
19 -Using Conversion Functions ( Part 1 ).mp4 (53.8 MB)
2 -Preparing Course Environment ( Part 1 ).mp4 (68.37 MB)
20 -Using Conversion Functions ( Part 2 ).mp4 (53.63 MB)
21 -Converting Character to DATE Data Type.mp4 (55.34 MB)
22 -Functions to Handle Null Values.mp4 (51.04 MB)
23 -Using Conditional Expressions.mp4 (38.49 MB)
24 -Introducing Group Functions.mp4 (71.88 MB)
25 -Using Group Functions.mp4 (67.87 MB)
26 -Implementing Inner Joins ( Part 1 ).mp4 (54.16 MB)
27 -Implementing Inner Joins ( Part 2 ).mp4 (64.89 MB)
28 -Implementing Self and Non-equi Joins.mp4 (38.15 MB)
29 -Implementing Outer Joins.mp4 (69.74 MB)
3 -Preparing Course Environment ( Part 2 ).mp4 (78.95 MB)
30 -Using Scalar Subqueries.mp4 (64.48 MB)
31 -Using Multiple-Row Subqueries.mp4 (60.55 MB)
32 -Using Multiple-Column Subqueries.mp4 (47.81 MB)
33 -Using Subqueries - More Options.mp4 (55.12 MB)
34 -Using the Set Operators.mp4 (102.54 MB)
35 -Hierarchical Retrieval.mp4 (97.38 MB)
36 -Using Oracle Database SQL Documentation.mp4 (1.31 MB)
37 -Using DML Statements - INSERT ( Part 1 ).mp4 (68.68 MB)
38 -Using DML Statements - INSERT ( Part 2 ).mp4 (60.45 MB)
39 -Using DML Statements - UPDATE.mp4 (66.87 MB)
4 -Introduction to SQL Developer.mp4 (31.79 MB)
40 -Using DML Statements - DELETE.mp4 (30.89 MB)
41 -Using DML Statements - MERGE.mp4 (32.2 MB)
42 -Using Transaction Control Commands ( Part 1 ).mp4 (67.3 MB)
43 -Using Transaction Control Commands ( Part 2 ).mp4 (30.15 MB)
44 -Demo - Using Transaction Control Commands.mp4 (37.01 MB)
45 -Read Consistency and Locking Data ( Part 1 ).mp4 (51.63 MB)
46 -Read Consistency and Locking Data ( Part 2 ).mp4 (67.88 MB)
47 -Demo - Read Consistency and Locking Data.mp4 (68.43 MB)
48 -Using SQL-Plus ( Part 1 ).mp4 (73.24 MB)
49 -Using SQL-Plus ( Part 2 ).mp4 (45.37 MB)
5 -Demo - Getting Familiar with SQL Developer.mp4 (110.78 MB)
50 -Introduction to Oracle Database Built-in Data Types.mp4 (93.06 MB)
51 -Creating Tables.mp4 (95.23 MB)
52 -Demo - Creating Tables.mp4 (35.83 MB)
53 -Modifying Table Structure.mp4 (106.52 MB)
54 -Demo - Modifying Table Structure.mp4 (50.01 MB)
55 -Managing Constraints - Fundamentals ( Part 1 ).mp4 (60.97 MB)
56 -Managing Constraints - Fundamentals ( Part 2 ).mp4 (49.36 MB)
57 -Managing Constraints - Fundamentals ( Part 3 ).mp4 (57.58 MB)
58 -Demo - Managing Constraints - Fundamentals.mp4 (60.99 MB)
59 -Managing Views ( Part 1 ).mp4 (51.67 MB)
6 -Overview of RDBMS ( Part 1).mp4 (56.36 MB)
60 -Managing Views ( Part 2 ).mp4 (52.04 MB)
61 -Demo - Managing Views.mp4 (54.93 MB)
62 -Data Dictionary Views ( Part 1 ).mp4 (57.35 MB)
63 -Data Dictionary Views ( Part 2 ).mp4 (78.57 MB)
64 -Creating and Managing Sequences.mp4 (80.43 MB)
65 -Demo - Creating and Managing Sequences.mp4 (28.56 MB)
66 -Creating Indexes.mp4 (80.59 MB)
67 -Demo - Creating Indexes.mp4 (85.37 MB)
68 -Creating Indexes - More Options.mp4 (133.88 MB)
69 -Demo - Creating Indexes - More Options.mp4 (55.73 MB)
7 -Overview of RDBMS ( Part 2 ).mp4 (50.59 MB)
70 -Defragmenting Indexes.mp4 (61.3 MB)
71 -Demo - Rebuilding Indexes.mp4 (22.76 MB)
72 -Creating Database Users.mp4 (74.96 MB)
73 -Controlling User Access - System Privileges.mp4 (74.21 MB)
74 -Demo - Managing System Privileges.mp4 (77.48 MB)
75 -Controlling User Access - Object Privileges.mp4 (79.38 MB)
76 -Demo - Managing Object Privileges.mp4 (52.17 MB)
77 -Managing Roles.mp4 (146.42 MB)
78 -Demo - Managing Roles.mp4 (76.86 MB)
79 -Creating and Managing Synonyms.mp4 (24.22 MB)
8 -Data Models ( Part 1 ).mp4 (47.14 MB)
80 -Demo - Creating and Managing Synonyms.mp4 (21.31 MB)
81 -Using TIMESTAMP Data Type.mp4 (51.42 MB)
82 -Demo - Using TIMESTAMP Data Type.mp4 (26.72 MB)
83 -Using TIMESTAMP WITH TIME ZONE Data Type.mp4 (81.85 MB)
84 -Demo - Using TIMESTAMP WITH TIME ZONE Data Type.mp4 (43 MB)
85 -Handling Daylight Saving Time.mp4 (135.19 MB)
86 -Demo - Handling Daylight Saving Time.mp4 (52.73 MB)
87 -More Datetime Functions.mp4 (67.74 MB)
88 -Demo - More Datetime Functions.mp4 (40.21 MB)
89 -Managing Interval Data Types.mp4 (73.18 MB)
9 -Data Models ( Part 2 ).mp4 (65.47 MB)
90 -Demo - Managing Interval Data Types.mp4 (35.44 MB)
91 -Managing Temporary Tables.mp4 (40.87 MB)
92 -Demo - Managing Temporary Tables.mp4 (29.47 MB)
93 -Managing External Tables.mp4 (83.47 MB)
94 -Demo - Managing External Tables.mp4 (71.84 MB)
95 -Managing Constraints - Advanced Topics.mp4 (155.25 MB)
96 -Demo - Managing Constraints - Advanced Topics.mp4 (110.46 MB)

]
Screenshot

Spoiler

RapidGator

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

TurboBit

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

 

[0dayddl]

Oracle SQL from Zero to Hero
2025-01-21
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English (US) | Size: 6.49 GB | Duration: 18h 52m​

Learn Oracle SQL from Scratch, Build Real Skills, and Prepare for 1Z0-071 certification success

What you'll learn
Master Oracle SQL fundamentals and advanced
Gain the SQL skills and experience to cope with real life scenarios
Be confident in covering all the SQL aspects, including data retrieval, modification, structure, security, and transaction control.
Prepare for certification 1Z0-071 success
Gain hands-on experience in solving business problems with SQL
Extend your SQL experience beyond the exam topics to gain more realistic skills required in production environments.

Requirements
Windows PC with at least 8 GB RAM and 60 GB storage

Description
Unlock the power of Oracle SQL with this engaging course designed specifically for beginners preparing for the Oracle Database SQL Certified Associate (1Z0-071) Exam. Whether you are new to SQL or looking to build foundational skills in Oracle databases, this course provides everything you need to succeed in your journey.Starting from scratch, you will learn how to retrieve, sort, filter, and restrict data effectively. The course covers essential SQL topics such as group functions, joins, subqueries, and set operators, ensuring you have a comprehensive understanding of how to manage and query data efficiently. Additionally, you will explore key database object management skills, including creating and managing tables, views, indexes, sequences, and constraints.What sets this course apart is its hands-on approach. You will work through real-world examples, interactive demos, quizzes, and practice sessions to build practical and applicable skills. The curriculum is designed to not only help you pass the 1Z0-071 certification exam but also prepare you to tackle everyday database challenges with confidence.By the end of this course, you will have the knowledge and expertise to write effective SQL queries and work with Oracle databases, setting you on a path to success in your career and certification goals.

Who this course is for:
IT Developers and Professionals, Business Analysts and Data Analysts, 1Z0-071 Certification Seekers, Database Administrators

For More Courses Visit & Bookmark Your Preferred Language Blog
From Here:

Bitte Anmelden oder Registrieren um Links zu sehen.

-

Bitte Anmelden oder Registrieren um Links zu sehen.

-

Bitte Anmelden oder Registrieren um Links zu sehen.

-

Bitte Anmelden oder Registrieren um Links zu sehen.

-

Bitte Anmelden oder Registrieren um Links zu sehen.

-

Bitte Anmelden oder Registrieren um Links zu sehen.

-

Bitte Anmelden oder Registrieren um Links zu sehen.

-

Bitte Anmelden oder Registrieren um Links zu sehen.

-

Bitte Anmelden oder Registrieren um Links zu sehen.

TurboBit

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

RapidGator

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

AlfaFile

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!