Learn MySQL from scratch for Data Science and Analytics
https://CourseWikia.com
Published 07/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 87 lectures (5h 40m) | Size: 2.5 GB
Using MySQL Server RDBMS with Workbench to Become a SQL Expert on Queries for your Business Logic on real world problems
What you'll learn
What you'll learn
Use SQL to query a data for reports
Get a job as a junior Data Analytics developer
Advanced SQL statements
Use Workbench to prepare Database schema structure
Be comfortable putting SQL and MySQL on their resume
Learn to perform GROUP BY statements for Business Intelligence reports
Replicate real-world situations and query reports
Complete basic SELECT statements querying against a single table
Filter data using the WHERE clause to identify required data
Apply SQL for Data Science
Using JOINS, return data from multiple tables in the same query
Complete Analysis statements that use aggregate functions
Import and Export .CSV, Excel to SQL Database
Performing Secure Backup and Restore Full SQL Database
Requirements
No prior technical experience is required! All you need a computer!
No SQL experience needed. You will learn everything you need to know
No software is required in advance of the course (all software used in the course is free)