~Get Your Files Here !

  01 Introduction

   001 Introduction.mp4

   002 What is SQL.mp4

   004 What is MySQL.en.srt

   005 What is PostgreSQL.en.srt

   006 What is SQL Server.en.srt

   007 What is T-SQL.en.srt

   008 Basic Database Concepts.en.srt

   009 What is a Schema.en.srt

   010 Database Schema.en.srt

  02 MySQL Database Server Setup

   001 MySQL Download & Installation on Windows.mp4

   002 MySQL Workbench for windows.mp4

   003 MySQL Installation on Macs.mp4

   004 MySQL Workbench Installation on Macs.mp4

   005 Creating a new MySQL Connection.mp4

   006 Managing Server Connections.mp4

   007 Client Connections.mp4

   008 Checking MySQL Server Status.mp4

   009 MySQL Data Types.mp4

   010 Creating a database in MySQL.mp4

   011 Using IF NOT EXIST DROP.mp4

   012 Creating a table in MySQL Database.mp4

   013 Setting Default MySQL Database.mp4

   014 Using Primary Keys.mp4

   015 Using Foreign Keys.mp4

   016 SQL Statement and Query.mp4

  03 Data Analysis & Manipulation with MySQL

   001 Query Data.mp4

   002 SUB Queries.mp4

   003 Nested Sub queries.mp4

   004 Derived Tables.mp4

   005 Insert Data.mp4

   006 Update Data.mp4

   007 Delete Data.mp4

   008 Removing duplicate records.mp4

   009 Grouping Data.mp4

   010 Separating Grouped Data.mp4

   011 Sorting Data.mp4

   012 Filtering Data.mp4

  04 MySQL Data Analysis using Table Joins & Views

   001 MySQL INNER Join.mp4

   002 MySQL LEFT Join.mp4

   003 MySQL RIGHT Join.mp4

   004 MySQL SELF Join.mp4

   005 MySQL VIEWS.mp4

   006 Creating MySQL Views.mp4

   007 Query MySQL Views.mp4

   008 Modify Views.mp4

   009 Dropping a View.mp4

  05 MySQL Data Analysis using Aggregate Functions & Operators

   001 What are aggregate Functions.mp4

   002 AVG Aggregate Function.mp4

   003 COUNT Aggregate Function.mp4

   004 SUM Aggregate Function.mp4

   005 MIN Aggregate Function.mp4

   006 MAX Aggregate Function.mp4

   007 BETWEEN Operator.mp4

   008 IN Operator.mp4

   009 LIKE Operator.mp4

   010 UNION Operator.mp4

  06 PostgreSQL Setup

   001 PostgreSQL Installation on Windows.mp4

   002 PostgreSQL Installation on Macs.mp4

   003 PgAdmin Installation on Macs.mp4

   004 Connecting to PostgreSQL Database Server.mp4

   005 Download Sample Database.mp4

  07 Data Analysis with SQL on PostgreSQL Database

   001 Filtering Data.mp4

   002 Sorting Data.mp4

   003 SUB Queries.mp4

   004 Comparison Operators.mp4

   005 NOT Operators.mp4

   006 OR Operators.mp4

   007 AND Operators.mp4

   008 Combining AND _ OR Operators.mp4

  08 SQL PostgreSQL Data Analysis with Analytic Functions

   001 What are Analytic Functions.mp4

   002 Creating tables.mp4

   003 Using AVG as Window Function.mp4

   004 Row Number Functions.mp4

   005 Rank Functions.mp4

   006 DENSE RANK Functions.mp4

   007 FIRST Value Function.mp4

   008 LAST Value Function.mp4

   009 LAG Function.mp4

   010 LEAD Function.mp4

  09 Microsoft SQL Server Setup

   001 SQL Server Installation Requirements.mp4

   002 SQL Server Editions.mp4

   003 SQL Server Downloads.mp4

   004 SQL Server Installation.mp4

   005 Installing SSMS.mp4

   006 Connecting to SQL Server with SSMS.mp4

   007 Install Sample Database.mp4

  10 Data Analysis with Microsoft SQL

   001 Filtering Data with equality filters.mp4

   002 Filtering Data with comparison filters.mp4

   003 Filtering Data with logical filters.mp4

   004 Filtering Data with string comparison filters.mp4

   005 Sorting Data with ORDER BY.mp4

   006 Sorting data in ascending order.mp4

   007 Sorting data in descending order.mp4

   008 Sorting data by multiple columns.mp4

  11 MS SQL Data Analysis with Ranking Functions

   001 What are ranking functions.mp4

   002 Analysing data with RANK Functions.mp4

   003 Analysing data with NTILE Functions.mp4

   004 Analysing data with DENSE_ RANK Functions.mp4

   005 Analysing data with ROW Number Functions.mp4

   006 Using Multiple Ranking Functions.mp4

  12 MS SQL Data Analysis with MS SQL Analytic Functions & SET Operators

   001 What are Analytic Functions.mp4

   002 Analysing data with PERCENT_RANK Functions.mp4

   003 Analysing data with CUME_DIST Functions.mp4

   004 Analysing data with PERCENTILE_DISC Functions.mp4

   005 Analysing data with PERCENTILE_CONT Functions.mp4

   006 Analysing data with EXCEPT SET Operators.mp4

   007 Analysing data with INTERSECT SET Operators.mp4

   008 Analysing data with UNION SET Operators.mp4