课程详情
Do you want to learn about SQL but aren’t sure where to start? In this beginner-level course, instructor Julianne Thouin covers basic concepts of relational database design and explains how to write simple SELECT statements using joins and proper filtering. Julianne explains what SQL Server is and what it is used for. Next, she shows how tables in a relational database relate to one another through surrogate, primary, and foreign keys. Julianne teaches you how to tackle the most basic query possible. She explains how AND and OR logic applies to filtering queries on more than one data point, then discusses INNER joins and OUTER joins. Julianne covers how to use subqueries for filtering your results. She walks you through some commonly used examples of built-in functions. In conclusion, Julianne shows you how aggregate functions work using the GROUP BY and HAVING clauses. Practice what you learn with hands-on challenges!
您将获得的技能
获取证书，展示成果
分享学到的内容，成为理想行业的达人，获取证书，展示您在课程中所学的知识。
-
在领英档案中的“资格认证”版块下展示
-
下载或打印为 PDF，与他人分享
-
以图片形式在线分享，展现您的技能
了解讲师
学员评价
-
-
-
Clement Yao Deafeamekpor
Clement Yao Deafeamekpor
DATABASE ADMINI || DATA ANALYST || DATA ENTRY CLERK || BARTENDER || CASHIER || AWS CONSOLE || GOOGLE CLOUD CONSOLE || DATA ANNOTATION (CVAT)
内容
课程内容
- 边学边练 1 个练习文件
- 知识测验 4 个测验
- 随时随地学习 可在平板电脑和手机上访问
相似课程
下载课程
使用 iOS 或安卓版领英学习 APP，即可在移动设备上离线观看课程。