Home
Search results “Sql server linux oracle”
Linux Fundamentals for SQL Server DBAs
 
01:08:34
Most of the Fortune 1000 companies leverage Linux for their 7/24 mission-critical enterprise server platform and Enterprise Linux has become the standard de facto for reliability and scalability. Today, more and more companies are considering Linux as their new operating system (OS) for SQL Server; and in today's economy to be an effective database administrator, DBAs and Architects must possess extensive OS and database expertise. In this session, learn how to install and configure SQL Server on Red Hat 7 Enterprise Linux and SUSE Enterprise Server (SLES v12) on bare metal servers and in virtualized infrastructures. We will discuss the top 10 Linux commands that every SQL Server DBA needs to know as you transition from Microsoft to the world of Red Hat and SUSE; with a closer look at the different file system types that are available and which one you should choose. Leveraging real-life experiences and techniques as a certified Linux veteran for over 16 years, I will also share my top tips that you need to know to configure a Linux environment worthy to run SQL Server: 1. Install required RPMs to install SQL Server * Manage and interrogate RPMs * Review RPM dependencies * Setup a local YUM repository 2. Set appropriate kernel and network parameters, shell limits, and file limits for SQL Server 3. Configure transparent hugepages 4. Determine and implement the right I/O Scheduler 5. Configure NTP for the server 6. Bond network interface * Enable jumbo frames 7. Configuring NFS 8. Setup correct partition alignment 9. Centralize System Logging 10. Simplify DNS 11. Setup up ssh equivalence between Linux servers 12. Configure swap setting Charles Kim Charles Kim is an Oracle ACE Director, VMware vExpert, Oracle Certified DBA, Certified Exadata Implementation Specialist, Certified SharePlex Administrator, and a Certified RAC Expert. Charles specializes in RAC, Exadata, Cloud, and Virtualization and author of 10 books:
Views: 518 DBAFundamentals
Oracle Database Gateway Installation & Configuration On Linux For MS SQL
 
14:35
Learn how to install oracle database gateway on linux on the same database server but on different home location and connect it to ms sql server 2008 and configure the database and the gateway You can find the installation process on: http://oracle-ebs-apps.blogspot.com/2014/12/oracle-database-gateway-installation.html
Views: 7293 Waseem Maarbani
[vi] Oracle SQL Developer: Cài đặt lên Ubuntu và connect tới Microsoft SQL Server
 
12:57
- Cài đặt Oracle SQL Developer lên Ubuntu. - Cài đặt JDBC cho SQL Server và Sybase. - Dùng Oracle SQL Developer connect tới SQL Server. English version: https://youtu.be/Kt3bFeZgA4c
Views: 1738 1Click2beDBA
Oracle Database Gateway for MS SQL Server
 
14:36
Implementando Oracle Database Gateway for MS SQL Server
Views: 20028 Francisco Riccio
Install SQL Server on Oracle Linux 7 3
 
12:40
Installation of SQL Server 2017 on Oracle Linux version 7.3. The commands to do the online installation is available on the Microsoft Website. This installation requires Internet, however there is an offline installation option also available which i will share in another video.
Views: 137 Mithun Roy
Using Oracle to read data from SQL Server
 
