We offer a 3-day course that cover the essentials of SQL Server
Are you an Oracle Database Administrator (DBA), looking to support SQL Server databases after a migration project? Check out this course, especially if you need to get spun up quickly on SQL Server 2017. Learn the essentials of SQL Server 2017, along with the things you need to be successful in running SQL Server within your organization.
Get an overview of SQL Server 2017, and take a look at new features and specifications. Compare the basics of SQL Server and its functionality with Oracle database applications, security features, and specifications. Explore high availability and disaster recovery in SQL Server 2017. Plus, hear about the basics of SQL Server monitoring and performance tuning, in addition to the metrics to watch.
This is a three-day training course. Day 1 & 2 training will be based on the Oracle University training for beginning DBAs/developers that will compare and contrast Oracle features and processes with SQL Server 2017 capabilities. This section will consist of 12 modules that include one module on migrating an Oracle database with the latest version of SSMA to SQL Server 2017.
Day 3 training will be based on the SQL Server 2017 training to demonstrate to Oracle DBAs the differentiating features of 2017 that might include, but not limited to: R-Integration, PolyBase, Power BI, Cortana Analytics, etc.
Throughout the training, we cover how your team’s Linux experience translates to running SQL Server 2017 on Linux.
Here are 6 main topics that will be covered during the course.
- Overview of SQL Server 2017
Get an overview of SQL Server 2017 and the new features and specifications of this software.
- Server Essentials
Explore Windows Server and SQL Server tools and learn configuration techniques.
- Database Essentials
Learn about the basics of SQL Server and its functionality, and compare them with Oracle database applications.
- Security Essentials
Get the basics on SQL Server security, and compare them with Oracle database security features and specifications.
- High Availability and Disaster Recovery Essentials
Explore the basics of SQL Server high availability and disaster recovery functionality in SQL Server 2017.
- Monitoring and Performance Tuning Essentials
Take a look at the basics of SQL Server monitoring and performance tuning, along with some of the tools used and the metrics to keep an eye on.