Database administration

Lecture "Administration and visualization: Chapter 3.1 - Data modelling and databases" provides students with content about: Data model; Data modeling; Ralational data model; Data modeling process;... Please refer to the detailed content of the lecture!

56p gaupanda031 20-05-2024 10 4   Download

Lecture "Administration and visualization: Chapter 3.2 - Data modelling and databases OLTP & OLAP" provides students with content about: Overview; OLTP vs OLAP; Data warehouse modeling; Data warehouse design; Data warehouse Implementation;... Please refer to the detailed content of the lecture!

71p gaupanda031 20-05-2024 6 4   Download

Upon completion of this lesson, the successful participant will be able to: Understand the need for and importance of database administration; learn different ways of processing a database; understand the need for concurrency control, security, and backup and recovery; learn typical problems that can occur when multiple users process a database concurrently; understand the use of locking and the problem of deadlock;…

62p tangtuy17 11-07-2016 40 2   Download

In the knowledge byte section, tell the students about how to use the copy database wizard to copy or move databases and related objects to a different database server or another SQL Server instance. When using the copy database wizard you must have database administrator permissions on both the source and destination servers. Also, ensure that the second instance of SQL Server is installed, with the name SERVER\SECOND.

46p anhgau456 25-11-2015 40 3   Download

The VLAN Trunking Protocol (VTP) allows you to simplify the management of the VLAN database across multiple switches. As the number of switches increases on a small- or mediumsized business network, the overall administration required to manage VLANs and trunks in a network becomes a challenge.The VLAN Trunking Protocol (VTP) allows you to simplify the management of the VLAN database across multiple switches. Benefits: VLAN configuration consistency across the entire network. Accurate tracking and monitoring of VLANs. Dynamic reporting of added VLANs across a network....

43p vanmanh1008 21-05-2013 63 5   Download

10 câu lệnh T-SQL Index cần thiết với DBA .Những người SQL Server DBA (Database Administrator) – quản trị cơ sở dữ liệu biết rất rõ rằng các danh mục Index trong database rất giống với Index trong mục Library. Hoặc hiểu theo cách đơn giản rằng Index trong Database là 1 hệ cấu trúc có liên kết chặt chẽ với các bảng để nhanh chóng thu thập thông tin từ các dòng trong bảng đó.

12p badaovl 18-05-2013 102 7   Download

Cài Oracle cần như sau: 1. Tạo 2 Groups: đặc tên là oinstall và dba 2. Tạo 1 User account tên là: oracle (note: Đúng ra đặt là Tí Tèo gì củng được, nhưng conventional, thấy thiên hạ cài Oracle hay đặt là vậy.) Login as root, run: � # groupadd oinstall # groupadd dba # useradd -m -g oinstall -G dba oracle Tạo password cho user: oracle # passwd oracle Changing password for user oracle. New UNIX password: Retype new UNIX password: passwd: all authentication tokens updated successfully.

7p gcsvpn 28-02-2013 63 7   Download

Redundant Arrays of Inexpensive Disks Technology (RAID)

12p trinh02 28-01-2013 55 5   Download

Small shared pool Small database buffer cache Small redo log buffer cache Missing indexes Rollback segments and undo tablespace Sort area size incorrectly set Assorted

16p trinh02 28-01-2013 54 6   Download

Example of Statspack Report

38p trinh02 28-01-2013 41 3   Download

Globalization Support Features Globalization Support ensures that database utilities and error messages, sort order, date, time, monetary, numeric, and calendar conventions automatically adapt to the native language. Oracle currently supports 57 languages, 88 territories, 84 linguistic sorts (71 monolingual and 13 multilingual), and 235 encoded character sets. The language-dependent operations are controlled by a number of parameters and environment variables on both the client and the server sides. The server and the client may run in the same or different locations.

42p trinh02 28-01-2013 73 5   Download

After completing this lesson, you should be able to do the following: Describe the features of multitable inserts Use the following types of multitable inserts Unconditional INSERT Pivoting INSERT Conditional ALL INSERT Conditional FIRST INSERT Create and use external tables Name the index at the time of creating a primary key constraint

30p trinh02 28-01-2013 50 6   Download

After completing this lesson, you should be able to do the following: Use the Oracle tuning methodology to diagnose and resolve performance problems Use Oracle tools to diagnose performance problems Understand the goals of the workshop

14p trinh02 28-01-2013 69 5   Download

Data Loading Methods Several methods are available for loading data into tables in an Oracle database. Of the methods available, Direct Load insert and SQL*Loader are discussed here. Export and Import are covered in the Oracle9i Database Administration Fundamentals II course. SQL*Loader SQL*Loader loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that places little limitation on the format of the data in the data file. Direct Load Direct Load insert can be used to copy data from one table to another table within the same database.

40p trinh02 28-01-2013 69 5   Download

After completing this lesson, you should be able to do the following: Describe different system architectures Describe the primary steps of OS tuning Identify similarities between OS and DB tuning Understand virtual memory and paging Explain the difference between a process and a thread

14p trinh02 28-01-2013 46 5   Download

After completing this lesson, you should be able to do the following: Interpret the concept of a hierarchical query Create a tree-structured report Format hierarchical data Exclude branches from the tree structure

18p trinh02 28-01-2013 44 3   Download

Auditing If an unauthorized user is deleting data, then the DBA might decide to audit all connections to the database and all successful and unsuccessful deletions from all tables in the database. The DBA can gather statistics about which tables are being updated, how many logical inputs/outputs (I/Os) are performed, and how many concurrent users connect at peak times.

16p trinh02 28-01-2013 52 9   Download

After completing this lesson, you should be able to do the following: Set up Database Resource Manager Assign users to Resource Manager groups Create resource plans within groups

34p trinh02 28-01-2013 48 3   Download

After completing this lesson, you should be able to do the following: Write a multiple-column subquery Describe and explain the behavior of subqueries when null values are retrieved Write a subquery in a FROM clause Use scalar subqueries in SQL Describe the types of problems that can be solved with correlated subqueries Write correlated subqueries Update and delete rows using correlated subqueries Use the EXISTS and NOT EXISTS operators Use the WITH clause

36p trinh02 28-01-2013 51 5   Download

Oracle provides for easy and controlled privilege management through roles. Roles are named groups of related privileges that are granted to users or to other roles. They are designed to ease the administration of privileges in the database. Role characteristics Roles can be granted to and revoked from users with the same commands that are used to grant and revoke system privileges. Roles can be granted to any user or role. However, a role cannot be granted to itself and cannot be granted circularly. A role can consist of both system and object privileges.

28p trinh02 28-01-2013 45 3   Download