Searching for SQL : 37 results found | RSS Feed for this search

1

Introduction to Xampp and MySQL (2012-13)

Description

SERGIO LUJÁN and ARMANDO SUÁREZ. XAMPP is a development platform for the operating systems Linux, Windows, MacOS X and Solaris that includes Apache, MySQL, PHP and Perl. This course is an introduction to the management of relational databases oriented exploitation on the web. Begins with a brief description of the steps to follow to install Xampp server environment: Apache, Php and MySQL, with a few brief notes on configuration of the database server and the client phpMyAdmin tool. Then, after showing the context in which are relational databases, a guide about the most common operations performed in phpMyAdmin to manage MySQL databases.

Subjects

License

http://creativecommons.org/licenses/by-nc-sa/3.0/es/

Site sourced from

http://ocw.ua.es/en/ocw-ua.rss

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata

DH3J34 SQL: Introduction

Description

This unit is designed to help you develop a broad knowledge of the concepts, principles, boundaries and scope of relational databases using a query language. This will be reinforced by helping you to develop the practical skills required in using the structures and features of a query language in order to maintain and interrogate a relational database management system. The structured query language (SQL) constructs used adhere to the current standards and so will be applicable in all SQLbased platforms. The unit forms part of an HN group award programme, although it can also be used as a stand-alone unit by candidates wishing to acquire and develop skills using a query language. Outcomes There are three outcomes in this unit: • Create and maintain a data storage system • Manipulate da

Subjects

DH3J 34 | SQL*Plus | Data definition language | Synonyms | Data manipulation language | Headings | SCQF Level 7

License

Licensed to colleges in Scotland only Licensed to colleges in Scotland only Except where expressly indicated otherwise on the face of these materials (i) copyright in these materials is owned by the Scottish Qualification Authority (SQA), and (ii) none of these materials may be Used without the express, prior, written consent of the Colleges Open Learning Exchange Group (COLEG) and SQA, except if and to the extent that such Use is permitted under COLEG's conditions of Contribution and Use of Learning Materials through COLEG’s Repository, for the purposes of which these materials are COLEG Materials. Except where expressly indicated otherwise on the face of these materials (i) copyright in these materials is owned by the Scottish Qualification Authority (SQA), and (ii) none of these materials may be Used without the express, prior, written consent of the Colleges Open Learning Exchange Group (COLEG) and SQA, except if and to the extent that such Use is permitted under COLEG's conditions of Contribution and Use of Learning Materials through COLEG’s Repository, for the purposes of which these materials are COLEG Materials. http://content.resourceshare.ac.uk/xmlui/bitstream/handle/10949/17761/LicenceSQAMaterialsCOLEG.pdf?sequence=1 http://content.resourceshare.ac.uk/xmlui/bitstream/handle/10949/17761/LicenceSQAMaterialsCOLEG.pdf?sequence=1 SQA SQA

Site sourced from

http://dspace.jorum.ac.uk/oai/request?verb=ListRecords&metadataPrefix=oai_dc

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata

DH3J34 SQL: Introduction

Description

This unit is designed to help you develop a broad knowledge of the concepts, principles, boundaries and scope of relational databases using a query language. This will be reinforced by helping you to develop the practical skills required in using the structures and features of a query language in order to maintain and interrogate a relational database management system. The structured query language (SQL) constructs used adhere to the current standards and so will be applicable in all SQLbased platforms. The unit forms part of an HN group award programme, although it can also be used as a stand-alone unit by candidates wishing to acquire and develop skills using a query language. Outcomes There are three outcomes in this unit: • Create and maintain a data storage system • Manipulate da

Subjects

DH3J 34 | / | Data definition language | Synonyms | Data manipulation language | Headings | SCQF Level 7

License

Licensed to colleges in Scotland only Licensed to colleges in Scotland only Except where expressly indicated otherwise on the face of these materials (i) copyright in these materials is owned by the Scottish Qualification Authority (SQA), and (ii) none of these materials may be Used without the express, prior, written consent of the Colleges Open Learning Exchange Group (COLEG) and SQA, except if and to the extent that such Use is permitted under COLEG's conditions of Contribution and Use of Learning Materials through COLEG’s Repository, for the purposes of which these materials are COLEG Materials. Except where expressly indicated otherwise on the face of these materials (i) copyright in these materials is owned by the Scottish Qualification Authority (SQA), and (ii) none of these materials may be Used without the express, prior, written consent of the Colleges Open Learning Exchange Group (COLEG) and SQA, except if and to the extent that such Use is permitted under COLEG's conditions of Contribution and Use of Learning Materials through COLEG’s Repository, for the purposes of which these materials are COLEG Materials. http://content.resourceshare.ac.uk/xmlui/bitstream/handle/10949/17761/LicenceSQAMaterialsCOLEG.pdf?sequence=1 http://content.resourceshare.ac.uk/xmlui/bitstream/handle/10949/17761/LicenceSQAMaterialsCOLEG.pdf?sequence=1 SQA

