Home
Search results “Number to month sql oracle”
Part 5   SQL query to find employees hired in last n months
 
04:53
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-5-sql-query-to-find-employees.html This question is asked is many sql server interviews. If you have used DATEDIFF() sql server function then you already know the answer. -- Replace N with number of months Select * FROM Employees Where DATEDIFF(MONTH, HireDate, GETDATE()) Between 1 and N
Views: 194134 kudvenkat
SQL Tutorial - SQL DATE Functions like GETDATE, DATEADD, CONVERT
 
09:54
http://www.learningsqlserver2008.com/ https://youtu.be/KmsmPOImpHo - Date functions in SQL Server 2012 GETDATE -- Today's date DATEADD - adding time interval to an existing Date DATEPART - return part of the date like year or month DATEDIFF - Give you the different between two dates DAY - returns the day of the month MONTH - return the Month of the Year YEAR - returns the year in the Sql expression CAST - Converts an expression of one data type to another in SQL Server 2008 R2 CONVERT - Convert expressions of one data type to another in sql server r2 SQL Tutorial
Views: 69113 baghul
Query to Find Employee hired in last n month & year
 
12:17
Hi guys today its very important tpoic in sql how to find the last employee who hired in last month and years. #lastnmonth&year Oracle database Unbeatable,Unbreakable Platform..
Views: 2970 Oracle World
SQL Aggregation queries using Group By, Sum, Count and Having
 
10:01
From SQL Queries Joes 2 Pros (Vol2) ch4.1. Learn up to write aggregated queries.
Views: 194254 Joes2Pros SQL Trainings
Sql query to select all names that start with a given letter without like operator
 
03:02
Text Article http://csharp-video-tutorials.blogspot.com/2017/01/sql-query-to-select-all-names-that.html Slides http://csharp-video-tutorials.blogspot.com/2017/01/sql-query-to-select-all-names-that_31.html SQL Server Interview Questions and Answers text articles & slides http://csharp-video-tutorials.blogspot.com/2014/05/sql-server-interview-questions-and.html SQL Server Interview Questions and Answers playlist https://www.youtube.com/playlist?list=PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss writing a SQL query to retrieve all student names that start with letter 'M' without using the LIKE operator. If the interviewer has not mentioned not to use LIKE operator, we would have written the query using the LIKE operator as shown below. SELECT * FROM Students WHERE Name LIKE 'M%' We can use any one of the following 3 SQL Server functions, to achieve exactly the same thing. CHARINDEX LEFT SUBSTRING The following 3 queries retrieve all student rows whose Name starts with letter 'M'. Notice none of the queries are using the LIKE operator. SELECT * FROM Students WHERE CHARINDEX('M',Name) = 1 SELECT * FROM Students WHERE LEFT(Name, 1) = 'M' SELECT * FROM Students WHERE SUBSTRING(Name, 1, 1) = 'M'
Views: 73319 kudvenkat
ORACLE: How to get FIRST and LAST day of a month ?
 
00:56
ORACLE DATE FUNCTION - trunc(date) - last_day()
Views: 529 How to do it ?
Part 8   SQL Query to find department with highest number of employees
 
04:03
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/06/part-8-sql-query-to-find-department.html Scenario asked in the SQL Server Interview Based on the above two tables write a SQL Query to get the name of the Department that has got the maximum number of Employees. To answer this question it will be helpful if you the knowledge of JOINS & GROUP BY in SQL Server. We discusses these in Parts 11 & 12 of SQL Server Tutorial video series. SQL query that retrieves the department name with maximum number of employees SELECT TOP 1 DepartmentName FROM Employees JOIN Departments ON Employees.DepartmentID = Departments.DepartmentID GROUP BY DepartmentName ORDER BY COUNT(*) DESC Scenario asked in the SQL Server Interview Based on the above two tables write a SQL Query to get the name of the Department that has got the maximum number of Employees. To answer this question it will be helpful if you the knowledge of JOINS & GROUP BY in SQL Server. We discusses these in Parts 11 & 12 of SQL Server Tutorial video series. SQL query that retrieves the department name with maximum number of employees SELECT TOP 1 DepartmentName FROM Employees JOIN Departments ON Employees.DepartmentID = Departments.DepartmentID GROUP BY DepartmentName ORDER BY COUNT(*) DESC
Views: 136944 kudvenkat
Oracle SQL: Exploring Date Functions
 
