Published 11/2024
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 8.63 GB | Duration: 24h 15m
Oracle SQL with hands-on projects and deep dives into database management, queries, and data manipulation techniques.
What you’ll learn
Master the fundamentals of Oracle SQL 21c, including basic queries, sorting, and data manipulation.
Gain proficiency in using Oracle SQL Developer for database management and optimization.
Understand and implement complex joins, subqueries, and advanced SQL functions.
Apply real-world SQL solutions through hands-on projects using Oracle SQL Developer.
Develop expertise in ER modeling, data storage, and advanced Oracle-specific features like hierarchical queries and set operators.
Execute advanced data aggregation, grouping, and sorting techniques to analyze large datasets efficiently.
Requirements
No prior experience with Oracle SQL is required, but a basic understanding of general database concepts is helpful.
Familiarity with any programming or scripting language is an advantage but not necessary.
A computer with Oracle SQL Developer and Oracle Database 21c installed (instructions for installation will be provided).
Description
Introduction:Welcome to “Mastering Oracle SQL: From Fundamentals to Advanced Projects.” This comprehensive course is designed for aspiring database professionals, developers, and analysts who want to master the intricacies of Oracle SQL 21c. Whether you are a beginner looking to build a strong foundation in SQL or an experienced developer aiming to enhance your database management skills, this course covers everything you need to know. From writing basic SQL queries to implementing complex subqueries, joins, and advanced data manipulation, this course offers a step-by-step approach with practical examples and projects to solidify your understanding.Section-Wise Breakdown:Section 1: Oracle SQL 21c EssentialsThis section sets the stage by introducing you to the fundamentals of Oracle SQL 21c. You’ll start with an overview of the platform and an introduction to SQL Developer, Oracle’s powerful integrated development environment. As you progress, you’ll dive into executing basic SQL commands, sorting data, and using single and multiple-row functions to manipulate your datasets. The lectures on joins and subqueries will equip you with the skills to retrieve and manage complex datasets efficiently. You’ll conclude this section by mastering essential commands like UPDATE, DELETE, and table management techniques, setting a solid foundation for the projects to come.Section 2: Project 1 – Real-World Application Using Oracle SQL DeveloperBuilding on the concepts learned in the first section, this project takes a hands-on approach to applying your skills using Oracle SQL Developer. The lectures guide you through a real-world scenario where you’ll utilize Oracle SQL Developer to solve business problems. Each part of the project will enhance your proficiency with the tool, from executing queries to managing and visualizing data. By the end of this project, you’ll have developed a deeper understanding of how Oracle SQL can be used to drive actionable insights in a practical setting.Section 3: Project 2 – Advanced SQL Developer TechniquesIn the third section, you’ll embark on another project focused on advanced techniques within Oracle SQL Developer. You’ll explore more complex use cases, fine-tuning your skills in data management and optimization. This project emphasizes multi-step processes, integrating multiple tables, and utilizing advanced SQL functions to deliver comprehensive data solutions. By engaging with this project, you will gain confidence in using Oracle SQL for large-scale data operations and complex business scenarios.Section 4: Comprehensive Oracle SQL TrainingThe final section is a deep dive into the comprehensive capabilities of Oracle SQL 21c. You’ll explore Entity-Relationship (ER) modeling, data storage solutions, and advanced SQL concepts. The lectures cover an extensive range of topics, including character functions, arithmetic operations, data conversion, and sophisticated queries like hierarchical queries and correlated subqueries. You’ll also learn about Oracle-specific features such as the use of pseudocolumns, set operators, and advanced data grouping techniques. This section is packed with practical examples and assignments to ensure you not only understand but can apply these concepts in real-world scenarios.Conclusion:By the end of this course, you’ll have a robust understanding of Oracle SQL 21c, enabling you to tackle complex database challenges with ease. Whether you’re looking to enhance your career prospects, advance in your current role, or simply expand your technical skill set, this course equips you with the knowledge and practical experience to excel in the field of database management and SQL development. The hands-on projects and practical examples ensure you can apply what you’ve learned immediately in a professional setting.
Overview
Section 1: Oracle SQL 21c
Lecture 1 Oracle SQL 21c Overview
Lecture 2 Introduction to Course
Lecture 3 Executing Structured Query Language in SQL Developer
Lecture 4 Various Sorting Options in SQL
Lecture 5 Single and Multiple Row Functions
Lecture 6 Joins
Lecture 7 Single and Multiple Row Subqueries
Lecture 8 Update and Delete Statements
Lecture 9 Create and Manage Tables
Section 2: Oracle SQL Developer – Project # 1
Lecture 10 Introduction to SQL Developer
Lecture 11 SQL Developer Part 1
Lecture 12 SQL Developer Part 2
Lecture 13 SQL Developer Part 3
Lecture 14 SQL Developer Part 4
Lecture 15 SQL Developer Part 5
Lecture 16 SQL Developer Part 6
Section 3: SQL Developer-Project #2
Lecture 17 Intro to SQL Developer Project 2
Lecture 18 SQL Developer Part 1
Lecture 19 SQL Developer Part 2
Lecture 20 SQL Developer Part 3
Lecture 21 SQL Developer Part 4
Section 4: Oracle SQL Comprehensive Training
Lecture 22 ER Modeling
Lecture 23 Data Storage on Different Media
Lecture 24 RDBMS and SQL
Lecture 25 Select Statement with Column Alias and Arithmatic operators
Lecture 26 Concatination Operator,Literal, Eliminating Duplicate rows
Lecture 27 SQL iSQLplus and Displaying Table Structure
Lecture 28 Basic SQL Select Statements-Practical Examples
Lecture 29 Writing Basic SQL Select Statements
Lecture 30 Where Clause and Comparison Conditions
Lecture 31 Comparison Conditions
Lecture 32 Logical and Order by Clause
Lecture 33 Restricting and Sorting Data-Practical Examples 1
Lecture 34 Restricting and Sorting Data-Practical Examples 2
Lecture 35 Basic SQL Select Statements
Lecture 36 Basic SQL Select Statements Continue
Lecture 37 Character Function
Lecture 38 Case Manipulation Function
Lecture 39 Number, Arithmatic and Date Functions
Lecture 40 Arithmetic with Dates
Lecture 41 Conversion and RR YY Functions
Lecture 42 CHAR Function with Dates
Lecture 43 Nesting and General Functions
Lecture 44 COALESCE Function
Lecture 45 Practical Assignments
Lecture 46 Practical exercise
Lecture 47 Conversion Function
Lecture 48 Practical Demonstration
Lecture 49 Additional Examples
Lecture 50 Additional Examples of Salary
Lecture 51 Cartesian Product, EquiJoin
Lecture 52 Non Equi, Outer and Self Joins
Lecture 53 SQL 1999 Complaint Joins
Lecture 54 Creating Three-Way Joins with the ON Clause
Lecture 55 Displaying Data from Multiple Tables 1
Lecture 56 Displaying Data from Multiple Tables 2
Lecture 57 Displaying Data from Multiple Tables 3
Lecture 58 Create Query 1
Lecture 59 Create Query 2
Lecture 60 Group Functions Syntax
Lecture 61 MIN and MAX Functions
Lecture 62 Groups of Data and Having Clause
Lecture 63 IIIegal Querise Using Group Function
Lecture 64 Aggregating Data Using Group Functions-Practical Examples
Lecture 65 Aggregating Data Using Group Functions-Additional Examples 1
Lecture 66 Aggregating Data Using Group Functions-Additional Examples 2
Lecture 67 Subqueries
Lecture 68 The HAVING Clause with Subqueries
Lecture 69 Subqueries-Practical Examples-1
Lecture 70 Subqueries-Practical Examples-2
Lecture 71 Subqueries-Additional Examples 1
Lecture 72 Subqueries-Additional Examples 2
Lecture 73 Substitution Variables
Lecture 74 Verify,Column,Break,Ttitle,Btitle commands
Lecture 75 Producing Readable Output with iSQL-Practical Examples
Lecture 76 Producing Readable Output with iSQL- Examples
Lecture 77 Objectives and Insert Statement
Lecture 78 Update, Delete and Merge
Lecture 79 The UPDATE Statement Syntax
Lecture 80 Database Transaction
Lecture 81 ROLLBACK Statements
Lecture 82 Manipulating Data-Session 8 Practical 1
Lecture 83 Manipulating Data-Session 8 Practical 2
Lecture 84 Manipulating Data-Session 8 Practical 3
Lecture 85 Manipulating Data-Additional Examples 1
Lecture 86 Manipulating Data-Additional Examples 2
Lecture 87 Database Objects, Create Table
Lecture 88 Tables in the Oracle Database
Lecture 89 Alter Table, Drop Table
Lecture 90 The SETUNUSED Option
Lecture 91 Creating and Managing Tables-Practical Examples 1
Lecture 92 Creating and Managing Tables-Practical Examples 2
Lecture 93 Creating and Managing Tables-Additional Examples 1
Lecture 94 Creating and Managing Tables-Additional Examples 2
Lecture 95 Constraints, Type of Constraints and Defining Contraints
Lecture 96 The UNIQUE Constraint
Lecture 97 Adding, Disabling, Enabling Viewing Constraints
Lecture 98 Adding, Disabling, Enabling Viewing Constraints- summary
Lecture 99 Including Constraints-Practical Examples
Lecture 100 Including Constraints-Additional Examples
Lecture 101 Creating, Modifying and Quering Views
Lecture 102 Complex Views, Denying DML, Inline Views and Top n Analysis
Lecture 103 Complex Views, Denying DML, Inline Views and Top n Analysis part summary
Lecture 104 Creating Views-Practical Examples
Lecture 105 Creating Views-Additional Examples
Lecture 106 Creating Sequence, Modifying
Lecture 107 NEXTVAL and CURRVAL Pseudocolumns
Lecture 108 Indexes and Synonyms
Lecture 109 Other Database Objects-Practical Examples
Lecture 110 Other Database Objects-Additional Examples
Lecture 111 Controlling User Access
Lecture 112 Granting System Privileges
Lecture 113 Practice and Additional Practice Part-1
Lecture 114 Practice and Additional Practice Part-2
Lecture 115 SQL Workshop Examples 1
Lecture 116 SQL Workshop Examples 2
Lecture 117 SQL Workshop Examples 3
Lecture 118 SQL Workshop Examples 4
Lecture 119 SQL Workshop Examples 5
Lecture 120 SQL Workshop Examples 6
Lecture 121 SQL Workshop Examples 7
Lecture 122 SQL Workshop Examples 8
Lecture 123 Set Operators, Union, Unionall, Intersect and Minus
Lecture 124 Oracle Server and Set Operator
Lecture 125 Oracle Server and Set Operator summary
Lecture 126 Using SETOperators-Practical Examples
Lecture 127 Using SETOperators-Additional Examples
Lecture 128 Tz_offset,Current_date,Current_timestamp,Localtimestamp
Lecture 129 Extract and Other timestamp data types
Lecture 130 Extract and Other timestamp data types summary
Lecture 131 Oracle9i Datetime Functions-Practical Examples 1
Lecture 132 Oracle9i Datetime Functions-Practical Examples 2
Lecture 133 Oracle9i Datetime Functions-Additional Practice
Lecture 134 Group, Having, Group by, Rollup and Cube
Lecture 135 Grouping Functions, Grouping Set
Lecture 136 Grouping Functions, Grouping Set, Composit columns and Concatenated grouping sum
Lecture 137 Enhancements to the GROUP BY Clause 1
Lecture 138 Enhancements to the GROUP BY Clause 2
Lecture 139 Enhancements to the GROUP BY Clause-Additional Examples
Lecture 140 Multiple-Column Subqueries
Lecture 141 Column Comparisons
Lecture 142 Correlated Subqueries
Lecture 143 Correlated UPDATE
Lecture 144 summary
Lecture 145 Advanced Subqueries-Practical Examples 1
Lecture 146 Advanced Subqueries-Practical Examples 2
Lecture 147 Advanced Subqueries-Additional Example 1
Lecture 148 Advanced Subqueries-Additional Example 2
Lecture 149 Hierarchical Queries
Lecture 150 Walking the Tree From the Bottom Up
Lecture 151 Hierarchical Queries_summary
Lecture 152 Hierarchical Retrieval-Practical Examples
Lecture 153 Hierarchical Retrieval-Additional Examples
Lecture 154 Review of the UPDATE Statement
Lecture 155 Ranking Rows With the Level
Lecture 156 Pivoting Insert, External Tables
Lecture 157 Creating an External Table
Lecture 158 create table summary
Beginners looking to build a solid foundation in Oracle SQL and database management.,Database administrators who want to enhance their skills in Oracle SQL 21c.,Data analysts and developers looking to improve their SQL proficiency for data analysis and business intelligence.,IT professionals and project managers who need to understand SQL queries to communicate effectively with their teams.,Anyone interested in mastering Oracle SQL 21c to boost their career prospects in the tech industry.
https://anonymz.com/?https://www.udemy.com/course/mastering-oracle-sql-from-fundamentals-to-advanced-projects/