This Month in Database: The SQL Edition
This Month in Database: The SQL Edition
Whether you want to improve the performance of your SQL SELECT statements by 80% with 20% effort or just want to learn the very basics of databases, there's something in this article for you.
Join the DZone community and get the full member experience.Join For Free
Discover Tarantool's unique features which include powerful stored procedures, SQL support, smart cache, and the speed of 1 million ACID transactions on a single CPU core!
This month in Database, we're continuing to do something a little different. In the past, we've looked at a variety of topics in these posts — like in the August edition, when we talked about graph theory, Async modules, and talking to databases. But like we did for Big Data last time, we're going to wrap up the month with a deep dive into one topic. This time, it's SQL!
Top 5 SQL Articles on DZone
We dug through the SQL-related articles on DZone (which is a lot of articles!), and these are the cream of the crop.
6 Simple Performance Tips for SQL SELECT Statements by Mpumelelo Msimanga. Performance-tuning SELECT statements can be a time-consuming task — but 20% effort will basically give you an 80% performance improvement, so it's well worth it.
Connecting to SQL Azure With SQL Management Studio by Rob Sanders. If you want to manage your SQL databases in Azure using tools that you're familiar and comfortable with, check out these intuitive, screen-based instructions.
Custom Date Formatting in SQL Server by Boyan Kosadinov. SQL Server doesn't always adhere to its date/time formatting. So here's how to create your own.
10 Easy Steps to a Complete Understanding of SQL by Lukas Eder. SQL is one of the few declarative languages out there, and as such, behaves in an entirely different way from imperative, object-oriented, or even functional languages. If you're looking for a quick and dirty way to gain an understanding of SQL, check out this tutorial.
Configuring Spring Boot for Microsoft SQL Server by John Thompson. Accessing and configuring your SQL Server instance is pretty simple — if you're using Spring Boot. Learn about the legwork you need to do before Spring can fill in the defaults for you.
PS: Are you interested in contributing to DZone? Check out our brand new Bounty Board, where you can apply for specific writing prompts and win prizes!
Seeing SQL Sequel
Get it? It's like a sequel to the above section on SQL articles on DZone, and you're seeing it. Yeah... anyways, let's journey outside of DZone and check out some recent news, conferences, and more that should be of interest to SQL newbies and experts alike.
SQLBits is the largest SQL Server conference in Europe and is dedicated to spreading the knowledge of the passionate SQL community. The website claims that you'll learn more in four days than you did in the entire last year. The conference will be taking place in London from February 21-24, 2018. Get your passes before they run out!
DataCore tech cranks wheezing SQL Servers to ridiculous speeds (September 26, 2017). DataCore has crafted a driver for SQL Server that runs IO requests simultaneously and increases throughput. Modern CPUs have multiple cores, with each supporting more than one threads to execute concurrently. But with this driver, parallelizing IO is like punching the hyperspace button!
If you are a beginner in the world of databases and SQL, the following video is for you! With nearly 600K views and an overwhelming majority of likes, this video is a fun, energetic, and clear intro to SQL and databases that just about anybody can understand. Check it out below:
Dive Deeper Into SQL
The DZone Guide to Database and Data Persistence Tools and Techniques. Discover the best database management systems, frameworks, and methods for data storage and retrieval and learn which tools and techniques developers are using for data persistence.
SQL Syntax for Apache Drill: Using SQL for the SQL-on-Everything Engine. In this DZone Refcard, discover the benefits of data agility and gain faster insights into BI and analytics through advanced SQL queries on massive datasets.
Jobs for the SQL Expert
Below are a few jobs that may pique your interest if you're a SQL aficionado. Check them out and apply today! (PS: If you don't see anything you like here, you can check out our Job Board with a lot more listings!)
Senior Software Development Engineer
Location: Chicago, Illinois, United States
Experience: Minimum of 5-7 years' experience in software development methodologies/processes, design, implementation, and documentation within the order or billing management industry; experience with database SQL and design (Oracle, MS SQL Server, Postgres, NoSQL).
Software Engineer: Backend
Optimizory Technologies Private Limited
Location: Noida, Uttar Pradesh, India
Experience: Experience programming in Java and/or Scala; using Spring, Hibernate, Play, and Akka frameworks; and using multiple databases in cluding Postgres, MySQL, MariaDB, Oracle, and SQL Server.
That's all for September's This Month in Big Data post! What would you like to learn about next time? Let us know in the comments!
Opinions expressed by DZone contributors are their own.