-
Working with NoSQL Databases
Aug 10, 2018 by Robert Gravelle The term "NoSQL" actually encompasses a wide variety of different database technologies that were developed in response to the demands dictated by modern applications and Internet of Things (IoT) devices. The massive...
https://www.navicat.com/en/company/aboutus/blog/767-working-with-nosql-databases.html -
Analyzing MongoDB Schemas and Data
verifying your schemas, visualizing data distributions and for identifying data outliers. Available only for MongoDB, the Navicat for MongoDB Collection and Data Viewer toolbars include command buttons for analyzing your collection schema and document...
https://www.navicat.com/en/company/aboutus/blog/869-analyzing-mongodb-schemas-and-data.html -
Create DBRefs in MongoDB
Feb 19, 2019 by Robert Gravelle In last week's blog , we explored the pros and cons of document relationship modeling via Embedded and Referenced approaches in MongoDB. We then gained some valuable experience with each by creating both an Embedded and...
https://www.navicat.com/en/company/aboutus/blog/1004-create-dbrefs-in-mongodb.html -
More Essential SELECT Queries for Every Database Developer's Toolkit
Jun 19, 2019 by Robert Gravelle A short time ago, we explored Some SELECT Queries You Must Know . These included determining the lowest and highest value for a column, as well as grouping results by category. Today's blog presents a couple more...
https://www.navicat.com/en/company/aboutus/blog/1064-more-essential-select-queries-for-every-database-developer-s-toolkit.html -
Direct Download 2
Thank you for downloading Navicat 14 -day fully functional free trial. Your download should start automatically. If it doesn't, you can download here . Need Help? Contact our customer service team . Thank you for downloading Navicat Monitor. Your...
https://www.navicat.com/en/download/direct-download-2.html -
Using the SQL CASE Statement
Sep 5, 2019 by Robert Gravelle CASE is a Control Flow statement that acts a lot like an IF-THEN-ELSE statement to choose a value based on the data. The CASE statement goes through conditions and returns a value when the first condition is met. So, once...
https://www.navicat.com/en/company/aboutus/blog/1249-using-the-sql-case-statement.html -
Navicat named "Trend-Setting Products List for 2017” by Database Trends and Applications Magazine
2017-05-31 Navicat Version 12 is released Read More > < Hide
https://www.navicat.com/en/company/press-2/145-test-13.html -
MongoDB Documents Tutorial
Aug 14, 2018 by Robert Gravelle The massive volumes data generated by modern interconnected systems and devices has spawned a new kind of database known as NoSQL. Perhaps the best known of this new breed of non-relational database is MongoDB. Unlike...
https://www.navicat.com/en/company/aboutus/blog/768-mongodb-documents-tutorial.html -
Specifying Collation in MongoDB (Part 1)
Oct 3, 2018 by Robert Gravelle Collation involves a set of language-specific rules for string comparison, such as those for lettercase and accent marks. Your run of the mill sorting is fine for simple entries made up of alphanumeric characters, but...
https://www.navicat.com/en/company/aboutus/blog/877-specifying-collation-in-mongodb-part-1.html -
Introduction to User & Role Management in MongoDB
users, such as to change password and grant or revoke roles. In today's blog, we'll explore how to create a new user using Navicat for MongoDB's User & Role Management facilities.
https://www.navicat.com/en/company/aboutus/blog/914-introduction-to-user-role-management-in-mongodb.html -
Relationships in MongoDB
between documents to be modeled via Embedded and Referenced approaches. In today's blog, we'll give each a try using Navicat for MongoDB .
https://www.navicat.com/en/company/aboutus/blog/1003-relationships-in-mongodb.html -
All about MongoDB's _id Field
Mar 26, 2019 by Robert Gravelle Open up any document in a MongoDB database and you'll notice an _id field: In fact, the ObjectId/_id is the only field that exists across every MongoDB document. In today's blog, we'll explore what it is and why it's...
https://www.navicat.com/en/company/aboutus/blog/1010-all-about-mongodb-s-_id-field.html -
Performing Regular Expression Searches in MongoDB
what the exact Field value is that you're looking for. In today's blog we'll learn how to use regexes in MongoDB, using Navicat for MongoDB .
https://www.navicat.com/en/company/aboutus/blog/1011-performing-regular-expression-searches-in-mongodb.html -
Understanding Views in Relational Databases
the view, but with some caveats. In today's blog, we'll learn what a view is and how to create one for MySQL 8 using Navicat Premium as our client.
https://www.navicat.com/en/company/aboutus/blog/1046-understanding-views-in-relational-databases.html -
Some SELECT Queries You Must Know
SELECT statement. Today's blog will present a couple of the most important queries to know, along with some examples using Navicat Premium as the database client.
https://www.navicat.com/en/company/aboutus/blog/1057-some-select-queries-you-must-know.html -
Using the SQL Limit Keyword
and Oracle, the SQL LIMIT clause can solve several problems. In today's blog, we'll explore a few of these, using Navicat for PostgreSQL .
https://www.navicat.com/en/company/aboutus/blog/1215-using-the-sql-limit-keyword.html -
Validating Data using Triggers in MySQL 8
Aug 21, 2019 by Robert Gravelle There are some very good reasons why data validation is best performed at the database level rather than at the application level. For instance, the same data source may be accessed by multiple applications. Therefore,...
https://www.navicat.com/en/company/aboutus/blog/1236-validating-data-using-triggers-in-mysql-8.html -
Working with Cursors in MongoDB
additional functionality for processing individual rows. In today's blog, we'll learn how to work with MongoDB cursors in Navicat for MongoDB .
https://www.navicat.com/en/company/aboutus/blog/1258-working-with-cursors-in-mongodb.html -
Perform Full-text Searches in MySQL (Part 1)
blog, we'll learn how full-text searching is implemented in MySQL. In part 2, we'll try our hand at some queries using Navicat for MySQL as our database client.
https://www.navicat.com/en/company/aboutus/blog/1261-perform-full-text-searches-in-mysql-part-1.html -
Perform Full-text Searches in MySQL (Part 3)
Full-Text searches Query expansion searches In Part 2, I described how to perform Natural Language full-text searches in Navicat for MySQL. Today's blog follows where part 2 left off and covers the next type of full-text searching: Boolean Full-Text...
https://www.navicat.com/en/company/aboutus/blog/1299-perform-full-text-searches-in-mysql-part-3.html
