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 Security Tutorial – Part 5

SQL Server Security Tutorial from Coding compiler | SQL Server DBA Tutorial – Part 5, this blog is the fifth tutorial in the series, here you are going to learn about how SQL server security works. Before going to learn this tutorial, we recommend you to go through the previous SQL Server Restoration DBA Tutorial – Part 4.

Topics Covered in this SQL Server DBA Tutorial

  • Security Basics
  • Levels of Security
    • Server level
    • Database level
    • Object level
  • Security Processes
    • Authentication
    • Authorization
    • Encryption

Read more

SQL Server DBA Tutorial – Part 4

SQL Server Restoration Tutorial from Coding compiler | SQL Server DBA Tutorial – Part 4, this blog is the fourth tutorial in the series, here you are going to learn about how SQL server restoration works. Before going to learn this tutorial, we recommend you to go through the previous SQL Server Backups DBA Tutorial – Part 3.

Topics Covered in this SQL Server DBA Tutorial

  • SQL Server Restoration
  • Situations for Restoration
  • Restoring Backups using SSMS (GUI)
  • Restoring Enhancements in SQL Server 2012

Read more

SQL Server DBA Tutorial – Part 3

SQL Server Backup Tutorial from Coding compiler | SQL Server DBA Tutorial – Part 3, this blog is the third tutorial in the series, here we are going to learn about these below topics. Before going to learn this tutorial, we recommend you to go through the SQL Server DBA Tutorial – Part 1 and SQL Server DBA Tutorial – Part 2.

Topics Covered in this SQL Server DBA Tutorial

  • Introduction to Backups
  • Recovery Models
  • Backup Types
  • Advanced Backup Types
  • Situations of Tail Log Backup

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

Advanced SSRS Interview Questions For Experience

SSRS Interview Questions And Answers. If you are looking for SQL Server Reporting Services Interview Questions, here is the comprehensive list from basic to most advanced SSRS interview questions for 2+, 3+, 4+, 5+, 6+ years of SSRS experienced professionals. When attending interviews for experienced roles, you should know practical SSRS interview questions, and real-time SSRS scenario based interview questions. … Read more

SSIS Interview Questions And Answers For Experienced

SSIS Interview Questions And Answers. If you are looking for SQL Server Integration Services Interview Questions, here is the comprehensive list from basic to most advanced SSIS interview questions for 2+, 3+, 4+, 5+, 6+ years of SSIS experienced professionals. When attending interviews for experienced roles, you should know practical SSIS interview questions, and real-time SSIS scenario based … Read more