SQL Tutorial For Intermediate

by Randall C. Moore

What is SQL?SQL is a database query language we use it for operating databases. It is used for storing and managing data in Relational DBMS, the operations included are creation, deletion, modifying rows, etc. SQL is standardized by ANSI (American National Standards Institute).Let us learn in detail about SQL.SQL is a Relational Database Management Systems (RDMS), that is, it is a standard language for Relational Database system.Examples of RDMS are MySQL, MS Access, Oracle, Sybase, Informix, Postgres and SQL Server, they all use SQL as their standard database language.Different used dialects are –MS SQL Server using T-SQL,Oracle using PL/SQL,The MS Access version is called JET SQL (native format) etc.Table of ContentsChapter 1 Distinct Keyword in SQLChapter 2 SQL Constraint Chapter 3 Default and Check Constraint in SQLChapter 4 COUNT Function in SQL Server .Chapter 5 SUM Function in SQLChapter 6 SQL Like Clause .Chapter 7 SQL Wildcard Characters With Example Chapter 8 Truncate and Alter CommandsChapter 9 NULL Values and the UNION Clause In SQLChapter 10 SQL Date and Time Functions Chapter 11 SQL Jobs .Chapter 12 SQL Interview Questions-Part 1Chapter 13 SQL Interview Questions-Part 2Chapter 14 SQL Interview Questions-Part 3

75 pages, Paperback

Published March 17, 2020