Categories
Video

Top 65 SQL Interview Questions and Answers | SQL Interview Preparation | SQL Training | Edureka



๐Ÿ”ฅ MYSQL DBA Certification Training: https://www.edureka.co/mysql-dba
๐Ÿ”ฅ Edureka Computer Science Bootcamp Program: https://www.edureka.co/masters-program/computer-science-bootcamp-program
This Edureka video on Top 65 SQL Interview Question and Answers (SQL Interview Questions blog: http://bit.ly/2G2XapU) will help you to prepare yourself for Database Administrators Interviews. It covers questions for beginners, intermediate and experienced professionals.

Subscribe to our channel to get video updates. Hit the subscribe button above: https://goo.gl/6ohpTV

Join Edurekaโ€™s Meetup community and never miss any event โ€“ YouTube Live, Webinars, Workshops etc. https://bit.ly/2EfTXS1

#edureka #edurekasql #sqlinterviewquestions #sql

——————–

๐Ÿ“Œ๐“๐ž๐ฅ๐ž๐ ๐ซ๐š๐ฆ: https://t.me/edurekaupdates
๐Ÿ“Œ๐“๐ฐ๐ข๐ญ๐ญ๐ž๐ซ: https://twitter.com/edurekain
๐Ÿ“Œ๐‹๐ข๐ง๐ค๐ž๐๐ˆ๐ง: https://www.linkedin.com/company/edureka
๐Ÿ“Œ๐ˆ๐ง๐ฌ๐ญ๐š๐ ๐ซ๐š๐ฆ: https://www.instagram.com/edureka_learning/
๐Ÿ“Œ๐…๐š๐œ๐ž๐›๐จ๐จ๐ค: https://www.facebook.com/edurekaIN/
๐Ÿ“Œ๐’๐ฅ๐ข๐๐ž๐’๐ก๐š๐ซ๐ž: https://www.slideshare.net/EdurekaIN
๐Ÿ“Œ๐‚๐š๐ฌ๐ญ๐›๐จ๐ฑ: https://castbox.fm/networks/505?country=IN
๐Ÿ“Œ๐Œ๐ž๐ž๐ญ๐ฎ๐ฉ: https://www.meetup.com/edureka/
๐Ÿ“Œ๐‚๐จ๐ฆ๐ฆ๐ฎ๐ง๐ข๐ญ๐ฒ: https://www.edureka.co/community/

——————-
How does it work?

1. This is a 4 Week Instructor-led Online Course.
2. The course consists of 24 hours of online classes, 25 hours of assignment, 20 hours of project
3. We have a 24×7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course.
4. You will get Lifetime Access to the recordings in the LMS.
5. At the end of the training, you will have to complete the project based on which we will provide you with a Verifiable Certificate!

– – – – – – – – – – – – – –

About the Course

MySQL DBA Certification Training trains you on the core concepts & advanced tools and techniques to manage data and administer the MySQL Database. It includes hands-on learning on concepts like MySQL Workbench, MySQL Server, Data Modeling, MySQL Connector, Database Design, MySQL Command line, MySQL Functions etc. End of the training you will be able to create and administer your own MySQL Database and manage data.

– – – – – – – – – – – – – –

Who should go for this course?

This course can be beneficial for people having the below professional background:
Database Developers
Application Developers
Database Designers
Database Administrators
– – – – – – – – – – – – – –

Project

In the project you will be creating a Database using MySQL on SALARY MANAGEMENT SYSTEM :-

โ€ข Employee list to be maintained having id, name, designation, experience
โ€ข Salary details having employee id, current salary
โ€ข Salary in hand details having employee id, CTC salary, pf deduction or any other deduction and net salary to be given and also maintain details of total savings of employee
โ€ข Salary increment to be given by next year if any depending upon constraints
โ€ข Deduction in monthly salary if any depending upon any discrepancy in work and amount to be deducted.

– – – – – – – – – – – – – –

Got a question on the topic? Please share it in the comment section below and our experts will answer it for you.

For more information, Please write back to us at sales@edureka.co or call us at IND: 9606058406 / US: 18338555775 (toll free).

source

Categories
Video

VBScript SQL Query | VBScript Database SQL | VBScript SQL Server Query Example | Database Record Set



VBScript SQL query can fetch, add, update or delete database records. VBScript Database SQL tutorial shows database connection using vbscript and run VBScript SQL Server query with VBScript code using VBScript database Connection object and database Record Set vbscript. This VBScript tutorial for beginners shows VBScript database query to fetch data from database VBScript, add record in database VBScript, update record and delete record in database VBScript.

0:00 | VBScript SQL Query Tutorial Introduction
0:43 | ADO objects in VBScript
1:00 | What is VBScript Database Connection Object
1:23 | What is Database Record Set VBScript
2:23 | SQL Server Database
2:58 | VBScript Code
3:28 | database Connection using vbscript
4:01 | database Record Set vbscript
4:10 | SQL Query
4:27 | database Record Set vbscript object
5:19 | VBScript Loop through Records
6:18 | MoveNext VBScript
6:49 | Run VBS Script
7:37 | Insert Record in Database (AddNew RecordSet)
8:23 | VBScript Run VBS file
9:17 | VBScript Update Record in Database
9:37 | VBScript SQL Server Query Example
10:22 | VBScript Run VBS file
10:48 | VBScript Delete Record in Database
11:02 | SQL Query Example
11:55 | Run VBS Script
12:15 | VBScript Database SQL Tutorial Summary

Learn VBscripting for beginners with code shown in this VBS training. This VBScript database SQL tutorial resolves viewer vbscript basics queries on:
1) SQL database
2) Writing sql queries in vbscript
3) RecordSet object methods
4) Vbscript with sql server
5) Activex data objects in vbscript
* Click Cc button to see subtitles in English.

