Jordan Sanders

Jordan Sanders

1600927204

Best SQL Tools for Database Developers and Administrators

For a SQL database developer, it is essential to have the necessary SQL tools in hand, which enable to reduce the development time of given functionality. The same is true for the tester. For a database administrator, it is also important to have monitoring tools.

In this article, we are going to look at some MS SQL Server development and monitoring tools, such as:

  • SQL Server Management Studio
  • dbForge SQL Tools
  • Visual Studio and Visual Studio Code
  • dbForge Studio for SQL Server if necessary
  • Notepad ++
  • DBeaver
  • ApexSQL Developer and DBA tools
  • RedGate SQL Toolbelt
  • Spotlight on SQL Server и Foglight for SQL Server
  • Zabbix
  • Prometheus

SQL Server Management Studio
Let us begin with a free SSMS application. The functionality for development can be found here.
To add, there is a convenient function of Registered Server, which allows you to add the necessary MS SQL Server instances and also group them:
This is image title
It is also possible to create subgroups, to send requests to a given group, or a subgroup, or to a certain registered configured server, to upload registered configured servers for further import between all developers, for testing and administration.

It is also important to note the possibility of multi-editing:
This is image title
In SSMS, there is also a possibility of managing the Agent and designing databases through a database diagram. But the latter isn’t very user-friendly.

What is more, in SSMS, it is also possible to see active queries using Activity Monitor, but in general, it isn’t the best option to monitor a database and a database server.

Also, to monitor performance, you can use Profiler and Extended events in SSMS.

There are a bunch of other functions in SSMS, including the following:

  • data import and export
  • performance reports
  • database engine log shipping configuration and monitoring
  • configuring and monitoring AlwaysOn availability groups
  • configuring and monitoring query store
    and many more.

dbForge SQL Tools

dbForge SQL Tools is a multi-functional toolkit for SQL Server. The tools are useful for any Microsoft SQL Server developer because they are integrated into SSMS, expanding it with the missing functionality, to perform a lot of routine tasks. SQL Tools can be used to automate development and deploy databases with the help of dbForge DevOps Automation. The package includes:

  • SQL Complete, which is one of the most functional add-ins, used to write and format SQL queries in SSMS and VS. This utility has not only functions of SQL code IntelliSense, formatting, and refactoring, but also a huge number of useful features that simplify code writing, formatting, and refactoring. This add-in also integrates with Visual Studio, which is particularly convenient.
  • Source Control is a powerful SSMS add-in for managing SQL Server database changes via all popular source control systems.
  • Unit Test is a convenient GUI for unit automation in SSMS.
  • Schema Compare and Data Compare
  • an excellent Data Generator for generation SQL Server test data.
  • Documenter
  • Data Pump, which provides you with a convenient functionality for data export/import.
  • Index Manager, which is used for index optimization.
  • Query Builder allows users to visually build SQL queries of any complexity.
  • Search is used for a quick search for objects and data in the database.
  • Monitor for SQL Server has basic required functionality.
  • Event Profiler
  • SQL Decryptor

This is image title
This is image title
This is image title
Apart from this, the package includes dbForge DevOps Automation, whose functionality allows you to implement a comprehensive database continuous integration process for SQL Server. In this way, a user gets a full set of tools for database DevОps.

You can buy all tools from the package and install them separately, but experience has proven that buying the package will reduce the cost of the tools substantially.

Visual Studio Editor for SQL Server

Hand in hand with SSMS goes the powerful Visual Studio editor for SQL Server Database Project projects and other types of projects for databases and T-SQL scripts:
This is image title
Visual Studio is usually used for the following main functions:

  • Viewing and editing code and the database as a whole
  • Comparing database schemas and data, and making changes to the schema if necessary
  • Database schema export and import

Among the main disadvantages of SSMS as well as Visual Studio, are the following ones:

  1. They do not have all the necessary functions for development, testing, and administration

  2. Some of the capabilities, even if present, do not allow to perform all required tasks, and the process itself is very time-consuming.

There is also Visual Studio Code, which a cross-platform analogue of Visual Studio and which has only part of its functionality:
This is image title

dbForge Studio for SQL Server