07:29
http://www.informit.com/store/oracle-sql-livelessons-video-training-downloadable-9780134275741?WT.mc_id=Social_YT Oracle SQL: Exploring Date Functions is an excerpt from Oracle SQL LiveLessons Video Training -- 6+ Hours of Video -- Oracle SQL LiveLessons Video Training covers the basics of the Oracle SQL programming language. This course covers both Oracle standard SQL and the ANSI approved SQL that Oracle supports. The focus of the course is to give students working knowledge of the Oracle SQL language and at the conclusion of this course, students should be able to query the Oracle database. Description In this LiveLessons video course, Oracle ACE Director Dan Hotka will teach you how to use the SQL query language, interpret business questions into SQL code, and how to use Where clauses sub-queries, complex table join conditions, and how to create table objects and populate tables with data. Students will also learn how to access Oracle from Microsoft products such as Excel. In addition, they will learn how analytical SQL can be used for business analysis. This course will use both Toad and SQL Developer for SQL examples. About the Instructor Dan Hotka is a training specialist and an Oracle ACE director who has more than 37 years in the computer industry and more than 31 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well published with 12 Oracle books and well over 200 published articles. He is also the video author for Oracle SQL Performance Tuning for Developers LiveLessons and Oracle PL/SQL Programming Fundamentals. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world. Visit his website at www.DanHotka.com. Skill Level Beginner Learn How To Use the SQL query language Interpret business questions into SQL code Understand Oracle standard SQL and ANSI SQL Work with Where clauses, sub-queries, and complex table join conditions Create table objects and populate these tables with data Access Oracle from Microsoft products such as Excel Use analytical SQL, useful for business analysts Who Should Take This Course Students who are new to SQL and want to learn Oracle SQL Course Requirements Basic knowledge of what is a database, especially RDBMS and what is a computer programming language http://www.informit.com/store/oracle-sql-livelessons-video-training-downloadable-9780134275741?WT.mc_id=Social_YT
Views: 5531 LiveLessons
Tutorial#45 TO_NUMBER function | Convert varchar value into number format
 
04:24
Oracle TO_NUMBER function is used to convert a text/varchar2/varchar/string value into a number value in Oracle 11g or how to convert varchar to number in oracle in the select query or what is conversion function is Oracle SQL or how to use to_number function is Oracle SQL Assignment link: https://drive.google.com/open?id=1ngkXONohE1AfRO2HaUXd1VRx3uZ8bAM1 follow me on: Facebook Page: https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks Contacts Email: [email protected] Instagram: https://www.instagram.com/equalconnect/ Twitter: https://twitter.com/LrnWthR #To_numberFunction #convertionFunctionInSQL #SQLtypeCast
Views: 346 EqualConnect Coach
Last Date Of the Month SQL Server
 
02:00
Published on Aug 27, 2017: In this video tutorial, we will use the Eomonth function to find the end date of the month for any given date. You can refer to the documentation for EOMonth function by clicking this link. https://youtu.be/Omort30gN-o Previous Video:https://youtu.be/8l5nPqVy-o0 SUBSCRIBE to learn more about Power BI,Power Query, Power Pivot, Excel and SQL Server! https://www.youtube.com/channel/UCYYHFZpm5GbaOmQKDNSTGLw Download the sample database used for the demo here: https://goo.gl/SVyVmT Our Playists: SQL Playlist :https://goo.gl/PS5Ep6 DAX PlayList : https://goo.gl/S4W41D Power BI PlayList: https://goo.gl/dXxvnB Power Query Playlist: https://goo.gl/5QS7P4 ABOUT DAGDOO: Website: Home Page: http://www.dagdoo.org/ Power BI Tutorials: http://www.dagdoo.org/excel-learning/tutorial-power-bi-desktop/ Questions? Comments and SUGESTIONS? You will find me here: Twitter: @dagdooe Category: Science & Technology License: Standard YouTube License
Views: 80 Learn 2 Excel
Finding the number of days between two dates
 
06:35
This is the third video in the series and it is on finding the days between two dates in SQL. We look up a date function and use it to tell the distance between a holiday and the current date.
Views: 1270 LL Easy
SQL Server - Get Start Date of Month From a Given Date
 
07:54
In this tutorial, we will learn "How to Get Start Date of Month From a Given Date" in SQL Server. We are going to build some logic here to get the start date of the current month, start date of the last month and start date of the next month by using some date function and tricks. To learn more, please visit us at - http://www.sql-datatools.com
Views: 10 Mukesh Singh
Part 1   How to find nth highest salary in sql
 
11:45
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-1-how-to-find-nth-highest-salary_17.html This is a very common SQL Server Interview Question. There are several ways of finding the nth highest salary. By the end of this video, we will be able to answer all the following questions as well. How to find nth highest salary in SQL Server using a Sub-Query How to find nth highest salary in SQL Server using a CTE How to find the 2nd, 3rd or 15th highest salary Let's use the following Employees table for this demo Use the following script to create Employees table Create table Employees ( ID int primary key identity, FirstName nvarchar(50), LastName nvarchar(50), Gender nvarchar(50), Salary int ) GO Insert into Employees values ('Ben', 'Hoskins', 'Male', 70000) Insert into Employees values ('Mark', 'Hastings', 'Male', 60000) Insert into Employees values ('Steve', 'Pound', 'Male', 45000) Insert into Employees values ('Ben', 'Hoskins', 'Male', 70000) Insert into Employees values ('Philip', 'Hastings', 'Male', 45000) Insert into Employees values ('Mary', 'Lambeth', 'Female', 30000) Insert into Employees values ('Valarie', 'Vikings', 'Female', 35000) Insert into Employees values ('John', 'Stanmore', 'Male', 80000) GO To find the highest salary it is straight forward. We can simply use the Max() function as shown below. Select Max(Salary) from Employees To get the second highest salary use a sub query along with Max() function as shown below. Select Max(Salary) from Employees where Salary [ (Select Max(Salary) from Employees) To find nth highest salary using Sub-Query SELECT TOP 1 SALARY FROM ( SELECT DISTINCT TOP N SALARY FROM EMPLOYEES ORDER BY SALARY DESC ) RESULT ORDER BY SALARY To find nth highest salary using CTE WITH RESULT AS ( SELECT SALARY, DENSE_RANK() OVER (ORDER BY SALARY DESC) AS DENSERANK FROM EMPLOYEES ) SELECT TOP 1 SALARY FROM RESULT WHERE DENSERANK = N To find 2nd highest salary we can use any of the above queries. Simple replace N with 2. Similarly, to find 3rd highest salary, simple replace N with 3. Please Note: On many of the websites, you may have seen that, the following query can be used to get the nth highest salary. The below query will only work if there are no duplicates. WITH RESULT AS ( SELECT SALARY, ROW_NUMBER() OVER (ORDER BY SALARY DESC) AS ROWNUMBER FROM EMPLOYEES ) SELECT SALARY FROM RESULT WHERE ROWNUMBER = 3
Views: 1050144 kudvenkat
SQL MONTH function - how to use SQL MONTH function
 
