SQL Server数据库技术

Product type
Logo Coursera (CC)
Provider rating: starstarstarstar_halfstar_border 7.2 Coursera (CC) has an average rating of 7.2 (out of 6 reviews)

Need more information? Get more details on the site of the provider.

Description

When you enroll for courses through Coursera you get to choose for a paid plan or for a free plan

  • Free plan: No certicification and/or audit only. You will have access to all course materials except graded items.
  • Paid plan: Commit to earning a Certificate—it's a trusted, shareable way to showcase your new skills.

About this course: 在信息化社会,充分有效地管理和利用各类信息资源,是进行科学研究和决策管理的前提。数据库技术是有效地管理和利用各类信息资源的重要技术手段。通过本课程,你将获得数据库技术的基本知识,学会通过SQL Server数据库管理系统管理数据,包括安装数据库管理系统,创建数据库和数据表,插入数据和维护数据等,特别是可以使用SQL Server按各种条件查询需要的信息。

Who is this class for: 本课程面向需要快速了解数据库基本知识和需要快速掌握SQL Server基本操作方法的各类人员,特别是初学者。

Created by:   Xi'an Jiaotong University
  • Taught by:    吴 宁, 教授

    西安交通大学电信学院计算机教学实验中心
  • Taught by:    谢涛, 讲师

  • Taught by:    赵英良, 教授

    西安交通大学
Basic Info Course 4 of 6 in the .Net平台下的软件开发技术 Specialization. Level Beginner Commitment 3 周课程, 2-4 小时/周 Language Chinese (Simplified) How To Pass Pass all graded assignments to complete the course. User Ratings 4.7 stars Averag…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Microsoft SQL Server, PL/SQL, Microsoft ProClarity, Client - Server, and Oracle.

When you enroll for courses through Coursera you get to choose for a paid plan or for a free plan

  • Free plan: No certicification and/or audit only. You will have access to all course materials except graded items.
  • Paid plan: Commit to earning a Certificate—it's a trusted, shareable way to showcase your new skills.

About this course: 在信息化社会,充分有效地管理和利用各类信息资源,是进行科学研究和决策管理的前提。数据库技术是有效地管理和利用各类信息资源的重要技术手段。通过本课程,你将获得数据库技术的基本知识,学会通过SQL Server数据库管理系统管理数据,包括安装数据库管理系统,创建数据库和数据表,插入数据和维护数据等,特别是可以使用SQL Server按各种条件查询需要的信息。

Who is this class for: 本课程面向需要快速了解数据库基本知识和需要快速掌握SQL Server基本操作方法的各类人员,特别是初学者。

Created by:   Xi'an Jiaotong University
  • Taught by:    吴 宁, 教授

    西安交通大学电信学院计算机教学实验中心
  • Taught by:    谢涛, 讲师

  • Taught by:    赵英良, 教授

    西安交通大学
Basic Info Course 4 of 6 in the .Net平台下的软件开发技术 Specialization. Level Beginner Commitment 3 周课程, 2-4 小时/周 Language Chinese (Simplified) How To Pass Pass all graded assignments to complete the course. User Ratings 4.7 stars Average User Rating 4.7See all reviews Course 4 of Specialization 面向对象程序设计、数据库编程、Windows编程、Web应用开发。. 具备.Net应用程序和Web应用程序设计能力。如:电子商务网站、社交网站、信息管理系统等。 .Net平台下的软件开发技术 Xi'an Jiaotong University Learn More Coursework

Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.

Help from your peers

Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.

Certificates

Earn official recognition for your work, and share your success with friends, colleagues, and employers.

About Xi'an Jiaotong University Xi'an Jiaotong University is one of the oldest institutions of higher learning in China. Founded in Shanghai in 1896 as Nanyang Public, it was renamed Jiaotong University in 1921. In 1956, at the direction of the State Council, the university was moved to Xi’an, an important historical city, and renamed Xi'an Jiaotong University (XJTU). Now, XJTU is a comprehensive research university offering programs in ten areas—science, engineering, medicine, economics, management, humanities, art, law, philosophy and education. XJTU features 26 schools, 8 undergraduate residential colleges, 12 teaching hospitals, and serves about 30,000 full-time students, including over 14,600 graduate students.

Syllabus


WEEK 1


关系数据库和SQL Server使用入门
本讲内容包括:数据库的概念、发展和数据库模型;关系数据库的基本概念;SQL Server数据库管理系统的安装;创建数据库、数据表;插入数据;简单查询。 


7 videos expand
Graded: 第1周知识作业

WEEK 2


数据管理和基本查询
本周学习如何创建带主键的数据表、带外键的数据表以及有其他约束条件的数据表。学习数据表的修改、数据的修改,学习简单查询、按条件查询、使用特殊运算符查询、对查询结果排序等内容。通过本周的学习,你可以随心所欲地创建数据表,可以从数据库中查询到自己需要的数据。 


9 videos expand
Graded: 第2周知识作业

WEEK 3


高级查询和数据库的安全
本周内容包括函数查询、分组查询、多表连接查询、子查询、视图的创建和应用,SQL Server安全的基本原则,通过C#连接和使用数据库等内容。 


8 videos, 1 reading expand
Graded: 第3周知识作业
There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.