SQL Programming for Data Analysis and Software Development

MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 119 lectures (25h 34m) | Size: 15.2 GB

Learn Fundamentals of RDBMS with MySQL and MS SQL Server

What you’ll learn:
Step by Step SQL Programming Language for Data Analysis and Software Development.
Learn MySQL from scratch
Learn MS SQL Server from scratch
Learn Creating Databases for Applications
Learn Database transfer from Local hosting to Web Hosting
Learn basics of Python Pandas for connecting MySQL Database using Anaconda Navigator
Learn Use of tools like MySQL Workbench and SQL Server Management Studio for Database Administration

Requirements
Basic Knowledge of Computer Concepts.

Description
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

Who this course is for
Beginners who want to build their career in the field of Data Science or Software Development.
Scool or College students who have SQL Language as a Subject in their curriculum.
Beginners who want to create SQL Database for their own web applications

Password/解压密码0daydown

Download rapidgator

Download nitroflare

转载请注明：0daytown » SQL Programming for Data Analysis and Software Development