SQL: The Ultimate Intermediate Guide to Learning SQL Programming Step by Step

Length: 186 pages
Edition: 1
Language: English
Publication Date: 2022-01-14
ISBN-10: B09QHD5BPP
Sales Rank: #0 (See Top 100 Books)

Do you use SQL on a daily basis? Have you mastered the fundamentals and want it to do more for you?

The answers can be found in this book!

SQL, or Structured Query Language, is a must-have tool for developers working in any programming language, and its universal language is domain-specific, making it ideal for programming and data management.

SQL: The Ultimate Intermediate Guide to Learning SQL Programming Step by Step is suitable for helping you with a variety of intermediate abilities, including:

A refresher on SQL fundamentals
An easy-to-follow tutorial on setting up and configuring SQL
Data types and their functions
View encryption, creation, and indexing
Using stored routines and functions to their full potential
The advantages of data normalization
And so much more…

With this practical and in-depth book, you will be able to improve your SQL knowledge and skills, regardless of how you use it. And because it’s presented in an easy-to-follow format, it makes learning a potentially hard activity much easier.

Introduction
    SQL
Chapter 1: Basics of SQL
    Data and Databases
    The Elements of an SQL Database
    SQL Server
Chapter 2: Installing and Configuring MySQL
    Downloading, Installing, and the Initial Setup of MySQL on a Microsoft Windows Computer System
    Downloading, Installing, and the Initial Setup of MySQL on a Mac Computer System
Chapter 3: Getting Started With SQL
    MySQL Screen
    Working With MySQL Databases
    Working With Tables
    Exercise 1
    Viewing Data in a Table
Chapter 4: Data Types
    SQL Data Type Categories
Chapter 5: SQL Statements and Clauses
    SQL Statements
    SQL Clauses
Chapter 6: SQL Expressions, Functions, and Operators
    Expressions
    Operators
    Functions
Chapter 7: Working With Constraints
    Commonly Used SQL Constraints
    Adding Constraints
    Altering Constraints
    Exercise 2
Chapter 8: Joins, Unions, Ordering, Grouping, and Alias
    JOINS
    UNION
    Order
    Group By
    Alias
Chapter 9: Stored Procedures
Chapter 10: Views, Index, Truncate, Top, Wildcards, and Triggers
    Index
    Truncate
    Top
    Wildcards
    Triggers
Chapter 11: Pivoting Tables in MySQL
Chapter 12: Clone Tables
Chapter 13: Security
Chapter 14: SQL Injections
Chapter 15: Fine-Tuning
Chapter 16: Working With SSMS
    Downloading SQL Server Management Studio (SSMS)
    The Basics and Features of SSMS
Chapter 17: Database Administration
    Maintenance Plan
    Running the Maintenance Plan
    Backup and Recovery
    Database Backup
    Attaching and Detaching Databases
Chapter 18: Deadlocks
Chapter 19: Normalization of Your Data
    How to Normalize the Database
    Database Normal Forms
Chapter 19: Real-World Uses
Conclusion
References