SQL Basics for Telecom Engineers

As being a Telecom Engineer ,  RAN ,Transmission and core nodes are counting a lot of counters ( number of calls , RACH attempts , RRC attempts , number of blocked calls and dropped calls ,,,,) and saving them in a database.

As a RF planning / optimization , TX Planning , Core Planning member , you should query these data and analyze then taking the proper actions to enhance the performance of the network

• SQL is one of the most popular programming language that lets you access and manipulate databases

• SQL stands for Structured Query Language

SQL’s beauty lies in its simplicity. Compared to Python, SQL is a much simpler language. It’s also exclusively used for data. That means it’s easier to learn, and it provides the quickest, most efficient means of performing simple data analyses.

SQL Topics in the Course:

Intro

SELECT statements.

SQL Aggregations (SUM, AVG).

Filtration methods.

UNION Statement.

JOIN statement.

INNER JOIN.

LEFT JOIN.

RIGHT JOIN.

FULL JOIN.

CASE WHEN.

By the end of this course , you will learn how to write a SQL code  / script that will help you to extract the counters saved in the database to start analyzing and understanding the changes in data behavior and then you can take a proper action.