Home
Search results “Oracle least null”
SQL Oracle Greatest and Least Functions
 
07:50
SQL Oracle Greatest and Least Functions You can use https://livesql.oracle.com to run you r sample queries and learn. Commands used: /*List Functions – GREATEST and LEAST*/ SELECT GREATEST(employee_id, department_id,salary), employee_id, department_id,salary from hr.employees; SELECT GREATEST(5, 18, 21, 3, 65) AS GREATEST_CHECK, LEAST(5, 18, 21, 3, 65) AS LEAST_CHECK FROM dual; SELECT GREATEST('Fred', 'Edward', 'Ruby', 'Jane') AS GREATEST_CHECK, LEAST('Fred', 'Edward', 'Ruby', 'Jane') AS LEAST_CHECK FROM dual; SELECT GREATEST('9', '12', '73', '15') AS GREATEST_CHECK, LEAST('9', '12', '73', '15') AS LEAST_CHECK FROM dual; SELECT GREATEST('45', 'apple', 'banana', 100) AS GREATEST_CHECK, LEAST('45', 'apple', 'banana', 100) AS LEAST_CHECK FROM dual; SELECT GREATEST( TO_DATE('25-MAR-2017'), TO_DATE('14-APR-2017'), TO_DATE('7-JAN-2017')) AS GREATEST_CHECK, LEAST( TO_DATE('25-MAR-2017'), TO_DATE('14-APR-2017'), TO_DATE('7-JAN-2017')) AS LEAST_CHECK FROM dual; SELECT GREATEST('Fred', 'Edward', NULL, 'Jane') AS GREATEST_CHECK, LEAST('Fred', 'Edward', NULL, 'Jane') AS LEAST_CHECK FROM dual; SELECT GREATEST('x', 'w','y', 'a', 'q', 'u', 'i', 'a', 'd', 's', 'g', 'k', 'e', 'w', 'i', 'p','a', 'z', 'b', 'c', 'm','w', 'r', 'y', 'n', 'Z') AS GREATEST_CHECK, LEAST('x', 'w','y', 'a', 'q', 'u', 'i', 'a', 'd', 's', 'g', 'k', 'e', 'w', 'i', 'p','a', 'z', 'b', 'c', 'm','w', 'r', 'y', 'n') AS LEAST_CHECK FROM dual;
Views: 55 Nids Dixit
COALESCE IN ORACLE SQL
 
06:50
This video is the 4th video in the series of 'working with null', this video explains the working of the coalesce function in oracle sql. Also the video explains the use of coalesce function in oracle sql queries by perfect simple and easy to understand examples. COALESCE returns the first non-null expr in the expression list. You must specify at least two expressions. If all occurrences of expr evaluate to null, then the function returns null. Oracle Database uses short-circuit evaluation. The database evaluates each expr value and determines whether it is NULL, rather than evaluating all of the expr values before determining whether any of them is NULL. If all occurrences of expr are numeric datatype or any non numeric datatype that can be implicitly converted to a numeric datatype, then Oracle Database determines the argument with the highest numeric precedence, implicitly converts the remaining arguments to that datatype, and returns that datatype.
Views: 1120 Kishan Mashru
Oracle GREATEST Function
 
02:43
https://www.databasestar.com/oracle-greatest/ The Oracle GREATEST function is a useful function, but I don’t think it’s very well understood. It returns the greatest or largest value in a set of values. You can provide the values, and use numbers or text values. The syntax for the Oracle GREATEST function is: GREATEST(expr1 [, expr_n]) The expr1 is the first expression to use for your comparison. Expr_n is one or more expressions to use in the comparison, separated by commas. This is optional. So how is GREATEST calculated? If the parameters are numeric, the GREATEST function finds the largest number. If the parameters are characters, the function finds the latest value if they were sorted alphabetically (using their character values). What data type is returned? It depends on the parameters you provide. It could be the same as the parameters you provide, or VARCHAR2 if the parameters are all characters. You can also use the GREATEST function with dates. It’s also the opposite of the LEAST function. For more information on the GREATEST function, including the SQL used in this video and the examples, read the related post here: https://www.databasestar.com/oracle-greatest/
Views: 325 Database Star
Null: Databases for Developers #10
 
07:42
The null value represents missing or unknown information. But using it brings complications to your SQL. In this video Chris discusses how to work with null to ensure you get the correct results. Further reading: Oracle Database SQL Reference on Nulls: http://docs.oracle.com/database/122/SQLRF/Nulls.htm#SQLRF30037 Null related functions: http://docs.oracle.com/database/122/SQLRF/Single-Row-Functions.htm#SQLRF51187 Is null condition: http://docs.oracle.com/database/122/SQLRF/Null-Conditions.htm#SQLRF52152 Need help with SQL? Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ ============================ The Magic of SQL with Chris Saxon 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.
Views: 3607 The Magic of SQL
SQL Q & A Part 3 - NULL Functions NVL, NVL2, NULLIF, DECODE, & COALESCE
 
03:59
NULL is a keyword used to represent ‘unknown’ or ‘missing’ data. NULL is not ‘zero’ or ‘blank’. SQL NULL functions are used to validate it. Explained NVL(), NVL2(), NULLIF(), DECODE() & COALESCE() in detail with examples SQL Interview Q & A Playlist: https://www.youtube.com/watch?v=t2qoqI5TjSk&list=PLSo-SnVTqbBLavDdG89zpQZDWkoEc9LP_ LINUX Interview Q & A Playlist: https://www.youtube.com/watch?v=1WEZqImoxzs&list=PLSo-SnVTqbBIBjEhxwRV3hbYmfXOWiYmR Technology You Must Know Playlist: https://www.youtube.com/watch?v=9FPrr1f2yjo&list=PLSo-SnVTqbBK4qk42HRrawr17mBITQmJd
Views: 1197 Shivanand V
Null Values in Attributes | Database Management System
 
01:21
This lecture explains about Null Values in attributes. To ask your doubts on this topic and much more, click on this Direct Link: http://www.techtud.com/video-lecture/lecture-21 IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE(for 'All India Test Series for GATE-2016'): http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate/ Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about our regularly uploaded new videos.
Views: 18573 Techtud
How to Detect Soft Corruption in Oracle 12c Database
 
18:19
Detection of Soft Corruption in 12c: To use the scripts below replace : , ",# and $ by proper bracket Lets Create a tablespace and small table. SQL: create tablespace DEMO1 datafile '/u02/tstdb1/TSTDB1/datafile/demo01.dbf' size 50M SQL: create table objects tablespace DEMO1 as select * from dba_objects; SQL: alter table objects add constraint pk_obj primary key #object_id$; SQL: create index idx_obj_name on objects#object_name$ tablespace demo1; Backup tablespace. RMAN: backup tablespace DEMO1; We need to put the DB in archivelog first Rebuild index with NOLOGGING option to simulate soft corruption later. RMAN: alter index idx_obj_name rebuild nologging; Confirm that we have datafiles that require backup because they have been affected with NOLOGGING operation. RMAN: report unrecoverable; Simulate corruption. RMAN: alter database datafile 5 offline; RMAN: restore datafile 5; RMAN: recover datafile 5; RMAN: alter database datafile 5 online; Query table with corrupted index and notice error. SQL: select count#*$ from objects where object_name like 'A%'; Let’s perform validation of datafile to check block corruption. RMAN: backup validate check logical datafile 5; Notice that we have 457 blocks marked corrupt but v$database_block_corruption view is empty. SQL: select count#*$ from v$database_block_corruption; Let’s query v$nonlogged_block view. set lines 200 set pages 999 select file#, block#, blocks,object#,reason from v$nonlogged_block; Will RMAN detect that we have corrupted blocks? RMAN: backup datafile 5; RMAN backup won’t fail due to NOLOGGING corrupt blocks and our backup will contain soft corrupted blocks. Let’s Identify corrupt segments using v$nonlogged_block view. set lines 2000 set pages 9999 col owner for a20 col partition_name for a10 col segment_name for a20 SELECT e.owner, e.segment_type, e.segment_name, e.partition_name, c.file# , greatest#e.block_id, c.block#$ corr_start_block# , least#e.block_id+e.blocks-1, c.block#+c.blocks-1$ corr_end_block# , least#e.block_id+e.blocks-1, c.block#+c.blocks-1$ - greatest#e.block_id, c.block#$ + 1 blocks_corrupted FROM dba_extents e, V$NONLOGGED_BLOCK c WHERE e.file_id = c.file# AND e.block_id "= c.block# + c.blocks - 1 AND e.block_id + e.blocks - 1 := c.block# UNION SELECT s.owner, s.segment_type, s.segment_name, s.partition_name, c.file# , header_block corr_start_block# , header_block corr_end_block# , 1 blocks_corrupted FROM dba_segments s, V$NONLOGGED_BLOCK c WHERE s.header_file = c.file# AND s.header_block between c.block# and c.block# + c.blocks - 1 UNION SELECT null owner, null segment_type, null segment_name, null partition_name, c.file# , greatest#f.block_id, c.block#$ corr_start_block# , least#f.block_id+f.blocks-1, c.block#+c.blocks-1$ corr_end_block# , least#f.block_id+f.blocks-1, c.block#+c.blocks-1$ - greatest#f.block_id, c.block#$ + 1 blocks_corrupted FROM dba_free_space f, V$NONLOGGED_BLOCK c WHERE f.file_id = c.file# AND f.block_id "= c.block# + c.blocks - 1 AND f.block_id + f.blocks - 1 := c.block# order by file#, corr_start_block# / This is the best outcome to get if you notice corruption errors. All errors are related to index corruption so we could fix this problem rebuilding index. alter index idx_obj_name rebuild; Simply issuing "alter index rebuild" command won't work. We should mark index unusable to drop segment before rebuilding it or just rebuild index with online option. It is better choice to mark index unusable because you don't need additional space then, but I will simply rebuild index with online option and see what will happen. SQL: alter index idx_obj_name rebuild online; Index altered. SQL: select count#*$ from objects where object_name like 'A%'; No errors... but, let's validate datafile for corruption. RMAN: backup validate check logical datafile 5; Notice "Marked Corrupt" column. Hm... 457 like before. Don't worry, this is not new corruption. These are FREE blocks which will be reused and Oracle will automatically re-format those blocks. Query the v$nonlogged_block view again as given above. We could force re-formatting creating dummy table and inserting data to dummy table. Check Doc ID 336133.1. create table s # n number, c varchar2#4000$ $ nologging tablespace DEMO1; SQL: BEGIN FOR i IN 1..1000000 LOOP INSERT /*+ APPEND */ INTO sys.s select i, lpad#'REFORMAT',3092, 'R'$ from dual; commit ; END LOOP; END; / SQL: drop table sys.s purge; Notice that we don't have corrupted blocks any more. RMAN: backup validate check logical datafile 5;
Views: 222 OracleDBA
EVE Online - Null isn't impossible (Coercer ratting)
 
