SQL and Data: The Step-by-Step guide you need in learning how to manipulate and analyze data and information for Beginners

SQL and Data: The Step-by-Step guide you need in learning how to manipulate and analyze data and information for Beginners

In today’s society, data is a very part of any business, institution and/or organization. Data can increase exponentially day-by-day (Big data) and such, knowing how to arrange and analyze it is very important.

Therefore, are you seeking to join an organization where you would be in a position of handling data effectively and efficiently or do you want to become a database administrator but don’t have the basic knowledge? Then this book is for you.

You will learn how to generate, manipulate and retrieve data using SQL in Microsoft Access.

What does this book provide?

• Brief but comprehensive Concepts in SQL
• A Step-by-Step guide with lots of examples and pictures
• Challenges at the end of each chapter to test your knowledge on a particular topic
• Accompanying videos and resources to help boost your confidence in using SQL

What will you learn by reading this book?

You will learn:

• What data, database objects, SQL etc. are
• Creating database and tables using SQL in Microsoft Access
• Inserting Data into tables
• Updating Data using SQL
• Deleting Data using SQL
• DROP tables
• Selecting and Filtering data
• Aggregate Functions
• Wildcards
• Subqueries
• Joins
• Constraints
• SQL Reports and Forms etc.

Remember, you can also use this book as a reference or a guide that provides the foundational skills needed in creating and analyzing any of your database projects.