Master SQL with SQL Server,MySql,PostGre,MariaDB and SQLite

Master SQL with SQL Server,MySql,PostGre,MariaDB and SQLite

What makes this course unique:

1. This course is designed around 5 DBMS - MYSql - SQL Server - PostGre - MariaDB - SQLite

2. 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...

From start to finish, become a master at SQL and learn how to provide data solutions to meet business operational needs

Url: View Details

What you will learn

• Learn how to use SQL to perform the most basic to the most advanced query. This course covers more than 300 keywords. No other course is as comprehensive.
• Learn SQL on 5 different relational database and their associated Database Management System.
• Learn SQL and gain experience through exercises/challenges by meeting the operational needs of a business. All of the course is structured around 1 business.

Rating: 4.5

Level: All Levels

Duration: 20.5 hours

Instructor: Richard Proteau