강의

N
챌린지

멘토링

로드맵

Inflearn brand logo image
Programming

/

Database

Oracle SQL Database

Learn Oracle Database SQL syntax.

(4.9) 10 reviews

128 learners

  • javaspecialist
이론 실습 모두
도커
SQL
Oracle

Reviews from Early Learners

What you will learn!

  • Oracle Database SQL

  • Installing Oracle Database and Configuring a Practice Environment Using Docker

  • Data retrieval using SELECT

  • Oracle functions (characters, numbers, dates, regular expression functions, conversion functions, set operators)

  • Data aggregation using GROUP BY and group functions

  • Analytical function, window clause, linear regression function, pivot table

  • Oracle Join, ANSI Join

  • Subquery

  • DML(INSERT, UPDATE, DELETE, MERGE, CTAS)

  • Transaction COMMIT, ROLLBACK

  • Table creation and management (CREATE TABLE, ALTER TABLE, DROP TABLE)

  • Constraints

  • Creating and Managing Views

  • Sequence, Index, Synonym

Do you want to become a developer?

Learning SQL syntax for managing data in a database is the starting point for any developer. Learn SQL syntax using the Oracle database.

Features of this course

📌 You can learn more accurate and practical fundamental skills of Oracle SQL database.

📌 This course is taught by a Star Training Instructor expert with over 20 years of teaching and project experience.

📌 You can improve your skills through practice for each lesson and step.

📌 We teach you the essential skills you need to learn to become a backend developer.

I recommend this to these people

I want to learn databases.

Oracle SQL database is the most widely used in enterprises.

I'm working as a developer.
Backend development is a fundamental skill for developers. Without SQL, development is impossible.

Want to get a SQLD price certificate?
After completing your studies, challenge yourself to obtain the SQLD certification.

Who created this course

  • Java Expert Group Operator ( javaspecialist.co.kr )

  • Star Training Instructor recognized by the Ministry of Employment and Labor (2021 Information and Communications Field)


  • Information technology development, information technology strategic planning, artificial intelligence training instructors

💡 This lecture...

  • The lecture is given by a 2021 Information and Communications Technology Star Training Instructor recognized by the Ministry of Employment and Labor.

  • The course is taught by professional instructors with thorough fundamental knowledge and extensive experience in field projects.


Things to note before taking the course

Practice environment

  • Install a database using Docker on Windows.

  • Learn SQL syntax using Oracle's SQL Developer.

  • Even Mac users can use the database by installing Docker.

Learning Materials

Player Knowledge and Precautions

  • All you need is an interest in programming languages and the confidence to take the course to the end.

💡 If there are any notes needed for the lecture, please write them down carefully.
It can help students fully understand the content covered in the lecture and increase learning satisfaction.

  1. Practice environment

    • Operating System and Version (OS): Windows

    • Tools used: Docker Desktop, Oracle Database, SQL Developer

    • PC specifications: Any standard PC will do.

  2. Learning Materials

  3. Player Knowledge and Precautions

    • The learning difficulty is basic, but does not require any special pre-requisite knowledge.

    • All you need is passion for taking the class.

Recommended for
these people

Who is this course right for?

  • Backend Developer

  • Database Programming Developer

  • Web Application Developer

Hello
This is

1,011

Learners

75

Reviews

8

Answers

4.8

Rating

8

Courses

자바전문가그룹(JavaSpecialist.co.kr)이 인공지능의 성장을 지원합니다.

Curriculum

All

