Complete Data Analysis Course for Absolute Beginners [2020]

Installation of MYSQL database

Refer to the next session.

Installation of MYSQL Workbench for writing SQL queries.

Refer to the next session.

For oracle refer to the video and the following:

Installation of Oracle ( XE Edition )

Oracle has provided the community edition : Express Edition ( XE)

Min system requirement

1) Microsoft Windows 7

2) RAM 512 MB

3) Disk space 2 GB

Reference docsfor installation Guide https://docs.oracle.com/cd/E17781_01/install.112/e18803/toc.htm#XEINW119

Download Link for XE edition

https://www.oracle.com/database/technologies/xe-downloads.html

Installation of SQL Developer Client

SQL developer is the freeware software for writing SQL from simplest to the most complex.

Other developer client which are used in Industries are :

Toad , DB Visualiser , SQL Workbench , PLSQL Developer

Reference link for download SQL developer

https://www.oracle.com/tools/downloads/sqldev-v192-downloads.html

The commands are broadly categorised as follows:

• Data Definition Language (DDL)

• Data Manipulation Language (DML)

As the name suggests, the DDL is used to create a new schema as well as to modify the existing schema. The typical commands in DDL are — CREATE, ALTER and DROP. As a data analyst, the majority of your work will be focused on insight generation, and you will be working with DML commands, specifically the SELECT command.

In this lecture, you learned the basic constructs in the SELECT query. The session will also cover the creation of schema for the database that will be used throughout the session. You will specifically learn the following:

• SELECT clause

• FROM Clause

• WHERE Clause

• Basic Sorting and Filtering in SQL

Pattern Matching using LIKE function

Pattern matching is an important concept in the string or text-based processing. In SQL, certain characters are reserved as wildcards that can match any number of preceding or trailing characters

Sorting

In SQL, sorting is done using the clauses 'asc' and 'desc' for ascending and descending order respectively. You will also learn to use the IN, NOT IN and IS NULL clauses.

In this lecture, you also learned to use the following clauses:

1. IN

2. NOT IN

3. IS NULL

4. Asc

5. desc

Summary of Learning Till now

Till now you learn the basics of Database and SQL. Database was invented to store the data in a more consistent manner and to access with ease. Such databases are called as RDBMS.

You then learnt that in an RDBMS, the data is organised in tables inside a database and SQL is the language to access and manipulate data in an RDBMS. There are two major categories of SQL commands:

• Data Definition Language i.e. DDL

• Data Manipulation Language i.e. DML

The DDL commands are typically used to change the structure of schema by creating new tables or adding new columns in existing tables or dropping tables etc. Such activities are typically done by DBA .

As a data analyst you will be frequently using the DML commands.

In this session you learned the basics of SQL , select commands, where command, filter conditions and order by clause.

In the next session you are going to learn aggregate functions , and advance SQL queries which you will be using more frequently in your day to day projects.