Böcker av Joel Murach

If you're developing applications that access Oracle databases, you can save time and effort by having the database do more work for you. That's where this book comes in.This book teaches you how to write SQL statements to efficiently retrieve and update the data in an Oracle database. It teaches you how to design and create a database because that provides insight into performance and security issues. It teaches you how to use Oracle's procedural language (PL/SQL) to take advantage of powerful features like transactions, stored procedures, functions, and triggers. And it teaches you how to host an Oracle database in the cloud and use SQL Developer to run SQL statements against that database.The result? You'll learn how to write the kind of SQL and PL/SQL that makes you a more effective and valuable developer or analyst.

The latest edition of Murach's classic SQL Server book does a better job than ever of teaching the SQL statements that every database developer should know. Each chapter features clear examples, easy-to-understand explanations, best practices, and helpful tips. To start, this book presents the SQL statements for retrieving and updating the data in a database. These are the SQL statements that you'll use every day. Then, it shows how to design a database, how to implement that design, and how to work with database features like views, scripts, stored procedures, functions, triggers, transactions, and security. Finally, it shows how to work with an Azure SQL database that runs in the cloud as a service that's available from the Azure cloud computing platform. The result? You'll be able to write SQL that's thoroughly professional, and you'll be able to work far more effectively than most of your colleagues. Every Murach book guarantees high quality. The realistic examples show how each feature works in context. The exercises at the end of each chapter let you gain valuable hands-on experience. And the distinctive "paired-pages" format is ideal for learning and reference.

The 8th Edition of Murach's C# does a better job than ever of teaching the C# programming language. Each section features clear examples and easy-to-understand explanations that walk you through crucial skills, best practices, and helpful tips.

This 2nd Edition of Murach's ASP.NET Core MVC does a better job than ever of delivering the skills you need to develop websites using the MVC (Model-View-Controller) pattern with ASP.NET Core. If you know the basics of C#, you'll quickly learn to code the way today's top web professionals do. Each section features clear, beginner-friendly examples and easy-to-understand explanations that walk you through crucial skills, best practices, and helpful tips.

Now you can learn C++ in manageable chunks with Murach''s C++ Programming and its distinctive "paired-pages" format, which has earned rave reviews from programmers (see the reviews of the 1st Edition). Each topic is presented in a 2-page spread: You get clear syntax and coding examples along with easy-to-understand bullets on the righthand page and in-depth explanations and perspective on the left. Not only does this format ease the learning curve, it''s a time-saver for on-the-job reference too.What''s more, we''ve taken advantage of language advances and modern techniques to make it easier to learn C++ than ever before. This book is organized in a logical way that gets you started fast with a practical subset of today''s C++. Then, it presents coding and object-oriented programming skills that will elevate you to the professional level. With this strong foundation in place, later chapters cover legacy techniques and older C++ features that let you maintain the vast amount of legacy code in the world and work with embedded systems.New in this 2nd Edition are features that have been introduced in C++20. That includes brand-new material on modules, one of the most exciting new features added to C++ in years. As always, each feature is carefully explained and integrated where it belongs in the learning sequence so that beginners and experienced programmers alike can quickly grasp the new concepts and their advantages.Every Murach book guarantees high quality and our readers love our "code that actually works." See why yourself with more than 50 realistic programs to study and practice exercises for hands-on experience. You''ll have a hard time finding such effective examples anywhere else.New in this 2nd Edition are features that have been introduced in C++20. That includes brand-new material on modules, one of the most exciting new features added to C++ in years. As always, each feature is carefully explained and integrated where it belongs in the learning sequence so that beginners and experienced programmers alike can quickly grasp the new concepts and their advantages.

Whether Java is your 1st language or whether you've lost count, this is the right book for you. If you're new to programming, the self-paced approach lets you absorb all that's required of a programmer as you learn Java itself, with plenty of practice exercises along the way. If you're an experienced programmer, the same approach lets you skim through the familiar to focus on what's new, helping you learn Java faster and better than you've ever learned a language before. At the end, you'll have the Java skills you need on the job, including those for object-oriented, database, and GUI programming.

This C# book has been a favourite of developers ever since the 1st edition came out in 2004. So you can be sure that this latest edition will deliver the professional skills youre looking for today. In fact, it will teach you the C# essentials more easily than ever, as it shows you how to take advantage of the most recent releases of C#, .NET, and Visual Studio. Its a self-paced book that shows you how to use Visual Studio, C#, and the .NET classes to develop Windows Forms applications whether you are new to programming or not. Its an object-oriented book that shows you how to use business classes, inheritance, and interfaces the way theyre used in the real world. Its a database programming book that shows you how to create professional database applications using Entity Framework and LINQ or ADO.NET. When you are done, you will be able to develop 3-tiered, object-oriented, Windows Forms applications the way the best professionals do. And you will have the essential skills that you need to develop any C# application whether for the desktop, the web, or mobile devices.

