Post has attachment

Post has attachment

Post has attachment
SQL full form - Structured Query Language.

SQL is a programming language used for managing databases and performing various operations on the data in them.

https://goo.gl/DsbQ2E

#SQL #SQLtutorial #whatisSQL
#javatpoint

Post has attachment

Post has shared content
How can we preserve Hive metadata in an Azure HDInsight cluster? As we cannot keep running a cluster all the time (because of the cost associated with the uptime), we should choose the metastore option as per the need during HDInsight cluster instantiation process.
In this post, we are going to learn that how we can configure an HDInsight cluster in such a way so that we can preserve the Hive metadata.

https://goo.gl/Qq8nQH

#Azure #HiveQL #HDInsight #Cloud

Post has shared content
In this post “Connecting Python 3 to SQL Server 2017 using pyodbc”, we are going to learn that how we can connect Python 3 to SQL Server 2017 to execute SQL queries. We can change the settings accordingly to connect to other versions of SQL Server also. Also, we will learn how to SELECT, INSERT, UPDATE and DELETE records in a table with examples.

https://goo.gl/GNnhCk

#Python #SQLServer #DataAnalytics #pyodbc #SQLServer2017

Post has shared content
In this post, we are going to explore another use case example of Python in SQL Server 2017. As Microsoft has integrated Python in SQL Server 2017 for advanced data analytics and machine learning purpose, it can also be used to ease the complex data transformation and analysis which might be tedious and a bit complex while doing the same using T-SQL.

https://goo.gl/h43R99

#MSSQL #Python #SQLServer #sql #sqlrelease

Post has shared content
We can use Python for almost everything from website development to robotics and Data Science. In SQL Server 2017, Python can be used primarily for Machine learning purposes but it is not limited to that only. We can also use Python for complex data transformations and analysis which might be a bit tedious and complex while doing the same using T-SQL in SQL Server.

In this post, we will be exploring an use case example of Python for data transformation in SQL Server 2017.

https://goo.gl/KHv9t3

#sqlrelease #python #sqlserver2017 #pythonsqlserverusecase

Post has shared content
Microsoft has integrated Python in SQL Server 2017 which can be used for in-database analysis purpose.In this post, we are going to explore “Why Python and how to use it in SQL Server 2017”, and then we will explore that how we can use it in SQL Server 2017.

https://goo.gl/VYhjp6

#sqlrelease #python #pythoninsqlserver

Post has shared content
Microsoft has launched the most recent SQL Server 2017 release candidate (RC1, July 2017). SQL Server 2017 will run on both Windows as well as on Linux OS. It will also support macOS via Docker. To know new features of SQL Server 2017, read this blog.

https://goo.gl/rbNDQd

#sqlrelease #sqlserver2017 #newfeature #sql
Wait while more posts are being loaded