Catherine_zhilin

  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

随笔分类 -  数据库--SQL

摘要:1.官网下载 2.下面参考: 第一次安装MYSQL,网上查找了半天才解决可以正常使用,浪费了很多时间现在重新整理一下,比较粗糙,供大家参考。操作系统是window7 ,64位。 step1.官网下载对应版本压缩包直接解压即可(网上很多下载教程) step2.注册MYSQL服务(刚开始没注册服务,直接 阅读全文
posted @ 2018-08-23 19:32 kkkshiki 阅读(122) 评论(0) 推荐(0)

摘要:subtype:子类型; supertype:超类型; RDBMS (Relational Database Management System) 阅读全文
posted @ 2017-12-11 13:42 kkkshiki 阅读(156) 评论(0) 推荐(0)

摘要:Objectives:1.Monitor performance 2.Optimize performance 阅读全文
posted @ 2017-12-04 23:35 kkkshiki 阅读(133) 评论(0) 推荐(0)

摘要:Objectives:1.Implement triggers 2.Implement transactions 阅读全文
posted @ 2017-12-04 23:33 kkkshiki 阅读(139) 评论(0) 推荐(0)

摘要:Objectives:1.Implement batches 2.Implement stored procedures 3.Implement functions 阅读全文
posted @ 2017-12-04 23:31 kkkshiki 阅读(172) 评论(0) 推荐(0)

摘要:Objective:1.Create and manage indexs 2.Create and manage views 3.Implement a full-text search 阅读全文
posted @ 2017-12-04 23:27 kkkshiki 阅读(110) 评论(0) 推荐(0)

摘要:Objectives 1.Manipulate data by using DML satesments 2.Manipulate XML data 阅读全文
posted @ 2017-12-04 23:25 kkkshiki 阅读(131) 评论(0) 推荐(0)

摘要:Objectivs:1.Manage databases 2.Manage tables 阅读全文
posted @ 2017-12-04 23:21 kkkshiki 阅读(126) 评论(0) 推荐(0)

摘要:Objectives:1.Query data by using joins 2.Query data by using subqueries 3.Manage result sets 阅读全文
posted @ 2017-12-04 23:20 kkkshiki 阅读(129) 评论(0) 推荐(0)

摘要:Objectives:1.Retrieve data 2.Use function to customize the result set 3.Summarize and group data 阅读全文
posted @ 2017-12-04 23:17 kkkshiki 阅读(166) 评论(0) 推荐(0)

摘要:1.Which one of the following components of SQL Server allows you to create and manage database objects? Database engine 2.Which one of the following f 阅读全文
posted @ 2017-12-03 16:51 kkkshiki 阅读(243) 评论(0) 推荐(0)

摘要:Objectives:1.Appreciate SQL Server as a database server 2.Identify the SQL Server tools Instance: 1.Default Instance 2.Named Instance 1.Database Engin 阅读全文
posted @ 2017-12-03 16:11 kkkshiki 阅读(135) 评论(0) 推荐(0)

只有注册用户登录后才能阅读该文。
posted @ 2017-12-03 16:00 kkkshiki 阅读(1) 评论(0) 推荐(0)