数据库的学习| 耗时:0.308秒|447215条结果

极好数据库学习资料

http://www.itnose.net/detail/6494752.html 2016-04-27 10:25   [其它]

关于数据库学习

最近想写一个简易bbs小项目玩,但是数据库方面知识没学过,感觉比较迷茫啊。因为我是看视频和书一起自学(主要还是视频),刚好数据库那段找不到,求大家给我介绍一下啊~~简单说说或是给个帖子什么连接都行啊,从安装到使用都行啊。而且我用win7系统装oracle不太会装,MySQL装了个
http://www.itnose.net/detail/334693.html 2014-01-03-11:22   [JavaWeb]

学习数据库好书

本人大学生,最近看书学习知道了数据库重要性,求大家推荐好数据库语言知识(自己有一点数据库基础),以后有做ASP.NET方向。求一本数据库好书,里面讲解了存储过程这些。希望帮帮忙 回复讨论(解决方案) 先学好《关系数据库概论》,然后找一个方向,是学SQLServer?DB2
http://www.itnose.net/detail/209035.html 2014-01-01-15:50   [MS-SQL-Server]

学习数据库建议

我想致力于数据库开发,然后再转向DBA,请问有什么好建议吗?比如要学会什么开发工具或语言等,也可以推荐看一下书或教程 回复讨论(解决方案) 要学会搜索哦、 http://so.csdn.net/ 数据库你用哪个?oracle,sql server还是mysql?工具
http://www.itnose.net/detail/85158.html 2013-12-31-17:38   [Oracle]

数据库case,when学习

, [guagua_new_event_system_test].[dbo].[school] b WHERE a.school_id = b.id GROUP BY b.id , b.name ) AS c 算是数据库一种学习吧! 路漫漫其修远兮,吾将上下而求索!
http://www.itnose.net/detail/6223335.html 2015-03-13 15:46   [其它]

数据库 sqlite 学习

http://www.itnose.net/detail/6268606.html 2015-05-10 16:11   [Sqlite]

学习数据库笔记七

内连接查询 就是把两张表用inner join连接成一张表,再进行查询,筛选这两张表时候用on(where是单张表查询时条件) 例 select boy.hid,bname,girl.hid,gname    #查出两张表记录 from 
http://www.itnose.net/detail/6229513.html 2015-03-22 19:28   [其它]

学习数据库笔记六

截取3个 其它类似还有 取出学习最好前三名 select * from student order by score desc limit 0,3;   模型四    结果集 + group by + 结果集比较 例 查出2
http://www.itnose.net/detail/6229477.html 2015-03-22 17:41   [其它]

学习数据库笔记五

一 where 型子查询 内层查询结果充当外层查询条件 1.查询最新商品    步骤a ) select max(goods_id) from goods;  这是一条动态语句,怎么添加都会是最新,它查出了最新一列goods_id   
http://www.itnose.net/detail/6229468.html 2015-03-22 17:19   [其它]

数据库学习笔记(八)

--对数据库其他操作 --创建表 CREATE TABLE student1 (column_grade int)  GO --查看表信息 EXEC sp_help student1 GO --添加列 ALTER TABLE student1 ADD
http://www.itnose.net/detail/6181608.html 2014-12-26 10:24   [其它]

数据库学习笔记(七)

