本课程是为那些愿意学习有关数据库和系统分析的所有背景的人员（IT和非IT人员）而设计的。
完成本课程后，您将能够：
分析系统并构建实体关系图，并构建逻辑模型。
规范化你的数据库表（直到 3NF）。
使用 MySQL 将 ER-Diagram 实施到物理数据库中（构建自己的数据库）。
您将能够阅读、编写和理解 SQL 查询和复杂 SQL 查询（嵌套 SQL 查询）。
使用最重要的预建 SQL 函数。
在 SQL 中使用连接语句。
您将能够通过 Google Cloud Platform (GCP) 实现数据库。
课程定期更新，您可以随时提出问题并提供反馈。
其他DBMS等奖励内容将定期添加。
$44.99 | Created by Mohammad Abu hasira | Last updated 3/2020
Duration: 2 hours | Video: h264, 1280×720 | Audio: AAC, 44 KHz, 2 Ch | 1.3 GB
Genre: eLearning | Language: English + Sub | 40 lectures
What you’ll learn
Introduction to Data and Data Types in SQL perspective
Introduction to information Systems
System Analysis & E-R Modelling and Relationships
Different ways to for Database Modeling
Querying using Structure Query Language
Data Definition language (DDL)
Data Manipulation language (DDL)
Installing MySQL Server and building your own live database
Operators
Aggregation functions
Filtering
Assignments
Requirements
No requirements, Only Your computer
Description
This course is designed to people from all backgrounds (IT and non-IT) who are willing to learn all about Databases and System analysis
After this course you’ll be able to :
Analyse a system and Build Entity-Relationship Diagrams, and build the logical model.
Normalise your database tables (until the 3NF).
Implement your ER-Diagram into a physical database using MySQL ( Build your own Database).
You’ll be able to read, write and understand SQL queries and Complex SQL queries (Nested SQL queries).
Use most important Pre-built SQL functions.
Use join statements in SQL.
You’ll be able to implement a database over Google Cloud Platform (GCP).
The course is updated regularly, you can always ask questions and give feedback.
Bonus content such as other DBMS will be added regularly.
Who this course is for:
Beginners looking forward to discover the world of database
People with no knowledge to databases world
Students Looking to boost their academic performance
This course is NOT for Database Professionals
原创文章，作者：steven，如若转载，请注明出处：https://rr3d.cn/11796.html