Let us now look at the dbForge Studio for SQL Server editor:
This is image title
This solution is an alternative to SSMS, which complements and expands it. On top of that, this editor has well-implemented such important functions as:

  • Database Documenter
  • Database Schema Compare and Database Data Compare
  • Unit Test
  • Code Formatting
  • Source Control
  • Database Designer
  • Index Manager
  • Data Generator
  • Search
  • Monitor
  • Backup and Restore
  • Debugger
  • Query Profiler
  • Intellisense
    and lots more.

Unfortunately, for the present moment, dbForge Studio for SQL Server does not support multi-editing.

Notepad ++

We can not but mention a wonderful simplified and free editor which is Notepad++. You can use it to view and edit T-SQL scripts. The editor supports multiple programming languages:
This is image title
This editor is especially handy when a T-SQL query is too large and it has many thousands and dozens of thousands of code lines because SSMS can freeze even when it displays a big chunk of code. There are various extensions for Notepad++, the most frequently used ones are SQL code comparison and formatting. You can also search for files with the help of Notepad++.

We won’t name the drawbacks of Notepad++, as it is mainly used for reading and editing the content of a file, and also for searching for a fragment in files and comparing the contents of files.

DBeaver
One more free editor, DBeaver:
This is image title
There is a paid version as well.

This editor, among all other things, has useful functions such as:

  • Code formatting
  • Database design
  • Open Dashboard
  • Search
  • Transaction Log
    However, this editor does not support multi-editing and some other useful functions for development, testing, and administration.

ApexSQL Developer and DBA tools
Let’s now look at ApexSQL developer tools and ApexSQL DBA tools, which are plugged in SSMS and in Visual Studio:
This is image title
This is image title
ApexSQL developer tools are designed for development and testing. It provides, among other things, the following functions:

  • Database schema and data comparison
  • SQL code formatting
  • Database documentation
  • Synthetic test data generation
  • Unit testing
  • Database design
  • Connecting to popular version control systems
  • Search for objects and data

ApexSQL DBA tools are designed for SQL Server administration. Among others, it provides the following functionality:

  • Index optimization
  • Backup and recovery
  • Reading transaction log

Together, ApexSQL developer tools and ApexSQL DBA tools, as well as dbForge SQL Tools, allow us to fully implement continuous integration and delivery processes and to organize ci/cd pipeline.

RedGate SQL Toolbelt
Let us now look at RedGate SQL Toolbelt:
This is image title
This is image title
This is image title
This tool is designed to develop, test, and administer databases. It provides, among other things, the following functions:

 1) Comparison of schemas and database data

 2) SQL Server monitoring

 3) Search

 4) Backup

 5) Documentation of databases

 6) Index Manager

 7) Analysis and formatting of the code

 8) Continuous integration and automatic deployment of SQL Server database

 9) Data generator

and much more.

As you can see, RedGate is the most expensive of all mentioned tools and it has a wide range of functionalities, but such competitive products as dbForge SQL Tools, ApexSQL Developer and DBA tools are constantly being improved, and new functionality is added to them. Therefore, today it is safe to say that such products as dbForge SQL Tools, ApexSQL Developer and DBA tools are on the level with, and in some cases even superior to RedGate, yet they are much cheaper.

SQL Server Monitoring Tools
At the end of the overview of the SQL Server tools, we will briefly go over the most popular systems for SQL Server monitoring.

Spotlight on SQL Server and Foglight for SQL Server
Let us start by looking at Spotlight on SQL Server
This is image title
This tool is quite rich in functionality for monitoring database servers and has, among others, the following functions:

  • collect basic characteristics of both the server and each database
  • fine-tuning alerts for each performance metric
  • several ready-made templates for performance metrics and alerts
  • a possibility to create user performance metrics
  • many convenient visual reports, including database growth rate reports
  • collection and analysis of heavy queries and their performance plans in the context of the total performance duration, of CPU performance, and of the number of the records, physical and logical reads
  • analysis of index fragmentation
  • a possibility to have a detailed look into every moment of time when the messages or alerts appeared, including details on queries and their performance plans (Playback)
    and a lot more

A more advanced solution for SQL Server monitoring is Foglight for SQL Server:
This is image title

Zabbix
Let us now look at Zabbix:
This is image title
This product for monitoring provides a wide range of performance metrics and their triggers, as well as templates for them, different graphics, dashboards, and a wide variety of functionality, most of which can be customized.

The monitor has one major drawback. Zabbix, unlike Spotlight on SQL Server, can’t show queries at the specific point in time. But Zabbix is an open-source solution that allows you to monitor much more than just a database server.