05:38
Music used is "Crystallize," by Lindsey Stirling. FAQs; Q: What happened when your armor shot down to 60%? A: The Sansha's Slave Lord which was firing at me just so happened to shoot while my radial velocity in comparison to him was low. This resulted in a near-perfect hit which caused me to take a lot of damage. If you want to prevent this, then manually maneuver your ship as opposed to simply orbiting your target, though it shouldn't be necessary (I tanked it just fine). Q: What's your fit? (It didn't stay on screen for very long) A: 8x dual light pulse lasers 1x 1MN afterburner 2x Heat Sink 1x Small armor repairer 1x Capacitor power relay 3x Small capacitor control circuit In all honesty, you could probably make do with less capacitor stuff; either change the capacitor power relay into a third heat sink or tracking enhancer, or change 1-2 of the rigs into damage/tracking rigs. However, if your skills are low, having a good cap buffer is a plus. Q: Where are you, and would this work in other regions? A: I'm in space with Sansha rats, so EM/thermal damage is good, which happens to be what the Coercer is good at. It would probably also work in Blood Raiders space, where the rats are weak to the same damage type. I probably wouldn't recommend this for other NPCs, which are resistant to that damage type; however, the other destroyers are all viable for this as well. For Serpentis/Guristas space, use hybrids (the Catalyst or Cormorant) or a Thrasher using Phased Plasma ammunition. For Angel space, the best destroyer is really only the Thrasher using Fusion ammo, given that it's the only one to reliably deal explosive damage. Q: How much skill training would this require? A: Bare bones, you could fly destroyers in 4 days or so. If you're also including getting the relevant skills to 4 (Destroyers IV, gunnery skills to IV, cap skills to IV) it would probably be about 2.5 weeks? Q: What other PvE activities can this be used for? A: It will probably also work for low to mid level missions (L1s and L2s, *maybe* L3s?). I would not recommend it for cosmic anomalies or deadspace complexes - at least not solo - because of a large number of cruisers and frigates which will ruin your day. Q: What's the DPS of your fit? A: 250 with t1 multifrequency. If you drop the capacitor power relay for a third heat sink, that goes up to 290 (as much as a Drake shooting EM missiles), and if you use imperial navy multifrequency that hits around ~320. With decent skills, you should be able to break the tank of any Sansha rat, and can probably kill most of them even with low support skills. Q: How are you tanking battleships in a destroyer? A: By using the afterburner to keep your speed up, you can greatly reduce the damage that enemy battleships and cruisers will deal to you - this is due to the way weapons in EVE work. Essentially, if a turret is firing at you, you will take more damage if you are going slowly than if you are going fast. This alone won't save you, though; you also need to travel at an angle in relation to the opponent, as opposed to straight on. This essentially means that you're barely going to get hit, so what little damage you do take can be comfortably soaked up by the repper. As you saw, my actual tank really isn't very good - at the 3:20 mark, I accidentally took a direct hit, and my armor was brought down to 60% with a single shot. This is why you keep moving, and always watch the angles so that you try not to let yourself fly in a straight line compared to something else. Edit - Added tips, courtesy of ZaiRoX on Reddit: Find an empty null. Systems without npc stations are usually less populated. Use a "travel" fit between highsec and null. It should have some buffertank and a couple WCS. Just pick your refit station carefully!. Make a insta-undock bm if you can. While travelling. Check your map for ship destroyed/podkills along your route. Every gatecamp will kill you... Bring a secure container. You get more cargospace and get the benefit of keeping the loot locked at a safespot (requires anchoring lvl 1). This is important to minimize your losses. Also the fit is very dependent on speedtanking. You'll die instantly if you crash into an asteroid. Manual flying is a must.
Views: 11249 Roosterton
ORACLE  SQL Coding Lesson 3 in Jinghpaw Language - More Character and Numeric Functions
 
44:14
SQL Coding Lesson 3 in Jinghpaw Language - Lessons Continued. Please watch in HD mode for better video quality. --numeric functions SELECT ABS(12) FROM DUAL; SELECT ABS(-12.65) FROM DUAL; SELECT CEIL(48.99) FROM DUAL; SELECT CEIL(48.11) FROM DUAL; SELECT FLOOR(49.99) FROM DUAL; SELECT FLOOR(49.11) FROM DUAL; SELECT ROUND(49.11321,2) FROM DUAL; SELECT ROUND(49.11321,3) FROM DUAL; SELECT POWER(4,2) FROM DUAL; SELECT POWER(3,4) FROM DUAL; SELECT MOD(4,2) FROM DUAL; SELECT MOD(5051,100) FROM DUAL; select greatest(34,567,290,86) from dual; select least(34,567,290,86) from dual; select INSTR('Tech on the net', 'e') from dual; select INSTR('Tech on the net', 'e', 1, 1) from dual; select TRIM(' tech ') from dual; select TRIM(' ' FROM ' tech ') from dual; select TRIM(LEADING '0' FROM '000123') from dual; select TRIM(BOTH '1' FROM '123Tech111') from dual; select GREATEST(2, 5, 12, 3) from dual; select GREATEST('2', '5', '12', '3') from dual; select GREATEST('apples', 'oranges', 'bananas') from dual; select LEAST('2', '5', '12', '3') from dual; --null select (9000*null) from dual; select (null/9000) from dual; select (9000-null) from dual; select (9000+null) from dual; select distinct department_id from employees where commission_pct is not null; select last_name,job_id,coalesce(department_id,0) as dept,salary,commission_pct,coalesce(commission_pct,0) as comm_not_null, salary*commission_pct as multiplied_by_null, salary*coalesce(commission_pct,0) as commission_amt, salary+ (salary*coalesce(commission_pct,0)) as salary_plus_comm from employees where commission_pct is not null or department_id=20 order by dept; desc locations; select coalesce(postal_code,city,STATE_PROVINCE,COUNTRY_ID) as new_address,postal_code,city,STATE_PROVINCE,COUNTRY_ID from locations where COUNTRY_ID in ('JP','IT','UK'); --add more departments SELECT first_name ||'.'||last_name as "Employee Name",department_id, CASE when department_id in (10) THEN 'Accounting' WHEN department_id in (20) THEN 'Research' -- WHEN commission_pct is not null THEN 'Sales' WHEN department_id in (30) THEN 'Operations' ELSE 'Unknown' END department FROM employees ORDER BY first_name ||'.'||last_name ; SELECT last_name, department_id, DECODE( department_id ,10 ,'Accounting' ,20 ,'Research' ,30 ,'Sales' ,40 ,'Operations' ,'Unknown') department FROM employees ORDER BY last_name; select country_id,decode(country_id,'BR','Southern Hemisphere', 'AU','Southern Hemisphere', 'Northen Hemisphere') hemisphere from locations order by hemisphere; --set define on; select 'Coke & Popcorn' from dual; --upper,lower,coalesce and null select upper('sql') from dual; select lower('SQL') from dual; select initcap('sql') from dual; Select * from employees where email like '%SON'; Select * from employees where lower(email) like '%son'; Select * from employees where upper(last_name) like '%SON'; Select * from employees where lower(job_id) ='pu_clerk'; Select * from employees where initcap(email) ='Sbaida'; select * from employees where substr(phone_number,1,3) eq '515'; select * from employees where substr(phone_number,1,3) ne '515'; select * from employees where last_name gt 'King'; select * from employees where hire_date lt '01-JAN-1992'; --special character select * from jobs where job_id like 'SA\_%' escape '\'; select * from jobs where job_id like 'SA$_%' escape '$'; --translate, replace --( string1, string_to_replace, replacement_string ) select TRANSLATE('1tech23', '123', '456') from dual; select phone_number,translate(phone_number,'.','-') as modified_phnum from employees where rownum le 10; select job_id,translate(job_id,'_','&') as modified_phnum from employees where rownum le 10; select phone_number,translate(phone_number,'515','415') as modified_phnum from employees where rownum le 5; select phone_number,REPLACE(phone_number,'515','415') as modified_phnum from employees where rownum le 5; select REPLACE('123123tech', '123') from dual; select REPLACE('123tech123', '123') from dual; select REPLACE('222tech', '2', '3') from dual;
Views: 45 Hkau Doi
MySQL 33 - Datetime, Date, Time Data Types
 
