Author: Vertabelo Team

How to Gift a Vertabelo Academy Course

Thin line colorful vector illustration concept for gift delivery service, e-commerce, online shopping, receiving package from courier to customer isolated on bright background.
Learning is the gift that keeps on giving. Find out how you can gift an online course. So you’ve decided to gift a course but don’t know how to do it? It’s very easy! Following is an example of how to do this using our introductory course on Python. First, pick and navigate to the page with the course you’d like to gift. Click on the “Gift this course” option that is visible on the right-hand side.

New Course Launch: How to Read and Write JSON Files in Python

Providing various types of data in a unified way is one of the core concepts of web communication. In recent years, JSON text files have become extremely popular due to their simplicity and universality. Vertabelo Academy’s recent course—How to Read and Write JSON Files in Python—explains how to manipulate JSON files in Python. If you work with Python and want to learn a practical skill in high demand, you’re in the right place.

New Course Launch: Python Data Structures in Practice

Do you know the feeling when you’ve read the theory behind some programming concepts but you’re at a loss when it comes to writing actual code? Vertabelo Academy’s new course—Python Data Structures in Practice—addresses this exact problem by explaining the practical aspects of basic data structures. The course discusses frequent use cases and teaches you optimal solutions to common problems. As a bonus, you’ll create a real Python game!

New Course Launch: How to Insert, Update, and Delete Data in MS SQL Server

Learn how the T-SQL data manipulation language (DML) can help you control the information inside your SQL Server database. Do you work with SQL Server? Interested in learning more about the T-SQL language? Then you’re in the right place! We’re excited to introduce our new online course: How to Insert, Update, or Delete Data in MS SQL Server. In this course, you’ll learn about the data manipulation language (DML) statements in T-SQL.

New Course Launch: How to Read and Write CSV Files in Python

Another Python course is now available on Vertabelo Academy. “How to Read and Write CSV Files in Python” is an online course for anyone interested in working with files in Python—a must-have skill for any beginner software developer or data scientist! After the great success of our SQL courses, we began working hard on the Python learning path. So far, we’ve made five Python courses available, and we’re proud to announce the release of yet another one: How to Read and Write CSV Files in Python!

New Course Launch: GROUP BY Extensions in MS SQL Server

If you’re looking for an online course to improve your SQL skills for Microsoft SQL Server or simply want to pass the Microsoft SQL certification, you’re in the right place. Vertabelo Academy’s new course—GROUP BY Extensions in MS SQL Server—is a perfect way to learn how to create advanced reports or facilitate ETL processes. At Vertabelo Academy, you’ll find lots of general SQL courses that’ll teach you to work with any relational database.

Practical Ways to Improve the Performance of SQL Queries

Knowing how to improve SQL query performance is an important skill, especially when working with with large databases. In this article, you’ll learn how to write more efficient SQL queries to get results faster. The biggest difference between SQL and other languages is that SQL is a non-procedural language. In a non-procedural language you specify the results that you need but not the methods used to get it. The advantage of a non-procedural language is that it is easier to write programs, therefore it is common for non-programmer business users to generate reports from SQL queries.

Boo, It’s a Trick!

Halloween is not only the spookiest day of the year but also a great opportunity for some good old-fashioned pranking! We’re self-proclaimed pranksters, true, but this time you’re lucky. We’re out for a party, so you won’t be getting tricked today—sorry to disappoint 🙂 In any case, we hope to see you next time you decide to learn data science. Have a happy Halloween!

Vertabelo Academy Bundles: Learn Skills in Bulk