Prometheus
Let us now consider Prometheus:
This is image title
Prometheus is usually used with the client side of Grafana.

Grafana can also be used for Zabbix, but the latter has a built-in customizable client side view to display the results in the form of dashboards and graphs.

Prometheus and Zabbix work fine for SQL Server monitoring and they fully cover the needs for monitoring databases and servers without giving details of queries in chronological order. Zabbix can be used without Grafana, so it can be deployed and set up faster than other solutions. However, Prometheus is much more modular and extendable than Zabbix.

Conclusion
The main tools for working with SQL Server databases are:

  • SSMS

  • Visual Studio
    They can be extended by third-party plugins to cover all development, testing and administration needs:

  • dbForge SQL Tools

  • ApexSQL developer tools и ApexSQL DBA tools

  • RedGate SQL Toolbelt
    or other similar systems.

These solutions also allow us to fully support the DevOps process.

To monitor database servers, I usually use the following systems:

  • Zabbix
  • Prometheus и Grafana
    or other similar systems.

To monitor queries and query history, the following tools are often used:

  • Spotlight on SQL Server
  • Foglight for SQL Server
  • SQL Server Query Store
    or other similar systems.

There are also a number of additional tools that partially or completely replace SSMS depending on the tasks that are solved, working with SQL Server:

  • dbForge Studio for SQL Server
  • Visual Studio Code
  • DBeaver
    The Notepad++ editor is handy when editing content, searching, or comparing very large files.

Originally posted at https://codingsight.com/best-sql-tools-for-database-developers-and-administrators/
Author Evgeniy Gribkov

#sql-server #database #sql #gui #tools #developer

What is GEEK

Buddha Community

Best SQL Tools for Database Developers and Administrators
Cayla  Erdman

Cayla Erdman

1594369800

Introduction to Structured Query Language SQL pdf

SQL stands for Structured Query Language. SQL is a scripting language expected to store, control, and inquiry information put away in social databases. The main manifestation of SQL showed up in 1974, when a gathering in IBM built up the principal model of a social database. The primary business social database was discharged by Relational Software later turning out to be Oracle.

Models for SQL exist. In any case, the SQL that can be utilized on every last one of the major RDBMS today is in various flavors. This is because of two reasons:

1. The SQL order standard is genuinely intricate, and it isn’t handy to actualize the whole standard.

2. Every database seller needs an approach to separate its item from others.

Right now, contrasts are noted where fitting.

#programming books #beginning sql pdf #commands sql #download free sql full book pdf #introduction to sql pdf #introduction to sql ppt #introduction to sql #practical sql pdf #sql commands pdf with examples free download #sql commands #sql free bool download #sql guide #sql language #sql pdf #sql ppt #sql programming language #sql tutorial for beginners #sql tutorial pdf #sql #structured query language pdf #structured query language ppt #structured query language

bindu singh

bindu singh

1647351133

Procedure To Become An Air Hostess/Cabin Crew

Minimum educational required – 10+2 passed in any stream from a recognized board.

The age limit is 18 to 25 years. It may differ from one airline to another!

 

Physical and Medical standards –

  • Females must be 157 cm in height and males must be 170 cm in height (for males). This parameter may vary from one airline toward the next.
  • The candidate's body weight should be proportional to his or her height.
  • Candidates with blemish-free skin will have an advantage.
  • Physical fitness is required of the candidate.
  • Eyesight requirements: a minimum of 6/9 vision is required. Many airlines allow applicants to fix their vision to 20/20!
  • There should be no history of mental disease in the candidate's past.
  • The candidate should not have a significant cardiovascular condition.

You can become an air hostess if you meet certain criteria, such as a minimum educational level, an age limit, language ability, and physical characteristics.

As can be seen from the preceding information, a 10+2 pass is the minimal educational need for becoming an air hostess in India. So, if you have a 10+2 certificate from a recognized board, you are qualified to apply for an interview for air hostess positions!

You can still apply for this job if you have a higher qualification (such as a Bachelor's or Master's Degree).

So That I may recommend, joining Special Personality development courses, a learning gallery that offers aviation industry courses by AEROFLY INTERNATIONAL AVIATION ACADEMY in CHANDIGARH. They provide extra sessions included in the course and conduct the entire course in 6 months covering all topics at an affordable pricing structure. They pay particular attention to each and every aspirant and prepare them according to airline criteria. So be a part of it and give your aspirations So be a part of it and give your aspirations wings.