06:40
Next up on our MySQL to-do list is to learn about storing dates and times. There are various data types in MySQL for storing dates and times. It seems MySQL and databases likes to break everything up into multiple data types to make things more organized at the consequence of being confusing and annoying. This video is going to be talking about the DATETIME, DATE, and TIME data types. These are all used to store, you guessed it, dates and times. The one you choose depends on your needs. If you just need dates, choose DATE. If you just need times, choose TIME, if you need both stored together, choose DATETIME. Now you set a column one of these data types whenever you want every row for this field to have some sort of date, time or both…but how exactly is the data formatted? This requires us to understand some convention. For example, in the USA at least, if you have something like 4:30AM, by convention you know the hour is 4 and the minutes are 30. But this is just an agreed upon convention. MySQL has its own convention…For example 2017-02-02. The first thing is the year, the second is the month, and the third is the day. That is for the DATE. The convention for time is 22:54:30. The first is the hour (military time), the second is the minute, and the third is the seconds. Lastly, there can actually be fractions of seconds…up to microseconds! .123456. To use fractional seconds though you must specify to MySQL the precision of the TIME or DATETIME when you create it, for example DATETIME(6) would allow microsecond precision. How do you actually give a date to MySQL? By that I mean let's say you have a table with a column of DATETIME(6), and you want to give a value for that column, how do you format it? It's quoted. For example: '2017-02-02 22:54:30.333333' MySQL interprets this as a DATETIME. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support me! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 40567 Caleb Curry
Null Life - Giveaways - EVE Online Live
 
03:21:55
Want an entry on the Live Show Giveaway while the show is live? Get your entry here. https://store.markeedragon.com/index.php?cat=18 We will draw near the end of the live show and the winner will be notified by email. If you are viewing the giveaways while the show is offline only monthly giveaways will appear. http://store.markeedragon.com/affiliate.php?id=4&redirect=index.php?cat=4 Special Viewer Discount or Bonus. YOUR CHOICE! Want a bonus on your EVE new account or Plex? Use the discount code of "discount" and get 3% off your order. Or want 3.3% cash back for even more savings? Use bonus code "bonus" and get 3.3% credit in your account for future purchases This is for a limited time and the discount/bonus codes may be changed or removed at any time. The discount / bonus is provided by Markee Dragon Game Codes and we are an authorized CCP reseller. Codes delivered in 20 minutes or less. Twitter: http://twitter.com/markeedragon Want to Try EVE for free? Get it here: http://secure.eveonline.com/signup/?invc=d6baec26-231d-4ced-9cd2-1a8b3713d72d&action=buddy [!nojob] Want to get rid of your day job and be your own boss? Markee Dragon is sharing how he does it with a step by step guide to independence. Get it here: http://jedimarketingtricks.com/ultimate/ Join me and your favorite streamers! Put my 10+ years of experience to work for YOU. Learn how to start generating income while playing your favorite games! I include everything you need to know to get started PLUS plenty of support for when you get stuck! Join us for chat in Discord https://discord.gg/markeedragon Discord is what we use for in game chat and voice comms. This is a simulcast of http://twitch.tv/markeedragon . You can watch here live on YouTube and talk in chat. but for the giveaways mentioned on the show those currently only work in Twitch chat. You do not have to watch on Twitch. You only need to be in the Twitch chat to get in on the giveaways. WTFast is what I use to improve my connection to EVE. I get at least a 20% improvement at all times. Try it here: http://www.wtfast.com/markeedragon Videos How to convert Loyalty Points This video shows how we decided what items to use. Items Sold. https://www.youtube.com/watch?v=rnv4eW9hwP0 What worked Successful conversion of 1m LP to 1.5b ISK in 13 days. https://www.youtube.com/watch?v=eiGEj4XhKt0 Hauling Introduction https://www.youtube.com/watch?v=7NjY9aU-uBQ Hauling is a great secondary income. Market Blue Line Hauling is a great secondary income. EVE Sites Mentioned on the Show EVE Guides and Ship Fits: http://news.markeedragon.com/category/game-guides-how-to/eve-online-guides/ Moose Army Corp - My Null Corp I am a member of. http://moose.army Airhogs - The best all around corp and great for new players. I am also a member http://docs.google.com/document/d/1cCPjgTfOxMN7JpagSs5iUCyES2OalT5j6O4zaP5qVNw/edit?usp=sharing LP Store Conversion See what LP items are currently worth on the market. https://www.fuzzwork.co.uk/lpstore/ Daopa's LP Stores Database LP store items information http://www.ellatha.com/eve/LP-Stores EVE Assets Manager Find your stuff. Know where your money is sitting! http://eve.nikr.net/jeveasset EVE Markets Market history data. http://eve-markets.net/ EVEPraisal Quick values for your loot and other market actions. http://evepraisal.com/ EVE Maps All kinds of map related information. http://evemaps.dotlan.net/ Deepsafe https://deepsafe.xyz Excellent crowed sourced information on cosmic signatures. All explorers should use this. EVE University EVE Wiki http://wiki.eveuniversity.org/Main_Page Live shows Schedule: https://docs.google.com/spreadsheets/d/1zQZoKQnzGRgWXBefzGKlyfDppGQWzJy6PafWm-4c4sQ/pubhtml Music by Monstercat http://www.monstercat.com
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: 131310 kudvenkat
About that error: ORA-06502: numeric or value error
 
12:11
"ORA-06502: numeric or value error" is one of the most commonly occurring and irritating errors for PL/SQL developers. Value too big for its "container"? Trying to stuff a non-numeric string value into a number through implicit conversion? [naughty naughty] In this video, Steven takes a close look at ORA-06502, exploring the ways it can be raised and how best to deal with those scenarios. ============================ Practically Perfect PL/SQL with Steven Feuerstein 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.
Episode 1 - Mongo DB Is Web Scale
 
05:36
Q&A discussion discussing the merits of No SQL and relational databases.
Views: 521556 gar1t
Aggregate Functions in SQL
 
05:42
Join Discussion: http://www.techtud.com/video-lecture/aggregate-functions-sql IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 17260 Techtud
Foreign Key | Database Management System
 
06:29
To ask your doubts on this topic and much more, click on this Direct Link: http://www.techtud.com/video-lecture/lecture-foreign-key IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 281301 Techtud
SQL функции и операторы сравнения значений в базах данных MySQL
 
