SQL Server and MongoDB Database Course

The SQL Server and MongoDB Database course is for those who want to start from scratch in the world of databases or want to consolidate their knowledge in the field of databases.

For this educational program it is recommended to have:

General presentation

Time schedule

Monday, Wednesday 17:30 - 20:00

term

4 months - 5 hours / week

Start date

September 15, 2021

This date is estimated and may change slightly depending on the number of entries and the length of the candidate selection process.

Study volume

85 hours

For individual study and homework we recommend at least one hour a day.

Apply now

BENEFITS

Employment Assistance

Constant support in getting a job by recommending the candidate for interviews in specialized companies

Course support

Access to SkillUp course support and study platform, even after graduation

Career counseling

Career workshops where you will learn how to write a resume and how to present yourself at the interview.

Discounts

Payment in advance

10% discount of the total cost of the course if you pay for the course 10 days before the start of the course.

recommendation

For every recommended friend who completes our courses, both you and your friend receive 5% discount.

The second course

Have you taken any of the Skill Up courses? You benefit from 5% discount for the next course.

Investment

Investment

Investment required to follow this program:
270 euro / month course (1080 euro total price)
* VAT is added for companies

Payment methods

  • Bank transfer
  • Cash deposit at the bank
Apply now

SQL Server and MongoDB course curriculum

  • Data Relationships
  • Normal forms
  • Design a database model
  • Relational databases
  • Other types of databases
  • ERM (Entity Relationship Modeling) and ORM (Object Relational Mapping)
  • SQL Server Management Studio (SSMS)
  • Database schema
  • CRUD operations
  • Join operations
  • SQL queries
  • Use of Null and DEFAULT constraints
  • Primary Key Constraints (PK)
  • Using indexes - UNIQUE constraint
  • External key constraints (FK)
  • Check constraint
  • What is a view?
  • Create a view that will produce a list of customers
  • Modified view tables
  • Indexable views
  • Partitioned views
  • What is a stored procedure?
  • Stored procedures with parameters
  • Returning data from the stored procedure
  • Calling a procedure from another procedure
  • What is a function?
  • How do I return data from a function?
  • What is a trigger?
  • What is a transaction?
  • Isolation levels
  • Locking
  • Data competition
  • How do we avoid DEADLOCK?
  • Debugging using SQL Server Management Studio
  • Error handling - Try / Catch
  • Managing failed transactions
  • What is an execution plan?
  • Capturing execution plans
  • How do we identify a poorly performing query?
  • Index maintenance
  • Maintenance of statistics
  • How to model NoSQL data
  • Document type databases (MongoDB)
  • RAW operations: Creating and returning objects
  • Relational databases vs. document databases
  • Which database is better: Relational or Document?
  • NoSQL best practices
  • Install MongoDB
  • MongoDB relationship mapping
  • Using an ORM (Mongoose) to work with data more easily
  • Command line
  • Using basic commands, handling files, folders without the user interface
  • Using GIT for version control and collaboration
  • Git fork, branch and cloning
  • Using GitHub as a remote repository
  • Checkout, checkin and rolling back changes using GIT
  • What is hosting and deployment?
  • Deploying a database
  • How do we make a resume stand out?
  • About me, the importance of the portfolio
  • Create your resume
  • Interview preparation - role exchange
  • What to expect during the technical interview
  • Show everything you know in an interview
  • Technical interview
  • I'm ready

Want more details about the Database course?

Fill out the form to be contacted by a career counselor

I have read and agree to the terms and conditions .