Read More:   Safety and Emergency Procedures of Aviation || Operations of Travel and Hospitality Management || Intellectual Language and Interview Training || Premiere Coaching For Retail and Mass Communication |Introductory Cosmetology and Tress Styling  ||  Aircraft Ground Personnel Competent Course

For more information:

Visit us at:     https://aerofly.co.in

Phone         :     wa.me//+919988887551 

Address:     Aerofly International Aviation Academy, SCO 68, 4th Floor, Sector 17-D,                            Chandigarh, Pin 160017 

Email:     info@aerofly.co.in

 

#air hostess institute in Delhi, 

#air hostess institute in Chandigarh, 

#air hostess institute near me,

#best air hostess institute in India,
#air hostess institute,

#best air hostess institute in Delhi, 

#air hostess institute in India, 

#best air hostess institute in India,

#air hostess training institute fees, 

#top 10 air hostess training institute in India, 

#government air hostess training institute in India, 

#best air hostess training institute in the world,

#air hostess training institute fees, 

#cabin crew course fees, 

#cabin crew course duration and fees, 

#best cabin crew training institute in Delhi, 

#cabin crew courses after 12th,

#best cabin crew training institute in Delhi, 

#cabin crew training institute in Delhi, 

#cabin crew training institute in India,

#cabin crew training institute near me,

#best cabin crew training institute in India,

#best cabin crew training institute in Delhi, 

#best cabin crew training institute in the world, 

#government cabin crew training institute

Ruth  Nabimanya

Ruth Nabimanya

1621850444

List of Available Database for Current User In SQL Server

Introduction

When working in the SQL Server, we may have to check some other databases other than the current one which we are working. In that scenario we may not be sure that does we have access to those Databases?. In this article we discuss the list of databases that are available for the current logged user in SQL Server

Get the list of database
Conclusion

#sql server #available databases for current user #check database has access #list of available database #sql #sql query #sql server database #sql tips #sql tips and tricks #tips

Jordan Sanders

Jordan Sanders

1600927204

Best SQL Tools for Database Developers and Administrators

For a SQL database developer, it is essential to have the necessary SQL tools in hand, which enable to reduce the development time of given functionality. The same is true for the tester. For a database administrator, it is also important to have monitoring tools.

In this article, we are going to look at some MS SQL Server development and monitoring tools, such as:

  • SQL Server Management Studio
  • dbForge SQL Tools
  • Visual Studio and Visual Studio Code
  • dbForge Studio for SQL Server if necessary
  • Notepad ++
  • DBeaver
  • ApexSQL Developer and DBA tools
  • RedGate SQL Toolbelt
  • Spotlight on SQL Server и Foglight for SQL Server
  • Zabbix
  • Prometheus

SQL Server Management Studio
Let us begin with a free SSMS application. The functionality for development can be found here.
To add, there is a convenient function of Registered Server, which allows you to add the necessary MS SQL Server instances and also group them:
This is image title
It is also possible to create subgroups, to send requests to a given group, or a subgroup, or to a certain registered configured server, to upload registered configured servers for further import between all developers, for testing and administration.

It is also important to note the possibility of multi-editing:
This is image title
In SSMS, there is also a possibility of managing the Agent and designing databases through a database diagram. But the latter isn’t very user-friendly.

What is more, in SSMS, it is also possible to see active queries using Activity Monitor, but in general, it isn’t the best option to monitor a database and a database server.

Also, to monitor performance, you can use Profiler and Extended events in SSMS.

There are a bunch of other functions in SSMS, including the following:

  • data import and export
  • performance reports
  • database engine log shipping configuration and monitoring
  • configuring and monitoring AlwaysOn availability groups
  • configuring and monitoring query store
    and many more.

dbForge SQL Tools

dbForge SQL Tools is a multi-functional toolkit for SQL Server. The tools are useful for any Microsoft SQL Server developer because they are integrated into SSMS, expanding it with the missing functionality, to perform a lot of routine tasks. SQL Tools can be used to automate development and deploy databases with the help of dbForge DevOps Automation. The package includes:

  • SQL Complete, which is one of the most functional add-ins, used to write and format SQL queries in SSMS and VS. This utility has not only functions of SQL code IntelliSense, formatting, and refactoring, but also a huge number of useful features that simplify code writing, formatting, and refactoring. This add-in also integrates with Visual Studio, which is particularly convenient.
  • Source Control is a powerful SSMS add-in for managing SQL Server database changes via all popular source control systems.
  • Unit Test is a convenient GUI for unit automation in SSMS.
  • Schema Compare and Data Compare
  • an excellent Data Generator for generation SQL Server test data.
  • Documenter
  • Data Pump, which provides you with a convenient functionality for data export/import.
  • Index Manager, which is used for index optimization.
  • Query Builder allows users to visually build SQL queries of any complexity.
  • Search is used for a quick search for objects and data in the database.
  • Monitor for SQL Server has basic required functionality.
  • Event Profiler
  • SQL Decryptor