10:47
Hi everyone, Andy from Easysoft Limited here, what I want to show you today is how to get data from SQL Server into Oracle. Now for this we will be accessing SQL Server 2014 from Oracle 12 and getting data across. This could be quite easily be any SQL Server version from 2008 and any Oracle version from 11.2, the configuration and process is the same. We can obviously get access to data on SQL Server prior to 2008 and Oracle prior to version 11.2 but it will need a different configuration to what I am going to show you today The plan is also to add more data to the SQL Server table and show this new data back in Oracle. To start off you'll need access to ensure that you have access to your SQL Server and Oracle databases. You'll also need the Easysoft SQL Server ODBC Driver available from www.easysoft.com; just download it, install it and request the free 14 day trial licence. Before we start we need to make some changes to the standard Easysoft config files. cat /etc/odbc.ini Here I have changed Mars Connection to Yes. It must be set to "Yes" if you are connecting to SQL Server 2005 or newer. Easysoft supports all SQL data types from the version of SQL Server from version 7. Oracle supports data types that are common to most ODBC Drivers, but not some of the SQL Server ones. If you intend to access VARCHAR(MAX) for example, then there are some additional settings that need to be set up. Now as I would like to show you VARCHAR(MAX) data moving from SQL Server to Oracle, I have made the relevant change. As you can see, VarMaxAsLong says "Yes" We now need to create a link from Oracles Database Gateway (DG4ODBC) to the ODBC datasource that we already have, this is done in an init(sid) oracle file; let's have a look at our file. cat $ORACLE_HOME/hs/admin/initsqlsrv.ora Please note that HS_NLS_NCHAR must be set to UCS2 Oracle assume that most database vendors use UTF-8 for wide characters, however Easysoft, like almost all ODBC Driver vendors (including Oracles own ODBC Driver) uses UCS2 for wide characters. So that's the link between DG4ODBC and the datasource setup correctly. Next we need to set up the Listener entry The Oracle Listener waits for incoming requests from the Oracle database. For the Oracle Listener to listen for requests, information about DG4ODBC must be added to the Oracle Listener configuration file, listener.ora cat $ORACLE_HOME/network/admin/listener.ora The PROGRAM=dg4odbc tells the Listener that we are wanting to use the Oracle database gateway to communicate with ODBC. The ENVS=LD_LIBRARY_PATH tells Oracle what library to load Now that's all set up and OK we need to tell Oracle which server to attach the listener entry to. This is done in tnsnames.ora, and he is the file that we ensured was set up earlier. cat $ORACLE_HOME/network/admin/tnsnames.ora The Oracle Listener now needs to be restarted. lsnrctl stop lsnrctl start OK, that's now started the Listener up again. So we have ensured that all the configuration files are set up correctly. The Listener and tnsnames.ora both set up OK. The final step is to create a link from the Oracle database to the "tnsnames.ora" entry. CREATE PUBLIC DATABASE LINK ODBC CONNECT TO "test" IDENTIFIED BY "test" USING 'sqlsrv_ptr'; Right, that's all done. Let's access the data in SQL Server now. select * from [email protected]; Where 'demo' is the name of the SQL Server table and 'odbc' is the public database link name. OK, there we have the data. So to recap, I'm in Oracle and we have managed to read the data from SQL Server. Let's just add an additional row in that SQL Server table and retrieve the new data in Oracle. quit; /usr/local/easysoft/unixODBC/bin/isql.sh -v sqlsrv insert into demo values (2,'Easysoft') select * from demo select * from [email protected]; And there is the new data. Easysoft Limited can help you with your data access ... for our full range of ODBC and JDBC Drivers, Bridges and Gateways visit easysoft.com Be sure to let us know if you have any comments or questions. Until next time, thanks again and we'll see you again soon.
Views: 16684 Easysoft Limited
SQL Server Linux (Ubuntu) Kurulumu Nasıl Yapılır?
 
15:02
-- SQL SERVER KURULUMU -- apt-get install -y libjemalloc1 libsss-nss-idmap0 libc++1 gawk curl curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list)" add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list)" wget http://archive.ubuntu.com/ubuntu/pool/main/c/ca-certificates/ca-certificates_20160104ubuntu1_all.deb dpkg -i ca-certificates_20160104ubuntu1_all.deb wget http://archive.ubuntu.com/ubuntu/pool/main/o/openssl/openssl_1.0.2g-1ubuntu4_amd64.deb dpkg -i openssl_1.0.2g-1ubuntu4_amd64.deb apt install -y libcurl3 apt-get update apt-get install -y mssql-server -- SQL CMD KURULUMU -- sudo apt-get update sudo apt-get install mssql-tools unixodbc-dev -- PATH TANIMLARI -- gedit ~/.bashrc export SQL_TOOLS=/opt/mssql-tools/bin export PATH=${PATH}:${SQL_TOOLS} -- SQL SERVER BAĞLANTI TESTİ -- sqlcmd -S localhost -U SA -P SqlSaŞifreniz -- VERİ TABANI OLUŞTUR -- CREATE DATABASE TestVT -- TABLO OLUŞTUR -- CREATE TABLE Adresler ( KayitNo INT, AdSoyad NVARCHAR(40), Telefon NVARCHAR(20), Eposta NVARCHAR(50) ); GO
Views: 450 datakent
Install and configure sql developer on Linux | Oracle Tutorial
 