57 lectures ∙ (14hr 57min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

10 reviews

4.9

10 reviews

  • javaspecialist님의 프로필 이미지
    javaspecialist

    Reviews 8

    ∙

    Average Rating 5.0

    5

    98% enrolled

    Best Oracle SQL Course!!~~~

    • hyunseoung8142님의 프로필 이미지
      hyunseoung8142

      Reviews 2

      ∙

      Average Rating 5.0

      5

      32% enrolled

      • illay님의 프로필 이미지
        illay

        Reviews 2

        ∙

        Average Rating 5.0

        5

        61% enrolled

        Okay.

        • sblee6967님의 프로필 이미지
          sblee6967

          Reviews 2

          ∙

          Average Rating 5.0

          5

          32% enrolled

          • kwonsoonkyeong8977님의 프로필 이미지
            kwonsoonkyeong8977

            Reviews 1

            ∙

            Average Rating 5.0

            5

            98% enrolled

            Thank you for explaining it in detail and in an easy-to-understand manner. I think it would be good if you also opened a DBA course. Thank you for teaching with sincerity.

            $30.80

            javaspecialist's other courses

            Check out other courses by the instructor!

            Python library for data analysis and EDACourse Thumbnail

            Python library for data analysis and EDA

            javaspecialist

            We will cover the major Python libraries that you must learn to become a data analysis expert.

            Basic

            Basic

            Numpy, Pandas

            Python library for data analysis and EDACourse Thumbnail

            Python library for data analysis and EDA

            javaspecialist

            Python Programming from the Ground UpCourse Thumbnail

            Python Programming from the Ground Up

            javaspecialist

            A star instructor in IT development, artificial intelligence, and IT strategic planning provides an easy, detailed, and accurate explanation of the Python programming language.

            Basic

            Basic

            Python, Coding Test, programming-languages

            Python Programming from the Ground UpCourse Thumbnail

            Python Programming from the Ground Up

            javaspecialist

            Web Data Collection Techniques (Web Crawling) Used in PracticeCourse Thumbnail

            Web Data Collection Techniques (Web Crawling) Used in Practice

            javaspecialist

            Explanation of web data collection techniques using Python. Explanation of web data scraping using the latest technologies.

            Basic

            Basic

            Web Crawling, Web Scraping, browser-automation

            Web Data Collection Techniques (Web Crawling) Used in PracticeCourse Thumbnail

            Web Data Collection Techniques (Web Crawling) Used in Practice

            javaspecialist

            Development of AI web service using ChatGPT APICourse Thumbnail

            Development of AI web service using ChatGPT API

            javaspecialist

            This article explains how to develop an AI web service using the API from OpenAI.

            Basic

            Basic

            ChatGPT, AI, openAI API

            Development of AI web service using ChatGPT APICourse Thumbnail

            Development of AI web service using ChatGPT API

            javaspecialist

            Connecting a Java Spring Boot project with a Python AI projectCourse Thumbnail

            Connecting a Java Spring Boot project with a Python AI project

            javaspecialist

            Explaining how to connect to a Python-based AI web server using FastAPI from a Spring Boot project.

            Intermediate

            Intermediate

            Spring Boot, FastAPI, yolo

            Connecting a Java Spring Boot project with a Python AI projectCourse Thumbnail

            Connecting a Java Spring Boot project with a Python AI project

            javaspecialist

            Understanding and Implementing Artificial Neural Network Theory and DNN, CNN ArchitecturesCourse Thumbnail

            Understanding and Implementing Artificial Neural Network Theory and DNN, CNN Architectures

            javaspecialist

            We will introduce how to create deep learning models and CNN models using artificial neural network algorithms.

            Basic

            Basic

            Tensorflow, Artificial Neural Network, CNN

            Understanding and Implementing Artificial Neural Network Theory and DNN, CNN ArchitecturesCourse Thumbnail

            Understanding and Implementing Artificial Neural Network Theory and DNN, CNN Architectures

            javaspecialist

            Java Programming from the BasicsCourse Thumbnail

            Java Programming from the Basics

            javaspecialist

            A star trainer in IT development, artificial intelligence, and IT strategic planning provides an easy, detailed, and accurate explanation of the fundamentals of the Java programming language.

            Beginner

            Beginner

            Java, oop

            Java Programming from the BasicsCourse Thumbnail

            Java Programming from the Basics

            javaspecialist

            Similar courses

            Explore other courses in the same field!

            PYTHON written like SQLCourse Thumbnail

            PYTHON written like SQL

            pbj0812

            You can learn how to handle data frames (tables) using Python, similar to the SELECT statement in SQL.

            Basic

            Basic

            Python, SQL, Pandas

            PYTHON written like SQLCourse Thumbnail

            PYTHON written like SQL

            pbj0812

            Oracle PL/SQL Just This Much.. [Concept + Practice]Course Thumbnail

            Oracle PL/SQL Just This Much.. [Concept + Practice]

            itpaul

            This course provides developers/operators using Oracle with PL/SQL concepts and practical skills that can be immediately applied in the field.

            Basic

            Basic

            PL/SQL, SQL, Oracle

            Oracle PL/SQL Just This Much.. [Concept + Practice]Course Thumbnail

            Oracle PL/SQL Just This Much.. [Concept + Practice]

            itpaul

            [SQL Quest] Strengthen your SQL skills by solving real-world problems (Basic)Course Thumbnail

            [SQL Quest] Strengthen your SQL skills by solving real-world problems (Basic)

            WHIZ

            This course will solidify the basics of SQL through various problems that can be encountered in the actual IT industry. Solve the problem-solving quests, take the first step toward data analysis, and strengthen your SQL skills that can be applied in real life!

            Basic

            Basic

            SQL, sql-query, bigquery

            [SQL Quest] Strengthen your SQL skills by solving real-world problems (Basic)Course Thumbnail

            [SQL Quest] Strengthen your SQL skills by solving real-world problems (Basic)

            WHIZ

            [A hundred words are not as good as seeing once] Advanced SQL problem solving for data analysisCourse Thumbnail

            [A hundred words are not as good as seeing once] Advanced SQL problem solving for data analysis

            datarian

            Datalian's advanced SQL problem-solving lecture with over 10,000 cumulative students and rich online/offline lecture experience. We will solve several problems together to practice advanced SQL content.

            Intermediate

            Intermediate

            SQL

            [A hundred words are not as good as seeing once] Advanced SQL problem solving for data analysisCourse Thumbnail

            [A hundred words are not as good as seeing once] Advanced SQL problem solving for data analysis

            datarian

            [MMORPG Game Development Series with C# and Unity] Part 5: DatabaseCourse Thumbnail

            [MMORPG Game Development Series with C# and Unity] Part 5: Database

            Rookiss

            This course teaches MS-SQL through baseball/company databases.

            Basic

            Basic

            SQL, DBMS/RDBMS

            [MMORPG Game Development Series with C# and Unity] Part 5: DatabaseCourse Thumbnail

            [MMORPG Game Development Series with C# and Unity] Part 5: Database

            Rookiss

            For those who haven't even started with SQL, come hereCourse Thumbnail

            For those who haven't even started with SQL, come here

            coddatg

            Technology should also start with interest. I have prepared a story about a person who analyzes MBTI of his coworkers. I hope that those who have been daunted by SQL will start studying it with enjoyment.

            Beginner

            Beginner

            SQL, bigquery

            For those who haven't even started with SQL, come hereCourse Thumbnail

            For those who haven't even started with SQL, come here

            coddatg

            High-Performance SQL for JPA (ORM) DevelopersCourse Thumbnail

            High-Performance SQL for JPA (ORM) Developers

            Vlad Mihalcea

            Make the most of relational database systems!

            Intermediate

            Intermediate

            SQL, performance-tuning, sql-query

            High-Performance SQL for JPA (ORM) DevelopersCourse Thumbnail

            High-Performance SQL for JPA (ORM) Developers

            Vlad Mihalcea

            Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]Course Thumbnail

            Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]

            youngcodikimssam

            From Java basics to advanced concepts, and Oracle SQL too, Backend web development series with hands-on practice, taught by star instructor Young Cody Kim who explains clearly for non-majors and coding beginners

            Beginner

            Beginner

            Java, JSP, Spring

            Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]Course Thumbnail

            Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]

            youngcodikimssam

            SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questionsCourse Thumbnail

            SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions

            Masocampus

            From understanding SQL to using actual functions, Complete preparation for SQLD certification with the latest past exam questions!

            Beginner

            Beginner

            SQL, SQLD

            SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questionsCourse Thumbnail

            SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions

            Masocampus

            FastAPI Complete GuideCourse Thumbnail

            FastAPI Complete Guide

            dooleyz3525

            This course is designed to help you learn the core functions of FastAPI, as well as the entire process of web service development. Through this course, we will help you become a FastAPI expert developer needed in the field.

            Intermediate

            Intermediate

            Python, FastAPI, SQL

            FastAPI Complete GuideCourse Thumbnail

            FastAPI Complete Guide

            dooleyz3525

            SQL data analysis learned through various casesCourse Thumbnail

            SQL data analysis learned through various cases

            dooleyz3525

            By implementing various practical data analysis cases using SQL, you can simultaneously improve your data analysis and SQL utilization skills.

            Intermediate

            Intermediate

            SQL, PostgreSQL, DBMS/RDBMS

            SQL data analysis learned through various casesCourse Thumbnail

            SQL data analysis learned through various cases

            dooleyz3525

            3. Web Development Course [Spring Framework + e-Government Standard Framework]Course Thumbnail

            3. Web Development Course [Spring Framework + e-Government Standard Framework]

            vmproductor0202

            This is a lecture using the only domestic e-government framework and Layered Architecture, which are widely used in practice but not available in Korea. In this lecture, we will learn how to build the backend and server side of web development using the Spring Framework and the e-government standard framework.

            Beginner

            Beginner

            Spring, eGovFrame, spring-framework

            3. Web Development Course [Spring Framework + e-Government Standard Framework]Course Thumbnail

            3. Web Development Course [Spring Framework + e-Government Standard Framework]

            vmproductor0202