Home
Search results “Trunc date to hour oracle”
oracle date and time functions
 
21:33
Video from our Oracle SQL course. Check out the full course at.. http://learn.hackpress.co/courses/oracle-sql-learning-by-example
Views: 49153 etldeveloper
Oracle SQL TUTORIAL – Date columns with Time in Where condition
 
12:41
In this video, we will see how to retrieve records for a specific time duration. SQLs used in this video are given below. select * from employees; alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS'; SELECT DBMS_RANDOM.VALUE(0,9) FROM DUAL; SELECT SYSDATE-DBMS_RANDOM.VALUE(0,9) FROM DUAL; SELECT FIRST_NAME,LAST_NAME, SYSDATE-DBMS_RANDOM.VALUE(0,9) CREATED_DATE FROM EMPLOYEES; CREATE TABLE EMP_TEST AS SELECT FIRST_NAME,LAST_NAME, SYSDATE-DBMS_RANDOM.VALUE(0,9) CREATED_DATE FROM EMPLOYEES; SELECT * FROM EMP_TEST ORDER BY CREATED_DATE DESC; select sysdate from dual; select sysdate,trunc(sysdate) from dual; 26 sep 2018 00:00:00 to 26 sep 2018 23:59:59 select sysdate,trunc(sysdate),trunc(sysdate)+0.99999 from dual; Records that got created yesterday.. 25 sep 2018 00:00:00 to 25 sep 2018 23:59:59 select trunc(sysdate-1),trunc(sysdate-1)+0.99999 from dual; SELECT * FROM emp_test WHERE created_date BETWEEN trunc(SYSDATE-1) AND trunc(SYSDATE-1)+0.99999 order by created_date; Retrieve records for 22nd Septembter 2018 SELECT * FROM emp_test WHERE created_date BETWEEN to_date('22-sep-2018 00:00:00','dd-mon-yyyy hh24:mi:ss') AND to_date('22-sep-2018 23:59:59','dd-mon-yyyy hh24:mi:ss') order by created_date; SELECT * FROM emp_test WHERE created_date BETWEEN to_date('22-sep-2018','dd-mon-yyyy') AND to_date('22-sep-2018 23:59:59','dd-mon-yyyy hh24:mi:ss') order by created_date; -- Get all records created in last 24 hours select sysdate,sysdate-1 from dual; SELECT * FROM emp_test where created_date between sysdate-1 and sysdate order by created_date;
Views: 271 Ganesh Anbarasu
Oracle CURRENT_TIMESTAMP Function
 
02:37
https://www.databasestar.com/oracle-date-functions/ The Oracle CURRENT_TIMESTAMP function will display the current date and time in the session time zone. Just like the CURRENT_DATE function, it uses the session time zone, which is where you logged in from. This could be different to the database time zone. The syntax of the CURRENT_TIMESTAMP function is: CURRENT_TIMESTAMP ( [precision] ) The return type of this function is TIMESTAMP WITH TIME ZONE. The precision parameter is optional, and it lets you specify the number of fractional seconds to return. If this is omitted, it uses the default of 6. It’s different to the SYSTIMESTAMP function, because CURRENT_TIMESTAMP returns the session timezone, and SYSTIMESTAMP returns the database time zone. So, if I’m logging in from Melbourne, Australia, and the database is in London, England, then the CURRENT_TIMESTAMP will return a date and time that’s 10 hours ahead of SYSTIMESTAMP, and in a different time zone. It may be on the same day, or it could be a different day, depending on when I run the function. You can perform arithmetic on this function just like any other date value (e.g. CURRENT_TIMESTAMP - 7 for 7 days ago). However, it might be better to use interval data types so you can keep the original data type. For more information about the Oracle CURRENT_TIMESTAMP function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-date-functions/
Views: 469 Database Star
Custom date time format in Oracle SQL Developer?
 
01:03
From Oracle SQL Developer's menu go to Tools -- Preferences. From the Preferences dialog, select Database -- NLS from the left panel. From the list of NLS parameters, enter DD-MON-RR HH24:MI:SS or for 24-Hour, DD-MON-YY HH24:MI:SS Or just for an active session use below instead. alter SESSION set NLS_DATE_FORMAT = 'required_date_format' i.e. alter SESSION set NLS_DATE_FORMAT = 'DD-MM-YYYY HH24:MI:SS' into the Date Format field. Save and close the dialog.
Views: 1291 Maruti AIR Tech
Learn Excel - Truncate Date+Time to Date - Podcast 2203
 
03:49
Ian in Nashville gets data from the system. The date column has date and time. This really screws up the pivot table, because instead of daily dates, he gets time. One solution: Group the pivot table by Date Better solution: Power Query Make the downloaded data set in to a table with Ctrl+T Data, From Table. Select the Date Time column and transform to Date Close and Load Build the pivot table from that The next time you get data, paste to original table. Go to Query. Refresh. Refresh the Pivot Table To download this workbook: https://www.mrexcel.com/download-center/2018/05/date-time-to-date.xlsx List of upcoming seminars: https://www.mrexcel.com/press-appearances/
Views: 1295 MrExcel.com
คำสั่ง TRUNC ตัดค่าวันที่กับตัวเลขแบบง่าย ๆ ใน Oracle
 
08:10
คำสั่ง TRUNC ตัดค่าวันที่กับตัวเลขแบบง่าย ๆ ใน Oracle ดูเพิ่มเติมได้ที่ http://www.doesystem.info/2016/07/oracle-trunc.html โปรแกรม สอนใช้โปรแกรม สอน แนะนำ และช่วยแก้ปัญหา เกี่ยวกับคอมพิวเตอร์และไอที สอนการใช้งาน การเรียนรู้ การแก้ปัญหา การทำเว็บไซต์ การเขียนโปรแกรม และไอทีอื่น ๆ Oracle คำสั่ง TRUNC เบื้องต้น บทความนี้เรามาดูคำสั่งใน Oracle กันอีกซักหน่อย ซึ่งคำสั่งนั้นคือ TRUNC ครับ ในคำสั่ง TRUNC นั้นสามารถใช้ได้ทั้งตัวเลขและก็เวลาเลยครับ นั่นก็แปลว่ามันจะมีทั้งคำสั่ง TRUNC(date) และก็ TRUNC(number) มาดู Syntax กันก่อนดีกว่าครับ TRUNC(number) Syntax ของ TRUNC(number) แสดงได้ดังด้านล่าง TRUNC(n1 [, n2 ]) TRUNC(number) เมื่อเรียกใช้จะรีเทิร์นค่าเป็นตัวเลขที่ถูกตัดออก ตัวตำแหน่งของตัวที่ถูกตัดออกจะถูกกำหนดด้วย n2 แต่ถ้าไม่ได้กำหนด n2 มาให้ n2 จะถูกแทนที่ด้วยเลข 0 ในฟังก์ชัน TRUNC(number) นี้เราสามารถกำหนดได้ทั้งจำนวนลบ บวก หรือ 0 ก็ได้ทั้งนั้น เรามาดูตัวอย่างการใช้งานกัน ตัวอย่างคำสั่ง TRUNC(number) แบบง่าย ๆ select trunc(19.32, 0) from dual; ผลลัพธ์ที่ได้ก็คือ 19 เพราะตัดตำแหน่งที่ 0 select trunc(19.32, 1) from dual; ผลลัพธ์ที่ได้คือ 19.3 เพราะตัดตำแหน่งที่ 1 select trunc(19.32, -1) from dual; ผลลัพธ์ที่ได้คือ 10 เพราะตัดตำแหน่งที่ -1 นั่นคือย้อนกลับไปหนึ่งตำแหน่งก็คือ 10 เลข 9 ตัดทิ้ง TRUNC(date) Syntax ของ TRUNC(date) แสดงได้ดังด้านล่าง TRUNC(date [, fmt ]) TRUNC(date) เมื่อเรียกใช้ฟังก์ชันนี้แล้วจะรีเทิร์นค่าเป็น Date ซึ่ง Date ที่ได้จะเป็นเวลาที่ถูกตัดโดยกำหนดไว้ใน fmt ข้อมูลที่ได้จะเป็นข้อมูล Date เสมอแม้ว่าจะกำหนดตัวแปรเป็น DateTime ก็ตามแต่ สำหรับ fmt ที่ใส่ได้นั้นแสดงได้ตามด้านล่าง Unit Valid format parameters Year SYYYY, YYYY, YEAR, SYEAR, YYY, YY, Y ISO Year IYYY, IY, I Quarter Q Month MONTH, MON, MM, RM Week WW IW IW W W Day DDD, DD, J Start day of the week DAY, DY, D Hour HH, HH12, HH24 Minute MI เมื่อได้ format แล้วเรามาลองเรียกใช้งานกันดูครับ ตัวอย่างง่าย ๆ สำหรับการใช้งานฟังก์ชัน TRUNC ใน Oracle แสดงได้ดังนี้ select trunc(to_date('04-07-2016', 'DD-MM-YYYY'), 'YEAR') from dual; เมื่อรันคำสั่งนี้จะได้ผลลัพธ์เป็น 01-JAN-16 ซึ่งเราใช้ฟอร์แมท YEAR เป็นฟอร์แมทของปีดังนั้นมันจะตัดทิ้งแล้วไปต้นปีนั่นก็คือวันที่ 1 มกราของปีนั้น ๆ คือ 1 JAN 2016 select trunc(to_date('04-07-2016', 'DD-MM-YYYY'), 'MONTH') from dual; ตัวอย่างนี้เมื่อรันแล้วจะได้ผลลัพธ์เป็น 01-JUL-16 ซึ่งก็ได้ว่าฟอร์แมทที่เราใช้นั้นเป็น MONTH ซึ่งเป็นเดือน ดังนั้นมันจะกระโดดไปต้นเดือนแล้วตัดส่วนอื่นทิ้งนั่นก็คือต้นเดือนวันที่ 1 JUL 2016 สำหรับฟอร์แมทอื่น ๆ หรือตัวเลขอื่น ๆ ของไปเล่นกันดูครับ
Views: 472 Akira Shoyasu
Oracle TO_TIMESTAMP Function
 
