Author: Vertabelo Team

Trick or treat! Halloween is coming, the festival of ghosts and monsters! At Vertabelo Academy, it’s time for paranormal sales activities and a Halloween promotion. We also have a special Halloween challenge: a haunted SQL crossword puzzle. Even if you don’t have experience in SQL, you can solve it! Halloween Promotion Halloween is coming! Many of you are probably getting ready for costume parties and deciding whether to dress up as Dracula or Lord Vader this year.

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.

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.

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!

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.

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!

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.

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!

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.

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.

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.

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?

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.

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.

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.

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.

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.

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?

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!

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.