MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 42 lectures (3h 26m) | Size: 648.8 MB

If you want to learn how to write SQL queries quickly then you have come to the right place.

Learn how to Write Queries for Data Analysis and Data Analytics using SQL in MySQL Database: Includes lots of Exercises

How to write commonly used SQL queries using SELECT

Fundamentals of SQL

SQL Best Practices

Data Analysis

How to join data tables - includes both inner and outer joins

How to group data using GROUP BY

SQL operators

Aggregate Functions

No previous technical knowledge required



What makes this course unique are the following features:

1. I get straight to the point - no messing around or time wasted padding out lectures.

2. Purely focused on writing SQL queries for data analysis rather than on creating and managing database tables.

3. Lots of visual diagrams to help you understand key concepts.

3. Lots of challenges where you get to write SQL queries. In addition, the solution to every challenge is provided and I walk through the solutions as well.

4. At under 4 fours in length this is a course you will actually finish! And you will get 30 SQL coding challenges which are spread throughout the course. In addition, we will go through the solution to every challenge in a practical demo lecture.

This course focuses on the fundamentals of the SQL language and I go everything step-by-step with lots of visual examples along the way. Also included in this course, are the conceptual steps of how a query gets evaluated. This provides a visual of how things are working, so that when you are confronted with your own real-life SQL challenges, you will have the skills to arrive at the best solution.

IMPORTANT NOTE: This course does NOT cover building, altering, or maintaining SQL/MySQL databases or tables. Our goal in this course is purely on writing queries for database analysis using MySQL and MySQL Workbench.

Students interested in learning Structured Query Language (SQL)

Aspiring Data Analysts

Job-seekers

Application Developers

Web Developers




DOWNLOAD
uploadgig.com