課程介紹

Learn how to use SQL quickly and effectively with this course!

You’ll learn how to read and write complex queries to a database using one of the most in demand skills – PostgreSQL. These skills are also applicable to any other major SQL database, su

…[更多細節]

哪些人適合這堂課？

• Anyone interested in learning more about SQL, PostgreSQL, or basic data analysis!

學習目標

• Use SQL to query a database
• Use SQL to perform data analysis
• Be comfortable putting SQL and PostgreSQL on their resume
• Learn to perform GROUP BY statements
• Replicate real-world situations and query reports

課程介紹

If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but comprehensive introduction to MySQL, one of the most highly in-demand skills in

…[更多細節]

哪些人適合這堂課？

• Anyone interested in learning SQL to help with their current job or to find a new role. SQL is one of today’s most in-demand skills
• Anyone looking to answer complex business problems and generate reports using data
• Business owners, people in sales, or people in marketing roles who are interested in understanding company data better.
• Developers who are looking to build applications (e.g. social network, ecommerce site) using MySQL

學習目標

• Create your own database or interact with existing databases
• Write complex SQL queries across multiple tables
• Build a web app using NodeJS and MySQL
• Model real-world data and generate reports using SQL
• Answer company performance or sales questions using data

課程介紹

How important is database management in the age of big data and analytics?

It is really important.   

How many employers would be happy to hire employees who can use data for the purposes of business intelligence?   

All of them.  

How many pe

…[更多細節]

哪些人適合這堂課？

• People interested in SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities
• Beginners to programming
• Everyone who wants to learn how to code and apply their skills in practice

學習目標

• Become an expert in SQL
• Learn how to code in SQL
• Boost your resume by learning an in-demand skill
• Create, design, and operate with SQL databases
• Start using MySQL – the #1 Database Management System
• Prepare for SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities
• Adopt professionally tested SQL best practices
• Gain theoretical insights about relational databases
• Work with a sophisticated real-life database throughout the course
• Get maximum preparation for real-life database management
• Add data analytical tools to your skillset
• Develop business intuition while solving tasks with big data
• Study relational database management theory that you will need in your workplace every day
• Learn how to create a database from scratch
• The ability to take control of your dataset – insert, update, and delete records from your database
• Be confident while working with constraints and relating data tables
• Become a proficient MySQL Workbench user
• Acquire top-notch coding techniques and best practices
• Know how to answer specific business questions by using SQL’s aggregate functions
• Handle complex SQL joins with ease
• Approach more advanced topics in programming like SQL’s triggers, sequences, local and global variables, indexes, and more
• Merge coding skills and business acumen to solve complex analytical problems
• Become a proficient SQL user by writing flawless and efficient queries
• Tons of exercises that will solidify your knowledge
• The freedom to query anything you like from a database

課程介紹

Have you heard that database skills are essential for developers to be skilled in and understand?

Are you wanting to understand SQL and databases in general, but don’t know where to start?

Maybe you have a pressing need to learn about Database Desi

…[更多細節]

哪些人適合這堂課？

• Anyone who wants to learn how to use SQL and MySQL.

學習目標

• Have a detailed knowledge and understanding of using MySQL, one of the most widely used databases in the world.
• Obtained a knowledge of SQL, and MySQL, allows students to apply for jobs in the IT sector.
• In-depth knowledge of database design will give students an edge over other applicants.

課程介紹

這門課程是「成為初級資料分析師」的其中一門課，在 6 小時的教學影片之中內容包含這些主題：

關於

起步走

基礎 SQL 資料庫查詢

SELECT FROM

WHERE

ORDER BY

進階 SQL 資料庫查詢

子查詢

GROUP BY

HAVING

JOIN

基礎 SQL 資料庫表格處理

SQL 資料庫與資料科學程式語言

Python

R

…[更多細節]

哪些人適合這堂課？

• 想要成為初級資料分析師（Junior Data Analyst）的學員

學習目標

