£0
- Brand: DataCeps
- Sku: SK69152UK
- Availability: In Stock
✔️Immediate download
✔️Highlighting, editing, saving and printing are available
✔️The same content as in a hardcover book
✔️Search for words within the text
✔️For any PDF file viewers and devices
How to download
Register on this website and pay for your selected book.
After you have paid, go to "My Account"-"Downloads" section. There you will see a PDF file. Download and open it. It contains a link to download your book. Click on the link and download your book.
You can send us a message that you want to receive the book to your e-mail, and a link to download the book will also be sent to your e-mail.
About the book:
Publisher: DataCeps
Author (s): Dane Wade
Pages: 492
Edition: 2022
Language: English
Size: 14 Mb
Content:
INTRODUCTION
PART 1: THE FUNDAMENTALS
CHAPTER 1: MASTERING THE FUNDAMENTALS & DATABASES
THE EVOLUTION OF DATABASES
DIFFERENT TYPES OF DATABASES
UNDERSTANDING DATABASE MANAGEMENT SYSTEMS
DIVING INTO THE CONCEPT OF DATA MODELLING
ONE TO ONE
ONE TO MANY AND MANY TO ONE
MANY-TO-MANY
SELF-REFERENCING RELATIONSHIPS
ENTITY-RELATIONSHIP MODEL
ENTITY
ATTRIBUTES
RELATIONSHIP
ONE
MANY
1 AND ONLY 1
1 OR MANY
ZERO OR ONE
0 OR MANY
REPRESENTING CARDINALITY BETWEEN ENTITIES USING
RELATIONSHIP NOTATIONS.
SCENARIO: A SIMPLE ECOMMERCE SALES ER MODEL
STEP 1: IDENTIFYING THE ENTITIES
STEP 2: IDENTIYING THE RELATIONSHIPS
STEP 3: CREATING THE ER DIAGRAM
CHAPTER 2: THE RELATIONAL MODEL, RDBMS AND SQL
THE RELATIONAL MODEL
SOME KEY TERMS OF RELATIONAL MODEL.
KEYS IN A TABLE
CHARACTERISTICS OF A RELATIONAL TABLES
RELATING MULTIPLE TABLES
DEPENDENCIES IN A TABLES
NORMALIZATION
CODD’S RULES OF RELATIONAL MODEL
RELATIONAL DATABASE MANAGEMENT SYSTEM (RDBMS)
SQL AND ITS IMPACT
ADVANTAGES OF SQL
HISTORY AND BIRTH OF SQL
CHAPTER 3: DATACEPTION: Data, Datatypes and Metadata
UNDERSTANDING DATATYPES
NUMERIC DATA TYPES
STRING DATATYPES
BINARY DATA TYPES
DATE TIME DATATYPES IN SQL
METADATA: DATA ABOUT DATA
PART 2: GETTING YOUR HANDS DIRTY WITH SQL
CHAPTER 4: INSTALLATION OF SOFTWARE TOOLS
SQL SERVER INSTALLATION FOR WINDOWS
SQL SERVER INSTALLATION IN MAC OS
PART 1: INSTALLING DOCKER
PART 2: DOWNLOAD AND INSTALL SQL SERVER ON MAC
PART 3: AZURE DATA STUDIO INSTALLATION
CHAPTER 5: MASTERING SQL QUERIES
SQL QUERIES, STATEMENTS, and CLAUSES
NUT AND BOLTS OF SQL STATEMENTS
PRACTICING SQL COMMANDS
CHAPTER 6: UNDERSTANDING TABLES IN DEPTH
DESIGNING AND CREATING TABLES
STEP 1: IDENTIFYING ENTITIES
STEP 2: IDENTIFYING ATTRIBUTES
STEP 3: IDENTIFYING THE KEYS ATTRIBUTES
STEP 4: IDENTIFYING THE CONSTRAINTS
STEP 5: CREATING TABLES USING SQL STATEMENTS
BEST PRACTICES FOR CREATING TABLES THAT EVERY
DEVELOPER WILL RESPECT YOU FOR
CHOOSING THE RIGHT CASES AND STICKING TO IT:
AVOID SPELLING MISTAKES:
ADDING COMMENTS IN YOUR SQL STATEMENTS:
ADDING ALIASES:
CHAPTER 7: PLAYING WITH DATA USING SELECT
THE SELECT CLAUSE
TOP
DISTINCT
THE FROM CLAUSE
THE WHERE CLAUSE
THE GROUP BY CLAUSE
COUNT ()
SUM ()
AVG ()
MIN ()
MAX ()
THE HAVING CLAUSE
THE ORDER BY CLAUSE
ADVANCED FILTERING (Operators in WHERE clause )
COMPARISON OPERATORS IN SQL
LOGICAL OPERATORS IN SQL
EVALUATION AND PROCESSING OF SQL QUERY
CHAPTER 8: MASTERING SQL FUNCTIONS
SYSTEM DEFINED FUNCTIONS
AGGREGATE FUNCTIONS
MAX ()
MIN ()
SUM ()
AVG ()
COUNT ()
STRING FUNCTIONS
ASCII
CHAR
LEN
CHARINDEX
PATINDEX
LEFT
RIGHT
LTRIM
RTRIM
REPLACE
REPLICATE
REVERSE
QUOTENAME
SPACE
STR
STUFF
SUBSTRING
LOWER
UPPER
SOUNDEX
DIFFERENCE
CONCAT
TRIM
TRANSLATE
NCHAR
DATALENGTH
CONCAT_WS
CONCAT USING +
DATE AND TIME FUNCTIONS
FUNCTIONS THAT RETURNS CURRENT DATE
FUNCTIONS THAT RETURN PART OF A DATE AND TIME:
SQL FUNCTIONS TO MODIFY DATE VALUES
WORKING WITH NUMERIC/MATH FUNCTIONS
POWER
REFRESHING SOME PROGRAMMING FUNDAMENTALS
USER DEFINED FUNCTIONS
SCALAR FUNCTIONS
INLINE TABLE-VALUED FUNCTIONS
LEVELING UP THE GAME WITH ADVANCED FUNCTIONS
WINDOW Function in SQL.
ROW_NUMBER()
RANK()
DENSE_RANK()
NTILE()
DEALING WITH NULL VALUES USING FUNCTIONS
CHAPTER 9: LEVELLING UP THE GAME WITH SUBQUERIES
What is a SUBQUERY?
EXPLORING POSSIBILITIES WITH SUBQUERIES
CHAPTER 10: SQL JOINS MADE EASY
WHY DO WE NEED JOINS?
UNDESTANDING JOINS
THE CROSS JOIN
INNER JOIN
OUTER JOINS
LEFT OUTER JOIN
RIGHT OUTER JOIN
FULL OUTER JOIN
CHAPTER 11: SETS IN SQL
UNION
UNION ALL
INTERSECT
EXCEPT
PART 3: ADVANCE LEVEL STUFF
CHAPTER 12 : VIEWS AND INDEXES IN SQL
VIEWS
WHY USE VIEWS?
TYPES OF SQL VIEWS
USER-DEFINED VIEWS
INDEXES
CHAPTER 13: STORED PROCEDURES, CURSOR AND TRIGGERS
UNDERSTANDING STORED PROCEDURES
TRIGGERS
TYPES OF TRIGGERS
CURSORS
RESOURCES and REFERENCES
There are no reviews for this product.