SQL forms an important tool in the entire data engineering process. The following topics are covered:
| 1 | Introduction to SQL |
| 2 | SQL Applications |
| 3 | Installing SQL |
| 4 | Basic SQL commands |
| 5 | DDL, DML, DCL commands |
| 6 | Data Querying-SQL, Indexing |
| 7 | Clauses, Functions, Conditions, Windows Functions |
| 8 | SQL Tables , Views, Stored Procedures and Functions |
| 9 | Joining data – Inner, Outer & Cross Joins |
| 10 | Sub-Queries, Common Table Expressions (CTE) |
| 11 | Triggers, Procedures, Synonyms & Performance Tuning |
| 12 | Project |
Reviews
There are no reviews yet.