SQL Programming for Data Analysis and Software Development
Learn Fundamentals of RDBMS with MySQL and MS SQL Server
Ratings 3.92 / 5.00
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
- 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
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 Should Attend!
- 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