VBScript for Beginners (complete set): https://www.youtube.com/playlist?list=PLc3SzDYhhiGXH8hEHtayRPdwAsddelkh6
Programming Concepts: https://www.youtube.com/playlist?list=PLc3SzDYhhiGVqrvE28rlJR75asbujHoUL
Test Automation (full set): https://www.youtube.com/playlist?list=PLc3SzDYhhiGXVcy8EcrTSfwsC-v8EUZvg
Database Testing : https://www.youtube.com/playlist?list=PLc3SzDYhhiGVVb76aFOH9AcIMNAW-JuXE
Software Testing Tutorials (complete set) : https://www.youtube.com/playlist?list=PLc3SzDYhhiGWuMK03uYO-UENAx0s2woWM

Subscribe: https://www.youtube.com/user/SoftwareTestingSpace?sub_confirmation=1

Software and Testing Training: Online training in Python programming, VB scripting, Perl scripting, Big Data, SQL, HTML, XML, Selenium Python, Selenium with Java, SoapUI, LoadRunner and JMeter automated software testing tools, software testing training, Database testing, QA, domain knowledge and others

#softwareandtestingtraining #inderpsingh #sql #sqlserver

Website (blog – VBScript code): https://inderpsingh.blogspot.com/2020/04/VBScriptTutorial8.html
Twitter: https://twitter.com/inder_p_singh
LinkedIn: https://www.linkedin.com/in/inderpsingh/

source

Categories
Video

SQL database tutorial: relational database, schema, table, SQL data types, SQL constraints, RDBMS



Watch this SQL tutorial to learn the key terms – SQL database, schema, table, and fields. Find out whatโ€™s the difference between SQL vs. no-SQL dbs. Discover what a relational database management system (RDBMS) is and how it is different from the database.

If you are interested in a particular topic, click on a timestamp to move right to it:
00:50 – The most common tasks you can perform using SQL (CRUD operations)
1:25 – What is a SQL database
1:39 – SQL vs. no-SQL databases
2:12 – SQL schema
2:29 – SQL tables
3:02 – SQL table structure: fields (columns) and records (rows)
3:27 – SQL data types
3:46 – SQL constraints: NOT NULL, DEFAULT, UNIQUE, PRIMARY KEY
5:16 – Database management system (DBMS) vs. database
6:29 – Relational database management systems RDBMS examples (MySQL, postgreSQL, Oracle db)
6:49 – no-SQL DBMS examples
7:05 – How to work with RDBMS: graphical user interfaces, connectors, apps
8:50 – 10 key statements about SQL

