\documentclass[11pt]{report}
\usepackage{titlesec}
\usepackage{charter}
\usepackage
[
   a4paper,
   left=2cm,
   right=2cm,
   top=3cm,
   bottom=4cm,
]
{geometry}
\usepackage{listings}
\lstset
{
    language=SQL,
    basicstyle=\footnotesize,
    numbers=left,
    stepnumber=1,
    showstringspaces=false,
    tabsize=4,
    breaklines=true,
    breakatwhitespace=false,
}



\titleformat{\chapter}[display]
  {\Huge\bfseries}
  {}
  {0pt}
  {\thechapter.\ }
  
\titleformat{name=\chapter,numberless}[display]
  {\Huge\bfseries}
  {}
  {0pt}
  {}
  
\pagenumbering{arabic}

