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