The Complete Oracle SQL Certification Course

4.5 (21946)
Онлайн-курс
Payment
Обучение платное
Language
Английский
Duration
16.5 часов курса
Курс от Udemy
Чему вы научились?
Become Job Ready to Start Contributing as a Database Developer Day 1
Program in the SQL Language to Solve a Variety of Database Problems
Code along with me to PRACTICE and IMPLEMENT everything you learn
Become a SQL Ninja and Understand How the Oracle Database Works
MASTER the Content Required to Pass the Oracle 1Z0-071 Database SQL Exam
Obtain the Skills that are Necessary to Land a Job as a SQL Developer
Have the Ability to Solve any SQL Problem
О курсе

LAST UPDATED: JUNE 2020

(Source Code Included for Lectures)

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 I ask students to pause the video and complete the assignment before resuming to watch my solution. MAKE SURE YOU WORK OUT THE PROBLEMS ON YOUR OWN BEFORE MOVING ON TO MY SOLUTION!!

With over 62,000 enrolled students and a 4.5 star-rating, this is a Udemy best-selling course.

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."

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)
Программа
Database Basics
Learn the very basics of what is a database and how SQL is used to interact with it.
Oracle Database Introduction & Basics of Tables
Setting Up the SQL Development Environment (Mac & Windows)
IMPORTANT: Prepare the Data in the Database
In this lecture, we'll prepare the data in our database. This will setup the playground you'll need topractice SQLthroughout the course. Follow the instructions provided in this video for runningthe commandsin the accompanying file.
Single Table Queries (Exercises & Solutions in the Lectures)
Learn about the basic SELECT statement and how it can be used to retrieve data from a single table
Oracle Exams and Certification Information
Retrieving Data Using the SELECT Clause
Using the WHERE Clause in a Query
Using Operators in the WHERE Clause
Combining WHERE, AND & OR with Operators
Query Filtering Continued BETWEEN, IN and NULL
Query Filtering Conditions & Operator Precedence
Требования
  • Absolutely no programming experience is required to master the content in this course
Лекторы
Imtiaz Ahmad
Imtiaz Ahmad
Senior Software Engineer & Trainer @ Job Ready Programmer
Платформа
/storage/img/providers/udemy.svg
Курсы Udemy подойдут для профессионального развития. Платформа устроена таким образом, что эксперты сами запускают курсы. Все материалы передаются в пожизненный доступ. На этой платформе можно найти курс, без преувеличений, на любую тему – начиная от тьюториала по какой-то камере и заканчивая теоретическим курсом по управлению финансовыми рисками. Язык и формат обучения устанавливается преподавателем, поэтому стоит внимательно изучить информацию о курсе перед покупкой.
Рейтинг
4.5
(11974)
(8093)
(1902)
(284)
(126)
Комментарии (21946)
Похожие курсы
Как и любой другой веб-сайт, konevy использует файлы cookie. Эти файлы используются для хранения информации, включая предпочтения посетителей и страницы веб-сайта, которые он/она посещал. Информация используется для того, чтобы подстроить содержимое нашей страницы под тип браузера пользователя и другие параметры и таким образом улучшить его пользовательский опыт. Для получения более подробной информации о файлах cookie, пожалуйста, прочтите статью «Что такое файлы cookie»