Sql administrator

Bài giảng Cơ sở dữ liệu nâng cao - Chapter 5: Automating administrative tasks. Những nội dung chính được trình bày trong chương này gồm có: Automating administrative tasks in SQL server, SQL server agent, creating maintenance plans.

19p nomoney10 05-04-2017 79 7   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

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

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: 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

Managing Privileges A privilege is a right to execute a particular type of SQL statement or to access another user’s object. These include the right to: Connect to a database Create a table Select rows from another user’s table Execute another user’s stored procedure System privileges Each system privilege allows a user to perform a particular database operation or class of database operations; for example, the privilege to create tablespaces is a system privilege.

26p trinh02 28-01-2013 73 5   Download

Profiles A profile is a named set of the following password and resource limits: Password aging and expiration Password history Password complexity verification Account locking CPU time Input/output (I/O) operations Idle time Connect time Memory space (private SQL area for Shared Server only) Concurrent sessions After a profile has been created, the database administrator can assign it to each user. If resource limits are enabled, the Oracle server limits the database usage and resources to the defined profile of the user....

38p trinh02 28-01-2013 50 5   Download

This workshop covers: Creating tables and sequences Modifying data in the tables Modifying table definitions Creating views Writing scripts containing SQL and iSQL*Plus commands Generating a simple report

14p trinh02 28-01-2013 73 4   Download

After completing this lesson, you should be able to do the following: Control optimizer options Use optimizer hints Employ plan stability Use stored outlines Use SQL Trace and TKPROF

32p trinh02 28-01-2013 51 4   Download

After completing this lesson, you should be able to do the following: List the operations that use temporary space Create and monitor temporary tablespaces Identify actions that use the temporary tablespace Describe the use of disk and memory for sorting Identify the SQL operations that require sorts Differentiate between disk and memory sorts List ways to reduce total sorts and disk sorts Determine the number of memory sorts performed Set parameters to optimize sorts

32p trinh02 28-01-2013 45 6   Download

Built-In Database Objects In addition to creating the database files, several other structures are created. Data dictionary: Contains descriptions of the objects in the database Dynamic performance tables: Contains information used by the database administrator (DBA) to monitor and tune the database and instance PL/SQL packages: Program units adding functionality to the database. These packages are created when the catproc.sql script is run after the CREATE DATABASE command. PL/SQL packages will not be discussed within the scope of this course.

20p trinh02 28-01-2013 63 4   Download

Overview of Primary Components The Oracle architecture includes a number of primary components, which are discussed further in this lesson. Oracle server: There are several files, processes, and memory structures in an Oracle server; however, not all of them are used when processing a SQL statement. Some are used to improve the performance of the database, to ensure that the database can be recovered in the event of a software or hardware error, or to perform other tasks necessary to maintain the database. The Oracle server consists of an Oracle instance and an Oracle database.

48p trinh02 28-01-2013 92 8   Download

SQL statements are not case sensitive. SQL statements can be on one or more lines. Keywords cannot be abbreviated or splitacross lines. Clauses are usually placed on separate lines. Indents are used to enhance readability.

40p trinh02 28-01-2013 48 6   Download

On occasion you will need to perform some tasks using SQL*Plus and/or the operating system command line. In Practice 2, you will start an SQL*Plus session. Continue to keep the SQL*Plus session open to accomplish those tasks done in SQL*Plus. When performing tasks that require the operating system command line, an [ ! ] will be used from the SQL*Plus command line to get you out of SQL*Plus and into the operating system command line mode. Once you have completed your work on the operating system command line you can return to the SQL*Plus command line...

86p trinh02 28-01-2013 56 7   Download

Lab scripts have been included in the lab exercises to perform certain tasks for you. The task being accomplished may be one that you have not learned at the point of the exercise or it may be that the task is being accomplished for your convenience. When asked to run a .sql script, take time to review the script before running it. This will provide you with a thorough understanding of what is actually being created for you, and how it affects the task you are about to accomplish in the practice....

100p trinh02 28-01-2013 53 4   Download

In either case, the easiest way is to drop the entire tablespace that contains the datafile. The steps that are to be executed from within SQL*Plus are: 1. STARTUP MOUNT 2. For each deleted datafile, issue the command ALTER DATABASE DATAFILE ’full path of filename’ OFFLINE [DROP]; Note: You must use the DROP option if the database is in NOARCHIVELOG mode, because you cannot recover this file if you apply incomplete media recovery on it via the command ALTER DATABASE OPEN RESETLOGS. See the SQL Reference for details. 3. ALTER DATABASE OPEN; 4.

14p trinh02 28-01-2013 47 4   Download

Loading Data 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. SQL*Loader SQL*Loader loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts little limitation on the format of the data in the datafile. Direct-Load insert Direct-load insert can be used to copy data from one table to another table within the same database.

32p trinh02 28-01-2013 67 4   Download

The distinction between data administration and database administration. The purpose and tasks associated with data administration and database administration. The scope of database security. Why database security is a serious concern for an organization. The type of threats that can affect a database system. How to protect a computer system using computer-based controls

21p cuongbkav 02-12-2012 63 4   Download

Trong bài này chúng ta sẽ tìm hiểu một chút lý thuyết về backup và restore database trong SQL Server. Chiến Lược Phục Hồi Dữ Liệu (Data Restoration Strategy) Có một điều mà chúng ta phải chú ý là hầu như bất kỳ database nào cũng cần được phục hồi vào một lúc nào đó trong suốt chu kỳ sống của nó. Là một người Database Administrator bạn cần phải giảm tối đa số lần phải phục hồi dữ liệu, luôn theo dõi, kiểm tra thường xuyên để phát hiện các trục trặc trước khi nó xảy ra. Phải dự...

20p suthebeo 17-07-2012 251 46   Download

SQL Databases Using SQL databases in Android. Android (as well as iPhone OS) uses an embedded standalone program called sqlite3 which can be used to: create a database, define SQL tables, indices, queries, views, triggers Insert rows, delete rows, change rows, run queries and administer a SQLite database file.

77p lvtcit 13-06-2012 109 25   Download