Overview

Course Description

In this course, you will learn how to write clean SQL code. Clean Code is about writing code which is not only understandable to the developer him/herself but to the others as well. Also, it makes it easier to understand your own code after an extended period of time, when you will need to upgrade it.

Basic principles

You will learn about the basic clean code concepts such as SQL keyword principles or indenting. These are the main concepts that a developer needs to keep in mind when writing SQL code.

Intermediate principles

These concepts are referring to aliases, data type conventions, naming conventions and comments. These concepts will make you a better developer and using them in the right way can help you as a developer and you colleagues in future developments.

Advanced principles

The advanced principles are the cherry on top. By applying these rules, your code will look exceptionally. You will find it very easy to debug and upgrade, having in mind that SQL queries can easily get huge.

This is a great course to take after the 'Databases & SQL - Introduction Course' and after finishing this course, you will be able to write readable and maintainable code. Starting from here, your code won't look so complex anymore.

What you'll learn

  • The most important clean code concepts that can be applied to SQL code

  • A list of principles to apply in your day to day SQL programming activity

  • How to write SQL code that is easily readable by other developers

  • How to develop SQL code that can be comfortably upgraded in the future

Requirements

  • Familiarity with SQL programming language

  • Desire to write code that can be easily read and upgraded

Who this course is for

  • SQL Developers who want to learn to write clean code

  • Anyone with SQL knowledge who wants to take their skill to the next level

  • Web/Desktop/Mobile Developers who want to learn some clean code principles for developing code for their databases

About the instructor

  • 0.00 Instructor Rating
  • 0 Reviews
  • 4 Students
  • 2 Courses

Matei Dogeanu

Dragon Zap Instructor

Hi! I am Matei and I live in Bucharest, Romania.

I graduated the faculty of Economic Informatics at the Academy of Economic Studies here in Bucharest and the master's degree of Business Support Databases at the same university.

I've been working in the IT industry for more than 5 years as a Senior Cloud Database Developer, Database Administrator and Data Warehouse Developer and I gained knowledge about multiple technologies such as Oracle, DB2 or Teradata, Snowflake, Power BI and many more.

I hope my knowledge will also help others to learn about databases.

Student feedback

  • Stars 5
  • 0%

  • Stars 4
  • 0%

  • Stars 3
  • 0%

  • Stars 2
  • 0%

  • Stars 1
  • 0%

0.00

Course Rating

Reviews

Rate This Course

  • What would you rate this course?

Related Courses

Get it now!
Preview Course
Get it now!
Preview Course

    Course Features

  • Lectures 13
  • Duration 0 hours
  • Skill level All levels
  • Language English
2.png

Not sure?


Every course comes with a 30-day money-back guarantee

Q&A


View the current questions and answers for this course here