15:41
Рубрика по базам данных: http://zametkinapolyah.ru/zametki-o-mysql/sqlite/ Рубрика MySQL: http://zametkinapolyah.ru/zametki-o-mysql/server-mysql Паблик блога в ВК: https://vk.com/zametkinapolyah Тематическая группа в ВК: https://vk.com/zametki_bd Помощь проекту: WMR: R288272666982 WMZ: Z293550531456 Яндекс.Деньги: 410011531129223 MySQL поддерживает довольно-таки большой набор операторов и функция сравнения значений: BETWEEN ... AND ..., COALESCE(), =, GREATEST(), IN(), INTERVAL(), IS, IS NOT, IS NOT NULL, IS NULL, ISNULL(), LEAST(), LIKE, NOT BETWEEN ... AND ..., !=, NOT IN(), NOT LIKE, STRCMP(). Часть из них возвращает логические значения, как результат своей работы, а некоторые функции и операторы возвращают значения, исходя из того, что они получили. -- Проверка на равенство значений SELECT 1 = 0; SELECT NULL = 0; SELECT 1 = NULL; SELECT NULL = NULL; SELECT '0' = 0; SELECT '0.0' = 0; SELECT '0.01' = 0; SELECT '.01' = 0.01; -- Оператор проверки логического значения IS SELECT 10 IS TRUE; SELECT -10 IS TRUE; SELECT 'string' IS NOT NULL; SELECT '' IS TRUE; SELECT '' IS FALSE; SELECT ' ' IS TRUE; SELECT 0 IS TRUE; SELECT NULL IS TRUE; SELECT NULL IS FALSE; -- Операторы IS NULL и IS NOT NULL или проверка на NULL SELECT 1 IS NULL, 0 IS NULL, NULL IS NULL; SELECT 1 IS NOT NULL, 0 IS NOT NULL, NULL IS NOT NULL; -- Оператор между (не знаю как он правильно называются): ... BETWEEN ... AND ... SELECT 2 BETWEEN 1 AND 3, 2 BETWEEN 3 and 1; SELECT 1 BETWEEN 2 AND 3; SELECT 2.5 BETWEEN 2 AND 3; SELECT 4 BETWEEN 2 AND 3; SELECT 'b' BETWEEN 'a' AND 'c'; SELECT 'b' NOT BETWEEN 'a' AND 'c'; SELECT 1 NOT BETWEEN 2 AND 3; SELECT 4 NOT BETWEEN 2 AND 3; SELECT 2.5 NOT BETWEEN 2 AND 3; -- Следующая функция MySQL сравнивает значения и возвращает первое попавшееся, которое не равно NULL SELECT COALESCE(NULL,1, 55, 'hello'); SELECT COALESCE(NULL,NULL,NULL); -- Следующая функция MySQL сравнивает значения и возвращает наибольшее SELECT GREATEST(2,0); SELECT GREATEST(34.0,3.0,5.0,767.0); SELECT GREATEST('B','A','C'); SELECT GREATEST('B','A','C', NULL); -- Оператор IN. Данный оператор в SQL и базах данных MySQL имеет два операнда. Первый операнд сравниваемое значение, второй - набор значений, с которым сравнивается первый операнд. SELECT 2 IN (0,3,5,7); SELECT 'wefwf' IN ('wee','wefwf','weg'); SELECT (3,4) IN ((1,2), (3,4)); SELECT (3,4) IN ((1,2), (3,5)); SELECT 2 NOT IN (0,3,5,7); SELECT 'wefwf' NOT IN ('wee','wefwf','weg'); -- В базах данных MySQL есть функция ISNULL(), в качестве аргумента она принимает выражение и проверяет его результат на NULL SELECT ISNULL(1+1); SELECT ISNULL(1/0); -- Быстрая проверка/сортировка чисел. 0 1 SELECT INTERVAL(23, 1, 15, 17, 30, 44, 200); SELECT INTERVAL(31, 30, 35, 17, 30, 44, 200); SELECT INTERVAL(4, 6, 7, 8, 9, 10, 11); -- Поиск наименьшего значения в базе данных MySQL -- Если один из аргументов NULL, то результат всегда будет NULL -- Если все аргументы INTEGER или могут быть приведены к INTEGER, то они сравниваются как целые цисла. -- Если аргументы REAL или могут быть приведены к REAL, то они сравниваются как вещественные числа. -- Если аргументы смешанные (строки и числа), то MySQL сравнивает их как числа. -- Если аргументы - небинарные строки, то они сравниваются как небинарные строки. -- Все остальные случаи MySQL сравнивает значения в бинарном виде, то есть как последовательность нулей и единиц. SELECT LEAST(2,0); SELECT LEAST(34.0,3.0,5.0,767.0); SELECT LEAST('B','A','C');
Understanding Set Comparison Operator in SQL
 
11:15
Join Discussion on: http://www.techtud.com/video-lecture/understanding-set-comparison-operators IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 13402 Techtud
SQL Tutorial For Beginners : What is SYS_CONTEXT in Oracle with Example
 
04:24
What is SYS_CONTEXT in Oracle with Example What is SYS_CONTEXT Function? Syntax: SYS_CONTEXT( namespace, parameter [, length] ) SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 445 TechLake
Using SQL for Pattern Matching in Oracle Database - OLL Live recorded event
 
35:44
Learn how to use SQL for Pattern Matching. Row pattern matching in native SQL improve application and development productivity and query efficiency for row-sequence analysis. Recognizing patterns in a sequence of rows has been a capability that was widely desired, but not possible with SQL until now. With Oracle Database 12c Release 1 (12.1), you can use the MATCH_RECOGNIZE clause to perform pattern matching in SQL. See the related tutorial at http://apex.oracle.com/pls/apex/f?p=44785:24:0::::P24_CONTENT_ID,P24_PREV_PAGE:6781,1. Copyright © 2013 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. 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 of merchantability, fitness for a particular purpose, and non-infringement.
Oracle Database11g tutorials 14 : How to CREATE TABLE using sql developer and command prompt
 
08:36
Oracle Database11g tutorials 14 How to Create table using command prompt and Create table using sql developer Blog Link http://bit.ly/1TkY4Oe Time Line 0:25 Introduction of Tables in Database 1:03 What is Create Table (Introduction of create table) 1:30 Syntax of Create Table 2:08 How to create table using Command Prompt 4:55 How to create table using SQL Developer Links for Oracle Database tutorials 4: database connectivity using SQL developer and command prompt http://youtu.be/wSqoXRlXDUU You can have indepth knowledge about SQL create table here http://www.rebellionrider.com/sql-create-table.html Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com Today in this oracle database tutorial we will see How to CREATE A TABLE. if we have to define a table in layman language then we can say that Tables are just a collection of Rows and Columns but In RDBMS tables are database objects which help in organizing data into ROWS and COLUMNS. We can also say that SQL tables are kind of data structure which are used by database for efficient storage of data. To create a table in our database we use SQL CREATE TABLE command. SQL CREATE TABLE is a type of DATA DEFINITION LANGUAGE also known as DDL. To Create a table in your schema you will require CREATE TABLE system privilege. In our future videos we will see what are system and object privileges and how to grant them to a user. Today for this video we will be using Sample schema HR which already has all the necessary privileges. Ohk Let's see the syntax. CREATE TABLE table name ( column name1 Data-Type(size), column name2 Data-Type(size), ..... ); CREATE TABLE is an oracle reserved word or say an Oracle key word whereas There are 3 different ways of creating a table in Oracle database. Creating a table using Command Line Interface (CLI) in Oracle database For demonstrating how to create table in oracle database using CLI, I'll be using Command prompt. Thats how we create table using command prompt. you can check your table structure by DESCRIBE command for that just write DESC and your table name. Like this Another way of creating a table is by using Graphic user interface (GUI) in Oracle database To demonstrate how to create table using GUI we will use SQL developer. Lets open our SQL developer I am connected to HR schema if you do not know how to create a connection to database using SQL developer please watch my oracle database tutorial 4 that explains database connectivity using SQL developer and command prompt. Link for this video is in the description below. So lets create a table. Creating a table using SQL developer is very easy we do not have to fire any query here. Let's start First of all right click on your connection in which you want to create a table and choose schema browser. This will open a separate schema browser pane or you can expend your connection by clicking this + sign and then right click on table and choose New Table. However I prefer working with schema browser so let's skip to schema browser pane here from the first drop-down list you can choose connection name and in the second drop down list you can choose what database objects you want to work with we want to create a table thus I'll choose table and then click this arrow here and choose option for new table Ok we have created a table wizard first of all give a unique name to your table and add some column as well. For this, click the green plus button. Now we already have a column so give it some name. Also choose a datatype from the list and specify any size you can check this not null column if in case you want to make this a mandatory column you can also specify default value and constraint If you want to make this column a primary key you can click here In my future video i'll show you what are these constraints and different ways of applying them on a column in a table. for this video we will concentrate on create table only so when you are done with all your columns click ok Thats your table You can double click on your table here and can see its structure. Thats it
Views: 189183 Manish Sharma
VIEW  in SQL
 
14:59
Join Discussion: http://www.techtud.com/video-lecture/understanding-views-sql IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 38060 Techtud
Subqueries: Databases for Developers #11
 
07:45
In SQL you can base queries on the results of other queries. This video explains the various types of subquery and their uses, covering: - Inline views - IN & EXISTS - Common table expressions/subquery factoring/with clause - Scalar subqueries Take the course; Databases for Developers: Next Level https://blogs.oracle.com/academy/take-your-sql-skills-to-the-next-level-with-this-free-online-10-part-tutorial Further reading: About Queries and Subqueries: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/About-Queries-and-Subqueries.html Using Subqueries: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/Using-Subqueries.html Need help with SQL? Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ ============================ The Magic of SQL with Chris Saxon 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.
Views: 1985 The Magic of SQL
Intersect operator in sql server
 
