Description
What makes this course unique:1. This course is designed around 5 DBMS - MYSql - SQL Server - PostGre - MariaDB - SQLite2. Data drives business. This is is why the course is built around 1 business case. Your objective if you choose to accept it is to learn SQL is such a way in order to present data and analysis to a business owner that will empower such business owner to make the right business decision. 3. A very comprehensive SQL course. We don't shy away from advanced topics such as Recursive CTE and cursors.4. This course comes with a unique database (upon completion of 50% of course) that contains 250+ key words of the 5 DBMS covered by this course. Don't restrict your career to 1 DBMS!5. This course really covers the ins and out of SQL. From importing data, creating queries to using the data. We will show you how to use Excel to construct a data pipeline. How to use SQL in Java, Python and R. How to use SQL in an Android application and finally how to build a web application where can learn about ethical hacking by testing a case of SQL injection.6. More than 40 exercises where you will get familiar with creating complex queries of 50+ lines of codes using views, correlated subqueries, joining tables,, cte. in views, stored procedures, functions...
