Native SQL For Developers
4 Weeks
·Cohort-based Course
Develop faster applications by using native SQL instead of object-relational mapping when working with databases.
4 Weeks
·Cohort-based Course
Develop faster applications by using native SQL instead of object-relational mapping when working with databases.
Get notified about the next cohort
Hosted by
Lucian Lazar
Software Developer | Oracle Certified Professional | Academic and Online Teacher
Course overview
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.
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.
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.
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.
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 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.
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.
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.
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.
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.
Dan Tofan
Adrian Banu
Sabina Macarie
Sneha Hiremath
Maxim Rohit
Stefan Popa
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