Site sourced from

http://dspace.jorum.ac.uk/oai/request?verb=ListRecords&metadataPrefix=oai_dc

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata

n de Informacin n de Informacin

Description

Revisin de los Sistemas de Recuperacin de informacin en la Web y en sistemas locales. 1. Sistemas de recuperacin de informacin, posicionamiento y evaluacin de la recuperacin. 2. Lenguajes para estructurar la informacin documental y lenguajes de recuperacin de la informacin. 3. Sistemas de organizacin del conocimiento. Revisin de los Sistemas de Recuperacin de informacin en la Web y en sistemas locales. 1. Sistemas de recuperacin de informacin, posicionamiento y evaluacin de la recuperacin. 2. Lenguajes para estructurar la informacin documental y lenguajes de recuperacin de la informacin. 3. Sistemas de organizacin del conocimiento.

Subjects

n de Bases de Datos | n de Bases de Datos | n e Inteligencia Artificial | n e Inteligencia Artificial | n de buscadores | n de buscadores | n de Pginas Web | n de Pginas Web | cnicas de Representacin y organizacion de informacion | cnicas de Representacin y organizacion de informacion | n | n | as | as | n de contenidos | n de contenidos | Tesauros | Tesauros | SQL | SQL | Internet Invisible | Internet Invisible | ticos | ticos | 2009 | 2009

License

Copyright 2015, UC3M http://creativecommons.org/licenses/by-nc-sa/4.0/

Site sourced from

http://ocw.uc3m.es/ocwuniversia/rss_all

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata

6.893 Database Systems (MIT) 6.893 Database Systems (MIT)

Description

This course is designed to introduce graduate students to the foundations of database systems, focusing on basics such as the relational algebra and data model, query optimization, query processing, and transactions. This is not a course on database design or SQL programming (though we will discuss these issues briefly). It is designed for students who have taken 6.033 (or equivalent); no prior database experience is assumed though students who have taken an undergraduate course in databases are encouraged to attend. This course is designed to introduce graduate students to the foundations of database systems, focusing on basics such as the relational algebra and data model, query optimization, query processing, and transactions. This is not a course on database design or SQL programming (though we will discuss these issues briefly). It is designed for students who have taken 6.033 (or equivalent); no prior database experience is assumed though students who have taken an undergraduate course in databases are encouraged to attend.

Subjects

database systems | database systems | data models | data models | database design | database design | schema design | schema design | schema normalization | schema normalization | integrity constraints | integrity constraints | query processing | query processing | query optimization | query optimization | cost estimation | cost estimation | transactions | transactions | recovery | recovery | concurrency control | concurrency control | isolation | isolation | consistency | consistency | distributed | parallel | and heterogeneous databases | distributed | parallel | and heterogeneous databases | adaptive databases | adaptive databases | trigger systems | trigger systems | pub-sub systems | pub-sub systems | semi-structured data | semi-structured data | XML querying | XML querying

License

Content within individual OCW courses is (c) by the individual authors unless otherwise noted. MIT OpenCourseWare materials are licensed by the Massachusetts Institute of Technology under a Creative Commons License (Attribution-NonCommercial-ShareAlike). For further information see http://ocw.mit.edu/terms/index.htm

Site sourced from

http://ocw.mit.edu/rss/all/mit-allarchivedcourses.xml

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata

11.520 Workshop on Geographic Information Systems (MIT) 11.520 Workshop on Geographic Information Systems (MIT)

Description

This class uses lab exercises and a workshop setting to help students develop a solid understanding of the planning and public management uses of geographic information systems (GIS). The goals are to help students:Acquire technical skills in the use of GIS software.Acquire qualitative methods skills in data and document gathering, analyzing information, and presenting results.Investigate the potential and practicality of GIS technologies in a typical planning setting and evaluate possible applications.The workshop teaches GIS techniques and basic database management at a level that extends somewhat beyond the basic thematic mapping and data manipulation skills included in the MCP core classes (viz. 11.204 and 11.220). Instead of focusing on one thematic map of a single variable, students This class uses lab exercises and a workshop setting to help students develop a solid understanding of the planning and public management uses of geographic information systems (GIS). The goals are to help students:Acquire technical skills in the use of GIS software.Acquire qualitative methods skills in data and document gathering, analyzing information, and presenting results.Investigate the potential and practicality of GIS technologies in a typical planning setting and evaluate possible applications.The workshop teaches GIS techniques and basic database management at a level that extends somewhat beyond the basic thematic mapping and data manipulation skills included in the MCP core classes (viz. 11.204 and 11.220). Instead of focusing on one thematic map of a single variable, students

Subjects

