|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-oracle-engineer-toad-ssmsdata-migration/
课程评论：没有评论
课程名称：SQL Server Oracle 工程师 - （TOAD, SSMS, 数据迁移） 课程概述：随着数据的增长和依赖，SQL Server 数据库工程师的需求日益增加。SQL Server 是 Microsoft 开发的一种关系数据库管理系统，旨在企业环境中使用。SQL Server 工程师的日常工作包括： - 确认备份文件已成功保存到安全位置，检查备份失败警报，修正错误并重新运行备份，评估备份平均持续时间并调查显著变化的原因；通常这可能由于网络带宽低导致。 - 通过进行“恢复验证”来验证备份文件的有效性，创建作业以处理任务，如有备份验证失败则发送通知。 - 定期监控和识别性能阻塞问题，检查所有生产服务器上的性能计数器，确保所有计数器在正常范围内，并通过收集相关数据定期监控性能，创建索引以减少 T-SQL 脚本执行后获取响应所需的时间。 - 安全性方面，检查审计日志以发现失败的登录尝试，并在必要时通知审计团队，实施相关权限以防止未授权访问 SQL Server 数据库。 T-SQL（Transact-SQL）是使用 SQL Server 的核心，所有与 SQL Server 实例通信的应用程序均通过发送 T-SQL 语句与服务器交互。T-SQL 是 Microsoft 专有的标准 SQL（结构化查询语言）版本。使用 T-SQL 可完成以下任务： - 从数据库中检索数据 - 更新数据 - 向数据库插入数据 - 删除数据 在信息技术行业，Oracle 数据库工程师的需求也持续增长，快速增长的数据使得数据库管理员的需求变得更加迫切。我们在日常生活中越来越依赖数据，例如通过社交媒体使用 Facebook、Instagram、WhatsApp、Twitter 等数据丰富的应用程序。数据迁移是数据库工作人员必须具备的重要技能。本课程将使用 Oracle 提供的免费强大工具 Oracle SQL Developer，将第三方数据库从 Microsoft SQL Server 迁移到 Oracle。
SQL Server Database Engineers are in hot demand due to the growth and reliance on data.SQL Server is a relational database management system from Microsoft that's designed for the enterprise environment.Some of the key daily responsibilities of a SQL Server Engineer includes:Confirm that backups have been made and successfully saved to a secure location Check the backup failure alerts, correct the errors and rerun the backups Review the average duration of backup, any significant changes occurred investigates on this.Most of the time it happens due to networking low bandwidth Validate the backup files using restore verify only. Jobs can be created to take care of the task and to send a notification if it fails to verify any backup.Performance Regularly monitor and identify blocking issues. Check Performance counters on all production servers and verify that all counters are within the normal range. Throughout the day, periodically monitor performance by collecting relevant data Create indexes to reduce the time it takes to get responses from the SQL Server after a T-SQL Script is executed.Security Check the auditing logs for failed logins and notify the audit team if necessary Implement relevant permissions to prevent authorized access to SQL Server databasesT-SQL ( Transact -SQL )Transact-SQL is central to using SQL Server. All applications that communicate with an instance of SQL Server do so by sending Transact-SQL statements to the server, regardless of the user interface of the application. T-SQL is Microsoft's proprietary version of the standard SQL(Structural Query language)Using T-SQL you can communicate with SQL Servers to perform task like:Retrieving data from the database Updating data Inserting data into databases Deleting dataOracle Database Engineers are in constant demand in the IT industry.The rapid growth of data has fueled the demand for database administrator's in general. We are more than before reliant on data in our everyday life either through the use of social media with applications like Facebook,Instagram Whatsapp ,Twitter and may more data rich applications.Data Migration is an important function anyone working with a database should be able to carry out.There are several tools available to perform database and data migration. In this course we will be using a free powerful tool by Oracle called Oracle SQL Developer to migrate a third party database from Microsoft SQL Server into Oracle.
