SQL 初学者 - 学习与数据库通信

上次更新时间：2024-11-27

课程售价: 2.9 元

联系右侧微信客服充值或购买课程

课程内容

01 - Setup Database and MySQL Workbench

001 Introduction (免费)
002 What is SQL (免费)
003 What is MySQL
004 Download and Install MySQL (Windows)
005 MySQL Installation ( Macs )
006 What is MySQL Workbench
007 Installing MySQL Workbench on Macs
008 Basic Database Concepts
009 What is a Schema
010 Setting up default database in MySQL
011 Showing existing database
012 Showing existing tables
013 Create your first database
014 Create your first table
015 Basic MySQL Commands

02 - Data Manipulation

001 Create a database
002 SQL CREATE TABLE Statement
003 SQL INSERT Statement
004 SQL UPDATE Statement
005 SQL DELETE Statement
006 Primary Key
007 Foreign Key

03 - SQL Queries

001 What is an SQL Statement Query
002 SQL WHERE clause
003 SQL SELECT Statement
004 Removing duplicates with SQL DISTINCT
005 Sorting Data with ORDER BY clause
006 Grouping data with GROUP BY clause
007 SQL HAVING clause
008 SQL Subqueries
009 Nested subquery

04 - SQL Operators

001 BETWEEN Operator in SQL
002 LIKE Operator in SQL
003 LIMIT Clause in SQL
004 IN Operator in SQL
005 SQL UNION Operator

05 - Joining Data From Multiple Tables

001 INNER Join
002 LEFT JOIN
003 RIGHT JOIN
004 SELF JOIN

06 - Aggregate Functions

001 What are Aggregate Functions
002 AVG Aggregate Function
003 COUNT Aggregate Functions
004 MAX Aggregate Functions
005 MIN Aggregate Functions
006 SUM Aggregate Functions

网站首页 > 编程开发 > 其他

SQL 初学者 - 学习与数据库通信

SQL For Beginners - Learn to communicate with databases

上次更新时间：2024-11-27 19:15

课程售价：2.9元

联系客服微信，购买课程或充值

请登录网站 , 没有账号点击这里注册

课程内容

6个章节 , 46个讲座

01 - Setup Database and MySQL Workbench

001 Introduction (免费)
002 What is SQL (免费)
003 What is MySQL
004 Download and Install MySQL (Windows)
005 MySQL Installation ( Macs )
006 What is MySQL Workbench
007 Installing MySQL Workbench on Macs
008 Basic Database Concepts
009 What is a Schema
010 Setting up default database in MySQL
011 Showing existing database
012 Showing existing tables
013 Create your first database
014 Create your first table
015 Basic MySQL Commands

02 - Data Manipulation

001 Create a database
002 SQL CREATE TABLE Statement
003 SQL INSERT Statement
004 SQL UPDATE Statement
005 SQL DELETE Statement
006 Primary Key
007 Foreign Key

03 - SQL Queries

001 What is an SQL Statement Query
002 SQL WHERE clause
003 SQL SELECT Statement
004 Removing duplicates with SQL DISTINCT
005 Sorting Data with ORDER BY clause
006 Grouping data with GROUP BY clause
007 SQL HAVING clause
008 SQL Subqueries
009 Nested subquery

04 - SQL Operators

001 BETWEEN Operator in SQL
002 LIKE Operator in SQL
003 LIMIT Clause in SQL
004 IN Operator in SQL
005 SQL UNION Operator

05 - Joining Data From Multiple Tables

001 INNER Join
002 LEFT JOIN
003 RIGHT JOIN
004 SELF JOIN

06 - Aggregate Functions

001 What are Aggregate Functions
002 AVG Aggregate Function
003 COUNT Aggregate Functions
004 MAX Aggregate Functions
005 MIN Aggregate Functions
006 SUM Aggregate Functions