الدروس والاختبارات لتعلم هذه الدورة التدريبية : دورة تديبية في تصميم وبناء قواعد البيانات MySQL

• 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

• القسم: Database And Data Types

• 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

• القسم: Design Database

• Database Design, Entity row cell and Table Defination

• ER Model And Why Use it

• Normalization in Tables

• Primary Key And Foregin Key

• القسم: Numbers, Create and read tables

• 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

• القسم: Strings and Date and Default constants

• 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

• القسم: CRUD And DML And Filteration

• 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

• القسم: Design, Normalization, Relationships

• 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

• القسم: Relationships in Practice

• 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

• القسم: Joins

• 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

• القسم: Data Interact

• 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 course

• Recite Section 1 and Intro to Recite Section 2

• Recite Section 2

• Recite Sections 3 and 4 and 5