This is image title
This is image title
This is image title
Apart from this, the package includes dbForge DevOps Automation, whose functionality allows you to implement a comprehensive database continuous integration process for SQL Server. In this way, a user gets a full set of tools for database DevОps.

You can buy all tools from the package and install them separately, but experience has proven that buying the package will reduce the cost of the tools substantially.

Visual Studio Editor for SQL Server

Hand in hand with SSMS goes the powerful Visual Studio editor for SQL Server Database Project projects and other types of projects for databases and T-SQL scripts:
This is image title
Visual Studio is usually used for the following main functions:

  • Viewing and editing code and the database as a whole
  • Comparing database schemas and data, and making changes to the schema if necessary
  • Database schema export and import

Among the main disadvantages of SSMS as well as Visual Studio, are the following ones:

  1. They do not have all the necessary functions for development, testing, and administration

  2. Some of the capabilities, even if present, do not allow to perform all required tasks, and the process itself is very time-consuming.

There is also Visual Studio Code, which a cross-platform analogue of Visual Studio and which has only part of its functionality:
This is image title

dbForge Studio for SQL Server

Let us now look at the dbForge Studio for SQL Server editor:
This is image title
This solution is an alternative to SSMS, which complements and expands it. On top of that, this editor has well-implemented such important functions as:

  • Database Documenter
  • Database Schema Compare and Database Data Compare
  • Unit Test
  • Code Formatting
  • Source Control
  • Database Designer
  • Index Manager
  • Data Generator
  • Search
  • Monitor
  • Backup and Restore
  • Debugger
  • Query Profiler
  • Intellisense
    and lots more.

Unfortunately, for the present moment, dbForge Studio for SQL Server does not support multi-editing.

Notepad ++

We can not but mention a wonderful simplified and free editor which is Notepad++. You can use it to view and edit T-SQL scripts. The editor supports multiple programming languages:
This is image title
This editor is especially handy when a T-SQL query is too large and it has many thousands and dozens of thousands of code lines because SSMS can freeze even when it displays a big chunk of code. There are various extensions for Notepad++, the most frequently used ones are SQL code comparison and formatting. You can also search for files with the help of Notepad++.

We won’t name the drawbacks of Notepad++, as it is mainly used for reading and editing the content of a file, and also for searching for a fragment in files and comparing the contents of files.

DBeaver
One more free editor, DBeaver:
This is image title
There is a paid version as well.

This editor, among all other things, has useful functions such as:

  • Code formatting
  • Database design
  • Open Dashboard
  • Search
  • Transaction Log
    However, this editor does not support multi-editing and some other useful functions for development, testing, and administration.

ApexSQL Developer and DBA tools
Let’s now look at ApexSQL developer tools and ApexSQL DBA tools, which are plugged in SSMS and in Visual Studio:
This is image title
This is image title
ApexSQL developer tools are designed for development and testing. It provides, among other things, the following functions:

  • Database schema and data comparison
  • SQL code formatting
  • Database documentation
  • Synthetic test data generation
  • Unit testing
  • Database design
  • Connecting to popular version control systems
  • Search for objects and data

ApexSQL DBA tools are designed for SQL Server administration. Among others, it provides the following functionality:

  • Index optimization
  • Backup and recovery
  • Reading transaction log

Together, ApexSQL developer tools and ApexSQL DBA tools, as well as dbForge SQL Tools, allow us to fully implement continuous integration and delivery processes and to organize ci/cd pipeline.

RedGate SQL Toolbelt
Let us now look at RedGate SQL Toolbelt:
This is image title
This is image title
This is image title
This tool is designed to develop, test, and administer databases. It provides, among other things, the following functions:

 1) Comparison of schemas and database data

 2) SQL Server monitoring

 3) Search

 4) Backup

 5) Documentation of databases

 6) Index Manager

 7) Analysis and formatting of the code

 8) Continuous integration and automatic deployment of SQL Server database

 9) Data generator

