Intro to SQL.webm

Who and when use SQL.webm

What you will learn in this course.webm

Prepare environment concepts.webm

Query Language And Purpose of learning.webm

Run SQL via XAMPP CMD and run some codes.webm

7-Why Focus on SQL Query and management is easy

Install SQL Server on Ubuntu

Running SQL Queries on SQL Servers

Intro to Database Usage

Database Types And Big Data

Big Data Market And Why Use Databases

Data Types Numbers And Strings

Other data types and CRUD Concept

SQL Query Syntax

Revise Database Types and Usage

Revise NoSQL And Big Data

Revise Types and Queries And Goals

Database Design, Entity row cell and Table Defination

ER Model And Why Use it

Normalization in Tables

Primary Key And Foregin Key

Start execute SQL listing commands

Databases Commands via GUI phpmyadmin

Control Database by Command line and Basics Syntax Rules

Create table and columns and data types via GUI phpmyadmin

show and create and drop tables via GUI phpmyadmin

Number Data types and create simple table

Data Errors When Build non-optimized database

Fix Common beggner errors by Adding ID Primary Key and Auto Increment

Intro to Strings Data Types

MySQL Session terminal cookie error

Run commands from files in sql terminal

Create newsletter table with strings for email and default date

Drop table if exists and Insert new data and multi data

Alter table to add or modify columns to table in sql

show all or specific columns from sql using Select

ADD data from table to table using INSERT INTO SELECT in SQL

Built in Default Constants

Revise and recite on update contact effect in MySQL

Intro to CRUD

UPDATE Rows In SQL Database

Delete FROM Database

Intro to Clauses

Intro to Logical Clauses and DML topics

Intro to Single-Row functions and comments

Arithmatic operators

Apply Arithmatic Operators and values with NULL and Empty

Between, like, null, and logical door

Apply nested conditions in Where clause

String functions on cells in database

Apply functions on rows and columns cells

Apply functions on Decimals values

Revise Section Lessons

Apply search in String Using Like operators

Intro to Design Database ER-model and Diagram

Fast indexing and key attributes

Unique And ID int And Normalization

Apply Normalization 1f and Intro to Normalization 2F

Apply Normalization 2f and Intro to Normalization 3f

Apply Normalization 3f and Recite One to One relationship

Recite Design, Normalization And Relationships

Intro to practical guides in reltionships

Design Base Database via Diagram Tool

Define Relationships in Diagram

Design ER-model And Diagram And Convert them to code

Define relationships and table structure

Create relationships in SQL program codes

Apply relationships for foreign keys in sql codes

Apply relationships foregin keys and pass validation of sql on data

Intro to Joins And Inner Join

Inner Join And PostgreeSQL Syntax

Multi Inner Join And Intro to Left Join

What is Right join and How it works

Left Join And Revise Joins

Practice Right join in Details and Intro to Left Join

Revise JOINS and UNION SELECT Queries

Show rows Based on Other Rows Using Select Inside In by keys

Show rows Based on Other Rows Using Select Inside In by keys

Apply pagination concept in SQL

Intro to Group by and grouping data

Group by in SQL And Intro to Having

Use Having in SQL to apply conditions

How to export and backup data

Import files to database and run sql queries codes in GUI

Rollback all changes in Database for transactions

Import Big Data Using Load INFILE And MySQL Dump

Use MySQLDump to Load Big Data into database

Recite Section 1 and Intro to Recite Section 2

Recite Section 2

Recite Sections 3 and 4 and 5