장래쌤과 함께하는 쉽고 재미있는 파이썬 이야기
장래쌤
전문 강사에게서 배우는 쉽고 재미있는 파이썬 이야기! 처음 배우는 분들을 위해 차근차근 강의를 진행합니다. 충분히 반복하며 학습할 수 있는 기회를 제공합니다.처음 파이썬을 배우는 분들에게 든든한 디딤돌이 될 것입니다.
입문
Python, 객체지향
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.
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
297
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
G PAKReviews 7
∙
Average Rating 3.4
- cafetasse
Reviews 6
∙
Average Rating 5.0
- bestyum
Reviews 1
∙
Average Rating 5.0
- kimnzang19
Reviews 1
∙
Average Rating 5.0
Edited
- yeonhong.min
Reviews 15
∙
Average Rating 4.7
$58.30
jangrae's other courses
Check out other courses by the instructor!
Similar courses
Explore other courses in the same field!
![[개념은 호옹~, 실습 빡] SQL 데이터 분석, 활용!강의 썸네일](https://cdn.inflearn.com/public/courses/328743/cover/59aa0ed0-cf2f-4cdc-b508-6cf8d652c563/328743-eng-original.png?f=avif&w=420)
![[개념은 호옹~, 실습 빡] SQL 데이터 분석, 입문!강의 썸네일](https://cdn.inflearn.com/public/courses/328741/cover/e1d1e473-ef71-403e-93ef-63db6a7eba72/328741-eng-original.png?f=avif&w=420)
![[C#과 유니티로 만드는 MMORPG 게임 개발 시리즈] Part5: 데이터베이스강의 썸네일](https://cdn.inflearn.com/public/courses/325283/course_cover/afb413e6-681e-47cd-808a-099c79fed112/rookiss-rpg-5.jpg?f=avif&w=420)
