Learn SQL with ease
What you'll 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
Requirements
- This course uses an online practice database. All you need is a modern web browser to write your own queries and perform the practice tasks.
Description
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!
Who this course is for:
- This course is created for beginners with little or no knowledge of SQL and those who want to freshen up their skills.
Course content
- Preview02:29
- 01:53Selecting columns
- 00:091st practice session - phone list
- Preview01:55
- 02:06Filtering with WHERE
- Preview02:38
- 00:182nd practice - filtering
- 03:382nd practice - solution
- 00:213rd practice - advanced filtering
- 03:263rd practice - solution
- 04:26IN and NOT IN
- 04:19Greater than and less than
- 4 questionsQuiz 1 - Practice filtering
- 03:25Finding unique values
- Preview07:02
- 06:22Grouping results
- 3 questionsQuiz 2 - DISTINCT, COUNT and GROUP BY
- 00:274th practice - DISTINCT, COUNT and GROUP BY
- 09:424th practice - solution
- Preview04:34
- 02:54Some finer points
- 02:27What you learned so far
Instructor
![Marco Eder](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.5 Instructor Rating
- 883 Reviews
- 2,911 Students
- 2 Courses
Hallo,
ursprünglich komme ich aus Brandenburg, aber meine Wanderlust hat mich in viele verschiedene Länder gezogen. Zwei meiner Lieblingsstationen waren Dublin und San Francisco, wo ich insgesamt sechs Jahre für Google gearbeitet habe. Als Analyst im Finance und Business Intelligence Team habe ich unendlich viele Zeilen an SQL-Abfragen geschrieben.
Meine Begeisterung und Leidenschaft für Daten, Datenbanken und die Abfrage mit SQL möchte ich mit dir auf Udemy teilen!