GIS | GIS | Spatial Database Management | Spatial Database Management | Geographic Information Systems | Geographic Information Systems | ArcView | ArcView | census | census | SQL | SQL | databases | databases | urban planning | urban planning | community planning | community planning | spatial analysis | spatial analysis

License

Content within individual OCW courses is (c) by the individual authors unless otherwise noted. MIT OpenCourseWare materials are licensed by the Massachusetts Institute of Technology under a Creative Commons License (Attribution-NonCommercial-ShareAlike). For further information see http://ocw.mit.edu/terms/index.htm

Site sourced from

http://ocw.mit.edu/rss/all/mit-allarchivedcourses.xml

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata

1.963 Environmental Engineering Applications of Geographic Information Systems (MIT) 1.963 Environmental Engineering Applications of Geographic Information Systems (MIT)

Description

This graduate seminar is taught in a lecture and lab exercise format. The subject matter is tailored to introduce Environmental Engineering students to the use and potential of Geographic Information Systems in their discipline. Lectures will cover the general concepts of GIS use and introduce the material in the exercises that demonstrate the practical application of GIS. This graduate seminar is taught in a lecture and lab exercise format. The subject matter is tailored to introduce Environmental Engineering students to the use and potential of Geographic Information Systems in their discipline. Lectures will cover the general concepts of GIS use and introduce the material in the exercises that demonstrate the practical application of GIS.

Subjects

GIS | GIS | Spatial Database Management | Spatial Database Management | Geographic Information Systems | Geographic Information Systems | ArcView | ArcView | census | census | SQL | SQL | databases | databases | cartography | cartography | community planning | community planning | spatial analysis | spatial analysis | wetlands management | wetlands management | data types | data types | map-making | map-making | data mapping | data mapping | hydrology | hydrology | environmental engineering | environmental engineering | deepwater habitats | deepwater habitats | salinization | salinization

License

Content within individual OCW courses is (c) by the individual authors unless otherwise noted. MIT OpenCourseWare materials are licensed by the Massachusetts Institute of Technology under a Creative Commons License (Attribution-NonCommercial-ShareAlike). For further information see http://ocw.mit.edu/terms/index.htm

Site sourced from

http://ocw.mit.edu/rss/all/mit-allcourses.xml

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata

11.520 A Workshop on Geographic Information Systems (MIT) 11.520 A Workshop on Geographic Information Systems (MIT)

Description

This class uses lab exercises and a workshop setting to help students develop a solid understanding of the planning and public management uses of geographic information systems (GIS). The goals are to help students: acquire technical skills in the use of GIS software; acquire qualitative methods skills in data and document gathering, analyzing information, and presenting results; and investigate the potential and practicality of GIS technologies in a typical planning setting and evaluate possible applications. The workshop teaches GIS techniques and basic database management at a level that extends somewhat beyond the basic thematic mapping and data manipulation skills included in the MCP core classes (viz. 11.204 and 11.220). Instead of focusing on one thematic map of a single variable, s This class uses lab exercises and a workshop setting to help students develop a solid understanding of the planning and public management uses of geographic information systems (GIS). The goals are to help students: acquire technical skills in the use of GIS software; acquire qualitative methods skills in data and document gathering, analyzing information, and presenting results; and investigate the potential and practicality of GIS technologies in a typical planning setting and evaluate possible applications. The workshop teaches GIS techniques and basic database management at a level that extends somewhat beyond the basic thematic mapping and data manipulation skills included in the MCP core classes (viz. 11.204 and 11.220). Instead of focusing on one thematic map of a single variable, s

Subjects

GIS | GIS | Spatial Database Management | Spatial Database Management | Geographic Information Systems | Geographic Information Systems | ArcView | ArcView | census | census | SQL | SQL | databases | databases | urban planning | urban planning | community planning | community planning | spatial analysis | spatial analysis

License

Content within individual OCW courses is (c) by the individual authors unless otherwise noted. MIT OpenCourseWare materials are licensed by the Massachusetts Institute of Technology under a Creative Commons License (Attribution-NonCommercial-ShareAlike). For further information see http://ocw.mit.edu/terms/index.htm

Site sourced from

http://ocw.mit.edu/rss/all/mit-allcourses-11.xml

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata

11.521 Spatial Database Management and Advanced Geographic Information Systems (MIT) 11.521 Spatial Database Management and Advanced Geographic Information Systems (MIT)

Description

