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

Featured Post

Machine Learning

Master machine learning fundamentals in four hands-on courses

About This Specialization This Specialization from leading researchers at the University of Washington introduces you to the exciting, high-demand field of Machine Learning. Through a series of practical case studies, you will gain applied experience in major areas of Machine Learning including Prediction, Classification, Clustering, and Information Retrieval. You will learn to analyze large and complex datasets, create systems that adapt and improve over time, and build intelligent applications that can make predictions from data. Created by: Industry Partners: 4 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

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

Big Data Hadoop Certification Training

Big Data Hadoop training will make you an expert in HDFS, MapReduce, Hbase, Hive, Pig, Yarn, Oozie, Flume and Sqoop using real-time use cases on Retail, Social Media, Aviation, Tourism, Finance domain. You will get Hadoop certification at the end of the course

About the Training
This Hadoop training is designed to make you a certified Big Data practitioner by providing you rich hands-on training on Hadoop ecosystem and best practices about HDFS, MapReduce, HBase, Hive, Pig, Oozie, Sqoop. This course is stepping stone to your Big Data journey and you will get the opportunity to work on a Big data Analytics project after selecting a data-set of your choice. You will get Hadoop certification after the project completion.

Training Objectives
The hadoop training is designed to help you become a top Hadoop developer. During this course, our expert instructors will train you to: Master the concepts of HDFS and MapReduce frameworkUnderstand Hadoop 2.x ArchitectureSetup Hadoop Cluster and write Co…

Hands-on Text Mining and Analytics by Yonsei University

About this course: This course provides an unique opportunity for you to learn key components of text mining and analytics aided by the real world datasets and the text mining toolkit written in Java. Hands-on experience in core text mining techniques including text preprocessing, sentiment analysis, and topic modeling help learners be trained to be a competent data scientists. Empowered by bringing lecture notes together with lab sessions based on the y-TextMiner toolkit developed for the class, learners will be able to develop interesting text mining applications.



LevelIntermediateLanguage English, Subtitles: Chinese (Simplified) How To PassPass all graded assignments to complete the course.
Syllabus

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

Deep Learning Specialization

Master Deep Learning, and Break into AI
About This Specialization If you want to break into AI, this Specialization will help you do so. Deep Learning is one of the most highly sought after skills in tech. We will help you become good at Deep Learning. In five courses, you will learn the foundations of Deep Learning, understand how to build neural networks, and learn how to lead successful machine learning projects. You will learn about Convolutional networks, RNNs, LSTM, Adam, Dropout, BatchNorm, Xavier/He initialization, and more. You will work on case studies from healthcare, autonomous driving, sign language reading, music generation, and natural language processing. You will master not only the theory, but also see how it is applied in industry. You will practice all these ideas in Python and in TensorFlow, which we will teach. You will also hear from many top leaders in Deep Learning, who will share with you their personal stories and give you career advice. AI is transforming m…

Launch Your Career in Data Science

A nine-course introduction to data science, developed and taught by leading professors.
About This Specialization Ask the right questions, manipulate data sets, and create visualizations to communicate results. This Specialization covers the concepts and tools you'll need throughout the entire data science pipeline, from asking the right kinds of questions to making inferences and publishing results. In the final Capstone Project, you’ll apply the skills learned by building a data product using real-world data. At completion, students will have a portfolio demonstrating their mastery of the material. Created by: Industry Partners: 10 courses Follow the suggested order or choose your own. Projects Designed to help you practice and apply the skills you learn.

Master of Computer Science in Data Science

A flexible and affordable degree from one of the top Computer Science programs in the world, focused on one of the hottest fields of the new millennium

Enroll in the Master of Computer Science in Data Science (MCS-DS) and gain access to the computational and statistical knowledge needed to turn big data into meaningful insights. Build expertise in four core areas of computer science—data visualization, machine learning, data mining, and cloud computing—while learning key skills in statistics and information science. This completely online degree is an affordable gateway to one of the most lucrative and fastest growing careers of the new millennium. The MCS-DS is offered by CS @ ILLINOIS, a U.S. News & World Report top five CS graduate program, in collaboration with the University’s Statistics Department and top-ranked iSchool. Join our alumni network of entrepreneurs, educators, and technical visionaries, who have revolutionized the way people communicate, shop, conduct business,…

Machine Learning

Master machine learning fundamentals in four hands-on courses

About This Specialization This Specialization from leading researchers at the University of Washington introduces you to the exciting, high-demand field of Machine Learning. Through a series of practical case studies, you will gain applied experience in major areas of Machine Learning including Prediction, Classification, Clustering, and Information Retrieval. You will learn to analyze large and complex datasets, create systems that adapt and improve over time, and build intelligent applications that can make predictions from data. Created by: Industry Partners: 4 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

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…

Программирование на Python

About this course: Python – простой, гибкий и невероятно популярный язык, который используется практически во всех областях современной разработки. С его помощью можно создавать веб-приложения, писать игры, заниматься анализом данных, автоматизировать задачи системного администрирования и многое другое. “Программирование на Python” читают разработчики, применяющие Python в проектах, которыми ежедневно пользуются миллионы людей. Курс покрывает все необходимые для ежедневной работы программиста темы, а также рассказывает про многие особенности языка, которые часто опускают при его изучении. В ходе курса вы изучите конструкции языка, типы и структуры данных, функции, научитесь применять объектно-ориентированное и функциональное программирование, узнаете про особенности реализации Python, научитесь писать асинхронный и многопоточный код. Помимо теории вас ждут практические задания, которые помогут проверить полученные знания и отточить навыки программирования на Python. После успешного о…

Front-End JavaScript Frameworks: Angular

About this course: This course concentrates mainly on Javascript based front-end frameworks, and in particular the Angular framework (Currently Ver. 4.x). This course will use Typescript for developing Angular application. Typescript features will be introduced in the context of Angular as part of the exercises. You will also get an introduction to the use of Angular Material and Angular Flex-Layout for responsive UI design. You will be introduced to various aspects of Angular including components, directives and services. You will learn about data binding, Angular router and its use for developing single-page applications. You will also learn about designing both template-driven forms and reactive forms. A quick introduction to Observables, reactive programming and RxJS in the context of Angular is included. You will then learn about Angular support for client-server communication and the use of REST API on the server side. You will use Restangular for communicating with a server sup…

Archive