Microsoft SQL Server 2017 for Administration
Microsoft SQL Server 2017 for Administration is a 30-hour training course by IT Genius Institute. Microsoft SQL Server 2017 มาพร้อมคุณสมบัติใหม่ ๆ มากมาย ทั้งด้านการ monitoring, securing, optimizing พร้อมรองรับการทำงานพื้นฐานกับข้อมูลคุณ…
Training schedule
No public rounds are open right now — register your interest and we will contact you when the next round opens, or request an in-house session for your team.
Objectives
- เรียนรู้การ Implementing encryption
- การ Configuring backup and connection encryption
- สามารถสร้างกระบวนการ Import และ Export ข้อมูลทั้งอย่างง่ายและซับซ้อน
- เข้าใจและสามารถจัดการด้านความปลอดภัยสำหรับ Microsoft SQL Server ในเรื่อง Authentication, Authorization และ Auditing ได้
- สร้างกระบวนการจัดการอัตโนมัติผ่าน SQL Server Agent Service
- Creating and maintaining users
- Managing permissions and roles
- Configuring SQL Server auditing
- Developing a backup strategy
- Restoring databases
- Identifying and recovering from corruption
- Monitoring database activity and queries
- Managing indexes
- Managing statistics
- Monitoring instances
- Implementing log shipping
- Implementing always on availability groups
Who this course is for
- นักเรียนนักศึกษา
- ครู อาจารย์ วิทยากรที่สนใจ
- นักวิชาการ นักไอที หรือผู้ดูและระบบ
- ตลอดจนผู้สนใจทั่วไปใน Microsoft SQL Server 2017 สำหรับผู้ดูแลระบบ
Prerequisites
- พื้นฐานการใช้งานคอมพิวเตอร์ เช่น Copy , Paste สร้างไฟล์และโฟลเดอร์
- การใช้งานระบบปฎิบัติการ Windows / MacOS
- พื้นฐานการใช้งานฐานข้อมูลมาบ้าง
Curriculum
Module 1: Configure Encryption
- Encryption overview
- Implement cell-level encryption
- Configure transparent data encryption
- Implement Always Encrypted
- Implement backup encryption
- Configure encryption for connections
Module 2: Configure Data Access and Permissions
- Create and maintain users
- Manage database object permissions
- Create and maintain custom roles
- User options for Azure SQL Database
- Configure row-level security
- Configure dynamic data masking
Module 3: Configure Auditing
- SQL Server audits
- Create an audit on SQL Server
- Query the SQL Server audit log
- Configure an Azure SQL Database audit
- Analyze logs from Azure SQL Database
Module 4: Develop a Backup Strategy
- Back up very large databases
- Configure database recovery models
- Manage transaction log backups
- Configure backup automation
- Back up databases to Azure
Module 5: Restore Databases
- Automate and test restores
- Perform page recovery
- Restore file groups
- Perform piecemeal restores
Module 6: Manage Database Integrity
- Identify database corruption
- Implement database consistency checks
- Recover from database corruption
Module 7: Monitor Database Activity
- Monitor current sessions
- Identify causes of blocking activity
- Find sessions that use tempdb resources
- Configure the data collector
Module 8: Monitor Queries
- Manage the Query Store
- Configure trace events
- Identify problematic execution plans
- Server health and extended events
Module 9: Manage Indexes
- Identify and repair index fragmentation
- Identify and create missing indexes
- Identify and drop underutilized indexes
- Manage existing columnstore indexes
Module 10: Manage Statistics
- Statistics objects
- Identify and correct outdated statistics
- Implement auto update statistics
- Implement statistics for large tables
Module 11: Monitor SQL Server Instances
- Configure database mail
- Create and manage operators
- Create and manage SQL Server Agent alerts
- Define failure actions
- Identify available space on data volumes
- Introduction to Policy-Based Management
Module 12: Implement Log Shipping
- Log shipping overview
- Configure log shipping
Module 13: Implement Always On Availability Groups
- Configure Windows clustering
- Create an availability group
- Configure read-only routing
- Manage failover
- Create distributed availability groups
Module 14: Importing and Exporting Data
- Introduction to Transferring Data
- Importing and Exporting Table Data
- Implementing bcp and BULK Insert for Importing data
- Implementing Data-Tier Applications and upgrading
Module 15: Workshop and Exercise
- Live workshop and exercise
Frequently asked questions
Who is Microsoft SQL Server 2017 for Administration for, and what background is needed?
Built for นักเรียนนักศึกษา · ครู อาจารย์ วิทยากรที่สนใจ · นักวิชาการ นักไอที หรือผู้ดูและระบบ Background you should have: พื้นฐานการใช้งานคอมพิวเตอร์ เช่น Copy , Paste สร้างไฟล์และโฟลเดอร์ · การใช้งานระบบปฎิบัติการ Windows / MacOS Not sure the fit is right? Talk to our team on LINE @itgenius or call 02-570-8449.
How much does Microsoft SQL Server 2017 for Administration cost and how long does it run?
THB 12,500. The course runs 30 hours. The fee covers course materials, lunch and refreshments throughout. Pay by bank transfer to the company account, confirm it on our payment page, and we can issue the receipt or tax invoice in your company's name.
Do I get a certificate?
Yes. Everyone who completes the course receives a Certificate of Completion from IT Genius Institute. Each certificate carries its own number, and anyone holding that number can verify it online on our certificate page, so you can add it to your portfolio or pass it to HR as evidence of training.
Where does the training take place, and is there an online option?
You can attend onsite at IT Genius Institute or arrange to join online, and we also run it as a private in-house session for your team. Ask about dates and venues on LINE @itgenius or call 02-570-8449.
What if I fall behind or miss a session — can I retake it?
Yes. You may retake the same course free of charge in a later round, under the institute's conditions. Tell our team which course and round you attended, and we will check it and offer you the rounds that still have seats. Ask us on LINE @itgenius or call 02-570-8449.
How do I enrol, or request a quotation for my company?
Enrol online with the registration form on this page. You can register several attendees at once and enter your tax ID and billing address for the tax invoice. Or request a company quotation straight from the quote button. For anything else call 02-570-8449 or reach us on LINE @itgenius.
Instructors
Run this course for your whole team
We run this course in-house, tailored to your stack.
Corporate training quote