DBA – MySQL, PostgreSQL, MongoDB, Oracle
Background: To make the user interface more friendly in nature it’s a good approach displaying an Alert Message when MS Access Query returns no value to its corresponding recordset. How To: By using the MS Access RecordsetClone and RecordCount Property we can return a message with an empty recordset. If Me.RecordsetClone.RecordCount <= 0 Then MsgBox (“No records…
Background: It might be needed to change WordPress site URL for example from http://domain.com to http://www.domain.com and vice versa. Workaround: My test blog’s original site URL was http://tutorial.kaysariqbal.com; intend to prefix the site with www so the site will look like http://www.tutorial.kaysariqbal.com. To make Change WordPress Site URL i had to work on cPanel of…
Background: For a newly purchased domain WordPress software needs to be installed at first hand to make the site up and running. In this tutorial we will see how to install WordPress on a new site. Workaround: If we have already purchased a new domain and hosted it under any hosting service provider then we…
This oracle tutorial is about using sub-queries in SQL SELECT statements in Oracle Database 11g. A subquery is a query that put inside a main query and pass the results of the query to the main query.A subquery in the FROM clause of a SELECT statement is also called an inline view. A subquery in…
I had to arrange training session on Database Management System to my colleagues which used oracle as backend. This oracle tutorial includes: Cross joins Natural joins USING clause Table alias ON clause OUTER joins Cartesian product Download: Displaying data from multiple tables
Background: Sometime it needs calling sub routine in MS Access VBA on another form or in same form to perform certain tasks on the current intended command execution as a pre-requisite of the process. There might also be needed to call a subroutine on the main from the sub-form. In addition to that calling the sub-routine from another…
This Oracle Tutorial: Using single-row or multiple-row functions contains the lessons mentioned below: Types of SQL Functions Single Row Functions Number Functions Character Functions Date Functions Conversion Functions General Functions Multiple Row/Aggregate Functions Restricting Group results With HAVING Clause Nesting Group Functions Download: Using single-row or multiple-row functions to customize output
This Oracle Tutorial: Retrieving data using SQL SELECT statements contains the below Topics: Limiting rows in SELECT statement Character Strings and Dates Comparison Operators Logical Operators Sorting Rows Substitution Variables Download: Retrieving data using SQL SELECT statements
From Start > Go to SQL Server configuration manager Expand: SQL Server network configuration Choose: Protocols for database Right Click on TCP/IP and Enable From Start > Go to SQL Server services Restart: SQL Server instance(database) From Start > Go to Control panel > Administrative tools > ODBC data sources 64/32 bit Choose: System DSN…
I had to arrange training session over Database Management System to my colleagues which used oracle as backend. This “Oracle Tutorial: SQL SELECT Statements” is about basics of DBMS, SQL and SELECT statements. Includes: Types of SQL statement Arithmetic Operators and Precedence Null Values Column Alias Concatenation Operator/Literal Character String Duplicate Rows/DISTINCT keyword Download: SQL Select…