The Ultimate Oracle SQL Course: SQL Made Practical
This Ultimate Oracle SQL Course is the perfect way to jump-start your career as an Oracle SQL developer. It covers Oracle Database 11g, Oracle 12c, Oracle 18c, and Oracle 19c, and provides practical knowledge based on best practices and experience. You will learn by actually writing code, and get tips and knowledge that is usually only learned through years of SQL experience. With this course, you can become an experienced and knowledgeable SQL developer in a very short time. ▼
ADVERTISEMENT
Course Feature
Cost:
Paid
Provider:
Udemy
Certificate:
Paid Certification
Language:
English
Start Date:
2023-05-02
Course Overview
❗The content presented here is sourced directly from Udemy platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.
Updated in [July 18th, 2023]
The Ultimate Oracle SQL Course: SQL Made Practical is designed to help students learn Oracle SQL in a practical and smart way. This course covers Oracle Database 11g, Oracle 12c, Oracle 18c, and Oracle 19c. It is suitable for beginners, but experienced developers and other instructors will also learn a lot.
The course focuses on actually writing code, rather than just theoretical knowledge. Students will learn how to read, filter, and sort information from database tables, use all types of operators in Oracle SQL, use numeric, text, date, conversion, aggregate, analytic, and other types of Oracle SQL functions, add, modify, and delete information from Oracle databases using SQL, create and use tables, constraints, sequences, indexes, and views, and much more.
The instructor will also share his decades of Oracle experience with students through “experience tips”. These tips can help students differentiate and stand out.
At the end of the course, students will be comfortable writing code using Oracle SQL Developer and have the knowledge and skills to jump-start their career as an Oracle SQL developer.
Course Syllabus
Course Introduction
Environment Setup
Basic Database and SQL Concepts
Retrieving information from the Database using SQL (The SELECT statement)
Filtering and Sorting Results in SQL
Operators used in SQL
Group Operations in SQL
Subqueries in SQL
Single Row SQL Functions
Transposing Rows into Columns and Columns into Rows with SQL
Analytic Functions in Oracle SQL
Set Operators in SQL
Selecting Data from More than one Table with SQL
Hierarchical Queries in Oracle SQL
Additional Practice
Changing the Contents of Database Tables with SQL
Data Definition Language (DDL) in SQL
Controlling User Access – Data Control Language (DCL)
Extras
Conclusion
Pros & Cons
Comprehensive and well-structured course: Users appreciate the course for its comprehensive coverage of SQL topics, including advanced concepts like hierarchical queries and analytical functions. The course is also well-structured, making it easy for beginners to follow along and learn. Engaging and enthusiastic instructor: The instructor is praised for being engaging, positive, and enthusiastic throughout the course. Users find the instructor's teaching style to be effective in keeping them interested and motivated to learn.
Fast pace and difficulty understanding: Some users mention that the instructor goes too fast, making it difficult for them to understand the content. This can be a drawback for those who prefer a slower pace or have limited prior knowledge of SQL. Lack of text file for SQL statements and switching of tables: One user suggests that it would be helpful if the instructor provided a text file with a full list of SQL statements, allowing them to copy and paste the statements correctly instead of manually typing them. Additionally, the user mentions that they would have preferred if the instructor did not switch to newly imported tables midway through the course, as it caused confusion and loss of old data. The content is based on their experiences and opinions.
Course Provider
Provider Udemy's Stats at AZClass
Discussion and Reviews
0.0 (Based on 0 reviews)
Start your review of The Ultimate Oracle SQL Course: SQL Made Practical