Brezplačni e-vodič: Kako postati programer?
Poglej več
BESTSELLER: Web Development 1
Read more

SQL and databases 2 (ENGLISH LANGUAGE)

Expand your knowledge of the basics of SQL with more advanced queries and techniques. In this course, you’ll learn about SQL functions, complex SQL sentences, nested queries, indexes, and much more.

In addition, in this course, you’ll learn how to set up a database on a remote server and connect to it. Besides SQLite, you’ll also learn how to use a very popular database system called PostgreSQL and advanced tools like Beekeeper Studio and DBeaver.

7,5 hours
5 lectures
Amateur

Program

  • Lesson 1: SQL basics repeat, CASE sentence, HAVING clause
  • Lesson 2: Foreign key constraints, Advanced views and triggers
  • Lesson 3: Subqueries, CTE & Indexing
  • Lesson 4: Connecting to a remote database, Dates, and Times
  • Lesson 5: Window/analytic functions, string functions, printf(), strftime()

Pre-knowledge

The knowledge of the basics of SQL is required. If you don’t have this knowledge, join our SQL and databases 1 course instead.

Knowledge of SQL as a secondary knowledge is useful for:

  • every programmer, as the vast majority of programs use databases to store data. Whether it’s a computer program, a website, or a mobile application,
  • general insight into the planning nature of the IT world,
  • deeper insight into working with data or working with spreadsheets,
  • development of general analytical and planning skills, useful even outside the profession related to SQL databases.

Schedule

The course takes place twice a week, each Monday and Thursday between 17:00 and 18:30 (5 sessions in total).

What do I need with me?

Each participant needs a computer with at least 4GB of RAM and a solid internet connection.

What if I miss a session?

Every student gets access to the Student dashboard where you can see all the lessons. If you miss some course sessions don’t worry – you can study the lesson on your own at home. There are also five recap lessons during the course where you can make up for the missing sessions.

Bonuses

  • Course completion certificate
  • Free 4-month access to JetBrains Academy learning materials to help you build your knowledge long after you finish the course
  • Online lessons that are held LIVE with the instructor, each course has guaranteed time to revise and review assignments
  • Access to curriculum and lesson videos forever
  • Involvement in the Slack channel, where you communicate with the instructor and students outside of lecture time
  • 20% discount on all future (undiscounted) Smartninja courses
eng sql and databases 2

249,00 

Date
june 2024
Instructor
Boštjan Cigan
Duration
7,5 hours
Sessions
5 lectures
Difficulty
Amateur