SQL The Complete Guide: SQL from Beginner to Advanced
SQL The Complete Guide: SQL from Beginner to Advanced, available at $44.99, has an average rating of 4.6, with 49 lectures, 17 quizzes, based on 16 reviews, and has 264 subscribers.
You will learn about Use SQL to query any relational database Perform data analysis with SQL in the real-world situations Write complex queries across multiple tables Work with real-life database and learn everything that you need to create your own SQL reports This course is ideal for individuals who are People who want to start running their own queries with SQL or People who want to increase their earning potential or Professionals who work with data analysis on a relational basis, from programmers to financial areas, marketing, etc… or Data Engineers and Data Scientists or Technology students learning about SQL or SQL enthusiasts 🙂 It is particularly useful for People who want to start running their own queries with SQL or People who want to increase their earning potential or Professionals who work with data analysis on a relational basis, from programmers to financial areas, marketing, etc… or Data Engineers and Data Scientists or Technology students learning about SQL or SQL enthusiasts :).
Enroll now: SQL The Complete Guide: SQL from Beginner to Advanced
Summary
Title: SQL The Complete Guide: SQL from Beginner to Advanced
Price: $44.99
Average Rating: 4.6
Number of Lectures: 49
Number of Quizzes: 17
Number of Published Lectures: 49
Number of Published Quizzes: 17
Number of Curriculum Items: 66
Number of Published Curriculum Objects: 66
Original Price: $99.99
Quality Status: approved
Status: Live
What You Will Learn
- Use SQL to query any relational database
- Perform data analysis with SQL in the real-world situations
- Write complex queries across multiple tables
- Work with real-life database and learn everything that you need to create your own SQL reports
Who Should Attend
- People who want to start running their own queries with SQL
- People who want to increase their earning potential
- Professionals who work with data analysis on a relational basis, from programmers to financial areas, marketing, etc…
- Data Engineers and Data Scientists
- Technology students learning about SQL
- SQL enthusiasts 🙂
Target Audiences
- People who want to start running their own queries with SQL
- People who want to increase their earning potential
- Professionals who work with data analysis on a relational basis, from programmers to financial areas, marketing, etc…
- Data Engineers and Data Scientists
- Technology students learning about SQL
- SQL enthusiasts 🙂
Learn how to work with SQL for real with this course!
In recent years the data area has grown a lot and has been in great demand, the SQL language has been one of the requirements in several professional areas outside the technological scope, for example in some companies in the areas of marketing, finance, HR, they use SQL to carry out analyzes and make decisions! Learning SQL nowadays is essential to increase your chances in the job market.
You will learn with an effective method, from basic to advanced and understand SQL by applying it in practice with practical examples, and you will be ready to apply it immediately in the real world. In this course we will use the PostgreSQL database to execute our queries, but this knowledge can be applied to any database that uses SQL, such as MySQL, Oracle, SQL Server, Redshift…
What will you learn:
-
Concepts about Databases, schemes and tables
-
Basic and Intermediate SQL (WHERE command, ORDER BY command, Logical Operators, Conditionals)
-
Group data with aggregate functions using the GROUP BY command
-
Filter aggregated data with HAVING command
-
Perform all types of SQL JOINs (Inner, Left, Right, Cross, Full…)
-
String functions
-
Date and Time functions
-
Mathematical functions
-
Subqueries
-
CTEs (Common Table Expressions)
-
Window Functions
-
SQL Advanced Topics
-
Performance Improvements on Queries
Let’s learn together, from basic to advanced of SQL! Check out the free preview videos for more information about the complete guide!
Course Curriculum
Chapter 1: Introduction
Lecture 1: What is a Database?
Lecture 2: Schemes and Tables
Lecture 3: Preparing the Ground
Chapter 2: SQL Fundamentals
Lecture 1: Section Introduction
Lecture 2: Starting Queries
Lecture 3: Comments on Queries
Lecture 4: Renaming Columns in Queries
Lecture 5: Using DISTINCT
Lecture 6: Using WHERE
Lecture 7: AND, OR and NOT Operators
Lecture 8: Filtering with BETWEEN
Lecture 9: Filtering with IN
Lecture 10: Filtering with LIKE
Lecture 11: Using ORDER BY
Lecture 12: Using LIMIT
Lecture 13: Using COUNT
Lecture 14: About Coding Exercises
Chapter 3: Grouping your Data
Lecture 1: Section Introduction
Lecture 2: Using GROUP BY
Lecture 3: MAX, MIN, AVG and SUM Aggregation Functions
Lecture 4: Using HAVING
Chapter 4: Crossing and Uniting Information
Lecture 1: Section Introduction
Lecture 2: Using INNER JOIN in Queries
Lecture 3: Using LEFT JOIN in Queries
Lecture 4: Using RIGHT JOIN in Queries
Lecture 5: Using FULL JOIN in Queries
Lecture 6: Using CROSS JOIN in Queries
Lecture 7: Using UNION in Queries
Lecture 8: Using UNION ALL in Queries
Chapter 5: Basic and Conditional Functions
Lecture 1: Section Introduction
Lecture 2: STRING Functions Part 1
Lecture 3: STRING Functions Part 2
Lecture 4: Date and Time Functions Part 1
Lecture 5: Date and Time Functions Part 2
Lecture 6: Mathematical Functions Part 1
Lecture 7: Mathematical Functions Part 2
Lecture 8: CAST Function
Lecture 9: NULLIF Function
Lecture 10: COALESCE Function
Lecture 11: CASE Conditional
Chapter 6: Advanced SQL
Lecture 1: Section Introduction
Lecture 2: Subqueries
Lecture 3: Common Table Expressions (CTE)
Lecture 4: EXISTS Operator
Lecture 5: Window Functions Part 1
Lecture 6: Window Functions Part 2
Lecture 7: Window Functions Part 3
Lecture 8: Next Steps
Chapter 7: EXTRA SECTION!
Lecture 1: Data Analysis with SQL: Mastering Data Analysis
Instructors
-
Kauann Henrique Oliveira
Data Engineer
Rating Distribution
- 1 stars: 0 votes
- 2 stars: 0 votes
- 3 stars: 1 votes
- 4 stars: 4 votes
- 5 stars: 11 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