<?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 Mrunali Patil on Medium]]></title>
        <description><![CDATA[Stories by Mrunali Patil on Medium]]></description>
        <link>https://medium.com/@mrunaligp30?source=rss-fc16e14e1063------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*c6hyHv0mBbd1qeKo.jpg</url>
            <title>Stories by Mrunali Patil on Medium</title>
            <link>https://medium.com/@mrunaligp30?source=rss-fc16e14e1063------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 22:23:33 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@mrunaligp30/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[Naming Convention Rules used in Programming]]></title>
            <link>https://medium.com/@mrunaligp30/naming-convention-rules-used-in-programming-b0f9b4aa0a4e?source=rss-fc16e14e1063------2</link>
            <guid isPermaLink="false">https://medium.com/p/b0f9b4aa0a4e</guid>
            <dc:creator><![CDATA[Mrunali Patil]]></dc:creator>
            <pubDate>Mon, 25 May 2020 12:32:23 GMT</pubDate>
            <atom:updated>2020-05-30T14:21:52.415Z</atom:updated>
            <content:encoded><![CDATA[<h3>Camel Case and Pascal Case: Naming Convention Rules</h3><p>So, here we getting the knowledge about naming conventions, its types and where to be used that types.</p><h3>What is naming conventions?</h3><ul><li><strong>Naming Convention</strong> is a defined set of rules, used for choosing proper character sequence used for an identifier, which specifically denote variables, functions, classes and other entities in source code.</li><li>Suppose, I want to give variable name such as ‘my name is’. But while declaration of variables spaces are not allowed.</li><li>If I write this variable name such as ‘mynameis’ or ‘MYNAMEIS’, but it is difficult to read and also takes more time for understanding which purpose used that variable. For example I used this variable to indicate my name.</li><li>So, naming convention provide three ways to write variable in proper format.</li><li>The variable ‘mynameis’ is written by me such as ‘myNameIs’ or ‘MyNameIs’ or ‘_myNameIs’.</li></ul><h4>There are three types of naming conventions:-</h4><ol><li>Camel case</li><li>Pascal case</li><li>Underscore case</li></ol><p>So, Understanding this one by one…</p><h4>1. Camel case naming conventions:-</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/396/0*exIHr1WZdDS_qu32.png" /></figure><ul><li>camelCase naming convention allows us to combine multiple words in a single word. But the rule is that, the word must start with lower case letter and each next word in that string is start with upper case letter.</li><li><strong><em>For example:</em></strong>- I want to declare variable as ‘my class is’. So, declare it using camelCase is:-</li></ul><p>string myClassIs=”TECSE”;</p><ul><li><strong>Example:-</strong></li></ul><p>class MathsLogic{</p><p>int num1Value=0; //←camel case</p><p>int num2Value=0; //←camel case</p><p>}</p><h4>2. Pascal case naming conventions:-</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/329/0*w2pQVTRGv-kCspg7.png" /></figure><ul><li>A Pascal Case is also a combination of two or more words in a single word but rule is that first letter of each word is in upper case.</li><li>Pascal Case is used, where there is an enclosure.</li><li><strong><em>For example:- </em></strong>I want to declare variable as ‘my class is’. So, declare it using PascalCase is:-</li></ul><p>string MyClassIs=”TECSE”;</p><ul><li><strong>Example:-</strong></li></ul><p>class MathsLogic{ //←PascalCase</p><p>int num1Value=0; //←camelCase</p><p>int num2Value=0; //←camelCase</p><p>}</p><h4>3. Underscore case naming convention:-</h4><ul><li>In Underscore case naming convention, we can combine multiple words in a single word by separating them with Underscore (‘_’).</li><li>We can also start the name with Underscore (‘_’).</li><li><strong><em>If variable name is starting with underscore then that variable is private variable.</em></strong></li><li>For example:-I want to declare variable as ‘my class is’. So, declare it using underscore case is:-</li></ul><p>string _myClassIs=”TECSE”;</p><h3>Where to use Camel case and where to use Pascal case?</h3><ul><li>Pascal case is used for giving file name, class Name, function Name, stored procedures.</li><li>Camel case is used for giving variable name, constant name, end of the node.</li><li>For making variable private, use underscore with camel case.</li><li>For making variable public, use camel case without underscore.</li></ul><p>So, this is all about naming conventions used in programming.</p><p><em>If this article is useful then share with someone who may need it.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b0f9b4aa0a4e" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Learn Angular Step-by-Step PART-II (Data Binding)]]></title>
            <link>https://medium.com/@mrunaligp30/learn-angular-step-by-step-part-ii-data-binding-83fb31ba3f10?source=rss-fc16e14e1063------2</link>
            <guid isPermaLink="false">https://medium.com/p/83fb31ba3f10</guid>
            <dc:creator><![CDATA[Mrunali Patil]]></dc:creator>
            <pubDate>Mon, 25 May 2020 04:58:57 GMT</pubDate>
            <atom:updated>2020-05-25T05:02:49.258Z</atom:updated>
            <content:encoded><![CDATA[<p>Hello everyone! In this article we are going to learn about data binding in angular. So, lets start…</p><h4>What is meant binding?</h4><ul><li>Binding is the process of making connection between your application User Interface(UI) and data that want displays.</li></ul><h4>What is Data Binding?</h4><ul><li>Data Binding is the process of synchronizing data between model and view components.</li><li>Synchronization of data between model and view components means, when data in the model changes, automatically view reflects the change, and when data in the view changes, it automatically update the model.</li></ul><p><strong>There are mainly two parts that considers while data binding :-</strong></p><ol><li><strong>View i.e. UI:-</strong> It is an html UI. It contains templates such as buttons, input tags, etc.</li><li><strong>Component:-</strong>View has some code behind it, it is called component. It contains classes, methods and other things for UI.</li></ol><ul><li>When we do changes in UI, such as, add some buttons or anything else then component should handle it.</li></ul><p><strong><em>Data binding has two types. It can done either one way or two way.</em></strong></p><h3>1. One way data binding:-</h3><ul><li>One way data binding is a unidirectional means either a data flows from component to view or from view to component.</li><li><strong>It has two types:-</strong></li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/763/1*HnZF7WB7nYg3rowJAPkqkw.png" /></figure><ol><li><strong>Event binding:-</strong></li></ol><ul><li>In event binding, data flows from view to component.</li><li>Event binding occurs when if we click on button, passing some values from keyboard, etc.</li><li>Event binding uses round bracket ‘()’ to pass data from view to component.</li></ul><p>2. <strong>Property binding:-</strong></p><ul><li>In property binding, data flows from component to view.</li><li>Use square brackets ‘[]’ to pass data from component to UI.</li></ul><h3>2. Two Way Binding:-</h3><ul><li>In two way binding, data come and go from both view and component.</li><li>It is a combination of property and event binding.</li><li>For achieving two way binding, both square and round brackets are used such as ‘[()]’.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/764/1*yxprUhWTFjUXoDAvo60bPA.png" /></figure><ul><li>Here, syntax used for two way binding is:-</li></ul><p><strong><em>[(ngModel)]=”Component Property”</em></strong></p><ul><li>[(ngModel)] is called as Angular directives.</li><li>Directive means it changes the behaviour of HTML.</li></ul><h4>Example of Data Binding:-</h4><ul><li>First open your project in VS Code , in that open file ‘app.component.html’ and write below code in it.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1000/1*PtIg3RKjpbrzlFZoh6uu4Q.png" /></figure><ul><li>Now, open ‘app.component.ts’ file and write below code in it.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1003/1*IrThj9MAKYO0Zg5GTku64g.png" /></figure><ul><li>Now, run the project using ‘ng serve’ command and copy localhost port number given by this command. Paste it to your browser and press enter.</li><li>We get below screen. Add patient Name to it and click on ‘Click’ button.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/319/1*Gnhf2w7j2ktuFTeS0sQ5zg.png" /></figure><ul><li>If we click on ‘Click’ button gets output as below screen. Press to OK.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/995/1*_VxNwa6U1mg2vBaEe8c9Iw.png" /></figure><ul><li>This is all about data binding in an Angular.</li></ul><p>If this article is helpful, then share with someone who may need it.</p><p><em>For getting more knowledge about Angular must watch this video:-</em></p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FFV2MXOygDTM%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DFV2MXOygDTM&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FFV2MXOygDTM%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/d79f845ccd2be5a55515fcb9064300c5/href">https://medium.com/media/d79f845ccd2be5a55515fcb9064300c5/href</a></iframe><p><em>If not read my previous article on angular then read it using below link and if feels as it is helpful then share with someone who may need it.</em></p><p><a href="https://medium.com/@mrunaligp30/learn-angular-step-by-step-part-i-21bb136c714">Learn Angular Step-by-Step PART-I</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=83fb31ba3f10" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Learn Angular Step-by-Step PART-I]]></title>
            <link>https://medium.com/@mrunaligp30/learn-angular-step-by-step-part-i-21bb136c714?source=rss-fc16e14e1063------2</link>
            <guid isPermaLink="false">https://medium.com/p/21bb136c714</guid>
            <dc:creator><![CDATA[Mrunali Patil]]></dc:creator>
            <pubDate>Sat, 23 May 2020 06:23:52 GMT</pubDate>
            <atom:updated>2020-05-23T06:30:27.404Z</atom:updated>
            <content:encoded><![CDATA[<p>Hello everyone! In this article, we are going to learn about,</p><p>i. What is CLI?</p><p>ii. Which commands are required to run angular project.</p><p>iii. Running first angular application.</p><p>So lets start…</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/311/1*2nMnQSo7Tv2_ILtDtxNbZA.png" /></figure><h3>Angular:-</h3><ul><li>Angular is a open source application design framework that binds code between JavaScript object and UI element.</li><li>Javascript framework is used to build Single Page Applications(SAP). You can create both mobile and web applications using an Angular.</li><li>Whole angular source code is mainly divided into 3 sections:-</li></ul><ol><li><strong>Angular:- </strong>Actual angular framework contains in it.Actual code binding is done over here.</li></ol><p><strong>2. Components:-</strong>To make an UI, component part is used. UI contains material design such as grids, auto complete box, flying text boxes, buttons, menus,etc. that all are in component part.</p><p><strong>3. Angular-CLI:- </strong>CLI is a Command Line Interpreter. It helps you to create basic project template.</p><ul><li>So, first need to install CLI. By using that we can create and run the project.</li></ul><h4>Steps for installing CLI and run first angular project:-</h4><p><strong><em>Step-1: Install Node.js in your computer.</em></strong></p><ul><li>Node.js is an open source JavaScript framework, which helps to run JavaScript code outside the browser.</li><li>For downloading node.js click on below link:</li></ul><blockquote><a href="https://nodejs.org/en/">Click here to download node.js</a></blockquote><ul><li>After clicking this link we got below page. Then you download current version as I marked with red box.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*6pwgINqSraU1flhZGUiAyA.png" /></figure><ul><li>After the complete installation of Node.js, we see the Node.js command prompt(as shown below) in computer program files. By using this command prompt we can fire the NPM commands.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/605/1*3cmeH6zOMB4w3y1qibrj_w.png" /></figure><p>After that we need to install angular CLI.</p><p><strong>Step-2: Install angular CLI.</strong></p><ul><li>We install Angular CLI by using following commands:</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/501/1*dzUOpfNyRv2ogg64pv0pTA.png" /><figcaption>Picture-1</figcaption></figure><ul><li>All this commands are may run via node.js command prompt or else create one folder in any drive and open this folder via VS Code and in VS Code terminal all that commands are run. We require internet connection to run all this commands.</li><li>To download and install angular CLI, first command in above picture is used.</li></ul><blockquote>npm install -g @angular/cli</blockquote><ul><li>NPM stands for Node Package Manager.</li><li>‘-g’ specifies install all packages GLOBALLY. If installation of packages done globally then we can run project from any command prompt.</li><li>For checking angular CLI installed successfully or not, run below command:-</li></ul><blockquote>ng - -version</blockquote><p><strong>Step-2: Create first Angular Project.</strong></p><ul><li>By using second command in Picture-1, we create project.</li></ul><blockquote>ng new my-dream-app</blockquote><ul><li>my-dream-app is a name of project.</li><li>So we creating project HospitalManagement.</li><li>While creating project they ask couple of questions:-</li></ul><p>i. Would you like to add angular routing?(y/N)</p><p>For this question, type N that is No.</p><p>ii. Which stylesheet format would you like to use?(Use arrow keys)</p><p>For this question, press enter while on CSS.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/981/1*ynqbQ93_-f1Rz9SH1E3zow.png" /></figure><ul><li>After successfully creating project, at left hand side under folder HospitalManagement we can see all project folder, in which basic templates are created. This is shown below :</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/983/1*3cyuwTymQW6KLdznoBeXdA.png" /></figure><p><strong>Step-3: Change the directory to go inside the project.</strong></p><ul><li>Now, for running created project we need to go inside the project. so, third command in Picture-1 is used.</li></ul><blockquote>cd my-dream-app</blockquote><ul><li>cd means Change Directory. After cd command, we go inside HospitalManagement project. As shown in below snapshot:-</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/712/1*sqEv4htL1nU2Rpbj6CwHNA.png" /></figure><p><strong>Step-4: Run the created project.</strong></p><ul><li>By using last command in Picture-1, we run the created project.</li></ul><blockquote>ng serve</blockquote><ul><li>This command compiles all files and makes project template.</li><li>So, after successful compilation of project, it show the port number(in below snapshot marked as yellow box) to run on that localhost in browser. This is shown in below snapshot.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/972/1*Lh-K8eSmLizPOOk4RDT9QQ.png" /></figure><ul><li>So, to run our project, copy the port number which I have yellow marked and paste it in chrome.</li><li>You have run your project successfully. For the first time the browser will show you the official angular page as shown below:</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/983/1*8A8Nq1YXx8bIzcXcoIG5VA.png" /></figure><ul><li>Now to display any of your code on browser, we need to go in app.component.html file which is present under the project folder.</li><li>Open this file and clear all code inside it.</li><li>Type any text you want and save it.</li><li>See below snapshot, in HospitalManagement project I write some text as,</li></ul><p>‘This is our first angular</p><p>Application’</p><p>and got output as,</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/987/1*H9R_JUFv3Oz7CdMu0VDD6g.png" /></figure><h4>Note:-In angular, not need to always refresh the browser to see the changes made in project. It automatically done by compiler. Also not need to compile again and again, if we do any changes, automatically compiler compiles it and gives output in browser.</h4><p>If this article is helpful, then share with someone who may need it.</p><p><em>For getting more knowledge about Angular must watch this video:-</em></p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2F0kmdjqgO9IY%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D0kmdjqgO9IY&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2F0kmdjqgO9IY%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/12b292dba260220b976829fd75df9494/href">https://medium.com/media/12b292dba260220b976829fd75df9494/href</a></iframe><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=21bb136c714" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[SQL SELECT Statement-Part-IV]]></title>
            <link>https://medium.com/@mrunaligp30/sql-select-statement-part-iv-a3734d33b5fb?source=rss-fc16e14e1063------2</link>
            <guid isPermaLink="false">https://medium.com/p/a3734d33b5fb</guid>
            <dc:creator><![CDATA[Mrunali Patil]]></dc:creator>
            <pubDate>Wed, 20 May 2020 11:37:12 GMT</pubDate>
            <atom:updated>2020-05-20T11:37:12.191Z</atom:updated>
            <content:encoded><![CDATA[<p>In this article we learn about SQL SELECT statement. So lets start…</p><h3>SQL:-</h3><ul><li>Structured Query Language(SQL) is a query language, by using this we can communicate with database.</li><li>It can define structure of data, modify data in database and also specify security constraints.</li><li><strong><em>The SQL has several parts:-</em></strong></li></ul><p>I. Data Definition Language(DDL)</p><p>II. Data Manipulation Language(DML)</p><p><strong>I. Data Definition Language(DDL):-</strong></p><p>The SQL DDL provides commands for defining table structures, deleting tables, and modifying table structures. It includes queries such as create table, drop table, alter table, etc.</p><p><strong>II. Data Manipulation Language(DML):-</strong></p><p>The SQL DML provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database. It includes queries such as insert, update, delete and retrieve data from database tables.</p><blockquote>SELECT is a DML statement in SQL.</blockquote><p><strong><em>Syntax for SELECT statement:-</em></strong></p><blockquote>SELECT ColumnName(s) FROM TableName</blockquote><p>Here, select statement selects columns specified in the place of columnName(s) from the table which specified in TableName and display the result.</p><p><strong><em>Example:-</em></strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*y4yG04z2BsrdNIIze6DEJg.png" /></figure><h4>SELECT statement to display all records:-</h4><ul><li>To retrieve all data and display all records from table, ‘*’ symbol is used. ‘*’ symbol indicates all.</li></ul><p><strong><em>Syntax:-</em></strong></p><blockquote>SELECT * FROM TableName</blockquote><p>It gives output as all columns and tuples from specified TableName.</p><p><strong><em>Example:-</em></strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*p9v3ARCYNOyjZ7TJmB9yTQ.png" /></figure><h4>SELECT statement with WHERE clause:-</h4><ul><li>SELECT statement also helps to retrieve specific data from table. For this, WHERE clause is used. It specifies the condition from that we want data from table.</li></ul><p><strong><em>Syntax:-</em></strong></p><blockquote>SELECT * FROM TableName</blockquote><blockquote>WHERE Condition</blockquote><p><strong><em>Example:-</em></strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*LJdCa4Gs2Jn2hKuO_lMIsg.png" /></figure><h4>SELECT statement with Numeric and String:-</h4><p>There are two ways to retrieve data from table using where clause. They are:-</p><ol><li><strong>Numeric:-</strong></li></ol><p>If you want data from table then you gives condition, While giving condition simply gives conditional operator and condition in the form numbers auch as id, salary, etc. by using that we want your requested records.</p><p><strong><em>Example:-</em></strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*IRNGpWxcydj8-dx2len2QA.png" /></figure><p>2. <strong>String:-</strong></p><p>While we want data from table and we gives condition in the form of string value, then put that conditional string in single inverted commas (‘’).</p><p><strong><em>Example:-</em></strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ybbp9tM7zmcg8f0t9AL3sA.png" /></figure><h4>SELECT specific columns with ALIAS:-</h4><p><strong><em>Example:-</em></strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*XoFiLtURqqr8y6qstqKLYA.png" /></figure><ul><li>In above example, output table as column name that specified in select query.</li><li>But sometimes it is not understood.</li><li>So, for that we give new column name to same column.</li><li>This is called ALIAS. ALIAS are used with ‘AS’ keyword.</li></ul><p><strong><em>Example:-</em></strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*W20T59vDaJ1_0U20avO7cQ.png" /></figure><h4>Wild Card Operator:-</h4><ul><li>Wild Card operator is used for getting pattern matching string.</li><li>It is used with LIKE operator for searching matching string.</li><li>For wild card operator <strong><em>syntax</em></strong> is:-</li></ul><blockquote>SELECT * FROM TableName</blockquote><blockquote>WHERE ColumnName LIKE ‘PatternMatchingString’</blockquote><ul><li><strong><em>Example 1:-</em></strong></li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*iPFCbqV6EPMKKWQLs2lE7Q.png" /></figure><ul><li><strong><em>Example 2:-</em></strong></li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*V1n8cdjc2YjR0j1JM2tHMg.png" /></figure><h4>Select with Inner Join:-</h4><ul><li>Inner Join helps to show the only matching records from both the tables.</li></ul><p><strong><em>Syntax:-</em></strong></p><blockquote>SELECT columnName(s) FROM Table1</blockquote><blockquote>INNER JOIN Table2 ON Table1.ColumnName=Table2.ColumnName;</blockquote><p><strong><em>Example:-</em></strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1022/1*rMzY8UGsToOiXaYw6ZVV0w.png" /></figure><h4>Select with Left Join:-</h4><ul><li>Left join selects all the records from left side table and only matching records from right side table and display.</li></ul><p><strong><em>Syntax:-</em></strong></p><blockquote>SELECT columnName(s) FROM Table1</blockquote><blockquote>LEFT JOIN Table2 ON Table1.ColumnName=Table2.ColumnName;</blockquote><p><strong><em>Example:-</em></strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*BtZ9YtN69KtuFYHYvL7qrw.png" /></figure><h4>Select with Right Join:-</h4><ul><li>Right join selects all the records from right side table and only matching records from left side table and display.</li></ul><p><strong><em>Syntax:-</em></strong></p><blockquote>SELECT columnName(s) FROM Table1</blockquote><blockquote>RIGHT JOIN Table2 ON Table1.ColumnName=Table2.ColumnName;</blockquote><p><strong><em>Example:-</em></strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*NimK_FljKeGNJTZ8NbTMfQ.png" /></figure><p><em>For getting more information about SQL query statement must watch this video:-</em></p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FuGlfP9o7kmY%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DuGlfP9o7kmY&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FuGlfP9o7kmY%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/b108a31cf1ed747e6c45d31aa03bdf63/href">https://medium.com/media/b108a31cf1ed747e6c45d31aa03bdf63/href</a></iframe><p><em>If not read my previous articles then below are links, read it and if feels as it is helpful then share with someone who may need it.</em></p><ul><li><a href="https://medium.com/@mrunaligp30/sql-server-for-beginners-part-i-7bf6e2b695d7">SQL Server for Beginners Part-I</a></li><li><a href="https://medium.com/@mrunaligp30/sql-server-for-beginners-part-ii-a638d75f47ef">SQL Server for beginners Part-II</a></li><li><a href="https://medium.com/@mrunaligp30/sql-server-for-beginners-part-iii-89ea0c46ad28">SQL Server for beginners Part-III</a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a3734d33b5fb" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Normalization in SQL]]></title>
            <link>https://medium.com/@mrunaligp30/normalization-in-sql-db40b20e420e?source=rss-fc16e14e1063------2</link>
            <guid isPermaLink="false">https://medium.com/p/db40b20e420e</guid>
            <dc:creator><![CDATA[Mrunali Patil]]></dc:creator>
            <pubDate>Fri, 24 Apr 2020 15:36:30 GMT</pubDate>
            <atom:updated>2020-04-24T17:14:06.740Z</atom:updated>
            <content:encoded><![CDATA[<p>In this article, we learn about Normalization and types of normal forms.</p><h3><strong>Normalization:-</strong></h3><ul><li>Normalization is a process which is used to minimize the data redundancies and remove duplication from the table.</li><li>In other way, normalization is defined as splitting a table into multiple tables as per need.</li><li>Normalization process transforms database is in inconsistent form to consistent form i.e. trusted form.</li></ul><h4>What is data redundancies and duplication:-</h4><ul><li>Redundant means like synonyms, means expressing same thing in multiple ways.</li><li>For example, there is table say Person. Person belongs to any country. There are three peoples, they belongs to country INDIA, but while filling information one fill country name as India, second fill country name as Bharat, third fill as IND. So country is INDIA, but express it using India, Bharat, IND i.e. multiple ways, so this is called redundant data.</li><li>Duplicate data means exactly same. Duplicate data is like copied.</li><li>For same example, if two persons fill country as India, then this is called as duplicate data i.e. same to same.</li><li>Redundant data is more problematic than duplicate data, so while fixing the redundant data it takes more effort than duplicate data.</li></ul><h4>Need of Normalization:-</h4><ul><li>Consider the following database:-</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/960/1*0lCbNOXUY8UxMIOkZGAjNw.png" /><figcaption>Fig.1 Database of Construction Company</figcaption></figure><p>The above database is of one construction company. It manages several building projects. And display the report as shown in above table.</p><p><strong>Consider the following problems related to this database:</strong></p><p>1. The project number (PROJ_NUM) is intended to be a primary key(PK) or at least a part of a PK, but it contains nulls.</p><p>2. The table entries occurs data inconsistencies. For example, the JOB_CLASS has value “Elect. Engineer” might be entered as “Elect.Eng.” , or, “El. Eng.” or “EE”.</p><p>3. The table displays <strong>data redundancies</strong> that has following anomalies:</p><p><strong>a.</strong> <strong>Update anomalies</strong>: If we change value of one entity then all the copies of that entity must be updated. Modifying the JOB_CLASS for employee number 105 does many changes, for each EMP_NUM = 105.</p><p><strong>b.</strong> <strong>Insertion anomalies</strong>: If some value of inserting data is not present then that data does not be inserted into database. If we want insert that, then use some dummy fields.</p><p><strong>c. Deletion anomalies</strong>: Suppose that one employee is associated with a project. If that employee leaves the company and the employee data is deleted, the project information will also be deleted. To prevent the loss of the project information, a dummy employee must be created.</p><p>So for overcome this problems we need to follow normalization process. And table is converting into different types of normal forms for maintaining consistency.</p><h4>Types of normal forms in Normalization:-</h4><ol><li>First Normal Form(1NF)</li><li>Second Normal Form(2NF)</li><li>Third Normal Form(3NF)</li><li>Fourth Normal Form(4NF)</li></ol><p><strong>Different Normal forms with example:-</strong></p><h4><strong>1. First Normal Form(1NF):-</strong></h4><ul><li>1NF specifies table not contain any repeating groups.</li><li>Each cell of its table have its own value.</li><li>Above given example in Fig. 1 contains repeating groups. So to convert table into 1NF is required.</li></ul><p><strong><em>Steps for converting table in 1NF:-</em></strong></p><p><strong>Step 1: Eliminate the Repeating Groups</strong></p><ul><li>Table is representing in such format, where each cell has a single value and there are no repeating groups. To eliminate the repeating groups, eliminate the nulls by making sure that each repeating group attribute contains an appropriate data value.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/965/1*cbeTa6rFot5Jx6mFZMgNHA.png" /><figcaption>Fig. 2 Repeating groups eliminated</figcaption></figure><p>Table now becomes as above.</p><p><strong>Step 2: Identify the Primary Key</strong></p><ul><li>The PROJ_NUM is not an primary key because the project number does not uniquely identify all of the remaining attributes i.e. tuple in a table. For example, the PROJ_NUM value 15 can identify any one of five employees.</li><li>To maintain a proper primary key that uniquely identify any attribute value, the new key must be formed as combination of PROJ_NUM and EMP_NUM. So, it is now easy to identify tuples uniquely.</li></ul><p><strong>Step 3: Identify All Dependencies</strong></p><ul><li>The identification of the PK in Step 2 means that we have already identified the following dependency: PROJ_NUM and EMP_NUM uniquely identify all attributes. i.e.</li></ul><p>PROJ_NUM, EMP_NUM → PROJ_NAME, EMP_NAME, JOB_CLASS, CHG_HOUR, HOURS</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/943/1*53qnn4UJVLFA9IM5GMruVg.png" /><figcaption>Fig.3 Table is in 1NF</figcaption></figure><h4>2. Second Normal Form(2NF):-</h4><ul><li>Conversion of table to 2NF occurs only when 1NF has composite primary key.</li><li>If 1NF has only single primary key then table is automatically in 2NF.</li></ul><p><strong><em>Steps to convert 1NF to 2NF:-</em></strong></p><p><strong>Step 1</strong>: <strong>Make New Tables to Eliminate Partial Dependencies</strong></p><ul><li>A <strong>partial dependency </strong>exists when there is a functional dependence in which the determinant is only part of the primary key. For each component of the primary key that acts as a determinant in a partial dependency, create a new table with a copy of that component as the primary key.</li><li>While these components are placed in the new tables, it is important that they also remain in the original table as well. Because they will be the foreign keys for the relationships needed to relate these new tables to the original table.</li><li>Write each key component on a separate line and then write the original key on the last line. For example:</li></ul><p>Proj_Num</p><p>Emp_Num</p><p>Proj_Num,Emp_Num</p><ul><li>Each component will become the key in a new table. In other words, the original table is now divided into three tables (PROJECT, EMPLOYEE, and ASSIGNMENT).</li></ul><p><strong>Step 2: Reassign Corresponding Dependent Attributes</strong></p><ul><li>The dependencies for the original key components are found by examining the arrows below the dependency diagram shown in 1NF. The attributes that are dependent in a partial dependency are removed from the original table and placed in the new table with the dependency’s determinant.</li><li>Any attributes that are not dependent in a partial dependency will remain in the original table.</li><li>The second NF form of Fig.3 is as follows:-</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/912/1*Dus5GBJuTzhPC-h99mLNog.png" /><figcaption>Fig.4 2NF</figcaption></figure><h4>3. Third Normal Form(3NF):-</h4><ul><li>If table is in 2NF and still there present some transitive dependencies then then need to convert it into 3NF by eliminating transitive dependency.</li></ul><p><strong><em>Steps to converting 2NF to 3 NF:-</em></strong></p><p><strong>Step 1: Make New Tables to Eliminate Transitive Dependencies</strong></p><ul><li>For every transitive dependency, write a copy of its determinant as a primary key for a new table.</li><li>A determinant is any attribute whose value determines other values within a row in table.</li><li>As with the conversion to 2NF, it is important that the determinant remain in the original table to serve as a foreign key.</li></ul><p><strong>Step 2: Reassign Corresponding Dependent Attributes</strong></p><ul><li>The Fig. 4, identify the attributes that are dependent on each determinant identified in Step 1.</li><li>Place the dependent attributes in the new tables with their determinants and remove them from their original tables.</li><li>In this example, eliminate CHG_HOUR from the EMPLOYEE table.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/956/1*pjoezhoTyaYf99CTTrJjSg.png" /><figcaption>Fig. 5 3NF</figcaption></figure><h4><strong>4. Fourth Normal Form(4NF):-</strong></h4><ul><li>A table is in fourth normal form (4NF) when it is in 3NF and has no multivalued dependencies.</li><li>Consider example:-</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/376/1*thW7BfEqezypiZUu_XbmqQ.png" /><figcaption>Fig. 6 Student Table</figcaption></figure><ul><li>In the above example, Student Sachin learn Management, Finance, Marketing and hobbies and they have multiple hobbies like singing, playing, so the Subjects and Hobbies attributes are multivalued.</li><li>To solve this problem splitting of table is required.</li><li>The solution is to eliminate the problems caused by the multivalued dependency. You do this by creating new tables for the components of the multivalued dependency.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/644/1*uKnZPaexFZApWnpsa6U_0g.png" /><figcaption>Fig. 7 Table in 4NF</figcaption></figure><p>So, this is about Normalization in SQL.</p><p><strong>For more understanding the SQL Normalization watch this video:-</strong></p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FHmnQyP8s5O8%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DHmnQyP8s5O8&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FHmnQyP8s5O8%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/5efd6a0aa671e3ab167b17ed891bac72/href">https://medium.com/media/5efd6a0aa671e3ab167b17ed891bac72/href</a></iframe><p><em>If this article is useful then share it with someone who may need it.</em></p><p><strong><em>To see all my JavaScript and TypeScript articles go through this:-</em></strong></p><ol><li><a href="https://medium.com/@mrunaligp30/hello-guys-8b1e8b1a6fc4">Basics Of JavaScript</a></li><li><a href="https://medium.com/@mrunaligp30/inheritance-in-javascript-4e35923ed0e7">Inheritance in JavaScript</a></li><li><a href="https://link.medium.com/0Lv0qwG8n5">Introduction Of TypeScript</a></li><li><a href="https://link.medium.com/bALdmDucr5">Interface in TypeScript</a></li><li><a href="https://link.medium.com/PMkEWa1zu5">Abstract class in TypeScript</a></li><li><a href="https://link.medium.com/Y1o4ZDq8x5">Access Modifiers and constructors in TypeScript</a></li><li><a href="https://link.medium.com/SoleK5bmH5">TypeScript configuration File</a></li><li><a href="https://link.medium.com/dACvkIhME5">Hoisting in JavaScript</a></li><li><a href="https://link.medium.com/1PJuo9ItE5">this keyword and global sharing in JavaScript</a></li><li><a href="https://link.medium.com/mxhGN5JlH5">JavaScript closures</a></li><li><a href="https://link.medium.com/9psMnoDfL5">IIFE in JavaScript</a></li><li><a href="https://medium.com/@mrunaligp30/sql-server-for-beginners-part-i-7bf6e2b695d7">SQL Server for Beginners Part-I</a></li><li><a href="https://medium.com/@mrunaligp30/sql-server-for-beginners-part-ii-a638d75f47ef">SQL Server for Beginners Part-II</a></li><li><a href="https://medium.com/@mrunaligp30/sql-server-for-beginners-part-iii-89ea0c46ad28?source=your_stories_page---------------------------">SQL Server for Beginners Part-III</a></li><li><a href="https://link.medium.com/LCrLYDwZW5">Normalization in SQL</a></li></ol><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=db40b20e420e" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[SQL Server for beginners Part-III]]></title>
            <link>https://medium.com/@mrunaligp30/sql-server-for-beginners-part-iii-89ea0c46ad28?source=rss-fc16e14e1063------2</link>
            <guid isPermaLink="false">https://medium.com/p/89ea0c46ad28</guid>
            <dc:creator><![CDATA[Mrunali Patil]]></dc:creator>
            <pubDate>Fri, 24 Apr 2020 12:21:23 GMT</pubDate>
            <atom:updated>2020-04-24T17:15:39.708Z</atom:updated>
            <content:encoded><![CDATA[<p>Here, we learn about candidate key, unique key and primary key. Also seeing the difference between unique key and primary key.</p><h3>Candidate Key:-</h3><ul><li>For getting knowledge about candidate key, we first know the super key.</li><li><strong>Super key </strong>refers that, one or more attributes of table is used to uniquely identify the tuples in a table.</li><li>For example, there is a Company database. In that database, the table is Employee. It contains empNo, projectNo, empName, projectName, location, salary. If we take empNo and projectNo then uniquely identify tuple in a table. Also, if we take empNo and empName then also uniquely identify tuple in a table. For identifying tuple uniquely there are many other combinations of attribute in table Employee. So this is called as Super key.</li><li><strong>Candidate key</strong> is defined as minimal super key.</li><li>So, in same example, we refer empNo as candidate key because empNo is unique for all employees and also uniquely identify tuple in a table. So, only one attribute is used to identify tuple uniquely, this is called minimal super key i.e. candidate key.</li><li>Candidate key is implemented by using unique key.</li></ul><h3><strong>Unique Key:-</strong></h3><ul><li><strong>Unique key</strong> is used for specifying candidate key.</li><li>Unique key is a combination of one or more attributes that uniquely identify tuple in a table.</li><li>It don’t allowed to duplicate values in particular column/attribute.</li><li><em>For applying unique keys for table, steps are:-</em></li></ul><p>i. Go to Object Explorer.</p><p>ii. Right click on table that you want to apply unique key constraints.</p><p>iii. Click on design.</p><p>iv. Right click on column that you want to apply unique key.</p><p>v. Click on “Indexes/keys”.</p><p>vi. Click on add.</p><p>vii. In opened dialog box, click on Type under General and choose unique key from drop down list.</p><p>viii. Click on save or simply press “CTRL+S”.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1013/1*ZTD8eEcCeoiA05lkt58pZA.png" /><figcaption>Example of Unique Key</figcaption></figure><p>Here, unique key is applied on Empid. First time Empid 12 is inserted, so no problem. While inserting 12 Empid again then shows the error as above.</p><h3><strong>Primary Key:-</strong></h3><ul><li><strong>Primary key</strong> is same as unique key but there is some differences.</li><li>It uniquely identify the tuple in a table.</li><li><em>For applying primary key for table, steps are:-</em></li></ul><p>i. Go to Object Explorer.</p><p>ii. Right click on table that you want to apply primary key constraint.</p><p>iii. Click on design.</p><p>iv. Right click on column that you want to apply primary key.</p><p>v. Click on “Indexes/keys”.</p><p>vi. Click on add.</p><p>vii. In opened dialog box, click on Type under General and choose primary key from drop down list.</p><p>viii. Click on save or simply press “CTRL+S”.</p><h3><strong>Unique key VS Primary key:-</strong></h3><ol><li><strong>Unique Key</strong> is used to <em>represent the candidate key</em>. Where <strong>Primary Key</strong> is used to <em>represent the main key whose data will not change</em>.</li><li><strong>Unique Key</strong><em> allows null values</em>. <strong>Primary Key </strong><em>does not allow null values</em>.</li><li><strong>Unique Key </strong><em>is not strict.</em><strong> Primary key </strong><em>strict.</em></li><li><strong>Unique key </strong>allows for data changing, so <em>problem occurs for referencing table. </em><strong>Primary Key </strong><em>don’t allows for data changing so it is mostly used in foreign key as referential integrity.</em></li><li><em>In same table </em><strong>multiple Unique keys are allowed</strong><em>.</em></li><li><em>In same table </em><strong>only one Primary Key is allowed.</strong></li></ol><p>This is about Unique Key and Primary Key.</p><p><strong>For more information watch this video:-</strong></p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2Fo9D6G-LVp5U%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Do9D6G-LVp5U&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2Fo9D6G-LVp5U%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/66f28ebd11e78caac4cc0dbcdea11fa4/href">https://medium.com/media/66f28ebd11e78caac4cc0dbcdea11fa4/href</a></iframe><p>If this article is helpful, then share with someone who may need it.</p><p><strong><em>To see all my JavaScript and TypeScript articles go through this:-</em></strong></p><ol><li><a href="https://medium.com/@mrunaligp30/hello-guys-8b1e8b1a6fc4">Basics Of JavaScript</a></li><li><a href="https://medium.com/@mrunaligp30/inheritance-in-javascript-4e35923ed0e7">Inheritance in JavaScript</a></li><li><a href="https://link.medium.com/0Lv0qwG8n5">Introduction Of TypeScript</a></li><li><a href="https://link.medium.com/bALdmDucr5">Interface in TypeScript</a></li><li><a href="https://link.medium.com/PMkEWa1zu5">Abstract class in TypeScript</a></li><li><a href="https://link.medium.com/Y1o4ZDq8x5">Access Modifiers and constructors in TypeScript</a></li><li><a href="https://link.medium.com/SoleK5bmH5">TypeScript configuration File</a></li><li><a href="https://link.medium.com/dACvkIhME5">Hoisting in JavaScript</a></li><li><a href="https://link.medium.com/1PJuo9ItE5">this keyword and global sharing in JavaScript</a></li><li><a href="https://link.medium.com/mxhGN5JlH5">JavaScript closures</a></li><li><a href="https://link.medium.com/9psMnoDfL5">IIFE in JavaScript</a></li><li><a href="https://medium.com/@mrunaligp30/sql-server-for-beginners-part-i-7bf6e2b695d7">SQL Server for Beginners Part-I</a></li><li><a href="https://medium.com/@mrunaligp30/sql-server-for-beginners-part-ii-a638d75f47ef">SQL Server for Beginners Part-II</a></li><li><a href="https://medium.com/@mrunaligp30/sql-server-for-beginners-part-iii-89ea0c46ad28?source=your_stories_page---------------------------">SQL Server for Beginners Part-III</a></li><li><a href="https://link.medium.com/LCrLYDwZW5">Normalization in SQL</a></li></ol><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=89ea0c46ad28" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[SQL Server for beginners Part-II]]></title>
            <link>https://medium.com/@mrunaligp30/sql-server-for-beginners-part-ii-a638d75f47ef?source=rss-fc16e14e1063------2</link>
            <guid isPermaLink="false">https://medium.com/p/a638d75f47ef</guid>
            <dc:creator><![CDATA[Mrunali Patil]]></dc:creator>
            <pubDate>Fri, 24 Apr 2020 11:32:05 GMT</pubDate>
            <atom:updated>2020-04-24T17:16:18.773Z</atom:updated>
            <content:encoded><![CDATA[<p>In previous article we learned about SQL Server 2019 and SSMS installation. Also we learned about database and tables creation.</p><p>Now, we discuss some rules for specifying data in SQL.</p><h3>Integrity:-</h3><ul><li>Integrity refers that something that is in right and in the consistent form.</li><li>SQL supports multiple data types such as int, varchar, nvarchar, datetime, money, float, decimal, etc.</li><li>Suppose, in table there is field like name, so name is a string that is data type of name is varchar.</li><li>So, while inserting values if we specify string is in name is correct. But if we put other than string i.e. numbers or floats or any other values in column then it gives an error.</li></ul><h3>Constraints:-</h3><ul><li>Constraints are applied on a particular attribute in a table.</li><li>Constraints are rules that specifies the accuracy and correctness of data.</li><li>There are some integrity constraints that need to follow while designing database.</li></ul><h3>Integrity constraints:-</h3><ol><li>Data integrity</li><li>Uniqueness</li><li>Referential integrity</li></ol><p><strong><em>Data integrity:-</em></strong></p><ul><li>Data integrity is used to specify proper data type for SQL attributes.</li><li><strong>For example</strong>, table Employee contains many attributes. In that, for Empid the data type is number, for EmpName the data type is varchar with specified size(varchar(20)), for Doj(DateOfJoining) data type is datetime, for Salary data type is money.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*QFcxoAh0FfYB31yosuUE7w.png" /></figure><ul><li>When we add test that is string in Empid then it gives error as shown above, because data type of Empid is number. So, it follows data integrity.</li></ul><p><strong><em>Uniqueness:-</em></strong></p><ul><li>Uniqueness points to unique key in the table.</li><li>Uniqueness can be achieve by using unique key or primary key.</li><li>If we apply unique key in table for particular column, then that column does not contain any duplicate value.</li><li>Unique key attributes are unique in nature, not duplicate.</li><li>For applying unique key, steps:-</li></ul><p>i. Go to Object Explorer. Right click on table that you want to apply unique constraints and click on design.</p><p>ii. Right click on column that you want to apply unique key, Click on “Indexes/keys”. Click on add.</p><p>iii. In opened dialog box, click on Type under General and choose unique key from drop down list. And click on save or simply press “CTRL+S”.</p><p>For adding primary key, same steps are followed, but instead of unique key choose Primary key in drop down list.</p><p><strong><em>Referential Integrity:-</em></strong></p><ul><li>Referential integrity specifies reference from one table to other table.</li><li>For applying referential integrity, foreign key is used.</li><li>For implementing referential integrity, both table contains at least one primary or unique key attribute(column).</li><li><strong>Unique key </strong>allows for data changing, so <em>problem occurs for referencing table. </em><strong>Primary Key </strong><em>don’t allows for data changing so it is mostly used in referential integrity.</em></li><li>First table primary key attribute is referencing to another table primary key attribute.</li><li>For example, there are two tables-one is Employee and other is Address. Employee table contains primary key Empid, Address table contains primary key Addressid. If we do changes in Employee table then automatically respected fields of Address table get changed because of referential integrity. This shows in below figures. And if some values not present in any of the two table then simply shows “null” at that place.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/766/0*QMEzPhL8lFL5yWg8.png" /><figcaption>Table : Employee</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/685/1*lWMLs28S9DS97giSRB4SrA.png" /><figcaption>Table : Address</figcaption></figure><p><em>This is all about integrity constraints in SQL.</em></p><p><strong>For getting more knowledge about it must watch the video:-</strong></p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FuGlfP9o7kmY%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DuGlfP9o7kmY&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FuGlfP9o7kmY%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/b108a31cf1ed747e6c45d31aa03bdf63/href">https://medium.com/media/b108a31cf1ed747e6c45d31aa03bdf63/href</a></iframe><p>If this article is helpful, then share with someone who may need it.</p><p>If you not read my previous article on SQL Server then read it as follows:-</p><p><a href="https://medium.com/@mrunaligp30/sql-server-for-beginners-part-i-7bf6e2b695d7">SQL Server for Beginners Part-I</a></p><p><strong><em>To see all my JavaScript and TypeScript articles go through this:-</em></strong></p><ol><li><a href="https://medium.com/@mrunaligp30/hello-guys-8b1e8b1a6fc4">Basics Of JavaScript</a></li><li><a href="https://medium.com/@mrunaligp30/inheritance-in-javascript-4e35923ed0e7">Inheritance in JavaScript</a></li><li><a href="https://link.medium.com/0Lv0qwG8n5">Introduction Of TypeScript</a></li><li><a href="https://link.medium.com/bALdmDucr5">Interface in TypeScript</a></li><li><a href="https://link.medium.com/PMkEWa1zu5">Abstract class in TypeScript</a></li><li><a href="https://link.medium.com/Y1o4ZDq8x5">Access Modifiers and constructors in TypeScript</a></li><li><a href="https://link.medium.com/SoleK5bmH5">TypeScript configuration File</a></li><li><a href="https://link.medium.com/dACvkIhME5">Hoisting in JavaScript</a></li><li><a href="https://link.medium.com/1PJuo9ItE5">this keyword and global sharing in JavaScript</a></li><li><a href="https://link.medium.com/mxhGN5JlH5">JavaScript closures</a></li><li><a href="https://link.medium.com/9psMnoDfL5">IIFE in JavaScript</a></li><li><a href="https://medium.com/@mrunaligp30/sql-server-for-beginners-part-i-7bf6e2b695d7">SQL Server for Beginners Part-I</a></li><li><a href="https://medium.com/@mrunaligp30/sql-server-for-beginners-part-ii-a638d75f47ef">SQL Server for Beginners Part-II</a></li><li><a href="https://medium.com/@mrunaligp30/sql-server-for-beginners-part-iii-89ea0c46ad28?source=your_stories_page---------------------------">SQL Server for Beginners Part-III</a></li><li><a href="https://link.medium.com/LCrLYDwZW5">Normalization in SQL</a></li></ol><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a638d75f47ef" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[SQL Server for Beginners Part-I]]></title>
            <link>https://medium.com/@mrunaligp30/sql-server-for-beginners-part-i-7bf6e2b695d7?source=rss-fc16e14e1063------2</link>
            <guid isPermaLink="false">https://medium.com/p/7bf6e2b695d7</guid>
            <dc:creator><![CDATA[Mrunali Patil]]></dc:creator>
            <pubDate>Mon, 20 Apr 2020 17:21:39 GMT</pubDate>
            <atom:updated>2020-04-24T17:16:47.831Z</atom:updated>
            <content:encoded><![CDATA[<p>In this article, we getting knowledge about SQL server.</p><p><strong>SQL Server:-</strong></p><ul><li><em>SQL Server is a Relational Database Management System(RDBMS) which is used to store data.</em></li><li>It is developed by Microsoft.</li><li>SQL stands for Structured Query Language.</li><li>There are various versions of SQL Server, e.g., SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2018, SQL Server 2019.</li><li>The latest version of SQL Server is SQL Server 2019, which is released in year 2019. So in this article learn how to install and use it.</li><li>SQL Server runs on different operating systems like Windows, Linux, Docker, etc.</li></ul><h4>So firstly we need to download and install SQL Server. So steps are:-</h4><ol><li><strong>Go to Google search engine, type “Download sql server 2019”. Press search button.</strong></li><li><strong>Then click on SQL Server downloads.</strong></li><li><strong>So, we got a page:</strong></li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*3T-phOTfos1onTl6ZiXjDQ.png" /></figure><p>SQL Server is comes with various versions. The three of the main are:-</p><p><strong>i. Express Edition:-</strong></p><p>The Express edition provided by Microsoft is free. By using that we do the development, production as well. But it has very limited features.</p><p><strong>ii. Developer Edition:-</strong></p><p>Developer Edition is a fully featured environment. By using that, development of some applications is done. Also Testing on non-production environment is possible. Non-production environment means it is not real, we go and learn SQL Server, test the developed application personally(on your local computer only).</p><p><strong>iii. Enterprise Edition:-</strong></p><p>It is not free. Client has do some payment and then use it. It is mainly used for production environment. This is the top-end edition with full feature set and Storage Area Network support.</p><h4>So, here we downloading and installing Developer Edition.</h4><p>4. <strong>After installing SQL Server we got the SQL Server Management Studio(SSMS).</strong> By using that we perform operations like creating databases, creating tables, etc.</p><p>5. <strong>Open SQL Server Management Studio.</strong></p><p>6.<strong> Then go to file and click on connect object explorer.</strong></p><p>7. The SQL Server Management Studio(SSMS) is a front end or we can say it as User Interface(UI). It is used for create databases, create tables, etc like queries.</p><p>To handle the RDBMS queries we need a SQL Server Service. The service is a heart of SQL server, it handles all thing is SQL. If service is not started then we can’t connect with SSMS. It works as background process or back end.</p><p>Connection is requires between SQL Server Management Studio(SSMS) and SQL Server Service. Otherwise, gets an error. For that, service must be started.</p><h4><strong>Steps for Starting service:-</strong></h4><p>a. Go to control panel.</p><p>b. Click on Administrative tools.</p><p>c. In that window we have the services. Click on it. In that services, we have option SQL Server(MSSQLSERVER). Right click on it and start the service.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*ECZHrBtNmpHkDAdG.png" /></figure><p>Once service is started, then connect to the SQL Server Management Studio as follows:-</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*WqqUkzkJihY_jteg.jpeg" /></figure><p>For the security point of view the SQL server given two ways of authentication:-</p><p><strong>i. Using Windows authentication:-</strong></p><ul><li>It provides login of windows for your personal computer. By using this, we can access SQL Server.</li><li>It is more secure than server authentication.</li></ul><p><strong>ii. Using server Authentication:-</strong></p><ul><li>It provides login Id and password to access a SQL server. By using login Id and password user can logged and use SQL Server.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/292/1*t3aENAhzUIuJXCYKeJTkFw.png" /></figure><p>Here, we give a server type as Database Engine, server name as (local) and authentication is windows authentication because it is more secure.</p><p>Once the connection is establish we got a screen as follows:-</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/361/1*fjAkqw53Tbjp5qn7yeGJVA.png" /></figure><p>Here, we see all the objects of SQL Server. Like databases, security,etc.</p><p>8. <strong>SQL Server organizes data in the form of databases. Databases is a collection of tables. And tables uses rows ad columns to store data.</strong></p><h4>To create database, steps are:-</h4><p>a. Click on view.</p><p>b. Go to object explorer.</p><p>c. Right click on database.</p><p>d. Click on new database.</p><p>e. Give the name of database. (While creating database, database is stored in two format: one is database file and other is log file.)</p><p>f. Click on OK.</p><p>9. <strong>Now, your database is now created. For adding tables to database, steps :-</strong></p><p>i. Extract your named database folder.</p><p>ii. Right click on option ‘Table’.</p><p>iii. Click on ‘create new table’. Give the name of table and press enter.</p><p>iv. Now, specify Column names and respected data types.</p><p>v. Click on save button. While saving if you want give table name then you can give name to that table. Then press OK.</p><p>10. <strong>To insert data into table:-</strong></p><p>Click on Object explorer, extract database, right click on your created database, add data . click on save.</p><p>So, this is about SQL Server.</p><p><strong><em>If we want more information about SQL server and its installation, see below video:-</em></strong></p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2Fo9D6G-LVp5U%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Do9D6G-LVp5U&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2Fo9D6G-LVp5U%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/66f28ebd11e78caac4cc0dbcdea11fa4/href">https://medium.com/media/66f28ebd11e78caac4cc0dbcdea11fa4/href</a></iframe><p>If this article is helpful, then share with someone who may need it.</p><p><strong><em>To see all my JavaScript and TypeScript articles go through this:-</em></strong></p><ol><li><a href="https://medium.com/@mrunaligp30/hello-guys-8b1e8b1a6fc4">Basics Of JavaScript</a></li><li><a href="https://medium.com/@mrunaligp30/inheritance-in-javascript-4e35923ed0e7">Inheritance in JavaScript</a></li><li><a href="https://link.medium.com/0Lv0qwG8n5">Introduction Of TypeScript</a></li><li><a href="https://link.medium.com/bALdmDucr5">Interface in TypeScript</a></li><li><a href="https://link.medium.com/PMkEWa1zu5">Abstract class in TypeScript</a></li><li><a href="https://link.medium.com/Y1o4ZDq8x5">Access Modifiers and constructors in TypeScript</a></li><li><a href="https://link.medium.com/SoleK5bmH5">TypeScript configuration File</a></li><li><a href="https://link.medium.com/dACvkIhME5">Hoisting in JavaScript</a></li><li><a href="https://link.medium.com/1PJuo9ItE5">this keyword and global sharing in JavaScript</a></li><li><a href="https://link.medium.com/mxhGN5JlH5">JavaScript closures</a></li><li><a href="https://link.medium.com/9psMnoDfL5">IIFE in JavaScript</a></li><li><a href="https://medium.com/@mrunaligp30/sql-server-for-beginners-part-i-7bf6e2b695d7">SQL Server for Beginners Part-I</a></li><li><a href="https://medium.com/@mrunaligp30/sql-server-for-beginners-part-ii-a638d75f47ef">SQL Server for Beginners Part-II</a></li><li><a href="https://medium.com/@mrunaligp30/sql-server-for-beginners-part-iii-89ea0c46ad28?source=your_stories_page---------------------------">SQL Server for Beginners Part-III</a></li><li><a href="https://link.medium.com/LCrLYDwZW5">Normalization in SQL</a></li></ol><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=7bf6e2b695d7" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Immediately Invoked Function Expression(IIFE) in JavaScript]]></title>
            <link>https://medium.com/@mrunaligp30/immediately-invoked-function-expression-iife-in-javascript-6385546cfdb8?source=rss-fc16e14e1063------2</link>
            <guid isPermaLink="false">https://medium.com/p/6385546cfdb8</guid>
            <dc:creator><![CDATA[Mrunali Patil]]></dc:creator>
            <pubDate>Fri, 17 Apr 2020 15:06:00 GMT</pubDate>
            <atom:updated>2020-04-20T17:29:12.512Z</atom:updated>
            <content:encoded><![CDATA[<h3>Immediately Invoked Function Expression (IIFE) in JavaScript</h3><p>Immediately Invoked Function Expression (IIFE) in JavaScript is very important, because whole TypeScript is depend on it.</p><p><strong>IIFE</strong>:-</p><ul><li>It is a JavaScript function that was initially invoked when application run inside the browser and that function never invoked twice again.</li><li>Any variable that used in JavaScript, must be declared and initialized.</li></ul><p><strong>For example:-</strong> var value=10;</p><ul><li>If variable declared as global then it is accessed by any file so problem of global pollution is occurred.</li><li>There is some situations like, it is initialized only once and only accessible locally. It Cannot be accessed globally by any file.</li><li>So, for that purpose Immediately Invoked Function Expression is used.</li><li><strong><em>Syntax:-</em></strong></li></ul><p>(function FunctionName(){</p><p>//variables and methods;</p><p>})();</p><ul><li><strong><em>Example:-</em></strong></li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/498/1*B4Buo_wVisiFNi-jevDohQ.png" /></figure><p>So here, IIFE is init(). It gives output as current time for example: 12:23:34.</p><h3><strong>Important points related to IIFE:-</strong></h3><ul><li>In IIFE, initialize variables in function only once.</li><li>Methods in IIFE should not invoked twice. It immediately invoked only once when browser starts to run application.</li><li><strong>All variables are locally scoped:-</strong>By declaring variables locally protection is provided to variables. So, problem of global pollution is avoided.</li></ul><p><strong><em>Example:-</em></strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/583/1*t9JE6M3PXMGd-1_Y6gZUvg.png" /></figure><p>In this example, loggedInTime is local and private variable to function init(). When its tried to access outside then it gives error. In above example, loggedInTime was tried to access in fun1(), so error occurred as “ReferenceError: loggedInTime is not defined at fun1”.</p><ul><li>Also in IIFE, function not called outside directly. It is called as self contained IIFE.</li></ul><p><strong><em>Example:-</em></strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/551/1*srekQtu8VFWA3G4S6Oe4XA.png" /></figure><p>In the above example, init() function has local variables loggedInTime and dt. In that, init() function was called directly, so it gives an error as “ReferenceError: init is not defined”.</p><ul><li>When browser gets start, immediately first variables are initialized and they not accessible in outside.</li><li>If want to access these variables outside, then use closure property “return {}” to get access of variables in IIFE.</li></ul><p>So, this is about IIFE.</p><p><strong>For more understanding about an IIFE in JavaScript watch this video:-</strong></p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FFV2MXOygDTM%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DFV2MXOygDTM&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FFV2MXOygDTM%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/d79f845ccd2be5a55515fcb9064300c5/href">https://medium.com/media/d79f845ccd2be5a55515fcb9064300c5/href</a></iframe><p>If this article is useful then you can share it with someones who may need it.</p><p><strong><em>To see all my JavaScript and TypeScript articles go through this:-</em></strong></p><ol><li><a href="https://medium.com/@mrunaligp30/hello-guys-8b1e8b1a6fc4">Basics Of JavaScript</a></li><li><a href="https://medium.com/@mrunaligp30/inheritance-in-javascript-4e35923ed0e7">Inheritance in JavaScript</a></li><li><a href="https://link.medium.com/0Lv0qwG8n5">Introduction Of TypeScript</a></li><li><a href="https://link.medium.com/bALdmDucr5">Interface in TypeScript</a></li><li><a href="https://link.medium.com/PMkEWa1zu5">Abstract class in TypeScript</a></li><li><a href="https://link.medium.com/Y1o4ZDq8x5">Access Modifiers and constructors in TypeScript</a></li><li><a href="https://link.medium.com/SoleK5bmH5">TypeScript configuration File</a></li><li><a href="https://link.medium.com/dACvkIhME5">Hoisting in JavaScript</a></li><li><a href="https://link.medium.com/1PJuo9ItE5">this keyword and global sharing in JavaScript</a></li><li><a href="https://link.medium.com/mxhGN5JlH5">JavaScript closures</a></li><li><a href="https://link.medium.com/9psMnoDfL5">IIFE in JavaScript</a></li><li><a href="https://medium.com/@mrunaligp30/sql-server-for-beginners-part-i-7bf6e2b695d7">SQL Server for Beginners Part-I</a></li></ol><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6385546cfdb8" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[TypeScript tsconfig.json file]]></title>
            <link>https://medium.com/@mrunaligp30/typescript-tsconfig-json-file-794f7c60bfe5?source=rss-fc16e14e1063------2</link>
            <guid isPermaLink="false">https://medium.com/p/794f7c60bfe5</guid>
            <dc:creator><![CDATA[Mrunali Patil]]></dc:creator>
            <pubDate>Wed, 15 Apr 2020 06:46:13 GMT</pubDate>
            <atom:updated>2020-04-20T17:30:05.423Z</atom:updated>
            <content:encoded><![CDATA[<p>Here, we getting the knowledge about TypeScript configuration file i.e. tsconfig.json file.</p><ul><li>Any program created in TypeScript, this TypeScript file is converted to JavaScript every time before executing it.</li></ul><p><strong>For example</strong>:- Suppose, the file is Person. If we want to compile it, then this is done by using command,</p><p><strong>tsc Person.ts </strong>//TypeScriptCompiler FileName.extensionOfTSProgram</p><p>It converts Person.ts into Person.js file.</p><ul><li>It is suitable for single program. Suppose there are multiple programs in our project that requires compiling again and again. So, each time executing <em>tsc FileName.ts</em> command is not suitable.So for that, we create a <strong>tsconfig.json </strong>file.</li><li><strong>tsconfig.json </strong>file helps to go and create configurations which is applicable to whole compiling process of TypeScript.</li><li><em>tsconfig.json file is created by using command:-</em></li></ul><p><strong>tsc --init</strong></p><p>When we press enter after this command,it gives result as “Successfully created a tsconfig.json file”.</p><p><strong>Dist:-</strong></p><ul><li><strong>dist</strong> stands for distribution file.</li><li>It is a file which gives to the end user and end user can launch and use it.</li><li>If we want to put all files of project in single folder then we create a outDir property.</li></ul><p><strong>Example:-</strong></p><p>“outDir”:”./dist/”</p><p>In this command, ‘./’ refers current folder.</p><ul><li>After this command, <strong>dist </strong>folder is created in our project.<strong> It contains all final .js files.</strong></li><li>After creating this file we only give command as <strong>tsc</strong> in terminal. <em>We need not give file name and extension after tsc.</em></li></ul><p><strong>Target:-</strong></p><ul><li>TypeScript file is converted into JavaScript file i.e. .ts to .js file and that file is run inside the browser.</li><li>An ECMAScript gives various versions such as es4, es5, es6, es.next, etc.</li><li>The es5 version is suitable for all browsers.</li><li><strong>Example:-</strong></li></ul><p>“target”:”es5”</p><ul><li>If your system not supported newer versions and we go through another browsers then possibility of occuring an error as “Browser not compatible”.</li></ul><p><strong>For more information about tsconfig.json file in TypeScript wath this video:-</strong></p><p><a href="https://www.questpond.com/learn-angular-step-by-step/cid12">Learn Angular Step by Step</a></p><p>If this article is useful then you can share it with someones who may need it.</p><p><strong><em>To see all my JavaScript and TypeScript articles go through this:-</em></strong></p><ol><li><a href="https://medium.com/@mrunaligp30/hello-guys-8b1e8b1a6fc4">Basics Of JavaScript</a></li><li><a href="https://medium.com/@mrunaligp30/inheritance-in-javascript-4e35923ed0e7">Inheritance in JavaScript</a></li><li><a href="https://link.medium.com/0Lv0qwG8n5">Introduction Of TypeScript</a></li><li><a href="https://link.medium.com/bALdmDucr5">Interface in TypeScript</a></li><li><a href="https://link.medium.com/PMkEWa1zu5">Abstract class in TypeScript</a></li><li><a href="https://link.medium.com/Y1o4ZDq8x5">Access Modifiers and constructors in TypeScript</a></li><li><a href="https://link.medium.com/SoleK5bmH5">TypeScript configuration File</a></li><li><a href="https://link.medium.com/dACvkIhME5">Hoisting in JavaScript</a></li><li><a href="https://link.medium.com/1PJuo9ItE5">this keyword and global sharing in JavaScript</a></li><li><a href="https://link.medium.com/mxhGN5JlH5">JavaScript closures</a></li><li><a href="https://link.medium.com/9psMnoDfL5">IIFE in JavaScript</a></li><li><a href="https://medium.com/@mrunaligp30/sql-server-for-beginners-part-i-7bf6e2b695d7">SQL Server for Beginners Part-I</a></li></ol><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=794f7c60bfe5" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>