Skip to content

JobReadyProgrammer/The-Complete-Oracle-SQL-Certification-Course

Repository files navigation

Don't Just Learn the SQL Language, Become Job-Ready and Launch Your Career as a Certified Oracle SQL Developer!

Alt text

This GitHub Repository will include the Source Code for the Complete Oracle SQL Certification Course

(Work in progress ⏳)

Note for newcomers

Checkout our complete course on the following platforms:

  1. Udemy
  2. Job Ready Programmer (JRP)
  3. JRP Membership (Includes Data Analyst & Software Developer Career Paths)

About the course :

  • Get ready to acquire some seriously marketable programming skills! You can't consider yourself a complete end to end developer until you can code in SQL.
  • Today, data has become the hottest topic in technology and a company's biggest asset is their data.
  • All databases require the language SQL to store and retrieve data.
  • Salaries for junior level SQL Developers are upwards of $70,000 - $90,000 dollars a year!
  • The great thing is, for this course, you do not need any prior experience in programming what so ever.
  • SQL is a different animal and we're going to demystify the language from scratch and prepare you with plenty of progressively challenging assignments so that by the time you've completed the course (in 2 months), you can call your self an Oracle SQL Master!
  • Oracle is the most popular relational database in the world!
  • This course will prepare you to be job-ready in just 1 month of study and practice.
  • All exercises and solutions are in the lectures. In several lectures we ask students to pause the video and complete the assignment before resuming to watch our solution.
  • With over 195,000 enrolled students and a 4.5 star-rating, this is a Udemy best-selling course.

Topics covered in this course :

  • Basics of Tables
  • SELECT and WHERE Clause
  • WHERE, AND & OR with Operators
  • BETWEEN, IN and NULL
  • Single Table Queries
  • Single Row Functions
  • Grouping Functions
  • GROUP BY and HAVING Clause
  • Joins
  • Inner and Outer Joins
  • EXISTS & NOT EXIST Operators
  • Creating Your Own Tables
  • Using ALTER
  • Creating Tables with SELECT & UPDATE Data
  • DELETE, TRUNCATE, and DROP Commands
  • System Tables, Pseudo Columns & Deleting Duplicates (Newly Added)
  • Views and Other Objects and Commands (Newly Added)

Testimonials

  • Do you have no prior experience in SQL development? This course is perfect for you. Don't take it from me, take it from actual students that took this course:
    • "I am a beginner and the way this course starts is perfect for the person who has no introduction of SQL or Oracle."
  • Do you have prior experience, but need a refresher or to fine-tune your skills? This is the course for you. Again, I'll let my students do the talking:
    • "I had a good base of knowledge from my last employment. This course is constantly proving useful to supercharge my actual knowledge base. Very good one!"
  • Have you taken a SQL course before, but felt confused on certain topics or not completely satisfied in your abilities? A lot of my students had shared similar concerns:
    • "I had previously taken a college course about databases and SQL, but these ten hours of content were more clear and useful than the course and textbook."

Contact us

About Imtiaz Ahmad

  • Imtiaz Ahmad is an award-winning Udemy Instructor who is highly experienced in big data technologies and enterprise software architectures.
  • Imtiaz has spent a considerable amount of time building financial software on Wall St. and worked with companies like S&P, Goldman Sachs, AOL and JP Morgan along with helping various startups solve mission-critical software problems.
  • In his 13+ years of experience, Imtiaz has also taught software development in programming languages like Java, C++, Python, PL/SQL, Ruby and JavaScript.
  • He’s the founder of Job Ready Programmer — an online programming school that prepares students of all backgrounds to become professional job-ready software developers through real-world programming courses.
  • Take the twin highway of Learning Data Analysis and Software Development on a single platform: Job Ready Programmer

Alt text

Releases

No releases published

Packages

No packages published