가야대학교 분성도서관
주메뉴
자료검색
- Home
- 상세정보
상세정보
부가기능
Learn SQL database programming : query and manipulate databases from popular relational database servers using SQL /
상세 프로파일
| 자료유형 | E-Book |
|---|---|
| 개인저자 | Bush, Josephine, author. |
| 서명/저자사항 | Learn SQL database programming :query and manipulate databases from popular relational database servers using SQL /Josephine Bush. |
| 발행사항 | Birmingham : Packt Publishing, 2020. |
| 형태사항 | 1 online resource |
| 소장본 주기 | Master record variable field(s) change: 050 |
| ISBN | 1838981705 9781838981709 |
| 일반주기 |
Table of ContentsIntroduction to Relational Database Management SystemsInstalling and Using MySQL WorkbenchUnderstanding Data TypesDesigning and Creating a DatabaseImporting and Exporting DataQuerying a Single TableQuerying Multiple TablesModifying Data and Table StructuresWorking with ExpressionsGrouping and Summarizing DataAdvanced Querying TechniquesProgrammable ObjectsExploring and Processing Your DataTell a Story with Your DataBest Practices for Design and QueryingSQL Appendix.
|
| 내용주기 | Cover -- Title Page -- Copyright and Credits -- About Packt -- Contributors -- Table of Contents -- Preface -- Section 1: Database Fundamentals -- Chapter 1: Introduction to Relational Database Management Systems -- Understanding SQL -- Elements of SQL -- Understanding databases -- Tables -- Fields -- Records or rows -- Columns -- Understanding data integrity -- Types of integrity -- Entity integrity -- Unique constraints -- Not null constraints -- The primary key -- Referential integrity -- Domain integrity -- Database normalization -- The first normal form -- The second normal form The third normal form -- Types of RDMS -- Oracle -- MySQL -- SQL Server -- PostgreSQL -- RDMS SQL differences -- Summary -- Questions -- Chapter 2: Installing and Using MySQL Workbench -- Technical requirements -- Installing MySQL Workbench -- Installing on Windows -- Installing MySQL on Windows -- Configuring MySQL on Windows -- Installing on Mac -- Installing MySQL Server on Mac -- Checking the status of MySQL Server on Mac -- Installing MySQL Workbench on Mac -- Using MySQL Workbench -- Connecting to your local instance -- Connecting to another instance or setting up your local instance Restoring a database -- Summary -- Questions -- Chapter 3: Understanding Data Types -- Understanding string data types -- String data types in MySQL -- MySQL string data type table summary -- String data types in other RDMS -- Oracle -- PostgreSQL -- SQL Server -- String data types RDMS table comparison -- Understanding numeric data types -- Numeric data types in MySQL -- MySQL numeric data type table summary -- Numeric data types in other RDMSes -- SQL Server -- Oracle -- PostgreSQL -- Numeric data types table comparison -- Understanding date and time data types Date and time data types in MySQL -- MySQL date and time data type table summary -- Date and time data types in other RDMSes -- Oracle -- PostgreSQL -- SQL Server -- Date and time data types table comparison -- Understanding other data types -- Other data types in MySQL -- Other data types in other RDMSes -- Oracle -- PostgreSQL -- SQL Server -- Choosing the right data type -- Examples of choosing a data type -- Summary -- Questions -- Chapter 4: Designing and Creating a Database -- Technical requirements -- Creating a database -- Guidelines for naming conventions -- Avoiding keywords Avoiding spaces -- Descriptive and accurate naming -- Case and separating words -- Allowed characters when naming database objects -- Learning how to create a database -- Creating a database via the MySQL Workbench interface -- Creating a database via MySQL Workbench with a SQL script -- Understanding SQL code errors -- Understanding table relationships -- Understanding entity-relationship diagrams -- Understanding one-to-one table relationships -- Understanding one-to-many table relationships -- Understanding many-to-many table relationships -- Creating a table in the database |
| 요약 | SQL is a powerful querying language used to store, manipulate, and retrieve data. This is a comprehensive guide for who are new to SQL, which will have you up-to-speed and using SQL to streamline your work in no time. It gives users enough confidence to use SQL queries for retrieving and manipulating data relevant to their work-related tasks. |
| 일반주제명 | SQL (Computer program language) Database management. |
| 언어 | 영어 |
| 기타형태 저록 | Print version:9781838984762 |
| 대출바로가기 | http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=2490091 |
소장정보
- 소장정보
인쇄
| No. | 등록번호 | 청구기호 | 소장처 | 도서상태 | 반납예정일 | 예약 | 서비스 | 매체정보 |
|---|---|---|---|---|---|---|---|---|
| 1 | WE00018684 | 005.756 | 가야대학교/전자책서버(컴퓨터서버)/ | 대출가능 |
|
카피라이터