This semester long subject (11.521) is divided into two halves. The first half focuses on learning spatial database management techniques and methods and the second half focuses on using these skills to address a 'real world,' client-oriented planning problem. The first half of the semester may be taken separately using the class number 11.523 and the second half may be taken separately as 11.524. In order to help shape and utilize the information infrastructure that will support the management and development of our metropolitan areas, planners need a basic understanding of the tools and technology for querying, analyzing, and sharing complex databases and maps. Managing online access to large and constantly-changing spatial datasets can be a powerful aid to planning and can facilitate This semester long subject (11.521) is divided into two halves. The first half focuses on learning spatial database management techniques and methods and the second half focuses on using these skills to address a 'real world,' client-oriented planning problem. The first half of the semester may be taken separately using the class number 11.523 and the second half may be taken separately as 11.524. In order to help shape and utilize the information infrastructure that will support the management and development of our metropolitan areas, planners need a basic understanding of the tools and technology for querying, analyzing, and sharing complex databases and maps. Managing online access to large and constantly-changing spatial datasets can be a powerful aid to planning and can facilitate

Subjects

GIS | GIS | Spatial Database Management | Spatial Database Management | Geographic Information Systems | Geographic Information Systems | ArcView | ArcView | census | census | SQL | SQL | databases | databases | urban planning | urban planning | community planning | community planning | spatial analysis | spatial analysis

License

Content within individual OCW courses is (c) by the individual authors unless otherwise noted. MIT OpenCourseWare materials are licensed by the Massachusetts Institute of Technology under a Creative Commons License (Attribution-NonCommercial-ShareAlike). For further information see http://ocw.mit.edu/terms/index.htm

Site sourced from

http://ocw.mit.edu/rss/all/mit-allcourses-11.xml

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata

15.564 Information Technology I (MIT) 15.564 Information Technology I (MIT)

Description

Information Technology I helps students understand technical concepts underlying current and future developments in information technology. There will be a special emphasis on networks and distributed computing. Students will also gain some hands-on exposure to powerful, high-level tools for making computers do amazing things, without the need for conventional programming languages. Since 15.564 is an introductory course, no knowledge of how computers work or are programmed is assumed. Information Technology I helps students understand technical concepts underlying current and future developments in information technology. There will be a special emphasis on networks and distributed computing. Students will also gain some hands-on exposure to powerful, high-level tools for making computers do amazing things, without the need for conventional programming languages. Since 15.564 is an introductory course, no knowledge of how computers work or are programmed is assumed.

Subjects

developing-country governments; international | developing-country governments; international | computers; future developments; networks;distributed computing; programming languages;firewall;e-business;computerarchitecture;operating systems;software development;database;user interface;telecommunication;data transmission;localarea network;wireless network;internet;world wide web;digital security | computers; future developments; networks;distributed computing; programming languages;firewall;e-business;computerarchitecture;operating systems;software development;database;user interface;telecommunication;data transmission;localarea network;wireless network;internet;world wide web;digital security | computers;future developments;networks;distributed computing;programming languages;firewall;e-business;computerarchitecture;operating systems;software development;database;user interface;telecommunication;data transmission;localarea network;wireless network;internet;world wide web;digital security | computers;future developments;networks;distributed computing;programming languages;firewall;e-business;computerarchitecture;operating systems;software development;database;user interface;telecommunication;data transmission;localarea network;wireless network;internet;world wide web;digital security | computers | computers | future developments | future developments | networks | networks | distributed computing | distributed computing | programming languages | programming languages | firewall | firewall | e-business | e-business | computer architecture | computer architecture | operating | operating | software development | software development | database | database | user interface | user interface | telecommunication | telecommunication | data transmission | data transmission | local area network | local area network | wireless network | wireless network | internet | internet | world wide web | world wide web | digital security | digital security | architecture | architecture | data | data | transmission | transmission | wireless | wireless | interface | interface | user | user | software | software | development | development | programming | programming | languages | languages | distributed | distributed | computing | computing | LAN | LAN | local | local | area | area | future | future | digital | digital | security | security | technology | technology | information | information | management | management | systems | systems | relational | relational | graphical | graphical | interfaces | interfaces | client/server | client/server | enterprise | enterprise | applications | applications | cryptography | cryptography | services | services | Microsoft | Microsoft | Access | Access | Lotus Notes | Lotus Notes | processing | processing | memory | memory | I/O | I/O | CPU | CPU | OS | OS | hardware | hardware | compression | compression | SQL | SQL | queries | queries | design | design | WAN | WAN | wide | wide | Ethernet | Ethernet | packet-switched | packet-switched | peer-to-peer | peer-to-peer | WWW | WWW | public | public | key | key | mining | mining | warehousing | warehousing | concepts | concepts | conceptual | conceptual | modern computing | modern computing | information management | information management | operating systems | operating systems | relational database systems | relational database systems | graphical user interfaces | graphical user interfaces | client/server systems | client/server systems | enterprise applications | enterprise applications | web.internet services | web.internet services | Microsoft Access | Microsoft Access | database management systems | database management systems | information technology | information technology | telecommunications | telecommunications | eBusiness applications | eBusiness applications | client | client | servers | servers | wireless area network | wireless area network

License

