|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-basics-for-telecom-engineers/
课程评论：没有评论
**课程名称：SQL基础：电信工程师专项** **课程概述：** 作为一名电信工程师，无论是在无线接入网（RAN）、传输还是核心网，您都需要处理海量的计数器数据，例如呼叫数量、RACH尝试次数、RRC尝试次数、被叫失败次数和掉话次数等。这些数据通常存储在数据库中。本课程旨在帮助您掌握SQL（结构化查询语言），通过有效地查询和分析这些数据，从而为射频规划、优化、传输规划以及核心网规划等工作提供决策支持，以提升网络性能。 SQL是一种广泛应用于数据库访问和操作的编程语言。相比于Python等其他语言，SQL以其简洁性和专注于数据处理的特性而著称，学习门槛较低，是进行快速高效数据分析的理想工具。 **课程涵盖的SQL主题：** * **SQL入门：** 介绍SQL的基本概念和用途。 * **SELECT语句：** 学习如何从数据库中选择和检索数据。 * **SQL聚合函数：** 掌握SUM（求和）、AVG（平均值）等函数，用于汇总数据。 * **过滤方法：** 学习使用WHERE子句对数据进行筛选。 * **UNION语句：** 了解如何合并两个或多个SELECT语句的结果。 * **JOIN语句：** 重点学习如何连接数据库中的多个表，包括： * **INNER JOIN** * **LEFT JOIN** * **RIGHT JOIN** * **FULL JOIN** * **CASE WHEN语句：** 学习使用条件逻辑来创建更复杂的查询。 **课程目标：** 完成本课程后，您将能够编写SQL代码和脚本，从数据库中提取所需的计数器数据。这将使您能够有效地分析数据变化行为，并根据分析结果采取适当的行动，以优化和提升电信网络的整体性能。
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 networkSQL is one of the most popular programming language that lets you access and manipulate databasesSQL 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:IntroSELECT 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.
