دورة تديبية في تصميم وبناء قواعد البيانات MySQL
$19.00
لرؤية المحاور والأهداف ومعلومات أخرى عن البرنامج الدراسي للإنضمام قم بزيارة دورة تديبية في تصميم وبناء قواعد البيانات 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
بعد إتمام الكورس على المنصة والحصول على شهادة اتمام البرنامج الالكترونية، يستطيع المشارك طلب شهادة دبلوم مع بطاقة عضوية مطبوعة ،رسوم إضافية امتحان الدبلوم مع اصدار الشهادة إضافية وبطاقة العضوية و الشحن
تقييمات
لا يوجد تعليقات بعد