05:28
How to Install SQL Developer on Linux 1) Download for the below link http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html 2) Make sure you have Java Development Kit installed with latest version. http://www.oracle.com/technetwork/java/javase/downloads/index.html 3) Install SQL developer as rpm -ihv sqldeveloper-xxx.noarch.rpm (replace xxx with exact version of your SQL developer) Run SQL developer on linux command prompt as $ sqldeveloper 4) Create a new connection to connect to user Technology Lair : www.technologylair.org Subscribe : http://www.youtube.com/subscription_center?add_user=technologylair For More Videos : http://www.youtube.com/user/technologylair/videos For Video Tutorials :http://www.youtube.com/playlist?list=PLC71CFFF7A916DCAA For Android : http://www.youtube.com/playlist?list=PLUXK1VpPWQKHI1l-NvM5jvNKKnmNy9eHp For Linux : https://www.youtube.com/playlist?list=PLUXK1VpPWQKHV2xOmjQgUNj3Hrmcslj-H Kalam e Iqbal : http://www.youtube.com/playlist?list=PLF057785BD260F061 Like us on Facebook : https://www.facebook.com/technologylair Tweet us : http://twitter.com/technologylair Follow us : https://plus.google.com/u/0/118196883367288585963/posts Pin us : http://www.pinterest.com/technologylair/
Views: 25076 TechLair
[en] Ubuntu: Oracle SQL Developer connect to Microsoft SQL Server and Sybase
 
13:06
Steps guide to install Oracle SQL Developer on Ubuntu, Enable the connectivity tabs to Microsoft SQL Server and Sybase. Tiếng Việt: https://youtu.be/S4MyDUMeLMs
Views: 79 1Click2beDBA
脱Oracleはここから!SQL Server on Linuxにも対応した移行手法をご紹介!!
 
32:15
Oracleの移行方法に頭を抱えていませんか。 本セミナーでは、DBの移行の手法は勿論のこと、下記の要求にも最適な手段をご紹介いたします。 ・最小限のダウンタイムでDBを移行したい ・オンプレミスのDBをクラウド上DBに移行したい ・OracleからSQL Server on Linuxやオープン系のMySQL、PostgreSQLなどに移行したい また、セミナーの後半に予定しているデモでは、 SQL Server on Linuxへの移行の紹介を行います。 セミナーの最後には、Amazonギフト券が抽選で当たるクイズも行います。詳しくは下記のページをご覧ください。 https://www.climb.co.jp/soft/webseminar/2018/0215/
Microsoft SQL Server 2017 Installation on Oracle Linux 7.5 Step by Step
 
15:58
In this video we are going to show how to install Microsoft SQL Server 2017 Express Edition on Oracle Linux 7.5 step by step. It is the offline installation were RPM packages are downloaded from Microsoft website https://packages.microsoft.com/ and https://packages.microsoft.com/yumrepos/mssql-server-2017-rhel7/ Following scenarios are covered in the video. 1. Installation of Microsoft SQL Server 2017 2. Dependencies Installation for Microsoft SQL Server Command Line tools 3. Installation of Microsoft SQL Server Command-line tools 4. Creating database, table, inserting and selecting records 5. Accessing the Database in Windows Machine using SQL Server Management Studio 17.9. All the dependency packages are downloaded from pkgs.org
Views: 29 java frm
SQL Server 2017 Ubuntu AD integration
 
05:11
This video covers the Keytab and SPN creation need to connect SQL Server on Linux to Active Directory logins
Views: 97 Tips For IT Pros
SQL Server’s sqlcmd on Linux using Windows Authentication (720p)
 
47:23
Presented on March 22, 2016 by Chrissy LeMaire and Aaron Nelson You've heard that SQL Server will soon be available on Linux, but did you know that the client tools have already been ported *and* they support Integrated Authentication? Watch as PowerShell MVP and SUSE Certified Linux Administrator Chrissy LeMaire shows SQL Server MVP Aaron Nelson how to install Linux, join an Active Directory domain, login as a domain user, and execute a SQL query against SQL Server using sqlcmd. PowerShell/Linux command line equivalents will also be discussed.
Install SQL Server on Ubuntu Linux
 
03:00
This video is part of tutorial of how to install SQL Server for Linux on Ubuntu Linux. In this video, I'm using Ubuntu 16.04 LTS (Xenial Xerus) as Operating System. Visit this link to see full tutorial http://www.belajararief.com/index.php/tulisan/tekno/173-instalasi-sql-server-pada-linux-ubuntu
Views: 3926 Arief Wijaya
CONNECT ORACLE TO SQLSERVER الاتصال بسكول سيرفر من قاعدة بيانات  اوراكل
 