05:29
sql intersect vs join sql server intersect example sql server intersect vs inner join sql server inner join remove duplicates In this video we will discuss 1. Intersect operator in sql server 2. Difference between intersect and inner join Intersect operator retrieves the common records from both the left and the right query of the Intersect operator. Introduced in SQL Server 2005 The number and the order of the columns must be same in both the queries The data types must be same or at least compatible Let us understand INTERSECT operator with an example. The following query retrieves the common records from both the left and the right query of the Intersect operator. Select Id, Name, Gender from TableA Intersect Select Id, Name, Gender from TableB We can also achieve the same thinkg using INNER join. The following INNER join query would produce the exact same result. Select TableA.Id, TableA.Name, TableA.Gender From TableA Inner Join TableB On TableA.Id = TableB.Id What is the difference between INTERSECT and INNER JOIN 1. INTERSECT filters duplicates and returns only DISTINCT rows that are common between the LEFT and Right Query, where as INNER JOIN does not filter the duplicates. To understand this difference, insert the following row into TableA Insert into TableA values (2, 'Mary', 'Female') Now execute the following INTERSECT query. Notice that we get only the DISTINCT rows Select Id, Name, Gender from TableA Intersect Select Id, Name, Gender from TableB Now execute the following INNER JOIN query. Notice that the duplicate rows are not filtered. Select TableA.Id, TableA.Name, TableA.Gender From TableA Inner Join TableB On TableA.Id = TableB.Id You can make the INNER JOIN behave like INTERSECT operator by using the DISTINCT operator Select DISTINCT TableA.Id, TableA.Name, TableA.Gender From TableA Inner Join TableB On TableA.Id = TableB.Id 2. INNER JOIN treats two NULLS as two different values. So if you are joining two tables based on a nullable column and if both tables have NULLs in that joining column then, INNER JOIN will not include those rows in the result-set, where as INTERSECT treats two NULLs as a same value and it returns all matching rows. To understand this difference, execute the following 2 insert statements Insert into TableA values(NULL, 'Pam', 'Female') Insert into TableB values(NULL, 'Pam', 'Female') INTERSECT query Select Id, Name, Gender from TableA Intersect Select Id, Name, Gender from TableB INNER JOIN query Select TableA.Id, TableA.Name, TableA.Gender From TableA Inner Join TableB On TableA.Id = TableB.Id Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/intersect-operator-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/intersect-operator-in-sql-server_6.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: 41163 kudvenkat
ACID Property in Database Management System
 
12:40
Join Discussion: http://www.techtud.com/video-lecture/acid-property-dbms IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 61551 Techtud
How to do database normalization
 
21:42
In this video, we learn to normalize RDBMS tables up to 3NF. 1:23 - Need for Normalization 8:20 - 1NF (First Normal Form) 12:47 - 2NF (Second Normal Form) 19:07 - 3NF (Third Normal Form) C programming series (pointers, functions and DMA): https://www.youtube.com/watch?v=gozzO96tRpQ&list=PLRnuLZZ5D0KySx7rBi6iWnPaf-McGBcoC C++ programming concepts series: https://www.youtube.com/watch?v=R4iviB8g12A&list=PLRnuLZZ5D0KzAQIanRKPetLl73DoHVn6I
Views: 138997 BBarters
#Kscope15 Interview: Steven Feuerstein, Oracle Corporation
 
10:54
Oracle Developer Outreach Advocate Todd Trichler interviewed #Kscope15 presenter Steven Feuerstein of Oracle Corporation. For more information on Kscope15 visit http://kscope15.com. To learn about ODTUG go to http://odtug.com and to be a part of the best Oracle developer conference in 2016 go to Kscope16 http://kscope16.com. Bio: Steven Feuerstein, Oracle Corporation Steven Feuerstein is an expert on the Oracle PL/SQL language, having written 10 books on PL/SQL, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices (all published by O'Reilly Media). Steven is an Architect for Oracle Corporation, leading a team of evangelists with a mission of helping users leverage Oracle Database as a powerful application development platform. Steven has been developing software since 1980, originally spent five years with Oracle (1987-1992), and was PL/SQL Evangelist for Quest Software (and then Dell) from January 2001 to February 2014, at which point he returned joyfully to Oracle Corporation. He was one of the original Oracle ACE Directors and writes regularly for Oracle Magazine, which named him the PL/SQL Developer of the Year in both 2002 and 2006. He is also the first recipient of ODTUG's Lifetime Achievement Award (2009). Read Steven's commentary on PL/SQL and other Oracle technologies at stevenfeuersteinonplsql.blogspot.com. Session: Cool Package Features You May Not Know About Topic: Database Development Packages are the building blocks of any well-designed PL/SQL-based application. That means that most PL/SQL developers are at least familiar with the basics of packages. This session will first make sure you aware of key package features, such as the initialization section, oveloading, and package level data, and then explores lesser-known features of packages including serialization of package data and whitelisting access to packages (new to 12.1 PL/SQL). Back to Top PL/SQL Developers, the Most Important Developers on Earth: Part 1 & 2 Topic: Database Development It's a mobile, app-y, Internutty kind of world - does PL/SQL still have a role to play? You bet it does! And the way we write our PL/SQL is more important than ever before. This special two-part presentation will focus on using PL/SQL to build hiqh-quality and highly efficient APIs to data and the business rules that form the foundation of your applications. And because those APIs are going to be around for a while, you'll get top tips for writing highly maintainable code, too.
Views: 239 ODTUG
ORDER BY clause in SQL | Database Management System
 
06:56
Join discussion on: http://www.techtud.com/video-lecture/order-clause-sql IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 5374 Techtud
Datatypes in SQL | Database management System
 
10:03
Join discussion on: http://www.techtud.com/video-lecture/introduction-sql IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 16278 Techtud
Talking about A-Log (Anthony LoGatto)
 
01:00:58
Bookmark:https://madattheinternet.com/ Kiwi Farms Channel: https://www.youtube.com/channel/UCSb5Oa-441qvbyLknCcuLKg Streaming channel: https://www.youtube.com/channel/UCgpVO5oxAh7oMk3vynU-2Vg
Views: 1737 Kiwi Farms Archive
The Gary Null Show - 09.25.18
 
50:58
Source: https://www.podbean.com/media/share/pb-wknci-9abbfd Wikipedia : the Modern Delphic Oracle By Helen Buyniski Can we trust Wikipedia as an unbiased source of truth? Can we at least offer it the same trust we place in our news media? The country is experiencing a crisis of confidence. Establishment credibility is collapsing all around us. We know that the New York Times boasts more Pulitzer-winning journalists writing in its pages than any other paper, as well as robust editorial review boards. Yet even this paper, written by experts, has become a source of politically-motivated misinformation, and trust in the news media is at an all-time low. Trust in government has similarly cratered. We fumble blindly for a trustworthy source, and where expertise has failed us, we reach now for the Vox Populi. Surely, everyone else can’t be wrong. A 2014 YouGov poll showed that UK residents trust Wikipedia more than the news media.1 While no such poll was conducted in the US, we can safely extrapolate the popular climate of media mistrust across the Atlantic. According to Reuters, 61% of Americans think news media is doing a good job covering the most important news events, but only 56% think they report the news accurately and 58% think they cover the government well. Only 47% think they report on all sides fairly, and among supporters of the government, only 21% think the news media is fair2. A Gallup poll paints an even bleaker picture: only 32% say that they have a great deal or fair amount of trust in the media, and only 14% of Republicans say so.3 Meanwhile, only 33% of Americans trust their government “to do what is right,” according to Edelman, which rates media slightly higher at 42%.4 Expertise is no longer valued because the experts have failed us. The “smartest guys in the room” gave us Enron; “expert” journalists brought us lurid tales of Weapons of Mass Destruction in Iraq; financial savants gave us the crash of 2008; and savvy pollsters and Democrat careerists brought us an election contest between the two most unpopular candidates in history. Officially, there is no barrier to entry to editing Wikipedia, and this paradoxically contributes to its perceived trustworthiness. If one is willing to suspend disbelief and cling to a fleeting idea of the essential goodness of humanity – if one has never before visited an online forum and seen the race to the bottom accelerated by trolls, sociopaths, and other misanthropes – perhaps one can believe that an encyclopedia that “anyone can edit” will trend toward the truth in a sort of benevolent consensus reality. But would we read a peer-reviewed medical journal written by people with no background in science or medicine? Wikipedia is just such a journal. There is no guarantee an editor writing about a living person or a concept under development has any knowledge of the subject. Worse, there is no guarantee they are not concealing some bias or looking to grind their personal axe through editorial control of an article or an entire section of the encyclopedia. In what world would we allow the inmates to run the asylum? The reality is that Wikipedia is not a grassroots collaborative crafted through the shared effort of People Like Us. Its rules are applied selectively and secretively. It is common to find articles on living persons written up as smear jobs, replete in some cases with outright libel but more often disguised as “neutral” assessments in which undue weight is given to negative evaluations and mischaracterizations of a person’s work while their defining achievements are minimalized or left out. Victims of these hit pieces have no opportunity to address the attacks on their reputation by anonymous editors whose qualifications are frequently nonexistent. Despite Wikipedia’s stated protections against character assassination – drawn up in the aftermath of a scandal which saw a journalist smeared as an accessory to the Kennedy assassination – the rules are selectively enforced and there is a clear bias toward individuals whose work supports the status quo, whatever their field. Wikipedia’s founder Jimmy Wales has not been shy about espousing his political philosophy. He is a devotee of Ayn Rand, whose belief in “the virtue of selfishness” survives in the neoliberalism that forms the economic core of both US political parties. While Rand is more openly championed by the political Right today, Wales’ British wife worked in Tony Blair’s Labour cabinet and he moves in centrist Democrat circles in the US. He is also an avowed Skeptic, meaning he eschews all but the most established scientific orthodoxy as “lunatic charlatanism.” Wales thinks homeopathy should be illegal5 and has expressed hostility toward users of his site who support alternative and holistic medicine.6 All his biases are on display on Wikipedia – they are the edits left in when others are reverted. Yet even as it sports the hallmarks of a d
CREATE table and Integrity Constraint (Example in SQL) | DBMS
 