01:31
https://www.databasestar.com/oracle-to_timestamp/ The Oracle TO_TIMESTAMP function can be confusing, but we’ll explain it in this video. This function allows you to convert a string value into a TIMESTAMP value. A TIMESTAMP value is a type of DATE, but has a few components: - A date, including day, month, and year - A time, including hours, minutes, seconds, and fractional seconds This is a useful data type because it allows you to store a time down to fractions of a second. The syntax of the TO_TIMESTAMP function is: TO_TIMESTAMP ( input_string [, format_mask] [, nls_param] ) The input_string parameter is the string you want to convert. The format_mask is where you specify the format of the input_string parameter. This is so you can specify the input_string in a variety of formats, and just use this format_mask to indicate which format it is in. The nls_param parameter is another optional parameter, and allows you to specify the returning language of the month and day names. The default format will depend on the region you’re running your database in. In my example (using Oracle Express in Australia), the default format is ‘DD-MM-RRRR HH:MI:SS AM’. For more information on the Oracle TO_TIMESTAMP function, including the SQL used in this video, read the related article here: https://www.databasestar.com/oracle-to_timestamp/
Views: 540 Database Star
How to use tricky things with SYSDATE
 
04:59
How to use tricky things with SYSDATE like how to know the next day, next hour, next minuite etc.,
Views: 1320 Techie Rajesh
EXCEL: Difference between INT and TRUNC functions
 
08:47
EXCEL: Difference between INT and TRUNC functions INT function The formula syntax and usage of the INT function in Microsoft Excel. Description Rounds a number down to the nearest integer. Syntax INT(number) The INT function syntax has the following arguments: Number Required. The real number you want to round down to an integer. TRUNC function Description Truncates a number to an integer by removing the fractional part of the number. Syntax TRUNC(number, [num_digits]) The TRUNC function syntax has the following arguments: Number Required. The number you want to truncate. Num_digits Optional. A number specifying the precision of the truncation. The default value for num_digits is 0 (zero). Remark TRUNC and INT are similar in that both return integers. TRUNC removes the fractional part of the number. INT rounds numbers down to the nearest integer based on the value of the fractional part of the number. INT and TRUNC are different only when using negative numbers: TRUNC(-4.3) returns -4, but INT(-4.3) returns -5 because -5 is the lower number.
Views: 410 Allan Sam
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: 481 Oracle Analytics
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: 5474 LiveLessons
Learn SQL: Query 4: Working with DATES
 
02:01
Dataset: http://www.ishelp.info/sites/yt/gsdb.accdb Next video: https://www.youtube.com/watch?v=adQR-EY6v2s&index=4&list=PLe9UEU4oeAuVIarKPBffh4qWv31lX391g Previous video: https://www.youtube.com/watch?v=Mztp1M5FUN4&index=2&list=PLe9UEU4oeAuVIarKPBffh4qWv31lX391g Topic: Learn Structured Query Language ( SQL ) keywords SELECT FROM WHERE topic DATES
Views: 3406 Mark Keith
FUNCIONES para FECHAS y TIEMPO - Date, Time , Timestamp y Extract() | Curso de PostgreSQL #53
 