19:02
CONNECT ORACLE TO SQLSERVER الاتصال بسكول سيرفر من قاعدة بيانات اوراكل
Views: 17752 mohamed adam
SQL Server Active Directory Authentication on Linux
 
02:24
Learn how to use Active Directory authentication with SQL Server on Linux in this demo video from Travis Wright of SQL Server engineering. Now with SQL Server 2017, customers are able to bring the industry-leading performance and security of SQL Server to Linux and Docker containers. SQL Server 2017 delivers mission-critical OLTP database capabilities and enterprise data warehousing with in-memory technology across workloads, and the security of Active Directory authentication for databases running on Linux. Try SQL Server 2017 on Windows or Linux: https://www.microsoft.com/en-us/sql-server/sql-server-downloads-free-trial
How to Install SQL Server on Linux (Ubuntu 17.04)
 
20:17
Article for commands to copy: https://vlemonn.com/blog/sql-server/install-sql-server-2017-in-ubuntu-17.04/ Support Us: PayPal: https://www.paypal.me/vlemonn Patreon: https://www.patreon.com/vlemonn In this video we are going to learn about how to install Microsoft SQL Server 2017 RC in Ubuntu Linux version 17.04. During the installation video we learned about How to import SQL Server 2017 public repository ? How to Install SQL Server 2017 RC in Linux Ubuntu 17.04 ? How to Configure SQL Server 2017 RC in Linux Ubuntu 17.04 ? SQL Server Installation variants. How to install SQLCMD command line tool for SQL Server 2017 RC in Linux Ubuntu 17.04 ? Use SQLCMD to execute TSQL for creating database, database table and insert test records in newly created database table. Next in our to do for SQL Server 2017 in Linux environment 1. Configure SQL Server 2017 in Ubuntu Linux for remote connection 2. GUI Editor in Ubuntu 17.04 for SQL Server 2017. Our testing system information: OS Ubuntu 17.04 64 bit Available Ram 5 GB Disk Space: 63 GB Useful URL: Our Website: https://vlemonn.com Blog Post: https://vlemonn.com/blog/sql-server/install-sql-server-2017-in-ubuntu-17.04/ Facebook: https://www.facebook.com/vLemonn Twitter: https://www.facebook.com/vLemonn Google Plus: https://plus.google.com/+MayankSanghvivlemonn Youtube: https://www.youtube.com/c/mayanksanghvi Whats App: 8818882120 (Only for Registered and verified Users)
Views: 1928 Mayank Sanghvi
Instalacion y Configuracion de Oracle y SQL Server Ubuntu 18.04
 
08:17
Instalacion y Configuracion de Oracle y SQL Server Ubuntu 18.04, tarea
Views: 122 Luis Gil
Scriptcase 8 - Enabling and Connecting DBs (Oracle, DB2, MS SQL Server, Informix)
 
47:17
This video was recorded from a live webinar that happened on June, 12th. During the webinar we explain how to enable and connect the Scriptcase with DBs: Oracle, DB2, MS SQL Server, Informix. Each of these systems have quirks in their connections. We show all the details and tips. Timing acording to the DB: - IBM DB2: 02'10'' - Informix: 09'35'' - Oracle: 27'05'' and 36'05'' - SQL Server: 32'00'' Scriptcase - The most efficient web development tool on the market. Creates complete web systems, integrated with Business Ingelligence in minutes! Free Trial: https://www.scriptcase.net/descargar/ More videos: https://www.scriptcase.net/learn/videos/ https://www.youtube.com/user/ScriptCaseVideos Blog: https://www.scriptcaseblog.net/ Examples: https://www.scriptcase.net/samples/ Courses: https://www.scriptcase.net/learn/courses/ You can also register for free for our upcoming events: Product demo: https://www.scriptcase.net/learning/demonstration/ Intermediate / Advanced: https://www.scriptcase.net/aprendizaje/webinars/ Contact us and get a coupon for discount in a Scriptcase purchase. Mauricio Rory | Techinical Sales Support E-Mail: [email protected] Skype: m.rory www.scriptcase.net
Get started developing apps with SQL Server 2017 running on Linux
 
11:05
In this short video we will walk you through everything you should know as a developer: the acquisition and installation process, the connectors: node, .net, php, and key management tools. Download SQL Server 2017: Now on Windows, Linux, and Docker: https://aka.ms/sqlserver17linuxyt
Views: 949 Microsoft Cloud
Install Microsoft SQL Server Tools and ODBC Drivers in Linux Server step by step
 
