This course is about structured Query Language – SQL- features – American National Standard Institute – applying them using exercises – examples – Following is the content-
SQL Introduction,SQL Joins,SQL Date Time Values, Date Functions,Time Functions,TimeStamDiff ,SQL Scalar Functions,Casting Data Types,Case Statement,UNION, UNION ALL ,Recursive CTE,OLAP Functions,Store Procedure,Troubleshooting Steps ,Real Time Examples
This enables students to understand basic concepts behind features of ANSI SQL – Stress is on practical use of the features in querying the database of any type. All the Relational Database Management Systems (RDMS) like MySQL, MS Access, Oracle, Sybase, Informix, Postgres and SQL Server use SQL as their standard database language. Student will be comfortable in using any of these data bases.