Content within individual OCW courses is (c) by the individual authors unless otherwise noted. MIT OpenCourseWare materials are licensed by the Massachusetts Institute of Technology under a Creative Commons License (Attribution-NonCommercial-ShareAlike). For further information see http://ocw.mit.edu/terms/index.htm

Site sourced from

http://ocw.mit.edu/rss/all/mit-allcourses.xml

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata

20.453J Biomedical Information Technology (MIT) 20.453J Biomedical Information Technology (MIT)

Description

This course teaches the design of contemporary information systems for biological and medical data. Examples are chosen from biology and medicine to illustrate complete life cycle information systems, beginning with data acquisition, following to data storage and finally to retrieval and analysis. Design of appropriate databases, client-server strategies, data interchange protocols, and computational modeling architectures. Students are expected to have some familiarity with scientific application software and a basic understanding of at least one contemporary programming language (e.g. C, C++, Java, Lisp, Perl, Python). A major term project is required of all students. This subject is open to motivated seniors having a strong interest in biomedical engineering and information system desig This course teaches the design of contemporary information systems for biological and medical data. Examples are chosen from biology and medicine to illustrate complete life cycle information systems, beginning with data acquisition, following to data storage and finally to retrieval and analysis. Design of appropriate databases, client-server strategies, data interchange protocols, and computational modeling architectures. Students are expected to have some familiarity with scientific application software and a basic understanding of at least one contemporary programming language (e.g. C, C++, Java, Lisp, Perl, Python). A major term project is required of all students. This subject is open to motivated seniors having a strong interest in biomedical engineering and information system desig

Subjects

20.453 | 20.453 | 2.771 | 2.771 | HST.958 | HST.958 | imaging | imaging | medical imaging | medical imaging | metadata | metadata | molecular biology | molecular biology | medical records | medical records | DICOM | DICOM | RDF | RDF | OWL | OWL | SPARQL | SPARQL | SBML | SBML | CellML | CellML | semantic web | semantic web | BioHaystack | BioHaystack | database | database | schema | schema | ExperiBase | ExperiBase | genomics | genomics | proteomics | proteomics | bioinformatics | bioinformatics | computational biology | computational biology | clinical decision support | clinical decision support | clinical trial | clinical trial | microarray | microarray | gel electrophoresis | gel electrophoresis | diagnosis | diagnosis | pathway modeling | pathway modeling | XML | XML | SQL | SQL | relational database | relational database | biological data | biological data | ontologies | ontologies | drug development | drug development | drug discovery | drug discovery | drug target | drug target | pharmaceutical | pharmaceutical | gene sequencing | gene sequencing

License

Content within individual OCW courses is (c) by the individual authors unless otherwise noted. MIT OpenCourseWare materials are licensed by the Massachusetts Institute of Technology under a Creative Commons License (Attribution-NonCommercial-ShareAlike). For further information see http://ocw.mit.edu/terms/index.htm

Site sourced from

http://ocw.mit.edu/rss/all/mit-alllifesciencescourses.xml

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata

Database Systems - Advanced Database Design (Introduction to MS SQL Server 2000 and Transact SQL)

Description

This lecture forms part of the "Advanced Database Design" topic in the Database Systems module.

Subjects

ukoer | ms sql server lecture | advanced database design | ms sql server | advanced databases design | advanced database | advanced databases | database design | database systems | database system | databases | database | advanced database design lecture | advanced databases design lecture | advanced database lecture | advanced databases lecture | database design lecture | database systems lecture | database system lecture | databases lecture | database lecture | Computer science | I100

License

Attribution-Noncommercial-Share Alike 2.0 UK: England & Wales Attribution-Noncommercial-Share Alike 2.0 UK: England & Wales http://creativecommons.org/licenses/by-nc-sa/2.0/uk/ http://creativecommons.org/licenses/by-nc-sa/2.0/uk/

Site sourced from

http://dspace.jorum.ac.uk/oai/request?verb=ListRecords&metadataPrefix=oai_dc

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata

Database Systems - Advanced Database Design (MS SQL Server 2000 -Transact SQL - Triggers)

Description

This lecture forms part of the "Advanced Database Design" topic in the Database Systems module.

Subjects

ukoer | ms sql server lecture | advanced database design | ms sql server | advanced databases design | advanced database | advanced databases | database design | database systems | database system | databases | database | advanced database design lecture | advanced databases design lecture | advanced database lecture | advanced databases lecture | database design lecture | database systems lecture | database system lecture | databases lecture | database lecture | Computer science | I100

License

Attribution-Noncommercial-Share Alike 2.0 UK: England & Wales Attribution-Noncommercial-Share Alike 2.0 UK: England & Wales http://creativecommons.org/licenses/by-nc-sa/2.0/uk/ http://creativecommons.org/licenses/by-nc-sa/2.0/uk/

Site sourced from