04:16
Join discussion: http://www.techtud.com/video-illustration/illustration-create-table IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 10399 Techtud
joins in sql server in hindi
 
18:04
An SQL JOIN clause is used to combine rows from two or more tables, based on a common field between them. The most common type of join is: SQL INNER JOIN (simple join). An SQL INNER JOIN returns all rows from multiple tables where the join condition is met. Different SQL JOINs Before we continue with examples, we will list the types of the different SQL JOINs you can use: INNER JOIN: Returns all rows when there is at least one match in BOTH tables LEFT JOIN: Return all rows from the left table, and the matched rows from the right table RIGHT JOIN: Return all rows from the right table, and the matched rows from the left table FULL JOIN: Return all rows when there is a match in ONE of the tables The SQL Joins clause is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two tables by using values common to each. SQL Join Types: There are different types of joins available in SQL: INNER JOIN: returns rows when there is a match in both tables. LEFT JOIN: returns all rows from the left table, even if there are no matches in the right table. RIGHT JOIN: returns all rows from the right table, even if there are no matches in the left table. FULL JOIN: returns rows when there is a match in one of the tables. SELF JOIN: is used to join a table to itself as if the table were two tables, temporarily renaming at least one table in the SQL statement. CARTESIAN JOIN: returns the Cartesian product of the sets of records from the two or more joined tables. What is a left outer join This means that if the ON clause matches 0 (zero) records in B (for a given record in A), the join will still return a row in the result (for that record)—but with NULL in each column from B. A left outer join returns all the values from an inner join plus all values in the left table that do not match to the right ... What is an outer join An outer join returns a set of records (or rows) that include what an inner join would return but also includes other rows for which no corresponding match is found in the other table. There are three types of outer joins: Left Outer Join (or Left Join) Right Outer Join (or Right Join) Full Outer Join (or Full Join) What is a natural join A NATURAL JOIN is a JOIN operation that creates an implicit join clause for you based on the common columns in the two tables being joined. Common columns are columns that have the same name in both tables. A NATURAL JOIN can be an INNER join, a LEFT OUTER join, or a RIGHT OUTER join. What is an inner join Inner join. A join is combining the rows from two tables. An inner join attempts to match up the two tables based on the criteria you specify in the query, and only returns the rows that match. If a row from the first table in the join matches two rows in the second table, then two rows will be returned in the results.
Views: 1487 Learn Everything
DISTINCT in SQL | Database Management System
 
05:36
Join discussion on: http://www.techtud.com/video-lecture/distinct-sql IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 4388 Techtud
Entity, Entity Type, Entity Set | Database Management System
 
07:12
This lecture explains the basic concepts of Entity, Entity Type, and Entity Set. To ask your doubts on this topic and much more, click on this Direct Link: http://www.techtud.com/video-lecture/lecture-entity-entity-type-entity-set IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE(for 'All India Test Series for GATE-2016'): http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate/ Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about our regularly uploaded new videos.
Views: 82430 Techtud
MySQL 27 - TEXT, TINYTEXT, MEDIUMTEXT, LONGTEXT
 
03:42
The TEXT data types have not yet been discussed, but they are another string data type. They are similar to the VARCHAR data type with some minor differences that are important to know. The first thing to note is that there are four versions used to determine different sizes. From least to greatest size is TINYTEXT, TEXT, MEDIUMTEXT, LARGETEXT. These each have different maximum byte sizes: 255, 65535, 16 million something, and 4 billion something. You create a column as one of these data types just as you would with a varchar column. You work with them exactly the same, too. If that is the case, what are the primary differences between these and VARCHAR? The first difference is that VARCHAR is restricted by the row limit of a table. TEXT tables do not contribute nearly as much (max of 12 bytes) because the data is not stored inline in the table. This means that if you need to allow for extra space for other rows, you can use a TEXT column. And even though the table only contains a pointer to the data, it is all hidden to us and working with a TEXT column is the same as working with a VARCHAR column. The second primary difference is that TEXT data types do not allow for a default other than NULL. Thirdly, VARCHAR is limited to just under 64KB, whereas you can use MEDIUMTEXT or LARGETEXT to allow for more storage. So if what you are trying to store as an individual value is over 64KB, use a text column. Other than those three things, VARCHAR will usually work just fine for our text needs. Now, last thing is that these data types are often called CLOB data types. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support me! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 6307 Caleb Curry
Taryon, My Wayward Son | Critical Role RPG Episode 97
 
