BI Data Analysts use Python and SQL to query, analyze, and visualize data — and Tableau and Excel to communicate findings. Includes18Courses WithCertificate BeginnerFriendly 50hours Career path Data Scientist: Inference Specialist Inference Data Scientists run A/B tests, do root-cause analysis, and...
and a.s_score<=90 then 1 else 0 end)/SUM(case when a.s_score then 1 else 0 end)),2) as 优良率, ROUND(100*(SUM(case when a.s_score>=90 then 1 else 0 end)/SUM(case when a.s_score then 1 else 0 end)),2) as 优秀率 from score a left join course b on a.c_id =...
create table course2 ( cid int(4) , cname varchar(20) ); # 插入数据 insert into course2 values(1,'java'); insert into course2 values(2,'python'); insert into course2 values(3,'kotlin'); 案例:使用一个左连接,查找教java课程的所有信息。 explain select * from teacher2 t left outer ...
Improve your skills in SQL, Office, Tableau, Power BI + more学生总数 869,983 审核 141,610 关于我 I Do Data is dedicated to creating video courses on Udemy in a variety of computer-related topics, such as SQL in its different dialects and Microsoft Office. Are you wanting to learn a ne...
Tableau 数据可视化平台 业务基础 数据收集 数据是如何收集到的? ETL工程 怎么清洗、处理和转化数据? 数据仓库基础 如何完成面向分析的数据建模? 元数据中心 如何做好数据治理? 分析思维 数据分析思维方法论 怎么去分析一个具体问题? 排查问题思维 如何高效排查数据问题? 指标体系 怎么让数据成体系化? 由于介绍的是基...
Offering boot camp, workshops, and corporate training to help you exceed to the next level. Microsoft Excel Power BI + TABLEAU SQL Clients We Have Worked With Subscribe to receive our latest updates Add your name and email address to stay connected. ...
create table course( cno varchar(10), #课程号 cname varchar(20), #课程名 tno varchar(20), #教师号 constraint pk_course primary key (cno,tno) ); #分数表 create table sc( sno varchar(10), #学号 cno varchar(10), #课程号 score DECIMAL(4,2), #分数 ...
TABLEAU TOP 50 INTERVIEW QUESTIONS 2023 总共1.5 小时更新日期 2022年12月 评分:4.3,满分 5 分4.31,257 加载价格时发生错误 显示更多 常见购买搭配 SQL Ultimate Course: from Zero to Hero Unique SQL course - covers everything you need to MASTER SQL and understand how things work behind the scenes in...
create table course( cno varchar(10), #课程号 cname varchar(20), #课程名 tno varchar(20), #教师号 constraint pk_course primary key (cno,tno) ); #分数表 create table sc( sno varchar(10), #学号 cno varchar(10), #课程号 score DECIMAL(4,2), #分数 ...
Introduction to Geographical Time Series Prediction with Crime Data in R, SQL, and Tableau - Feb 14, 2020.When reviewing geographical data, it can be difficult to prepare the data for an analysis. This article helps by covering importing data into a SQL Server database; cleansing and grouping...