http://dspace.jorum.ac.uk/oai/request?verb=ListRecords&metadataPrefix=oai_dc

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata

1.264J Database, Internet, and Systems Integration Technologies (MIT) 1.264J Database, Internet, and Systems Integration Technologies (MIT)

Description

This course addresses information technology fundamentals, including project management and software processes, data modeling, UML, relational databases and SQL. Topics covered include internet technologies, such as XML, web services, and service-oriented architectures. This course provides an introduction to security and presents the fundamentals of telecommunications and includes a project that involves requirements / design, data model, database implementation, website, security and data network. No prior programming experience required. This course addresses information technology fundamentals, including project management and software processes, data modeling, UML, relational databases and SQL. Topics covered include internet technologies, such as XML, web services, and service-oriented architectures. This course provides an introduction to security and presents the fundamentals of telecommunications and includes a project that involves requirements / design, data model, database implementation, website, security and data network. No prior programming experience required.

Subjects

1.264 | 1.264 | ESD.264 | ESD.264 | information technology | information technology | software development | software development | data modeling | data modeling | database | database | application development | application development | web standards | web standards | system integration | system integration | security | security | data communications | data communications | good software process | good software process | supply chain | supply chain | transportation | transportation | civil engineering | civil engineering

License

Content within individual OCW courses is (c) by the individual authors unless otherwise noted. MIT OpenCourseWare materials are licensed by the Massachusetts Institute of Technology under a Creative Commons License (Attribution-NonCommercial-ShareAlike). For further information see http://ocw.mit.edu/terms/index.htm

Site sourced from

http://ocw.mit.edu/rss/all/mit-allcourses.xml

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata

DH3D35 Software Development: Relational Database Systems

Description

The unit is designed to enable you to: • understand the manipulation of normalised data structures • apply this knowledge in the design and use of relational database systems • solve problems, and synthesise and evaluate solutions within the discipline of relational database systems. This unit is suitable for candidates wishing to specialise in the design and implementation of solutions based on relational information systems. Outcomes There are five outcomes in this unit:: 1. Explain the terminology and techniques used in the design of relational information systems. 2. Create a relational database design from user requirements. 3. Describe the issues involved in implementing a relational database system. 4. Implement structures and manipulate data in a relational database managemen

Subjects