Learn SQL with Railsware Academy. Subscribe to our channel and follow the SQL YouTube course.
๐Ÿง Try Coupler.io – a tool for safe data imports from various tools to GSheets: https://bit.ly/sqldb-couplerws
๐Ÿ”Œ Download Coupler.io in GSuite marketplace: https://bit.ly/sqldb-couplermp
๐Ÿ’Œ Contact Railsware to build your software product http://bit.ly/contactrailsware
๐Ÿค Join Railsware team http://bit.ly/railswarecareers
โœ… Subscribe to Railsware and learn the most efficient data analytics tools with us!

Design: Vlad Shagov
Video editor: Oleg Gorovoi
Speaker: Anastasiia Avramenko

source

Categories
Video

What is SQL | DDL DML DQL | Data types in SQL | SQL Full Course | SQL Tutorial For Beginners (2/11)



What is SQL(Structured Query Language) , DDL , DML , DQL
Purpose of SQL
What are different data types in SQL Server
This is part of full course in SQL, In this series of videos I show you how to write SQL using MS SQL Server and SQL Server Management Studio. We go through Creating a Database, Creating Tables, Inserting, Updating, Deleting, Selecting, Grouping, Summing, Indexing, Joining, and every basic you need to get starting writing SQL.

#SQL #SQLServer #SQLTutorials

๐Ÿฌ Reference Books : https://www.amazon.in/shop/analyticswithnags

โœ‰ Business Queries / Analytics Consulting โœ‰ : analyticswithnags@gmail.com

๐Ÿ’ฌ For Learners Post queries and Interact ๐Ÿ’ฌ : http://t.me/analyticswithnags

Complete Playlists

Power BI Tutorials – Complete Playlist ๐Ÿ“š๐Ÿ“– https://youtu.be/T_bRcvmOMSM
Power BI Desktop Tips and Tricks ๐Ÿ“š๐Ÿ“– https://youtu.be/PyFQh8MmDWo
Power BI DAX – Complete Playlist ๐Ÿ“š๐Ÿ“– https://youtu.be/sCAQtqHINAQ
Power BI Project Dashboards – Power BI Realtime Projects – Playlist ๐Ÿ“š๐Ÿ“– https://youtu.be/wS2Hw9CPJeY
Power Pivot ๐Ÿ“š๐Ÿ“– https://youtu.be/lfLAvUARle4
Power Query ๐Ÿ“š๐Ÿ“– https://youtu.be/lfLAvUARle4
Power BI Services Playlist ๐Ÿ“š๐Ÿ“– https://youtu.be/F1BtmioYzGw
Power BI Tamil Tutorials ๐Ÿ“š๐Ÿ“– https://youtu.be/fY-8ShO1Di0
Power BI Telugu Tutorials ๐Ÿ“š๐Ÿ“– https://youtu.be/NU2A35Rz9NQ
SQL Full Course | SQL Tutorial For Beginners ๐Ÿ“š๐Ÿ“– https://youtu.be/5FrBJ4PXj2s
SSAS Tutorials – SQL Server Analysis Services ๐Ÿ“š๐Ÿ“– https://youtu.be/0YY7_k-Asmk
MSBI Tutorials – SQL + SSAS + SSIS ๐Ÿ“š๐Ÿ“– https://youtu.be/5FrBJ4PXj2s
Data Analyst – Complete Reference – Playlist ๐Ÿ“š๐Ÿ“– https://youtu.be/fWE93St-RaQ
BI Developer – Complete Reference – Playlist
๐Ÿ“š๐Ÿ“– https://youtu.be/AGrl-H87pRU
BI Architect – Complete Reference – Playlist
๐Ÿ“š๐Ÿ“– https://youtu.be/3u7MQz1EyPY
ETL Developer – Complete Reference – Playlist ๐Ÿ“š๐Ÿ“– https://youtu.be/9xwZyOzlMqU
Database Developer – Complete Reference – Playlist ๐Ÿ“š๐Ÿ“– https://youtu.be/HXV3zeQKqGY