03:13
Install Microsoft SQL Server Tools and ODBC Drivers in Linux Server step by step tutorial
Views: 6326 mobilerootindia
How to Install SQL Server 2017 on RHEL with Ansible
 
05:00
Using Ansible helps seasoned and new administrators automate some of their most time consuming tasks. This video demonstrates how to get started with Microsoft SQL Server 2017 on Red Hat Enterprise Linux 7. For more info check out: -------------------- Kyle's example playbook: https://github.com/kyleabenson/mssql-demo The MsSQL role on Ansible Galaxy: https://galaxy.ansible.com/kyleabenson/mssql/ Blog link coming soon This video was created with support by Command Line Heroes, an original podcast by Red Hat. Visit redhat.com/commandlineheroes to access demos, special how-tos, and to sign up for the newsletter.
Installing SQL Developer on Ubuntu 16.04
 
19:05
Installing SQL Developer on Ubuntu 16.04
Views: 29786 Everything About Linux
SQL Server on Linux: overview
 
06:19
Learn about SQL Server on Linux and watch demos on how to get started today. See SQL Server on Linux for more information: http://www.sqlserveronlinux.com/
Instalar SQL Server en Linux
 
12:30
En este video mostramos el proceso de instalación de SQL Server en Linux. Ing. Eduardo Castro, PhD http://ecastrom.blogspot.com Microsoft SQL Server MVP
Views: 5859 Eduardo Castro
CONEXION ORACLE 11G - SQL SERVER 2014
 
07:47
VINCULO DE 2 GESTORES DE BASE DE DATOS
SQL Server 2017 on Linux
 
01:34
You can now run SQL across your entire IT ecosystem. Learn about the benefits of SQL Server 2017 on Linux: https://www.microsoft.com/en-US/sql-server/sql-server-2017-linux
Views: 6041 Microsoft Cloud
How to Restore SQL Server database from Windows to SQL Server on Linux
 
05:11
How to Restore SQL Server database from Windows to SQL Server on Linux, Migrate a SQL Server database from Windows to Linux using backup and restore.SQL Server Linux ➭ For more Tutorials visit : http://hightechnology.in ➭ For help tweet @hightechnology1
Views: 929 Hightechnology TV
Install and Run Microsoft SQL Server 2017 on Red Hat Enterprise Linux
 