• 解決惱人的問題
• 什麼是SQL
• SQL的重要性
• MySQL Workbench安裝與連線設定
• 哈囉世界
• SQL查詢
• SELECT FROM
• 使用函數
• WHERE
• ORDER BY
• 子查詢
• 一般函數
• 聚合函數
• GROUP BY
• HAVING
• UNION
• JOIN
• 簡介SQLite資料庫
• 前置作業
• 創建
• 更新
• 刪除
• 與Python連結
• 與R連結

課程介紹

只要你願意，可以在24小時內學完紮實的標準SQL語法

新增、修改、刪除、查詢

聚集函式 (Aggregate Functions)

合併 (Join)

分組統計 (Group by)

子查詢 (Subquery)

標準的SQL語法不僅可以用於PostgreSQL資料庫，亦可用於其他資料庫如：Oracle、MySQL、Microsoft SQL Server、IBM DB2等關聯式資料庫

除了SQL語法，還會說明資料庫重要觀念

交易管理 – ACID

為什麼採用關聯式設計？

何

…[更多細節]

哪些人適合這堂課？

• 學校老師怎麼教都聽不懂，需要能舉簡單例子來解說SQL語法的老師
• 利用資料庫來儲存並處理大量的資料，未來想成為資料庫管理師 (DBA)
• 正在撰寫的app需要連結資料庫，卻不熟悉SQL語法

學習目標

• 擁有正確的資料庫交易觀念，資料表的建立與正規化也會十分熟悉
• SQL語法變得清楚明暸，無論app連結資料庫或是資料處理都一把罩

課程介紹

非常容易！每介紹完一個概念之後馬上有小練習及參考答案，令你馬上動手實踐，馬上搞清楚。

這套教材曾用於培訓一個政府部門的IT團隊，令他們的SQL水平大幅提升，令開發工作如虎添翼，應用系統的效能大幅改善。

這套教材也曾讓一些非IT人學懂相當複雜的SQL，協助他們進入數據科學的殿堂。

…[更多細節]

哪些人適合這堂課？

• People who need to use SQL to access a database such as junior programmers or DB administrators

學習目標

• SQL

課程介紹

动态交互网站，实现交互利用用户输入拼接到SQL执行，输入不同导致返回结果不同。用户输入内容没有经过完美处理，而且构造SQL语句，直接将构造的SQL语句带入SQL语句中执行，导致SQL注入漏洞。

课程将从代码到SQL语句开始，讲解SQL注入原理，以及利用方式

…[更多細節]

哪些人適合這堂課？

• 对Web安全感兴趣的任何人

學習目標

• 从代码层面帮助你理解SQL注入原理与利用方式。

課程介紹

学习并掌握Oracle的高级查询，包括：组函数的使用、分组查询、多表查询、子查询等内容。让学员全面掌握Oracle数据库select语句高级查询功能，为后续继续学习奠定基础。 

==================课程大纲==================

一、Oracle数据库之高级查询课程概述
（*）课程概述

二、分组函数和分组数据
（*）分组函数的概念
（*）使用分组函数1
（*）使用分组函数2
（*）使用分组函数3
（*）使用Group by子句分组数据
（*）having子句的

…[更多細節]

哪些人適合這堂課？

• 已经掌握Oracle SQL基础，并想进一步学习Oracle SQL高级内容的学员

學習目標

• 分组函数和分组数据
• Oracle数据库的多表查询
• Oracle数据库的子查询

課程介紹

学习并掌握DML语句：insert、update和delete语句；并能够使用DDL管理常见的数据库对象：表、视图、序列、索引和同义词。

==========课程大纲===========

一、Oracle的insert、update和delete语句
（*）课程概述
（*）insert语句和update语句
（*）delete语句
（*）Oracle事务简介

二、创建和管理表
（*）使用create table语句创建表
（*）使用alter table语句修改表
（*）删除表和Ora

…[更多細節]

哪些人適合這堂課？

• 已经掌握查询SQL的数据库开发人员，运维人员和在校大学生。

學習目標

• DML语句
• DDL语句
• 数据库对象