Description
Learn SQL in a Month of Lunches, Video Edition. This course teaches the structured query language from the ground up. It’s designed for people who want to add skills in working with relational databases like SQL Server, PostgreSQL, and Oracle to their resume without any prior programming experience. The course content focuses on practical, real-world applications and covers the most useful skills for retrieving, filtering, and analyzing business data. Participants learn how to read and write basic queries, troubleshoot common problems, and manipulate data. Each lesson includes a 15-minute hands-on lab that practices new techniques with relevant code examples and simple language. This course is especially ideal for data analysts who work with tools like Excel, Tableau, and Power BI and need to move beyond spreadsheets and business intelligence tools. Jeff Iannucci, an expert with 25 years of experience, provides guidance on how to write custom queries, modify existing expressions, and work professionally with data to produce effective reports in a short period of time.
What you will learn
- Setting up your first database with MySQL.
- Writing your own SQL queries.
- View only the data you need from large data sets.
- Connecting different data sets.
- Data analysis using functions and aggregations.
- Mastery of basic data manipulation techniques.
- Save queries in Stored Procedures and Views.
- Create tables to store data efficiently.
- Read and improve SQL written by others.
- Get the required data from any relational database.
- Filtering, sorting, and grouping data.
- Combine data from multiple tables.
- Create, update, and delete data.
This course is suitable for people who:
- Students.
- Aspiring data analysts.
- Software Developers.
- Anyone who wants to work with relational databases.
- Those who use Excel, Tableau, or PowerBI to analyze business data.
- Aspiring data professionals with no prior experience using relational databases.
Course Details Learn SQL in a Month of Lunches, Video Edition
- Publisher: Oreilly
- Instructor: Jeff Iannucci
- Training level: Beginner to advanced
- Training duration: 8 hours and 21 minutes
Course headings
Images of the Learn SQL in a Month of Lunches, Video Edition course
Sample course video
Installation Guide
After Extract, view with your favorite player.
Subtitles: None
Quality: 720p
Download link
Downloadly
Rapidgator link
File(s) password: www.downloadly.ir
File size
1.1 GB