07:17
See how to install Microsoft SQL Server 2017 on Red Hat Enterprise Linux. Try out a free developer subscription of Red Hat Enterprise Linux (https://developers.redhat.com/) and use this demo script to run the installation and test yourself: https://github.com/mheslin/SQL-Server---RHEL-BM-Demo.
Views: 2876 Red Hat Developer
Migrating from Oracle to SQL Server
 
53:03
Presented by Red Gate and Inspirer Systems. Wednesday 20th April 2011 If you are considering moving from Oracle to SQL Server or just interested in what such a move would involve, this webinar is not to be missed! In a joint collaboration between Red Gate Software and Inspirer Systems, we discuss the whole process from preparing for the migration, to the actual move itself. A Q+A session will follow the presentation with technical and commercial representatives from both Red Gate and Inspirer. For our complete archive, and to sign up for upcoming webinars please go to http://www.red-gate.com/oracle-webinars
Views: 3137 Redgate Videos
MIGRACION DE ORACLE 11G EN LINUX A SQL SERVER 2012 EN WINDOWS
 
01:05:56
Este vídeo tutorial es sobre como migrar de oracle en linux a sql en windows echos por los alumnos de Base de Datos II la universidad San Pedro Link de ova de oracle: http://praitheesh.blogspot.com/2013/10/oracle-developer-day-vm-how-to-use-pre.html Link de oracle cliente 11g: http://www.oracle.com/us/industries/public-sector/112010-win64soft-094461.html Link de Microsoft SQL Server Migration Assistant for Oracle: http://www.microsoft.com/en-us/download/details.aspx?id=42655
Oracle SQL Developer installation in Oracle Enterprise Linux 6
 
03:28
http://locutoriorama.blogspot.com.es/ This is a simple installation of Oracle SQL Developer tool in Linux OEL 6, using zip distribution. SQL Developer download: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html add 'SetSkipJ2SDKCheck true' to /home/oracle/dba/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf
Views: 2699 locuto riorama
5 minutes to install SQL Server on Linux
 
05:01
In this short video : - we create a Linux VM in Azure. - we install SQL Server for Linux. - we execute a SQL Query. https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-linux-2017
Views: 73 Denis Voituron
Convert Oracle to Sql Server
 
04:06
SQLIE Website:https://sqlie.com Hello friends, in this video you will learn how to convert SQLserver tables to oracle using SQLIE App. SQLIE is Converting Oracle Schema Tables in two steps: 1-Export Oracle Source Tables Data and generating SQLIE Files. 2-Import SQLIE Generated files to the Destination Sql Server DataBase. SQLIE Website:https://sqlie.com
Views: 115 SQLIE
Oracle Enterprise Manager 12c Monitoring Plug-in for Microsoft SQL Server
 
14:29
The Enterprise Manager System Monitoring Plug-in for Microsoft SQL Server delivers comprehensive availability, performance and configuration information for Microsoft SQL Server. By combining Microsoft SQL Server monitoring with the richest and most comprehensive management of Oracle systems, Oracle Enterprise Manager significantly reduces the cost and complexity of managing IT environments that have a mix of Microsoft SQL Server and Oracle technologies. Administrators running packaged and custom applications on top of Oracle systems and Microsoft SQL Server can now centralize all of the monitoring information in the Oracle Enterprise Manager Cloud Control, model and view the complete topology of their applications, and perform comprehensive root cause analysis. Database administrators managing Oracle Databases and Microsoft SQL Server can perform proactive monitoring and detailed configuration analysis for Microsoft SQL Server, while consolidating all of the management information about their database environment in the Oracle Enterprise Manager Console. ================================= For more information, see http://www.oracle.com/goto/oll Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
SQL - Full course for beginners
 
04:20:39
In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS. The course is designed for beginners to SQL and database management systems, and will introduce common database management topics. Throughout the course we'll be looking at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more. 🔗Company Database Code: https://www.giraffeacademy.com/databases/sql/creating-company-database/ ⭐️ Contents ⭐ ⌨️ (0:00) Introduction ⌨️ (2:36) What is a Database? ⌨️ (23:10) Tables & Keys ⌨️ (43:31) SQL Basics ⌨️ (52:26) MySQL Windows Installation ⌨️ (1:01:59) MySQL Mac Installation ⌨️ (1:15:49) Creating Tables ⌨️ (1:31:05) Inserting Data ⌨️ (1:38:17) Constraints ⌨️ (1:48:11) Update & Delete ⌨️ (1:56:11) Basic Queries ⌨️ (2:08:37) Company Database Intro ⌨️ (2:14:05) Creating Company Database ⌨️ (2:30:27 ) More Basic Queries ⌨️ (2:26:24) Functions ⌨️ (2:45:13) Wildcards ⌨️ (2:53:53) Union ⌨️ (3:01:36) Joins ⌨️ (3:11:49) Nested Queries ⌨️ (3:21:52) On Delete ⌨️ (3:30:05) Triggers ⌨️ (3:42:12) ER Diagrams Intro ⌨️ (3:55:53) Designing an ER Diagram ⌨️ (4:08:34) Converting ER Diagrams to Schemas Course developed by Mike Dane. Check out his YouTube channel for more great programming courses: https://www.youtube.com/channel/UCvmINlrza7JHB1zkIOuXEbw 🐦Follow Mike on Twitter: https://twitter.com/GiraffeAcademy 🔗The Giraffe Academy website: http://www.giraffeacademy.com/ -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://medium.freecodecamp.org And subscribe for new videos on technology every day: https://youtube.com/subscription_center?add_user=freecodecamp
Views: 1151387 freeCodeCamp.org
Backup of SQL Server Database on Linux | Backup SQL server database in linux
 
03:18
How to Take Backup of SQL Server Database on Linux, Backup SQL Server Database on Linux, Backup SQL Server Database on Linux, How to Backup SQL Server Database on Linux OS.SQL Server Linux Take backup of database in sql server linux. backup sql server database in linux Share, Support, Subscribe!!! Youtube: http://www.youtube.com/c/hightechnologyin Twitter: http://www.twitter.com/hightechnology1 Facebook: http://www.facebook.com/hightechnologyblog Google Plus: https://plus.google.com/+TheHightechnology Website: http://hightechnology.in/
Views: 1055 Hightechnology TV
How to Install SQL Developer on Linux
 
04:21
How to Install SQL Developer on LINUX 1) Download for the below link http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html 2) Make sure you have Java Development Kit installed with latest version. http://www.oracle.com/technetwork/java/javase/downloads/index.html 3) Install SQL developer as rpm -Uhv sqldeveloper-xx.noarch.rpm (replace xxx with exact version of your SQL developer) Run SQL developer on linux command prompt as $ sqldeveloper 4) Create a new connection to connect to user Technology Lair : www.technologylair.net Subscribe : http://www.youtube.com/subscription_center?add_user=technologylair For More Videos : http://www.youtube.com/user/technologylair/videos For Video Tutorials :http://www.youtube.com/playlist?list=PLC71CFFF7A916DCAA For Android : http://www.youtube.com/playlist?list=PLUXK1VpPWQKHI1l-NvM5jvNKKnmNy9eHp Kalam e Iqbal : http://www.youtube.com/playlist?list=PLF057785BD260F061 Like us on Facebook : https://www.facebook.com/techlair Tweet us : @technologylair Follow us : https://plus.google.com/u/0/118196883367288585963/posts Pin us : http://www.pinterest.com/technologylair/
Views: 41864 TechLair
SQL Server on VirtualBox
 