Buy courses individually or in packs! Find out what courses are in each course bundle and learn the skills you need. For the first time in the history of Vertabelo Academy, you can get them with 70% discount! At Vertabelo Academy, you can buy courses individually or in bundles. Bundles, to put it simply, are packs of courses that teach you one technology (e.g., SQL) or one particular topic (e.

SQL Crossword #3: Test your basic querying knowledge and win a prize! (Halloween Edition)

How much SQL do you know? Test your knowledge with this spooky crossword to find out! Contest Rules Downloadthe Vertabelo Academy SQL crossword. Solve tasks and unlock the secret solution. Send your answerto marketing@vertabelo.com before 👉 November 1, 2018. Wait for the prize to be drawn and, if you’re lucky, win a course 💜 One lucky winner will be drawn among the users who send us the correct solution, and they’ll be contacted by email within 7 days of the contest closing.

Halloween Contest: Win a Course Bundle of Your Choice!

Share a pic of your DIY jack-o’-lantern or halloween costume to win a spooky prize. Halloween is upon us! And there’s lots of costume parties and trick-or-treating to be had. But if you’d just like to chill at home, we invite you to join us in our online festivities—and possibly even win a course bundle of your choice! This Halloween season, Vertabelo Academy is hosting a jack-o’-lantern and costume contest.

How to Start a Job in IT with Vertabelo Academy

Information technology is one of the hottest industries in the world and offers thousands of job in each major city around the globe. If you’re a student or professional who wants to get IT skills and find your first job in the industry, Vertabelo Academy can help you get started. The range of IT jobs available is stunning—from software engineers to system administrators and data scientists, IT rules the job market.

New Course Launch: Python Basics for Programming

The Vertabelo Academy Team has been working hard to release a brand-new course, and it’s finally here! Python Basics for Programming is a great place to start for anyone aspiring to become a software developer. Since our SQL courses, the Vertabelo Academy platform has been embraced by thousands of students who are eager to learn new technologies. After releasing Intro to Python for Data Science last month, we asked ourselves: why not create another introductory Python course, but this time from a software developer’s perspective?

SQL Crossword #2: Test your basic querying knowledge and win a prize!

How much SQL do you know? Test your knowledge with this crossword to find out! Contest Rules Download Vertabelo Academy SQL crossword. Solve tasks and unlock its solution. Send your answer at marketing@vertabelo.com before👉 September 8, 2018. Wait and win a special prize 💜  Prizes will be drawn among the users who will send us the correct solution. Then winners will be contacted by email within 7 days from contest closing.

How to Help Employees Develop IT Skills with Vertabelo Academy

One of the oldest jokes in the business world goes like this: The CFO asked the CEO, “What happens if we invest in developing people and they leave us?” The CEO answered, “What happens if we don’t and they stay?” If you’re like the CEO and want to help your employees grow, this article will explain how you can do so with Vertabelo Academy. Vertabelo Academy has been around since 2015.

New Course Launch: Intro to Python for Data Science (no IT background required)

Over the past three months, we’ve been working on something completely new. Please welcome our new course on Python data analysis! We got many emails from users like you with good feedback on our Introduction to R course. So first, I want to start off with a big thank you—reading your wonderful comments was like a burst of energy! We’re always looking to improve our offerings, and we greatly value your input.

Inside a Data Science Team: 5 Tips to Avoid Communication Problems

Data science professionals frequently coordinate their workloads, host meetings to discuss and share ideas, and collaborate to solve problems. But all it takes for things to fall apart is a lack of clear communication. Data Science is a team sport that involves a variety of professionals working together to solve technological problems. However, you need good communication for your team to run like a well-oiled machine. You may be thinking that poor communication isn’t that big of a deal.

How It Works

Brush up on your data science and SQL skills with Vertabelo Academy’s interactive courses. Why Vertabelo Academy? You get instant access to lessonsthat teach various concepts of SQL, data science, and programming in R (soon also in Python!). Our courses are appropriate for people who have no prior knowledge of computer science or programming. The only requirement is a web browser. No need to install databases, download example tables, or spend time inventing exercises for yourself.

SQL Advent Challenge 2017: Day 24 (Final Call)

Unfortunately, all good things must come to an end—this is your last query task for this season! We hope you’ve enjoyed the challenges so far. The good news, however, is that you got to practice your SQL skills. At this point, you’re only one step away from completing ourcrosswordand getting a Vertabelo Academy discount on a course of your choosing. Task #24: How much did Santa Claus pay for each toy he purchased from the musiccategory?

SQL Advent Challenge 2017: Get 25% OFF for Helping Santa (updated list of tasks)

Wanna be part of this year’s Christmas success? Santa needs your help organizing his Christmas deliveries. For this occasion, we’ve prepared a special Christmas database. While working on tasks, you’ll help Santa Claus deliver gifts to children. For this upcoming Christmas, we’ve prepared a 24-Day SQL Advent challenge. From now until Christmas Eve, we’ll publish daily SQL tasks for you to complete. If you’ve completed or recently started our SQL Basics course, or if you already have basic SQL knowledge, then this event is perfect for you!

SQL Advent Challenge 2017: Day 23

Task #23: Santa Claus ordered a gift for a particular child on December 12th, but that gift has not been delivered yet. Who is the child? Answer 23 for the crossword: The child’s name. Challenge Accepted? Use the SQL Advent Challenge sandbox to solve tasks and practice writing all kinds of SQL queries.

SQL Advent Challenge 2017: Day 22

Task #22: Find the name of the toy that most children asked for in their letters. Select the toy name and the number of requests for this toy. Answer 22 for the crossword: The toy name. Challenge Accepted? Use the SQL Advent Challenge sandbox to solve tasks and practice writing all kinds of SQL queries.

SQL Advent Challenge 2017: Day 21

Task #21: Santa Claus wants to buy some surprises for children from Argentina who either didn’t ask him for any toys or simply didn’t send him any letters. Help Santa Claus find the names of these children. Sort the records by child name in ascending order. Answer 21 for the crossword: The name of the last child in the result set. Challenge Accepted? Use the SQL Advent Challenge sandbox to solve tasks and practice writing all kinds of SQL queries.

SQL Advent Challenge 2017: Day 20

Task #20: Retrieve the name of the child who did not write a letter to Santa and whose country name is composed of two words. Answer 20 for the crossword: The child’s name. Challenge Accepted!? Use the SQL Advent Challenge sandbox to solve tasks and practice writing all kinds of SQL queries.

SQL Advent Challenge 2017: Day 19

Task #19: In which store did Santa Claus spend the most on gifts? Answer 19 for the crossword: The second word in the store name. Challenge Accepted? Use the SQL Advent Challenge sandbox to solve tasks and practice writing all kinds of SQL queries.

SQL Advent Challenge 2017: Day 18

Task #18: How many letters were written by children from countries other than those in which there was at least one naughty child? Answer 18 for the crossword: The number returned by the query, with the digits reversed. Challenge Accepted? Use the SQL Advent Challenge sandbox to solve tasks and practice writing all kinds of SQL queries.

SQL Advent Challenge 2017: Day 17

Task #17: Which children were naughty this year, and what countries are they from? Sort the records by country name in descending order and by child name in ascending order. Answer 17 for the crossword: The name of the last child in the result set. Challenge Accepted? Use the SQL Advent Challenge sandbox to solve tasks and practice writing all kinds of SQL queries.

SQL Advent Challenge 2017: Day 16

Task #16: Retrieve the largest number of toys that children asked for on a particular day during the period from December 6, 2017 through December 16, 2017. Answer 16 for the crossword: The number returned by your query. Challenge Accepted? Use the SQL Advent Challenge sandbox to solve tasks and practice writing all kinds of SQL queries.

SQL Advent Challenge 2017: Day 15

Task #15: What gifts did Santa Claus buy for children from the World of Sweets store? Sort the results by gift name in ascending order. Answer 15 for the crossword: The name of the last gift in the result set. Challenge Accepted? Use the SQL Advent Challenge sandbox to solve tasks and practice writing all kinds of SQL queries.

SQL Advent Challenge 2017: Day 14

Task #14: Retrieve the names of all stores from which Santa Claus purchased gifts for children. Sort the results by store name in ascending order. Answer 14 For the Crossword: The first word in the last store name of the result set. Challenge Accepted? Use the SQL Advent Challenge sandbox to solve tasks and practice writing all kinds of SQL queries.

SQL Advent Challenge 2017: Day 13

Task #13: By coincidence, all children who sent Santa a letter on December 14th asked for gifts from some categories. Determine names of these categories. Answer 13 for the Crossword: Name of one of the categories. Challenge Accepted? Use the SQL Advent Challenge sandbox to solve tasks and practice writing all kinds of SQL queries.

SQL Advent Challenge 2017: Day 12

Task #12: Select the number of letters that Santa Claus received on each day of the period from December 1, 2017 through December 5, 2017. Answer 12 For the Crossword: The spelled-out version of the number of letters Santa received on December 4th. Challenge Accepted? Use the SQL Advent Challenge sandbox to solve tasks and practice writing all kinds of SQL queries.

SQL Advent Challenge 2017: Day 11

Task 11: For each country in which at least one child forgot to ask Santa for a gift, select the country name and the number of letters children sent from that country. Sort the records by country name in ascending order. Answer 11 for the Crossword: The name of the last country in the result set. Ready to Challenge? Use the SQL Advent Challenge sandbox to solve tasks or practice writing all kinds of SQL queries.

SQL Advent Challenge 2017: Day 10

Task 10: Which children wrote letters to Santa Claus but forgot to ask him for gifts? Retrieve the names of these children and the countries from which they come. Sort the records by child name in ascending order. Answer 10 for the crossword: The name of the third child in the result set. Ready to Challenge? Use the SQL Advent Challenge sandbox to solve tasks or practice writing all kinds of SQL queries.

SQL Advent Challenge 2017: Day 9

Task 9: Select the names of the countries from which Santa Claus received the most letters. You can use the result of the previous task to write your query. Answer 9 for the crossword: The country name that is composed of one word.

SQL Advent Challenge 2017: Day 8

Task #8: What is the largest number of letters that Santa Claus received from among the various countries on his list? Answer For the Crossword: The spelled-out version of the number your query returned.

SQL Advent Challenge 2017: Day 7

Task #7: Retrieve the names of countries from which there are no children on Santa Claus’s list. Sort the results by country name in ascending order. Answer for the crossword: The name of the first country in the result set.

SQL Advent Challenge 2017: Day 7

Task #7: Retrieve the names of countries from which there are no children on Santa Claus’s list. Sort the results by country name in ascending order. Answer for the crossword: The name of the first country in the result set.

SQL Advent Challenge 2017: Day 6

Task 6: How many letters did children from each country starting with the letter ‘P’ send to Santa Claus? Sort the records by country name in ascending order. Answer for the crossword: The name of the last country in the result set.

SQL Advent Challenge 2017: Day 5

Task #5: Which children sent more than two letters to Santa Claus? Retrieve the children’s names, their country names, and the number of letters they sent. Sort the records by children’s names in ascending order. Answer for the crossword: The name of the first child in the result set.

SQL Advent Challenge 2017: Day 5

Task #5: Which children sent more than two letters to Santa Claus? Retrieve the children’s names, their country names, and the number of letters they sent. Sort the records by children’s names in ascending order. Answer for the crossword: The name of the first child in the result set.

SQL Advent Challenge 2017: Day 4

Task #4: How many letters did children from the United States, Canada, and Argentina write to Santa Claus? Select the names of these three countries and the number of letters their children sent. Sort the records by number of letters in ascending order. Answer 4 for the Crossword: The name of the first country in the result set.

SQL Advent Challenge 2017: Day 3

Task #3: Select the names of all children who come from Chile. Answer for the Crossword: The child’s name that is composed of the least number of letters.

SQL Advent Challenge 2017: Day 2

Task #2: Write a query that determines how many children come from the first country in the result set you obtained for the first task (all five-letter country names from the Santa Claus database, in ascending order). Display both the country name and the number of children who come from it. For the Crossword: The name of the country.

SQL Advent Challenge 2017: Day 2

Task #2: Write a query that determines how many children come from the first country in the result set you obtained for the first task (all five-letter country names from the Santa Claus database, in ascending order). Display both the country name and the number of children who come from it. For the Crossword: The name of the country.

SQL Advent Challenge 2017: Day 1

Task #1: Retrieve all five-letter country names from the Santa Claus database, and sort them in ascending order. Answer For the Crossword: The name of the last country in the result set.

SQL Advent Challenge 2017: Day 1

Task #1: Retrieve all five-letter country names from the Santa Claus database, and sort them in ascending order. Answer For the Crossword: The name of the last country in the result set.

SQL Crossword #1

How much SQL do you know? Test your knowledge with this crossword to find out! Download SQL Crossword #1 Psst! Be the first to post your answer in the comment section belowand get 50% OFF on the selected course.  

The Complete Beginner’s Guide to SQL Fundamentals

Vertabelo Academy is a great place to learn SQL. If you’re a complete beginner, it’s best to have an overview of what SQL is, what a database is, and how they work together. In this article, you’ll find a quick explanation of all you need to get started with SQL. The Database You might have already heard that SQL is used with databases. What exactly is a database? In the most general sense, it is an organized collection of various kinds of data.