LEADER 01134nam 2200373 450 001 9910793990303321 005 20230817182831.0 010 $a1-64461-798-6 035 $a(CKB)4100000009587613 035 $a(MiAaPQ)EBC5930218 035 $a(EXLCZ)994100000009587613 100 $a20191204d2019 uy 0 101 0 $ager 135 $aurcnu|||||||| 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aWesteuropa?ische Buchmalerei des 8. bis 16. Jahrhunderts /$fTamara Woronowa, Andrej Sterligov 210 1$aNew York :$cParkstone Press USA,$d[2019] 215 $a1 online resource (256 pages) 311 $a1-904310-48-6 320 $aIncludes bibliographical references. 606 $aManuscripts, European 615 0$aManuscripts, European. 676 $a091 700 $aWoronowa$b Tamara P.$01570741 702 $aSterligov$b A$g(Andrei?), 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910793990303321 996 $aWesteuropa?ische Buchmalerei des 8. bis 16. Jahrhunderts$93844594 997 $aUNINA LEADER 03799nam 22006735 450 001 9910743682203321 005 20251008165033.0 010 $a9781484296851 010 $a1484296850 024 7 $a10.1007/978-1-4842-9685-1 035 $a(MiAaPQ)EBC30728634 035 $a(Au-PeEL)EBL30728634 035 $a(DE-He213)978-1-4842-9685-1 035 $a(OCoLC)1396696419 035 $a(OCoLC-P)1396696419 035 $a(PPN)272741124 035 $a(CaSebORM)9781484296851 035 $a(CKB)28152177500041 035 $a(Perlego)4515748 035 $a(EXLCZ)9928152177500041 100 $a20230904d2023 u| 0 101 0 $aeng 135 $aurcnu|||||||| 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aLeveling Up with SQL $eAdvanced Techniques for Transforming Data into Insights /$fby Mark Simon 205 $a1st ed. 2023. 210 1$aBerkeley, CA :$cApress :$cImprint: Apress,$d2023. 215 $a1 online resource (466 pages) 300 $aDescription based upon print version of record. 300 $aMore Details on Calculations 311 08$a9781484296844 311 08$a1484296842 327 $aChapter 1: Getting Ready -- Chapter 2: Working with Table Design -- Chapter 3: Table Relationships and Working With Joins -- Chapter 4: Working with Calculated Data -- Chapter 5: Aggregating Data -- Chapter 6: Creating and Using Views and Friends -- Chapter 7: Working With Subqueries and Common Table Expressions -- Chapter 8: Working With Window Functions.-Chapter 9: More on Common Table Expressions -- Chapter 10: More Techniques with SQL: Triggers, Pivot Tables, and Variables -- Appendix A. 330 $aLearn to write SQL queries to select and analyze data, and improve your ability to manipulate data. This book will help you take your existing skills to the next level. Author Mark Simon kicks things off with a quick review of basic SQL knowledge, followed by a demonstration of how efficient SQL databases are designed and how to extract just the right data from them. You?ll then learn about each individual table?s structure and how to work with the relationships between tables. As you progress through the book, you will learn more sophisticated techniques such as using common table expressions and subqueries, analyzing your data using aggregate and windowing functions, and how to save queries in the form of views and other methods. This book employs an accessible approach to work through a realistic sample, enabling you to learn concepts as they arise to improve parts of the database or to work with the data itself. After completing this book, you will have a more thorough understanding of database structure and how to use advanced techniques to extract, manage, and analyze data. You will: Gain a stronger understanding of database design principles, especially individual tables Understand the relationships between tables Utilize techniques such as views, subqueries, common table expressions, and windowing functions. 606 $aDatabase management 606 $aData mining 606 $aMicrosoft software 606 $aMicrosoft .NET Framework 606 $aDatabase Management 606 $aData Mining and Knowledge Discovery 606 $aMicrosoft 615 0$aDatabase management. 615 0$aData mining. 615 0$aMicrosoft software. 615 0$aMicrosoft .NET Framework. 615 14$aDatabase Management. 615 24$aData Mining and Knowledge Discovery. 615 24$aMicrosoft. 676 $a005.74 700 $aSimon$b Mark$01367136 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910743682203321 996 $aLeveling up with SQL$93559864 997 $aUNINA