We may earn an affiliate commission when you visit our partners.
吴 宁,
谢涛,
and
赵英良
在信息化社会，充分有效地管理和利用各类信息资源，是进行科学研究和决策管理的前提。数据库技术是有效地管理和利用各类信息资源的重要技术手段。通过本课程，你将获得数据库技术的基本知识，学会通过SQL Server数据库管理系统管理数据，包括安装数据库管理系统，创建数据库和数据表，插入数据和维护数据等，特别是可以使用SQL Server按各种条件查询需要的信息。
Register for this course and see more details by visiting:
OpenCourser.com/course/lnp76c/sql
What's inside
Syllabus
关系数据库和SQL Server使用入门
本讲内容包括：数据库的概念、发展和数据库模型；关系数据库的基本概念；SQL Server数据库管理系统的安装；创建数据库、数据表；插入数据；简单查询。
数据管理和基本查询
本周学习如何创建带主键的数据表、带外键的数据表以及有其他约束条件的数据表。学习数据表的修改、数据的修改，学习简单查询、按条件查询、使用特殊运算符查询、对查询结果排序等内容。通过本周的学习，你可以随心所欲地创建数据表，可以从数据库中查询到自己需要的数据。
Read more
Syllabus
关系数据库和SQL Server使用入门
本讲内容包括：数据库的概念、发展和数据库模型；关系数据库的基本概念；SQL Server数据库管理系统的安装；创建数据库、数据表；插入数据；简单查询。
数据管理和基本查询
本周学习如何创建带主键的数据表、带外键的数据表以及有其他约束条件的数据表。学习数据表的修改、数据的修改，学习简单查询、按条件查询、使用特殊运算符查询、对查询结果排序等内容。通过本周的学习，你可以随心所欲地创建数据表，可以从数据库中查询到自己需要的数据。
Read more
高级查询和数据库的安全
本周内容包括函数查询、分组查询、多表连接查询、子查询、视图的创建和应用，SQL Server安全的基本原则，通过C#连接和使用数据库等内容。
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
企业管理和科研工作者、信息管理和计算机应用人员、大数据管理与分析人员
通过SQL Server数据库管理系统管理数据，包括安装数据库管理系统，创建数据库和数据表，插入数据和维护数据等
建立数据库管理基础知识，为后续开展更加深层次的数据挖掘、数据分析和数据可视化等学习奠定基础
Save this course
Save SQL Server数据库技术 to your list so you can find it easily later:
Save
Save
Reviews summary
Sql server database practices
Students who have taken this course, SQL Server Database Practices, have given it a perfect score. Based on the single review, the most commonly mentioned feature is that the instructor provides clear explanations. One student mentioned that the instructor started off teaching more slowly and then sped up towards the end of the course. Overall, based on this review, this course is highly recommended.
The instructor provides clear explanations.
"前面绝大部分讲解非常详细而且通俗易懂。"
The instructor sped up the pace of the course at the end.
"老师后面讲的有点快，知识讲解较为粗略。"
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in SQL Server数据库技术 with these
activities:
整理学习资源
Show steps
将课程材料、笔记和练习题整理成一个易于访问的学习包，可以提高学习效率。
Show steps
-
下载课程讲义和教材
-
整理笔记并归档
-
收集练习题和在线资源
SQL Server 安装与使用指南
Show steps
回顾 SQL Server 的安装和使用基础知识，加深对数据库管理系统的理解。
Show steps
-
阅读 SQL Server 安装文档
-
下载并安装 SQL Server
-
使用 SQL Server Management Studio
编写 SQL 查询练习
Show steps
通过编写 SQL 查询来巩固对数据库查询语法和功能的掌握。
Show steps
-
熟悉 SQL 查询语法
-
练习编写简单查询
-
解决更复杂的查询问题
Four other activities
Expand to see all activities and additional details
Show all seven activities
寻求导师指导
Show steps
与经验丰富的导师建立联系，可以获得宝贵的指导和建议，从而加速学习进程。
Show steps
-
在行业内建立人脉
-
参加会议或在线社区
-
主动与潜在导师联系
数据库设计项目
Show steps
应用所学知识设计和创建自己的数据库，加深对数据库设计和管理的理解。
Show steps
-
确定项目需求
-
设计数据库架构
-
创建数据库和表
-
插入和查询数据
探索高级数据库技术
Show steps
深入了解高级数据库技术，如事务处理、并发性和分布式数据库，可以扩展你的知识和技能。
Show steps
-
查找在线课程或教程，如 Coursera 或 edX
-
参加网络研讨会或观看行业专家演讲
-
阅读技术白皮书和文章
参与开源项目
Show steps
通过参与开源项目，可以接触到实际的数据库应用，并获得与其他开发人员协作的宝贵经验。
Show steps
-
选择一个与本课程相关的开源项目
-
熟悉项目文档和代码库
-
提出问题或编写代码补丁
-
协作解决问题并完善项目
整理学习资源
Show steps
将课程材料、笔记和练习题整理成一个易于访问的学习包，可以提高学习效率。
Show steps
Show steps
Show steps
- 下载课程讲义和教材
- 整理笔记并归档
- 收集练习题和在线资源
SQL Server 安装与使用指南
Show steps
回顾 SQL Server 的安装和使用基础知识，加深对数据库管理系统的理解。
Show steps
Show steps
Show steps
- 阅读 SQL Server 安装文档
- 下载并安装 SQL Server
- 使用 SQL Server Management Studio
编写 SQL 查询练习
Show steps
通过编写 SQL 查询来巩固对数据库查询语法和功能的掌握。
Show steps
Show steps
Show steps
- 熟悉 SQL 查询语法
- 练习编写简单查询
- 解决更复杂的查询问题
Four other activities
Expand to see all activities and additional details
Show all seven activities
寻求导师指导
Show steps
与经验丰富的导师建立联系，可以获得宝贵的指导和建议，从而加速学习进程。
Show steps
Show steps
Show steps
- 在行业内建立人脉
- 参加会议或在线社区
- 主动与潜在导师联系
数据库设计项目
Show steps
应用所学知识设计和创建自己的数据库，加深对数据库设计和管理的理解。
Show steps
Show steps
Show steps
- 确定项目需求
- 设计数据库架构
- 创建数据库和表
- 插入和查询数据
探索高级数据库技术
Show steps
深入了解高级数据库技术，如事务处理、并发性和分布式数据库，可以扩展你的知识和技能。
Show steps
Show steps
Show steps
- 查找在线课程或教程，如 Coursera 或 edX
- 参加网络研讨会或观看行业专家演讲
- 阅读技术白皮书和文章
参与开源项目
Show steps
通过参与开源项目，可以接触到实际的数据库应用，并获得与其他开发人员协作的宝贵经验。
Show steps
Show steps
Show steps
- 选择一个与本课程相关的开源项目
- 熟悉项目文档和代码库
- 提出问题或编写代码补丁
- 协作解决问题并完善项目
Career center
Learners who complete SQL Server数据库技术 will develop knowledge and skills
that may be useful to these careers:
Data Analyst
Data Analyst
Data Analysts collect, clean, and analyze data to help businesses make informed decisions. This course can help you develop the skills you need to become a Data Analyst by providing you with a foundation in SQL Server, a powerful database management system. You will learn how to use SQL Server to query and analyze data, and you will gain experience with data visualization tools. These skills are in high demand in the job market, and they can help you launch a successful career as a Data Analyst.
Database Architect
Database Architect
Database Architects design and develop database architectures. This course can help you develop the skills you need to become a Database Architect by providing you with a foundation in SQL Server, a popular database management system. You will learn how to use SQL Server to design and develop database architectures, and you will gain experience with data modeling and database design. These skills are essential for Database Architects, who need to be able to design and develop database architectures that are efficient and scalable.
Database Developer
Database Developer
Database Developers design and develop databases. This course can help you develop the skills you need to become a Database Developer by providing you with a foundation in SQL Server, a popular database management system. You will learn how to use SQL Server to create and manage databases, and you will gain experience with data modeling and database design. These skills are essential for Database Developers, who need to be able to design and develop databases that meet the needs of their users.
Data Scientist
Data Scientist
Data Scientists use data to solve business problems and develop new products and services. This course can help you prepare for a career as a Data Scientist by providing you with a foundation in SQL Server, a popular database management system. You will learn how to use SQL Server to query and analyze data, and you will gain experience with data visualization tools. These skills are essential for Data Scientists, who need to be able to work with large datasets and extract meaningful insights from them. This course may also be helpful for those who wish to pursue a career in machine learning or artificial intelligence.
Database Administrator
Database Administrator
Database Administrators build data architecture and ensure that databases are operating efficiently. This course can help prepare you for a career as a Database Administrator by developing your knowledge of SQL Server, a popular database management system. You will learn how to install and configure SQL Server, create and manage databases, and write queries to retrieve data. These skills are essential for Database Administrators, who are responsible for the day-to-day operation and maintenance of databases. This course may also be helpful for those who wish to pursue a career in data analysis or data science.
Data Engineer
Data Engineer
Data Engineers design, build, and maintain data pipelines. This course can help you develop the skills you need to become a Data Engineer by providing you with a foundation in SQL Server, a popular database management system. You will learn how to use SQL Server to extract, transform, and load data, and you will gain experience with data modeling and database design. These skills are essential for Data Engineers, who need to be able to build and maintain the data pipelines that power data-driven businesses.
ETL Developer
ETL Developer
ETL Developers design and develop data pipelines that extract, transform, and load data. This course can help you develop the skills you need to become an ETL Developer by providing you with a foundation in SQL Server, a popular database management system. You will learn how to use SQL Server to extract, transform, and load data, and you will gain experience with data modeling and database design. These skills are essential for ETL Developers, who need to be able to design and develop data pipelines that are efficient and reliable.
Enterprise Architect
Enterprise Architect
Enterprise Architects design and develop enterprise architectures. This course can help you develop the skills you need to become an Enterprise Architect by providing you with a foundation in SQL Server, a popular database management system. You will learn how to use SQL Server to design and develop enterprise architectures, and you will gain experience with data modeling and database design. These skills are essential for Enterprise Architects, who need to be able to design and develop enterprise architectures that are efficient and scalable.
Data Warehouse Developer
Data Warehouse Developer
Data Warehouse Developers design and develop data warehouses. This course can help you develop the skills you need to become a Data Warehouse Developer by providing you with a foundation in SQL Server, a popular database management system. You will learn how to use SQL Server to design and develop data warehouses, and you will gain experience with data modeling and database design. These skills are essential for Data Warehouse Developers, who need to be able to design and develop data warehouses that are efficient and scalable.
Data Integration Developer
Data Integration Developer
Data Integration Developers design and develop data integration solutions. This course can help you develop the skills you need to become a Data Integration Developer by providing you with a foundation in SQL Server, a popular database management system. You will learn how to use SQL Server to design and develop data integration solutions, and you will gain experience with data modeling and database design. These skills are essential for Data Integration Developers, who need to be able to design and develop data integration solutions that are efficient and reliable.
Information Architect
Information Architect
Information Architects design and organize information systems. This course can help you develop the skills you need to become an Information Architect by providing you with a foundation in SQL Server, a popular database management system. You will learn how to use SQL Server to store and retrieve data, and you will gain experience with data modeling and database design. These skills are essential for Information Architects, who need to be able to design and organize information systems that are efficient and easy to use.
Systems Analyst
Systems Analyst
Systems Analysts design and implement computer systems. This course can help you develop the skills you need to become a Systems Analyst by providing you with a foundation in SQL Server, a popular database management system. You will learn how to use SQL Server to store and retrieve data, and you will gain experience with data modeling and database design. These skills are essential for Systems Analysts, who need to be able to design and implement computer systems that meet the needs of their users.
Software Engineer
Software Engineer
Software Engineers design, develop, and maintain software applications. This course can help you develop the skills you need to become a Software Engineer by providing you with a foundation in SQL Server, a popular database management system. You will learn how to use SQL Server to store and retrieve data, and you will gain experience with data modeling and database design. These skills are essential for Software Engineers, who need to be able to work with databases to build and maintain software applications.
Web Developer
Web Developer
Web Developers design and develop websites. This course can help you develop the skills you need to become a Web Developer by providing you with a foundation in SQL Server, a popular database management system. You will learn how to use SQL Server to store and retrieve data, and you will gain experience with data modeling and database design. These skills are essential for Web Developers, who need to be able to design and develop websites that are efficient and easy to use.
Business Analyst
Business Analyst
Business Analysts help businesses understand their data and make better decisions. This course can help you develop the skills you need to become a Business Analyst by providing you with a foundation in SQL Server, a popular database management system. You will learn how to use SQL Server to query and analyze data, and you will gain experience with data visualization tools. These skills are essential for Business Analysts, who need to be able to communicate data insights to stakeholders in a clear and concise way.
For more career information including salaries, visit:
OpenCourser.com/course/lnp76c/sql
Reading list
We've selected eight books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
SQL Server数据库技术.
Save
Provides a comprehensive guide to SQL Server's Transact-SQL programming language, covering topics such as data manipulation, error handling, and performance optimization.
Save
本书从理论与实践相结合的角度，介绍了SQL Server数据库设计与建模的最佳实践，帮助读者设计出高性能、高可用、易维护的数据库。
Provides practical advice on how to tune SQL Server databases for optimal performance.
Provides a detailed explanation of SQL Server's execution plans, helping readers optimize their queries for better performance.
本书是数据库领域的经典教科书，对数据库管理系统的基本概念、数据模型、数据库设计、查询处理、事务管理和数据库安全性等内容进行了全面的讲解。
本书详细介绍了SQL Server数据库管理与维护的各种操作，包括数据库安装、配置、监控、优化、故障排除等方面，帮助读者掌握数据库管理的最佳实践。
Provides a comprehensive guide to SQL Server security, covering topics such as authentication, authorization, and auditing.
Covers best practices for ensuring high availability and disaster recovery in SQL Server environments.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/lnp76c/sql
Share
Similar courses
Here are nine courses similar to
SQL Server数据库技术.
生物信息学: 导论与方法
OpenCourser.com/course/uzvcci/Sheng
生物信息学: 导论与方法
Most relevant
计算机操作系统
OpenCourser.com/course/3vw5o7/Ji
计算机操作系统
Most relevant
离散数学概论 Discrete Mathematics Generality
OpenCourser.com/course/w12rjn/Chi
离散数学概论 Discrete Mathematics Generality
Most relevant
基于.Net的Web开发技术
OpenCourser.com/course/jyz12a/Ji
基于.Net的Web开发技术
Most relevant
C#程序设计
OpenCourser.com/course/8robhm/c
C#程序设计
Most relevant
Business Transformation with Google Cloud 中文
OpenCourser.com/course/q5gyvw/business
Business Transformation with Google Cloud 中文
Most relevant
系统平台与计算环境
OpenCourser.com/course/0shsf4/Xi
系统平台与计算环境
Most relevant
论文写作初阶（Academic Writing and Research）
OpenCourser.com/course/j3ebd0/Lun
论文写作初阶（Academic Writing and Research）
Most relevant
财务会计概论（中文版）
OpenCourser.com/course/kez4gu/Cai
财务会计概论（中文版）
Most relevant
Effort
3 周课程, 2-4 小时/周
Level
Introductory
Via
Coursera
Institution
Xi'an Jiaotong University
Instructors
吴 宁
谢涛
赵英良
Language
中文
This course belongs to a
collection
called
.Net平台下的软件开发技术. It's comprised of six courses:
- .Net平台下的软件开发技术毕业项目
- c#高级编程
- 系统平台与C#程序基础
- 基于.Net的Web开发技术
- SQL Server数据库技术 (viewing)
- Windows可视化程序设计
Good to know
企业管理和科研工作者、信息管理和计算机应用人员、大数据管理与分析人员
通过SQL Server数据库管理系统管理数据，包括安装数据库管理系统，创建数据库和数据表，插入数据和维护数据等
建立数据库管理基础知识，为后续开展更加深层次的数据挖掘、数据分析和数据可视化等学习奠定基础
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser