• Le chevron_right

      These SQL Queries Will Help You With Data Analysis

      pubsub.slavino.sk / learnsql · Tuesday, 14 June, 2022 - 16:00 edit

    Need to streamline your everyday data analysis tasks? This article explains how basic SQL queries can help. If you are planning a corporate career or any field that involves working with data, you must have come across SQL, or Structured Query Language. SQL was first developed in the 1970s and it continues to be the industry standard for database interactions. Many of you may already have decided to learn this language, given how powerful it is.

    Značky: #Rozne

    • Le chevron_right

      5 Tips for You From a Senior SQL Data Analyst

      pubsub.slavino.sk / learnsql · Thursday, 9 June, 2022 - 16:00 edit

    Are you looking for tips for becoming a better data analyst? Do you want to know about the mistakes and issues you may face? I have collected five tips for your everyday work based on my experience as a data analyst. You may have already read about what data analysts do, how much they earn, and how to become one. However, there is more to it than just becoming a data analyst.

    Značky: #Rozne

    • wifi_tethering open_in_new

      This post is public

      learnsql.com /blog/tips-from-senior-sql-data-analyst/

    • Le chevron_right

      How to Combine Two Aggregate Functions in SQL

      pubsub.slavino.sk / learnsql · Tuesday, 7 June, 2022 - 16:00 edit

    Having trouble using two aggregate functions in one query? This article will show you how to do it the right way – actually, the two right ways. In data analysis and reporting, we often need to count the number of records or sum them up and then calculate the average of this count or sum. Translated to SQL logic, this is the aggregation of aggregated data, or multi-level aggregation. For aggregation purposes, there are the SQL aggregate functions.

    Značky: #Rozne

    • Le chevron_right

      Free SQL Course of the Month – PostGIS

      pubsub.slavino.sk / learnsql · Wednesday, 1 June, 2022 - 16:00 edit

    What is PostGIS, and why should you learn it? (Hint: Our SQL PostGIS course is free throughout June 2022!) Did you know databases can store geographic data? This is how interactive maps are made, most often based on PostGIS. In this article, I will tell you what PostGIS is and why it’s worth learning. Moreover, I am going to offer you an awesome online PostGIS SQL course which you can do for free during June 2022!

    Značky: #Rozne

    • Le chevron_right

      New Monthly SQL Practice for June 2022!

      pubsub.slavino.sk / learnsql · Wednesday, 1 June, 2022 - 13:00 edit

    Are you a SQL beginner that needs some interactive exercises to practice writing queries? Take up the challenge in our June SQL Practice course! In our June 2022 SQL Practice, you’ll meet Damiano – a young entrepreneur who wants to kick-start his car rental business. He needs you to help him gather the right data and statistics on his company’s performance. Can you use your SQL skills to help him find the data?

    Značky: #Rozne

    • Le chevron_right

      How to Install a MySQL Database on a Windows PC

      pubsub.slavino.sk / learnsql · Tuesday, 31 May, 2022 - 16:00 edit

    Do you want to install a MySQL database on your Windows computer? And maybe find out how to start using a MySQL database? In this article, we’ll cover the installation process. MySQL is one of the most popular relational database servers. This is one reason to start using a MySQL database. Among the various editions of MySQL delivered by Oracle, the Community edition is available for free. You can download it from the MySQL website.

    Značky: #Rozne

    • Le chevron_right

      Over 40 and Want to Upskill? Learn SQL!

      pubsub.slavino.sk / learnsql · Thursday, 26 May, 2022 - 16:00 edit

    You have several years of experience. Your work has even been written up in a few case studies. Yet, you still have a hard time finding the right path to improve your career. If that's true for you, the answer is to learn SQL. In this article, I'll tell you why. Why learn SQL when you’re already an experienced professional? It’s always good to learn something new. You may want to pick up a new hobby, try out a different industry, or get a new skill to help your career.

    Značky: #Rozne

    • Le chevron_right

      How to Use the COALESCE() Function in SQL

      pubsub.slavino.sk / learnsql · Tuesday, 24 May, 2022 - 16:00 edit

    SQL users are often faced with NULL values in their queries and need to process them properly. The COALESCE() function helps handle NULL values. Read this article to learn how to use COALESCE() in your queries. SQL tables store data in records, and records are composed of fields. There can be situations where we don’t know the value for a specific field. For example, let’s suppose we have a table with data for persons.

    Značky: #Rozne

    • Le chevron_right

      The Recent Rise of DBT and the Analytics Engineer

      pubsub.slavino.sk / learnsql · Thursday, 19 May, 2022 - 16:00 edit

    If you’re interested in data engineering or data analytics, you should know about DBT. And you should also learn about the role of an analytics engineer. We cover both in this article. The rise of Cloud data providers has led to new challenges and possibilities. If you are thinking about entering the data analytics space, it is important to be aware of them; it can help you decide what roles to aim for and what skills to learn.

    Značky: #Rozne