00:52
The SQL Server MONTH function returns the month (a number from 1 to 12) given a date value. visit Dose for excel Add-In website: http://www.zbrainsoft.com/ Visit our channel: https://www.youtube.com/channel/UCI4bMWYzrBTs47KINXL92Kw
Formatting your Oracle Query Results Directly to CSV
 
03:02
How to get Oracle SQL Developer to automatically format your query results to CSV, HTML, JSON, Insert statements, and more.
Views: 52269 Jeff Smith
Year-to-Date using Partition By with Windowing - SQL Training Online
 
05:43
You can use the Partition By Function in SQL Server to get a Year-to-Date and Month-to_Date calculation. In this video I show you how to create a Year-to-Date value using the Windowing Partition By Function in TSQL. READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE http://www.sqltrainingonline.com/year-to-date-using-the-partition-by-function-with-windowing-in-sql-server/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Google+: http://gplus.to/SQLTrainingOnline Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com
Views: 3994 Joey Blue
Part 6   Transform rows into columns in sql server
 
08:53
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/06/part-6-transform-rows-into-columns-in.html This is another common sql server interview question. We will be using Countries table in this example. SQL to create the table Create Table Countries ( Country nvarchar(50), City nvarchar(50) ) GO Insert into Countries values ('USA','New York') Insert into Countries values ('USA','Houston') Insert into Countries values ('USA','Dallas') Insert into Countries values ('India','Hyderabad') Insert into Countries values ('India','Bangalore') Insert into Countries values ('India','New Delhi') Insert into Countries values ('UK','London') Insert into Countries values ('UK','Birmingham') Insert into Countries values ('UK','Manchester') Here is the interview question. Write a sql query to transpose rows to columns. Using PIVOT operator we can very easily transform rows to columns. Select Country, City1, City2, City3 From ( Select Country, City, 'City'+ cast(row_number() over(partition by Country order by Country) as varchar(10)) ColumnSequence from Countries ) Temp pivot ( max(City) for ColumnSequence in (City1, City2, City3) ) Piv
Views: 217616 kudvenkat
DBMS_RANDOM : Generating Random Data (Numbers, Strings and Dates) in Oracle
 
02:53
A demonstration of how to generate random numbers, strings and dates using the DBMS_RANDOM package in Oracle. For more information see: https://oracle-base.com/articles/misc/dbms_random.php Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Chet Justice and LC Blog: http://www.oraclenerd.com/ Twitter: https://twitter.com/oraclenerd Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 3984 ORACLE-BASE.com
SQL Row Number / Window Function Example - Top NY Baby Names by Year
 
10:58
Using BigQuery's free tier (1TB per month) we explore baby name data and incorporate the basics of row_number,() where clauses and sub querying to filter inner queries. This was "live" so you see a few errors and my thought process. https://cloud.google.com/bigquery/pricing. A great way to learn SQL (applicable to postgressql, oracle, mssql server and others).
Views: 554 Jeffrey James
LAST VALUE function in SQL Server
 
