rdf-syntax-grammar
mods:
  schema location: http://www.loc.gov/mods/v3 http://www.loc.gov/standards/mods/v3/mods-3-2.xsd
  title info:
    title: SQL server course for beginners with 100+ examples
  name:
    name part: Diwan, Amit
    role:
      role term: presenter.
  name:
    name part: Packt Publishing
    role:
      role term: publisher.
  type of resource: moving image
  genre: videorecording
  genre: Instructional films.
  genre: Internet videos.
  genre: Nonfiction films.
  genre: Study guides.
  origin info:
    place:
      place term: xx
    date issued: 2022
    edition: [First edition].
    issuance: monographic
  language:
    language term: eng
  physical description:
    form: remote
    extent: 1 online resource (1 video file (2 hr.)) : sound, color.
  abstract: SQL Server is a relational database management system (RDBMS) developed by Microsoft. SQL Server also allows user-defined composite types (UDTs) to be used. The SQL Server services operate within SQL server instances, allowing people to do machine learning and data analytics. In this course, you will understand the difference between SQL and NoSQL. You will query SQL and learn about built-in SQL functions. You will create and modify databases and tables using the CREATE DATABASE and CREATE TABLE statements. You will create, select, and modify records and create constraints in SQL. You will advance to create indexes, drop tables, and databases in SQL. You will learn about operators (AND, OR, NOT, LIKE, BETWEEN, IN, LIKE), functions, statements, and constraints in SQL. You will look at stored procedures and aliases, and learn to back up databases in SQL. You will use the WHERE clause to query and learn about the SELECT and DISTINCT functions. You will arrange data using the ORDER BY keyword and ASC and DESC keywords. After completing the course, you will thoroughly understand SQL's features and components. You will create complex databases and maintain existing databases. Finally, you will acquire complex SQL query capabilities and write complex queries. What You Will Learn Create databases and tables from the start Learn to handle MySQL queries Learn to query SQL to manipulate records in tables Explore functions, statements, and constraints in SQL Create and maintain complex databases and table structures Write complex query statements for maximum data optimization Audience This course delivers a substantial learning experience for database creators, web developers, application developers, and programmers who must operate with SQL and database structures. Database analysts and administrators who are looking to advance/refresh their knowledge skillsets can benefit from this course. The course has no additional prerequisites besides basic computer use knowledge. About …
  note: "Published in November 2022."
  note: Amit Diwan, presenter.
  subject:
    topic: SQL (Computer program language)
  subject:
    topic: Electronic data processing personnel
    topic: Certification
  subject:
    topic: Microsoft software
    topic: Examinations
    genre: Study guides
  subject:
    topic: Electronic data processing personnel
    topic: Certification
  subject:
    topic: Microsoft software
    topic: Examinations
  subject:
    topic: SQL (Computer program language)
  classification: QA76.73.S67
  classification: 005.75/6
  identifier: 9781837630226
  identifier: 1837630224
  identifier: 9781837630226 O'Reilly Media
  identifier: https://proxy.library.tamu.edu/login
  record info:
    record content source: ORMDA
    record creation date: 221128
    record change date: 20260123225455.5
    record identifier: in00004673115
    language of cataloging:
      language term: eng