SQL Getting Started Guide

Welcome to the Coding compiler. We bring your attention to the article with the screaming title of “Getting Started SQL in 20 Minutes”, Of course, you will not master all SQL in 20 minutes, but you will get a good start.

SQL Fundamentals

Every self-respecting web developer should know SQL. Although it already exists since the 70s of the last century, it is still very widely used, and without it it will be difficult to create something serious. Most full-stack frameworks can work with SQL. Among them: ActiveRecord ,  Doctrine ,  Hibernate and many others. Despite this, sometimes you have to “mess your hands” and go into real SQL.

That’s why we have prepared a short introduction in which we will go through the fundamental things in SQL. We strongly recommend that you try all the examples below on your own, because, as you know, a theory is nothing without practice. Well, let’s get started!

Read more

SQL Server DBA Tutorial – Part 2

SQL Server DBA Tutorial – Part 2 from Coding compiler. This is the second tutorial in the series of SQL server dba tutorials. Here you are going to learn about service accounts, SQL server 2012 installation, SQL server databases and database properties. Before going to learn this tutorial, we recommend you to go through the SQL Server DBA Tutorial – Part 1

Topics Covered in this SQL Server DBA Tutorial

  • Service Accounts
  • Installing SQL Server 2012
  • Post Installation Steps
  • Introduction to SQL Server Database
  • How to create database in SQL server?
  • SQL Server Database Properties

Read more

Tricky SQL Server Interview Questions And Answers For Experienced

Interview Questions

SQL Server Interview Questions And Answers For Experienced. Here Coding compiler sharing a comprehensive list of 250 SQL Server Interview Questions. This list is prepared by the industry expert SQL Server professionals, it will help you to crack your next SQL Server job interview. These complex SQL Server questions were asked in many top MNC companies … Read more