SQL Programming for Data Analysis and Software Development

What will you learn in this SQL Tutorial?

• Introduction to SQl and its Applications

• Introduction to RDBMS and Tables

• Installing MySql , MSSQL etc.

• Creating a Database

• Creating a Table and Inserting Data

  Writing Queries for

• Select, Select Distinct

• Where Clause

• And, Or & Not

• Order By Clause

• Insert Into Statement

• Null Values

• Update Records in Table

• Delete Records from Table

• Select Top Statement

• Min and Max Aggregate Functions

• Count, Avg, Sum  Aggregate Functions

• Like Operator with Where Clause

• Wildcards in SQL for Pattern matching

• Use of IN Keyword in where and having clause

• Between Keyword in where clause

• Aliases for renaming columns

• Joins - Joining two or more tables to fetch data

• Inner Join

• Left Join

• Right Join

• Full Join

• Self Join

• Union and Union All for Joining two tables

• Group By Statement for One and More Tables

• Having Clause

• Use Exists Keyword

• Use of Any and All Operators in SQL

• Select Into Statement

• Insert Into Select Statement

• Functions in MySQL and MSSQL

• Datatypes in MySQL and MSSQL

• Case Function

• Null Functions

• What are Stored Procedures and how to use them

• How to write Comments in SQL

• Create, Drop and Backup DB

• Create, Drop and Alter Table

• Null and Not Null Constraints

• SQL Unique Constraints

• Creating SQL Primary Key and PK Constraints

• SQL Foreign Key Constraints

• SQL Default Constraints

• Creating SQL Index

• Using SQL Auto Increment

• Working with Dates in SQL

• Creating SQL Views

• SQL Injection

• Connecting MySQL Databases with Python Pandas

• Using MySQL workbench for accessing MySQL databases , creating tables , inserting , updating, selecting and deleting records.

• Using SQL Server Management Studio for accessing MSSQL databases , creating tables , inserting , updating, selecting and deleting records.

• Graphical Visualization of Data in Phpmyadmin (mysql) and Python Pandas Module (Basic Graphs).

• Web Hosting of MySql and MSSQl Databases