DH3D 35 | Data storage | Flat-file V normalised databases | Stages of creating a database | Data analysis | normalisation | Un-normalised form table | Data model | Object-oriented DBMS | Structured query language | SQL*Plus interactive environment | Data definition language (DDL) | Data manipulation language (DML) | SQL – data control language (DCL | SCQF Level 8

License

Licensed to colleges in Scotland only Licensed to colleges in Scotland only Except where expressly indicated otherwise on the face of these materials (i) copyright in these materials is owned by the Scottish Qualification Authority (SQA), and (ii) none of these materials may be Used without the express, prior, written consent of the Colleges Open Learning Exchange Group (COLEG) and SQA, except if and to the extent that such Use is permitted under COLEG's conditions of Contribution and Use of Learning Materials through COLEG’s Repository, for the purposes of which these materials are COLEG Materials. Except where expressly indicated otherwise on the face of these materials (i) copyright in these materials is owned by the Scottish Qualification Authority (SQA), and (ii) none of these materials may be Used without the express, prior, written consent of the Colleges Open Learning Exchange Group (COLEG) and SQA, except if and to the extent that such Use is permitted under COLEG's conditions of Contribution and Use of Learning Materials through COLEG’s Repository, for the purposes of which these materials are COLEG Materials. http://content.resourceshare.ac.uk/xmlui/bitstream/handle/10949/17761/LicenceSQAMaterialsCOLEG.pdf?sequence=1 http://content.resourceshare.ac.uk/xmlui/bitstream/handle/10949/17761/LicenceSQAMaterialsCOLEG.pdf?sequence=1 SQA

Site sourced from

http://dspace.jorum.ac.uk/oai/request?verb=ListRecords&metadataPrefix=oai_dc

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata

Podstawy baz danych z encyklopedią SQL

Description

Subjects

License

http://creativecommons.org/licenses/by-nc-sa/3.0/

Site sourced from

http://open.agh.edu.pl/news/feed.xml

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata

Arquitecturas Distribuidas

Description

Consolidar los conceptos adquiridos sobre sistemas distribuidos en sistemas reales.Aprender las herramientas, patrones bsicos de trabajo y los problemas de los sistemas distribuidos reales.Conocer en profundidad el funcionamiento de la Web (World Wide Web) y ser capaz de desarrollar aplicaciones para la Web.Estudiar tecnologas de referencia : HTML, XML, SQL, CORBA, etc.

Subjects

License

Attribution Non-Comercial Share Alike (by-nc-sa)

Site sourced from

http://ocw.bib.upct.es/rss/rss_ocw.xml

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata

11.520 A Workshop on Geographic Information Systems (MIT)

Description

This class uses lab exercises and a workshop setting to help students develop a solid understanding of the planning and public management uses of geographic information systems (GIS). The goals are to help students: acquire technical skills in the use of GIS software; acquire qualitative methods skills in data and document gathering, analyzing information, and presenting results; and investigate the potential and practicality of GIS technologies in a typical planning setting and evaluate possible applications. The workshop teaches GIS techniques and basic database management at a level that extends somewhat beyond the basic thematic mapping and data manipulation skills included in the MCP core classes (viz. 11.204 and 11.220). Instead of focusing on one thematic map of a single variable, s

Subjects

GIS | Spatial Database Management | Geographic Information Systems | ArcView | census | SQL | databases | urban planning | community planning | spatial analysis

License

Content within individual OCW courses is (c) by the individual authors unless otherwise noted. MIT OpenCourseWare materials are licensed by the Massachusetts Institute of Technology under a Creative Commons License (Attribution-NonCommercial-ShareAlike). For further information see https://ocw.mit.edu/terms/index.htm

Site sourced from

https://ocw.mit.edu/rss/all/mit-allpersiancourses.xml

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata

15.564 Information Technology I (MIT)

Description

Information Technology I helps students understand technical concepts underlying current and future developments in information technology. There will be a special emphasis on networks and distributed computing. Students will also gain some hands-on exposure to powerful, high-level tools for making computers do amazing things, without the need for conventional programming languages. Since 15.564 is an introductory course, no knowledge of how computers work or are programmed is assumed.

Subjects

developing-country governments; international | computers; future developments; networks;distributed computing; programming languages;firewall;e-business;computerarchitecture;operating systems;software development;database;user interface;telecommunication;data transmission;localarea network;wireless network;internet;world wide web;digital security | computers;future developments;networks;distributed computing;programming languages;firewall;e-business;computerarchitecture;operating systems;software development;database;user interface;telecommunication;data transmission;localarea network;wireless network;internet;world wide web;digital security | computers | future developments | networks | distributed computing | programming languages | firewall | e-business | computer architecture | operating | software development | database | user interface | telecommunication | data transmission | local area network | wireless network | internet | world wide web | digital security | architecture | data | transmission | wireless | interface | user | software | development | programming | languages | distributed | computing | LAN | local | area | future | digital | security | technology | information | management | systems | relational | graphical | interfaces | client/server | enterprise | applications | cryptography | services | Microsoft | Access | Lotus Notes | processing | memory | I/O | CPU | OS | hardware | compression | SQL | queries | design | WAN | wide | Ethernet | packet-switched | peer-to-peer | WWW | public | key | mining | warehousing | concepts | conceptual | modern computing | information management | operating systems | relational database systems | graphical user interfaces | client/server systems | enterprise applications | web.internet services | Microsoft Access | database management systems | information technology | telecommunications | eBusiness applications | client | servers | wireless area network

License

Content within individual OCW courses is (c) by the individual authors unless otherwise noted. MIT OpenCourseWare materials are licensed by the Massachusetts Institute of Technology under a Creative Commons License (Attribution-NonCommercial-ShareAlike). For further information see https://ocw.mit.edu/terms/index.htm

Site sourced from

https://ocw.mit.edu/rss/all/mit-allpersiancourses.xml

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata

15.564 Information Technology I (MIT)

Description

Information Technology I helps students understand technical concepts underlying current and future developments in information technology. There will be a special emphasis on networks and distributed computing. Students will also gain some hands-on exposure to powerful, high-level tools for making computers do amazing things, without the need for conventional programming languages. Since 15.564 is an introductory course, no knowledge of how computers work or are programmed is assumed.

Subjects

developing-country governments; international | computers; future developments; networks;distributed computing; programming languages;firewall;e-business;computerarchitecture;operating systems;software development;database;user interface;telecommunication;data transmission;localarea network;wireless network;internet;world wide web;digital security | computers;future developments;networks;distributed computing;programming languages;firewall;e-business;computerarchitecture;operating systems;software development;database;user interface;telecommunication;data transmission;localarea network;wireless network;internet;world wide web;digital security | computers | future developments | networks | distributed computing | programming languages | firewall | e-business | computer architecture | operating | software development | database | user interface | telecommunication | data transmission | local area network | wireless network | internet | world wide web | digital security | architecture | data | transmission | wireless | interface | user | software | development | programming | languages | distributed | computing | LAN | local | area | future | digital | security | technology | information | management | systems | relational | graphical | interfaces | client/server | enterprise | applications | cryptography | services | Microsoft | Access | Lotus Notes | processing | memory | I/O | CPU | OS | hardware | compression | SQL | queries | design | WAN | wide | Ethernet | packet-switched | peer-to-peer | WWW | public | key | mining | warehousing | concepts | conceptual | modern computing | information management | operating systems | relational database systems | graphical user interfaces | client/server systems | enterprise applications | web.internet services | Microsoft Access | database management systems | information technology | telecommunications | eBusiness applications | client | servers | wireless area network

License

Content within individual OCW courses is (c) by the individual authors unless otherwise noted. MIT OpenCourseWare materials are licensed by the Massachusetts Institute of Technology under a Creative Commons License (Attribution-NonCommercial-ShareAlike). For further information see https://ocw.mit.edu/terms/index.htm

Site sourced from

https://ocw.mit.edu/rss/all/mit-allsimplifiedchinesecourses.xml

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata

Database Systems - Advanced Database Design (MS SQL Server 2000 - Stored Procedures and Parameters)

Description

This lecture forms part of the "Advanced Database Design" topic in the Database Systems module.

Subjects

ukoer | ms sql server lecture | advanced database design | ms sql server | advanced databases design | advanced database | advanced databases | database design | database systems | database system | databases | database | advanced database design lecture | advanced databases design lecture | advanced database lecture | advanced databases lecture | database design lecture | database systems lecture | database system lecture | databases lecture | database lecture | Computer science | I100

License

Attribution-Noncommercial-Share Alike 2.0 UK: England & Wales Attribution-Noncommercial-Share Alike 2.0 UK: England & Wales http://creativecommons.org/licenses/by-nc-sa/2.0/uk/ http://creativecommons.org/licenses/by-nc-sa/2.0/uk/

Site sourced from

http://dspace.jorum.ac.uk/oai/request?verb=ListRecords&metadataPrefix=oai_dc

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata

Database Systems - Advanced Database Design (ABD Workshop SQL)

Description

This sql example forms part of the "Advanced Database Design" topic in the Database Systems module.

Subjects

ukoer | sql example | advanced database design | advanced databases design | advanced database | advanced databases | database design | database systems | database system | databases | database | advanced database design example | advanced databases design example | advanced database example | advanced databases example | database design example | database systems example | database system example | databases example | database example | Computer science | I100

License

Attribution-Noncommercial-Share Alike 2.0 UK: England & Wales Attribution-Noncommercial-Share Alike 2.0 UK: England & Wales http://creativecommons.org/licenses/by-nc-sa/2.0/uk/ http://creativecommons.org/licenses/by-nc-sa/2.0/uk/

Site sourced from

http://dspace.jorum.ac.uk/oai/request?verb=ListRecords&metadataPrefix=oai_dc

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata

SQL and JDBC Servlets

Description

Video lecture from a series on Internet Applications delivered by Graham Mansfield. Running time approximately 48 minutes.

Subjects

ukoer | java | java servlets | Computer science | I100

License

Attribution-Noncommercial-Share Alike 2.0 UK: England & Wales Attribution-Noncommercial-Share Alike 2.0 UK: England & Wales http://creativecommons.org/licenses/by-nc-sa/2.0/uk/ http://creativecommons.org/licenses/by-nc-sa/2.0/uk/

Site sourced from

http://dspace.jorum.ac.uk/oai/request?verb=ListRecords&metadataPrefix=oai_dc

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata

Introduction to Modern Database Systems

Description

This course provides a general overview of databases, including topics such as database history, modern database systems, the different models used to design a database, and Structured Query Language (SQL), which is the standard language used to access and manipulate databases. This free course may be completed online at any time. See course site for detailed overview and learning outcomes. (Computer Science 403)

Subjects

computer science | databases | data normalization | sql | entity relationship model | relational database model | relational algebra | join statement | Computer science | I100

License

Attribution 2.0 UK: England & Wales Attribution 2.0 UK: England & Wales http://creativecommons.org/licenses/by/2.0/uk/ http://creativecommons.org/licenses/by/2.0/uk/

Site sourced from

http://dspace.jorum.ac.uk/oai/request?verb=ListRecords&metadataPrefix=oai_dc

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata

Advanced Databases

Description

This course will expand upon SQL as well as other advanced topics, including query optimization, concurrency, data warehouses, object-oriented extensions, and XML. Additional topics covered in this course will help the student become more proficient in writing queries and will expand the student's knowledge base. This free course may be completed online at any time. See course site for detailed overview and learning outcomes. (Computer Science 410)

Subjects

computer science | databases | sql | query optimization | concurrency | recovery | xml | stored procedures | object-orientated | object-relational | Computer science | I100

License

Attribution 2.0 UK: England & Wales Attribution 2.0 UK: England & Wales http://creativecommons.org/licenses/by/2.0/uk/ http://creativecommons.org/licenses/by/2.0/uk/

Site sourced from

http://dspace.jorum.ac.uk/oai/request?verb=ListRecords&metadataPrefix=oai_dc

Attribution

Click to get HTML | Click to get attribution | Click to get URL

All metadata

See all metadata