가야대학교 분성도서관
주메뉴
자료검색
- Home
- 상세정보
상세정보
부가기능
SQL WORKSHOP;A NEW, INTERACTIVE APPROACH TO LEARNING SQL
상세 프로파일
| 자료유형 | E-Book |
|---|---|
| 개인저자 | FRANK SOLOMON;PRASHANTH JAYARAM;AWNI AL SAQQA. |
| 서명/저자사항 | SQL WORKSHOP;A NEW, INTERACTIVE APPROACH TO LEARNING SQL |
| 발행사항 | [Place of publication not identified] : PACKT Publishing, 2019. |
| 형태사항 | 1 online resource |
| 소장본 주기 | Master record variable field(s) change: 050, 082, 650 - OCLC control number change |
| ISBN | 1838649085 9781838649081 |
| 내용주기 | Cover -- FM -- Copyright -- Table of Contents -- Preface -- Chapter 1: SQL Basics -- Introduction -- Understanding Data -- An Overview of Basic SQL Commands -- Creating Databases -- The Use of Semicolons -- Data Types in SQL -- Creating Simple Tables -- Exercise 1.01: Building the PACKT_ONLINE_SHOP Database -- Populating Your Tables -- Exercise 1.02: Inserting Values into the Customers Table of the PACKT_ONLINE_SHOP Database -- Activity 1.01: Inserting Values into the Products Table in the PACKT_ONLINE_SHOP Database -- Summary -- Chapter 2: Manipulating Data -- Introduction The INSERT Operation -- Performing a Simple INSERT -- Exercise 2.01: Inserting One Row of Data into a Table -- Multiple Inserts -- Exercise 2.02: Specifying Default Values -- Using an INSERT Statement to Add Data from Another Dataset -- The DELETE Operation -- Exercise 2.03: Deleting a record from a table -- The ALTER Operation -- Exercise 2.04: Manipulating the Auto-Increment Values in a Table -- The UPDATE Operation -- The Basic UPDATE Statement -- ALIASING -- Conditional Update of Records -- Limiting the Records Using an UPDATE Statement -- Exercise 2.05: UPDATE Using Computed Values The DROP Operation -- Activity 2.01: Inserting Additional values to the Products table -- Summary -- Chapter 3: Normalization -- Introduction -- Primary Key Constraints -- Foreign Key Constraints -- Preserving Data Integrity -- Types of Data Integrity -- The Concept of Normalization -- First Normal Form (1NF) -- Second Normal Form (2NF) -- Third Normal Form (3NF) -- Denormalization -- Exercise 3.01: Building a Relationship between Two Tables -- Activity 3.01: Building a Relationship between the Orders and the OrderItems table -- Summary -- Chapter 4: The SELECT Statement -- Introduction What Does the SELECT Statement Do? -- Retrieving All Columns of a Table -- Selecting Limited Columns -- Exercise 4.01: Selecting Columns from a Table -- Using Naming Aliases -- Exercise 4.02: Aliasing the Column Headers -- Activity 4.01: Displaying Particular Columns from the Table -- Ordering Results -- Ordering Rows According to a Particular Column -- Ordering Rows According to Multiple Columns -- Using LIMIT -- Exercise 4.03: Using the LIMIT Keyword -- Using DISTINCT -- Using Mathematical Expressions -- Exercise 4.04: Calculating the Line Item Total -- Exercise 4.05: Calculating Discount Activity 4.02: Extracting the Top Five Highest Priced Items -- Summary -- Chapter 5: Shaping Data with the WHERE Clause -- Introduction -- The WHERE Clause Syntax -- Exercise 5.01: Implementing Logical Operators in the WHERE Clause -- Exercise 5.02: Using the BETWEEN Operator -- The Not Equal Operator -- Exercise 5.03: Using the!= and Operators -- The LIKE Operator -- Exercise 5.04: Using the LIKE Operator to Check a Pattern at the Beginning of a String -- Exercise 5.05: Using the LIKE Operator to Check for a Specified Length -- Checking for NULLS -- Exercise 5.06: Searching for NULL Values |
| 요약 | Cut through the noise and get real results with a step-by-step approach to learning SQL. |
| 일반주제명 | SQL (Computer program language) Relational databases. Relational databases. SQL (Computer program language) |
| 언어 | 영어 |
| 기타형태 저록 | Print version:Solomon, Frank.SQL Workshop : A New, Interactive Approach to Learning SQL.Birmingham : Packt Publishing, Limited, 짤20199781838642358 |
| 대출바로가기 | http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=2340737 |
소장정보
- 소장정보
인쇄
| No. | 등록번호 | 청구기호 | 소장처 | 도서상태 | 반납예정일 | 예약 | 서비스 | 매체정보 |
|---|---|---|---|---|---|---|---|---|
| 1 | WE00018389 | 005.75/6 | 가야대학교/전자책서버(컴퓨터서버)/ | 대출가능 |
|
카피라이터
