Techniki programowania
Baya Dewald
Microsoft SQL Server is a relational database management system. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications. SQL Server Analysis Services adds OLAP and data mining capabilities for SQL Server databases. OLAP (online analytical processing) is a technique for analyzing business data for effective business intelligence.This practical guide teaches you how to build business intelligence solutions using Microsoft’s core product – SQL Server Analysis Services. The book covers the traditional multi-dimensional model which has been around for over a decade as well as the tabular model introduced with SQL Server 2012.Starting with comparing MultiDimensional and tabular models – discussing the values and limitations of each, you will then cover the essential techniques for building dimensions and cubes. Following on from this, you will be introduced to more advanced topics, such as designing partitions and aggregations, implementing security, and synchronizing databases for solutions serving many users.The book also covers administrative material, such as database backups, server configuration options, and monitoring and tuning performance. We also provide a primer on MultiDimensional eXpressions (MDX) as well as Data Analysis expressions (DAX) languages.This book provides you with data cube development techniques, and also the ongoing monitoring and tuning for Analysis Services.
Rheinwerk Publishing, Inc, Kerem Koseoglu
This book starts with an introduction to the fundamentals of SQL and relational databases, including key concepts like tables, schemas, and data types. It provides a solid foundation for beginners, guiding readers through the setup process, including local database installation and SQL IDE configuration.As the book progresses, it dives into SQL operations, such as creating and manipulating databases, tables, and views using Data Definition Language (DDL). Readers will explore Data Manipulation Language (DML) to insert, update, and delete data, as well as learn about stored procedures, triggers, and automation techniques.The final sections focus on advanced topics like transaction control, data querying, and data control. Readers will gain in-depth knowledge of SQL queries, including complex operations such as joins, subqueries, and window functions. The book concludes with database security, user access control, and best practices for maintaining data integrity. By the end, readers will be equipped to apply SQL in real-world applications, ensuring efficient, secure, and optimized database management.
Stwórz Grę Aplikacje Mobilne ES6+ JavaScript React Native - Hooks
poswojsku.pl
Witaj w poradniku wydawnictwa poswojsku.pl, dzięki któremu wspólnie zaprogramujemy grę mobilną Falling Jumping Shapes. Stworzymy projekt od pomysłu przez grafikę, aż do kompleksowego zaprogramowania w najwspanialszym języku programowania: JavaScript. Aby jednak to osiągnąć, najpierw nauczę Ciebie podstaw kilku niesamowitych technologii: nowoczesnej odmiany JavaScript, czyli tzw. ES6+, React Native, React, CSS w wersji do aplikacji mobilnej, Android. Aplikacje będziemy tworzyli w IDE: VSCodium lub możesz użyć inny edytor kodu, np. Visual Studio Code. Poradnik zawiera kod gry wraz z omówieniem oraz podstawową wiedzę niezbędną do tworzenia aplikacji mobilnych za pomocą frameworka React Native - Część II Aplikacje Mobilne Wprowadzenie. Ale jeżeli posiadasz już podstawy wiedzy, możesz od razu przejść do tworzenia gry. OPIS GRY DO WYKONANIA Planujemy zbudować grę, posiadającą trzy poziomy, a właściwie warianty: prosty - nazwijmy go SIMPLE oraz przypiszmy do niego oznaczenie 'zero' trudniejszy - nazwijmy go MEDIUM oraz przypiszmy do niego oznaczenie 'one' nieco szalony - nazwijmy go CRAZY oraz przypiszmy do niego oznaczenie 'two' Użyłem określenia 'warianty' a nie poziomy, gdyż można uruchomić każdy z nich bez względu na przejście przez poprzedni. Technicznie rzecz ujmując będą to trzy zupełnie niezależne od siebie gry, ale oparte na podobnym wyglądzie oraz grafice. Gracz będzie miał za zadanie kliknięcie w spadającą kulkę, tyle razy, aby wyszła za jedną z bocznych krawędzi. Zasady gry są bardzo proste: Wybierając z menu nawigacyjnego jeden z wariantów, Gracz rozpocznie grę, Po kliknięciu w przycisk START GAME pojawia się na górnej krawędzi kulka o losowym kolorze, Kulka opada powoli w dół, Gracz ma za zadanie kliknąć kulkę, a ona za każdym kliknięciem zmienia swoją pozycję w poziomie (w sposób losowy w lewo lub prawo - zgodnie z logiką zapisaną w kodzie JavaScript), Gdy kulka wyjedzie za lewą lub prawą krawędź - Gracz uzyskuje punkt - trzeba: uruchomić Zliczanie Punktów, kulka ponownie musi wrócić powyżej górnej krawędzi, aby rozpocząć swobodne spadanie, ale już w innym kolorze oraz z większą szybkością niż poprzednio, Gracza trzeba poinformować o liczbie punktów, Gracza trzeba poinformować o tym, że idzie mu dobrze, Gdy kulka spadnie poniżej dolnej krawędzi, Gracz nie uzyskuje punktu: kulka ponownie musi wrócić powyżej górnej krawędzi, aby rozpocząć spadanie, ale już w innym kolorze, Gracza trzeba poinformować o tym, że nie wykonał poprawnie kliknięć w spadający obiekt, granicznik - maksymalna liczba punktów - po uzyskaniu określonej, założonej przez programistę liczby punktów, kończy się gra: Gracza trzeba poinformować, że gra się zakończyła bo uzyskał określoną liczbę punktów, Na ekranie powinien znowu pojawić się napis START GAME, gdyby chciał Gracz zagrać ponownie. INNE ?? tutaj jest miejsce na dalszy rozwój gry - dla Ciebie oraz Twojej kreatywności :).
Daniel Irvine
Svelte is a popular front-end framework used for its focus on performance and user-friendliness, and test-driven development (TDD) is a powerful approach that helps in creating automated tests before writing code. By combining them, you can create efficient, maintainable code for modern applications. Svelte with Test-Driven Development will help you learn effective automated testing practices to build and maintain Svelte applications.In the first part of the book, you’ll find a guided walkthrough on building a SvelteKit application using the TDD workflow. You’ll uncover the main concepts for writing effective unit test cases and practical advice for developing solid, maintainable test suites that can speed up application development while remaining effective as the application evolves. In the next part of the book, you’ll focus on refactoring and advanced test techniques, such as using component mocks and writing BDD-style tests with the Cucumber.js framework. In the final part of the book, you’ll explore how to test complex application and framework features, including authentication, Svelte stores, and service workers.By the end of this book, you’ll be well-equipped to build test-driven Svelte applications by employing theoretical and practical knowledge.
Dylan Hildenbrand
The JavaScript ecosystem has grown vast, complex, and daunting for newcomers. Fortunately, SvelteKit has emerged, simplifying the process of building JavaScript-based web applications. This book aims to demystify SvelteKit, making it as approachable as it makes web app development.With SvelteKit Up and Running you’ll be introduced to the philosophy and technologies underlying SvelteKit. First, you’ll follow a standard educational programming approach, progressing to a 'Hello World' application. Next, you’ll explore the fundamental routing techniques, data loading management, and user submission, all through real-world scenarios commonly encountered in day-to-day development, before discovering various adapters employed by SvelteKit to seamlessly integrate with diverse environments. You’ll also delve into advanced concepts like dynamic route management, error handling, and leveraging SvelteKit to optimize SEO and accessibility.By the end of this book, you’ll have mastered SvelteKit and will be well-equipped to navigate the complexities of web app development.
Swift 2 By Example. Create robust and extensible iOS apps using the advanced features of Swift 2
Giordano Scalzo
Swift is no longer the unripe language it was when launched by Apple at WWDC14, now it’s a powerful and ready-for-production programming language that has empowered most new released apps.Swift is a user-friendly language with a smooth learning curve; it is safe, robust, and really flexible.Swift 2 is more powerful than ever; it introduces new ways to solve old problems, more robust error handling, and a new programming paradigm that favours composition over inheritance.Swift 2 by Example is a fast-paced, practical guide to help you learn how to develop iOS apps using Swift. Through the development of seven different iOS apps and one server app, you’ll find out how to use either the right feature of the language or the right tool to solve a given problem.We begin by introducing you to the latest features of Swift 2, further kick-starting your app development journey by building a guessing game app, followed by a memory game. It doesn’t end there, with a few more apps in store for you: a to-do list, a beautiful weather app, two games: Flappy Swift and Cube Runner, and finally an ecommerce app to top everything off. By the end of the book, you’ll be able to build well-designed apps, effectively use AutoLayout, develop videogames, and build server apps.
Swift 3 New Features. Get up to date with what`s new in Swift 3
Keith Elliott
Since Swift was introduced by Apple in WWDC 2015, it has gone on to become one of the most beloved languages to develop iOS applications with. In the new version, the Swift team aimed to take its adoption to the next level by making it available for new platforms and audiences.This book will very quickly get you up to speed and productive with Swift 3. You will begin by understanding the process of submitting new feature requests for future versions of Swift. Swift 3 allows you to develop and run your applications on a Linux machine. Using this feature, you will write your first Linux application using the debugger in Linux. Using Swift migrator, you will initiate a conversion from Swift 2.2 to Swift 3. Further on, you will learn how to interact with Cocoa libraries when importing Objective C to Swift. You will explore the function and operator changes new to Swift 3, followed by Collection and Closure changes. You will also see the changes in Swift 3 that allow you write tests easier with XCTest and debug your running code better with new formats as well. Finally, you will have a running server written completely in Swift on a Linux box.By the end of the book, you will know everything you need to know to dive into Swift 3 and build successful projects.
Swift Data Structure and Algorithms. Implement Swift structures and algorithms natively
Erik Azar, Mario Eguiluz Alebicto
Apple’s Swift language has expressive features that are familiar to those working with modern functional languages, but also provides backward support for Objective-C and Apple’s legacy frameworks. These features are attracting many new developers to start creating applications for OS X and iOS using Swift. Designing an application to scale while processing large amounts of data or provide fast and efficient searching can be complex, especially running on mobile devices with limited memory and bandwidth. Learning about best practices and knowing how to select the best data structure and algorithm in Swift is crucial to the success of your application and will help ensure your application is a success. That’s what this book will teach you.Starting at the beginning, this book will cover the basic data structures and Swift types, and introduce asymptotic analysis. You’ll learn about the standard library collections and bridging between Swift and Objective-C collections. You will see how to implement advanced data structures, sort algorithms, work with trees, advanced searching methods, use graphs, and performance and algorithm efficiency. You’ll also see how to choose the perfect algorithm for your problem.