Srbija Posted October 4, 2020 Share #1 Posted October 4, 2020 (edited) SQL Programming for Data Analysis and Software Development MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch Genre: eLearning | Language: English + .srt | Duration: 119 lectures (25h 34m) | Size: 16 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 Homepage http://anonymz.com/?https://www.udemy.com/course/sql-programming-for-data-analysis-and-software-development/ https://rapidgator.net/file/fc42c4d6867868d6f149047a52a3ada8/SQL_Programming_for_Data_Analysis_and_Software_Development.part01.rar.html https://rapidgator.net/file/f05e894543a24da0725036c9facdb299/SQL_Programming_for_Data_Analysis_and_Software_Development.part02.rar.html https://rapidgator.net/file/d346eb1f84d5152806e7af87d150e0aa/SQL_Programming_for_Data_Analysis_and_Software_Development.part03.rar.html https://rapidgator.net/file/51e30ba6858489aef3458066fe2cae6c/SQL_Programming_for_Data_Analysis_and_Software_Development.part04.rar.html https://rapidgator.net/file/8796104d9549d81687c78c5bda666620/SQL_Programming_for_Data_Analysis_and_Software_Development.part05.rar.html https://rapidgator.net/file/b353aa0ac7008fbba396e2cfecc014bb/SQL_Programming_for_Data_Analysis_and_Software_Development.part06.rar.html https://rapidgator.net/file/a9e4cd63bc5a84207a35c0e9a5fc1345/SQL_Programming_for_Data_Analysis_and_Software_Development.part07.rar.html https://rapidgator.net/file/f5f243eabfb2b63c136bd7269687e230/SQL_Programming_for_Data_Analysis_and_Software_Development.part08.rar.html https://rapidgator.net/file/aa196e9953e2ca279be8166c5426e95e/SQL_Programming_for_Data_Analysis_and_Software_Development.part09.rar.html https://rapidgator.net/file/1b2cc8d71218988ce3da492a3ae23f54/SQL_Programming_for_Data_Analysis_and_Software_Development.part10.rar.html https://rapidgator.net/file/be83d4f5ce9e138471882dd15cfd01b2/SQL_Programming_for_Data_Analysis_and_Software_Development.part11.rar.html https://rapidgator.net/file/f88dacb5a72b0aeb092dfd28f83a5f5f/SQL_Programming_for_Data_Analysis_and_Software_Development.part12.rar.html https://rapidgator.net/file/445d0831d98682706ba4ffa506fea70a/SQL_Programming_for_Data_Analysis_and_Software_Development.part13.rar.html https://rapidgator.net/file/d7d1585b983c4445a3bac6549990f62e/SQL_Programming_for_Data_Analysis_and_Software_Development.part14.rar.html https://rapidgator.net/file/125fd0a5d2eb53eba603c63ee53d3be6/SQL_Programming_for_Data_Analysis_and_Software_Development.part15.rar.html https://rapidgator.net/file/d914ff25e6bc7acc87064bd7200d6ca8/SQL_Programming_for_Data_Analysis_and_Software_Development.part16.rar.html https://rapidgator.net/file/0fe06ad790bf3a071ec521f8fb350788/SQL_Programming_for_Data_Analysis_and_Software_Development.part17.rar.html Edited February 6, 2021 by Bad Karma Dead links removed Link to comment
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now