<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Pratibha shetty on Medium]]></title>
        <description><![CDATA[Stories by Pratibha shetty on Medium]]></description>
        <link>https://medium.com/@pratibhashetty2000?source=rss-4a80122b63be------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*wFhunuIo4mcQ6RMZZgxfZA.jpeg</url>
            <title>Stories by Pratibha shetty on Medium</title>
            <link>https://medium.com/@pratibhashetty2000?source=rss-4a80122b63be------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 20:09:40 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@pratibhashetty2000/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[DATABASE Stream Technical Training:]]></title>
            <link>https://medium.com/@pratibhashetty2000/database-stream-technical-training-e29df5d8db96?source=rss-4a80122b63be------2</link>
            <guid isPermaLink="false">https://medium.com/p/e29df5d8db96</guid>
            <dc:creator><![CDATA[Pratibha shetty]]></dc:creator>
            <pubDate>Wed, 12 Oct 2022 04:15:04 GMT</pubDate>
            <atom:updated>2022-10-22T06:30:59.076Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>Data</strong>: data is information that has been translated into a form that is efficient for movement or processing.<br><strong>database</strong> :data arranged in particular manner, stored in file<br><strong>DBMS:</strong> software handles storage of data ,retrieve of data, delete data<br><strong>RDBMS</strong>: data stores in the form of table and relation between table</p><p><strong>History of DBMS:</strong></p><p>The history of databases begins with the two earliest computerised examples. Charles Bachman designed the first computerised database in the early 1960s. This first database was known as the Integrated Data Store, or IDS. This was shortly followed by the Information Management System, a database created by IBM. data suddenly became important.</p><p>1940-usage of paper and pen</p><p>1945-usage of binary language</p><p>1960-usage of file system</p><p>1972-IBM ED COFF DBMS</p><p>1972-RDBMS</p><p><strong>SQL: </strong>Structured Query Language is a programming language used to communicate with and manipulate databases. SQL was developed in the 1970s by IBM researchers. Businesses and other organizations use SQL programs to access and manipulate the information and data in their databases and create and alter new tables.</p><p>creating table using SQL:<br>creating Database &lt;databse_name&gt;</p><p>creating table using SQL:</p><p>CREATE TABLE &lt;Table_name&gt;<br>{<br> column 1 data type(size),<br> column 1 data type(size)<br>}</p><p>ex: CREATE TABLE COMPANY.EMPLOYEE<br>{<br> EMPLOYEE_FNAME VARCHAR(100),<br> EMPLOYEE_LNAME VARCHAR(50),<br> PHONE_NO INT,<br> MAIL_ID VARCHAR(100)<br> EMPLOYEE_ID VARCHAR(100)<br>}</p><p>inserting data into table</p><p>Insert into &lt;table_name&gt; values (“data”);</p><p><strong>Constraint:</strong></p><p>constraints are used to specify rules for data in a table,<br>constraints are used to limit the type of data that can go into a table.</p><p><strong>NOT NULL</strong> — Ensures that a column cannot have a NULL value<br><strong>UNIQUE </strong>— Ensures that all values in a column are different<br><strong>PRIMARY KEY</strong> — A combination of a NOT NULL and UNIQUE. Uniquely identifies each row in a table<br><strong>FOREIGN KEY</strong> — Prevents actions that would destroy links between tables<br><strong>CHECK </strong>— Ensures that the values in a column satisfies a specific condition<br><strong>DEFAULT </strong>— Sets a default value for a column if no value is specified<br>composite key: is a combination of two or more columns in a table that can be used to uniquely identify each row in the table.</p><p>example:</p><p>CREATE TABLE employe (<br> emp_id INT PRIMARY KEY,<br> emp_name INT NOT NULL,<br> emp_code VARCHAR(20) UNIQUE,<br> emp_country VARCHAR(20) DEFAULT ‘india’<br>);</p><p>CREATE TABLE job (<br> emp_id int FOREIGN KEY REFERENCES employe(emp_id),<br> salary int CHECK (salary &gt;= 100)<br>);</p><p><strong>data warehouse</strong></p><p>A data warehouse is a central repository of information that can be analyzed to make more informed decisions. Data flows into a data warehouse from transactional systems, relational databases, and other sources, typically on a regular cadence.</p><p>7/8/22</p><p>DDL: Data definition language create, drop, truncate<br>DML: Data manipulation language select, insert delete, update<br>DCL: Data control language commit and Rollback</p><p>1. drop: drop table &lt;table _name&gt;<br>2. select: select *(all) from &lt;db anme&gt;.&lt;schema name&gt;.&lt;table _name&gt;</p><p>— DISTINCT — <br> select DISTINCT col_name from table_name<br> <br> — where — <br> select &lt;col_name&gt; from &lt;table_name&gt; where condition<br> <br> OPERTOR:</p><ul><li>is greater then or equal to &gt;=</li><li>is less than or equal to &lt;=</li><li>is not equal to !</li><li>is not equal to &lt;&gt;</li><li>Or operator OR</li><li>AND Operator</li><li>BETWEEN Operator</li><li>LIKE Like operator</li><li>NOT LIKE</li><li>IS NULL</li><li>IS NOT NULL</li><li>IN OPERATOR</li></ul><p>EXMPLE:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*7zh9W0nR_1aJxhAbVTr4ow.png" /></figure><p>STRING FUNCTIONS</p><ul><li><strong>TOP</strong> : is used to specify the number of records to return</li><li><strong>UPPER</strong> : function converts a string to upper-case.</li><li><strong>LOWER</strong>: function converts a string to lower-case.</li><li><strong>INITCAP</strong>: returns char , with the first letter of each word in uppercase, all other letters in lowercase</li><li><strong>TRIM</strong>: function removes the space character ,other specified characters from the start or end of a string.</li><li><strong>LTRIM</strong>: function helps to return remove all the space characters found on the left-hand side of the string.</li><li><strong>RTRIM</strong>: function helps to return remove all the space characters found on the right-hand side of the string.</li><li><strong>LEN</strong>: Return the length of a string</li><li><strong>REPLACE</strong>: function replaces all occurrences of a substring within a string</li><li>CASE WHEN STATEMENT</li><li>S<strong>UBSTRING</strong>: function extracts some characters from a string.</li><li><strong>CHARINDEX</strong>: function searches for a substring in a string, and returns the position.</li></ul><p>examples</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*8MYDRNHCAI4y63gWuvEvHg.png" /><figcaption>example for string operations</figcaption></figure><p>8/9/22</p><p>AGGREGATE FUNCTION</p><p>SUM — — ADDITION OF INTERGER NUMBER<br>AVG — -SUM DIVIEDE NUMBER OF ELEMENTS<br>MIN — -LOWEST VALUE OF THE DATA <br>MAX — -HIGHEST VALUES OF THE DATA<br>COUNT — -NUMBER OF ELEMENTS</p><p>examples</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*vNrc4hBHV0LcpSYr8TYe9g.png" /><figcaption>example of aggregate function</figcaption></figure><p>SELECT <em>column_name(s)</em><br>FROM <em>table_name</em><br>WHERE <em>condition</em><br>GROUP BY <em>column_name(s)<br></em>HAVING <em>condition<br></em>ORDER BY <em>column_name(s);</em></p><p>The <strong>ORDER BY</strong> keyword is used to sort the result-set in ascending or descending order.</p><p>The <strong>GROUP BY</strong> statement groups rows that have the same values into summary rows.</p><p><strong>Dense Rank function: </strong>DENSE_RANK computes the rank of a row in an ordered group of rows and returns the rank as a NUMBER</p><p><strong>Joins</strong></p><p>join clause is used to combine rows from two or more tables, based on a related column between them.</p><ul><li><strong>Inner join</strong> : Returns records that have matching values in both tables</li><li><strong>Left outer join</strong>: Returns all records from the left table, and the matched records from the right table</li><li><strong>Right outer join</strong>: Returns all records from the right table, and the matched records from the left table</li><li><strong>full outer join </strong>: Returns all records when there is a match in either left or right table</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*j1keUO4XlixWMBUm3GlLcQ.png" /><figcaption>example for join operation</figcaption></figure><p><strong>Inner query</strong></p><p>A Subquery or Inner query or a Nested query is a query within another SQL query and embedded within the WHERE clause. Subqueries can be used with the SELECT, INSERT, UPDATE, and DELETE statements along with the operators like =, &lt;, &gt;, &gt;=, &lt;=, IN, BETWEEN, etc.</p><p><strong>Drop ,Truncate, Delete, alter, Update</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*-sWUhyg8NC7LQV0U2s7C1A.png" /></figure><p><strong>Data Warehouse</strong></p><p>A data warehouse is a subject-oriented, integrated, time-variant and non-<br>volatile collection of data in support of management&amp; decision making process.</p><p>Subject-Oriented, Integrated, Time-Variant, Non-volatile</p><p>A data warehouse is a copy of transaction data specifically structured for<br>query and analysis.</p><p><strong>why?</strong></p><p>Data warehousing improves the speed and efficiency of accessing different data sets and makes it easier for corporate decision-makers to derive insights that will guide the business and marketing strategies.</p><p>Some of the most commonly used database operations are<strong> union, minus, Intersect</strong></p><h3>union</h3><p>The Union is a binary set operator in DBMS. It is used to combine the result set of two select queries. Thus, It combines two result sets into one.</p><h3>minus</h3><p>Minus is a binary set operator in DBMS. The minus operation between two selections returns the rows that are present in the first selection but not in the second selection. The Minus operator returns only the distinct rows from the first table.</p><h3>Intersect</h3><p>Intersect is a binary set operator in DBMS. The intersection operation between two selections returns only the common data sets or rows between them. It should be noted that the intersection operation always returns the distinct rows. The duplicate rows will not be returned by the intersect operator.</p><h3><strong>SSIS:</strong> <strong>SQL server integration service</strong></h3><p>Use Integration Services to solve complex business problems by copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL Server objects and data.</p><p><strong>use of data integration:</strong><br><strong>data profiling</strong>: check the error<br><strong>data cleaning</strong>: the process of fixing or removing incorrect, corrupted, incorrectly formatted, duplicate, or incomplete data within a dataset.<br><strong>structured and unstructured data</strong>: Structured data is highly specific and is stored in a predefined format, where unstructured data is a conglomeration of many varied types of data that are stored in their native formats<br><strong>Data migration</strong>: moving data one location to another<br><strong>Data merging</strong>: the process of combining<br>Data reflection: A reflection maintains one or more physically optimized representations of a table or view.</p><p><strong>homogeneous data and heterogeneous data</strong></p><p>Homogeneous data structures are ones that can only store a single type of data (numeric, integer, character, etc.). Heterogeneous data structures are ones that can store more than one type of data at the same time.</p><p><strong>ETL architecture:</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*RQQ9OLWiTTOlXZsG.png" /><figcaption>ETL architecture</figcaption></figure><p>it describes how data will flow from the source to target locations,</p><p><strong>Extract</strong>: ETL tool extracts data from an internal or external source. These sources may include CSV, JSON, and XML/HTML files</p><p><strong>Transform</strong>: When an ETL tool transforms data to make it suitable for, and compatible with, the schema of the target data warehouse . This may include cleaning the data to remove duplicate or out-of-date entries.</p><p><strong>Load:</strong> When an ETL tool loads data to the target data warehouse. Once inside the data warehouse, you can query that data for BI</p><p><strong>Where do we use SSIS?</strong></p><ul><li>Archival of data (export)</li><li>Loading of new data (import)</li><li>Transferring data from one data source to another.</li><li>Data cleansing or transformation of dirty data.</li></ul><p><strong>Advantages of SSIS</strong></p><ul><li>SSIS can combine data from multiple sources into a single package</li><li>SSIS has features that support transformation as a function.</li><li>Configuration is simpler to manage and package.</li></ul><p><strong>SSIS package</strong></p><p>SSIS package includes the necessary components, such as the connection manager, tasks, control flow, data flow, parameters, event handlers, and variables, to execute a specific ETL task</p><p><strong>components of SSIS</strong></p><p><strong>Control Flow</strong>: It helps to arranges the order of execution for all its components</p><p><strong>Data Flow</strong>: The main use of the SSIS tool is to extract data into the server’s memory, transform it, and write it to another destination.</p><h4>Extracting Data from source Files Loading to the Destination file:</h4><ol><li>Create a new SSIS package and a new Data Flow Task within the package.</li><li>Drag the Flat File Source from the Toolbox onto the Data Flow workspace and then double-click the Flat File Source .</li><li>Connecting to a flat file requires using a package connection. Therefore, in the File Source Editor, click the New button next to the File Connection Manager dropdown, which opens the File Connection Manager Editor.</li><li>Drag the File Destination from the Toolbox onto the Data Flow workspace and then double-click the Flat File Source .</li><li>Connecting to a source file requires using a package connection. double click on the destination file opens File S Editor, click the New button next to the File Connection Manager dropdown, which opens the File Connection Manager Editor.</li><li>after connecting run the package.</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/975/1*D7ojyhrdVDzUHxR4KFhABw.png" /><figcaption>example for extracting data from flat file loading data into flat file</figcaption></figure><p><strong>Data Conversion</strong>: converts the data in an input column to a different data type and then copies it to a new Destination</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/550/1*ju8Ka-6-XAtZ32NjE5-wsw.png" /><figcaption>example for extracting data from excel file loading data into SQL file</figcaption></figure><p>while extracting data from excel file loading data into SQL file used data conversion . to change the data type. so can easily loaded into the sql file</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/829/1*Y_HTABOsLeL14wZDw4P6jQ.png" /><figcaption>extracting data from SQL file loading data into SQL file</figcaption></figure><p>the above snapshot shows successful loaded the data from SQL Server DB to another table for this first i have created source and target table in Dbeaver and inserted some data into the source table then it is extracted and loaded into the target table</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/946/1*29wp1Shc-suNdr8LSS_1KA.png" /><figcaption>extracting data from 3 source file loading data into SQL file</figcaption></figure><p><strong>Union All transformation: </strong>combines multiple inputs into one output. For example, the above snapshot outputs from three different File sources like excel, flat file and SQL Server DB can be inputs to the Union All transformation and combined into one output is loaded into the another SQL table.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Ee1UY6kOa6ZWotEj1plj9Q.png" /></figure><p><strong>Execute SQL Task: </strong>it will execute a SQL statement. The Execute SQL task runs SQL statements. The task can contain either a single SQL statement or multiple SQL statements that run sequentially. Truncate a table or view in preparation for inserting data. Create, alter, and drop database objects such as tables and views. Re-create fact and dimension tables before loading data into them.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/749/1*iz8hLbe84G5UR-Xrh9XBEA.png" /><figcaption>Data transformation using merge and sort</figcaption></figure><p><strong>Merge Transformation: </strong>Merge transformation is very similar to the Union All Transformation, which combines rows from different sources into one output. The main difference is that Union All doesn’t require that the data sources are sorted, Besides, Union All accepts more than two inputs while Merge transformation doesn’t. As shown in the above image two data source from the excel is sorted and merged then loaded into the table</p><p><strong>Sort:</strong> Component is a transformation that sorts input data in ascending or descending order and Removes the duplicate data</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/895/1*6_qlYSbnTH1z2rYKLQ5-9Q.png" /><figcaption>Data transformation using condition split</figcaption></figure><p><strong>condition split: </strong>The Conditional Split Transformation task checks for the specified condition. It moves the data to an appropriate destination depending upon the condition. we need to define the conditions in the SSIS Conditional Split transformation task. Double click on the Conditional Split and it opens. We can use system variables and query output columns in the expressions to split the data flow. After the SSIS Conditional Split Transformation task, we need to add a destination path for each of the split conditions data. As shown in the above image i had split data from excel file to three different table depend upon the marks of student</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/975/1*Uwx7pBoRrB-1AtSpS1Qghg.png" /><figcaption>Data transformation using Character Map</figcaption></figure><p><strong>Character Map:</strong> The Character Map transformation applies string functions, such as conversion from lowercase to uppercase, to character data. This transformation operates only on column data with a string data type.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/517/1*rjdIXh_I6nj_7rkZbXeGzA.png" /></figure><p>In SSIS Toolbox, we have the Character Map transformation. by double clicking the character map transformation we can get above window we can choose the operation which we want to perform for the specific column.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/586/1*F7iJM6WrxI5q2UO5nsVP9A.png" /></figure><p><strong>LookUp Transformation : </strong>it specify<strong> </strong>How to handle rows with no matching entries. by double clicking the LookUp transformation we can get below window</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/613/1*xuua3w3yWO79P4sZrrfKvw.png" /></figure><p>The SSIS Lookup Transformation provides with four options:</p><p>Fail Component (Default): When a new row passes from the data flow to lookup. It will fail the package if it doesn’t find any matching row in the lookup table.</p><p>Ignore Failure: If we selected this option, When a new row passed from the data flow, Lookup Transformation would continue its processing even though it doesn’t find any matching row in the lookup table.</p><p>Redirect Rows to No Match Output: If we select this option, then Lookup Transformation will direct the rows that don’t find any matching row in the lookup table to No Match In real-time, we mostly use this option.</p><p>Redirect Rows to Error Output: If we select this option, SSIS Lookup Transformation will direct the rows that don’t find any matching row in the look up table to the standard error output.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/533/1*lHfG8f1zPQc-CmLbNU1s5A.png" /><figcaption><strong>OLE DB Command task</strong></figcaption></figure><p>by double clicking OLE DB Command task<strong> </strong>the transformation we can get above window</p><p><strong>OLE DB Command task: </strong>mainly used for a set of transformations that happen on each row of the SQL command which will be executed using this task. To pass an SSIS variable into an OLE DB command, we need to use a parameter placeholder a ? in our SQL statement then map the SSIS variable to our placeholder.</p><p><strong>Integration Services Containers</strong></p><p>Containers are objects in SQL Server Integration Services that provide structure to packages and services to tasks. They support repeating control flows in packages, and they group tasks and containers into meaningful units of work. Containers can include other containers in addition to tasks.</p><p>Packages use containers for the following purposes:</p><p>Repeat tasks for each element in a collection, such as files in a folder, schemas, or SQL Server Management objects. For example, a package can run Transact-SQL statements that reside in multiple files.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/466/1*a0Q-dC1W6Wbmc5XE3cW1tQ.png" /><figcaption>Foreach Loop Container</figcaption></figure><p><strong>Foreach Loop Container: </strong>The Foreach Loop container defines a repeating control flow in a package. The loop implementation is similar to Foreach looping structure in programming languages.</p><p>As shown in the above picture foreach loop executes multiple times to extract the data from multiple file resides in single folder and loaded into the SQL server table.</p><p>Open the ForLoopContainer package, create a new variable we may have to open the Variables window if it isn’t already open. To do this, right-click in the design pane and select Variables or click on the Variables icon on the top right of your package designer screen.<br>Once the window is open, click the Add Variable button. Accept all the defaults for the variable (string) and a default value of 0.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/732/1*CZKpQEyaCwtjjzfPnkXOAA.png" /><figcaption>sequence container</figcaption></figure><p><strong>sequence container: </strong>The Sequence container defines a control flow that is a subset of the package control flow. Sequence containers group the package into multiple separate control flows, each containing one or more tasks and containers that run within the overall package control flow.</p><p>applications of Sequence Containers</p><ul><li>Grouping tasks so that we can disable a part of the package that’s no longer needed</li><li>Managing the properties of multiple tasks in one step by setting the properties of the container</li><li>Using one method to ensure that multiple tasks have to execute successfully before the next task executes</li><li>Creating a transaction across a series of data-related tasks, but not on the entire package</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/550/1*vaXQtQB7UBgzSCODxZ5SVg.png" /><figcaption><strong>File System task</strong></figcaption></figure><p><strong>File System task:</strong></p><p>File System task operations use a source, which can be a file or a directory. For example, the file that the task copies or the directory it deletes is a source. The source can be specified by using a File connection manager that points to the directory or file or by providing the name of a variable that contains the source path. The operations that copy and move file and directories and rename files use a destination and a source. The destination is specified by using a File connection manager or a variable.</p><p>by double clicking the file system we can get the below window</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/564/1*CER654VD_YSkCRte7HoEZg.png" /></figure><p><strong>Copy directory</strong>: Copies a folder from one location to another.</p><p><strong>Copy file</strong>: Copies a file from one location to another.</p><p><strong>Create directory</strong>: Creates a folder in a specified location.</p><p><strong>Delete directory</strong>: Deletes a folder in a specified location. Delete directory content Deletes all files and folders in a folder.</p><p><strong>Delete file</strong>: Deletes a file in a specified location.</p><p><strong>Move directory</strong>: Moves a folder from one location to another.</p><p><strong>Move file</strong>: Moves a file from one location to another.</p><p><strong>Rename file</strong>: Renames a file in a specified location.</p><h3><strong>Fact table and Slowly Changing Dimension</strong></h3><p><strong>Fact table</strong>: Fact table contains the measuring of the attributes of a dimension table. Dimension table contains the attributes on that truth table calculates the metric. In fact table, There is less attributes than dimension table. While in dimension table, There is more attributes than fact table. In fact table, There is more records than dimension table. It is used for analysis purpose and decision making.</p><p><strong>Slowly Changing Dimension</strong>: A Slowly Changing Dimension (SCD) is a dimension that stores and manages both current and historical data over time in a data warehouse.</p><p><strong>Type 0:</strong> Data should be same in source and target table <em>(Give fixed attribute).</em></p><ul><li>If we enable the ‘fail the transformation if changes are detected in a fixed attribute’ and update the table. Our dataflow will execute with error.</li><li>If we unable the ‘fail the transformation if changes are detected in a fixed attribute’ and update the table. Our dataflow will execute without error but updated data will not be inserted.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/627/1*WDAKP8REnzzQKnAZjy7OfQ.png" /></figure><p><strong>Type 1:</strong> Data can be updated as per our requirement</p><p><em>(Give changing attribute)</em></p><ul><li>Only the updated data will be there in a same row.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/609/1*axXJVGBvh0IQIy1C59Hu0Q.png" /></figure><p><strong>Type 2: </strong>It holds historical data as well as new records and perform updation also <em>(Give historical attribute).</em></p><ul><li>If we make it historical attribute, both previous and updated data will be stored and displayed.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/585/1*AKSKBC04wewg2mT3XzNWbg.png" /></figure><h3><strong>SSRS:</strong></h3><p><strong>SQL Server Reporting Services </strong>: is a SQL Server subsystem that enables the creation of graphical, mobile and printed reports using SQL Server and other data sources. SQL Server is a relational database management system (RDBMS) that supports transaction processing, business intelligence and analytics applications.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*Ab9ckaJgCLbcgWta.png" /><figcaption>SSRS Architecture</figcaption></figure><ol><li><strong>Report User</strong><br>Report users are those that work with the data. Mainly, they work on the first two tools, i.e., SSIS (SQL Server Integration Services) and SSAS (SQL Server Analytic Services). If they want to make reports, then they can also use the SQL Server Reporting Services.</li><li><strong>Report Designer</strong><br>Report Designers are the professionals who design the reports from existing data.</li><li><strong>Report Manager</strong><br>Report managers are those who view the report or to whom we need to submit the report. They view the reports to check whether they meet the requirements or not.</li></ol><p><strong>Data visualization</strong> : Data visualization is the virtual access to the data that we have. A well-designed data can be a graph, charts or a report, and visual representation of the data is the simplest and most powerful representation of any data.</p><p><strong>Data visualization is useful because of the following reasons:</strong></p><ul><li>It helps you to identify the areas that need more improvement or attention.</li><li>It also helps you to identify the factors that influence customer behavior.</li><li>It is also used to predict sales volumes.</li></ul><p><strong>How to use SSRS ?</strong></p><ul><li>Open Visual Studio</li><li>Click File — -&gt;New — -&gt;Project</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/706/0*QHfQJ8DUWXnHy0XY.png" /></figure><ul><li>Browse the location. Create new folder and select the folder.</li><li>Give project name and select <strong>Report Server Project.</strong></li><li>Select OK button.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/793/0*OuPM5NGRb7lKT8sS.png" /></figure><ul><li>Right click on report and select add new report.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/945/0*XojKOESw6aZAVd9c.png" /></figure><ul><li>Click next and set the sql database connection and select the database. Click Next</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/522/0*1Sv6zbzvGuR-3ZMn.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/518/0*kaWB2Yil8BvJaTYJ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/521/0*BIVpqEDKOBjCT0JG.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/552/0*xS2W3he1nZg_3r_3.png" /></figure><ul><li>Write the query in query builder and click next.</li><li>Select the columns and move to Details column.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/945/0*T4hyhjK3UNJ7EP4Q.png" /></figure><ul><li>Click on preview and report will be generated. Just hover over button like save and it is possible to save report in any format like .pdf ,.docs, .csv files.</li></ul><p>It is possible to add new data source and data set to the SSRS reports. So it can reduce adding datasets again in each report. Right click on Shared Data Sources and create a connection.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/945/0*YB6GKF1U2p8Ju__s.png" /><figcaption>The window to add connection</figcaption></figure><p>Right click on shared dataset and write the query to select any table. That table can be used whenever needed in the project.</p><p><strong>Using two datasets in single table:</strong></p><p>Right click on the data sets option on left side of any reports. Then write the query to select particular rows. Click OK</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/945/0*x6XeoweJh4RJfw1h.png" /><figcaption>Dataset window</figcaption></figure><p>Then using this dataset it is possible to create the table and can generate reports.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*Ms8q2fMl3XO8fNY2.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*SWU2wlBShGW1oRMS.png" /><figcaption>Two tables</figcaption></figure><p><strong>Matrix, Charts and lines</strong></p><p>We can insert table, matrix, chart , line by right clicking on the window space . In matrix the data column will have the group values . It is mandatory to have row and column data .</p><p>In the below example the matrix will display the salary for each employee in the department</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/945/0*MvwiQC66XJS1ezUS" /><figcaption>Matrix created for employee table</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/945/0*u0cB_ai2YN1GvOpd" /><figcaption>Result</figcaption></figure><p>Charts are visual way of representing the reports. There are many charts like bar chart, pie chart, line chart etc.</p><p>Right click on window then click charts and select the type of chart . Then right click on chart and select the different parameters like values and groups based on which we need to divide the graph. There is other option series groups it will divide the graph based on subgroups.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/945/0*KvAw7eUqIlksh2_y.png" /><figcaption>Chart data example</figcaption></figure><p>We can convert chart to different chart types by right clicking on window.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/945/0*rSJY_cAMq7bH2izR.png" /><figcaption>Bar Chart</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/945/0*a-TDOy67JZ7u1Guw.png" /><figcaption>Line Chart</figcaption></figure><p>We can insert text box and lines based upon our requirements. It is possible to change text alignment, changing the font of text.</p><p>Insert text box by just clicking on insert text box option. Then go to text box property by right clicking the text box window. There are different editing options.</p><p><strong>Creating and filtering parameters in SSRS:</strong></p><ul><li>Add new item as report(Creating report)</li><li>Add data source and data set to the report.</li><li>Create table and select the column to be displayed.</li><li>Create parameter, right click parameter option then add parameter. Give name of parameter and click OK.</li><li>Now add parameter to dataset.</li><li>Right click on dataset select properties , then click filter option and add parameter.</li><li>Select expression from expression option and set value and mention expression. Select operator, = is used to select one value and in allows multi values.</li><li><strong>Default value </strong>can be set to column by just right clicking on parameter option then click default values, select specify value and add default value and click OK.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/945/0*EPL1pJBj8t2PgaZO" /><figcaption>Consumer is set as default value and report is generated</figcaption></figure><p><strong>Drill down report</strong></p><p>This is type of report based on our requirement. If we need to expand the report after clicking on any button then this can be used.</p><ul><li>Create new report and add data source and dataset.</li><li>Create table and add columns.</li><li>Add group and select the parent group.</li><li>Right click on the group value and click group properties.</li><li>Select the visibility and select hide and select display option , click Ok.</li><li>Preview the file.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*KV4aqp_SUKFCORBh.png" /><figcaption>drilldown report</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*mRtQSZScP7gm-pPZ.png" /><figcaption>drill down report</figcaption></figure><h3><strong>IICS(Informatica Intelligence Cloud Services)</strong></h3><p>IICS is a ETL tool which provide many services to the users. It is a cloud based tool which offer different operations and easy to use. It can connect to on premises and cloud applications .</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/895/0*AMXJK0-6Kx-WSEzu.png" /></figure><p>Services provided by Informatica</p><p>Administrator can manage different connection and can retrieve the users using the connection. This is usually handled by DBA administrator. Then data integration is a tool where it provides many transformations. It is similar to SSIS but it is Microsoft tool.</p><p><strong>Transformation of data from source to destination</strong></p><ul><li>Click on Data Integration tab .</li><li>Select Explore option and Create new project</li><li>Select New option → Mappings →Create</li><li>Rename file</li><li>Then select Source Connection and select table</li><li>The source connection can be from different servers like oracle, sql server, postgreSQL etc.</li><li>Select Destination connection and destination table else create new table</li><li>Save and Run</li><li>The data will be transferred to destination.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/975/1*OncwClpf4PLmILiH46BTRA.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/554/0*g3QBzotHdZdmRt-k.png" /><figcaption>Destination Table</figcaption></figure><p><strong>Sort Transformation</strong></p><p>This Transformation will sort the column in ascending and descending order. Also can remove the duplicate values if necessary.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/975/0*HpA6yq0_bfO946Ds.png" /><figcaption>Sorting property window</figcaption></figure><ul><li>Create new mapping and select source and destination.</li><li>Then add sort transformation and select any column in sort option.</li><li>If needed distinct check box can be selected in advanced</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/878/0*TB0dXf11bBg4ctN7.png" /><figcaption>Sorter Transformation</figcaption></figure><ul><li>Save and run</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/761/0*v9jXGXT_JkLjCe0f.png" /><figcaption>Employee_ID will be sorted</figcaption></figure><p><strong>Expression Transformation</strong></p><p>Expression transformation is used when we want to add any expressions to destination table by adding new fields. By using input fields it is possible to write expression.</p><p>For example if the salary of employee is increased by 10% and this column is need to be added in destination, then expression can be written in expression transformation. Select source and destination table .Add expression transformation .</p><ul><li>Connect to source and destination</li><li>Click on expression and add output column field and enter name amd type.</li><li>Add input column fields and write the expression</li><li>Save and run</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/797/0*XDd9VdSxwRnvY0Ye.png" /><figcaption>Add new field</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/889/0*uwZVXHGxOOU_jX4j.png" /><figcaption>Expression to increment salary by 10%</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/770/0*8Of_BM34Kw0mAmAW.png" /></figure><p>Destination table with additional column New_salary</p><p><strong>Joiner transformation</strong></p><p>It is used to join two tables and transform the data from two sources to one destination. Using same column from two tables we can join the tables. The two tables are referred as master table and details table. There are types of joins</p><ul><li>Master Join: Extracts all data from details and matching records from master table.</li><li>Details Join: Extract all records from master table and matching records from detail table.</li><li>Normal Join: It returns matching records ,similar to inner join.</li><li>Full Join: Return all data from both tables.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/773/0*60jCZJPWfNEYL0U9.png" /><figcaption>Joiner dataflow</figcaption></figure><ul><li>Create two source and create connection.</li><li>Select Joiner task and connect two sources to master and details.</li><li>Select target and select table.</li><li>Double click on joiner and select the matching column.</li><li>Name of matching columns should be different. It the name is same then column name should be renamed</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/867/0*DBHoZaGTqZyhDiBM.png" /><figcaption>Renaming column</figcaption></figure><ul><li>After renaming select the Join condition option and select the column and save.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/710/0*ZMMgjxjggB64yssx.png" /></figure><p><strong>Slowly changing dimension type 2 in IICS</strong></p><ul><li>In slowly changing dimension if new record is present then it is added to the destination. If any updates in existing record then the present record is made inactive and new record is added.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/945/0*SQHt_vN6hipdf745.png" /><figcaption>SCD transformations.</figcaption></figure><ul><li>Create new mapping and select source as database table.</li><li>Create one table in db to transfer data from source</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/853/0*MZIN1L_SkA73q9N5.png" /><figcaption>Table creation</figcaption></figure><ul><li>Select expression and enter the outfields with checksum. Checksum generates unique key that identifies each record.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/945/0*R5lGrN8_XT_9nind.png" /><figcaption>Expression Transformation</figcaption></figure><ul><li>Next select lookup transformation . It is used to compare the records from source and destination table. In lookup object select destination table and make the lookup condition based on employee_id.\</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/945/0*Haa4876obYNcLAAj.png" /><figcaption>Lookup condition</figcaption></figure><ul><li>Drag and drop expression transformation and write expression to route the data to either insert or update.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/945/0*PxSLPllO54F2itO_.png" /><figcaption>Expression Transformation</figcaption></figure><ul><li>The condition is if the employee_key is null then insert operation is performed. Else if checksum value of both target and source is same then update operation is performed.</li><li>Then Router transformation is used to route the based on either insert or update.</li><li>Three expression transformation is used to perform some operation when update and insert takes place.</li><li>If new records is inserted then its checksum is calculated and start_date and end_date must be added.</li><li>When any update is performed on record then End_date of the existing record should be changed to current data and new record is added with start_date and end_date with updated values.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*hFjdAeBcuN83YTft.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*MeKVximB3qEyktm0.png" /></figure><p>Expression on insert and insert_update</p><ul><li>select target for insert and map the columns . Then after updating the value same procedure is repeated.</li><li>In update operation mention the operation as update and select the key column and map the column.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*NDI1M4YXt27qfcNU.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*Frjbz9sLVqHm31Ak.png" /></figure><p>Result of destination in first run</p><ul><li>Update any column from source table and run the mapping.</li><li>The new record is added . Old record is made inactive by adding system date to end date.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/945/0*KcjXNqqAH4z2dlEC.png" /></figure><p>Update query</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/945/0*uLo9foihlQQ1BhIi.png" /></figure><p>Result of destination table in second run</p><p><strong>Union Transformation</strong></p><ul><li>This transformation combines data from different sources and transfers data to destination table. Even if any records are same in both tables it returns the records twice.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/637/0*EEzvd_3KFCnHIv1a.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/639/0*XgVAMHl0ppodVyZo.png" /></figure><p>Two Source table</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/945/0*cYL-jaCecppjCfEe.png" /></figure><p>Union Transformation</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/945/0*Y7mUyXhs1u2t2fkz.png" /></figure><p>Union Transformation Fields</p><ul><li>Select two sources and map the columns. select the target table and create the connection.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/945/0*Q813si6Y3-YIhQ6b.png" /><figcaption>Resultant Table</figcaption></figure><h3>Database Final Assessment</h3><p><strong>Module 1: SQL Server: </strong><br>1. Perform the normalization<br>a) Create tables as per normalization<br>b) Insert the data<br>c) Join the table<br>d) Create different views</p><p>Scenario:</p><p><strong>Healthcare domain:</strong></p><p>Multiple patients visiting hospitals located in multiple cities, for check up and treatment, multiple</p><p>doctors treating patients belong to specific department advising routine checkups(ex: Xray, Sugar</p><p>test, urine test, MRI etc) and further drugs(medicines) for the disease identified.</p><p><strong>Answer</strong></p><p>Created three tables as per the normalization that is hospital, Docotor and patient.</p><p>Below snapshot shows the query for creating tables</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*wbQ6AS_bRL8iffjJ8gfoSw.png" /></figure><p>After creating the table, inserted the data into the Hospital tables.</p><p>Below snapshot shows the inserting data in to the hospital tables</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1019/1*N-5HLMtrVesg-02p6yP2Cg.png" /></figure><p>Below snapshot shows adding foreign key reference to the existing table by using alter tabale command For doctors and patient table</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*uv-TYabTZQ8Jp_qu_C0z1A.png" /></figure><p>Below snapshot is for the inserting data for patient table</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/890/1*z2FcKCWFBWLh4xq5C2wPHg.png" /></figure><p>Performing join opertion for Doctor and Patient tables</p><p>Below snapshot shows the result inner join oprtion</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*S7MThZMFDG8hH13BSLonBA.png" /></figure><p>Below snapshot shows the result Right join oprtion</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/888/1*cNmjvLs-cr00vyogqRfrWw.png" /></figure><p>Below snapshot shows the result Full join opertion</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1001/1*U31FYPrJAg_VafozkADsbg.png" /></figure><p>Below snapshot shows the result Cross join operation</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/944/1*h5v40STG77sgK8R-Nww2FA.png" /></figure><p>Create different views:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/975/1*h8K3_pQc0Sl9MXXk6ibYFQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Y_ORExzFUAGJGk2PuWzA_A.png" /><figcaption>ER diagram</figcaption></figure><p><strong>2. Using transaction table perform various operations ( DDL,DML)</strong></p><p><strong>Answer:</strong></p><p>Created table for cinema ticket.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/975/1*uH0tGBSdnDoGNp3WSpOqnw.png" /></figure><p><strong>DML COMMANDS</strong></p><p>INSERTING DATA INTO THE TABLE</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/947/1*Rx1AVrhWOzaTgYOC78lyDg.png" /></figure><p>Below snapshot shows the updating the table using where condition</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/975/1*SiBxUqetpWNBa7PisggR6A.png" /></figure><p>Deleting the data using delete command</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/975/1*uXDtmSFgC2rmoZKUJpiiQQ.png" /></figure><p>Displaying the data using select command</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/975/1*zfp5hmL6GJ_AsCPcLbtsaA.png" /></figure><p><strong>DML COMMANDS</strong></p><p>Adding new row using ALTER COMMAND</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/975/1*ydkTgPliyLQ2Lbf1BCQtIQ.png" /></figure><p>Result of alter command, below snapshot shows the cinema_ name colomn added to the table</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/975/1*fupD5Pcfem0H9xwco9bBZg.png" /></figure><p>Truncate table</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/975/1*GP7SVkOkEc2XgUby0EuVsg.png" /></figure><p>Drop table</p><p>While performing the drop table operation we will get a warning window</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/975/1*Repoz9UmA0Uq6cWPKMAaWg.png" /></figure><p>Below snapshot show the result of drop table</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/975/1*01Ax_K-xiTfSpLKxz5sH_w.png" /></figure><p><strong>Module 2 SSIS</strong></p><p><strong>Qn1. Make connection to different data source</strong></p><p><strong>Solution:</strong></p><p><strong>1.Extracting the data from excel source, loading into the FLAT file</strong></p><p>Step1: drag and drop the data flow task from ssis tool box</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/975/1*zNea3umgY4ftGNu2H9EwHQ.png" /></figure><p>Step2: Double click on the data flow task</p><p>Step3: drag and drop the Excel source from the ssis tool box</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1002/1*KHWxsdPkO5YLugX_R-jH9A.png" /></figure><p>Step3: Double click on excel source we will get new window click on new.</p><p>Step4: Browse for the file in local computer and select the file</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/975/1*6KTQysjLU4BMaJddmC8qaA.png" /></figure><p>Step 5: check the columns and data in the excel file</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1012/1*JWfLDOHwVQZ4n4ewpafVOw.png" /></figure><p>Step6: drag and drop the flat file Destination then connect to the source</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/975/1*YGMCVV1kO-G0FUfrnS2dww.png" /></figure><p>Step7: double click on the flat file destination</p><p>Step8: click on new and select the empty flat file</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/975/1*DsevVpsvlO42g8q0NgFYtg.png" /></figure><p>Step9: run the package</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/975/1*j9cPl1F-XzSRgayZgcU7Pg.png" /></figure><p>Result of successful execution</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/975/1*UKOfxRzAqtXz0bGwioap7Q.png" /></figure><p><strong>Module-3 SSRS</strong></p><p><strong>1. Using the newly created DWH — SQL Server, generate different reports</strong></p><p><strong>a) Dashboard</strong></p><p><strong>b) Reports</strong></p><p><strong>Apply the filter on Dashboard and report level. Create meaningful reports</strong></p><p><strong>Table Report</strong></p><p>DRILL DOWN REPORT FOR CINEMA TICKET SALES</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9b0C2IWuk0QbzSIYUBse9g.png" /></figure><p>SSRS REPORT USING MULTI VALUE PARAMETER</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*jQxRMFPtrCgYFvIjq13Kww.png" /></figure><p>DASHBOARD FOR CINEMA TICKET SALES</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*oXFXnOFDaNzDOf3r39uIRg.png" /></figure><p>Big Picture of DB,SSIS,SSRS,IICS</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*MF74d2bS_7t9rW9B6WPEwg.png" /></figure><p>We have reached to the final day of training after the sixty days of continuous training from August to October. The training was really good and informative and the materials provided were really helpful. I got to learn many things which were applicable in real time and it was a great course. And also I would like to thank all the trainers for their time and support. Thank you so much for your very valuable training.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e29df5d8db96" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[My First job ]]></title>
            <link>https://medium.com/@pratibhashetty2000/my-first-job-7888f50c0a64?source=rss-4a80122b63be------2</link>
            <guid isPermaLink="false">https://medium.com/p/7888f50c0a64</guid>
            <dc:creator><![CDATA[Pratibha shetty]]></dc:creator>
            <pubDate>Wed, 12 Oct 2022 04:12:39 GMT</pubDate>
            <atom:updated>2022-10-12T04:12:39.479Z</atom:updated>
            <content:encoded><![CDATA[<p>Hello…!!</p><p>I am Pratibha Shetty! basically I am from Kundapur, i have completed my schooling in Bagalkot and Engineering in Alav’s institute of Engineering and Technology Moodbidri with 8.2 cgpa . I am interested in Photography 🎥 and writing Stories 🖊️ especially in Kannada. My strengths are my attitude that I like to take challenges that I can do it, my way of thinking that I take both success and failure in a balanced manner, My long-term goal is I want to be one of the reasons for the success of the organization and I want to be one of the responsible person in organization growth.</p><ul><li>Section 1</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*qkYh006O-46C6-8TV4Z9AA.jpeg" /><figcaption><em>Every day is a new beginning</em></figcaption></figure><p>on 16th sept 2021 I have attended campus drive conducted by <strong>tietoEvry</strong>, after 3 days i got to know that i have selected for this company…. on august 16th 2022 my journey started “campus to corporate” i have learnt some soft skills like time management, Email writing, Communication skills.</p><p><strong>Section 2 (24/8/22)</strong></p><p>on 24 our technical training started conducted by Dlithe. the first day of technical training i met Energetic Arun sir. he discussed about how the IT sector works and the overview of the whole training.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/670/1*XMqq6U_Pxx3fweTYTjOJkw.jpeg" /></figure><p><strong>Industry transformation:<br></strong>It’s about robots helping humans work better and faster by leveraging advanced technologies like the Internet of Things (IoT) and big data. It adds a personal human touch to the Industry 4.0 pillars of automation and efficiency</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/650/1*m20y7o9hp05Ogl1ShRYh1g.png" /></figure><p><strong>Banking:</strong></p><p>The three main business segments for a bank are <strong>retail banking, wholesale banking, and wealth management</strong>. Retail banking or personal banking involves deposits, mortgages, loans, and credit cards. Retail banking is the largest earnings contributor. It is the segment most people are familiar with, as it includes operations that occur in a bank’s branch. Products involved in retail banking include deposits, credit cards.</p><p><strong>Customer Experience</strong></p><p>Customer experience focuses on the relationship between a business and its customers. It includes every interaction, no matter how brief and even if it does not result in a purchase. Whether it is a call to a contact center, Most importantly, it’s how customers view those experiences in aggregate that matters. Customer experience is how a customer feels about the sum of their interactions with a business.</p><p><strong>Good Customer Experience:</strong></p><p>Great customer experience means following best practices like valuing customers’ time, having a pleasant attitude, and providing knowledgeable and resourceful resources, but that you also take things a step further to exceed rather than just meet expectations.</p><p><strong>Bad Customer Experience:</strong></p><p>Bad customer experience can be defined as when a business fails to meet customer expectations in terms of service quality, response time, or overall customer experience. The factors that have a negative effect on customer service are inefficient support staff, lack of real-time support, or unable to understand your customer needs.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*n5qk2k77hFvYww5YThduuQ.png" /></figure><p><strong>Section 3 (25/8/22)</strong></p><p>The second day of my technical training i have learnt about basic computer system and cloud and software engineering models explained by Pooja and Arun Sir.</p><p>i learnt basic concepts of computer system like input, outputs and memory, processing of computer and functionality ,advantages, disadvantages of computer.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/682/1*13G0l4pB1zBMkKjSKu0H1Q.jpeg" /></figure><p><strong>Cloud</strong></p><p>Cloud is used to store the computer instead of our computer it<br>can be access remotely over the internet.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*R16fEf96CXA0RX6oTgaulQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/788/1*BdA6l2F-R_wzjFgSae-16A.jpeg" /></figure><p><strong>Google cloud:</strong></p><p>It provides reliable and highly scalable Google <a href="https://www.netsolutions.com/insights/what-is-cloud-computing/">cloud computing</a> services to its users. These services help clients compute and store data, and help developers build, test, and deploy apps. Google cloud platform covers application, storage, and cloud computing services for backend, mobile, and web solutions using the internet. More than four million apps trust and use the platform.</p><ul><li><strong>Section 4</strong></li></ul><p><strong>Software engineering</strong></p><p>Software engineering is an engineering branch associated with development of software product using well-defined scientific principles, methods and procedures.</p><p><strong>SDLC</strong></p><p>Requirements, analysis, design, development, testing, implementation, and maintenance.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/604/1*LhcwGj9lR9IKOoL_PGVn7Q.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/559/1*jlqsKwLgVyeBVsB2s3EJ_g.png" /></figure><p>water fall model has High amounts of risk and uncertainty Not a good model for complex and object-oriented projects. Poor model for long and ongoing projects.</p><p>V-model: Very rigid and least flexible. Software is developed during the implementation phase, so no early prototypes of the software are produced. If any changes happen in midway, then the test documents along with requirement documents has to be updated.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/716/1*VX_F9LIahoH444U5jVEYsQ.jpeg" /></figure><p><strong>Requirement Gathering Process:<br></strong>Requirements gathering is the process of determining what your projects need to achieve and what needs to be created to make that happen. You’re probably familiar with the fact that everybody has their own common project assumptions about what a project should include.</p><p><strong>Requirements Gathering Techniques :</strong></p><ul><li>Interviews.</li><li>Questionnaires or Surveys.</li><li>User Observation.</li><li>Document Analysis.</li><li>Interface Analysis.</li><li>Workshops.</li><li>Brainstorming.</li><li>Role-Play.</li></ul><p><strong>Types of requirements: Functional and non-Functional<br></strong>Here is an example of requirement gathering, for <strong>Banking KYC</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*RvRclQ5On9xW7g03ON6oKw.png" /></figure><p><strong>use case diagrams</strong> :Use-case diagrams describe the high-level functions and scope of a system. These diagrams also identify the interactions between the system and its actors. use case is a methodology used in system analysis to identify, clarify and organize system requirements. The use case is made up of a set of possible sequences of interactions between systems and users in a particular environment and related to a particular goal. The method creates a document that describes all the steps taken by a user to complete an activity.</p><p>example for use case: ATM</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/717/1*R1LNnROQE5ktKbkW4pcFVA.jpeg" /></figure><p><strong>difference between use case and user story.</strong></p><p>Use stories are developed before the user case. In most cases they are developed by user interaction. One user story can generate multiple use cases. The combination of all such use cases produces a detailed document. This document has a description of the interaction between all software and users.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/558/1*r-I2hdHmT6qUEZXBQWb2vA.png" /></figure><p><strong>Agile Methodology:</strong></p><p>The Agile methodology is a way to manage a project by breaking it up into several phases. It involves constant collaboration with stakeholders and continuous improvement at every stage. Once the work begins, teams cycle through a process of planning, executing, and evaluating.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/788/1*vG0DHUklwoKD3wXqgktgBA.png" /></figure><p><strong>Subject Matter Expert </strong>(SME): Provides knowledge and expertise in a specific subject, business area, or technical area for a project.</p><p><strong>Product Owner:</strong> The Product Owner (PO) is a member of the Agile Team responsible for defining Stories and prioritizing the Team Backlog to streamline the execution of program priorities while maintaining the conceptual and technical integrity of the Features or components for the team.</p><p><strong>Scrum Master:</strong> A Scrum Master is a facilitator for an Agile development team. They are responsible for managing the exchange of information between team members</p><p><strong>Standup Meeting: </strong>It’s even commonly known as the daily scrum, and reinforces “we” to keep everyone aware of the team’s landscape and progress. a stand-up is a daily meeting that involves the core team: product owners, developers, and the scrum master.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Z20Ggwfqd-koPJukvONf0g.png" /></figure><p><strong>Sprint</strong>: A sprint is a short, time-boxed period when a scrum team works to complete a set amount of work. Spr<strong>Activity Involved in Sprint: </strong>A sprint consists of a set of activities: sprint planning, daily scrums, development work, sprint review and sprint retrospective. A sprint is used to accomplish something — a sprint goal.</p><p><strong>Retrospective meeting: </strong>A Meeting conducted at the end of a project to help teams pause and think about improving future performance. It’s a safe space for reviewing the project’s successes, identifying opportunities for process improvement, and solving issues that may have come up.</p><p><strong>Task Planning: </strong>A task is a single unit of work broken down from a user story. A task is usually completed by just one person.</p><p><strong>Estimation Process: </strong>In order to determine the task duration, the effort required to complete the task must be determined first. Duration can only be calculated once it is understood who will perform the task, how many people are going to perform the task, and whether they are available to perform the task at a reliable level of availability.</p><p><strong>Jira software</strong></p><p>Originally, Jira was designed as a bug and issue tracker. But today, Jira has evolved into a powerful work management tool for all kinds of use cases, from requirements and test case management to agile software development.Jira Software is an agile project management tool that supports any agile methodology, be it scrum, kanban From agile boards, backlogs, and add-ons we can plan, track, and manage all your agile software development projects from a single tool. Pick a framework to see how Jira Software can help your team release higher quality software, faster.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*C1u44T6_XUoV0dcehendqg.png" /><figcaption>screen shot of jira software</figcaption></figure><p><strong>software programming</strong>:</p><p>Software programming is the act of writing computer code that enables computer software to function.</p><p><strong>Algorithm</strong></p><p>procedure used for solving a problem or performing a computation.</p><p><strong>why?</strong></p><p>Algorithms are a very important topic in Computer Science because they help software developers create efficient and error free programs. The most important thing to remember about algorithms is that there can be many different algorithms for the same problem, but some are much better than others!</p><p>Ex-</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/952/0*bYnoGvwgi1mwO5D4.png" /></figure><h3>Flowchart</h3><p>A flowchart is a graphical representation of a process. It’s a diagram that illustrates the workflow required to complete a task or a set of tasks with the help of symbols, lines and shapes.</p><p><strong>why?</strong></p><p>When designing and planning a process, flowcharts can help you identify its essential steps and simultaneously offer the bigger picture of the process. It organizes the tasks in chronological order and identify them by type.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1006/0*Sk55usKP7b1LPZSg.png" /></figure><h3>Pseudo Code</h3><p>Pseudocode is an artificial and informal language that helps programmers develop algorithms. Pseudocode is a “text-based” detail (algorithmic) design tool. The rules of Pseudocode are reasonably straightforward. All statements showing “dependency” are to be indented. These include while, do, for, if, switch.</p><p><strong>why…?</strong></p><p>Pseudocode helps you plan out your app before you write it. It helps you create algorithms in a format that is easier to read than code syntax. Once programming languages come into the picture it can be harder to understand what your code is doing.</p><p>Ex-</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/0*QGd_1AKuiGkii8t3.png" /></figure><h3>Object-oriented programming (OOP):</h3><p>Object-oriented programming (OOP) is a style of programming characterized by the identification of classes of objects closely linked with the methods (functions) with which they are associated. It also includes ideas of inheritance of attributes and methods.</p><p><strong>Class</strong>:-A class is like a blueprint of data member and functions and object is an instance of class. For example, lets say we have a class Car which has data members (variables) such as speed, weight, price and functions such as gearChange(), slowDown(), brake() etc.</p><p><strong>Object</strong>:- An object can be defined as an instance of a class, and there can be multiple instances of a class in a program. An Object is one of the Java OOPs concepts which contains both the data and the function, which operates on the data. For example — chair, bike, marker, pen, table, car, etc.</p><p><strong>Constructor</strong>:- A constructor is a special type of member function that is called automatically when an object is created. They have the same name as a class. In our example default constructor is to be set with values such as eye color, skin color and mouse color. A constructor with at least one parameter is called parameterized constructor.</p><p><strong>The Four Pillars of Object-Oriented Programming</strong></p><ol><li>Abstract:- Abstraction is the process of hiding the internal details of an application from the outer world. Abstraction is used to describe things in simple terms.</li></ol><p>Ex- when we are driving a car, we are only concerned about driving the car like start/stop the car, accelerate/ break, etc.</p><p>2. Encapsulation:- Encapsulation can be used to hide both data members and data functions or methods associated with an instantiated class or object.</p><p>Ex- Containers are just one example of encapsulation in coding where data and methods are bundled together into a single package.</p><p>3. Inheritance:- Inheritance is a mechanism in which one class acquires the property of another class.</p><p>Ex- A child inherits the traits of his/her parents. With inheritance, we can reuse the fields and methods of the existing class.</p><p>4. Polymorphism:- Polymorphism is one of the core concepts of object-oriented programming (OOP) and describes situations in which something occurs in several different forms. In computer science, it describes the concept that you can access objects of different types through the same interface.</p><p>Ex- Let’s say we have a class Animal that has a method sound() . Since this is a generic class so we can’t give it an implementation like: Roar, Meow, Oink etc. We had to give a generic message.</p><h3>RDBMS</h3><p>The software used to store, manage, query, and retrieve data stored in a relational database is called a relational database management system (RDBMS). The RDBMS provides an interface between users and applications and the database, as well as administrative functions for managing data storage, access, and performance.</p><p><strong>Features:- </strong>Index creation for retrieving data at a higher speed. Facilitates a common column to be shared amid two or more tables. Multi-user accessibility is facilitated to be controlled by individual users.</p><p><strong>Characteristics:- </strong>Data abstraction, Self-describing data, Concurrency, Support for multiple views, Security, The use of keys. Each row of data in a table is identified by a unique “key”, called the primary key, Avoiding data redundancy, Constraining the input, Maintaining data integrity, Structured Query.</p><p><strong>How RDBMS works?</strong></p><p>The software used to store, manage, query, and retrieve data stored in a relational database is called a relational database management system (RDBMS). The RDBMS provides an interface between users and applications and the database, as well as administrative functions for managing data storage, access, and performance.</p><p><strong>Advantages:-</strong> It allows database admins to maintain, control, update data into the database easily. With RDBMS, backing up of data becomes easy. Automation tools of RBDMS automate these tasks. Flexibility: This feature of RDBMS saves a lot of time as updating data in one place is enough.</p><p><strong>Disadvantages:- </strong>➨Software is expensive. ➨Complex software refers to expensive hardware and hence increases overall cost to avail the RDBMS service. ➨It requires skilled human resources to implement. ➨Certain applications are slow in processing.</p><p><strong>DBMS vs RDBMS:- </strong>Relational Database Management System (RDBMS) is a more advanced version of a DBMS system that allows access to data in a more efficient way. It is used to store or manage only the data that are in the form of tables.</p><p><strong>Normalization:-</strong></p><ul><li>Normalization is the process of organizing the data in the database.</li><li>Normalization is used to minimize the redundancy from a relation or set of relations. It is also used to eliminate undesirable characteristics like Insertion, Update, and Deletion Anomalies.</li><li>Normalization divides the larger table into smaller and links them using relationships.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/960/0*VQTNjJOhJvUDI_wz" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=7888f50c0a64" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>