07:33
This video presents the best solution for running SQL server on a VirtualBox https://sqldevops.tech
Views: 2969 SqlDevOps
Create DB connection using Navicat premium for windows Oracle, SQL Server, MySQL etc
 
15:02
Create DB connection using Navicat premium for windows (Oracle, SQL Server, MySQL etc.) You can download and install necessary software from the link bellow. https://drive.google.com/open?id=0Bzj34Au3W4eUb3o2akVfejhoamc Is the video helpful? please add a comment and subscribe my channel.
Connect SQL Server on Linux Azure VM from SSMS
 
09:40
Connect SQL Server vNext on Linux Azure VM with SSMS from a Windows machine On my Blog: https://sqlwithmanoj.com/2017/01/06/connect-sql-server-on-linux-with-ssms-from-a-windows-machine/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 1041 SQL with Manoj
Trace session details with USER process and SERVER process ID
 
13:43
Oracle database user session tracing.
Views: 7609 OrSkl Academy
How to Configure Apache2, PHP5 and Microsoft SQL Server Connection on Debian Linux
 
05:01
This Tutorial is explaining about how to install and configure Apache2, PHP5 and Microsoft SQL Server Connection on your Debian Linux Environment
Views: 1103 Aone AR
How to install oracle 12c on Linux
 