--在数据库test01中新建课程信息表 USE test01 GO CREATE TABLE course ( courseno nchar(6) NOT NULL, cname nchar(20) NULL, type nchar(8) NULL, period tinyint NULL
http://www.itnose.net/detail/6181580.html 2014-12-26 09:40   [其它]

数据库学习笔记(四)

//生成数据库teaching脚本 USE master GO IF EXISTS(   SELECT name   FROM sys.databases   WHERE name = N'teaching' ) DROP DATABASE teaching CREATE DATABASE teaching    ON  PRIMARY     ( NAME = N'teaching', FILENAME = N'E:\DATA\teaching.mdf' , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )   LOG ON     ( NAME = N'teaching_log', FILENAME = N'E:\DATA\teaching_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) GO USE teaching  GO IF EXISTS (   SELECT * FROM sys.objects    WHERE name = N'student' ) DROP TABLE student CREATE TABLE student( studentno nchar(10) NOT NULL, sname nchar(8) NOT NULL, sex nchar(1) NOT NULL, birthday datetime NOT NULL, classno nchar(6) NOT NULL,     point smallint NOT NULL,     phone nchar(12) NOT NULL,     Email nchar(20) NOT NULL, CONSTRAINT CK_sex CHECK (sex='男' OR sex='女'),     CONSTRAINT PK_student PRIMARY KEY CLUSTERED (studentno  ASC) )  GO IF EXISTS (   SELECT * FROM sys.objects    WHERE name = N'course' ) DROP TABLE dbo.course CREATE TABLE dbo.course( courseno nchar(6) NOT NULL, cname nchar(20) NULL, type nchar(8) NULL, period tinyint NULL, credit numeric(4, 1) NULL,     CONSTRAINT PK_course PRIMARY KEY CLUSTERED (Courseno  ASC) )  GO IF EXISTS (   SELECT * FROM sys.objects    WHERE name = N'teacher' ) DROP TABLE dbo.teacher CREATE TABLE dbo.teacher( teacherno nchar(6) NOT NULL, tname nchar(8) NULL, major nchar(10) NULL, prof nchar(10) NOT NULL, department nchar(12)  NULL,     CONSTRAINT PK_teacher PRIMARY KEY CLUSTERED (teacherno ASC) )  GO IF EXISTS (   SELECT * FROM sys.objects    WHERE name = N'class' ) DROP TABLE dbo.class CREATE TABLE dbo.class( classno nchar(6)  NOT NULL, classname nchar(12) NULL, department nchar(12) NULL, monitor nchar(8) NULL,     CONSTRAINT PK_class PRIMARY KEY CLUSTERED (classno ASC) )  GO IF EXISTS (   SELECT * FROM sys.objects    WHERE name = N'score' ) DROP TABLE dbo.score CREATE TABLE dbo.score( studentno nchar(10)  NOT NULL, courseno  nchar(6)  NOT NULL, usually numeric(6, 2) DEFAULT 0, final numeric(6, 2) DEFAULT 0,     score as usually*30/100+final*70/100,     CONSTRAINT PK_score PRIMARY KEY CLUSTERED (studentno ASC,courseno ASC) )  GO IF EXISTS (   SELECT * FROM sys.objects    WHERE name = N'teach_class' ) DROP TABLE dbo.teach_class CREATE TABLE dbo.teach_class( teacherno nchar(6) NOT NULL,     classno nchar(6) NOT NULL, courseno  nchar(6) NOT NULL,     CONSTRAINT PK_teach_class PRIMARY KEY CLUSTERED (teacherno ASC,classno ASC,courseno ASC) )  GO ALTER TABLE score    ADD CONSTRAINT FK_score_student FOREIGN KEY (studentno) REFERENCES student (studentno) ON UPDATE CASCADE ON DELETE CASCADE,        CONSTRAINT FK_score_course  FOREIGN KEY (courseno)  REFERENCES course (courseno) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE teach_class     ADD CONSTRAINT FK_teach_class_teacher FOREIGN KEY (teacherno) REFERENCES teacher (teacherno) ON UPDATE CASCADE ON DELETE CASCADE,         CONSTRAINT FK_teach_class_class   FOREIGN KEY (classno)   REFERENCES class (classno) ON UPDATE CASCADE ON DELETE CASCADE, CONSTRAINT FK_teach_class_course  FOREIGN KEY (courseno)  REFERENCES course (courseno) ON UPDATE CASCADE ON DELETE CASCADE GO CREATE RULE score_rule AS    @score BETWEEN 0 AND 100 GO EXEC sp_bindrule 'score_rule','score.usually' EXEC sp_bindrule 'score_rule','score.final' insert into student (studentno,sname,sex,birthday,classno,point,phone,Email)values('0822111208','韩吟秋','男','1989-12-18','080601',666,'15878945612','han@163.com'  ) insert into student (studentno,sname,sex,birthday,classno,point,phone,Email)values('0823210007','宿致远','男','1988-12-7', '080501',658,'12545678998','sui2@163.com' ) insert into student (studentno,sname,sex,birthday,classno,point,phone,Email)values('0824113307','崔岩坚','男','1988-4-8',  '080601',787,'15556845645','cui@126.com'  ) insert into student (studentno,sname,sex,birthday,classno,point,phone,Email)values('0922210009','许海冰','男','1989-9-8',  '080501',789,'13623456778','qwe@163.com'  ) insert into student (studentno,sname,sex,birthday,classno,point,phone,Email)values('0922221324','何影',  '女','1990-10-7', '080501',879,'13178978999','aaa@sina.com' ) insert into student (studentno,sname,sex,birthday,classno,point,phone,Email)values('0925111109','敬秉辰','男','1991-1-2',  '080801',789,'15678945623','jing@sina.com') insert into student (studentno,sname,sex,birthday,classno,point,phone,Email)values('0925121107','梁欣',  '女','1989-7-7',  '080502',777,'13145678921','bing@126.com' ) insert into student (studentno,sname,sex,birthday,classno,point,phone,Email)values('0935222201','夏文?','女','1990-8-9',  '080502',867,'15978945645','tang@163.com' ) insert into student (studentno,sname,sex,birthday,classno,point,phone,Email)values('0937221508','平靖',  '女','1989-12-17','080802',789,'12367823453','ping@163.com' ) insert into teacher (teacherno,tname,major,prof,department) values ('t05001','韩晋升','软件工程'  ,'教授'  ,'计算机学院') insert into teacher (teacherno,tname,major,prof,department) values ('t05003','刘元朝','网络技术'  ,'教授'  ,'计算机学院') insert into teacher (teacherno,tname,major,prof,department) values ('t05011','海封'  ,'计算机设计','副教授','计算机学院') insert into teacher (teacherno,tname,major,prof,department) values ('t05017','卢明欣','软件测试'  ,'讲师'  ,'计算机学院') insert into teacher (teacherno,tname,major,prof,department) values ('t06011','胡海悦','机械制造'  ,'教授'  ,'机械学院'  ) insert into teacher (teacherno,tname,major,prof,department) values ('t06023','姚思远','铸造工艺'  ,'副教授','机械学院'  ) insert into teacher (teacherno,tname,major,prof,department) values ('t07019','马爱芬','经济管理'  ,'讲师'  ,'管理学院'  ) insert into teacher (teacherno,tname,major,prof,department) values ('t08017','田有余','金融管理'  ,'副教授','管理学院'  ) insert into course (courseno,cname,type,period,credit) values ('c05103','电子技术','必修',64,4.0) insert into course (courseno,cname,type,period,credit) values ('c05109','C语言'   ,'必修',72,4.5) insert into course (courseno,cname,type,period,credit) values ('c05127','数据结构','必修',64,4.0) insert into course (courseno,cname,type,period,credit) values ('c05138','软件工程','选修',48,3.0) insert into course (courseno,cname,type,period,credit) values ('c06108','机械制图','必修',60,3.5) insert into course (courseno,cname,type,period,credit) values ('c06127','机械设计','必修',64,4.0) insert into course (courseno,cname,type,period,credit) values ('c06172','铸造工艺','选修',42,2.5) insert into course (courseno,cname,type,period,credit) values ('c08106','经济法'  ,'必修',48,3.0) insert into course (courseno,cname,type,period,credit) values ('c08123','金融学'  ,'必修',40,2.5) insert into course (courseno,cname,type,period,credit) values ('c08171','会计软件','选修',32,2.0) insert into class (classno,classname,department,monitor) values ('080501','计08本1班','计算机学院','韩吟秋') insert into class (classno,classname,department,monitor) values ('080502','计08本2班','计算机学院','宿致远') insert into class (classno,classname,department,monitor) values ('080601','机08本1班','机械学院'  ,'崔岩坚') insert into class (classno,classname,department,monitor) values ('080602','机08本2班','机械学院'  ,'韩吟秋') insert into class (classno,classname,department,monitor) values ('080801','管08本1班','管理学院'  ,'许海冰') insert into class (classno,classname,department,monitor) values ('080802','管08本2班','管理学院'  ,'何影') insert into score(studentno,courseno,usually,final) values ('0822111208','c05109',85.00,91.00) insert into score(studentno,courseno,usually,final) values ('0822111208','c06108',89.00,95.00) insert into score(studentno,courseno,usually,final) values ('0822111208','c06127',78.00,67.00) insert into score(studentno,courseno,usually,final) values ('0823210007','c05103',82.00,69.00) insert into score(studentno,courseno,usually,final) values ('0823210007','c05109',87.00,86.00) insert into score(studentno,courseno,usually,final) values ('0824113307','c05103',85.00,77.00) insert into score(studentno,courseno,usually,final) values ('0824113307','c05109',88.00,79.00) insert into score(studentno,courseno,usually,final) values ('0824113307','c06108',66.00,82.00) insert into score(studentno,courseno,usually,final) values ('0922210009','c05103',87.00,82.00) insert into score(studentno,courseno,usually,final) values ('0922210009','c05109',77.00,91.00) insert into score(studentno,courseno,usually,final) values ('0922221324','c05103',88.00,62.00) insert into score(studentno,courseno,usually,final) values ('0922221324','c05109',91.00,77.00) insert into score(studentno,courseno,usually,final) values ('0925111109','c08106',79.00,99.00) insert into score(studentno,courseno,usually,final) values ('0925111109','c08123',85.00,92.00) insert into score(studentno,courseno,usually,final) values ('0925111109','c08171',77.00,92.00) insert into score(studentno,courseno,usually,final) values ('0925121107','c05103',74.00,91.00) insert into score(studentno,courseno
http://www.itnose.net/detail/6181556.html 2014-12-26 08:57   [其它]

数据库学习笔记(一)

--这里是用数据库是2008版本 --sql server2008 --创建数据库 create database student on primary( NAME='teaching', FILENAME='E:\DATA\teaching.mdf', SIZE=4MB, MAXSIZE
http://www.itnose.net/detail/6181552.html 2014-12-26 08:35   [其它]

数据库学习笔记(三)

提示: 想运行程序,首先需要添加数据库,到指定文件夹下, 比如说代码中写是E:\\DATA,那么就需要先在E:\\建立文件夹,然后在进行数据库代码编译执行 --给数据库添加studentfgrp文件组,并且添加数据文件studentfile.ndf到studentfgrp alter
http://www.itnose.net/detail/6181550.html 2014-12-26 08:35   [其它]

  1  2  3  4  5 下一页>