Error Page
SQL (STRUCTURED QUERY LANGUAGE) (BASIC - ADVANCE)
- Introduction to SQL: Basics of SQL, Applications of SQL, Databases, Frameworks, and different types of platforms which use SQL language.
- Functions in SQL: Numeric (MAX, MIN, AVG, ROUND, RAND, SQRT, SUM, LOG etc. & String Functions (LEFT, LEN, RIGHT, FORMAT, LOWER, UPPER, TRIM, NCHAR, REVERSE, SPACE, TRANSLATE, DATALENGTH, CONCAT etc.)
- Clauses in SQL: WHERE, ORDER BY, HAVING, TOP, GROUP BY etc.
- Advanced General Functions: DDL (Create, Drop, Alter, Truncate, Rename), DML (Insert, Update, Delete), DCL (Grant, Revoke), TCL (Commit, Rollback, Save point), DQL (Select)
- Advanced Server Functions: SQL Server Functions (CHAR, CHARINDEX, CONCAT, ISNULL, ISNUMERIC, NULLIF, IIF, CONVERT, CAST etc.)
- Server Date Functions: DATEADD, DATEIFF, DATEFROMPARTS, DATENAME, DATEPART, GETDATE, GETUTCDATE, ISDATE, SYSDATETIME, YEAR etc.)
- IMPORT & EXTRACT Data from Database Servers & Plotting the same to create new terminal for the dataset.
- Miscellaneous Functions: SQL Wildcards, In, Aliases, Joins (Inner, Left, Right, Full, Self), Union, Having, Exists, Any, All, Select Into, Insert Sheet Into, Case, Null, Stored Procedures, Operators etc.
REAL-WORLD CALCULATIONS & TOPICS (MORE in our Syllabus Attachment)
REAL-WORLD DASHBOARDS (BASIC - ADVANCE)
Please feel free to go through our curriculum & decide. Once you do,
we're here to help you throughout the journey. Looking forward to seeing you in
our sessions!
Thank you!
From TEAM EXCELZONE