05:55
PostgreSQL ofrece algunas funciones para trabajar con fechas y horas. Estas son algunas: - current_date - current_time - current_timestamp - extract(X from current_timestamp) Funciones para el extract: year, month, day, hour, minute, second, century, día de a semana = dow, día del año = doy, week, quarter. 🚩 Nuevo en el canal? Activa la 🔔 cuando te suscribas! ►[http://goo.gl/TZEYAO]◄ GRACIAS POR TU APOYO Y TU LIKE ►► Apoya al canal con una donación: https://goo.gl/MfnpWD ►► Tienda en Linea de la comunidad!: https://goo.gl/aK3YrC ►Hosting Profesional: https://goo.gl/Zaivk4 🚩🚩CUPONES🚩🚩 2 Meses gratis: tecnobinaria2M 10% Desc Anual: tecnobinarianual10 Host Wordpress básico muy barato!: tecnobinariaWPbasico ► Mira templates para WordPress AQUÍ: 🚩🚩 http://tiny.cc/galjwy Recibe un descuento usando el CUPÓN: TecnologiaBinaria10 ▼ Únete a nuestras redes sociales: ► Facebook: https://goo.gl/Sh9K3F ► Grupo en Facebook: https://goo.gl/sTvbFz ► Twiter: https://goo.gl/mnqGrg ► Instagram: https://goo.gl/mkYHuy ► Ayúdanos a Subtitular este y otros vídeos para llegar a más personas: https://goo.gl/kEr6xW ▼Más Cursos: ► SQL Server: https://goo.gl/7vMQnD ► C#: https://goo.gl/aZt3jo ► Java: https://goo.gl/VhFRR4 ► VB .Net: https://goo.gl/Gwh6O4 ► VBA: https://goo.gl/TxsZz3 ► Iniciándose en la programación: https://goo.gl/dHcmnM ▼ Código y más! ► Repositorio del Query del curso de SQL Server: https://goo.gl/LSig71 ▼ Música: ► Epidemic Sound: https://goo.gl/EY7jXG #PostgreSQL #Funciones #Fecha #Hora #Fundamentos #TecnologíaBinaria
Use of TRUNC Function for separating Date and Time in Excel sheet
 
01:59
excel function TRUNC various usages........
Views: 159 Er.Sathavara Dinesh
How to Change the Calendar in Primavera || Primavera Tricks
 
01:14
If you want to Change the Calendar of all the activities once the schedule is prepared, to see the impact of changing the calendars, Just follow the below mention steps. Step 1: Open the project, Right Click on any activity and select Columns, Find (Ctrl+F) and type in Calendar and select the calendar, and click on OK to insert the calendar column. Step 2: click on the top most cell in the calendar column ,select the desired calendar for that single activity and then press the Shift key on the keyboard and Select the bottom most cell of the Calendar column, right click and select the Fill down option- to change the calendars for all the activities of the schedule. Doing this, the default calendar will be shown only for the WBS, but the calendars for the activities get changed. For Personalized detail learning, write to [email protected] If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. *********************************************** ★ My Online Tutorials ► https://www.dptutorials.com LEARNING RESOURCES I Recommend: https://www.dptutorials.com/resources Subscribe for more Awesome Tutorials: goo.gl/NyAtg2 Support the Channel via shopping: http://ift.tt/2jH38PR Tools that I use for Vlogging: • Laptop: https://amzn.to/2E5U3MO • Canon 200D Camera: https://amzn.to/2HglDYA • Benro Tripod: https://amzn.to/2ExRvYj • Blue yeti microphone: https://amzn.to/2VwZyPn • Collar Microphone: https://amzn.to/2VyOdcM • Bluedio Headset: https://amzn.to/2W3xUZX • Screen recorder: https://techsmith.pxf.io/2BMjA • Boom Arm Stand: https://amzn.to/2VCQNi7 • Zoom H1 Audio Recorder: https://amzn.to/2VDumsT • Harison Softbox Studio Lights: https://amzn.to/2LY7x3u • Chroma Key Green Screen: https://amzn.to/2ExTr31 • Background Support Stand: https://amzn.to/2McqnEv • Acoustic Foam Background: https://amzn.to/2EoQ1zj • USB RGB LED Strip: https://amzn.to/2VItKm4 • Wireless Mouse: https://amzn.to/2E23cpN 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! *********************************************** You Can Connect with Me at YouTube: www.youtube.com/c/dptutorials G+: http://ift.tt/2kAOpa6 Twitter: https://twitter.com/dptutorials15 Facebook: http://ift.tt/2kfRnDi BlogSpot: http://ift.tt/2kB14dh Follow: www.dptutorials.com www.askplanner.blogspot.com Tags: - P6: primavera p6 training online, primavera p6, primavera p6 training, primavera p6 tutorial, oracle primavera, primavera p6 download, primavera 6, oracle primavera p6, primavera p6 free download, primavera project management, primavera project planner, primavera download, primavera online, primavera training, primavera software free download, youtube primavera, primavera tutorial, is primavera online easy, p6 online, primavera p6 complete video tutorial free download, critical path, oracle primavera, primavera p6, primavera, primavera software, construction project management software, project management software, project management books, microsoft project, project management courses, project management certification, online project management, project management tools, free project management software, project management training, best project management software, pmp certification, free project management tools, project management apps, microsoft project management, project management professional certification, google project management, ms project, agile project management, basecamp project management, project portfolio management, project management, project management system, scrum project management, open source project management, project management template, construction project management, project plan, project management professional, free project management, it project manager, project manager jobs, project management excel, project management consultant, pmi, project management plan, certified associate in project management, pmp, project management examples, what is project management, project management skills, engineering project manager, project risk management, project management steps, project management methodologies, project management process, marketing project manager, p6, primavera online, project management life cycle, project manager resume, project management phases, project management definition, project manager interview questions, project integration management, project manager responsibilities, project scope management, prima vera, project manager salary, oracle, oracle merge, explain plan in oracle, oracle group by, oracle case, with clause in oracle, oracle date format, oracle trunc, oracle replace, materialized view in oracle
Views: 981 dptutorials
Introduction to SQL - 6(Individual Row Functions)
 
19:21
This video explains the use of individual row functions to work upon numbers , strings and dates. I hope the examples given would help you understand it properly, in case of any doubts write in the comment section.
Views: 662 Anjali Luthra
How to Set  the Calendar in Primavera P6 || Primavera || dptutorials
 
01:34
Let's see How to set the Default calendar, Step 1: Go to Enterprise---Calendars, Step 2: Tick/Check the Calendar which you want to make as default, Step 3: If you want to further change the timings and work weeks, click on Modify Step 4: Click on "Work Weeks" and Change the Time periods for the work hours in the default calendar Step 5: After Creating the Schedule, in the middle of the schedule, if you want to change the calendar for the activities that you enter further, Go to Details tab--Defaults Tab;It will show the default calendar, if you want to change the calendar, select the calendar clicking the bubble. For Personalized detail learning, write to [email protected] If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. *********************************************** ★ My Online Tutorials ► https://www.dptutorials.com LEARNING RESOURCES I Recommend: https://www.dptutorials.com/resources Subscribe for more Awesome Tutorials: goo.gl/NyAtg2 Support the Channel via shopping: http://ift.tt/2jH38PR Tools that I use for Vlogging: • Laptop: https://amzn.to/2E5U3MO • Canon 200D Camera: https://amzn.to/2HglDYA • Benro Tripod: https://amzn.to/2ExRvYj • Blue yeti microphone: https://amzn.to/2VwZyPn • Collar Microphone: https://amzn.to/2VyOdcM • Bluedio Headset: https://amzn.to/2W3xUZX • Screen recorder: https://techsmith.pxf.io/2BMjA • Boom Arm Stand: https://amzn.to/2VCQNi7 • Zoom H1 Audio Recorder: https://amzn.to/2VDumsT • Harison Softbox Studio Lights: https://amzn.to/2LY7x3u • Chroma Key Green Screen: https://amzn.to/2ExTr31 • Background Support Stand: https://amzn.to/2McqnEv • Acoustic Foam Background: https://amzn.to/2EoQ1zj • USB RGB LED Strip: https://amzn.to/2VItKm4 • Wireless Mouse: https://amzn.to/2E23cpN 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! *********************************************** You Can Connect with Me at YouTube: www.youtube.com/c/dptutorials G+: http://ift.tt/2kAOpa6 Twitter: https://twitter.com/dptutorials15 Facebook: http://ift.tt/2kfRnDi BlogSpot: http://ift.tt/2kB14dh Follow: www.dptutorials.com www.askplanner.blogspot.com Tags: - P6: primavera p6 training online, primavera p6, primavera p6 training, primavera p6 tutorial, oracle primavera, primavera p6 download, primavera 6, oracle primavera p6, primavera p6 free download, primavera project management, primavera project planner, primavera download, primavera online, primavera training, primavera software free download, youtube primavera, primavera tutorial, is primavera online easy, p6 online, primavera p6 complete video tutorial free download, critical path, oracle primavera, primavera p6, primavera, primavera software, construction project management software, project management software, project management books, microsoft project, project management courses, project management certification, online project management, project management tools, free project management software, project management training, best project management software, pmp certification, free project management tools, project management apps, microsoft project management, project management professional certification, google project management, ms project, agile project management, basecamp project management, project portfolio management, project management, project management system, scrum project management, open source project management, project management template, construction project management, project plan, project management professional, free project management, it project manager, project manager jobs, project management excel, project management consultant, pmi, project management plan, certified associate in project management, pmp, project management examples, what is project management, project management skills, engineering project manager, project risk management, project management steps, project management methodologies, project management process, marketing project manager, p6, primavera online, project management life cycle, project manager resume, project management phases, project management definition, project manager interview questions, project integration management, project manager responsibilities, project scope management, prima vera, project manager salary, oracle, oracle merge, explain plan in oracle, oracle group by, oracle case, with clause in oracle, oracle date format, oracle trunc, oracle replace, materialized view in oracle, oracle timestamp, oracle oci, oracle wiki
Views: 1453 dptutorials
Common issues with SQL dates in 9 minutes and a half
 
09:42
CAPTIONS AVAILABLE. Full transcript (with some screenshots) available for a small fee at http://stores.lulu.com/konagora/. Conditions on dates are a frequent source of performance issues. Using dates well isn't difficult. Here is how.
Views: 3374 roughsealtd
Oracle - SQL - Group By Clause
 
07:50
Oracle - SQL - Group By Clause Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
oracle set operator union unionall intersect minus
 
15:32
Description: Oracle Interview Question - oracle set operator, union, unionall, intersect, minus List of all the SQL and PLSQL interview questions @ https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 1291 Siva Academy
Oracle ROUND: Number function
 
03:48
Oracle TRUNC: Number function https://www.youtube.com/watch?time_continue=3&v=4lchx4sseEM Oracle MOD: Number function https://www.youtube.com/watch?v=eMGgo_1y6b4&feature=youtu.be The usage of SELECT Playlist: https://www.youtube.com/watch?v=ZwgiIiD1dWE&list=PLjBraywgeSpEW2f7AK4Ddt6BRxW0HWN74
Oracle SQL Practical question Write a sql to replace the comma separated value
 
13:17
SQL Practical Interview question Oracle sql practice exercise with solution SQL questions for data analysis SQL scenario based interview questions Click here to subscribe to my youtube channel http://www.youtube.com/channel/UCBt6VrxAIb5jLh9HLDcdwtQ?sub_confirmation=1 Oracle Interview questions and Answers at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm Oracle 18C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW Oracle 12C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx- Oracle PLSQL records and collections at https://www.youtube.com/playlist?list=PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm
Views: 712 Siva Academy
Nesting Functions Within Functions (Introduction to Oracle SQL)
 
03:47
Learn how to nest one function inside another function, and why this might be needed. The full Introduction to Oracle SQL course is available here: https://www.databasestar.com/introduction-to-oracle-sql-course/
Views: 472 Database Star
SQL To_char Function with excellent examples
 
13:27
SQL To_char Function with excellent examples
Views: 8622 SQL Guru
Mathematical Functions in SQL SERVER Part I || ABS, CEILING, FLOOR, POWER functions in SQL 2014
 
04:23
This video will provide you the details of each Mathematical Function in SQL Server 2014. ***********************************************************************  ABS (Transact-SQL) A mathematical function that returns the absolute (positive) value of the specified numeric expression.  Syntax ABS ( numeric_expression )  Arguments numeric_expression Is an expression of the exact numeric or approximate numeric data type category.  Return Types Returns the same type as numeric_expression.  Examples The following example shows the results of using the ABS function on three different numbers. SELECT ABS(-1.0), ABS(0.0), ABS(1.0); Here is the result set. ---- ---- ---- 1.0 .0 1.0 The ABS function can produce an overflow error when the absolute value of a number is greater than the largest number that can be represented by the specified data type. For example, the int data type can hold only values that range from -2,147,483,648 to 2,147,483,647. Computing the absolute value for the signed integer -2,147,483,648 causes an overflow error because its absolute value is greater than the positive range for the int data type. DECLARE @i int; SET @i = -2147483648; SELECT ABS(@i); ***********************************************************************  CEILING (Transact-SQL) Returns the smallest integer greater than, or equal to, the specified numeric expression.  Syntax CEILING ( numeric_expression )  Arguments numeric_expression Is an expression of the exact numeric or approximate numeric data type category, except for the bit data type.  Return Types Returns the same type as numeric_expression.  Examples The following example shows positive numeric, negative, and zero values with the CEILING function. SELECT CEILING($123.45), CEILING($-123.45), CEILING($0.0); GO ***********************************************************************  FLOOR (Transact-SQL) Returns the largest integer less than or equal to the specified numeric expression.  Syntax FLOOR ( numeric_expression )  Arguments numeric_expression Is an expression of the exact numeric or approximate numeric data type category, except for the bit data type.  Return Types Returns the same type as numeric_expression.  Examples The following example shows positive numeric, negative numeric, and currency values with the FLOOR function. SELECT FLOOR(123.45), FLOOR(-123.45), FLOOR($123.45); ***********************************************************************  POWER (Transact-SQL) Returns the value of the specified expression to the specified power.  Syntax POWER ( float_expression , y )  Arguments float_expression Is an expression of type float or of a type that can be implicitly converted to float. y Is the power to which to raise float_expression. y can be an expression of the exact numeric or approximate numeric data type category, except for thebit data type.  Return Types Returns the same type as submitted in float_expression. For example, if a decimal(2,0) is submitted as float_expression, the result returned isdecimal(2,0).  Examples A. Using POWER to return the cube of a number The following example demonstrates raising a number to the power of 3 (the cube of the number). DECLARE @input1 float; DECLARE @input2 float; SET @input1= 2; SET @input2 = 2.5; SELECT POWER(@input1, 3) AS Result1, POWER(@input2, 3) AS Result2;
Views: 205 Softtech forum
Tutorial 11 : SQL INSTR() Function
 
06:58
Hi Friends! Here we are learning about SQL INSTR() Function. Let me know for any confusion or doubt. You can write in mail - [email protected] Or, comment in comment box. Thanks!
Views: 433 YourSmartCode
Tutorial#49 How to use  ROUND Function in Oracle SQL Database|Number Function in Oracle Database
 
03:09
ROUND function returns a number rounded to a certain number of decimal places 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 will be available soon: In this series we cover the following topics: 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. 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: 94 EqualConnect Coach
Sql Server tutorial || onlinetraining||date functions Part-1 by Narayana
 
25:22
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
Primavera Tricks : Why Primavera P6 Can not Filter On Start Or Finish Date By Default || dptutorials
 
02:51
Consider this project as an example here in this tutorial. Let us try to show only activity which finish on 04-Jul-18. What we generally do is, we create a filter like this: But you will notice that the screen goes blank without showing any activity. But why does this happen? Let us know the solution now. You need to show the time of activity by going to Edit, User Preferences , Dates tab, In “Time” section, click on “24 hour” Now you can see the date format showing the Time for start and finish. You should have noticed by now that when we created a filter, primavera will treat the time as 00:00 by default. That’s why P6 can not find any activity. So let us modify the filter again to cover the entire day like this. Now, P6 will  show  the activity which has finish date of 04-Jul-18. That's it friends. For Personalized detail learning, write to [email protected] If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. *********************************************** ★ My Online Tutorials ► https://www.dptutorials.com LEARNING RESOURCES I Recommend: https://www.dptutorials.com/resources Subscribe for more Awesome Tutorials: goo.gl/NyAtg2 Support the Channel via shopping: http://ift.tt/2jH38PR Tools that I use for Vlogging: • Laptop: https://amzn.to/2E5U3MO • Canon 200D Camera: https://amzn.to/2HglDYA • Benro Tripod: https://amzn.to/2ExRvYj • Blue yeti microphone: https://amzn.to/2VwZyPn • Collar Microphone: https://amzn.to/2VyOdcM • Bluedio Headset: https://amzn.to/2W3xUZX • Screen recorder: https://techsmith.pxf.io/2BMjA • Boom Arm Stand: https://amzn.to/2VCQNi7 • Zoom H1 Audio Recorder: https://amzn.to/2VDumsT • Harison Softbox Studio Lights: https://amzn.to/2LY7x3u • Chroma Key Green Screen: https://amzn.to/2ExTr31 • Background Support Stand: https://amzn.to/2McqnEv • Acoustic Foam Background: https://amzn.to/2EoQ1zj • USB RGB LED Strip: https://amzn.to/2VItKm4 • Wireless Mouse: https://amzn.to/2E23cpN 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! *********************************************** You Can Connect with Me at YouTube: www.youtube.com/c/dptutorials G+: http://ift.tt/2kAOpa6 Twitter: https://twitter.com/dptutorials15 Facebook: http://ift.tt/2kfRnDi BlogSpot: http://ift.tt/2kB14dh Follow: www.dptutorials.com www.askplanner.blogspot.com Tags: - P6: primavera p6 training online, primavera p6, primavera p6 training, primavera p6 tutorial, oracle primavera, primavera p6 download, primavera 6, oracle primavera p6, primavera p6 free download, primavera project management, primavera project planner, primavera download, primavera online, primavera training, primavera software free download, youtube primavera, primavera tutorial, is primavera online easy, p6 online, primavera p6 complete video tutorial free download, critical path, oracle primavera, primavera p6, primavera, primavera software, construction project management software, project management software, project management books, microsoft project, project management courses, project management certification, online project management, project management tools, free project management software, project management training, best project management software, pmp certification, free project management tools, project management apps, microsoft project management, project management professional certification, google project management, ms project, agile project management, basecamp project management, project portfolio management, project management, project management system, scrum project management, open source project management, project management template, construction project management, project plan, project management professional, free project management, it project manager, project manager jobs, project management excel, project management consultant, pmi, project management plan, certified associate in project management, pmp, project management examples, what is project management, project management skills, engineering project manager, project risk management, project management steps, project management methodologies, project management process, marketing project manager, p6, primavera online, project management life cycle, project manager resume, project management phases, project management definition, project manager interview questions, project integration management, project manager responsibilities, project scope management, prima vera, project manager salary, oracle, oracle merge, explain plan in oracle, oracle group by, oracle case, with clause in oracle, oracle date format, oracle trunc, oracle replace
Views: 1088 dptutorials
T-SQL: How to calculate the total number of working days between two dates?
 
10:17
FULL TSQL SCRIPT IS HERE: www.dargelis.net/idea/sql-scripts/WORKING_DAYS.sql
Views: 988 Alex Dargelis
حمل الان افضل برنماج لرسم الدوال مع ادريس بندحان
 
03:13
http://download1967.mediafire.com/ww1wl4sanr0g/nf66th776ty6ibb/straceur_install.exe دالة if دالة vlookup دالة التفقيط دالة sumif دالة if المركبة دالة دالة round دالة index دالة الصحيح دالة search دالة and دالة countif دالة count دالة choose شرح دالة countifs شرح دالة count دالة dcount دالة datedif دالة edate دالة find hgm gunmetal pipe hgm gunmetal pipe raider 150 hgm gunmetal hgm gunmetal mio دالة hlookup شرح دالة vlookup دالة indirect دالة if error hgm jayy grizz دالة look up دالة vlookup 2010 دالة match شرح دالة match شرح دالة max دالة offset دالة or شرح دالة offset دالة pmt دالة sln دالة sum دالة small شرح دالة sumifs شرح دالة sumproduct شرح دالة subtotal دالة today استخدام دالة vlookup hgm xrmدالة خطية دالة تربيعية دالة التوزيع التراكمي دالة الجزء الصحيح دالة زيتا دالة زوجية وفردية دالة الكثافة الاحتمالية دالة الانتاج دالة average دالة abs دالة and في excel دالة and if دالة accrint دالة and و or دالة averageifs دالة arctan دالة array دالة between دالة basename دالة bessel دالة binomdist دالة b_only دالة base64 decode دالة bijective دالة base64 الدالة bac شرح دالة between دالة counta دالة ceiling دالة concatenate دالة countif في access دالة countif باكثر من شرط دالة countif في excel دالة convert دالة date دالة dsum دالة dmax دالة datevalue دالة day دالة dlast دالة dlookup دالة datedif لا تعمل دالة e دالة exp دالة explode دالة excel دالة exact دالة echo دالة eval دالة else if دالة extract دالة floor دالة file_get_contents دالة foreach دالة for php دالة fgets دالة file_exists دالة fv دالة forecast دالة frequency دالة getch dallah group dallah group of companies saudi arabia dallah general services co dallah gym dallah group qatar dallah group jeddah dallah group saudi dallah general services dallah group jordan دالة header دالة htmlspecialchars دالة hour دالة hash دالة hyperlink دالة htmlentities دالة header php شرح دالة hlookup شرح دالة header دالة int دالة if بشرطين دالة if متعددة الشروط دالة iif دالة if الشرطية المركبة وكالة تسنيم h&m jobs دالة array_key_exists دالة lookup دالة ln دالة len دالة left دالة log دالة like دالة linest دالة large دالة loop دالة list دالة min دالة mid دالة median دالة mail دالة month دالة max دالة mod دالة mysql_real_escape_string دالة main دالة nz دالة networkdays دالة nb دالة nb.si دالة nvl دالة now دالة npv دالة not دالة no to txt دالة nper dallah online driving test dalan olive dallah office jeddah dallah oracle الدالة oui دالة if or شرح دالة or دالة product دالة ppmt دالة preg_match دالة preg_replace دالة php دالة pv دالة power دالة poisson دالة pow دالة queue دالة query دالة mysql_query دالة magic_quotes دالة rank دالة row دالة roundup دالة rept دالة right دالة replace دالة recherchev دالة rand دالة return دالة subtotal دالة sin دالة switch في لغة c++ دالة sumproduct دالة substitute دالة sec دالة time دالة text دالة trim دالة trunc دالة topten دالة transpose دالة tan دالة trend دالة tostring hgm usb microphone hgm usace hgm urban dictionary وكالة عمون وكالة عجلون دالة vlookup بشرطين دالة vlookup لا تعمل دالة vlookup بالصور دالة vlookup مع match دالة val دالة value دالة vlook دالة vlookup بالفرنسية دالة weekday دالة while دالة workday دالة wget الدالة workday الدالة while الدالة wiki شرح دالة weekday شرح دالة while دالة do while دالة xor دالة xirr الدالة x الدالة x مربع الدالة x مكعب دالة sin x دالة صحيح x دالة e^x دالة cos x شرح دالة xirr دالة year دالة yearfrac دالة y dalah yangon saleh yemen dallah yangon dallah yamin dallah yanbu دالة if yes دالة zeta dallah zawya dalah zagora dalah zagora 2015 dallah zagora dalah zagora 2014 dallah zagora 2014 dallah zagora 2015
Ms-Sql funções SUM, AVG, MAX e MIN - Aula 1
 
08:18
Como utilizar as funções SUM, AVG, MAX e MIN do Ms-Sql.
Views: 192 Marcio Cezar
00096 - How To Use The DATE Function To Add Months To A Date Using Microsoft Excel
 
03:57
How To Use The DATE Function To Add Months To A Date Using Microsoft Excel Tutorials Microsoft Excel Tutorials, Basic Tutorials of Excel, Microsoft Office Tutorials, Formulas in Excel, How to Use Formulas in Microsoft Excel, Formatting Cells in Excel, Simple Formulas in Excel
Primavera P6 Tutorial : Chapter - 2.8 : Calendars
 
05:49
The calendars define the number of available work hours in each calendar day. You can then create and assign calendars to each resource and each activity. The Primavera module uses your calendar for scheduling and tracking activities, and also leveling resources across your organization. You can link resource and project calendars to global calendars. In this Chapter, let us learn how to add calendars and how to modify them For Personalized detail learning, write to [email protected] If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. *********************************************** ★ My Online Tutorials ► https://www.dptutorials.com LEARNING RESOURCES I Recommend: https://www.dptutorials.com/resources Subscribe for more Awesome Tutorials: goo.gl/NyAtg2 Support the Channel via shopping: http://ift.tt/2jH38PR Tools that I use for Vlogging: • Laptop: https://amzn.to/2E5U3MO • Canon 200D Camera: https://amzn.to/2HglDYA • Benro Tripod: https://amzn.to/2ExRvYj • Blue yeti microphone: https://amzn.to/2VwZyPn • Collar Microphone: https://amzn.to/2VyOdcM • Bluedio Headset: https://amzn.to/2W3xUZX • Screen recorder: https://techsmith.pxf.io/2BMjA • Boom Arm Stand: https://amzn.to/2VCQNi7 • Zoom H1 Audio Recorder: https://amzn.to/2VDumsT • Harison Softbox Studio Lights: https://amzn.to/2LY7x3u • Chroma Key Green Screen: https://amzn.to/2ExTr31 • Background Support Stand: https://amzn.to/2McqnEv • Acoustic Foam Background: https://amzn.to/2EoQ1zj • USB RGB LED Strip: https://amzn.to/2VItKm4 • Wireless Mouse: https://amzn.to/2E23cpN 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! *********************************************** You Can Connect with Me at YouTube: www.youtube.com/c/dptutorials G+: http://ift.tt/2kAOpa6 Twitter: https://twitter.com/dptutorials15 Facebook: http://ift.tt/2kfRnDi BlogSpot: http://ift.tt/2kB14dh Follow: www.dptutorials.com www.askplanner.blogspot.com Tags: - P6: primavera p6 training online, primavera p6, primavera p6 training, primavera p6 tutorial, oracle primavera, primavera p6 download, primavera 6, oracle primavera p6, primavera p6 free download, primavera project management, primavera project planner, primavera download, primavera online, primavera training, primavera software free download, youtube primavera, primavera tutorial, is primavera online easy, p6 online, primavera p6 complete video tutorial free download, critical path, oracle primavera, primavera p6, primavera, primavera software, construction project management software, project management software, project management books, microsoft project, project management courses, project management certification, online project management, project management tools, free project management software, project management training, best project management software, pmp certification, free project management tools, project management apps, microsoft project management, project management professional certification, google project management, ms project, agile project management, basecamp project management, project portfolio management, project management, project management system, scrum project management, open source project management, project management template, construction project management, project plan, project management professional, free project management, it project manager, project manager jobs, project management excel, project management consultant, pmi, project management plan, certified associate in project management, pmp, project management examples, what is project management, project management skills, engineering project manager, project risk management, project management steps, project management methodologies, project management process, marketing project manager, p6, primavera online, project management life cycle, project manager resume, project management phases, project management definition, project manager interview questions, project integration management, project manager responsibilities, project scope management, prima vera, project manager salary, oracle, oracle merge, explain plan in oracle, oracle group by, oracle case, with clause in oracle, oracle date format, oracle trunc, oracle replace, materialized view in oracle, oracle timestamp, oracle oci, oracle wiki
Views: 2002 dptutorials
Truncate statement in SQL Server - Part 19 Tamil
 
10:56
Subscribe to IT PORT : https://www.youtube.com/c/itport28 SQL Server Tutorial in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64enJDwWVvN3KduuZRlUrb3 SQL Server Concepts in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ67kdNIByJKAGBIBhor_h4Hs SQL Server Analytic Functions in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ65XIU5azEUgLVrBKEl-jWMV SQL Server Tutorial : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66AYrzPtxt2SeeR4UABcBcO SQL Server Concepts : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66zRe8-nDDy-YHY2o0rmbn4 SQL Server Analytic Functions : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64hTsEdhLsVBquE1vERWngX TRUNCATE statement is used to Remove all rows from a table or specified partitions of a table, without logging the individual row deletions. TRUNCATE TABLE is similar to the DELETE statement with no WHERE clause; however, TRUNCATE TABLE is faster and uses fewer system and transaction log resources.
Views: 297 IT Port
How to Change the calendar in Primavera P6 || Primavera || dptutorials
 
01:16
Learn How to Change the calendar in Primavera P6 in the middle of the scheduling or after completing the schedule in a simple way. For Personalized detail learning, write to [email protected] If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. *********************************************** ★ My Online Tutorials ► https://www.dptutorials.com LEARNING RESOURCES I Recommend: https://www.dptutorials.com/resources Subscribe for more Awesome Tutorials: goo.gl/NyAtg2 Support the Channel via shopping: http://ift.tt/2jH38PR Tools that I use for Vlogging: • Laptop: https://amzn.to/2E5U3MO • Canon 200D Camera: https://amzn.to/2HglDYA • Benro Tripod: https://amzn.to/2ExRvYj • Blue yeti microphone: https://amzn.to/2VwZyPn • Collar Microphone: https://amzn.to/2VyOdcM • Bluedio Headset: https://amzn.to/2W3xUZX • Screen recorder: https://techsmith.pxf.io/2BMjA • Boom Arm Stand: https://amzn.to/2VCQNi7 • Zoom H1 Audio Recorder: https://amzn.to/2VDumsT • Harison Softbox Studio Lights: https://amzn.to/2LY7x3u • Chroma Key Green Screen: https://amzn.to/2ExTr31 • Background Support Stand: https://amzn.to/2McqnEv • Acoustic Foam Background: https://amzn.to/2EoQ1zj • USB RGB LED Strip: https://amzn.to/2VItKm4 • Wireless Mouse: https://amzn.to/2E23cpN 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! *********************************************** You Can Connect with Me at YouTube: www.youtube.com/c/dptutorials G+: http://ift.tt/2kAOpa6 Twitter: https://twitter.com/dptutorials15 Facebook: http://ift.tt/2kfRnDi BlogSpot: http://ift.tt/2kB14dh Follow: www.dptutorials.com www.askplanner.blogspot.com Tags: - P6: primavera p6 training online, primavera p6, primavera p6 training, primavera p6 tutorial, oracle primavera, primavera p6 download, primavera 6, oracle primavera p6, primavera p6 free download, primavera project management, primavera project planner, primavera download, primavera online, primavera training, primavera software free download, youtube primavera, primavera tutorial, is primavera online easy, p6 online, primavera p6 complete video tutorial free download, critical path, oracle primavera, primavera p6, primavera, primavera software, construction project management software, project management software, project management books, microsoft project, project management courses, project management certification, online project management, project management tools, free project management software, project management training, best project management software, pmp certification, free project management tools, project management apps, microsoft project management, project management professional certification, google project management, ms project, agile project management, basecamp project management, project portfolio management, project management, project management system, scrum project management, open source project management, project management template, construction project management, project plan, project management professional, free project management, it project manager, project manager jobs, project management excel, project management consultant, pmi, project management plan, certified associate in project management, pmp, project management examples, what is project management, project management skills, engineering project manager, project risk management, project management steps, project management methodologies, project management process, marketing project manager, p6, primavera online, project management life cycle, project manager resume, project management phases, project management definition, project manager interview questions, project integration management, project manager responsibilities, project scope management, prima vera, project manager salary, oracle, oracle merge, explain plan in oracle, oracle group by, oracle case, with clause in oracle, oracle date format, oracle trunc, oracle replace, materialized view in oracle, oracle timestamp, oracle oci, oracle wiki
Views: 530 dptutorials
SQL DUAL
 
07:23
Yazılışı: Select * From Dual;
Views: 336 SQL Pl/SQL
MSSQL - Example how to round number down and up
 
00:50
Simple example that shows how to round number down and up in MS SQL More info: http://howtodomssqlcsharpexcelaccess.blogspot.ca/2014/12/mssql-example-how-to-round-number-down.html
Views: 367 Vis Dotnet
How to Format Excel after exporting the data from Primavera P6 || dptutorials
 
02:31
After exporting the primavera P6 data into Excel, learn simple Formatting so as to make the excel sheet look simpler for further usage. For Personalized detail learning, write to [email protected] If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. *********************************************** ★ My Online Tutorials ► https://www.dptutorials.com LEARNING RESOURCES I Recommend: https://www.dptutorials.com/resources Subscribe for more Awesome Tutorials: goo.gl/NyAtg2 Support the Channel via shopping: http://ift.tt/2jH38PR Tools that I use for Vlogging: • Laptop: https://amzn.to/2E5U3MO • Canon 200D Camera: https://amzn.to/2HglDYA • Benro Tripod: https://amzn.to/2ExRvYj • Blue yeti microphone: https://amzn.to/2VwZyPn • Collar Microphone: https://amzn.to/2VyOdcM • Bluedio Headset: https://amzn.to/2W3xUZX • Screen recorder: https://techsmith.pxf.io/2BMjA • Boom Arm Stand: https://amzn.to/2VCQNi7 • Zoom H1 Audio Recorder: https://amzn.to/2VDumsT • Harison Softbox Studio Lights: https://amzn.to/2LY7x3u • Chroma Key Green Screen: https://amzn.to/2ExTr31 • Background Support Stand: https://amzn.to/2McqnEv • Acoustic Foam Background: https://amzn.to/2EoQ1zj • USB RGB LED Strip: https://amzn.to/2VItKm4 • Wireless Mouse: https://amzn.to/2E23cpN 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! *********************************************** You Can Connect with Me at YouTube: www.youtube.com/c/dptutorials G+: http://ift.tt/2kAOpa6 Twitter: https://twitter.com/dptutorials15 Facebook: http://ift.tt/2kfRnDi BlogSpot: http://ift.tt/2kB14dh Follow: www.dptutorials.com www.askplanner.blogspot.com Tags: - P6: primavera p6 training online, primavera p6, primavera p6 training, primavera p6 tutorial, oracle primavera, primavera p6 download, primavera 6, oracle primavera p6, primavera p6 free download, primavera project management, primavera project planner, primavera download, primavera online, primavera training, primavera software free download, youtube primavera, primavera tutorial, is primavera online easy, p6 online, primavera p6 complete video tutorial free download, critical path, oracle primavera, primavera p6, primavera, primavera software, construction project management software, project management software, project management books, microsoft project, project management courses, project management certification, online project management, project management tools, free project management software, project management training, best project management software, pmp certification, free project management tools, project management apps, microsoft project management, project management professional certification, google project management, ms project, agile project management, basecamp project management, project portfolio management, project management, project management system, scrum project management, open source project management, project management template, construction project management, project plan, project management professional, free project management, it project manager, project manager jobs, project management excel, project management consultant, pmi, project management plan, certified associate in project management, pmp, project management examples, what is project management, project management skills, engineering project manager, project risk management, project management steps, project management methodologies, project management process, marketing project manager, p6, primavera online, project management life cycle, project manager resume, project management phases, project management definition, project manager interview questions, project integration management, project manager responsibilities, project scope management, prima vera, project manager salary, oracle, oracle merge, explain plan in oracle, oracle group by, oracle case, with clause in oracle, oracle date format, oracle trunc, oracle replace, materialized view in oracle, oracle timestamp, oracle oci, oracle wiki
Views: 1966 dptutorials
Primavera P6 Tutorial : Chapter - 4.4.1 : Updating Project by "Auto Actuals" Method || dptutorials
 
01:55
Primavera P6 Tutorial : Chapter - 4.4.1 : Updating Project by "Auto Actuals" Method Learn How to apply actual dates, resource hours and expenses to your Primavera P6 schedule. Status your project automatically with the use of this auto compute actuals option. This function will automatically update actual dates, percent complete, remaining duration and remaining units based on the data date set by the user. For Personalized detail learning, write to [email protected] If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. *********************************************** ★ My Online Tutorials ► https://www.dptutorials.com LEARNING RESOURCES I Recommend: https://www.dptutorials.com/resources Subscribe for more Awesome Tutorials: goo.gl/NyAtg2 Support the Channel via shopping: http://ift.tt/2jH38PR Tools that I use for Vlogging: • Laptop: https://amzn.to/2E5U3MO • Canon 200D Camera: https://amzn.to/2HglDYA • Benro Tripod: https://amzn.to/2ExRvYj • Blue yeti microphone: https://amzn.to/2VwZyPn • Collar Microphone: https://amzn.to/2VyOdcM • Bluedio Headset: https://amzn.to/2W3xUZX • Screen recorder: https://techsmith.pxf.io/2BMjA • Boom Arm Stand: https://amzn.to/2VCQNi7 • Zoom H1 Audio Recorder: https://amzn.to/2VDumsT • Harison Softbox Studio Lights: https://amzn.to/2LY7x3u • Chroma Key Green Screen: https://amzn.to/2ExTr31 • Background Support Stand: https://amzn.to/2McqnEv • Acoustic Foam Background: https://amzn.to/2EoQ1zj • USB RGB LED Strip: https://amzn.to/2VItKm4 • Wireless Mouse: https://amzn.to/2E23cpN 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! *********************************************** You Can Connect with Me at YouTube: www.youtube.com/c/dptutorials G+: http://ift.tt/2kAOpa6 Twitter: https://twitter.com/dptutorials15 Facebook: http://ift.tt/2kfRnDi BlogSpot: http://ift.tt/2kB14dh Follow: www.dptutorials.com www.askplanner.blogspot.com Tags: - P6: primavera p6 training online, primavera p6, primavera p6 training, primavera p6 tutorial, oracle primavera, primavera p6 download, primavera 6, oracle primavera p6, primavera p6 free download, primavera project management, primavera project planner, primavera download, primavera online, primavera training, primavera software free download, youtube primavera, primavera tutorial, is primavera online easy, p6 online, primavera p6 complete video tutorial free download, critical path, oracle primavera, primavera p6, primavera, primavera software, construction project management software, project management software, project management books, microsoft project, project management courses, project management certification, online project management, project management tools, free project management software, project management training, best project management software, pmp certification, free project management tools, project management apps, microsoft project management, project management professional certification, google project management, ms project, agile project management, basecamp project management, project portfolio management, project management, project management system, scrum project management, open source project management, project management template, construction project management, project plan, project management professional, free project management, it project manager, project manager jobs, project management excel, project management consultant, pmi, project management plan, certified associate in project management, pmp, project management examples, what is project management, project management skills, engineering project manager, project risk management, project management steps, project management methodologies, project management process, marketing project manager, p6, primavera online, project management life cycle, project manager resume, project management phases, project management definition, project manager interview questions, project integration management, project manager responsibilities, project scope management, prima vera, project manager salary, oracle, oracle merge, explain plan in oracle, oracle group by, oracle case, with clause in oracle, oracle date format, oracle trunc, oracle replace, materialized view in oracle, oracle timestamp, oracle oci, oracle wiki primavera project planner p3
Views: 2544 dptutorials
How to use Drag and Drop function in Primavera P6 || Primavera Tricks
 
01:49
Let us see how to use the Drag and Drop function in Primavera P6 in this tutorial. Instead of Cutting and Pasting the bands, You can use the Drag and Drop function in primavera which saves lot of time. If you would like to move one Item from One branch of hierarchy to other, just Follow the mentioned steps Place your curser at the left corner of the band, Left click on the vertical band and Then release the mouse at the desired place where you would like to place the item For Personalized detail learning, write to [email protected] If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. *********************************************** ★ My Online Tutorials ► https://www.dptutorials.com LEARNING RESOURCES I Recommend: https://www.dptutorials.com/resources Subscribe for more Awesome Tutorials: goo.gl/NyAtg2 Support the Channel via shopping: http://ift.tt/2jH38PR Tools that I use for Vlogging: • Laptop: https://amzn.to/2E5U3MO • Canon 200D Camera: https://amzn.to/2HglDYA • Benro Tripod: https://amzn.to/2ExRvYj • Blue yeti microphone: https://amzn.to/2VwZyPn • Collar Microphone: https://amzn.to/2VyOdcM • Bluedio Headset: https://amzn.to/2W3xUZX • Screen recorder: https://techsmith.pxf.io/2BMjA • Boom Arm Stand: https://amzn.to/2VCQNi7 • Zoom H1 Audio Recorder: https://amzn.to/2VDumsT • Harison Softbox Studio Lights: https://amzn.to/2LY7x3u • Chroma Key Green Screen: https://amzn.to/2ExTr31 • Background Support Stand: https://amzn.to/2McqnEv • Acoustic Foam Background: https://amzn.to/2EoQ1zj • USB RGB LED Strip: https://amzn.to/2VItKm4 • Wireless Mouse: https://amzn.to/2E23cpN 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! *********************************************** You Can Connect with Me at YouTube: www.youtube.com/c/dptutorials G+: http://ift.tt/2kAOpa6 Twitter: https://twitter.com/dptutorials15 Facebook: http://ift.tt/2kfRnDi BlogSpot: http://ift.tt/2kB14dh Follow: www.dptutorials.com www.askplanner.blogspot.com Tags: - P6: primavera p6 training online, primavera p6, primavera p6 training, primavera p6 tutorial, oracle primavera, primavera p6 download, primavera 6, oracle primavera p6, primavera p6 free download, primavera project management, primavera project planner, primavera download, primavera online, primavera training, primavera software free download, youtube primavera, primavera tutorial, is primavera online easy, p6 online, primavera p6 complete video tutorial free download, critical path, oracle primavera, primavera p6, primavera, primavera software, construction project management software, project management software, project management books, microsoft project, project management courses, project management certification, online project management, project management tools, free project management software, project management training, best project management software, pmp certification, free project management tools, project management apps, microsoft project management, project management professional certification, google project management, ms project, agile project management, basecamp project management, project portfolio management, project management, project management system, scrum project management, open source project management, project management template, construction project management, project plan, project management professional, free project management, it project manager, project manager jobs, project management excel, project management consultant, pmi, project management plan, certified associate in project management, pmp, project management examples, what is project management, project management skills, engineering project manager, project risk management, project management steps, project management methodologies, project management process, marketing project manager, p6, primavera online, project management life cycle, project manager resume, project management phases, project management definition, project manager interview questions, project integration management, project manager responsibilities, project scope management, prima vera, project manager salary, oracle, oracle merge, explain plan in oracle, oracle group by, oracle case, with clause in oracle, oracle date format, oracle trunc, oracle replace, materialized view in oracle, oracle timestamp, oracle oci, oracle wiki
Views: 929 dptutorials
Primavera P6 Tutorials : Chapter - 6.1 : Exporting Data into XER & XML formats
 
04:15
In this Primavera P6 Tutorials, Let us see How to Export a Primavera Schedule into XER and XML formats that can be later used. XML format can be used by other Project Management Modules as well For Personalized detail learning, write to [email protected] If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. *********************************************** ★ My Online Tutorials ► https://www.dptutorials.com LEARNING RESOURCES I Recommend: https://www.dptutorials.com/resources Subscribe for more Awesome Tutorials: goo.gl/NyAtg2 Support the Channel via shopping: http://ift.tt/2jH38PR Tools that I use for Vlogging: • Laptop: https://amzn.to/2E5U3MO • Canon 200D Camera: https://amzn.to/2HglDYA • Benro Tripod: https://amzn.to/2ExRvYj • Blue yeti microphone: https://amzn.to/2VwZyPn • Collar Microphone: https://amzn.to/2VyOdcM • Bluedio Headset: https://amzn.to/2W3xUZX • Screen recorder: https://techsmith.pxf.io/2BMjA • Boom Arm Stand: https://amzn.to/2VCQNi7 • Zoom H1 Audio Recorder: https://amzn.to/2VDumsT • Harison Softbox Studio Lights: https://amzn.to/2LY7x3u • Chroma Key Green Screen: https://amzn.to/2ExTr31 • Background Support Stand: https://amzn.to/2McqnEv • Acoustic Foam Background: https://amzn.to/2EoQ1zj • USB RGB LED Strip: https://amzn.to/2VItKm4 • Wireless Mouse: https://amzn.to/2E23cpN 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! *********************************************** You Can Connect with Me at YouTube: www.youtube.com/c/dptutorials G+: http://ift.tt/2kAOpa6 Twitter: https://twitter.com/dptutorials15 Facebook: http://ift.tt/2kfRnDi BlogSpot: http://ift.tt/2kB14dh Follow: www.dptutorials.com www.askplanner.blogspot.com Tags: - P6: primavera p6 training online, primavera p6, primavera p6 training, primavera p6 tutorial, oracle primavera, primavera p6 download, primavera 6, oracle primavera p6, primavera p6 free download, primavera project management, primavera project planner, primavera download, primavera online, primavera training, primavera software free download, youtube primavera, primavera tutorial, is primavera online easy, p6 online, primavera p6 complete video tutorial free download, critical path, oracle primavera, primavera p6, primavera, primavera software, construction project management software, project management software, project management books, microsoft project, project management courses, project management certification, online project management, project management tools, free project management software, project management training, best project management software, pmp certification, free project management tools, project management apps, microsoft project management, project management professional certification, google project management, ms project, agile project management, basecamp project management, project portfolio management, project management, project management system, scrum project management, open source project management, project management template, construction project management, project plan, project management professional, free project management, it project manager, project manager jobs, project management excel, project management consultant, pmi, project management plan, certified associate in project management, pmp, project management examples, what is project management, project management skills, engineering project manager, project risk management, project management steps, project management methodologies, project management process, marketing project manager, p6, primavera online, project management life cycle, project manager resume, project management phases, project management definition, project manager interview questions, project integration management, project manager responsibilities, project scope management, prima vera, project manager salary, oracle, oracle merge, explain plan in oracle, oracle group by, oracle case, with clause in oracle, oracle date format, oracle trunc, oracle replace, materialized view in oracle, oracle timestamp, oracle oci, oracle wiki
Views: 2610 dptutorials
Curso MySQL #07 - Manipulando Linhas (UPDATE, DELETE e TRUNCATE)
 
27:01
Nessa aula, vamos aprender ... Nós do CursoemVideo sempre recomendamos assistir a aula completa, mas se quiser aprender diretamente uma parte específica, clique nos marcadores de tempo a seguir: 0:19 - Qual é o assunto da aula? Aula do Curso de Banco de Dados com MySQL criado pelo professor Gustavo Guanabara para o portal CursoemVideo.com. Curso em Vídeo Site: http://www.cursoemvideo.com YouTube: http://www.youtube.com/cursoemvideo Facebook: http://www.facebook.com/cursosemvideo Twitter: http://twitter.com/cursosemvideo Google+: http://plus.google.com/112666558837414979080 Patrocínio HOSTNET: http://www.hostnet.com.br Trilha sonora da abertura: African Drums (Sting) de Twin Musicom está licenciada sob uma licença Creative Commons Attribution (https://creativecommons.org/licenses/by/4.0/) Artista: http://www.twinmusicom.org/
Views: 158444 Curso em Vídeo
Leveraging Oracle's Clinical Development (CDA) Analytics
 
57:02
Learn how Oracle's Clinical Development Analytics (CDA) can be leveraged to answer specific critical business questions by bringing together information from both data management and clinical operations. -- Oracle's Clinical Development Analytics (CDA) is a comprehensive analytics solution that provides life sciences sponsors and CROs operational insight into their clinical studies, projects, and programs. Join BioPharm Systems' Michael Grossman, vice president of clinical data warehousing and analytics, for this one-hour session on CDA to learn how it can be leveraged to answer specific critical business questions by bringing together information from both data management and clinical operations. You will learn how CDA can: -Provide insight where and when you need it -Increase productivity and reduce costs -Improve clinical operations and data management effectiveness To view this webinar in its entirety, please visit: http://www.biopharm.com or https://cc.readytalk.com/r/o00dmtuqp4tl. Twitter: http://www.twitter.com/BioPharmSystems Facebook: http://www.facebook.com/BioPharmSystems LinkedIn: http://www.linkedin.com/companies/biopharm-systems-inc
Views: 415 BioPharmSystems
Primavera in Excel || How To Export Primavera Schedule TO MS Excel || dptutorials
 
02:18
Learn how to export P6 schedules into excel with the same color formatting. For Personalized detail learning, write to [email protected] If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. *********************************************** ★ My Online Tutorials ► https://www.dptutorials.com LEARNING RESOURCES I Recommend: https://www.dptutorials.com/resources Subscribe for more Awesome Tutorials: goo.gl/NyAtg2 Support the Channel via shopping: http://ift.tt/2jH38PR Tools that I use for Vlogging: • Laptop: https://amzn.to/2E5U3MO • Canon 200D Camera: https://amzn.to/2HglDYA • Benro Tripod: https://amzn.to/2ExRvYj • Blue yeti microphone: https://amzn.to/2VwZyPn • Collar Microphone: https://amzn.to/2VyOdcM • Bluedio Headset: https://amzn.to/2W3xUZX • Screen recorder: https://techsmith.pxf.io/2BMjA • Boom Arm Stand: https://amzn.to/2VCQNi7 • Zoom H1 Audio Recorder: https://amzn.to/2VDumsT • Harison Softbox Studio Lights: https://amzn.to/2LY7x3u • Chroma Key Green Screen: https://amzn.to/2ExTr31 • Background Support Stand: https://amzn.to/2McqnEv • Acoustic Foam Background: https://amzn.to/2EoQ1zj • USB RGB LED Strip: https://amzn.to/2VItKm4 • Wireless Mouse: https://amzn.to/2E23cpN 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! *********************************************** You Can Connect with Me at YouTube: www.youtube.com/c/dptutorials G+: http://ift.tt/2kAOpa6 Twitter: https://twitter.com/dptutorials15 Facebook: http://ift.tt/2kfRnDi BlogSpot: http://ift.tt/2kB14dh Follow: www.dptutorials.com www.askplanner.blogspot.com Tags: - P6: primavera p6 training online, primavera p6, primavera p6 training, primavera p6 tutorial, oracle primavera, primavera p6 download, primavera 6, oracle primavera p6, primavera p6 free download, primavera project management, primavera project planner, primavera download, primavera online, primavera training, primavera software free download, youtube primavera, primavera tutorial, is primavera online easy, p6 online, primavera p6 complete video tutorial free download, critical path, oracle primavera, primavera p6, primavera, primavera software, construction project management software, project management software, project management books, microsoft project, project management courses, project management certification, online project management, project management tools, free project management software, project management training, best project management software, pmp certification, free project management tools, project management apps, microsoft project management, project management professional certification, google project management, ms project, agile project management, basecamp project management, project portfolio management, project management, project management system, scrum project management, open source project management, project management template, construction project management, project plan, project management professional, free project management, it project manager, project manager jobs, project management excel, project management consultant, pmi, project management plan, certified associate in project management, pmp, project management examples, what is project management, project management skills, engineering project manager, project risk management, project management steps, project management methodologies, project management process, marketing project manager, p6, primavera online, project management life cycle, project manager resume, project management phases, project management definition, project manager interview questions, project integration management, project manager responsibilities, project scope management, prima vera, project manager salary, oracle, oracle merge, explain plan in oracle, oracle group by, oracle case, with clause in oracle, oracle date format, oracle trunc, oracle replace, materialized view in oracle, oracle timestamp, oracle oci, oracle wiki
Views: 321 dptutorials
Oracle 9i Complete English Course Part 1  Class 10
 
02:01
Oracle 9i Complete English Course Part 1 Class 10 Watch here ► https://youtu.be/qp4iTRVK8CE Author - Gavin Powell Total Time - 8 Hours Welcome,.Prerequisites for this Course About this Course Technet Database Administration Manuals Database Administration Oracle Database Administration? pt. 1 Oracle Database Administration? pt. 2 The Basic Architecture of Oracle Oracle Database Administration Tools What are the Tools? SQL*Plus SQL*Plus Worksheet iSQL*Plus All the Other Oracle Tools Database Configuration Assistant pt. 1 Database Configuration Assistant pt. 2 Oracle Enterprise Manager Console pt. 1 Oracle Enterprise Manager Console pt. 2 The Management Server and the Agent Net Configuration Assistant and Net Manager Oracle Enterprise Manager Console pt. 3 Oracle Enterprise Manager Console pt. 4 The Architecture of Oracle Oracle Database Architecture Memory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning Installing Oracle and Creating a Database The Oracle Installer pt. 1 The Oracle Installer pt. 2 The Oracle Installer pt. 3 Configuration Parameter Files pt. 1 Configuration Parameter Files pt. 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics pt. 1 Windows Specifics pt. 2 Creating a Database with a Script pt. 1 Creating a Database with a Script pt. 2 Starting Up and Shutting Down a Database Connecting to a Database STARTUP Command pt. 1 STARTUP Command pt. 2 SHUTDOWN Command pt. 1 SHUTDOWN Command pt. 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration Parameters What is the Parameter File? Looking at Parameters The Parameters and What They Do pt. 1 The Parameters and What They Do pt. 2 The Parameters and What They Do pt. 3 DDL and the Physical Database DDL and the Physical Database? The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives pt. 1 Logfiles and Archives pt. 2 The ALTER SYSTEM Command pt. 1 The ALTER SYSTEM Command pt. 2 Automated Undo/Manual Rollback pt. 1 Automated Undo/Manual Rollback pt. 2 Metadata Views DDL and the Logical Database What is the Logical Database? Tablespace Management pt. 1 Tablespace Management pt. 2 Tablespace Management pt. 3 Metadata Views Expanding Database Objects Tables pt. 1 Tables pt. 2 Tables pt. 3 Indexes pt. 1 Indexes pt. 2 Clusters Index Organized Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views pt. 1 Metadata Views pt. 2 Expanding Security for Database Administration Types of Users Grants and Revokes Create and Alter User Syntax Administration Users Database Auditing Scheduling The DBMS_JOB Package Job Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix Utilities Export Import SQL*Loader ORAPWD and ORADIM Built-In Packages Supplied Packages Scripting for Automation Some Example Scripts __________________YouTube Channel__________________ https://www.youtube.com/c/ABDULAZIZMEDIASTUFF ___________________________________________________ Subscribe and hit the Bell icon to get notification new video ► Facebook : https://www.facebook.com/abdulaziz.bhatti.56 ► Facebook : Page: https://www.facebook.com/ABDUL-AZIZ-MEDIA-STUFF-1627321537315673/ ► Twitter : https://twitter.com/azizbhatti2k7 ► Google+ : https://plus.google.com/u/0/105139444167097149529 ► Blogger : https://abdulazizbhattientertainment.blogspot.com/ So, Please Friends..... Do this | LIKE | | SHARE | | SUBSCRIBE | Don't forget to Subscribe Our YouTube Channel Thanks for Visit...
Oracle 9i Complete English Course Part 1  Class 60
 
06:13
Oracle 9i Complete English Course Part 1 Class 60 Watch here ► https://youtu.be/ZXgnhJOSJ2A Author - Gavin Powell Total Time - 8 Hours Welcome,.Prerequisites for this Course About this Course Technet Database Administration Manuals Database Administration Oracle Database Administration? pt. 1 Oracle Database Administration? pt. 2 The Basic Architecture of Oracle Oracle Database Administration Tools What are the Tools? SQL*Plus SQL*Plus Worksheet iSQL*Plus All the Other Oracle Tools Database Configuration Assistant pt. 1 Database Configuration Assistant pt. 2 Oracle Enterprise Manager Console pt. 1 Oracle Enterprise Manager Console pt. 2 The Management Server and the Agent Net Configuration Assistant and Net Manager Oracle Enterprise Manager Console pt. 3 Oracle Enterprise Manager Console pt. 4 The Architecture of Oracle Oracle Database Architecture Memory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning Installing Oracle and Creating a Database The Oracle Installer pt. 1 The Oracle Installer pt. 2 The Oracle Installer pt. 3 Configuration Parameter Files pt. 1 Configuration Parameter Files pt. 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics pt. 1 Windows Specifics pt. 2 Creating a Database with a Script pt. 1 Creating a Database with a Script pt. 2 Starting Up and Shutting Down a Database Connecting to a Database STARTUP Command pt. 1 STARTUP Command pt. 2 SHUTDOWN Command pt. 1 SHUTDOWN Command pt. 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration Parameters What is the Parameter File? Looking at Parameters The Parameters and What They Do pt. 1 The Parameters and What They Do pt. 2 The Parameters and What They Do pt. 3 DDL and the Physical Database DDL and the Physical Database? The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives pt. 1 Logfiles and Archives pt. 2 The ALTER SYSTEM Command pt. 1 The ALTER SYSTEM Command pt. 2 Automated Undo/Manual Rollback pt. 1 Automated Undo/Manual Rollback pt. 2 Metadata Views DDL and the Logical Database What is the Logical Database? Tablespace Management pt. 1 Tablespace Management pt. 2 Tablespace Management pt. 3 Metadata Views Expanding Database Objects Tables pt. 1 Tables pt. 2 Tables pt. 3 Indexes pt. 1 Indexes pt. 2 Clusters Index Organized Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views pt. 1 Metadata Views pt. 2 Expanding Security for Database Administration Types of Users Grants and Revokes Create and Alter User Syntax Administration Users Database Auditing Scheduling The DBMS_JOB Package Job Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix Utilities Export Import SQL*Loader ORAPWD and ORADIM Built-In Packages Supplied Packages Scripting for Automation Some Example Scripts __________________YouTube Channel__________________ https://www.youtube.com/c/ABDULAZIZMEDIASTUFF ___________________________________________________ Subscribe and hit the Bell icon to get notification new video ► Facebook : https://www.facebook.com/abdulaziz.bhatti.56 ► Facebook : Page: https://www.facebook.com/ABDUL-AZIZ-MEDIA-STUFF-1627321537315673/ ► Twitter : https://twitter.com/azizbhatti2k7 ► Google+ : https://plus.google.com/u/0/105139444167097149529 ► Blogger : https://abdulazizbhattientertainment.blogspot.com/ So, Please Friends..... Do this | LIKE | | SHARE | | SUBSCRIBE | Don't forget to Subscribe Our YouTube Channel Thanks for Visit...