28 Sep 2023 LearnSQL.com Team New Monthly SQL Practice for October 2023! In our October 2023 SQL Practice, you meet Sophie. She manages an online business for publishing and printing books and needs you to access and present various statistics to help her grow her business. Can you use your SQL skills to help? It should not be too hard if you have finished our SQL Basics courses or otherwise understand core SQL concepts. Our interactive SQL course is a great way to test your skills and see if you can put what you've learned so far into practice. Read more 4 Sep 2023 LearnSQL.com Team SQL Server Cheat Sheet Welcome to the SQL Server Cheat Sheet! Whether you're just starting out with SQL Server or you're a seasoned developer looking for a quick reference, this guide is tailored for you. This cheat sheet is a comprehensive guide to SQL Server, offering a quick reference to its essential commands. It covers the basics of creating and displaying databases and tables, the commands to modify tables, and the fundamental syntax for T-SQL commands such as SELECT, INSERT, UPDATE, and DELETE. Read more 1 Sep 2023 LearnSQL.com Team Free Course of the Month – SQL Practice Set in PostgreSQL Do you know the basics of PostgreSQL but still need some practice? Look no further! Here is a great interactive course, SQL Practice Set in PostgreSQL. Throughout the month of September, you have access to it for FREE! We at LearnSQL.com believe that to learn a new skill, you need basic theoretical knowledge and, above all, a lot of practice. It's the same with writing PostgreSQL queries – you need a lot of PostgreSQL practice. Read more 29 Aug 2023 LearnSQL.com Team New Monthly SQL Practice for September 2023! Ready for our new SQL challenge? This time, we have prepared slightly more difficult SQL tasks. Here’s the September SQL Practice course! This time, you will help Evelyn, the owner of a local art gallery. She would like to gather data to grow her business and has hired you as an SQL specialist to help her out. Which art pieces have not been exhibited? What is the transportation cost for each art piece? Read more 25 Aug 2023 LearnSQL.com Team SQL for Data Analysis Cheat Sheet Welcome to our SQL for Data Analysis Cheat Sheet — a must-have resource for anyone looking to harness the power of SQL in the realm of data analysis. Whether you're a data enthusiast, a business analyst, or a seasoned data professional, this cheat sheet is designed to empower you to extract valuable insights from your datasets. Inside, you'll find a carefully curated collection of SQL commands and tips that will elevate your data analysis game. Read more 28 Jul 2023 LearnSQL.com Team New Monthly SQL Practice for August 2023! Are you an SQL beginner needing some interactive exercises to practice writing queries? Take the challenge and choose our August SQL Practice course. This is your next step towards becoming a pro. In our August 2023 SQL Practice, you meet Abigail, the manager of a local healthcare clinic. She needs you to help her gather the right statistics on the patients and the medical procedures they need. Use your SQL skills to help her find the data! Read more 30 Jun 2023 LearnSQL.com Team Here Are Our New SQL Flashcards Preparing for an SQL exam or Data Job interview? Save these SQL Flashcards and always have them to hand, so you don’t forget anything during the most important moments. At LearnSQL.com, we understand that everyone has a unique learning style and pace. That's why we’ve created SQL Flashcards. They can help you during preparation for an exam or to consolidate your SQL knowledge. They are carefully crafted to help you reinforce your understanding of SQL concepts, syntax, and commands, making them an invaluable companion on your SQL learning journey. Read more 30 Jun 2023 LearnSQL.com Team New Monthly SQL Practice for July 2023! Ready for our new SQL challenge? This time, we have prepared slightly more difficult SQL tasks. Here’s the July SQL Practice course! You will help Isabella, the founder of an online home swap platform. On this platform, homeowners can find a place to stay for vacation by swapping homes with other homeowners. Isabella would like to gather data to help her expand the business, and she has hired you as an SQL specialist. Read more 26 Jun 2023 LearnSQL.com Team 53 Years of Relational Databases If it weren't for him, there would be no modern databases. It is the 53st anniversary of the publication of his article that changed the rules of the game. Edgar Frank Codd is one of the fathers of SQL, and his name is one of the first to be mentioned in the history of databases. Or maybe even the history of computer development in general? See what we owe to Dr. Read more 5 Jun 2023 LearnSQL.com Team MySQL Cheat Sheet Welcome to the MySQL cheat sheet! Whether you're just starting out with MySQL or you're a seasoned professional looking for a quick reference, this guide is tailor-made for you. This MySQL Cheat Sheet provides a concise and handy reference to the most commonly used MySQL commands and functionalities. It spans a range of topics, from connecting to a MySQL server and managing database contents, to the basic syntax for table creation and modification. Read more «« « 1 2 3 … 10 » »»