source

Categories
Video

Getting Started with T-SQL Queries using SQL Server Management Studio



This sql query tutorial introduces SQL Server queries using Transact-SQL (T-SQL). It covers the SELECT statement, which includes concepts of: WHERE, ORDER BY, GROUP BY, aggregations, aggregate functions, and joins. In addition, it provides tips for working with queries SQL Server Management Studio. For more information, see: http://learningsqlserver.wordpress.com

source

Categories
Video

SQL SELECT Tutorial |ยฆ| SQL Tutorial |ยฆ| SQL for Beginners



The SELECT statement in SQL is how you fetch data from your database. In this SQL tutorial we give an introduction on how to write a SELECT query. We will cover the SELECT, FROM, WHERE, ORDER BY, and LIMIT statements with many examples.

The data used in this video is available as a CSV from Socratica on Github. You can download the data here: https://github.com/socratica/data

Our SQL playlist starts here:
โ†ชhttp://bit.ly/Socratica_SQL

Be sure to SUBSCRIBE for more SQL!
โ†ช http://bit.ly/SocraticaSubscribe

You may also enjoy our Python playlist:
โ†ชhttp://bit.ly/PythonSocratica

โ™ฆโ™ฆโ™ฆโ™ฆโ™ฆโ™ฆโ™ฆโ™ฆโ™ฆโ™ฆ

Ways to support our channel:

โ–บย  Join our Patreon : https://www.patreon.com/socratica
โ–บย  Make a one-time PayPal donation: https://www.paypal.me/socratica
โ–บย  We also accept Bitcoin @ 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9

Thank you!

โ™ฆโ™ฆโ™ฆโ™ฆโ™ฆโ™ฆโ™ฆโ™ฆโ™ฆโ™ฆ

Connect with us!

Facebook: https://www.facebook.com/SocraticaStudios/
Instagram: https://www.instagram.com/SocraticaStudios/
Twitter: https://twitter.com/Socratica

โ™ฆโ™ฆโ™ฆโ™ฆโ™ฆโ™ฆโ™ฆโ™ฆโ™ฆโ™ฆ

SQL instructor: Ulka Simone Mohanty (@ulkam on Twitter)
Written & Produced by Kimberly Hatch Harrison (@khhsocratica) & Michael Harrison (@mlh496)

โ™ฆโ™ฆโ™ฆโ™ฆโ™ฆโ™ฆโ™ฆโ™ฆโ™ฆโ™ฆ

source

Categories
Video

How to run SQL queries in phpMyAdmin



This tutorial demonstrates how to run SQL queries in phpMyAdmin.
Related article: https://support.hostgator.com/articles/specialized-help/technical/phpmyadmin/how-to-run-sql-queries-in-phpmyadmin

source

Categories
Video

How to use Jupyter Notebooks in Azure Data Studio | Azure Friday



Vicky Harp joins Scott Hanselman to show how Azure Data Studio combined the simple and robust SQL query editing experience of tools like SSMS with the flexibility and collaboration of Jupyter Notebooks. The November 2019 release of Azure Data Studio included SQL Server 2019 Guide as a Jupyter Book, which provides a richer troubleshooting experience.

4:00 – Demo

Announcing Jupyter Book support blog post
https://aka.ms/azfr/613/01

Download and install Azure Data Studio
https://aka.ms/azfr/613/02

microsoft/azuredatastudio GitHub repo
https://aka.ms/azfr/613/03

Latest news on the SQL Server Blog
https://aka.ms/azfr/613/04

Create a free account (Azure)
https://aka.ms/azfr/613/free

#microsoft #microsoftazure

source