Home

Tutorials, FAQs and Tips for Software Developers

MySQL Tutorials and Tips - 268 Questions/Tutorials

This is a collection of tutorials and tips for MySQL DBA and developers. Clear answers and sample scripts provided can be used as learning tutorials or interview preparation guides.

It doesn't matter whether you are a beginner or an experienced MySQL DBA or developer, browse through our MySQL DBA FAQ and tips. They will always help you to improve your skills and find some good ideas to solve problems in your daily tasks.

So far, Our MySQL developers have written 268 questions and answers to share with you. Each one of them answers one commonly asked MySQL question with a short, but precise and clear tutorial script. More questions will be available soon. Please come back to visit this page again.

• 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)

More...

Oracle DBA FAQs and Tips - 400 Questions/Tutorials

This is a collection of FAQ and tips for Oracle DBA and developers. The clear answers and sample scripts provided can be used as learning tutorials or interview preparation guides.

It doesn't matter whether you are a beginner or an experienced Oracle DBA or developer, browse through our Oracle DBA FAQ and tips. They will always help you to improve your skills and find some good ideas to solve problems in your daily tasks.

So far, Our Oracle developers have written 400 questions and answers to share with you. Each one of them answers one commonly asked Oracle question with a short, but precise and clear SQL script. More questions will be available soon. Please come back to visit this page again.

• 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)

More...

SQL Server DBA FAQs and Tips - 442 Questions/Tutorials

This is a collection of FAQ and tips for SQL Server DBA and developers. The clear answers and sample scripts provided can be used as learning tutorials or interview preparation guides.

It doesn't matter whether you are a beginner or an experienced SQL Server DBA or developer, browse through our SQL Server DBA FAQ and tips. They will always help you to improve your skills and find some good ideas to solve problems in your daily tasks.

So far, Our SQL Server developers have written 442 questions and answers to share with you. Each one of them answers one commonly asked Oracle question with a short, but precise and clear SQL script. More questions will be available soon. Please come back to visit this page again.

• 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)

More...