The SQL Workshop Ebook Tooltip Ebooks kunnen worden gelezen op uw computer en op daarvoor geschikte e-readers. Learn to create, manipulate and secure data and manage relational databases with SQL
- Engels
- E-book
- 9781838649081
- 30 december 2019
Samenvatting
Get to grips with SQL fundamentals and learn how to efficiently create, read and update information stored in databases
Key Features- Understand the features and syntax of SQL and use them to query databases
- Learn how to create databases and tables and manipulate the data within them
- Create advanced queries and apply them on realistic databases with hands-on activities
Many 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 learn- Create databases and insert data into them
- Use SQL queries to create, read, update, and delete data
- Maintain data integrity and consistency through normalization
- Customize your basic SQL queries to get the desired output
- Refine your database search using the WHERE and HAVING clauses
- Use joins to fetch data from multiple tables and create custom reports
- Improve web application performance by automating processes
- Secure a database with GRANT and REVOKE privileges
This 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.
Productspecificaties
Inhoud
- Taal
- en
- Bindwijze
- E-book
- Oorspronkelijke releasedatum
- 30 december 2019
- Illustraties
- Nee
Betrokkenen
- Hoofdauteur
- Frank Solomon
- Tweede Auteur
- Prashanth Jayaram
- Co Auteur
- Saqqa, Awni Al
- Hoofduitgeverij
- Packt Publishing
Lees mogelijkheden
- Lees dit ebook op
- Desktop (Mac en Windows) | Kobo e-reader | Android (smartphone en tablet) | iOS (smartphone en tablet) | Windows (smartphone en tablet)
Overige kenmerken
- Editie
- 1
- Studieboek
- Ja
EAN
- EAN
- 9781838649081
Je vindt dit artikel in
- Categorieën
- Taal
- Engels
- Boek, ebook of luisterboek?
- Ebook
- Beschikbaar in Kobo Plus
- Beschikbaar in Kobo Plus
- Beschikbaarheid
- Leverbaar
- E-book is direct beschikbaar na aankoop
- E-books lezen is voordelig
- Dag en nacht klantenservice
- Veilig betalen
Rapporteer dit artikel
Je wilt melding doen van illegale inhoud over dit artikel:
- Ik wil melding doen als klant
- Ik wil melding doen als autoriteit of trusted flagger
- Ik wil melding doen als partner
- Ik wil melding doen als merkhouder
Geen klant, autoriteit, trusted flagger, merkhouder of partner? Gebruik dan onderstaande link om melding te doen.