Online Courses and Tutorials

Onlinecourses.tech provides you with the latest online courses information by assisting over 45,000 courses and 1 million students.

Learn programming, marketing, data science and more.

Get started today

Skip to main content

Data Analysis and Interpretation

About This Specialization Learn SAS or Python programming, expand your knowledge of analytical methods and applications, and conduct original research to inform complex decisions. The Data Analysis and Interpretation Specialization takes you from data novice to data expert in just four project-based courses. You will apply basic data science tools, including data management and visualization, modeling, and machine learning using your choice of either SAS or Python, including pandas and Scikit-learn. Throughout the Specialization, you will analyze a research question of your choice and summarize your insights. In the Capstone Project, you will use real data to address an important issue in society, and report your findings in a professional-quality report. You will have the opportunity to work with our industry partners, DRIVENDATA and The Connection. Help DRIVENDATA solve some of the world's biggest social challenges by joining one of their competitions, or help The Connection be…

SQL Server数据库技术

SQL Server数据库技术

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
LevelBeginner
Commitment3 周课程, 2-4 小时/周
Language
Chinese (Simplified)
How To PassPass all graded assignments to complete the course.
User Ratings
Average User Rating 4.7See what learners said
Syllabus
WEEK 1
关系数据库和SQL Server使用入门
本讲内容包括:数据库的概念、发展和数据库模型;关系数据库的基本概念;SQL Server数据库管理系统的安装;创建数据库、数据表;插入数据;简单查询。 

7 videos
  1. Video: 数据库的概念和发展
  2. Video: 关系数据库的基本概念
  3. Video: 数据库设计——实体关系图
  4. Video: 数据库设计——数据表设计
  5. Video: 常见数据库管理系统和SQL Server的安装
  6. Video: SQL Server启动服务和企业管理器
  7. Video: SQL和数据库数据表的创建
Graded: 第1周知识作业
Graded: SQL Server的安装和使用
WEEK 2
数据管理和基本查询
本周学习如何创建带主键的数据表、带外键的数据表以及有其他约束条件的数据表。学习数据表的修改、数据的修改,学习简单查询、按条件查询、使用特殊运算符查询、对查询结果排序等内容。通过本周的学习,你可以随心所欲地创建数据表,可以从数据库中查询到自己需要的数据。 

9 videos
  1. Video: 创建带主键和约束的数据表
  2. Video: 数据表的修改
  3. Video: 使用可视化的方式修改表
  4. Video: 数据的修改
  5. Video: 成批导入导出数据
  6. Video: 简单查询
  7. Video: 按条件查询
  8. Video: 使用特殊关系运算符查询
  9. Video: 对查询结果排序
Graded: 第2周知识作业
Graded: 基本查询练习
WEEK 3
高级查询和数据库的安全
本周内容包括函数查询、分组查询、多表连接查询、子查询、视图的创建和应用,SQL Server安全的基本原则,通过C#连接和使用数据库等内容。 

8 videos1 reading
  1. Video: 函数查询
  2. Video: 分组查询
  3. Video: 多表查询
  4. Video: 子查询
  5. Video: 视图
  6. Video: 用户管理
  7. Video: SQL Server数据库安全
  8. Video: 使用C#连接和使用数据库
  9. Reading: 使用SqlDataSet读取数据
Graded: 第3周知识作业
Graded: 高级查询练习
How It Works
Coursework
Coursework
Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.
Help from Your Peers
Help from Your Peers
Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.
Certificates
Certificates
Earn official recognition for your work, and share your success with friends, colleagues, and employers.
Creators
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.

Comments

Popular posts from this blog

An Introduction to Interactive Programming in Python (Part 1)

About this course: This two-part course is designed to help students with very little or no computing background learn the basics of building simple interactive applications. Our language of choice, Python, is an easy-to learn, high-level computer language that is used in many of the computational courses offered on Coursera. To make learning Python easy, we have developed a new browser-based programming environment that makes developing interactive applications in Python simple. These applications will involve windows whose contents are graphical and respond to buttons, the keyboard and the mouse. In part 1 of this course, we will introduce the basic elements of programming (such as expressions, conditionals, and functions) and then use these elements to create simple interactive applications such as a digital stopwatch. Part 1 of this class will culminate in building a version of the classic arcade game "Pong".
Who is this class for: Recommended Background - A knowledge o…

Introduction to Data Science in Python

About this course: This course will introduce the learner to the basics of the python programming environment, including how to download and install python, expected fundamental python programming techniques, and how to find help with python programming questions. The course will also introduce data manipulation and cleaning techniques using the popular python pandas data science library and introduce the abstraction of the DataFrame as the central data structure for data analysis. The course will end with a statistics primer, showing how various statistical measures can be applied to pandas DataFrames. By the end of the course, students will be able to take tabular data, clean it,  manipulate it, and run basic inferential statistical analyses. This course should be taken before any of the other Applied Data Science with Python courses: Applied Plotting, Charting & Data Representation in Python, Applied Machine Learning in Python, Applied Text Mining in Python, Applied Social Ne…

Learn to Program and Analyze Data with Python

About This Specialization This Specialization builds on the success of the Python for Everybody course and will introduce fundamental programming concepts including data structures, networked application program interfaces, and databases, using the Python programming language. In the Capstone Project, you’ll use the technologies learned throughout the Specialization to design and create your own applications for data retrieval, processing, and visualization. Created by: 5 courses Follow the suggested order or choose your own. Projects Designed to help you practice and apply the skills you learn. Certificates Highlight your new skills on your resume or LinkedIn. Courses

Archive