04:13:23
Catch Critical Role live Thursdays at 7PM PT on Twitch: https://goo.gl/D9fsrS Thanks to @CRTranscript and all the #critters for closed captions! Listen to the Critical Role podcast: https://goo.gl/jVwPBr Tary's past catches up with him, as Vox Machina find themselves racing towards the city of Deastok. Thanks Backblaze! https://bitly.com/BackblazeCriticalRole Thanks to our friends at Wyrmwood Gaming for sponsoring Critical Role! Check out their handcrafted goods at http://www.wyrmwoodgaming.com For more RPGs we love, go to http://bit.ly/GS_RPG Music and Sound by Syrinscape. https://store.syrinscape.com/what-is-syrinscape/?critatt Visit us on http://geekandsundry.com Subscribe to Geek and Sundry: http://goo.gl/B62jl Join our community at: http://geekandsundry.com/community Twitter: http://twitter.com/geekandsundry Facebook: http://facebook.com/geekandsundry Instagram: http://instagram.com/geekandsundry Google+: https://plus.google.com/+GeekandSundry/
Views: 770291 Geek & Sundry
Database Normalization Ebook(r
 
04:12
http://tinyurl.com/p2c6mrk Understanding and mastering database normalization techniques is essential in order to achieve a high performance database design for your system. If your design doesn't conform to (at least) the Third Normal Form (3NF), chances are high that you will find it hard to achieve the performance needed for a successful application. Furthermore, you will find that writing good DML-statements (SELECT, UPDATE, INSERT or DELETE) is difficult, and sometimes actually impossible, without using a lot of procedural coding (PL/SQL in Oracle, VB/C# in Microsoft products). Many "experts" will tell you that if you do database normalization up to (and including) the Third Normal Form, you're well off. The Database Normalization eBook shows you that this a far too easy approach, and it is richly documented with graphical Entity Relationship and Server Diagram examples. Before we proceed, may I ask what is your profession? (If no option matches you, just skip it): http://tinyurl.com/p2c6mrk
Views: 36 mpomos marlos
The SQL EXISTS clause
 
08:52
How to use the EXISTS clause in SQL. For beginners.
Views: 25242 Database by Doug
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: 304341 kudvenkat
Moon Mining Fleet, Join Us! - Giveaways - EVE Online Live
 
05:45:48
Want an entry on the Live Show Giveaway while the show is live? Get your entry here. https://store.markeedragon.com/index.php?cat=18 We will draw near the end of the live show and the winner will be notified by email. If you are viewing the giveaways while the show is offline only monthly giveaways will appear. http://store.markeedragon.com/affiliate.php?id=4&redirect=index.php?cat=4 Special Viewer Discount or Bonus. YOUR CHOICE! Want a bonus on your EVE new account or Plex? Use the discount code of "discount" and get 3% off your order. Or want 3.3% cash back for even more savings? Use bonus code "bonus" and get 3.3% credit in your account for future purchases This is for a limited time and the discount/bonus codes may be changed or removed at any time. The discount / bonus is provided by Markee Dragon Game Codes and we are an authorized CCP reseller. Codes delivered in 20 minutes or less. Twitter: http://twitter.com/markeedragon What's my computer build? Want to know what other stuff I use? Find it here: https://www.amazon.com/shop/markeedragon Want to Try EVE for free? Get it here: http://secure.eveonline.com/signup/?invc=d6baec26-231d-4ced-9cd2-1a8b3713d72d&action=buddy [!nojob] Want to get rid of your day job and be your own boss? Markee Dragon is sharing how he does it with a step by step guide to independence. Get it here: http://jedimarketingtricks.com/ultimate/ Join me and your favorite streamers! Put my 10+ years of experience to work for YOU. Learn how to start generating income while playing your favorite games! I include everything you need to know to get started PLUS plenty of support for when you get stuck! Join us for chat in Discord https://discord.gg/markeedragon Discord is what we use for in game chat and voice comms. This is a simulcast of http://twitch.tv/markeedragon . You can watch here live on YouTube and talk in chat. but for the giveaways mentioned on the show those currently only work in Twitch chat. You do not have to watch on Twitch. You only need to be in the Twitch chat to get in on the giveaways. WTFast is what I use to improve my connection to EVE. I get at least a 20% improvement at all times. Try it here: http://www.wtfast.com/markeedragon Videos How to convert Loyalty Points This video shows how we decided what items to use. Items Sold. https://www.youtube.com/watch?v=rnv4eW9hwP0 What worked Successful conversion of 1m LP to 1.5b ISK in 13 days. https://www.youtube.com/watch?v=eiGEj4XhKt0 Hauling Introduction https://www.youtube.com/watch?v=7NjY9aU-uBQ Hauling is a great secondary income. Market Blue Line Hauling is a great secondary income. EVE Sites Mentioned on the Show EVE Guides and Ship Fits: http://news.markeedragon.com/category/game-guides-how-to/eve-online-guides/ Moose Army Corp - My Null Corp I am a member of. http://moose.army Airhogs - The best all around corp and great for new players. I am also a member http://docs.google.com/document/d/1cCPjgTfOxMN7JpagSs5iUCyES2OalT5j6O4zaP5qVNw/edit?usp=sharing LP Store Conversion See what LP items are currently worth on the market. https://www.fuzzwork.co.uk/lpstore/ Daopa's LP Stores Database LP store items information http://www.ellatha.com/eve/LP-Stores EVE Assets Manager Find your stuff. Know where your money is sitting! http://eve.nikr.net/jeveasset EVE Markets Market history data. http://eve-markets.net/ EVEPraisal Quick values for your loot and other market actions. http://evepraisal.com/ EVE Maps All kinds of map related information. http://evemaps.dotlan.net/ Deepsafe https://deepsafe.xyz Excellent crowed sourced information on cosmic signatures. All explorers should use this. EVE University EVE Wiki http://wiki.eveuniversity.org/Main_Page Live shows Schedule: https://docs.google.com/spreadsheets/d/1zQZoKQnzGRgWXBefzGKlyfDppGQWzJy6PafWm-4c4sQ/pubhtml Music by Monstercat http://www.monstercat.com
ShadowPlayBR Batman Arkham Origins - BatComputer & BatWing
 
05:18
Who are the 8 Assassins?
Views: 6752 Francis Null
Learn SQL Basics in 3 Hours - SQL for Beginners
 
03:10:19
Learn SQL with MySQL in 3 hours - SQL Course for beginners. 👍Subscribe for more SQL tutorials like this: https://goo.gl/6PYaGF 🔥Get my Complete SQL Mastery Course with a 90% discount (limited to the first 200 students): http://bit.ly/2FndOAL 📕Get my FREE SQL cheat sheet: http://bit.ly/2JCO73l 📔Scripts to create the databases in this course: http://bit.ly/2TQAO41 TABLE OF CONTENT 0:00:00 Introduction 0:01:02 What is SQL? 0:04:24 Cheat Sheet 0:04:50 Installing MySQL on Mac 0:09:48 Installing MySQL on Windows 0:15:08 Creating the Databases for this Course 0:23:40 The SELECT Statement 0:29:30 The SELECT Clause 0:38:18 The WHERE Clause 0:43:35 The AND, OR, and NOT Operators 0:51:38 The IN Operator 0:54:41 The BETWEEN Operator 0:56:53 The LIKE Operator 1:02:31 The REGEXP Operator 1:11:51 The IS NULL Operator 1:14:18 The ORDER BY Operator 1:21:23 The LIMIT Operator 1:24:50 Inner Joins 1:33:16 Joining Across Databases 1:36:03 Self Joins 1:40:17 Joining Multiple Tables 1:47:03 Compound Join Conditions 1:50:44 Implicit Join Syntax 1:53:04 Outer Joins 1:59:31 Outer Join Between Multiple Tables 2:05:50 Self Outer Joins 2:08:02 The USING Clause 2:13:25 Natural Joins 2:14:46 Cross Joins 2:18:01 Unions 2:26:29 Column Attributes 2:29:54 Inserting a Single Row 2:35:40 Inserting Multiple Rows 2:38:58 Inserting Hierarchical Rows 2:44:51 Creating a Copy of a Table 2:53:38 Updating a Single Row 2:57:33 Updating Multiple Rows 3:00:47 Using Subqueries in Updates 3:06:24 Deleting Rows 3:07:48 Restoring Course Databases If you're looking for a complete SQL tutorial for beginners with examples, this tutorial is a great way to learn SQL basics. Just follow through and you'll be able to write SQL queries in no time. SQL, short for Structured Query Language, is a language used by software developers, data scientists and anyone who works with data. With SQL, you can store data in relational databases and write queries to extract valuable information. There are various database management systems (DBMS) that support SQL but each product has its own implementation of SQL. In this course, we'll be using MySQL to learn SQL. MySQL is the most popular free and open-source database management system in the world. If you use a different DBMS (eg SQL Server), you can still benefit from this course as 90% of the skills you'll learn in this course can be transferred to other database management systems. Stay in Touch: https://www.facebook.com/programmingwithmosh/ https://twitter.com/moshhamedani http://programmingwithmosh.com
Views: 169225 Programming with Mosh
SQL Database Fundamentals for Data Science and Machine Learning -  By Microsoft
 
03:03:47
Make Sure to SUBSCRIBE to my YouTube channel to get FREE VALUABLE DAILY CONTENT: https://www.youtube.com/channel/UCF6bTmSHZY2zWgxvk7DaLuA SQL is an essential skill to have in every data scientist. You should have sql skill and better understanding. In this complete SQL course you will learn about the following. SQL Query Types SELECT Statement Retrieve records from a table SELECT LIMIT Statement Retrieve records from a table and limit results SELECT TOP Statement Retrieve records from a table and limit results INSERT Statement Insert records into a table UPDATE Statement Update records in a table DELETE Statement Delete records from a table TRUNCATE TABLE Statement Delete all records from a table (no rollback) UNION Operator Combine 2 result sets (removes duplicates) UNION ALL Operator Combine 2 result sets (includes duplicates) INTERSECT Operator Intersection of 2 result sets MINUS Operator Result set of one minus the result set of another EXCEPT Operator Result set of one minus the result set of another SQL Comparison Operators Comparison Operators Operators such as greater than, less than and so on SQL Joins JOIN Tables Inner and Outer joins SQL Aliases ALIASES Create a temporary name for a column or table SQL Clauses DISTINCT Clause Retrieve unique records FROM Clause List tables and join information WHERE Clause Filter results ORDER BY Clause Sort query results GROUP BY Clause Group by one or more columns HAVING Clause Restrict the groups of returned rows SQL Functions COUNT Function Return the count of an expression SUM Function Return the sum of an expression MIN Function Return the min of an expression MAX Function Return the max of an expression AVG Function Return the average of an expression SQL Conditions AND Condition 2 or more conditions to be met OR Condition Any one of the conditions are met AND & OR Combining AND and OR conditions LIKE Condition Use wildcards in a WHERE clause IN Condition Alternative to multiple OR conditions NOT Condition Negate a condition IS NULL Condition Test for NULL value IS NOT NULL Condition Test for NOT NULL value BETWEEN Condition Retrieve within a range (inclusive) EXISTS Condition Condition is met if subquery returns at least one row SQL Tables and Views CREATE TABLE Create a table CREATE TABLE AS Create a table from another table's definition and data ALTER TABLE Add, modify or delete columns in a table; rename a table DROP TABLE Delete a table GLOBAL TEMP Tables Tables that are distinct within SQL session LOCAL TEMP Tables Tables that are distinct within modules and embedded SQL program SQL VIEW Virtual tables (views of other tables) SQL Keys, Constraints and Indexes Primary Keys Create or drop primary keys Indexes Create and drop indexes (performance tuning) SQL Data Types Data Types Data Types in SQL SQL Programming Comments How to create comments within your SQL statement and so on. You will get complete overview of SQL database and learn skill you required for data science. ********************************************* Course Creator: Microsoft License: Creative Commons Attribution license (reuse allowed) ********************************************
Views: 34 Techie Lessons
TERE NAAL NACHNA Full Song | Nawabzaade |  Feat. Athiya Shetty | Badshah, Sunanda S |
 
03:01
T-Series presents the full video of the song "Tere Naal Nachna" from Bollywood romantic comedy "Nawabzaade" film starring Raghav Juyal, Punit J Pathak, Isha Rikhi and Dharmesh Yelande in leading roles and also features Varun Dhawan, Shraddha Kapoor, Athiya Shetty in guest appearances. The movie is produced by Remo D'Souza under Remo D'Souza Entertainment and directed by Jayesh Pradhan. ---------------------------------------------------------------------------------------- ♪ Available on ♪ iTunes : http://bit.ly/Tere-Naal-Nachna-Nawabzaade-iTunes Hungama : http://bit.ly/Tere-Naal-Nachna-Nawabzaade-Hungama Saavn : http://bit.ly/Tere-Naal-Nachna-Nawabzaade-Saavn-1 Gaana : http://bit.ly/Tere-Naal-Nachna-Nawabzaade-Gaana Apple Music : http://bit.ly/Tere-Naal-Nachna-Nawabzaade-Apple-Music Amazon Prime Music : http://bit.ly/Tere-Naal-Nachna-Nawabzaade-Amazon-Music Google Play : http://bit.ly/Tere-Naal-Nachna-Nawabzaade-GooglePlay Wynk : http://bit.ly/Tere-Naal-Nachna-Nawabzaade-Wynk-1 JioMusic : http://bit.ly/Tere-Naal-Nachna-Nawabzaade-Jio Idea Music : http://bit.ly/Tere-Naal-Nachna-Nawabzaade-Idea-Music ---------------------------------------------------------------------------------------- For Caller Tunes : Tere Naal Nachna https://bit.ly/2KX7ujO Tere Naal Nachna - Club Mein Tu Aayi https://bit.ly/2KyY7KR Tere Naal Nachna - Baby Baby You https://bit.ly/2uaXf47 Set as Caller Tune: Set "Tere Naal Nachna" as your caller tune - sms NWBZ4 To 54646 Set "Tere Naal Nachna - Club Mein Tu Aayi" as your caller tune - sms NWBZ5 To 54646 Set "Tere Naal Nachna - Baby Baby You" as your caller tune - sms NWBZ6 To 54646 ________________________________________ ♫ Song - Tere Naal Nachna ♫ Singer - Badshah, Sunanda Sharma ♫ Lyrics - Badshah ♫ Music - Badshah ♫ Programming - Badshah, Aditya Dev ♫ Mixed & Mastered By Aditya Dev ♫ Song Editor - Nitin FCP ♫ Choreographer - Piyush Shazia ♫ Music Label - T-Series ________________________________________ Operator Codes: 1. Tere Naal Nachna Vodafone Subscribers Dial 53710541555 Airtel Subscribers Dial 5432116551528 Idea Subscribers Dial 5678910541555 Tata DoCoMo Subscribers dial 54321110541555 BSNL (South / East) Subscribers sms BT 10541555 To 56700 BSNL (North / West) Subscribers sms BT 7128879 To 56700 Virgin Subscribers sms TT 10541555 To 58475 MTNL Subscribers sms PT 10541555 To 56789 2.Tere Naal Nachna - Club Mein Tu Aayi Vodafone Subscribers Dial 53710541575 Airtel Subscribers Dial 5432116551542 Idea Subscribers Dial 5678910541575 Tata DoCoMo Subscribers dial 54321110541575 BSNL (South / East) Subscribers sms BT 10541575 To 56700 BSNL (North / West) Subscribers sms BT 7128881 To 56700 Virgin Subscribers sms TT 10541575 To 58475 MTNL Subscribers sms PT 10541575 To 56789 3.Tere Naal Nachna - Baby Baby You Vodafone Subscribers Dial 53710541576 Airtel Subscribers Dial 5432116551510 Idea Subscribers Dial 5678910541576 Tata DoCoMo Subscribers dial 54321110541576 BSNL (South / East) Subscribers sms BT 10541576 To 56700 BSNL (North / West) Subscribers sms BT 7128880 To 56700 Virgin Subscribers sms TT 10541576 To 58475 MTNL Subscribers sms PT 10541576 To 56789 ___ Enjoy & stay connected with us! ► Subscribe to T-Series: http://bit.ly/TSeriesYouTube ► Like us on Facebook: https://www.facebook.com/tseriesmusic ► Follow us on Twitter: https://twitter.com/tseries ► Follow us on Instagram: http://bit.ly/InstagramTseries
Views: 87953568 T-Series
IPPCR 2015: Overview of Hypothesis Testing
 
01:27:09
IPPCR 2015: Overview of Hypothesis Testing Air date: Tuesday, November 03, 2015, 5:00:00 PM Category: IPPCR Runtime: 01:27:08 Description: The Introduction to the Principles and Practice of Clinical Research (IPPCR) is a course to train participants on how to effectively conduct clinical research. The course focuses on the spectrum of clinical research and the research process by highlighting epidemiologic methods, study design, protocol preparation, patient monitoring, quality assurance, and Food and Drug Administration (FDA) issues. For more information go to https://ippcr.nihtraining.com/login.php Author: Paul Wakim, Ph.D., NIH Permanent link: http://videocast.nih.gov/launch.asp?19299
Views: 6242 nihvcast
RDBMS Concepts Session 1 Relational Database Model
 
43:31
RDBMS Concepts Session 1 Relational Database Model. To Learn or Teach Linux visit www.theskillpedia.com, A Marketplace for Learners and Trainers. Drawbacks of DBMS DBMS models are complex Difficult for new programmers and users. Therefore, training is required Costly system set up These drawbacks gave way for the new Relational Model Relational Model Dr. E. F. Codd described the Relation Model in 1970 He put 12 Rules describing the Relational Model All the RDBMS applications should follow the Rules Rules of Dr. E F codd. Rule (0): Foundation Rule Database must manage its data storage only using relational capabilities (table forms) Rule 1: Information Rule Database must represent its data as values of a table. Rule 2: Guaranteed Access Rule The data can be accessed by specifying the table name and the column name and the columns that defined the primary key . Primary key ensures that each value is unique and accessible. Rule 3: Systematic Treatment of NULL Values A null is a unknown value and every database must have a provision for storing NULL values. NULL != 0 NULL != space Rules of Dr. E F codd. (Contd.). Rule 4: Dynamic On-Line Catalog Based on the Relational Model User data in tables and the information about the table such as structure and other required information also in tables only. One as user tables and another as metadata this metadata is what called as system catalog. Rule 5: Comprehensive Sub Language There must be at least one language which supports data defining, view defining , manipulating data, integrity constraints. All the above should be supported with well defined syntax, as character strings. Rules of Dr. E F codd. (Contd.). Rule 6: View Updating Rule Should support a mechanism which designs different combinations of data from different tables called as views. All the view should be updateable. Views are virtual tables that contains extraction of data from the source tables Either it is a simple view or a complex view it should allow updates to the view. Rule 7: High Level Insert Update and Delete Rule Data manipulation operations treat Rows as a set. These set operations and relational operators are used to work on table. Use of insert, update and delete operations on views should act on their respective tables Rules of Dr. E F codd. (Contd.). Rule 8: Physical Data Independence Rule Changes in the data storage should not effect programs that access the data. Rule 9: Logical Data Independency Rule The data is stored in the files physically, but tables are logical structures. So for making any changes need in logical structures there is no need of any change in the application. Rule 10: Integrity Independency Rule Data integrity means the consistency and accuracy which keeps the garbage out of the database. Integrity constraints must be the supported functionality of any database application. Rules of Dr. E F codd. (Contd.). Rule 11: Distribution Rule To the end user all the commands should be working a same as it would working for the local database even though the database is in some other place and user is accessing through network. Rule 12: Non Subversion Rule All the constraints defined by the user using the SQL should not be by passed by any other way. Benefits of an RDBMS The ability to create multiple relations (tables) and enter data into them An interactive query language Retrieval of information stored in more than one table Provides a Catalog or Dictionary, which itself consists of tables (called system tables) Some Important Terms Relation : A table Tuple : A row in a table Attribute : A Column in a table Degree : Number of attributes Cardinality : Number of tuples Primary Key : A unique identifier for the table Domain : Pool of values from which specific attributes of specific relations draw their values Entity-Relationship Model E-R Modeling: Terminology Entity is anything that exists and is distinguishable Entity Set a group of similar entities Attribute properties that describe an entity Relationship an association between entities ER Modeling Notations ER Modeling: Entity ER Modeling: Types of Relationships E-R Model ER-Modeling: Key Constraint Key Constraints For Ternary Relationships E-R Modeling Participation Constraints E-R Modeling: Weak Entities Visit www.theskillpedia.com to teach or learn a skill For Any corporate Training Need, Call me at +91-9312406920
Views: 8187 TheSkillPedia