SQL Programming for Data Analysis and Software Development




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, OrNot

  • 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

Learn Fundamentals of RDBMS with MySQL and MS SQL Server

Url: View Details

What you will learn
  • Step by Step SQL Programming Language for Data Analysis and Software Development.
  • Learn MySQL from scratch
  • Learn MS SQL Server from scratch

Rating: 4.4

Level: Beginner Level

Duration: 25.5 hours

Instructor: Ankit Srivastava


Courses By:   0-9  A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z 

About US

The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of hugecourses.com.


© 2021 hugecourses.com. All rights reserved.
View Sitemap