1Data Analysis Fundamentals with the SQL Language
1.1. Data at the heart of the information system
1.1.1. Introduction
The development of IT solutions becomes more complicated from one day to the next due to the ever-increasing complexity of information systems and the need to align business needs with these IT solutions. In every generation of information system, data remains the cornerstone of these IT solutions. This importance is due to the static aspect of data in real-world modeling and the ability to provide any processing requested by application developers to meet the needs of the business logic layer.
Figure 1.1 shows the position of data in the urbanization of information systems according to the Enterprise Architecture (EA) vision1. This model puts two of the components on equal footing: data and applications.
Indeed, 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 SQL.
Figure 1.1. Enterprise architecture
1.1.2. Mind map of the first section
This first section will be devoted to introducing the basics of databases, the SQL language and Microsoft SQL Server DBMS.
Figure 1.2 presents a mind map of the different concepts that will be covered in this section.
1.1.3. Concept of a database
A database (referred to ...
Get Analytic SQL in SQL Server 2014/2016 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
