[Leadership Archive] Performance Leadership (Performance Feedback and Employee Development)
kpcre
We'll share the know-how techniques of successful leaders by combining them with various real-world cases.
Beginner
leadership
To allow even beginners to easily approach SQL, everything from basic installation methods to fundamental knowledge, and even points beginners should especially note, has been presented clearly and simply for effortless access.
Can understand fundamental database concepts.
Understand Oracle Database installation environment and be able to use it after installation.
Understand function concepts, master function utilization, and apply them in practice.
Master SQL through diverse case studies.
As we enter the full-fledged big data era, the scope of SQL utilization is expected to expand further for extensive data analysis. Accordingly, there are users who are personally interested in SQL despite having no knowledge of databases, but there is also an increasing number of office workers who want to acquire related knowledge to meet the needs of their company. Therefore, we present everything from basic installation methods to basic knowledge and things that beginners should pay special attention to so that even beginners can easily access SQL, making it easy and clear to approach without difficulty.
Provides basic concepts and application methods of SQL that can be utilized in work even by people with no knowledge of databases.
We provide guidance from program installation to improving understanding of basic terminology so that even beginners can easily access it.
We provide practical training using real cases so that you can understand the concept of functions used in SQL, learn how to use functions, and apply them more easily in practice.
Topic-based learning is possible through micro-learning centered on core keywords that can be immediately applied in practice.
Database Concepts and Basic Terminology
Oracle Database Installation and Configuration
Selecting columns and rows
Specifying complex conditions and sorting data
Character and Number Functions
Date Operations and Date Functions
Conversion function
General functions
Group function
Windows Function
Understanding the join process and basic join statements
Join statements and set operators
Subquery
Inline views and scalar subqueries
Using INSERT · UPDATE · DELETE statements
Understanding objects
We have hired SQL experts to provide lectures that carefully select only the core skills required in the industrial field. We have hired instructors who are well-received for their in-depth lectures in companies, public institutions, and universities, and have provided specialized and differentiated content.
Currently, an instructor at the SQL division of the Korea Productivity Center
Current Multicampus SQL Department Instructor
Former) LG Uplus Corporation, Ingenious Technology Development Team
Former Samsung SDS General Development Department
Who is this course right for?
Novice users beginning SQL
All users wanting to improve SQL skills
Staff starting out in application development and database management.
All employees wishing to simplify complex applications using SQL
Career Verified
1,932
Learners
268
Reviews
28
Answers
4.7
Rating
220
Courses
As an affiliate of the Korea Productivity Center established in 1987, we provide essential job training for employees of corporations and public institutions.
We have developed job-duty-task-based educational content to strengthen practical skills, based on the actual 'work' that occurs in real corporate business environments.
Experience job training on a whole new level!
Homepage : https://www.kpcice.or.kr
All
36 lectures ∙ (8hr 15min)
Course Materials:
All
3 reviews
5.0
3 reviews
Reviews 1
∙
Average Rating 5.0
5
Hello, this is the Korea Institute for Social Competency Development. Thank you for your valuable evaluation. We will continue striving to provide helpful lectures in return.🙂 Thank you.
Reviews 1
∙
Average Rating 5.0
5
Hello. This is the Korea Social Skills Development Institute. Thank you for your valuable evaluation. We will continue to strive to provide helpful lectures in the future.🙂 Thank you.
Reviews 1
∙
Average Rating 5.0
5
Hello. This is the Korea Social Skills Development Institute. Thank you for your valuable feedback. We will continue to strive to provide helpful lectures in the future. 🙂 Thank you.
Check out other courses by the instructor!
Explore other courses in the same field!