智警杯excel和sql实训盲点

目录

excel基础操作：

excel函数：智警杯赛前学习1.2--excel统计函数_lulu001128的博客-优快云博客知识点https://blog.youkuaiyun.com/lulu001128/article/details/130936259?spm=1001.2014.3001.5501

excel报表实战：

excel数据透视及绘图：

SQL简单查询

进入数据库

 支持中文字符

 创建数据库

创建数据表

SQL复杂查询

SQL多表查询

---

excel基础操作：

智警杯赛前学习1.1---excel基本操作_lulu001128的博客-优快云博客知识点https://blog.youkuaiyun.com/lulu001128/article/details/130934089?spm=1001.2014.3001.5502

excel函数：

智警杯赛前学习1.2--excel统计函数_lulu001128的博客-优快云博客知识点https://blog.youkuaiyun.com/lulu001128/article/details/130936259?spm=1001.2014.3001.5501

excel报表实战：

智警杯赛前学习1.3——excel报表开发_lulu001128的博客-优快云博客知识点https://blog.youkuaiyun.com/lulu001128/article/details/130954974?spm=1001.2014.3001.5502

excel数据透视及绘图：

智警杯1.4---excel可视化_lulu001128的博客-优快云博客知识点https://blog.youkuaiyun.com/lulu001128/article/details/130955860?spm=1001.2014.3001.5501

SQL简单查询

进入数据库

mysql -uroot -p123456

 支持中文字符

  Set character_set_database='utf8';

  Set character_set_server='utf8';

 

 创建数据库

 create database demo;

 use demo;

创建数据表

create table score(

id int primary key,

class int,

name varchar(255),

chinese double,

math double,

english double

);

 智警杯赛前学习2.2--SQL简单查询_lulu001128的博客-优快云博客知识点https://blog.youkuaiyun.com/lulu001128/article/details/130992587?csdn_share_tail=%7B%22type%22%3A%22blog%22%2C%22rType%22%3A%22article%22%2C%22rId%22%3A%22130992587%22%2C%22source%22%3A%22lulu001128%22%7D

SQL复杂查询

智警杯赛前学习2.3 -- SQL复杂查询_lulu001128的博客-优快云博客知识点https://blog.youkuaiyun.com/lulu001128/article/details/131053947?spm=1001.2014.3001.5501

SQL多表查询

智警杯赛前准备2.4--SQL多表查询_lulu001128的博客-优快云博客知识点https://blog.youkuaiyun.com/lulu001128/article/details/131054807?csdn_share_tail=%7B%22type%22%3A%22blog%22%2C%22rType%22%3A%22article%22%2C%22rId%22%3A%22131054807%22%2C%22source%22%3A%22lulu001128%22%7D