Simple SQL: Beginner’s Guide To Master SQL And Boost Career (Zero To Hero), Edition 2022 (PDF)

✔️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

Tags: Simple SQL Beginner’s Guide, SQL Beginner’s Guide pdf download