SQL for Beginners: Learn SQL for Data Analysis using MySQL
SQL for Beginners: Learn SQL for Data Analysis using MySQL, available at $59.99, has an average rating of 4.45, with 43 lectures, based on 38 reviews, and has 117 subscribers.
You will learn about 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 This course is ideal for individuals who are Students interested in learning Structured Query Language (SQL) or Aspiring Data Analysts or Job-seekers or Application Developers or Web Developers It is particularly useful for Students interested in learning Structured Query Language (SQL) or Aspiring Data Analysts or Job-seekers or Application Developers or Web Developers.
Enroll now: SQL for Beginners: Learn SQL for Data Analysis using MySQL
Summary
Title: SQL for Beginners: Learn SQL for Data Analysis using MySQL
Price: $59.99
Average Rating: 4.45
Number of Lectures: 43
Number of Published Lectures: 43
Number of Curriculum Items: 43
Number of Published Curriculum Objects: 43
Original Price: $19.99
Quality Status: approved
Status: Live
What You Will Learn
- 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
Who Should Attend
- Students interested in learning Structured Query Language (SQL)
- Aspiring Data Analysts
- Job-seekers
- Application Developers
- Web Developers
Target Audiences
- Students interested in learning Structured Query Language (SQL)
- Aspiring Data Analysts
- Job-seekers
- Application Developers
- Web Developers
If you want to learn how to write SQL queries quickly then you have come to the right place.
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.
Course Curriculum
Chapter 1: Introduction
Lecture 1: Welcome to the Course!
Lecture 2: Overview of Popular Relational Database Management Systems (Optional Lecture)
Chapter 2: SQL Statement Fundamentals
Lecture 1: Understanding the Foundations of SQL
Lecture 2: SELECT Statement
Lecture 3: Software Installation (Windows)
Lecture 4: MacOS Installation and set up Course Databases
Lecture 5: Overview of the Course Challenges
Lecture 6: SELECT Challenges
Lecture 7: Solutions to the SELECT Challenges
Lecture 8: SELECT DISTINCT
Lecture 9: SELECT DISTINCT Challenges
Lecture 10: Solutions to the SELECT DISTINCT Challenges
Lecture 11: Row Ordering – ORDER BY
Lecture 12: LIMIT Clause
Lecture 13: ORDER BY Challenges
Lecture 14: Solutions to the ORDER BY Challenges
Lecture 15: WHERE Clause – Three-valued Logic
Lecture 16: Replacing Nulls in Queries
Lecture 17: WHERE Clause – Comparison Operators
Lecture 18: WHERE Clause Challenges
Lecture 19: Solutions to the WHERE Clause Challenges
Lecture 20: Introduction to Collations and Pattern Matching
Lecture 21: Pattern Matching – Part 2
Lecture 22: Pattern Matching Challenges
Lecture 23: Solutions to the Pattern Matching Challenges
Lecture 24: MySQL Data Types
Chapter 3: Grouping Data
Lecture 1: Introduction to Aggregate Functions
Lecture 2: GROUP BY and Aggregate Functions
Lecture 3: HAVING Clause
Lecture 4: Logical Query Processing Order in MySQL
Lecture 5: GROUP BY Challenges
Lecture 6: Solutions to the GROUP BY Challenges
Chapter 4: Logical Operators
Lecture 1: AND Operator
Lecture 2: OR Operator
Lecture 3: Operator Precedence
Lecture 4: IN Operator
Lecture 5: Logical Operator Challenges
Lecture 6: Solutions to the Logical Operator Challenges
Chapter 5: Joins and Integrity Constraints
Lecture 1: INNER JOIN
Lecture 2: LEFT OUTER JOIN and RIGHT OUTER JOIN
Lecture 3: Integrity Constraints
Lecture 4: Join Challenges
Lecture 5: Solutions to the Join Challenges
Instructors
-
Daniel Tait
Database Instructor
Rating Distribution
- 1 stars: 0 votes
- 2 stars: 1 votes
- 3 stars: 2 votes
- 4 stars: 13 votes
- 5 stars: 22 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Language Learning Courses to Learn in November 2024
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024