DBAFYI - DBA Resource Center

This site is a resource center for database administrators (DBA). It includes latest DBA job opportunities, DBA technical articles and DBA job interview questions and answers.

Current Job Opportunities for Developers

Are you looking for a job? We have selected a collection of good job opportunities for you. See the current job opportunities listed below:

More...

Database Administrator (DBA) Articles

Are you a DBA? Need to update your database administration knowledge? We have selected a big collections of articles for you...

More...

Tutorials, FAQs and Tips Directory Edited by FYIcenter.com NEW

A comprehensive directory of well written tutorials with 300+ entries and growing. All entries are reviewed and edited by FYIcenter.com. Free submission. More...

Tutorial FAQs/Tips for DBA and Developers - 1075 Entries

It doesn't matter whether you are a beginner or an experienced DBA or database developer, browse through our tutorial tips. They will always help you to improve your skills and find some good ideas to solve your coding problems. So far, Our DBA have written 1075 tutorial tips to share with you. Each one of them answers one commonly asked question with a short, but precise and clear tutorial. More tips will be available soon. Please come back to visit this page again.

SQL Server DBA FAQs and Tips - 442 Questions/Tutorials NEW

• Downloading and Installing SQL Server 2005 Express Edition (14 questions)
• Getting Started with Transact-SQL Statements (10 questions)
• Creating and Managing Databases and Physical Files (16 questions)
• Creating/Managing Tables and Adding/Altering/Deleting Columns (16 questions)
• Understanding INSERT, UPDATE and DELETE Statements (18 questions)
• Understanding SELECT Statements with Joins and Subqueries (17 questions)
• Understanding SELECT Statements and GROUP BY Clauses (20 questions)
• Introduction To Transact-SQL Language Basics and Data Types (19 questions)
• Transact-SQL Constants/Literals and Value Ranges (18 questions)
• Transact-SQL Numeric Expressions and Functions (14 questions)
• Transact-SQL Managing Character Strings and Binary Strings (14 questions)
• Transact-SQL Date and Time Operations and Functions (18 questions)
• Transact-SQL Boolean Values and Logical Operations (14 questions)
• Transact-SQL Conditional Statements and Loops (5 questions)
• Downloading and Installing Sample Scripts and Databases (6 questions)
• Understanding and Managing Indexes (23 questions)
• Understanding and Managing Views (20 questions)
• Transact-SQL Understanding Stored Procedures (19 questions)
• Transact-SQL Understanding User Defined Functions (17 questions)
• Creating and Managing Schemas (11 questions)
• Introduction to Triggers (20 questions)
• Introduction to Cursors (9 questions)
• Introduction to NULL Values (11 questions)
• Security - Server Login and Database User (17 questions)
• Configuring ODBC Connection and DSN for SQL Servers (13 questions)
• PHP ODBC Functions - Connection and Query Execution (14 questions)
• PHP ODBC Functions - Managing Tables and Data Rows (14 questions)
• PHP MSSQL Functions - Connections and Query Execution (18 questions)
• PHP MSSQL Functions - Managing Tables and Data Rows (17 questions)

MySQL Tutorials and Tips - 268 Questions/Tutorials

• Downloading and Installing MySQL on Windows (7 tutorials)
• Administrator Tools for Managing MySQL Server (16 tutorials)
• Command-Line End User Interface mysql (10 tutorials)
• Introduction to SQL Basics (26 tutorials)
• Introduction to SQL Date and Time Handling (15 tutorials)
• Understanding SQL CREATE, ALTER and DROP Statements (17 tutorials)
• Understanding SQL INSERT, UPDATE and DELETE Statements (17 tutorials)
• SQL SELECT Query Statements with GROUP BY (20 tutorials)
• SQL SELECT Statements with JOIN and Subqueries (16 tutorials)
• Managing User Accounts and Access Privileges (17 tutorials)
• Server Daemon mysqld Administration (12 tutorials)
• PHP Connections and Query Execution (18 tutorials)
• Managing Tables and Running Queries with PHP Scripts (18 tutorials)
• Storage Engines: MyISAM, InnoDB and BDB (15 tutorials)
• Transaction Management: Commit or Rollback (24 tutorials)
• Database Basics and Terminologies (20 entries)

Oracle DBA FAQs and Tips - 400 Questions/Tutorials

• Understanding Oracle Basic Concepts (19 questions)
• Introduction to Oracle Database 10g Express Edition (21 questions)
• Understanding SQL Basics (28 questions)
• Understanding SQL DDL Statements (12 questions)
• Understanding SQL DML Statements (15 questions)
• Understanding SQL SELECT Query Statements (33 questions)
• Understanding SQL Transaction Management (22 questions)
• Managing Oracle User Accounts, Schema and Privileges (23 questions)
• Managing Oracle Database Tables (17 questions)
• Managing Oracle Table Indexes (14 questions)
• Managing Oracle Tablespaces and Data Files (17 questions)
• Creating New Database Instance Manually (15 questions)
• Introduction to PL/SQL language (17 questions)
• Introduction to Oracle SQL Developer (29 questions)
• Understanding PL/SQL language basics (22 questions)
• Creating your own PL/SQL procedures (26 questions)
• Working with Database Objects in PL/SQL (23 questions)
• Working with Cursors in PL/SQL (19 questions)
• Loading and Exporting Data (27 questions)

Sarlary Information for Database Administrator (DBA)

Looking for Database Administrator (DBA) job? Or looking for a raise? You need to know how much are you worth in today's job market. Read the detailed salary report on Database Administrator (DBA) professionals.

The Best Jobs In America

The Top 10 / Top 50 Best Jobs - Software engineer, College professor, Financial advisor, Human resources manager, Physician's assistant,Market research analyst,Real estate appraiser,Pharmacist,Psychologist..... More

Interview Questions and Answers

Need to prepare for a job interview? We have selected a big collection of interview questions and answers for you.

More...

Remote Mirroring of an Oracle Database - Installation Guide

An easy to follow installation guide to install and configure remote mirror of an Oracle database on various operating system. It covers the following areas: Topics include: Remote Volume Mirroring Requirements; Preinstallation Tasks; Remote Volume Mirroring Solution Installation; Oracle Configuration on AIX, Sun and Linux Operating Systems.

Oracle 11g Database - 2 Day Developer's Guide

An easy to follow tutorial guide for database developers to learn basics on using Oracle 11g database server. It covers 7 main areas: 1 Overview of Oracle Database and Development; 2 Querying and Manipulating Data; 3 Creating and Using Database Objects; 4 Developing and Using Stored Procedures; 6 Working in a Global Environment; 7 Deploying a Database Application.

Progress Database Administration Guide and Reference

When administering a Progress database, it is important to understand its architecture and the configuration options it supports. This chapter presents an overview of the Progress Version 9 database.

Interview Questions and Answers Database

Need to prepare for a job interview? Try this interview questions and answers database. It has a nice full-text search function. If you have a good interview question, share it with us by submitting it to the database. Go to interview question database.