Learn SQL with ease

Learn SQL with ease, available at $19.99, has an average rating of 4.2, with 45 lectures, 3 quizzes, based on 187 reviews, and has 501 subscribers.

You will learn about Use SQL to pull and manipulate data from relational databases Select columns, filter for results and sort values Aggregate and group data Calculate with data and manipulate text Join multiple tables This course is ideal for individuals who are This course is created for beginners with little or no knowledge of SQL and those who want to freshen up their skills. It is particularly useful for This course is created for beginners with little or no knowledge of SQL and those who want to freshen up their skills.

Enroll now: Learn SQL with ease

Summary

Title: Learn SQL with ease

Price: $19.99

Average Rating: 4.2

Number of Lectures: 45

Number of Quizzes: 3

Number of Published Lectures: 45

Number of Published Quizzes: 3

Number of Curriculum Items: 48

Number of Published Curriculum Objects: 48

Original Price: $29.99

Quality Status: approved

Status: Live

What You Will Learn

Use SQL to pull and manipulate data from relational databases
Select columns, filter for results and sort values
Aggregate and group data
Calculate with data and manipulate text
Join multiple tables

Who Should Attend

This course is created for beginners with little or no knowledge of SQL and those who want to freshen up their skills.

Target Audiences

This course is created for beginners with little or no knowledge of SQL and those who want to freshen up their skills.

No matter if you work in marketing, sales or finance, a solid understanding of data and the ability to query databases is a huge plus for your career. The first step to pulling your own data is an understand of SQL, the language used to query most data bases.

It doesn’t matter if your company uses MySQL, TeraData, Microsoft SQL Server, Oracle oder MS Access. SQL is a standardized language, can be used to get data out of almost all relational databases.

What will you learn in this course?

This course is a quick and easy step by step guide to writing SQL queries to pull your own data. You learn all key functions of SQL and get a basic understanding of how relational databases work. Plenty of practice sessions will allow you to write your own queries and learn hands on. This way you will feel comfortable in applying the learned material to your day to day problems at work.

Is this course right for you?

If you want to learn solid skills that will improve your career prospects, then this is probably the course for you. Individuals that know their way around data bases, can query their own data sets and analyze them are in high demand in. If your current or your dream employer collects data of any kind? Then you should learn how to use this data.

If you run your own business, it is even more critical to get to your data and make sense of it. Even the databases of websites, online shops and payment systems can be queried with SQL. Get this data, format it and analyze to take the right decisions for your business success.

Course structure

The course is structured in easy steps that allow you to learn one step at a time. Practice sessions and quick quizzes will allow you to write your own queries in an easy to use online tool. No installation or setup required. In fact, you will write your first SQL query in the very first lesson. With each lesson the queries get more complicated and built on the learnings of the prior lessons.

Begin today, learn how to write your first query and start your journey to becoming a data expert!

Course Curriculum

Chapter 1: Simple data query of one table

Lecture 1: Writing your first SQL query

Lecture 2: Selecting columns

Lecture 3: 1st practice session – phone list

Lecture 4: 1st practice – solution

Lecture 5: Filtering with WHERE

Lecture 6: Using AND and OR operators

Lecture 7: 2nd practice – filtering

Lecture 8: 2nd practice – solution

Lecture 9: 3rd practice – advanced filtering

Lecture 10: 3rd practice – solution

Lecture 11: IN and NOT IN

Lecture 12: Greater than and less than

Lecture 13: Finding unique values

Lecture 14: Counting entries and values

Lecture 15: Grouping results

Lecture 16: 4th practice – DISTINCT, COUNT and GROUP BY

Lecture 17: 4th practice – solution

Lecture 18: Sorting

Lecture 19: Some finer points

Lecture 20: What you learned so far

Chapter 2: Joining tables

Lecture 1: Background to relational data bases and joins

Lecture 2: Inner Joins

Lecture 3: 5th practice – INNER JOIN

Lecture 4: 5th practice – solution

Lecture 5: Joining multiple tables

Lecture 6: 6th practice – INNER JOIN on multiple tables

Lecture 7: 6th practice – solution

Lecture 8: Joining tables – inner and outer joins

Lecture 9: 7th practice – OUTER JOIN

Lecture 10: 7th practice – solution

Lecture 11: What you learned so far

Chapter 3: Aggregate functions

Lecture 1: Summing

Lecture 2: 8th practice – summing

Lecture 3: 8th practice – solution

Lecture 4: Average, minimum and maximum

Lecture 5: What you learned so far

Chapter 4: More functions

Lecture 1: Calculating

Lecture 2: Filtering with HAVING

Lecture 3: Changing values

Chapter 5: Tips and Tricks for writing SQL

Lecture 1: Alias

Lecture 2: Column numbers

Lecture 3: Using commas

Lecture 4: Semicolon

Lecture 5: Summary of optimization tips

Chapter 6: Bonus

Lecture 1: Bonus and thank you

Instructors

Marco Eder
Entrepreneur, Coach, Data Analyst

Rating Distribution

1 stars: 0 votes
2 stars: 3 votes
3 stars: 22 votes
4 stars: 61 votes
5 stars: 101 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!

Menu