|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-analysis-filter-sort-data-in-sql-server-ssms-t-sql/
课程评论：没有评论
课程名称：数据分析：在SQL Server中筛选和排序数据，SSMS T-SQL 课程概述：数据分析是一个检查、清洗、转换和建模数据的过程，旨在发现有用信息、提供结论并支持决策。微软SQL Server是由微软开发的关系数据库管理系统，其主要功能是根据其他软件应用的请求存储和检索数据，并可以在同一计算机或网络上运行的另一台计算机上访问。SQL Server管理工作室（SSMS）是一个集成环境，用于管理任何SQL基础设施，可用于访问、配置、管理、管理和开发SQL Server、Azure SQL数据库、Azure SQL托管实例、Azure VM上的SQL Server及Azure Synapse分析的所有组件。SSMS提供一个综合性工具，结合了广泛的图形工具和丰富的脚本编辑器，为各级开发人员和数据库管理员提供对SQL Server的访问。 T-SQL（Transact-SQL）是SQL语言的扩展，主要在Microsoft SQL Server中使用，这意味着它提供了SQL的所有功能，并附加了一些额外的扩展。排序是将数据按有意义的顺序排列的过程，以便更有效地进行分析。例如，您可能希望按日历月份对销售数据进行排序，以便生成销售业绩的图表。可以将文本数据按字母顺序排序，将数字数据按数值顺序排序。使用ORDER BY关键字可以将结果集按照升序或降序排序，默认情况下记录将按升序排序，若要按降序排序，则使用DESC关键字。 数据过滤是选择数据集的较小部分并使用该子集进行查看或分析的过程。SQL中的WHERE子句指定SQL数据操作语言（DML）语句只应影响满足特定条件的行。SQL WHERE子句用于从SQL语句中提取特定结果，例如：SELECT、INSERT、UPDATE或DELETE语句。通过使用WHERE子句可以过滤数据。 本课程将帮助学员掌握数据分析的基本技能，使用SQL Server和SSMS进行数据排序和过滤，从而提高数据处理能力。
Data analysis is a process of inspecting, cleansing, transforming, and modelling data with the goal of discovering useful information, informing conclusions, and supporting decision-making.Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications-which may run either on the same computer or on another computer across a network.SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure. Use SSMS to access, configure, manage, administer, and develop all components of SQL Server, Azure SQL Database , Azure SQL Managed Instance, SQL Server on Azure VM, and Azure Synapse Analytics. SSMS provides a single comprehensive utility that combines a broad group of graphical tools with many rich script editors to provide access to SQL Server for developers and database administrators of all skill levels.T-SQL, which stands for Transact-SQL and is sometimes referred to as TSQL, is an extension of the SQL language used primarily within Microsoft SQL Server. This means that it provides all the functionality of SQL but with some added extras.Sorting is the process of arranging data into meaningful order so that you can analyse it more effectively. For example, you might want to order sales data by calendar month so that you can produce a graph of sales performance. You can sort text data into alphabetical order. sort numeric data into numerical order. The ORDER BY keyword is used to sort the result-set in ascending or descending order. The ORDER BY keyword sorts the records in ascending order by default. To sort the records in descending order, use the DESC keyword.Data filtering is the process of choosing a smaller part of your data set and using that subset for viewing or analysis.A WHERE clause in SQL specifies that a SQL Data Manipulation Language (DML) statement should only affect rows that meet specified criteria.. SQL WHERE clause is used to extract only those results from a SQL statement, such as: SELECT , INSERT , UPDATE , or DELETE statement. Using the WHERE clause t you can filter data.
