There is a trend developing in business for non IT people to understand and use SQL (structured query language) to query relational database management systems. Business people new to databases (how they actually work and why they are designed in particular ways) need to grasp some basic database concepts before tackling the intricacies of SQL.
This SQL training course is provided for people with minimum understanding of relational databases (Access, Oracle, SQL Server, MySQL etc) who just want to demystify relational database management systems.
The Objective is to close the gap between ICT professionals and non-ICT professionals. Usually non-ICT professionals are left in dark when involved in projects that involves relational Database management systems (RDMS), these non-ICT professionals are also at the mercy of the ICT professional.
This course will expose non-ICT professional and upcoming ICT professional to the fact that SQL is an easy and high interactive language. SQL is also one of the needed tools for forensic audit
Select data from one table Alias columns
Rationalizing result sets with DISTINCT
Derive columns with arithmetic and concatenation
Cull records with the Where clause and relational operators
Expand the Where clause with logical operators AND and OR
Sort result sets with the Order By clause and nested sort orders
Understand and use relational and logical operators (use the keywords AND, OR, BETWEEN, NOT, IN, LIKE, TOP and IS NULL)
‘Grade’ a result set with TOP in conjunction with ORDER BY
Retrieve aggregated data into grand totals and subtotals using GROUP BY
Filter aggregated result sets with HAVING
UNION, INTERSECT and EXCEPT queries
Create subtotals and totals with COMPUTE and COMPUTE BY
Apply output selection logic to the select clause with simple and searched CASE
Join multiple tables in a query (INNER joins, OUTER (LEFT, RIGHT and FULL) joins, CROSS joins)
Table aliasing and ‘self’ joins
Further aggregation with multiple dimensions using ROLLUP, CUBE, the GROUPING function and the CASE statement combined
Queries that use sub-queries
Use the view builder to form the basis of a SQL statement
Use SELECT INTO to create tables from existing data
The importance and use of intrinsic SQL functions
Understand common SQL Server data types, data type precedence and implicit versus explicit data type conversion
Who Should Attend?
BVS Training Centre, 21 Adenuga Taiwo behind Fidson Headquarters Obanikoro Lagos.
=N=150,000.00 per participant. This fee covers all course materials, Tea and lunch break
was able to secure a promotion with the acquisition of knowledge on SQL and PL-SQL — Ada Daobi
took part in the Creating Professional Documents using the Advanced Features of Word 2010/2010 Course, and my office hours have become more productive. — john attah