Inflearn brand logo image
Inflearn brand logo image
Inflearn brand logo image
Programming

/

Database

Easy and Fun SQL Server Operation Stories with Teacher Jangrae (Basic Edition)

Learn the easy and fun story of SQL Server operations from a Microsoft Certified Trainer! We explain core operational technologies that you can learn and use right away, and that are truly needed in the field, step by step so that even beginners can easily understand.

(5.0) 7 reviews

91 learners

  • jangrae
서버
백엔드
db
데이터베이스
MSSQL
DBMS/RDBMS

Reviews from Early Learners

What you will learn!

  • SQL Server Installation and Service Management

  • Creating and managing databases with performance and stability in mind.

  • Various database backup and recovery methods

  • How to create an account and control permissions for enhanced security.

  • Automating operational tasks using data transfer and agent services

Learn from a Microsoft Certified Instructor with 25 years of experience
MS SQL Server Operation Story! ✅

SQL Server Operation, Easy and Fun for Beginners! 📙

Based on SQL Server 2022 version, you will systematically learn SQL Server installation, database management, backup and restoration, permission management, data transfer, and operational task automation technologies.

1️⃣ Learn SQL Server operation skills by systematically studying various topics such as the following.

  • SQL Server Installation and Service Management
    • Download and install the latest SQL Server 2022 version
    • Download and install Management Studio
    • Managing Services and TCP/IP Connections Using Configuration Manager
  • Create and maintain a database
    • Understanding database structure
    • Creating various types of databases
    • Understanding and Using File Groups
    • Understanding the different database options
    • Increase and decrease database size
    • Move database files to another location
  • Database Backup and Restore
    • Understand different backup methods and backup strategies
    • Perform full, differential, and transaction log backups
    • Set up database backup compression
    • Understand restore methods by backup strategy
    • Restoring databases in various situations
    • Point-in-time restore using transaction backups
  • Account Creation and Permission Management
    • Create a login account and manage permissions
    • Create database user accounts and manage permissions
    • Controlling access to objects
  • Data transfer
    • Transferring data between SQL Servers
    • Transferring data between Excel and SQL Server
    • Query SQL Server data in real time from Excel
    • Configuring Linked Servers Between SQL Servers
  • Automation of operational tasks
    • Configuring the SQL Server Agent Service
    • Automating operational tasks using tasks
    • Configuring Backup Automation Using the Maintenance Plan Wizard
  • Bonus, slightly advanced operating skills
    • Automated monitoring with database mail
    • Reverting mistakes with database snapshots
    • Block file connection and restore with database encryption

2️⃣ We use a realistic training environment configured to resemble an actual operating environment.


Easy! Tea! Thousand! 👍
Learning little by little
SQL Server Operational Technology

Through operating offline studies, lectures, seminars, etc. for a long time, I know better than anyone the minds of those who are just starting out, so I conduct classes easily + step by step + slowly from a beginner's perspective.

1️⃣ Section Introduction

Make sure you have thoroughly studied the material covered in the previous sections. Provide a general overview of the material covered in the new section along with a message of encouragement, giving you enough time to prepare before attending the lecture.

2️⃣ Theory class

First, learn the overall content through systematically organized PPT materials. By learning why you need to learn the technology and how to use it, you will stimulate your desire to learn.

3️⃣ Operational training

You will learn all the actual operational technologies by utilizing the Windows Server 2016 + SQL Server 2022 environment configured in the same form as the actual field server. Based on long-term field experience, we will explain the parts that are really necessary, so you will acquire operational technologies that can be used immediately in the field.

🧭 Over 20 years of teaching, practical, and consulting experience

  • With over 10 years of experience running a study program, I fully understand the feelings of those just starting out.
  • I conduct easy and fun lectures based on the know-how I have accumulated through over 20 years of experience in training centers and corporate lectures.
  • Provides the best learning opportunity for those who are new to SQL Server.
  • Based on our extensive consulting experience, we cover operational technologies that are truly needed in the field.

Who created this course 👨‍🦰

Book

  • Author of 『Enjoying the Special World of DB SQL Server Development Edition』, Ruby Paper
  • Author of 『A Special World Enjoyed with DB: SQL Server Operations』, Ruby Paper
  • Written by 『SQL Server 2012 Operation and Development with Lee Jang-rae』, IT Forum
  • Author of 『SQL Server Security Guide for Protecting Personal Information』, Microsoft

