Oracle SQL - Basics

SKU N/A Category:
Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn
Session Start Date End Date Duration Place Price
June 3.06.2019 5.06.2019 3 daysBucharest 850  699 
June 17.06.2019 19.06.2019 3 daysBucharest 850  699 
July 8.07.2019 10.07.20193 daysBucharest 850  699 

Description

  • Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.
  • Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.

Audience

  • Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.
  • Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.

Requirements

  • Basic computer skills and knowledge of set theory fundamentals
  • Understanding of first order logic
  • Understanding of search algorithms and complexity theory
  • Prior SQL programming experience is helpful but not required
  • Basic computer skills and knowledge of set theory fundamentals
  • Understanding of first order logic
  • Understanding of search algorithms and complexity theory
  • Prior SQL programming experience is helpful but not required

Objectives

  • Understand Relational Model
  • Understand Normal Forms
  • Learn SQL and how it’s used
  • Build and run SQL scripts
  • Perform basic database operations using MySQL
  • Write basic SQL scripts for MySQL
  • Understand Relational Model
  • Understand Normal Forms
  • Learn SQL and how it’s used
  • Build and run SQL scripts
  • Perform basic database operations using MySQL
  • Write basic SQL scripts for MySQL

Curriculum

  • DBMS
  • Relational Model
  • SQL basics
  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Data Query Language (DQL)
  • Best Practices
  • DBMS
  • Relational Model
  • SQL basics
  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Data Query Language (DQL)
  • Best Practices

Our

Online or On-site delivery

We created a personalized delivery strategy by offering blended learning

Interactive

Interactive online trainings and live webinars available.

Communities of practice

Find a bunch of people who are on the same page with you.

Efficient

A special learning environment can boost learning efficiency.

Engaging

Engaging platform with gamification for collaboration and friendly competition.

Accessible

Available anywhere and anytime, on your phone, computer or tablet.

Frequently Asked

Yes, of course. We offer training consultancy and we establish the most appropriate solution according to the specific needs and business objectives of your company. Contact us and we’ll find the best training solution for you.

Yes, we organise open courses which can be accessed by individuals. Whether you are looking for an IT or a Business training, you can find it at Brain Concert. Moreover, you’ll meet people from the same area of work as you and we can create communities of practice, where you can share professional tips and tricks and best practices.

We offer a variety of courses: in the IT area, there are Agile & Lean Courses, Software Development Courses, QA Courses, Software Administration Courses and Security Courses. We also offer Business Courses, focused on the development of soft skills. Define your objectives and choose the most appropriate training for you or your company.

You should know that we offer courses for everyone, but you have to choose according to some criteria. First, define your objectives, then, the level of the participants (basic, advanced). There are courses with some requirements attached because the participants of a training session must form a compact group in terms of their previous knowledge so that they and the trainers are on the same page.

The minimum number of participants for an in-house depends on the course type. Please contact us to establish these details.

Yes, you can choose an online or an offline training session. We use Knolyx, an e-learning platform to make the process of online training delivery as efficient as a face to face training session.

Shopping Basket