Academic Journal

Teaching Advanced SQL Skills: Text Bulk Loading.

Λεπτομέρειες βιβλιογραφικής εγγραφής
Τίτλος: Teaching Advanced SQL Skills: Text Bulk Loading.
Συγγραφείς: Olsen, David1 david.olsen@usu.edu, Hauser, Karma1 karina.hauser@usu.edu
Πηγή: Journal of Information Systems Education. Winter2007, Vol. 18 Issue 4, p399-402. 4p. 4 Black and White Photographs.
Θεματικοί όροι: *SQL, *Programming languages, *XML (Extensible Markup Language), Study & teaching of management information systems, Education research, Computer science education, Education
Περίληψη: Studies show that advanced database skills are important for student to be prepared for the today's highly competitive job market. A common task for database administrators is to insert large amount of data into a database. This paper illustrates how an up-to-date, advanced database topic, namely bulk insert, can be incorporated into a database class. It gives detailed examples on how to import different file types and discusses associated issues. [ABSTRACT FROM AUTHOR]
Copyright of Journal of Information Systems Education is the property of Information Systems & Computing Academic Professionals (ISCAP) and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.)
Βάση Δεδομένων: Business Source Index
FullText Text:
  Availability: 0
CustomLinks:
  – Url: https://resolver.ebsco.com/c/fiv2js/result?sid=EBSCO:bsx&genre=article&issn=10553096&ISBN=&volume=18&issue=4&date=20071201&spage=399&pages=399-402&title=Journal of Information Systems Education&atitle=Teaching%20Advanced%20SQL%20Skills%3A%20Text%20Bulk%20Loading.&aulast=Olsen%2C%20David&id=DOI:
    Name: Full Text Finder (for New FTF UI) (ns324271)
    Category: fullText
    Text: Full Text Finder
    MouseOverText: Full Text Finder
Header DbId: bsx
DbLabel: Business Source Index
An: 28320938
RelevancyScore: 1171
AccessLevel: 6
PubType: Academic Journal
PubTypeId: academicJournal
PreciseRelevancyScore: 1171.3779296875
IllustrationInfo
Items – Name: Title
  Label: Title
  Group: Ti
  Data: Teaching Advanced SQL Skills: Text Bulk Loading.
– Name: Author
  Label: Authors
  Group: Au
  Data: <searchLink fieldCode="AR" term="%22Olsen%2C+David%22">Olsen, David</searchLink><relatesTo>1</relatesTo><i> david.olsen@usu.edu</i><br /><searchLink fieldCode="AR" term="%22Hauser%2C+Karma%22">Hauser, Karma</searchLink><relatesTo>1</relatesTo><i> karina.hauser@usu.edu</i>
– Name: TitleSource
  Label: Source
  Group: Src
  Data: <searchLink fieldCode="JN" term="%22Journal+of+Information+Systems+Education%22">Journal of Information Systems Education</searchLink>. Winter2007, Vol. 18 Issue 4, p399-402. 4p. 4 Black and White Photographs.
– Name: Subject
  Label: Subject Terms
  Group: Su
  Data: *<searchLink fieldCode="DE" term="%22SQL%22">SQL</searchLink><br />*<searchLink fieldCode="DE" term="%22Programming+languages%22">Programming languages</searchLink><br />*<searchLink fieldCode="DE" term="%22XML+%28Extensible+Markup+Language%29%22">XML (Extensible Markup Language)</searchLink><br /><searchLink fieldCode="DE" term="%22Study+%26+teaching+of+management+information+systems%22">Study & teaching of management information systems</searchLink><br /><searchLink fieldCode="DE" term="%22Education+research%22">Education research</searchLink><br /><searchLink fieldCode="DE" term="%22Computer+science+education%22">Computer science education</searchLink><br /><searchLink fieldCode="DE" term="%22Education%22">Education</searchLink>
– Name: Abstract
  Label: Abstract
  Group: Ab
  Data: Studies show that advanced database skills are important for student to be prepared for the today's highly competitive job market. A common task for database administrators is to insert large amount of data into a database. This paper illustrates how an up-to-date, advanced database topic, namely bulk insert, can be incorporated into a database class. It gives detailed examples on how to import different file types and discusses associated issues. [ABSTRACT FROM AUTHOR]
– Name: AbstractSuppliedCopyright
  Label:
  Group: Ab
  Data: <i>Copyright of Journal of Information Systems Education is the property of Information Systems & Computing Academic Professionals (ISCAP) and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract.</i> (Copyright applies to all Abstracts.)
PLink https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=bsx&AN=28320938
RecordInfo BibRecord:
  BibEntity:
    Languages:
      – Code: eng
        Text: English
    PhysicalDescription:
      Pagination:
        PageCount: 4
        StartPage: 399
    Subjects:
      – SubjectFull: SQL
        Type: general
      – SubjectFull: Programming languages
        Type: general
      – SubjectFull: XML (Extensible Markup Language)
        Type: general
      – SubjectFull: Study & teaching of management information systems
        Type: general
      – SubjectFull: Education research
        Type: general
      – SubjectFull: Computer science education
        Type: general
      – SubjectFull: Education
        Type: general
    Titles:
      – TitleFull: Teaching Advanced SQL Skills: Text Bulk Loading.
        Type: main
  BibRelationships:
    HasContributorRelationships:
      – PersonEntity:
          Name:
            NameFull: Olsen, David
      – PersonEntity:
          Name:
            NameFull: Hauser, Karma
    IsPartOfRelationships:
      – BibEntity:
          Dates:
            – D: 01
              M: 12
              Text: Winter2007
              Type: published
              Y: 2007
          Identifiers:
            – Type: issn-print
              Value: 10553096
          Numbering:
            – Type: volume
              Value: 18
            – Type: issue
              Value: 4
          Titles:
            – TitleFull: Journal of Information Systems Education
              Type: main
ResultId 1