Teaching and teaching experience

  • Job training for SKT technical new recruits (JT)
  • KT Aible School 1st to 3rd Data Expert Training Course
  • GS EPS Data Analysis Advanced Course
  • SetrackEye Database Administrator Course
  • CJ Daehan Transportation SQL Server Monitoring and Optimization Process
  • SK C&C Data Preprocessing, Analysis Practice, Machine Learning Course
  • Daegu Bank Data Expert Training Course
  • KT Future Talent Development Project Data Preprocessing, Machine Learning Course
  • National Tax Service (Seoul, Daegu) SQL Course for Forensic Investigation
  • SK Networks DA (Data Architect) Training Course
  • SQL Course for Hyosung TNS Developers
  • Hanla Group Python Data Analysis Visualization Course
  • POSCO E&C Data Analysis Visualization Process
  • POSCO ICT Data Analysis Process
  • SK Networks Data Expert Training Course
  • CJ Olive Networks new employee training course, etc.

Q&A🔍

Q. Do I need to know SQL statements?

This course is a SQL Server operation course. Most of the operation techniques use the user interface of SQL Server Management Studio. Therefore , it does not matter at all if you do not know SQL statements. There are only a few SQL statements used in the lecture, but they are very simple statements that you can understand at a glance. If you can use only a keyboard and mouse, you will have no problem in approaching this course.

Q. Which version of SQL Server is it targeting?

Currently, the latest version of SQL Server is version 2022. The class will be conducted in an environment where SQL Server 2022 Developer Edition is installed on Windows Server 2016. However, you will learn the skills that are really necessary for operating SQL Server, and these operating skills are common to all versions of SQL Server. Therefore, this lecture can be helpful to those who use SQL Server 2008 or later .

Q. Do I need to purchase related textbooks?

This lecture video is based on the special world of DB SQL Server operation, but you do not necessarily need to purchase the related textbook. The lecture proceeds with sufficient theoretical explanation and actual operation method. If you do not fully understand the lecture video, or if you are interested in content not covered in the lecture video, it would be a good idea to purchase the textbook.

Q. Is there anything I need to prepare before attending the lecture?

You can learn effectively just by watching the lecture videos without actually installing SQL Server. However, if you learn by installing SQL Server on your own PC and practicing operating technology, the learning effect will be greater. The lecture will be conducted by configuring an actual operating environment, but you can install and use SQL Server on your own PC. Therefore, it is recommended to prepare a PC with Windows 10 or higher operating system installed .

Recommended for
these people

Who is this course right for?

  • For those who want to install and operate SQL Server

  • For those who are in charge of SQL Server operation at their company

  • Individuals interested in database management system operations

Hello
This is

290

Learners

20

Reviews

24

Answers

4.9

Rating

3

Courses

  • 현) 디프렌즈 대표

  • 현) 마이크로소프트 공인 강사

  • 전) 마이크로소프트 데이터플랫폼 MVP

  • 전) 씨퀄로 수석 컨설턴트

  • 전) 웹타임교육센터 전임강사

  • 전) 푸르덴셜생명보험 정보시스템 책임

[강의분야]

  • 데이터베이스 개발자, 운영자 과정

  • 데이터베이스 쿼리 튜닝 및 최적화 과정

  • 파이썬, 데이터 전처리, 시각화 과정

  • 파이썬 기반 데이터 분석, 머신러닝 과정

[저서]

  • 디비로 누리는 특별한 세상, SQL Server 개발편

  • 디비로 누리는 특별한 세상, SQL Server 운영편

  • 이장래와 함께하는 SQL Server 운영과 개발 등

Curriculum

All

56 lectures ∙ (9hr 28min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

7 reviews

5.0

7 reviews

  • parkbk1195082님의 프로필 이미지
    parkbk1195082

    Reviews 6

    Average Rating 3.2

    5

    61% enrolled

    • cafetasse4303님의 프로필 이미지
      cafetasse4303

      Reviews 6

      Average Rating 5.0

      5

      30% enrolled

      The lectures are so easy to understand and comfortable to follow! It's not boring at all, and I understand it so well. The explanations flow like water!

      • bestyum8826님의 프로필 이미지
        bestyum8826

        Reviews 1

        Average Rating 5.0

        5

        61% enrolled

        If you want to have a basic understanding of SQL, I recommend you take this course.

        • kimnzang199795님의 프로필 이미지
          kimnzang199795

          Reviews 1

          Average Rating 5.0

          Edited

          5

          57% enrolled

          Good lecture. Please be sure to give intermediate or advanced level lectures too, even if you are busy.

          • yeonhongmin9780님의 프로필 이미지
            yeonhongmin9780

            Reviews 15

            Average Rating 4.7

            5

            7% enrolled

            I like it because it's a very informative lecture that can be completed in one day.

            $58.30

            jangrae's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!