Scott Cosentino – författare
Visar alla böcker från författaren Scott Cosentino. Handla med fri frakt och snabb leverans.
3 produkter
3 produkter
SQL Workshop
Learn to create, manipulate and secure data and manage relational databases with SQL
Häftad, Engelska, 2019
446 kr
Skickas inom 5-8 vardagar
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.
Java Workshop
Learn object-oriented programming and kickstart your career in software development
Häftad, Engelska, 2019
573 kr
Skickas inom 5-8 vardagar
Get to grips with the fundamentals of Java programming and learn to build useful applications with the help of real-world examples and engaging practical activitiesKey FeaturesBuild a solid foundation in Java and focus on developing real-world applicationsImplement the fundamental concepts of object-oriented programming in your codeWork with external data storage systems and learn how to efficiently handle dataBook DescriptionJava is a versatile, popular programming language used across a wide range of industries. Learning how to write effective Java code can take your career to the next level, and The Java Workshop will help you do just that. This book is designed to take the pain out of Java coding and teach you everything you need to know to be productive in building real-world software.The Workshop starts by showing you how to use classes, methods, and the built-in Collections API to manipulate data structures effortlessly. You’ll dive right into learning about object-oriented programming by creating classes and interfaces and making use of inheritance and polymorphism. After learning how to handle exceptions, you’ll study the modules, packages, and libraries that help you organize your code. As you progress, you’ll discover how to connect to external databases and web servers, work with regular expressions, and write unit tests to validate your code. You’ll also be introduced to functional programming and see how to implement it using lambda functions. By the end of this Workshop, you’ll be well-versed with key Java concepts and have the knowledge and confidence to tackle your own ambitious projects with Java.What you will learnWrite clean, well-commented Java code that's easy to maintainDebug logical errors and handle exceptions in your Java programsImplement object-oriented and functional programming paradigmsUse regular expressions to search for information in text dataWork with information stored in databases using JDBCMake HTTP requests from Java applications and parse the response dataSecure your data with cryptography and encryptionWrite unit tests to validate your code with JUnitWho this book is forThis Java coding book is designed for anyone who is new to Java. Whether you’re an aspiring software developer, or are just curious about learning to code, then this book will get you on the right track. No prior programming experience is required.
MySQL Workshop
A practical guide to working with data and managing databases with MySQL
Häftad, Engelska, 2022
414 kr
Skickas inom 5-8 vardagar
Learning MySQL just got a whole lot easier, thanks to this hands-on workshop, complete with simple explanations, engaging examples, and realistic exercises that focus on helping you to build and maintain databases effectivelyKey FeaturesLearn how to set up and maintain a MySQL databaseRun SQL queries to create, retrieve, and manipulate dataUse MySQL effectively with common business applications such as Excel and MS AccessBook DescriptionDo you want to learn how to create and maintain databases effectively? Are you looking for simple answers to basic MySQL questions as well as straightforward examples that you can use at work? If so, this workshop is the right choice for you.Designed to build your confidence through hands-on practice, this book uses a simple approach that focuses on the practical, so you can get straight down to business without having to wade through pages and pages of dull, dry theory.As you work through bite-sized exercises and activities, you'll learn how to use different MySQL tools to create a database and manage the data within it. You'll see how to transfer data between a MySQL database and other sources, and use real-world datasets to gain valuable experience of manipulating and gaining insights from data. As you progress, you'll discover how to protect your database by managing user permissions and performing logical backups and restores.If you've already tried to teach yourself SQL, but haven't been able to make the leap from understanding simple queries to working on live projects with a real database management system, The MySQL Workshop will get you on the right track.By the end of this MySQL book, you'll have the knowledge, skills, and confidence to advance your career and tackle your own ambitious projects with MySQL.What you will learnUnderstand the concepts of relational databases and document storesUse SQL queries, stored procedures, views, functions, and transactionsConnect to and manipulate data using MS Access, MS Excel, and Visual Basic for Applications (VBA)Read and write data in the CSV or JSON format using MySQLManage data while running MySQL Shell in JavaScript modeUse X DevAPI to access a NoSQL interface for MySQLManage user roles, credentials, and privileges to keep data securePerform a logical database backup with mysqldump and mysqlpumpWho this book is forThis book is for anyone who wants to learn how to use MySQL in a productive, efficient way. If you’re totally new to MySQL, it'll help you get started or if you've used MySQL before, it'll fill in any gaps, consolidate key concepts, and offer valuable hands-on practice. Prior knowledge of simple SQL or basic programming techniques will help you in quickly grasping the concepts covered, but is not necessary.