|
Duration: 2 days
Languages: Slovenian, English, Croatian, Serbian, Bosnian
Price: 790,00 EUR + VAT per delegate
Literature: All delegates receive presentation handouts
This course is for Internal Auditors, IT Auditors, IT Directors, IT operational staffs, Risk Managers, Quality Managers.
No events scheduled for this category!
Click link below to see course calendar.read more
About the course
Objectives of SQL Server course is, to introduce the participants to SQL Server environment and acquaintance with basic knowledge and skills needed to perform a review of SQL Server.
Participants will be able to:
- Describe basics of relational databases and evolution of database management systems (DBMS).
- Explain common concepts: databases, data models,tables and views, databse management systems (DBMS) and their roles in the organization.
- Describe database related risks.
- Describe access paths to information stored in a database.
- Describe authentication methods used in SQL Server.
- Explain the use of default, public and service accounts.
- Identify characteristics of default, public and service accounts.
- Describe stored procedures,- Determine purpose of stored procedures.
- Determine common risks and pitfalls while auditing stored procedures.
- Describe what is SSMS?
- Identify important functions of SSMS.
- Where to execute queries in SSMS.
- How to create reports in SSMS.
- Identify most important screens in SSMS tool.
- Describe meaning of data backup and restoration for database.
- Define different scenarios for data backup and restoration of database.
- Identify key difference between SQL Server 2005 and 2008.
- Description of reasons for organizations against upgrade to newer versions.
- Define audit approach and impact of new versions.
|