20:53
Learn ow to install the latest release for oracle database i.e 12C. watch the step by step installation in the above video. Click the below link for all the commands and steps http://techlair.info/2015/11/08/oracle12cinstall/ Step 1 - Edit Host Files - /etc/hosts 127.0.0.1 localhost.localdomain localhost 192.168.0.210 oracle_12C.localdomain oracle_12C Step 2 - Edit Kernel Parameters /etc/sysctl.conf fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500 sysctl -p - apply changes Step 3 - Edit Limits file - etc/security/limits.conf oracle soft nofile 1024 oracle hard nofile 65536 oracle soft nproc 2047 oracle hard nproc 16384 oracle soft stack 10240 oracle hard stack 32768 Step 4 - Install dependencies yum install binutils -y yum install compat-libcap1 -y yum install compat-libstdc++-33 -y yum install compat-libstdc++-33.i686 -y yum install gcc -y yum install gcc-c++ -y yum install glibc -y yum install glibc.i686 -y yum install glibc-devel -y yum install glibc-devel.i686 -y yum install ksh -y yum install libgcc -y yum install libgcc.i686 -y yum install libstdc++ -y yum install libstdc++.i686 -y yum install libstdc++-devel -y yum install libstdc++-devel.i686 -y yum install libaio -y yum install libaio.i686 -y yum install libaio-devel -y yum install libaio-devel.i686 -y yum install libXext -y yum install libXext.i686 -y yum install libXtst -y yum install libXtst.i686 -y yum install libX11 -y yum install libX11.i686 -y yum install libXau -y yum install libXau.i686 -y yum install libxcb -y yum install libxcb.i686 -y yum install libXi -y yum install libXi.i686 -y yum install make -y yum install sysstat -y yum install unixODBC -y yum install unixODBC-devel -y Step 5 - Add Groups and Users groupadd -g 54321 oinstall groupadd -g 54322 dba groupadd -g 54323 oper useradd -u 54321 -g oinstall -G dba,oper oracle passwd oracle Step 6 - /etc/security/limits.d/90-nproc.conf # Change this * soft nproc 1024 # To this * - nproc 16384 Step 7 - Set SELINUX SELINUX=permissive run the command after edit setenforce Permissive Step 8 - Stop Firewall # service iptables stop # chkconfig iptables off Step 9 - Create directories for oracle Installation mkdir -p /oracle/product/12.1.0/db_1 chown -R oracle:oinstall /oracle chmod -R 775 /oracle Step 10 - xhost + Step 11 - Edit bash profile for oracle user /home/oracle/.bash_profile # Oracle Settings export TMP=/tmp export TMPDIR=$TMP export ORACLE_HOSTNAME=oracle_12C.localdomain export ORACLE_UNQNAME=db1 export ORACLE_BASE=/oracle export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1 export ORACLE_SID=db1 export PATH=/usr/sbin:$PATH export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib Step - 12 Extract Installation Files unzip linuxamd64_12c_database_1of2.zip unzip linuxamd64_12c_database_2of2.zip Step - 13 Start the Oracle Universal Installer ./runInstaller Post Installation dit the "/etc/oratab" file setting the restart flag for each instance to 'Y' cdb1:/u01/app/oracle/product/12.1.0/db_1:Y Technology Lair : www.technologylair.org Subscribe : http://www.youtube.com/subscription_center?add_user=technologylair For More Videos : http://www.youtube.com/user/technologylair/videos For Video Tutorials :http://www.youtube.com/playlist?list=PLC71CFFF7A916DCAA For Android : http://www.youtube.com/playlist?list=PLUXK1VpPWQKHI1l-NvM5jvNKKnmNy9eHp For Linux : https://www.youtube.com/playlist?list=PLUXK1VpPWQKHV2xOmjQgUNj3Hrmcslj-H Kalam e Iqbal : http://www.youtube.com/playlist?list=PLF057785BD260F061 Like us on Facebook : https://www.facebook.com/technologylair Tweet us : http://twitter.com/technologylair Follow us : https://plus.google.com/u/0/118196883367288585963/posts Pin us : http://www.pinterest.com/technologylair/
Views: 137693 TechLair
Scriptcase 8 - Habilitando e Conectando DBs (Oracle, DB2, MS SQL Server, Informix)
 
58:13
Video gravado desde um seminário ao-vivo no dia 12/06/2015 Durante o semináro explicamos como habilitar e conectar o Scriptcase com SGBDs: Oracle, DB2, MS SQL Server, Informix. Cada um desses sistemas possuem peculiaridades quanto a forma de conexão com o Scriptcase. Iremos mostrar todos os detalhes e dicas para essas conexões. As conexões foram mostradas na seguinte ordem: - Oracle minuto 1'30'' - SQL Server: minuto 14'55'' - Informix: minuto 24'36'' - Dúvidas gerais: minuto 42'55'' - DB2: minuto 48' O Scriptcase é uma solução para o desenvolvimento de aplicações web e relatórios de business intelligence de forma rápida e colaborativa. Experimente grátis: https://www.scriptcase.com.br/download/ Mais vídeos: https://www.scriptcase.com.br/aprendizagem/videos/ https://www.youtube.com/user/VideosScriptcase Blog: https://www.scriptcaseblog.com.br/blog Exemplos: https://www.scriptcase.com.br/exemplos/ Cursos: https://www.scriptcase.com.br/aprendizagem/cursos/ Você pode se registrar de graça para nossos próximos eventos: Demo do Produto: https://www.scriptcase.com.br/aprendizagem/demonstracao/ Intermediário / Avançado: https://www.scriptcase.com.br/aprendizagem/webinars/ Entre em contato e ganhe um desconto na compra do Scriptcase. Ingrid Araújo| Consultora de Negócios E-mail: [email protected] WhatsAPP: (81) 99665-0907 www.scriptcase.com.br
Views: 2518 Scriptcase Brasil
How to connect to an Oracle Database? - Database Tutorial 37
 
12:37
Video 37 - How to connect to a Oracle Database? - Database Tutorial 37 This video explains how to connection to an oracle database. The database, which is Oracle 11g has been installed in a Windows 7 computer.
Views: 121964 Sam Dhanasekaran