Data Analysis Fundamentals with the SQL Language

The role of data in meeting the needs of the business logic layer is essential, whether through the applications component or by direct access to the data component by means of a query language such as Structured Query Language (SQL). This chapter introduces the basics of databases, the SQL language and Microsoft SQL Server database management system (DBMS). Microsoft SQL Server is a relational DBMS. According to the
db‐engines.com
website, it is ranked the third DBMS among a list of 343 DBMS of different categories as of January 2019. The chapter presents the top 10 DBMSs according to this ranking. Microsoft SQL Server is a full environment for data management over both transactional and analytical axes. SAL analytic functions consist of strengthening its analytical capacity to further support managers in supervising their activities via dashboards generated by direct access to data.