Knowledge (XXG)

Database administrator

Source đź“ť

1442: 972: 1452: 1462: 962: 443: 1052: 1035: 477: 1047: 293: 867: 210: 764: 455: 1486: 1445: 897: 707: 181:
Training for DBAs with accompanying certifications is widely available, offered by database vendors and third parties. Offerings include:
1118: 1007: 882: 579: 1465: 965: 94: 1171: 1422: 1069: 892: 877: 806: 760: 1501: 1491: 1361: 913: 355: 240: 872: 727: 674: 61:
Databases, RDBMS, SQL, distributed computing, operating systems, storage technologies, networking, maintenance, recovery
409: 1387: 1106: 785: 669: 297: 266: 381: 1310: 1300: 1076: 928: 801: 697: 617: 1397: 1130: 1496: 887: 692: 1356: 1346: 1000: 822: 215: 1059: 1427: 1382: 770: 572: 98: 1402: 844: 166: 162: 1156: 535: 506: 1455: 1392: 1274: 1244: 1113: 1064: 918: 780: 637: 154: 1412: 1305: 1290: 1217: 1042: 938: 642: 220: 1407: 1351: 1320: 1269: 1101: 993: 975: 859: 849: 737: 485: 451: 1161: 1227: 1081: 943: 923: 742: 719: 565: 110: 90: 1417: 1264: 1254: 1222: 832: 652: 622: 170: 138: 319: 1325: 1295: 1249: 1030: 827: 775: 752: 664: 632: 627: 607: 150: 146: 142: 114: 102: 1377: 1315: 1259: 1232: 1125: 1086: 839: 732: 702: 612: 106: 17: 1480: 1196: 1181: 122: 185:
IBM Certified Advanced Database Administrator – DB2 10.1 for Linux, Unix and Windows
948: 337: 1186: 1166: 1330: 1239: 1201: 1176: 985: 647: 933: 514: 421: 188:
IBM Certified Database Administrator – DB2 10.1 for Linux, Unix, and Windows
71:
BS or MS in comp sci; associate degree or certificate with work experience
1191: 1146: 1016: 684: 602: 588: 86: 1096: 118: 1091: 158: 478:"Oracle Certified Professional, MySQL 5.6 Database Administrator" 133:
Required skills for database administrators include knowledge of
1151: 989: 561: 417: 194:
Oracle MySQL 5.6 Database Administrator Certified Professional
134: 557: 173:, routine maintenance, recovery, and replication/failover. 356:"Database Administrator: Job Description and Requirements" 191:
Oracle Database 12c Administrator Certified Professional
382:"How Do I Become a Certified Database Administrator?" 1370: 1339: 1283: 1210: 1139: 1023: 906: 858: 815: 794: 751: 718: 683: 595: 65: 57: 52: 42: 37: 1001: 573: 292:Spenik, Mark; Sledge, Orryn (20 March 2001). 8: 32: 211:Comparison of database administration tools 1008: 994: 986: 580: 566: 558: 404: 402: 338:"Roles and Responsibilities - Oracle FAQ" 294:"What is a Database Administrator? (DBA)" 410:"IBM Professional Certification Program" 232: 31: 7: 1461: 961: 200:MCSE Data Platform Solutions Expert 167:distributed computing architectures 25: 1460: 1450: 1441: 1440: 971: 970: 960: 1451: 296:. Developer.com. Archived from 444:"Oracle Certification Program" 149:, specific databases, such as 1: 914:Database-centric architecture 267:"What does a DBA do all day?" 247:. Bureau of Labor Statistics 1487:Database management systems 1017:Database management systems 1518: 1423:Object–relational database 929:Locks with ordered sharing 761:Entities and relationships 618:Database management system 109:, performance monitoring, 1436: 1398:Federated database system 1131:Blockchain-based database 957: 807:Object–relational mapping 241:"Database Administrators" 320:"Oracle DBA job skills" 216:Database administration 89:. The role may include 1428:Transaction processing 1383:Database normalization 1326:Query rewriting system 79:database administrator 48:Information Technology 33:Database Administrator 18:Database Administrator 1403:Referential integrity 708:information retrieval 536:"MCSE: Data Platform" 1502:Database specialists 1492:Computer occupations 1393:Distributed database 919:Intelligent database 197:MCSA SQL Server 2012 163:storage technologies 155:Microsoft SQL Server 1413:Relational calculus 1291:Concurrency control 728:Activity monitoring 324:Burleson Consulting 221:Database management 85:) manages computer 34: 27:Software profession 1408:Relational algebra 1352:Query optimization 1157:Armstrong's axioms 898:Online real estate 507:"MCSA: SQL Server" 486:Oracle Corporation 452:Oracle Corporation 424:on 29 October 2004 273:. techrepublic.com 67:Education required 1474: 1473: 1082:Wide-column store 1077:Document-oriented 983: 982: 944:Halloween Problem 924:Two-phase locking 883:Facial expression 802:Abstraction layer 743:Negative database 698:Data manipulation 458:on 4 October 2011 171:operating systems 91:capacity planning 75: 74: 16:(Redirected from 1509: 1464: 1463: 1454: 1453: 1444: 1443: 1418:Relational model 1388:Database storage 1265:Stored procedure 1010: 1003: 996: 987: 974: 973: 964: 963: 582: 575: 568: 559: 552: 551: 549: 547: 532: 526: 525: 523: 521: 503: 497: 496: 494: 492: 474: 468: 467: 465: 463: 454:. Archived from 440: 434: 433: 431: 429: 420:. Archived from 406: 397: 396: 394: 392: 378: 372: 371: 369: 367: 352: 346: 345: 334: 328: 327: 316: 310: 309: 307: 305: 289: 283: 282: 280: 278: 263: 257: 256: 254: 252: 237: 139:database queries 44:Activity sectors 35: 21: 1517: 1516: 1512: 1511: 1510: 1508: 1507: 1506: 1497:Data management 1477: 1476: 1475: 1470: 1432: 1378:Database models 1366: 1335: 1321:Query optimizer 1296:Data dictionary 1279: 1250:Transaction log 1206: 1162:Codd's 12 rules 1135: 1065:Column-oriented 1031:Object-oriented 1019: 1014: 984: 979: 953: 902: 854: 811: 790: 747: 714: 693:Data definition 679: 591: 586: 556: 555: 545: 543: 542:. microsoft.com 534: 533: 529: 519: 517: 505: 504: 500: 490: 488: 476: 475: 471: 461: 459: 442: 441: 437: 427: 425: 408: 407: 400: 390: 388: 380: 379: 375: 365: 363: 354: 353: 349: 336: 335: 331: 318: 317: 313: 303: 301: 300:on 13 June 2011 291: 290: 286: 276: 274: 265: 264: 260: 250: 248: 239: 238: 234: 229: 207: 179: 147:database design 143:database theory 131: 115:troubleshooting 103:database design 68: 45: 28: 23: 22: 15: 12: 11: 5: 1515: 1513: 1505: 1504: 1499: 1494: 1489: 1479: 1478: 1472: 1471: 1469: 1468: 1458: 1448: 1437: 1434: 1433: 1431: 1430: 1425: 1420: 1415: 1410: 1405: 1400: 1395: 1390: 1385: 1380: 1374: 1372: 1371:Related topics 1368: 1367: 1365: 1364: 1359: 1354: 1349: 1347:Administration 1343: 1341: 1337: 1336: 1334: 1333: 1328: 1323: 1318: 1316:Query language 1313: 1308: 1303: 1298: 1293: 1287: 1285: 1281: 1280: 1278: 1277: 1272: 1267: 1262: 1257: 1252: 1247: 1242: 1237: 1236: 1235: 1230: 1225: 1214: 1212: 1208: 1207: 1205: 1204: 1199: 1194: 1189: 1184: 1179: 1174: 1169: 1164: 1159: 1154: 1149: 1143: 1141: 1137: 1136: 1134: 1133: 1128: 1123: 1122: 1121: 1111: 1110: 1109: 1099: 1094: 1089: 1084: 1079: 1074: 1073: 1072: 1062: 1057: 1056: 1055: 1050: 1040: 1039: 1038: 1027: 1025: 1021: 1020: 1015: 1013: 1012: 1005: 998: 990: 981: 980: 958: 955: 954: 952: 951: 946: 941: 936: 931: 926: 921: 916: 910: 908: 904: 903: 901: 900: 895: 890: 885: 880: 875: 870: 864: 862: 856: 855: 853: 852: 847: 842: 837: 836: 835: 825: 823:Virtualization 819: 817: 813: 812: 810: 809: 804: 798: 796: 792: 791: 789: 788: 783: 778: 773: 768: 757: 755: 749: 748: 746: 745: 740: 735: 730: 724: 722: 716: 715: 713: 712: 711: 710: 700: 695: 689: 687: 681: 680: 678: 677: 672: 667: 662: 657: 656: 655: 650: 640: 635: 630: 625: 620: 615: 610: 605: 599: 597: 593: 592: 587: 585: 584: 577: 570: 562: 554: 553: 527: 498: 469: 435: 398: 373: 347: 342:www.orafaq.com 329: 311: 284: 258: 231: 230: 228: 225: 224: 223: 218: 213: 206: 203: 202: 201: 198: 195: 192: 189: 186: 178: 175: 130: 127: 73: 72: 69: 66: 63: 62: 59: 55: 54: 50: 49: 46: 43: 40: 39: 26: 24: 14: 13: 10: 9: 6: 4: 3: 2: 1514: 1503: 1500: 1498: 1495: 1493: 1490: 1488: 1485: 1484: 1482: 1467: 1459: 1457: 1449: 1447: 1439: 1438: 1435: 1429: 1426: 1424: 1421: 1419: 1416: 1414: 1411: 1409: 1406: 1404: 1401: 1399: 1396: 1394: 1391: 1389: 1386: 1384: 1381: 1379: 1376: 1375: 1373: 1369: 1363: 1360: 1358: 1355: 1353: 1350: 1348: 1345: 1344: 1342: 1338: 1332: 1329: 1327: 1324: 1322: 1319: 1317: 1314: 1312: 1309: 1307: 1304: 1302: 1299: 1297: 1294: 1292: 1289: 1288: 1286: 1282: 1276: 1273: 1271: 1268: 1266: 1263: 1261: 1258: 1256: 1253: 1251: 1248: 1246: 1243: 1241: 1238: 1234: 1231: 1229: 1226: 1224: 1221: 1220: 1219: 1216: 1215: 1213: 1209: 1203: 1200: 1198: 1197:Surrogate key 1195: 1193: 1190: 1188: 1185: 1183: 1182:Candidate key 1180: 1178: 1175: 1173: 1170: 1168: 1165: 1163: 1160: 1158: 1155: 1153: 1150: 1148: 1145: 1144: 1142: 1138: 1132: 1129: 1127: 1124: 1120: 1117: 1116: 1115: 1112: 1108: 1105: 1104: 1103: 1100: 1098: 1095: 1093: 1090: 1088: 1085: 1083: 1080: 1078: 1075: 1071: 1068: 1067: 1066: 1063: 1061: 1058: 1054: 1051: 1049: 1046: 1045: 1044: 1041: 1037: 1034: 1033: 1032: 1029: 1028: 1026: 1022: 1018: 1011: 1006: 1004: 999: 997: 992: 991: 988: 978: 977: 968: 967: 956: 950: 947: 945: 942: 940: 937: 935: 932: 930: 927: 925: 922: 920: 917: 915: 912: 911: 909: 905: 899: 896: 894: 891: 889: 886: 884: 881: 879: 876: 874: 871: 869: 866: 865: 863: 861: 857: 851: 848: 846: 843: 841: 838: 834: 831: 830: 829: 826: 824: 821: 820: 818: 814: 808: 805: 803: 800: 799: 797: 793: 787: 784: 782: 779: 777: 774: 772: 771:Normalization 769: 766: 762: 759: 758: 756: 754: 750: 744: 741: 739: 736: 734: 731: 729: 726: 725: 723: 721: 717: 709: 706: 705: 704: 701: 699: 696: 694: 691: 690: 688: 686: 682: 676: 673: 671: 668: 666: 663: 661: 660:Administrator 658: 654: 651: 649: 646: 645: 644: 641: 639: 636: 634: 631: 629: 626: 624: 621: 619: 616: 614: 611: 609: 606: 604: 601: 600: 598: 594: 590: 583: 578: 576: 571: 569: 564: 563: 560: 541: 537: 531: 528: 516: 512: 511:microsoft.com 508: 502: 499: 487: 483: 479: 473: 470: 457: 453: 449: 445: 439: 436: 423: 419: 415: 411: 405: 403: 399: 387: 383: 377: 374: 361: 357: 351: 348: 343: 339: 333: 330: 325: 321: 315: 312: 299: 295: 288: 285: 272: 268: 262: 259: 246: 242: 236: 233: 226: 222: 219: 217: 214: 212: 209: 208: 204: 199: 196: 193: 190: 187: 184: 183: 182: 177:Certification 176: 174: 172: 168: 164: 160: 156: 152: 148: 144: 140: 136: 128: 126: 124: 123:data recovery 120: 117:, as well as 116: 112: 108: 104: 100: 99:configuration 96: 92: 88: 84: 80: 70: 64: 60: 56: 51: 47: 41: 36: 30: 19: 969: 959: 949:Log shipping 893:Online music 878:Biodiversity 845:Preservation 659: 603:Requirements 544:. Retrieved 539: 530: 518:. Retrieved 510: 501: 491:18 September 489:. Retrieved 481: 472: 460:. Retrieved 456:the original 447: 438: 426:. Retrieved 422:the original 413: 389:. Retrieved 385: 376: 364:. Retrieved 359: 350: 341: 332: 323: 314: 302:. Retrieved 298:the original 287: 275:. Retrieved 270: 261: 249:. Retrieved 244: 235: 180: 132: 95:installation 82: 78: 76: 58:Competencies 29: 1466:WikiProject 1357:Replication 1245:Transaction 1187:Foreign key 1167:CAP theorem 1114:Multi-model 966:WikiProject 795:Programming 786:Cardinality 781:Refactoring 638:Application 362:. study.com 53:Description 1481:Categories 1331:Query plan 1284:Components 1202:Unique key 1119:comparison 1053:comparison 1043:Relational 1036:comparison 939:Publishing 873:Biological 816:Management 648:datasource 643:Connection 546:4 November 520:3 November 482:oracle.com 448:oracle.com 391:4 November 366:4 November 304:6 February 271:11/04/2015 251:4 November 245:11/04/2015 227:References 38:Occupation 1340:Functions 1275:Partition 1102:In-memory 1060:Key–value 934:Load file 850:Integrity 840:Migration 767:notation) 738:Forensics 685:Languages 540:11/4/2015 515:Microsoft 428:10 August 386:learn.org 360:11/4/2015 107:migration 87:databases 1446:Category 1362:Sharding 1218:Relation 1192:Superkey 1147:Database 1140:Concepts 976:Category 907:See also 868:Academic 860:Lists of 765:Enhanced 720:Security 589:Database 277:19 April 205:See also 111:security 1456:Outline 1255:Trigger 1211:Objects 833:caching 623:Machine 462:18 June 414:ibm.com 1270:Cursor 1228:column 1097:NewSQL 888:Online 828:Tuning 776:Schema 753:Design 633:Server 628:Engine 613:Models 608:Theory 151:Oracle 129:Skills 119:backup 1260:Index 1223:table 1126:Cloud 1092:NoSQL 1087:Graph 1024:Types 763:(and 733:Audit 703:Query 675:Tools 670:Types 159:MySQL 157:, or 1311:ODBC 1301:JDBC 1240:View 1177:Null 1172:CRUD 1152:ACID 1107:list 1070:list 1048:list 665:Lock 596:Main 548:2015 522:2015 493:2016 464:2011 430:2014 393:2015 368:2015 306:2012 279:2021 253:2015 121:and 1306:XQJ 1233:row 653:DSN 418:IBM 135:SQL 83:DBA 1483:: 538:. 513:. 509:. 484:. 480:. 450:. 446:. 416:. 412:. 401:^ 384:. 358:. 340:. 322:. 269:. 243:. 169:, 165:, 161:, 153:, 145:, 141:, 137:, 125:. 113:, 105:, 101:, 97:, 93:, 77:A 1009:e 1002:t 995:v 581:e 574:t 567:v 550:. 524:. 495:. 466:. 432:. 395:. 370:. 344:. 326:. 308:. 281:. 255:. 81:( 20:)

Index

Database Administrator
databases
capacity planning
installation
configuration
database design
migration
security
troubleshooting
backup
data recovery
SQL
database queries
database theory
database design
Oracle
Microsoft SQL Server
MySQL
storage technologies
distributed computing architectures
operating systems
Comparison of database administration tools
Database administration
Database management
"Database Administrators"
"What does a DBA do all day?"
"What is a Database Administrator? (DBA)"
the original
"Oracle DBA job skills"
"Roles and Responsibilities - Oracle FAQ"

Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.

↑