05:35
last_value function in sql server 2008 sql server last_value function returns incorrect data sql server last_value function example sql server last_value function with partition example LAST_VALUE function in SQL Server In this video we will discuss LAST_VALUE function in SQL Server. LAST_VALUE function Introduced in SQL Server 2012 Retrieves the last value from the specified column ORDER BY clause is required PARTITION BY clause is optional ROWS or RANGE clause is optional, but for it to work correctly you may have to explicitly specify a value Syntax : LAST_VALUE(Column_Name) OVER (ORDER BY Col1, Col2, ...) LAST_VALUE function not working as expected : In the following example, LAST_VALUE function does not return the name of the highest paid employee. This is because we have not specified an explicit value for ROWS or RANGE clause. As a result it is using it's default value RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW. SELECT Name, Gender, Salary, LAST_VALUE(Name) OVER (ORDER BY Salary) AS LastValue FROM Employees LAST_VALUE function working as expected : In the following example, LAST_VALUE function returns the name of the highest paid employee as expected. Notice we have set an explicit value for ROWS or RANGE clause to ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING This tells the LAST_VALUE function that it's window starts at the first row and ends at the last row in the result set. SELECT Name, Gender, Salary, LAST_VALUE(Name) OVER (ORDER BY Salary ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS LastValue FROM Employees LAST_VALUE function example with partitions : In the following example, LAST_VALUE function returns the name of the highest paid employee from the respective partition. SELECT Name, Gender, Salary, LAST_VALUE(Name) OVER (PARTITION BY Gender ORDER BY Salary ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS LastValue FROM Employees Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/lastvalue-function-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/lastvalue-function-in-sql-server_9.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html Full SQL Server Course https://www.youtube.com/playlist?list=PL4cyC4G0M1RQ_Rm52cQ4CcOJ_T_HXeMB4 All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 37722 kudvenkat
Oracle DV - Use TimestampDiff to Calculate Interval Between Two Dates
 
01:46
This video shows simple way to leveage TimestampDiff function in Oracle DV to calculate time interval between two dates. Download the latest version of DV today https://www.oracle.com/technetwork/middleware/oracle-data-visualization/downloads/oracle-data-visualization-desktop-2938957.html.
Views: 547 Oracle Analytics
SQL MONTH() Function
 
01:36
The SQL MONTH() is a function, and return or extract the month value (a whole integer number from 1 to 12) of a given input date value.
Views: 235 suresh babu
Row Number function in SQL Server
 
07:24
sql server row_number example sql server row number by partition sql server row_number over partition by order by In this video we will discuss Row_Number function in SQL Server. This is continuation to Part 108. Please watch Part 108 from SQL Server tutorial before proceeding. Row_Number function Introduced in SQL Server 2005 Returns the sequential number of a row starting at 1 ORDER BY clause is required PARTITION BY clause is optional When the data is partitioned, row number is reset to 1 when the partition changes Syntax : ROW_NUMBER() OVER (ORDER BY Col1, Col2) Row_Number function without PARTITION BY : In this example, data is not partitioned, so ROW_NUMBER will provide a consecutive numbering for all the rows in the table based on the order of rows imposed by the ORDER BY clause. SELECT Name, Gender, Salary, ROW_NUMBER() OVER (ORDER BY Gender) AS RowNumber FROM Employees Please note : If ORDER BY clause is not specified you will get the following error The function 'ROW_NUMBER' must have an OVER clause with ORDER BY Row_Number function with PARTITION BY : In this example, data is partitioned by Gender, so ROW_NUMBER will provide a consecutive numbering only for the rows with in a parttion. When the partition changes the row number is reset to 1. SELECT Name, Gender, Salary, ROW_NUMBER() OVER (PARTITION BY Gender ORDER BY Gender) AS RowNumber FROM Employees Use case for Row_Number function : Deleting all duplicate rows except one from a sql server table. Discussed in detail in Part 4 of SQL Server Interview Questions and Answers video series. Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/rownumber-function-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/rownumber-function-in-sql-server_30.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 94382 kudvenkat
Tutorial#48 How to use Power function in Oracle SQL Database| Number function in Oracle SQL
 
03:37
The Oracle SQL POWER function returns m raised to the nth power or Numeric Functions - Ceil, Floor, Round, mod, replace, power or How to use Power function in SQL or what is the numeric function oracle SQL database ------------------------------------------------------------------------ Assignment link: https://drive.google.com/open?id=1b50AeTyzAhHchqH1IGrgiu1ybAsMtIDX ------------------------------------------------------------------------------- SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator. Hi viewer, you might be thinking of the following question so landed at the right place you might get the answer to the following question how to learn sql some good sql tutorial how to find sql basics course, SQL training, SQL practice material, SQL practice online how to master oracle SQL best way to learn/practice oracle SQL best sql tutorial videos good video tutorial on SQL What are the query optimization techniques in Oracle/SQL follow me on: Facebook Page: https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks Contacts Email: [email protected] Instagram: https://www.instagram.com/equalconnect/ Twitter: https://twitter.com/LrnWthR
Views: 100 EqualConnect Coach
How to Join 3 tables in 1 SQL query
 
04:59
Get your first month on the Joes 2 Pros Academy for just $1 with code YOUTUBE1. Visit http://www.joes2pros.com Offer expires July 1, 2015 From the newly released 2 Disc DVD set (SQL Queries Joes 2 Pros Vol2) this video shows how to join 3 tables in 1 query.
Views: 273277 Joes2Pros SQL Trainings
Lesson 6 - SQL Operators (Oracle SQL Certification)
 
19:46
Access all of my courses using the below discount: https://www.jobreadyprogrammer.com/p/all-access-pass/?product_id=1065350&coupon_code=60_PERCENT_DISCOUNT&preview=logged_out #Oracle #Java #Data analysis Get ready to acquire some seriously marketable programming skills! You can't consider yourself a complete end to end developer until you can code in SQL. Today, data has become the hottest topic in technology and a company's biggest asset is their data. All databases require the language SQL to store and retrieve data. Salaries for junior level SQL Developers are upwards of $70,000 - $90,000 dollars a year! The great thing is, for this course, you do not need any prior experience in programming what so ever. SQL is a different animal and we're going to demystify the language from scratch and prepare you with plenty of progressively challenging assignments so that by the time you've completed the course (in 2 months), you can call your self an Oracle SQL Master! Oracle is the most popular relational database in the world! This course will prepare you to be job-ready in just 1 month of study and practice. All exercises and solutions are in the lectures. In several lectures I ask students to pause the video and complete the assignment before resuming to watch my solution. MAKE SURE YOU WORK OUT THE PROBLEMS ON YOUR OWN BEFORE MOVING ON TO MY SOLUTION!! Who this course is for: Anyone willing to get into the software development career Anyone willing to Master SQL and get a job as a well paid Oracle SQL Developer Anyone willing to work hard in mastering the SQL language Anyone who is interested in passing the Oracle 1Z0-071 exam!
Views: 4960 Imtiaz Ahmad
Best Way to Write Basic SQL Queries
 
13:33
SQL Server Query writing strategies is something I have yet to find in any book. When enthusiastic SQL students do this, they experience a revelation. The number of errors drops significantly and the speed at writing complex queries increases immediately. Knowing how to narrow down what we are looking for amongst a vast list of choices helps immensely. Grabbing the right tables first and then the fields second is akin to grabbing the right menu before ordering an item from it. In fact, one student named Tim took this back to his team of SQL developers and they immediately implemented this process. We are all used to following steps. Most of the time, actions are sequential from top to bottom or left to right. Other times we complete things in phases. The two phases we are going to use in this exercise apply to joining tables. This is easy to implement as we only need remember to organize first and clean up second. When visiting a new restaurant, we will ask to see the menu, because we want to see all they have to offer. The odds are that we might be interested in half of the items, but only need a few dishes for our group at the table. Looking at the menu is like starting a query with a ‘SELECT *’ statement. Once we have looked at all the fields, we narrow our choice(s) to only the items we want at the time. Sometimes restaurants have multiple menus. My favorite restaurant has a kids’ menu, an adult menu, a gluten-free menu and a drink menu. These menus were each gathered at our table. Ultimately, in my head, a selection was narrowed to what was needed. Phase I: Organize. When building a new query from many tables, we often find ourselves wondering, “Where do I start?” First, lay the steps out by identifying which tables contain the essential data. Second, get all the table joins working with a basic ‘SELECT *’ statement. Third, add any basic filtering criteria. Phase II: Itemize. Once all joins and criteria, such as SELECT, FROM and WHERE are working, we are ready for Phase II. This entails going back and changing our ‘SELECT *’ to an itemized SELECT field list as the final step. Let’s explore how this two-phase process of Organize and then Itemize can be a big time-saver. We are going to use one of the challenges from the last lab. In Lab 3.2 (Outer Joins), Skill Check 2, we needed to get four fields from two different tables. If we were to list all four desired fields and test one table at time, we will get an error as seen on the right side of the figure below. In the figure below we write a SELECT statement and part of the FROM clause. When completed, the FROM clause will have two tables, but for now we just want to get the Location table working. By using the ‘SELECT *’ strategy, we remove any possible errors from line 1. From there, we can focus on the more complicated logic used for joining tables together. We can add tables one at a time until everything is working. This is the Organize phase. NOTE: SELECT * never results in an Error message stating “invalid column name”, however; a SELECT list with itemized field(s) can have this error. After our query is organized and working, we can go back and itemize the SELECT field list to display only the fields that are necessary. This is done during Phase II (Itemize). The steps for this system are broken down as follows: Since SELECT is always the first statement in a query, it’s natural to want to write the field names before writing the FROM clause. However; we can save time and trouble by using the ‘*’ until the entire query is working properly. When this is complete, it is very easy to itemize the field list, with the confidence of knowing it will not cause any problems. Exercise: Simple membership for a club: Table1 (id_Member,name_Member, email_member, title, age, company) Table2 (id_Club,club_name, club_Location, address) Table3 (id_club, id_member,membership_date) Q1: Show all member names, email, age, and company from Table1 Q2: Show all club name, location, and address data Q3: Show member name, club name, club location (hint: Use joins and all 3 tables) You can find all other classes related to this video here: http://www.joes2pros.com/joes2pros/Course/Introduction_To_Microsoft_SQL_Server Enroll Today & Get the First Month for only $1! Use code: YOUTUBE1
Views: 281582 Joes2Pros SQL Trainings
Part 2   SQL query to get organization hierarchy
 
10:14
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-2-sql-query-to-get-organization.html To get the best out of this video, the following concepts need to be understood first. These are already discussed in SQL Server Tutorial. 1. Self-Join - http://www.youtube.com/watch?v=qnYSN_7qwgg 2. CTE - http://www.youtube.com/watch?v=ZXB5b-7HJHk 3. Recursive CTE - http://www.youtube.com/watch?v=GGoV0wTMCg0 Here is the problem definition: 1. Employees table contains the following columns a) EmployeeId, b) EmployeeName c) ManagerId 2. If an EmployeeId is passed, the query should list down the entire organization hierarchy i.e who is the manager of the EmployeeId passed and who is managers manager and so on till full hierarchy is listed. For example, Scenario 1: If we pass David's EmployeeId to the query, then it should display the organization hierarchy starting from David. Scenario 2: If we pass Lara's EmployeeId to the query, then it should display the organization hierarchy starting from Lara. We will be Employees table for this demo. SQL to create and populate Employees table with test data Create table Employees ( EmployeeID int primary key identity, EmployeeName nvarchar(50), ManagerID int foreign key references Employees(EmployeeID) ) GO Insert into Employees values ('John', NULL) Insert into Employees values ('Mark', NULL) Insert into Employees values ('Steve', NULL) Insert into Employees values ('Tom', NULL) Insert into Employees values ('Lara', NULL) Insert into Employees values ('Simon', NULL) Insert into Employees values ('David', NULL) Insert into Employees values ('Ben', NULL) Insert into Employees values ('Stacy', NULL) Insert into Employees values ('Sam', NULL) GO Update Employees Set ManagerID = 8 Where EmployeeName IN ('Mark', 'Steve', 'Lara') Update Employees Set ManagerID = 2 Where EmployeeName IN ('Stacy', 'Simon') Update Employees Set ManagerID = 3 Where EmployeeName IN ('Tom') Update Employees Set ManagerID = 5 Where EmployeeName IN ('John', 'Sam') Update Employees Set ManagerID = 4 Where EmployeeName IN ('David') GO Here is the SQL that does the job Declare @ID int ; Set @ID = 7; WITH EmployeeCTE AS ( Select EmployeeId, EmployeeName, ManagerID From Employees Where EmployeeId = @ID UNION ALL Select Employees.EmployeeId , Employees.EmployeeName, Employees.ManagerID From Employees JOIN EmployeeCTE ON Employees.EmployeeId = EmployeeCTE.ManagerID ) Select E1.EmployeeName, ISNULL(E2.EmployeeName, 'No Boss') as ManagerName From EmployeeCTE E1 LEFT Join EmployeeCTE E2 ON E1.ManagerID = E2.EmployeeId
Views: 316040 kudvenkat
ORACLE: How to extract YEAR from date ?
 
00:50
- Extract year to number. - Extract year to text (spelling).
Views: 44 How to do it ?
Getting Unique Records with DISTINCT (Introduction to Oracle SQL)
 
04:22
How to find unique records using the DISTINCT keyword
Views: 246 Database Star
SQL MONTHNAME() Function
 
01:05
The SQL MONTHNAME() is a function, and returns a string indicating the full name of the specified month of a given input date value.
Views: 239 suresh babu
ORACLE: How to extract MONTH from date ?
 
00:50
- extract month to number (01-12). - extract fist 3 letters of month. - extract month to text.
Views: 53 How to do it ?
SQL Tutorial - 13: Inserting Data Into a Table From Another Table
 
07:00
In this tutorial we'll learn to use the INSERT Query to copy data from one table into another.
Views: 279871 The Bad Tutorials
how to get 1st ,2nd ,3rd ,nth highest  salary using sql part 1?video by intelligent programming
 
08:49
how to get 1st ,2nd ,3rd ,nth highest salary using sql query.
How to find Top Three Salaries from employee table ?
 
07:27
Hello guys in this video i m showing to you how to retrieve the top most salary from table. #TopThreeSalaries Oracle database Unbeatable,Unbreakable Platform..
Views: 8425 Oracle World
Fetch or Filter Data from Date to Date
 
17:35
The Data Fetch or filter or search From date to date ( month to month , year to year ) by using datetimepicker in Dot Net.
Views: 68198 C# Tutorial
Convert number to a string
 
02:54
Published on Sep 02, 2017: In this video tutorial, we will learn to convert a number to a string using sql server. We will use the str function for the same. Documentation for the str function can be found at the below location: https://goo.gl/ifys11 SQL used in the example is copied below. Select 100+'-Test' Select Str(100)+'-Test' SELECT STR(123.46, 8, 4) Previous Video:https://youtu.be/yXOm3dWFbyE SUBSCRIBE to learn more about Power BI,Power Query, Power Pivot, Excel and SQL Server! https://www.youtube.com/channel/UCYYHFZpm5GbaOmQKDNSTGLw Download the sample database used for the demo here: https://goo.gl/SVyVmT Our Playists: SQL Playlist :https://goo.gl/PS5Ep6 DAX PlayList : https://goo.gl/S4W41D Power BI PlayList: https://goo.gl/dXxvnB Power Query Playlist: https://goo.gl/5QS7P4 ABOUT DAGDOO: Website: Home Page: http://www.dagdoo.org/ Power BI Tutorials: http://www.dagdoo.org/excel-learning/tutorial-power-bi-desktop/ Questions? Comments and SUGESTIONS? You will find me here: Twitter: @dagdooe Category: Science & Technology License: Standard YouTube License
Views: 171 Learn 2 Excel
Gemini***I'm Okay with Walking Away***Mid July 2019 General Tarot
 
27:45
Decks: https://www.usgamesinc.com/Rider-Waite-Tarot-Card-Deck.html https://www.barnesandnoble.com/w/moonology-oracle-cards-yasmin-boland/1127173524?ean=9781781809969 https://www.barnesandnoble.com/w/numerology-guidance-cards-michelle-buchanan/1117474694 I work full time during the week Monday through Friday. So, I’ve created a system on the website that allows you to view my availability. If you select ‘Services’ on the website, it will lead you to the Calendar option. From there, you can select the reading you’d like, the day and time you’d like and then go through payment with PayPal, Credit or Debit. You and I will both receive a notice, and on the day and time of our scheduled appointment, I will contact you via the phone number you leave me during registration. If you would like an individual reading, please visit www.pointyourcompass.com to book your appointment with me or email me at [email protected] Also, you can look me up on my Facebook page at https://www.facebook.com/PointYourCompass/ and message me from there. https://www.video.net/video/moon-over-sea-at-night/1675
Views: 11303 Miriam Kramer
VLOOKUP or SUM Not Working? Convert Text to Date? (Excel Text to Columns)
 
04:55
This tutorial uses Excel's Text to Columns feature to address two common Excel problems. Problem 1: VLOOKUP formula doesn't work One common reason for your VLOOKUP formulas or SUMIFS formulas not working is that Excel doesn't recognize the numbers as numbers. It sees them as text. Even if you change the cell custom formatting from General to a Number, your formulas still don't work. This is a common issue when you import data to Excel from SAP or Oracle systems. Problem 2: Dates are not recognized as dates in Excel. - sometimes imported dates from other systems to Excel are seen as text or number but not as a date. Excel's text to column feature can convert these super fast into dates. ⯆ DOWNLOAD the workbook & read the article: https://www.xelplus.com/excel-text-to-columns/ LINKS to related videos: VLOOKUP - https://youtu.be/hwL6KKJP-_I ★ My Online Excel Courses ► https://courses.xelplus.com ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Camera: https://amzn.to/2FLiFho Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Microphone: https://amzn.to/2DVKstA Lights: http://amzn.to/2eJKg1U More resources on my Amazon page: https://www.amazon.com/shop/leilagharani Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #MsExcel
Views: 23791 Leila Gharani
SQL YEAR() Function
 
01:25
The SQL YEAR() is a function, and returns or extract year portion(a four digit number) of a given input date value.
Views: 273 suresh babu
Leo***Finally Information that Gives You Choice*** Mid July 2019 General Tarot Reading
 
20:21
Decks: https://www.usgamesinc.com/Rider-Waite-Tarot-Card-Deck.html https://www.barnesandnoble.com/w/moonology-oracle-cards-yasmin-boland/1127173524?ean=9781781809969 https://www.barnesandnoble.com/w/numerology-guidance-cards-michelle-buchanan/1117474694 I work full time during the week Monday through Friday. So, I’ve created a system on the website that allows you to view my availability. If you select ‘Services’ on the website, it will lead you to the Calendar option. From there, you can select the reading you’d like, the day and time you’d like and then go through payment with PayPal, Credit or Debit. You and I will both receive a notice, and on the day and time of our scheduled appointment, I will contact you via the phone number you leave me during registration. If you would like an individual reading, please visit www.pointyourcompass.com to book your appointment with me or email me at [email protected] Also, you can look me up on my Facebook page at https://www.facebook.com/PointYourCompass/ and message me from there. https://www.video.net/video/moon-over-sea-at-night/1675
Views: 9132 Miriam Kramer
SDU Tools 91   Number to Roman Numerals in SQL Server T-SQL
 
01:34
SDU Tools are free tools for SQL Server developers and DBAs. We get some odd requests at times and this month is no different. We had a request for a function that could convert a number to roman numerals in T-SQL, and so that's just what this function does. It even handles quite large numbers. To join SDU Insiders and get all our free resources, including SDU Tools, see the details at http://sdutools.sqldownunder.com
Views: 31 SQL Down Under
Retrieve Month Name From Date
 
00:50
Use the TEXT function to retreive a month name from a date value in Excel.
Views: 426 Garrett Horton
Date Functions in SQL SERVER Part III || DATEPART, DATETIME2FROMPARTS, DATETIMEFROMPARTS and EOMONTH
 
04:31
This video will provide you the details of each Date and Time Data Types and Function in SQL Server 2014. Last session for date other date functions: Part I https://www.youtube.com/watch?v=2x29rH6nY3s Part II https://www.youtube.com/watch?v=A0NM91RIaLI *************************************************************************  DATEPART (Transact-SQL) Returns an integer that represents the specified datepart of the specified date.  Syntax DATEPART ( datepart , date )  Arguments datepart Is the part of date (a date or time value) for which an integer will be returned. The following table lists all valid datepart arguments. User-defined variable equivalents are not valid. date Is an expression that can be resolved to a time, date, smalldatetime, datetime, datetime2, or datetimeoffset value. date can be an expression, column expression, user-defined variable, or string literal. To avoid ambiguity, use four-digit years.  Return Type Int *************************************************************************  DATETIME2FROMPARTS (Transact-SQL) Returns a datetime2 value for the specified date and time and with the specified precision.  Syntax DATETIME2FROMPARTS ( year, month, day, hour, minute, seconds, fractions, precision )  Arguments year Integer expression specifying a year. month Integer expression specifying a month. Softtechforum day Integer expression specifying a day. hour Integer expression specifying hours. minute Integer expression specifying minutes. seconds Integer expression specifying seconds. fractions Integer expression specifying fractions. precision Integer literal specifying the precision of the datetime2 value to be returned.  Return Types datetime2( precision )  Examples • Example without fractions of a second SELECT DATETIME2FROMPARTS ( 2016, 12, 31, 23, 59, 59, 0, 0 ) AS Result; • Example with fractions of a second The following example demonstrates the use of the fractions and precision parameters: 1. When fractions has a value of 5 and precision has a value of 1, then the value of fractions represents 5/10 of a second. 2. When fractions has a value of 50 and precision has a value of 2, then the value of fractions represents 50/100 of a second. 3. When fractions has a value of 500 and precision has a value of 3, then the value of fractions represents 500/1000 of a second. Transact-SQL SELECT DATETIME2FROMPARTS (2016, 8, 15, 14, 23, 44, 5, 1 ); SELECT DATETIME2FROMPARTS (2016, 8, 15, 14, 23, 44, 50, 2 ); SELECT DATETIME2FROMPARTS (2016, 8, 15, 14, 23, 44, 500, 3 ); *************************************************************************  DATETIMEFROMPARTS (Transact-SQL) Returns a datetime value for the specified date and time.  Syntax DATETIMEFROMPARTS ( year, month, day, hour, minute, seconds, milliseconds )  Arguments year Integer expression specifying a year. month Integer expression specifying a month. day Integer expression specifying a day. hour Integer expression specifying hours. minute Integer expression specifying minutes. seconds Integer expression specifying seconds. milliseconds Integer expression specifying milliseconds.  Return Types datetime  Examples SELECT DATETIMEFROMPARTS ( 2016, 12, 31, 23, 59, 59, 0 ) AS Result; *************************************************************************  DAY/YEAR/MONTH (Transact-SQL) Returns an integer representing the day (day of the month)/year/month of the specified date.  Syntax DAY ( date ) / YEAR ( date ) / MONTH ( date )  Arguments date Is an expression that can be resolved to a time, date, smalldatetime, datetime, datetime2, or datetimeoffset value. The date argument can be an expression, column expression, user-defined variable or string literal.  Return Type Int  Return Value DAY returns the same value as DATEPART (day, date). Same with DATEPART(month,date) and DATEPART(year,date) If date contains only a time part, the return value is 1, the base day. *************************************************************************  EOMONTH (Transact-SQL) Returns the last day of the month that contains the specified date, with an optional offset.  Syntax EOMONTH ( start_date [, month_to_add ] )  Arguments start_date Date expression specifying the date for which to return the last day of the month. month_to_add Optional integer expression specifying the number of months to add to start_date. If this argument is specified, then EOMONTH adds the specified number of months to start_date, and then returns the last day of the month for the resulting date. If this addition overflows the valid range of dates, then an error is raised.  Return Type date
Views: 45 Softtech forum
Taurus**Someone Ain't Happy** Mid-July 2019 General Tarot Reading
 
15:20
Decks: https://www.usgamesinc.com/Rider-Waite-Tarot-Card-Deck.html https://www.barnesandnoble.com/w/moonology-oracle-cards-yasmin-boland/1127173524?ean=9781781809969 https://www.barnesandnoble.com/w/numerology-guidance-cards-michelle-buchanan/1117474694 I work full time during the week Monday through Friday. So, I’ve created a system on the website that allows you to view my availability. If you select ‘Services’ on the website, it will lead you to the Calendar option. From there, you can select the reading you’d like, the day and time you’d like and then go through payment with PayPal, Credit or Debit. You and I will both receive a notice, and on the day and time of our scheduled appointment, I will contact you via the phone number you leave me during registration. If you would like an individual reading, please visit www.pointyourcompass.com to book your appointment with me or email me at [email protected] Also, you can look me up on my Facebook page at https://www.facebook.com/PointYourCompass/ and message me from there. https://www.video.net/video/moon-over-sea-at-night/1675
Views: 10521 Miriam Kramer
Aries ***Who the Heck is This??*** July 2019 General Tarot Reading
 
23:48
Decks: https://www.usgamesinc.com/Rider-Waite-Tarot-Card-Deck.html https://www.barnesandnoble.com/w/moonology-oracle-cards-yasmin-boland/1127173524?ean=9781781809969 https://www.barnesandnoble.com/w/numerology-guidance-cards-michelle-buchanan/1117474694 I work full time during the week Monday through Friday. So, I’ve created a system on the website that allows you to view my availability. If you select ‘Services’ on the website, it will lead you to the Calendar option. From there, you can select the reading you’d like, the day and time you’d like and then go through payment with PayPal, Credit or Debit. You and I will both receive a notice, and on the day and time of our scheduled appointment, I will contact you via the phone number you leave me during registration. If you would like an individual reading, please visit www.pointyourcompass.com to book your appointment with me or email me at [email protected] Also, you can look me up on my Facebook page at https://www.facebook.com/PointYourCompass/ and message me from there. https://www.video.net/video/moon-over-sea-at-night/1675
Views: 20709 Miriam Kramer
Oracle Training - Accounts Payable in Oracle E-Business Suite R12 (1080p - HD)
 
12:00
http://www.i-oracle.com/ - Oracle Training and Tutorials - Learn how to enter and pay an invoice in Oracle Applications E-Business Suite R12. Use the R12 interface to also match the invoice to a Purchase Order, validate and approve the invoice. View Subledger Accounting (SLA) transactions, view invoice details. And many more.
Views: 410365 Yemi Onigbode