Complete Oracle SQL Masterclass: Go from zero to Hero
Complete Oracle SQL Masterclass: Go from zero to Hero, available at $54.99, has an average rating of 3.85, with 183 lectures, based on 53 reviews, and has 1736 subscribers.
You will learn about Write basic and advanced SQL Queries for any Relational Database Management System Learn DDL and DML commands Learn Joins and Subqueries Use SQL in Python 3 programs Work with Oracle SQL Developer Learn to export your data This course is ideal for individuals who are Programmers and Developers or Testers and QAs or Data Scientists and Engineers or Database Administrators or Analysts or Managers and Sales People or People preparing for Oracle and other database related certifications or Anyone who genuinely wants to learn SQL It is particularly useful for Programmers and Developers or Testers and QAs or Data Scientists and Engineers or Database Administrators or Analysts or Managers and Sales People or People preparing for Oracle and other database related certifications or Anyone who genuinely wants to learn SQL.
Enroll now: Complete Oracle SQL Masterclass: Go from zero to Hero
Summary
Title: Complete Oracle SQL Masterclass: Go from zero to Hero
Price: $54.99
Average Rating: 3.85
Number of Lectures: 183
Number of Published Lectures: 183
Number of Curriculum Items: 183
Number of Published Curriculum Objects: 183
Original Price: $19.99
Quality Status: approved
Status: Live
What You Will Learn
- Write basic and advanced SQL Queries for any Relational Database Management System
- Learn DDL and DML commands
- Learn Joins and Subqueries
- Use SQL in Python 3 programs
- Work with Oracle SQL Developer
- Learn to export your data
Who Should Attend
- Programmers and Developers
- Testers and QAs
- Data Scientists and Engineers
- Database Administrators
- Analysts
- Managers and Sales People
- People preparing for Oracle and other database related certifications
- Anyone who genuinely wants to learn SQL
Target Audiences
- Programmers and Developers
- Testers and QAs
- Data Scientists and Engineers
- Database Administrators
- Analysts
- Managers and Sales People
- People preparing for Oracle and other database related certifications
- Anyone who genuinely wants to learn SQL
Become an expert in SQL and learn one of employer’s most requested skills of 21st Century! SQL is used in many job roles including Database Administration, Data Science, Performance Engineering, and Web Development. A person with expert level knowledge of SQL can earn minimum $100000 (That’s five zeroes after 5) per year.
This is the most comprehensive, yet straight-forward course for the Structured Query Language (SQL) on Udemy! Whether you have never used databases before, already know basics of SQL, or want to learn about the advanced features of SQL, this course is for you! In this course I will teach you SQL with Oracle.
With over 180 lectures and more than 20 hours of video this comprehensive course leaves no stone unturned to make you an expert in the SQL.
This course will teach you SQL in a very practical manner, with every lecture comes a full SQL programming video and a corresponding PDF that has SQL code! Learn in whatever manner is the best for you!
We will start by helping you get Oracle XE and SQL Developer installed on your Windows computer.
We cover a wide variety of topics, including:
-
Basics of RDBMS and SQL
-
Getting Started with SQL
-
Installation of Oracle and SQL Developer
-
The WHERE Clause
-
Single ROW Functions
-
Group Functions
-
Joining data from multiple tables
-
DML Statements and Transactions
-
DDLs, Tables, and Data Dictionary
-
Constraints
-
Views
-
Synonyms and Indexes
-
Set Operations
-
Sequences
-
Schemas, Roles, and User Access Control
-
Advanced Topics in Oracle SQL
-
Python 3 and SQL
-
Additional Resources and Tools
-
MySQL
-
RDBMS and SQL for Data Science
-
Bonus Section
You will get lifetime access to over 180 lectures plus corresponding SQL code PDFs for the lectures!
So what are you waiting for? Learn SQL in a way that will advance your career and increase your knowledge, all in a fun and practical way!
Course Curriculum
Chapter 1: Introduction
Lecture 1: Course Objectives and Expected Audience
Lecture 2: Course Contents Walkthrough
Lecture 3: Please do leave your valuable feedback for the course
Lecture 4: Introduction to Relational DBMS and SQL
Lecture 5: Installation of Oracle XE
Lecture 6: Installation of SQL Developer
Lecture 7: Web Resources for Software installation
Lecture 8: Why Oracle
Lecture 9: Why Oracle : Web URLs
Lecture 10: Types of SQL Queries
Lecture 11: A quick look at SQL in action
Chapter 2: Getting Started with Oracle SQL
Lecture 1: Getting started with Oracle and SQL Developer
Lecture 2: CODE: Getting started with Oracle and SQL Developer
Lecture 3: Selection, Projection, Operators, and Operator Precedence
Lecture 4: CODE: Selection, Projection, Operators, and Operator Precedence
Lecture 5: NULL Values and Column Aliases
Lecture 6: CODE: NULL Values and Column Aliases
Lecture 7: Concatenation, Literal Character Strings, and DISTINCT
Lecture 8: CODE: Concatenation, Literal Character Strings, and DISTINCT
Chapter 3: The WHERE Clause
Lecture 1: WHERE Clause and Comparison Conditions
Lecture 2: CODE: WHERE Clause and Comparison Conditions
Lecture 3: BETWEEN and IN
Lecture 4: CODE: BETWEEN and IN
Lecture 5: LIKE and IS NULL
Lecture 6: CODE: LIKE and IS NULL
Lecture 7: Logical Operations
Lecture 8: CODE: Logical Operations
Lecture 9: Sorting
Lecture 10: CODE: Sorting
Lecture 11: Dates
Lecture 12: CODE: Dates
Chapter 4: Single Row Functions
Lecture 1: Functions in SQL – Single Row and Multiple Row (Group)
Lecture 2: Dual Table
Lecture 3: Case Manipulation Functions
Lecture 4: CODE: Case Manipulation Functions
Lecture 5: Character Manipulation Functions
Lecture 6: CODE: Character Manipulation Functions
Lecture 7: Number Functions
Lecture 8: CODE: Number Functions
Lecture 9: Conversion Functions
Lecture 10: CODE: Conversion Functions
Lecture 11: Working with dates
Lecture 12: CODE: Working with dates
Lecture 13: NVL, NVL2, NULLIF, COALESCE
Lecture 14: CODE: NVL, NVL2, NULLIF, COALESCE
Lecture 15: CASE and DECODE
Lecture 16: CODE: CASE and DECODE
Lecture 17: Nesting of Single Row Functions
Chapter 5: Group Functions
Lecture 1: Group Functions
Lecture 2: CODE: Group Functions
Lecture 3: GROUP BY
Lecture 4: CODE: GROUP BY
Lecture 5: HAVING Clause
Lecture 6: CODE: HAVING Clause
Chapter 6: Joining data from multiple tables
Lecture 1: Cross Join and Cartesian Product
Lecture 2: CODE: Cross Join and Cartesian Product
Lecture 3: NATURAL JOIN and INNER JOIN
Lecture 4: CODE: NATURAL JOIN and INNER JOIN
Lecture 5: OUTER JOINS
Lecture 6: CODE: OUTER JOINS
Lecture 7: Additional Conditions in Joins and Joining multiple tables
Lecture 8: CODE: Additional Conditions in Joins and Joining multiple tables
Lecture 9: Self Join
Lecture 10: CODE: Self Join
Lecture 11: Non-equijoins
Lecture 12: CODE: Non-equiJoins
Chapter 7: DML Statements and Transactions
Lecture 1: Basics of Sessions and Transactions
Lecture 2: INSERT Statement
Lecture 3: CODE: INSERT Statement
Lecture 4: UPDATE Statement
Lecture 5: CODE: UPDATE Statement
Lecture 6: DELETE Statements
Lecture 7: CODE: DELETE Statement
Lecture 8: Theory – Locking and Deadlocks
Lecture 9: Locking and Deadlock Demonstration
Lecture 10: CODE- Deadlock in Oracle
Chapter 8: DDL, Tables, and Data Dictionary
Lecture 1: DDLs and CREATE TABLE
Lecture 2: CODE: DDLs and CREATE TABLE
Lecture 3: ALTER TABLE
Lecture 4: CODE: ALTER TABLE
Lecture 5: Data Dictionary
Lecture 6: CODE: Data Dictionary
Lecture 7: RENAME and TRUNCATE
Lecture 8: CODE: RENAME and TRUNCATE
Lecture 9: DROP TABLE
Lecture 10: CODE: DROP TABLE
Lecture 11: Commonly used Oracle Data types
Lecture 12: CODE- Commonly used Oracle Data Types
Chapter 9: Constraints
Lecture 1: Constraints and Primary Key- Theory Lecture
Lecture 2: Data Dictionary for Constraints
Lecture 3: CODE- Data Dictionary for Constraints
Instructors
-
Ashwin Pajankar • 85,000+ Students Worldwide
Instructor | Programmer | Maker | Author | Youtuber
Rating Distribution
- 1 stars: 1 votes
- 2 stars: 2 votes
- 3 stars: 11 votes
- 4 stars: 25 votes
- 5 stars: 14 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024