and much more.

As you can see, RedGate is the most expensive of all mentioned tools and it has a wide range of functionalities, but such competitive products as dbForge SQL Tools, ApexSQL Developer and DBA tools are constantly being improved, and new functionality is added to them. Therefore, today it is safe to say that such products as dbForge SQL Tools, ApexSQL Developer and DBA tools are on the level with, and in some cases even superior to RedGate, yet they are much cheaper.

SQL Server Monitoring Tools
At the end of the overview of the SQL Server tools, we will briefly go over the most popular systems for SQL Server monitoring.

Spotlight on SQL Server and Foglight for SQL Server
Let us start by looking at Spotlight on SQL Server
This is image title
This tool is quite rich in functionality for monitoring database servers and has, among others, the following functions:

  • collect basic characteristics of both the server and each database
  • fine-tuning alerts for each performance metric
  • several ready-made templates for performance metrics and alerts
  • a possibility to create user performance metrics
  • many convenient visual reports, including database growth rate reports
  • collection and analysis of heavy queries and their performance plans in the context of the total performance duration, of CPU performance, and of the number of the records, physical and logical reads
  • analysis of index fragmentation
  • a possibility to have a detailed look into every moment of time when the messages or alerts appeared, including details on queries and their performance plans (Playback)
    and a lot more

A more advanced solution for SQL Server monitoring is Foglight for SQL Server:
This is image title

Zabbix
Let us now look at Zabbix:
This is image title
This product for monitoring provides a wide range of performance metrics and their triggers, as well as templates for them, different graphics, dashboards, and a wide variety of functionality, most of which can be customized.

The monitor has one major drawback. Zabbix, unlike Spotlight on SQL Server, can’t show queries at the specific point in time. But Zabbix is an open-source solution that allows you to monitor much more than just a database server.

Prometheus
Let us now consider Prometheus:
This is image title
Prometheus is usually used with the client side of Grafana.

Grafana can also be used for Zabbix, but the latter has a built-in customizable client side view to display the results in the form of dashboards and graphs.

Prometheus and Zabbix work fine for SQL Server monitoring and they fully cover the needs for monitoring databases and servers without giving details of queries in chronological order. Zabbix can be used without Grafana, so it can be deployed and set up faster than other solutions. However, Prometheus is much more modular and extendable than Zabbix.

Conclusion
The main tools for working with SQL Server databases are:

  • SSMS

  • Visual Studio
    They can be extended by third-party plugins to cover all development, testing and administration needs:

  • dbForge SQL Tools

  • ApexSQL developer tools и ApexSQL DBA tools

  • RedGate SQL Toolbelt
    or other similar systems.

These solutions also allow us to fully support the DevOps process.

To monitor database servers, I usually use the following systems:

  • Zabbix
  • Prometheus и Grafana
    or other similar systems.

To monitor queries and query history, the following tools are often used:

  • Spotlight on SQL Server
  • Foglight for SQL Server
  • SQL Server Query Store
    or other similar systems.

There are also a number of additional tools that partially or completely replace SSMS depending on the tasks that are solved, working with SQL Server:

  • dbForge Studio for SQL Server
  • Visual Studio Code
  • DBeaver
    The Notepad++ editor is handy when editing content, searching, or comparing very large files.

Originally posted at https://codingsight.com/best-sql-tools-for-database-developers-and-administrators/
Author Evgeniy Gribkov

#sql-server #database #sql #gui #tools #developer

Ruth  Nabimanya

Ruth Nabimanya

1620648300

What is SQL? And Where is it Used?

Define: SQL [pron. “sequel”] – stands for Structured Query Language (SQL), used by databases to model and manage tabular/relational datasets; a set of standardized Data Definition Language (DDL) functions to create tables, views, and define relational schema models, and Data Manipulation Language (DML) to query, insert, and modify data in the tables.

*Read-only select queries are technically part of its Data Query Language (DQL) group. Still, operationally, many refer to it as DML because it can do more than read-only queries.

Super Brief History of SQL

Who Uses SQL?

What Can a SQL Database Do?

What is a SQL Query?

Different SQL Database Platforms

SQL for JSON

Application Developers

SQL for Big Data

Further Reading

#sql #database #relational-database #nosql #json #sql-database #database-administration #databases-best-practices