Hero image

Native SQL For Developers

New
·

3.5 Weeks

·

Cohort-based Course

Develop faster applications by using native SQL instead of object-relational mapping when working with databases.

Hosted by

Lucian Lazar

Software Developer | Oracle Certified Professional | Academic and Online Teacher

Course overview

Native SQL For Developers

Have you ever used an ORM like Hibernate or Sequelize or SQLAlchemy and ended up with a slow database?


You will discover in this live course how using native SQL instead of object-relational mapping will help you access data faster and create faster applications.

Who is this course for

01

Back-end developers that use Java or Python and build applications with databases.

02

Front-end developers that use JavaScript or React and need to choose a database for a project.

03

Any developer that needs to use Oracle or another database and wants to be efficent.

What you will learn

01

Setup database

You will setup your Oracle database, connect to it and use an ORM to create tables and retrieve data. Then we will pass on to the more efficient way: using native SQL to build your first SQL queries and integrate them in your code: you will SELECT some fields FROM a table, maybe JOIN it with another table and keep the data WHERE a condition is met.

02

Model tables

We will discuss how an ORM creates tables by mapping them to classes. And then you will design the tables better considering how the relational databases work, using foreign keys and making trade-offs between performance, storage and flexibility. After that, you will create our tables and add data to them to prepare for running more queries.

03

Write SQL queries

You wrote your first queries to retrieve data from different tables and apply conditions on it. Next, you will transform data using functions. You will GROUP your data, sometimes HAVING to filter the aggregations in order to calculate subtotals. And you will analyze our data using window functions to return top values and ranks.

04

Tune SQL queries

You already know how to query the database, retrieve the data you want and perform analytics on it. But some of your queries are slow. You will learn how to tune your queries, use indexes and optimize the performance of your database to achive your goal: access data as fast as possible.

Do I really need this?

Why do I need to model tables myself? My ORM does this automatically.

Because you will design the tables better, using features not handled by an ORM. You will structure your data more efficiently and then you will access it faster.

Why should I learn to write SQL queries? My ORM can generate them.

The ORM generates suboptimal queries. By using native SQL you will build fast and efficient queries using the exact functions needed to acces your data.

Why do I need to learn to tune queries? The DBA can take care of this.

Why would you write slow queries and have a DBA tune them later, instead of writing them fast from the first place? You will learn the most efficient techniques to tune your SQL queries and access your data as fast as possible.

Why should I learn SQL altogether? It's an old language.

SQL is a timeless and universal language. It has been used for 50 years and it will probably be used for the next 50 years. Also, it works with all programming languages so if you learn it now, you can use it later for future projects.

When we will do this

8 live sessions, 16 hours of course
  • October 18th to November 10th

    Tuesdays and Thursdays from 1 PM to 3 PM

    The course duration is 4 weeks, from October 18th to November 10th. There will be 2 live sessions each week, on Tuesdays and Thursdays from 1 PM to 3 PM ET.

  • Group project and individual projects

    Using Java, JavaScript or Python

    In the first session of the week on Tuesdays we will work on a group project that uses Java code and Oracle database. In the second session of the week on Thursdays you will build your own projects using Java, JavaScript, Python or another language you prefer.

A pattern of wavy dots
Join an upcoming cohort

Native SQL For Developers

Fall 2022

$800 USD

Dates

Oct 18 - Nov 10, 2022

Payment Deadline

Oct 17, 2022

Meet your instructor

Lucian Lazar

Lucian Lazar

Software Developer | Oracle Certified Professional | University, Pluralsight and Maven Teacher

I have over 15 years experience in software development and teaching, so I will share with you both the basic academic concepts and the practical experience from industry. My current position is Database Developer at Optymyze maintaining a top sales application. I am Teaching Assistant for a top university in Romania on courses of databases and programming. I also teach databases courses for Pluralsight and here at Maven. You can see more details on my website and on my Linkedin profile.


The idea of this course came to me after presentations and coaching sessions with fellow developers. I was amazed of how easy it was for me to show them that native SQL improves the performance of accessing data and how much they improved their skills in working with databases after the sessions. I held this course with colleagues and with developers from other companies. You can see from their testimonials how they reached the outcomes of the course, how they improved the quality of their code and the speed of their applications.

See what people are saying

        I really like this course since it gives a well-structured way to get quickly up-to-speed with native SQL. ORMs are problematic as applications become more complex since they can generate suboptimal SQL queries. I highly recommend this course for developers who work with complex applications in which the database is the bottleneck.
Dan Tofan

Dan Tofan

Senior Software Engineer
        This is really interesting! I like the flavour added here, the comparison to ORMs. You can count on high level frameworks, but understanding what’s actually happening behind the scenes always matters. More than you think! Worked with Lucian on several projects, he’s the perfect mentor for you, looking forward to seeing the outcomes!
Adrian Banu

Adrian Banu

VP of Product
        Lucian presents some very important sql and performance concepts that any backend developer should be aware of, in an interesting and captivating matter. Having these notions and improvements in mind can make our lives a lot easier when we develop a complex application.
Sabina Macarie

Sabina Macarie

Full Stack Developer
        Your content is very clear and to the point. Especially the performance tuning and optimization. I am very impressed by that.
Sneha Hiremath

Sneha Hiremath

Senior Implementation Analyst
        Feel free to learn from an expert. Lucian will teach you quite a few tricks about SQL in this course.
Maxim Rohit

Maxim Rohit

Data Scientist | Solution Architect
        Lucian will show you how to build SQL queries and how to tune them for optimum performance. All with a /+ hint/ of DBA techniques.
Stefan Popa

Stefan Popa

Performance DBA
A pattern of wavy dots
Join an upcoming cohort

Native SQL For Developers

Fall 2022

$800 USD

Dates

Oct 18 - Nov 10, 2022

Payment Deadline

Oct 17, 2022

Learning is better with cohorts

Learning is better with cohorts

Active learning, not passive watching

This course builds on live workshops and hands-on projects

Interactive and project-based

You’ll be interacting with other learners through breakout rooms and project teams

Learn with a cohort of peers

Join a community of like-minded people who want to learn and grow alongside you

Frequently Asked Questions

What software should I know and have installed?
How much time will I spend on the course?
Will there be a private community?
How much access to Lucian do I get?
What happens if I can’t make a live session?
Can this course be reimbursed by my employer?
Will I get a certificate of completion?
Can you adjust the time for different time zones?
What’s the refund policy?
What if I have more questions?

$800 USD

New
·

3.5 Weeks