2 Dec 2020 Agnieszka Kozubek-Krycuń SQL Technologies Are More Common Than You Think Where is SQL being used today? The answers might surprise you! (Hint: SQL technology is basically everywhere.) Is it worth learning SQL? After all, the language was created in the 1970s. Is it still relevant today? The list of technologies that support SQL is very long – and it’s growing. Read on to find out what kinds of programs use SQL. SQL in Databases Relational Databases = SQL Databases It’s no surprise that SQL is used in relational databases. Read more 17 Nov 2020 Agnieszka Kozubek-Krycuń The History of SQL – How It All Began Who created SQL and why? Find out in this article! Here’s a brief history of SQL, starting with its foundational concept: the database. Ted Codd and the Relational Data Model The first computer databases appeared in the late 1960s. This was an important area of research at the time. Many computer scientists were focused on improving how databases work. One of them was Edgar Frank (Ted) Codd, an English computer scientist employed at IBM. Read more 6 Oct 2020 Agnieszka Kozubek-Krycuń Five Essential Features of a Good SQL Course There are many different platforms offering SQL courses. If you’re a beginner, it may be difficult to choose the right one for you. Find out what we think are the essential features of a good SQL course. Remember, if you make a poor choice at the beginning, you may get discouraged or get into bad habits that will impact your work down the line. What Is SQL? SQL (Structured Query Language) is the foundation of data management and analysis in relational databases. Read more 10 Sep 2020 Agnieszka Kozubek-Krycuń Creating SQL Courses: Behind the Scenes at LearnSQL.com Take a peek behind the scenes and learn our secret for creating great SQL courses! Have you ever wondered how LearnSQL.com courses are created? Are we looking at a lot of hard work or just a bit of magic? Or maybe both? Here’s a hint: we rely on proven methods to create user-friendly online courses. But it’s not easy! Read on to see the 8 steps we take when creating a new SQL course. Read more 7 Jul 2020 Agnieszka Kozubek-Krycuń What Is a SQL Dialect, and Which one Should You Learn? SQL, standard SQL, SQL Server, MySQL, PostgreSQL, Oracle, … You’d like to learn SQL, but you feel overwhelmed with options and you don’t know where to start. We’ll explain what each of these terms mean and what this has to do with SQL dialects. Diving into the world of SQL dialects can feel like jumping into a deep pool without knowing how to swim. There's a ton of stuff to pick up! Read more 17 Apr 2020 Agnieszka Kozubek-Krycuń Why Take the “SQL Basics” Course at LearnSQL.com LearnSQL.com’s interactive SQL Basics course teaches the foundations of SQL. Discover why we built this online course, our philosophy behind it, and what it contains! Learning SQL can feel like unlocking a new skill set you didn’t even know you needed. At first, it might seem like just another technical tool, but as you start using it, you'll notice how much smoother your workflow becomes. Suddenly, tasks like pulling data from multiple sources or answering complex questions about trends won’t feel as overwhelming. Read more 2 Apr 2020 Agnieszka Kozubek-Krycuń How to Get the First Day of the Week in SQL Server This is additional content for the LearnSQL.com course Customer Behavior Analysis in SQL Server. This interactive course will teach you how to analyze customer lifecycle in a SQL database in over 70 hands-on exercises. You will learn how to find out compare registration rates between periods of time, compute conversion rates in SQL, compare customer cohorts, analyze customer activity and customer churn over time. This course is essential for anyone doing customer analysis in their job. Read more 2 Apr 2020 Agnieszka Kozubek-Krycuń How to Group Data by Week in SQL Server This is additional content for the LearnSQL.com course Customer Behavior Analysis in SQL Server. In this course, we showed you how you can analyze the customer lifecycle (customer acquisition, conversion, activity, retention, and churn) with SQL. We discussed customer registration cohorts, or groups of customers who registered during the same period (e.g. same week, same month). Analyzing customer registration cohorts lets you see registration trends and relate registration cohorts with marketing campaigns. Read more 27 Mar 2020 Agnieszka Kozubek-Krycuń Why Window Functions Are Not Allowed in WHERE Clauses Window functions are extremely powerful, but there are a lot of nuances and little details you need to learn about using window functions in order to use them correctly and efficiently. A fairly common question SQL users have is why window functions are not allowed in WHERE. TL;DR: You can use window functions in SELECT and ORDER BY. You cannot use window functions in WHERE, GROUP BY, or HAVING. Read more 31 Dec 2014 Agnieszka Kozubek-Krycuń MySQL Collations List Collations To list all collations available in MySQL, use SHOW COLLATION; +-------------------+----------+-----+---------+----------+---------+ | Collation | Charset | Id | Default | Compiled | Sortlen | +-------------------+----------+-----+---------+----------+---------+ | big5_chinese_ci | big5 | 1 | Yes | Yes | 1 | | big5_bin | big5 | 84 | | Yes | 1 | | dec8_swedish_ci | dec8 | 3 | Yes | Yes | 1 | | dec8_bin | dec8 | 69 | | Yes | 1 | | cp850_general_ci | cp850 | 4 | Yes | Yes | 1 | | cp850_bin | cp850 | 80 | | Yes | 1 | | hp8_english_ci | hp8 | 6 | Yes | Yes | 1 | | hp8_bin | hp8 | 72 | | Yes | 1 | | koi8r_general_ci | koi8r | 7 | Yes | Yes | 1 | | koi8r_bin | koi8r | 74 | | Yes | 1 | | latin1_german1_ci | latin1 | 5 | | Yes | 1 | | latin1_swedish_ci | latin1 | 8 | Yes | Yes | 1 | | latin1_danish_ci | latin1 | 15 | | Yes | 1 | | latin1_german2_ci | latin1 | 31 | | Yes | 2 | | latin1_bin | latin1 | 47 | | Yes | 1 | | latin1_general_ci | latin1 | 48 | | Yes | 1 | . Read more «« « 1 2 3 » »»