Products related to SQL:
-
SQL Programming
Essential Structured Query Language (ANSI SQL-99) six page laminated guide with core commands, statements, syntax and terms for support of beginners who are learning, and experts as a handy quick reference.Author Robin Nixon worked with computers in the 80s and started developing websites in the 90s becoming an expert and writing over 40 programming books and over 500 articles for top computer magazines.With his expertise in the field and writing to his audience in our succinct and organized QuickStudy format, this reference has more quality actionable facts per page than any book or website.Designed for quick access to the facts you need, this inexpensive tool has been a best seller for over 10 years and is an easy add to your programming toolbox.
Price: 7.99 £ | Shipping*: 3.99 £ -
Microsoft SQL Server 2019 - Querying SQL Server
Course Description This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server. You will learn how to write queries that return data from tables as well as create, update, or delete data in a database. These queries will allow filtering and sorting and effectively use the various data types provided by SQL Server. This course also covers the use of dynamic tables of various sorts which can allow a more sophisticated SQL user to hide implementation details from other end users accessing data from reporting tools. Finally, the course will provide details on the what and how of error handling and transaction management. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. The primary target audience for this course is: Database Administrators, Database Developers and BI professionals. In this course, you will learn how to: Understand the similarities and differences between Transact-SQL and other computer languages. Write SELECT queries Query multiple tables Sort and filter data Describe the use of data types in SQL Server Modify data using Transact-SQL Use built-in functions Group and aggregate data Use subqueries Use table expressions Use set operators Use window ranking, offset and aggregate functions Implement pivoting and grouping sets Execute stored procedures Program with T-SQL Implement error handling Implement transactions Instructor: James Ring-HowellCourse Video Content: 10 Hours 5 MinutesTest Questions: 75 Course Content Module 1 - Query Tools1.1 Course Introduction1.2 Module 1 Introduction1.3 Intro to Management Studio1.4 Intro to command-line query toolsModule 2 - Introduction to T-SQL Querying2.1 Module 2 Introduction2.2 Introducing T-SQL2.3 Understanding Sets2.4 Understanding the Logical Order of Operations in SELECT statementsModule 3 - Basic SELECT Queries3.1 Module 3 Introduction3.2 Writing Simple SELECT Statements3.3 Eliminate Duplicates with DISTINCT3.4 Using Column and Table Aliases3.5 Write Simple CASE ExpressionsModule 4 - Querying Multiple Tables4.1 Module 4 Introduction4.2 Understanding Joins4.3 Querying with Inner Joins4.4 Querying with Outer Joins4.5 Querying with Cross Joins and Self JoinsModule 5 - Sorting and Filtering Data5.1 Module 5 Introduction5.2 Sorting Data5.3 Filtering Data with Predicates5.4 Filtering with the TOP and OFFSET-FETCH5.5 Working with Unknown ValuesModule 6 - Working with SQL Server Data Types6.1 Module 6 Introduction6.2 Writing Queries that return Date and Time Data6.3 Writing Queries that use Date and Time Functions6.4 Writing Queries that return Character Data6.5 Writing Queries that use Character FunctionsModule 7 - Using DML to Modify Data7.1 Module 7 Introduction7.2 Inserting Records with DML7.3 Updating Records Using DML7.4 Deleting Records Using DMLModule 8 - Using Built-In Functions8.1 Module 8 Introduction8.2 Writing Queries with Built-In Functions8.3 Using Conversion Functions8.4 Using Logical Functions8.5 Using Functions to Work with NULLModule 9 - Grouping and Aggregating Data9.1 Module 9 Introduction9.2 Using Aggregate Functions9.3 Using the GROUP BY Clause9.4 Filtering Groups with HAVINGModule 10 - Using Subqueries10.1 Module 10 Introduction10.2 Writing Self-Contained Subqueries10.3 Writing Correlated Subqueries10.4 Using the EXISTS Predicate with SubqueriesModule 11 - Using Table Expressions11.1 Module 11 Introduction11.2 Using Views11.3 Using Inline Table-Valued Functions11.4 Using Derived Tables11.5 Using Common Table ExpressionsModule 12 - Using Set Operators12.1 Module 12 Introduction12.2 Writing Queries with the UNION operator12.3 Using EXCEPT and INTERSECT12.4 Using APPLYModule 13 - Using Window Ranking, Offset, and Aggregate Functions13.1 Module 13 Introduction13.2 Creating Windows with OVER13.3 Exploring Window FunctionsModule 14 - Pivoting and Grouping Sets14.1 Module 14 Introduction14.2 Writing Queries with PIVOT and UNPIVOT14.3 Working with Grouping SetsModule 15 - Implementing Error Handling15.1 Module Introduction15.2 Implementing T-SQL error handling15.3 Implementing structured exception handlingModule 16 - Managing Transactions16.1 Module 16 Introduction16.2 Transactions and the Database Engine16.3 Controlling Transactions16.4 Course Wrap Up LEARN365 Courses Include 12 Months Unlimited Online Access to: Expert Instructor-Led Training: Learn 365 uses only the industry's finest instructors in the IT industry. They have a minimum of 15 years real-world experience and are subject matter experts in their fields. Unlike a live class, you can fast-forward, repeat or rewind all your lectures. This creates a personal learning experience and gives you all the benefit of hands-on training with the flexibility of doing it around your schedule 24/7. Visual Demonstrations andamp; Multimedia Presentations: Our courseware includes instructor-led demonstrations and visual presentations that allow students to develop their skills based on real world scenarios explained by the instructor. Learn 365 always focuses on real world scenarios and skill-set development. Quizzes andamp; Exam Simulators: Learn 365's custom practice exams prepare you for your exams differently and more effectively than the traditional exam preps on the market. You will have practice quizzes after each module to ensure you are confident on the topic you have completed before proceeding. This will allow you to gauge your effectiveness before moving to the next module in your course. Learn 365 courses also include practice exams designed to replicate and mirror the environment in the testing center. These exams are on average 100 questions to ensure you are 100% prepared before taking your certification exam. Need to train your Team? Contact Us for Discounts on Multiple Subscription Purchases.
Price: 59.00 £ | Shipping*: £ -
Joe Celko's SQL for Smarties : Advanced SQL Programming
SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert.Now, 20 years later and in its fifth edition, this classic reference still reigns supreme as the only book written by a SQL master that teaches programmers and practitioners to become SQL masters themselves!These are not just tips and techniques; also offered are the best solutions to old and new challenges.Joe Celko conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance.New to the fifth edition, Joe features new examples to reflect the ANSI/ISO Standards so anyone can use it.He also updates data element names to meet new ISO-11179 rules with the same experience-based teaching style that made the previous editions the classics they are today.You will learn new ways to write common queries, such as finding coverings, partitions, runs in data, auctions and inventory, relational divisions and so forth.SQL for Smarties explains some of the principles of SQL programming as well as the code.A new chapter discusses design flaws in DDL, such as attribute splitting, non-normal forum redundancies and tibbling.There is a look at the traditional acid versus base transaction models, now popular in NoSQL products.You’ll learn about computed columns and the DEFERRABLE options in constraints.An overview of the bi-temporal model is new to this edition and there is a longer discussion about descriptive statistic aggregate functions.The book finishes with an overview of SQL/PSM that is applicable to proprietary 4GL vendor extensions.
Price: 50.99 £ | Shipping*: 0.00 £ -
Oracle PL/SQL Programming
This book is the definitive reference on PL/SQL, considered throughout the database community to be the best Oracle programming book available.Like its predecessors, this 6th edition of Oracle PL/SQL Programming covers language fundamentals, advanced coding techniques, and best practices for using Oracle's powerful procedural language.Thoroughly updated for Oracle Database 12c, this edition reveals new PL/SQL features and provides extensive code samples, ranging from simple examples to complex and complete applications, in the book and on the companion website.It's an indispensable reference for both novices and experienced Oracle programmers.
Price: 63.99 £ | Shipping*: 0.00 £
-
Is the SQL Community Server package damaged on the Fedora server?
To determine if the SQL Community Server package is damaged on the Fedora server, you can run the following command in the terminal: "sudo dnf check". This command will check for any problems with the installed packages, including the SQL Community Server package. If there are any issues with the package, the command will provide information on how to fix them. Additionally, you can also use the "rpm -V" command to verify the integrity of the SQL Community Server package files. If any files are reported as being modified or corrupted, it may indicate that the package is damaged.
-
Is SQL a programming language?
SQL (Structured Query Language) is not a programming language in the traditional sense, but rather a domain-specific language used for managing and manipulating data within a relational database. While it does involve writing code to perform operations on a database, it is primarily used for querying and managing data rather than for general-purpose programming. However, SQL does have some procedural and control-of-flow capabilities, which blurs the line between a programming language and a query language.
-
What is SQL and what does an SQL server do?
SQL, or Structured Query Language, is a programming language used to manage and manipulate data in relational databases. It allows users to create, retrieve, update, and delete data from databases, as well as define and manipulate the structure of the data. An SQL server is a software application that is used to store and manage databases, allowing multiple users to access and manipulate the data concurrently. It provides a secure and efficient way to store and retrieve data, and can handle large volumes of data and complex queries.
-
Is the SQL Server broken?
Without more specific information or context, it is difficult to determine if the SQL Server is broken. Common signs of a broken SQL Server could include error messages, slow performance, or inability to connect to the server. It is recommended to check the server logs, run diagnostic tests, and consult with a database administrator to determine the root cause of any issues.
Similar search terms for SQL:
-
SQL Server Database Programming with C# : Desktop and Web Applications
Databases have become an integral part of modern-day life.We live in an information-driven society and database technology has a direct impact on our daily lives.Decisions are routinely made by organizations based on the information collected and stored in the databases. Because databases play such an important role in business and society, database programming is a key skill. SQL Server Database Programming with C#: Desktop and Web Applications is for college students and software programmers who want to develop practical and commercial skills in database programming with C# or Visual C#.NET 2022 as well as the relational database Microsoft SQL Server 2019.The book explains the practical considerations and applications in database programming with Visual C# 2022 and provides realistic examples and detailed explanations.A direct writing style is combined with real-world examples to provide readers with a clear picture of how to handle database programming issues in the Visual C#.NET 2022 environment. Highlights include: A complete sample database CSE_DEPT, built with Microsoft SQL Server 2019 Express, is provided and used for the entire book.Step-by-step, detailed illustrations and descriptions show how to design and build a practical relational database. Both fundamental and advanced database-programming techniques are covered to benefit beginning students and experienced programmers. An advanced database query technique, LINQ API, which includes LINQ to Objects, LINQ to DataSet, LINQ to SQL, LINQ to Entities and LINQ to XML, is discussed, analyzed, and implemented in actual projects with line-by-line explanations. Homework and class projects are provided for each chapter to strengthen and improve students’ abilities to learn and understand the topics they studied. PowerPoint teaching slides and selected homework solutions help instructors to teach and organize their classes easily and effectively. Useful and practical, this textbook is an intuitive guide on how to develop and build professional and practical database applications.
Price: 74.99 £ | Shipping*: 0.00 £ -
SQL Server Database Programming with Java : Concepts, Designs and Implementations
This textbook covers both fundamental and advanced Java database programming techniques for beginning and experienced students as well as programmers (courses related to database programming in Java with Apache NetBeans IDE 12 environment).A sample SQL Server 2019 Express database, CSE_DEPT, is created and implemented in all example projects throughout this textbook.Over 40 real sample database programming projects are covered in this textbook with detailed illustrations and explanations to help students understand the key techniques and programming technologies.Chapters include homework and selected solutions to strengthen and improve students’ learning and understanding for topics they study in the classroom.Both Java desktop and Web applications with SQL Server database programming techniques are discussed and analyzed.Some updated Java techniques, such as Java Server Pages (JSP), Java Server Faces (JSF), Java Web Service (JWS), JavaServer Pages Standard Tag Library (JSTL), JavaBeans and Java API for XML Web Services (JAX-WS) are also discussed and implemented in the real projects developed in this textbook. This textbook targets mainly advanced-level students in computer science, but it also targets entry-level students in computer science and information system.Programmers, software engineers and researchers will also find this textbook useful as a reference for their projects.
Price: 44.99 £ | Shipping*: 0.00 £ -
SQL Server 2005 T-SQL Recipes : A Problem-Solution Approach
Need to brush up on specific SQL Server tasks, procedures, or Transact-SQL commands?Not finding what you need from SQL Server books online? Or perhaps you just want to familiarize yourself with the practical application of new T-SQL related features.SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach is an ideal book, whatever your level as a database administrator or developer. This no-fluff desk reference offers direct access to the information you need to get the job done.It covers basic T-SQL data manipulation, the use of stored procedures, triggers and UDFs, and advanced T-SQL techniques for database security and maintenance.It also provides hundreds of practical recipes that describe the utilities of features and functions, with a minimim of background theory. Additionally, this book provides how-to answers to common SQL Server T-SQL questions, conceptual overviews, and highlights of new features introduced in SQL Server 2005.It also features concise T-SQL syntax examples, and you can use the book to prepare for a SQL Server-related job interview or certification test.
Price: 54.99 £ | Shipping*: 0.00 £ -
Pro SQL Server 2022 Wait Statistics : A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database
Use this practical guide to analyze and troubleshoot SQL Server performance using wait statistics.You'll learn to identify precisely why your queries are running slowly. And you'll know how to measure the amount of time consumed by each bottleneck so you can focus attention on making the largest improvements first.This edition is updated to cover analysis of wait statistics current with SQL Server 2022.Whether you are new to wait statistics, or already familiar with them, this book provides a deeper understanding on how wait statistics are generated and what they mean for your SQL Server instance’s performance.The book goes beyond the most common wait types into the more complex and performance-threatening wait types.You’ll learn about per-query wait statistics and session-based wait statistics, and the types of problems they can help you solve.The different wait types are categorized by their area of impact, including CPU, IO, Latching, Locking, and many more. Clear examples are included to help you gain practical knowledge of why and how specific wait times increase or decrease, how they impact your SQL Server’s performance, and what you can do to improve performance.After reading this book, you won’t want to be without the valuable information that wait statistics provide regarding where you should be spending your limited tuning time to maximize performance and value to your business.What You'll LearnUnderstand how the SQL Server engine processes requestsIdentify resource bottlenecks in a running SQL Server instanceLocate wait statistics information inside DMVs and Query StoreAnalyze the root cause of sub-optimal performanceDiagnose I/O contention and locking contentionBenchmark SQL Server performanceImprove database performance by lowering overall wait time Who This Book Is ForDatabase administrators who want to identify and resolve performance bottlenecks, those who want to learn more about how the SQL Server engine accesses and uses resources inside SQL Server, and administrators concerned with achieving—and knowing they have achieved—optimal performance
Price: 54.99 £ | Shipping*: 0.00 £
-
How can I establish a connection between Android Studio and SQL Server using IntelliJ Community?
To establish a connection between Android Studio and SQL Server using IntelliJ Community, you can use the JDBC driver for SQL Server. First, you need to download the JDBC driver for SQL Server and add it to your Android Studio project. Then, you can use the JDBC API to establish a connection to the SQL Server database within your Android Studio project. You can create a connection string with the necessary database credentials and use it to connect to the SQL Server database from your Android Studio project.
-
What is a hidden table in SQL Server?
A hidden table in SQL Server is a system table that is not directly accessible to users but is used by the SQL Server system to store metadata and other system information. These tables are not meant to be modified or accessed by users, and they are essential for the internal functioning of the SQL Server database. Hidden tables are typically prefixed with "sys" or "dm" and are used to store information about database objects, system configurations, and performance metrics. Accessing or modifying these hidden tables directly can lead to database corruption and should be avoided.
-
How do you encrypt data in SQL Server?
In SQL Server, data can be encrypted using the built-in encryption functions and features provided by the platform. One common method is to use the Transparent Data Encryption (TDE) feature, which encrypts the entire database at rest. Another option is to use the Always Encrypted feature, which allows specific columns containing sensitive data to be encrypted at the application level before being stored in the database. Additionally, SQL Server provides functions like EncryptByKey and DecryptByKey to encrypt and decrypt data using symmetric keys.
-
Is it possible to use a SQL database in Visual Studio 2019 without using SQL Server?
Yes, it is possible to use a SQL database in Visual Studio 2019 without using SQL Server by utilizing SQLite. SQLite is a lightweight, file-based database management system that can be easily integrated into Visual Studio projects. It allows developers to create and interact with SQL databases without the need for a separate SQL Server installation. SQLite is a popular choice for small to medium-sized applications or projects that do not require the full capabilities of SQL Server.
* All prices are inclusive of VAT and, if applicable, plus shipping costs. The offer information is based on the details provided by the respective shop and is updated through automated processes. Real-time updates do not occur, so deviations can occur in individual cases.