Oracle SQL Fundamentals 3-day Course, Manchester OR Online
Oracle SQL Fundamentals 3-day Course, Manchester OR Online
Time
Mon Sep 03 2018 at 11:00 am to Mon Sep 02 2024 at 04:00 pm (GMT+01:00)
Google Calendar
Outlook Calendar
iCal Calendar
Yahoo Calendar
82 King St, 82 King Street, Manchester, United Kingdom
Find Tickets
GBP 300
Find Tickets
Advertisement
About the eventOracle SQL Fundamentals 3-day Course, Manchester OR Online
3 days is enough to learn all about Oracle SQL, from the basics to stored procedures DDL and more
About this Event
<h4>Oracle Fundamentals SQL Course</h4>
SQL Course summary The Oracle SQL Fundamentals course is designed to give delegates practical experience in writing Oracle SQL statements. 3 Consecutive days. Max 4 delegates.After successfully completing this certification, delegates will be to create advanced queries including DML and DDL statements.The examinations are not included as a part of this course and will need to be purchased separately via Pearson Vue
Oracle SQL Course Desciption
Session 1: Relational database concept
Session 2: Using SQL developer
Session 3: Retrieving and filtering data with the select statement,using filter operations
Session 4: Expression Queries
Session 5: Aggregate functions, having
Session 6: Enhanced grouping features
Session 7: Joining tables
Session 8: Numeric Functions, String Functions
Session 9: Date Functions
Session 10: Date, time and timezone support
Session 11: Conversion and miscellaneous
Session 12: SQL Parameters
Session 13: SQL Stored procedures
Session 14: Managing tables
Session 15: Managing indexes and views
Session 16: Managing sequences and synonyms
Session 17: Retrieve data using subqueries
Session 18: Hierarchical queries
Session 19: Manage large data sets, Using Sub-queries, Temp tables
Session 20: Flashback technology
Session 21: Regular expression support
Session 22: Manage objects with the data dictionary
About The Host: At PCWorkshops, we offer instructor-led online courses in our Live Virtual Classroom. We cover Java programming, Python Coding, Database Development, SQL, Data Analytics and MS Project.More about us:training@pcworkshopslondon.co.ukOur classes are instructor led, in our Live Virtual ClassroomCourses well developed by registered, qualified instructors with a wealth of experience in software development and training.The maximum groups size that can access our Virtual Classroom, is 4.Every one gets personalised attention.Why learn with us at PCWorkshops:Excellent, up-to-date courses, following latest trends and technologies.Excellent trainers with professional experience.Award Winning Trainer21 Years In BusinessExcellent Client ReferencesPCWorkshops CertificateWeekdays, Evenings and WeekendsAt PCWorkshops, we love out job!We offer Training Courses in Software Packages:Java ProgrammingPython Programming, Python data analytics, Python Machine LearningDatabase design and Data NormalisationSQL CoursesData Analysis andMS Excel, data analyses with Excel. Excel VBAAccess Database Courses.MS Project TrainingMS Office TrainingOur Style:Relaxed, Practical, UsefulMethods of instruction:Classroom training with max class-size 4 peopleVirtual classrooms via online video links1-1 mentoringCustomised trainingCertification:Our PCWorkshops certificates are assessment based.Our Java course outlines are aligned with Oracle courses. We assist with exam prep for the prestigious, international Oracle Certified Associate qualification.Our clients are:Data analysts and all others who use large sets of dataSoftware companies, testing companies, companies employing software developersCoders and new coders who need Accredited Java qualificationCustomisation:We can tailor all our courses. Email to customise location, times, content.