• chevron_right

      What Are the Different SQL JOIN Types?

      pubsub.slavino.sk / learnsql · Tuesday, 19 April, 2022 - 16:00 edit

    You just can’t understate the importance of the JOIN when learning SQL. Not only is it one of the most fundamental operations in relational databases, but it is also very versatile with many different types. Although SQL JOIN may be intimidating at first, it becomes a very handy instrument in your arsenal once you understand it. Let’s explore all the SQL JOIN types! We can safely say the JOIN operation is one of the most powerful features of SQL.

    Značky: #Rozne

    • chevron_right

      The SQL OVER() Clause - When and Why to Use It

      pubsub.slavino.sk / learnsql · Thursday, 14 April, 2022 - 16:00 edit

    The OVER() clause, or how to reach a whole new level of data analysis. Why all the commotion around the SQL OVER() clause? I’ll tell you why: the OVER() clause introduces window functions. And what are window functions in SQL, you might ask? They are functions that operate on a window, i.e. a set of rows related to the current row. In that way, they are similar to the GROUP BY clause and to aggregate functions.

    Značky: #Rozne

    • chevron_right

      SQL Track of the Season: SQL from A to Z in MySQL

      pubsub.slavino.sk / learnsql · Tuesday, 12 April, 2022 - 16:00 edit

    Do you feel the spring already? Everything is in full bloom at this time of the year. Why shouldn’t it be the same with your career? You just need to water it with a new skill. Here is the brilliant SQL from A to Z in MySQL track, our Track of the Season. In this article, I answer common questions about this awesome set of online MySQL courses. Why should you care about relational databases at all?

    Značky: #Rozne

    • chevron_right

      Join the LearnSQL.com Affiliate Program!

      pubsub.slavino.sk / learnsql · Thursday, 7 April, 2022 - 16:00 edit

    Are you a creator, blogger, or YouTuber? Do you have an audience, do you appreciate our interactive SQL courses, and would you like to help promote them? By the way, you can earn some money! Here is our SQL Affiliate Program. We create our SQL courses with a passion and a love for databases. Looking at the reactions and the reviews of our users, we do quite well. If this is your first visit to LearnSQL.

    Značky: #Rozne

    • chevron_right

      Free Course of the Month – GROUP BY Extensions in PostgreSQL

      pubsub.slavino.sk / learnsql · Tuesday, 5 April, 2022 - 16:00 edit

    Do you work with data? Want to be able to create better and more sophisticated SQL reports? Then check out our interactive GROUP BY Extensions in PostgreSQL course. In April 2022, you can complete this online PostgreSQL course for FREE! How can you get this free SQL course in April? Create a free com account or log in if you already have one. Start the course. You will have free access to its content until the end of the month.

    Značky: #Rozne

    • chevron_right

      New Monthly SQL Practice for April 2022!

      pubsub.slavino.sk / learnsql · Friday, 1 April, 2022 - 13:00 edit

    Are you a SQL beginner that needs some interactive exercises to practice writing queries? Take up the challenge and choose our April SQL Practice course! In our April 2022 SQL Practice, you’ll meet Olivia, the owner of a hairdressing salon. She needs you to help her gather statistics on the services offered by her salon, the salon customers, their appointments, etc. Can you use your SQL skills to help her find the data?

    Značky: #Rozne

    • chevron_right

      How to Use the ROUND() Function in SQL

      pubsub.slavino.sk / learnsql · Thursday, 31 March, 2022 - 16:00 edit

    Need to round numeric results in SQL? The ROUND() function is here to do the job. Modern relational databases offer many built-in functions that extend the capabilities of SQL. In this article, we will use practical examples to explain how the ROUND() function works. (Spoiler alert: If you guessed that it rounds a number to a certain decimal place, you’re right! Read on to find out more.) SQL Standard Functions Each SQL database (PostgreSQL, MySQL, Oracle, SQL Server among others) has a set of built-in functions.

    Značky: #Rozne

    • chevron_right

      LearnSQL.com’s Monthly SQL Practice in 2022

      pubsub.slavino.sk / learnsql · Wednesday, 23 February, 2022 - 16:00 edit

    Are you looking for ways to practice SQL? Tired of boring exercises based on unreal scenarios? We have something for you! Every month, we publish a new set of SQL practice exercises. You'll find all of them in the monthly SQL Practice. Here at LearnSQL.com, we believe the best way to learn SQL is through practice. All of our SQL courses (and there are over 30 of them!) are hands-on.

    Značky: #Rozne

    • chevron_right

      An Overview of MySQL Data Types

      pubsub.slavino.sk / learnsql · Tuesday, 22 February, 2022 - 16:00 edit

    What data types are available in a MySQL database? In this article, you’ll learn about numeric data types, text data types, and much more! You may have seen our article about data types in SQL. Here, we focus on the MySQL data types. We will discuss the most commonly used ones: numeric, text, and date and time. If you are interested in the topic, be sure to check out our Data Types in SQL course.

    Značky: #Rozne