What do you think?
Rate this book
The SQL Workshop: Learn to create, manipulate and secure data and manage relational databases with SQL
Get to grips with SQL fundamentals and learn how to efficiently create, read and update information stored in databases
Key FeaturesUnderstand the features and syntax of SQL and use them to query databasesLearn how to create databases and tables and manipulate the data within themCreate advanced queries and apply them on realistic databases with hands-on activitiesBook DescriptionMany software applications are backed by powerful relational database systems, meaning that the skills to be able to maintain a SQL database and reliably retrieve data are in high demand. With its simple syntax and effective data manipulation capabilities, SQL enables you to manage relational databases with ease. The SQL Workshop will help you progress from basic to advanced-level SQL queries in order to create and manage databases successfully.
This Workshop begins with an introduction to basic CRUD commands and gives you an overview of the different data types in SQL. You'll use commands for narrowing down the search results within a database and learn about data retrieval from single and multiple tables in a single query. As you advance, you'll use aggregate functions to perform calculations on a set of values, and implement process automation using stored procedures, functions, and triggers. Finally, you'll secure your database against potential threats and use access control to keep your data safe.
Throughout this Workshop, you'll use your skills on a realistic database for an online shop, preparing you for solving data problems in the real world.
By the end of this book, you'll have built the knowledge, skills and confidence to creatively solve real-world data problems with SQL.
What you will learnCreate databases and insert data into themUse SQL queries to create, read, update, and delete dataMaintain data integrity and consistency through normalizationCustomize your basic SQL queries to get the desired outputRefine your database search using the WHERE and HAVING clausesUse joins to fetch data from multiple tables and create custom reportsImprove web application performance by automating processesSecure a database with GRANT and REVOKE privilegesWho this book is forThis Workshop is suitable for anyone who wants to learn how to use SQL to work with databases. No prior SQL or database experience is necessary. Whether you're an aspiring software developer, database engineer, data scientist, or systems administrator, this Workshop will quickly get you up and running.
Table of ContentsIntroduction to SQLManipulating DataDatabase NormalizationThe SELECT StatementShaping Data with the WHERE ClauseJOINSTaking Queries to the Next LevelSQL ProgrammingSecurityAggregate FunctionsFunctions and Transactions
Key FeaturesUnderstand the features and syntax of SQL and use them to query databasesLearn how to create databases and tables and manipulate the data within themCreate advanced queries and apply them on realistic databases with hands-on activitiesBook DescriptionMany software applications are backed by powerful relational database systems, meaning that the skills to be able to maintain a SQL database and reliably retrieve data are in high demand. With its simple syntax and effective data manipulation capabilities, SQL enables you to manage relational databases with ease. The SQL Workshop will help you progress from basic to advanced-level SQL queries in order to create and manage databases successfully.
This Workshop begins with an introduction to basic CRUD commands and gives you an overview of the different data types in SQL. You'll use commands for narrowing down the search results within a database and learn about data retrieval from single and multiple tables in a single query. As you advance, you'll use aggregate functions to perform calculations on a set of values, and implement process automation using stored procedures, functions, and triggers. Finally, you'll secure your database against potential threats and use access control to keep your data safe.
Throughout this Workshop, you'll use your skills on a realistic database for an online shop, preparing you for solving data problems in the real world.
By the end of this book, you'll have built the knowledge, skills and confidence to creatively solve real-world data problems with SQL.
What you will learnCreate databases and insert data into themUse SQL queries to create, read, update, and delete dataMaintain data integrity and consistency through normalizationCustomize your basic SQL queries to get the desired outputRefine your database search using the WHERE and HAVING clausesUse joins to fetch data from multiple tables and create custom reportsImprove web application performance by automating processesSecure a database with GRANT and REVOKE privilegesWho this book is forThis Workshop is suitable for anyone who wants to learn how to use SQL to work with databases. No prior SQL or database experience is necessary. Whether you're an aspiring software developer, database engineer, data scientist, or systems administrator, this Workshop will quickly get you up and running.
Table of ContentsIntroduction to SQLManipulating DataDatabase NormalizationThe SELECT StatementShaping Data with the WHERE ClauseJOINSTaking Queries to the Next LevelSQL ProgrammingSecurityAggregate FunctionsFunctions and Transactions
290 pages, Kindle Edition
Published December 30, 2019
4 people are currently reading
1 person want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 of 1 review
May 4, 2020
Thanks to the pandemic I got access to this course/book for free.
After the previous course/book, The HTML and CSS Workshop, I had my doubts about this series, but I wanted to give this one a try, because I loved sql programming but I haven't used it in years.
I finished the first chapter and I had enough of this course. From introduction to creating your first database it doesn't even mention which program you should be using and how to get to the screen for entering the statements. It was easy for me, but for someone new to this it creates an unnecessary hurdle. A wrong image was used to show the result of an exercise, typos in query statements and the quiz contained questions about topics that weren't even mentioned in the first chapter and from more advanced chapters. What am I, a proofreader? I would rather read the reference manual than continue with this book.
After the previous course/book, The HTML and CSS Workshop, I had my doubts about this series, but I wanted to give this one a try, because I loved sql programming but I haven't used it in years.
I finished the first chapter and I had enough of this course. From introduction to creating your first database it doesn't even mention which program you should be using and how to get to the screen for entering the statements. It was easy for me, but for someone new to this it creates an unnecessary hurdle. A wrong image was used to show the result of an exercise, typos in query statements and the quiz contained questions about topics that weren't even mentioned in the first chapter and from more advanced chapters. What am I, a proofreader? I would rather read the reference manual than continue with this book.
Displaying 1 of 1 review