Hero image

Class is in session

Native SQL For Developers

71 Weeks

·

Cohort-based Course

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

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.

This course includes

Interactive live sessions

Lifetime access to course materials

In-depth lessons

Direct access to instructor

Projects to apply learnings

Guided feedback & reflection

Private community of peers

Course certificate upon completion

Maven Satisfaction Guarantee

This course is backed by Maven’s guarantee. You can receive a full refund within 14 days after the course ends, provided you meet the completion criteria in our refund policy.

Course syllabus

Expand all modules

  • Week 1

    Jan 18—Jan 21

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 2

    Jan 22—Jan 28

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 3

    Jan 29—Feb 4

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 4

    Feb 5—Feb 11

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 5

    Feb 12—Feb 18

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 6

    Feb 19—Feb 25

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 7

    Feb 26—Mar 3

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 8

    Mar 4—Mar 10

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 9

    Mar 11—Mar 17

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 10

    Mar 18—Mar 24

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 11

    Mar 25—Mar 31

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 12

    Apr 1—Apr 7

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 13

    Apr 8—Apr 14

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 14

    Apr 15—Apr 21

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 15

    Apr 22—Apr 28

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 16

    Apr 29—May 5

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 17

    May 6—May 12

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 18

    May 13—May 19

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 19

    May 20—May 26

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 20

    May 27—Jun 2

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 21

    Jun 3—Jun 9

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 22

    Jun 10—Jun 16

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 23

    Jun 17—Jun 23

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 24

    Jun 24—Jun 30

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 25

    Jul 1—Jul 7

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 26

    Jul 8—Jul 14

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 27

    Jul 15—Jul 21

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 28

    Jul 22—Jul 28

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 29

    Jul 29—Aug 4

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 30

    Aug 5—Aug 11

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 31

    Aug 12—Aug 18

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 32

    Aug 19—Aug 25

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 33

    Aug 26—Sep 1

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 34

    Sep 2—Sep 8

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 35

    Sep 9—Sep 15

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 36

    Sep 16—Sep 22

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 37

    Sep 23—Sep 29

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 38

    Sep 30—Oct 6

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 39

    Oct 7—Oct 13

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 40

    Oct 14—Oct 20

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 41

    Oct 21—Oct 27

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 42

    Oct 28—Nov 3

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 43

    Nov 4—Nov 10

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 44

    Nov 11—Nov 17

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 45

    Nov 18—Nov 24

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 46

    Nov 25—Dec 1

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 47

    Dec 2—Dec 8

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 48

    Dec 9—Dec 15

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 49

    Dec 16—Dec 22

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 50

    Dec 23—Dec 29

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 51

    Dec 30—Jan 5

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 52

    Jan 6—Jan 12

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 53

    Jan 13—Jan 19

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 54

    Jan 20—Jan 26

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 55

    Jan 27—Feb 2

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 56

    Feb 3—Feb 9

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 57

    Feb 10—Feb 16

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 58

    Feb 17—Feb 23

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 59

    Feb 24—Mar 2

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 60

    Mar 3—Mar 9

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 61

    Mar 10—Mar 16

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 62

    Mar 17—Mar 23

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 63

    Mar 24—Mar 30

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 64

    Mar 31—Apr 6

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 65

    Apr 7—Apr 13

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 66

    Apr 14—Apr 20

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 67

    Apr 21—Apr 27

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 68

    Apr 28—May 4

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 69

    May 5—May 11

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 70

    May 12—May 18

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Week 71

    May 19—May 24

    Week dates are set to instructor's time zone

    Nothing scheduled for this week.

  • Bonus

    Modules

    • First SQL queries

    • Model tables and complex SQL queries

    • Functions, procedures and data processing

    • Optimize SQL queries

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

  • January 23rd to February 15th

    Tuesdays and Thursdays from 1 PM to 3 PM

    The course duration is 4 weeks, from January 23rd to February 15th. 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
Be the first to know about upcoming cohorts

Native SQL For Developers

|

Bulk purchases

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
Be the first to know about upcoming cohorts

Native SQL For Developers

|

Bulk purchases

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?

Powered by Maven