• Fri frakt över 249 kr
  • •
  • Snabba leveranser
  • •
  • Billiga böcker
Kundservice

Du är på sajten för privatpersoner.

Företag, bibliotek eller offentlig verksamhet?

Du handlar på classic.bokus.com, där alla dina funktioner finns intakta.
Till classic.bokus.com
Bokus logotyp. Gå till startsidan.
  • Erbjudanden
  • Student
  • Topplistor
  • Barn & ungdom
  • Bokus Play
  • E-böcker
  • Ljudböcker
  • Pocketböcker
  • Spel och pussel

5% studentrabatt – använd koden KURSBOK27 →

Sidfot

Mina sidor

    Hjälp

    • Kundservice
    • Vanliga frågor och svar
    • Frakt och leverans
    • Retur vid ångerrätt
    • Reklamera vara
    • Betalning
    • Köpvillkor
    • Allmänna villkor
    • Information om webbplatsens tillgänglighet

    Om Bokus

    • Om oss
    • Pressrum
    • För studenter
    • För företag
    • För bibliotek och offentlig verksamhet
    • För leverantörer
    • Hållbarhet

    Populärt

    • Aktuella erbjudanden
    • Presentkort
    • Studentlitteratur
    • Nya böcker
    • Topplistor
    • Signerade böcker
    • Engelska böcker

    Inspiration

    • Boktips
    • BookTok
    • Barnbokskaraktärer
    • Populära författare
    Logotyp för Bokus
    Följ oss på Facebook (extern länk)Följ oss på Instagram (extern länk)Följ oss på YouTube (extern länk)Följ oss på TikTok (extern länk)
    bokus @ CookiesAnpassa cookiesIntegritetspolicyKöpvillkor
    Till Citymail hemsida (extern länk)Till Budbee hemsida (extern länk)Till Postnord hemsida (extern länk)Till Schenker hemsida (extern länk)Till Early Bird hemsida (extern länk)Till Walleys hemsida (extern länk)
    1. Data och IT
    2. Programmeringsböcker

    SQL Workshop

    Learn to create, manipulate and secure data and manage relational databases with SQL

    AvFrank Solomon,Rakesh Kumar Pandey

    Häftad, Engelska, 2019

    454 kr

    Beställningsvara. Skickas inom 5-8 vardagar. Fri frakt över 249 kr.

    Beskrivning

    Get to grips with SQL fundamentals and learn how to efficiently create, read and update information stored in databasesKey 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.

    Produktinformation

    • Utgivningsdatum:2019-12-30
    • Mått:191 x 235 x 16 mm
    • Vikt:543 g
    • Format:Häftad
    • Språk:Engelska
    • Antal sidor:288
    • Förlag:Packt Publishing Limited
    • ISBN:9781838642358

    Utforska kategorier

    • Programmeringsböcker inom Data och IT

    Mer om författaren

    Frank Solomon started out building front-end and database software with Microsoft stack tools such as SQL Server and ASP and then extended into ASP.NET, C#, VB.NET, JavaScript, and more. He learns about new products, languages, and technologies all the time, and he pushed into technical writing as a way to present and express his research and discoveries. He works as a contractor right now. He has worked in start-ups himself, and he knows that the hard work of writers and developers makes the end user experience easier. Contacted by Ankita Thakur on Feb, 20, 2020 Contacted as a TR for Splunk 7 Essentials, Third Edition on April 23, 2019 by Sneha Shinde Prashanth Jayaram is a database technologist, blogger, engineering lead, automation expert, TechNet wiki ninja, PowerShell Geek, and technologist enthusiast with extensive experience in designing database solutions. He is the author of PowerShell 6.0 Linux Administration Cookbook and has hands-on experience with the next generation database technologies. He has been awarded as ABOVE and BEYOND and Best SQL Author 2018 towards his contribution to SQL Server technology. He has articulated over 200+ articles widespread across SQL, NoSQL, PowerShell, Python, SQL on Linux, SQL on Azure, and SQL on AWS arenas. Awni Al Saqqa is a Microsoft Technology Specialist in MS SQL Server and a certified solutions developer since 2007. He has over a decade of experience with database development and administration on SQL Server, Oracle, and MySQL. He is a solutions architect, who is hands-on in many enterprise projects for different business sectors, such as education, hospitality, retail, manufacturing, marketing, and more, which has given him the perfect combination between business and technical experience. Fiodar Sazanavets is an experienced lead software developer. His main areas of expertise are ASP.NET, SQL Server, Azure, Docker, Internet of Things, microservices architecture, and various frontend technologies. Fiodar built his software engineering experience while working in a variety of industries, including water engineering, financial, railway, and defense. He has played a leading role in various projects and, as well as writing software, his duties have included performing architectural tasks. Fiodar is passionate about teaching other people programming skills. He has published a number of programming courses on various online platforms. Aaditya Pokkunuri is an experienced senior database engineer with a demonstrated history of working in the information technology and service industry, with over 11 years of experience. He is skilled in performance tuning, Microsoft SQL Database Server Administration, SSIS, SSRS, PowerBI, and SQL development. He possesses strong knowledge of replication, clustering, SQL Server high availability options, and ITIL processes. His expertise lies in Windows administration tasks, Active Directory, and Microsoft Azure technologies. He has expertise in AWS Cloud and is an AWS Solution Architect Associate as well. Aaditya is a strong information technology professional with a Bachelor of Technology degree focused on computer science and engineering from Sastra University, Tamil Nadu. Shashikant Shakya is a passionate technologist with decades of experience in the sphere of databases. He works for Microsoft as a senior support engineer. In his day job, he works on Azure SQL Database, Azure Database for MySQL, and PostgreSQL. Apart from his work, he is a regular speaker at the SQLBangalore community group. Contacted for Ruby on October 7, 2019 by Sneha Shinde Contacted for JDS on Feb 22, 2019 by Sneha Shinde as TR Scott Cosentino is a software developer and teacher currently working in computer security. Scott has worked extensively with both low- and high-level languages, working on operating system- and enterprise-level applications. Scott has a passion for teaching and currently writes and creates videos on computer security and other programming topics. He has developed an extensive library of courses and has taught over 45,000 students through courses with Udemy, Packt, and CodeRed. He maintains a blog on Medium, and is active on YouTube and LinkedIn, where he enjoys creating content and interacting with students.

    Innehållsförteckning

    • Table of ContentsIntroduction to SQLManipulating DataDatabase NormalizationThe SELECT StatementShaping Data with the WHERE ClauseJOINSTaking Queries to the Next LevelSQL ProgrammingSecurityAggregate FunctionsFunctions and Transactions