If you know the basics of C#, you're ready to learn how to create web applications using Microsoft's powerful technology, ASP.NET Core MVC (Model-View-Controller). And there's no more practical way to do it than with this book. By the end of section 1]€]just 5 chapters]€]you'll be developing real-world web apps using C# code for the model and controller classes]€]HTML, CSS, and Razor code for the view files (for the user interface)]€]and Bootstrap classes for responsive design so that your apps adapt well to all screen sizes. You'll also be able use the debugging tools in Visual Studio and your browser to test your apps and make sure they'll work right for all users. In section 2, you'll build out that set of skills to create more complex controllers, work with Razor views, handle cookies and sessions, do model binding, validate data, and handle database data with EF (Entity Framework) Core. You'll also see how all these skills come together in a single application, with coverage of the "gotchas" that can occur and how to solve them. Finally, in section 3, you can pick up additional skills as you need them to: create custom tag helpers and view components; authenticate and authorize users; use dependency injection to automate testing; and use Visual Studio Code. All along the way, you'll get complete web apps that show you how each feature works in context (you can download these for free from the Murach website). You'll get chapter exercises that let you practice your new skills. And you'll get Murach's distinctive "paired-pages" format that presents each skill in a 2-page spread, full of examples, notes, and explanation]€]a format that developers praise because it saves them both training and reference time.

This is the latest edition of the book that application developers worldwide have used to master MySQL now updated for MySQL 8 and beyond. As you would expect, this book shows how to code all the essential SQL statements for working with a MySQL database. You will use these statements every day to have MySQL do more of your work for you. But beyond that, it shows how to work with classic MySQL features that take you to new level, such as summary queries, subqueries, functions, views, transactions, stored procedures, triggers, and security. It shows how to take advantage of newer MySQL features such as window functions, Common Table Expressions (CTE), and roles for database security. It shows how to design a database, including how to use MySQL Workbench to create and implement the design. It even presents a starting set of skills for a database administrator (DBA) if you are interested in that career path or if you need to be your own DBA. In short, its a must-have guide for anyone who works with MySQL, beginning and experienced developers alike.

C++ was first released in 1985, and it was a hard language to learn. That's because it required programmers to master low-level techniques to work with memory. Over the years, C++ has evolved to provide many higher-level techniques that make it much easier to write effective C++ code. But most C++ books haven't evolved with the language. Now, Murach's top authors have tackled the subject, rethinking the whole approach. So this book takes advantage of the modern techniques to make it easier to learn C++ than ever before. It's organized in a logical way that gets you off to a fast start with a practical subset of today's C++, and then builds out your coding and OOP skills to the professional level. With that foundation in place, it also covers older techniques so you'll be able to maintain the vast amount of legacy code that's out there, as well as work with embedded systems that don't support the newer techniques. To make all that manageable, this book uses Murach's distinctive "paired-pages" format that programmers find so helpful for both training and reference: Each topic is presented in a 2-page spread, with syntax, coding examples, and bulleted guidelines on the righthand page and extra explanation and perspective on the left. What's more, this book gives you 50+ realistic program examples to study, as well as practice exercises for hands-on experience. Examples and exercises like these are the key to learning any programming language. But you'll have a hard time finding such effective ones in other books and courses, that deliver the skills ours do.

This practical, hands-on tutorial/reference/guide to MySQL is perfect for beginners, but it also works for experienced developers who are not getting the most from MySQL. As you would expect, this book shows how to code all of the essential SQL statements for creating and working with a MySQL database. But beyond that, this book also shows how to design a database, including how to use the graphical MySQL Workbench to create an EER model. It shows how to take advantage of relatively new MySQL features such as foreign keys, transactions, stored procedures, stored functions, triggers, and events. It even presents a starting set of skills for a database administrator (DBA), including how to secure and back up databases. And like all Murach books, it uses the distinctive "paired pages" format, which breaks the material into manageable skills to speed up both learning and reference. A great help for MySQL users at any level.

This new edition makes it easier than ever for Java developers to master web programming. It shows how to install and use the Tomcat server and the NetBeans IDE. It shows how to use JSP's and servlets to build secure and well-structured web applications that implement the MVC pattern. It shows how to use sessions, cookies, JavaBeans, EL, JSTL, and custom tags. It shows how to use JDBC or JPA to work with a MySQL database. It shows how to work with JavaMail, SSL connections, authentication, encryption, filters, and listeners. It even includes an introduction to JSF to expand your perspective on Java web programming. These are the skills that you need to build professional Java web applications using servlets and JSP. A great read for any Java developer.