Course Details

Our course in structured query language or SQL is taught on A. Relational database concepts, specific products, B. SQL syntax rules, C. Data definition, data manipulation and data control statements, D. Getting acquainted with the course database and editor, II. SQL SELECT statements, A. Clauses, B. The SELECT clause: columns and aliases, where expressions, order by expressions how null values behave, III. SQL Functions and Expressions, A. Eliminating duplicates with DISTINCT, arithmetic expressions, B. Replacing null values, C. Literals, concatenation, other string, functions, D. Numeric operations, including, rounding, E. Date and time functions, F. Nested table expressions, G. Case logic H. Other expressions in specific dbms etc.