Professional Database STEP BY STEP + Exercises

Build a professional database literally STEP BY STEP

 
This course is intended for people who know basics of SQL and want to learn to program professional databases in Ms SQL Server. Scope of course will allow you to build a professional database from scratch to advanced solutions that are used in production databases in many very large companies. The lessons come with ready-to-use files and scripts with detailed comments and descriptions to help you quickly and easily understand all code blocks. The course also includes exercises to do, which are based on previous implementations that I have made, which should be followed.

 

I have developed this course in an unprecedented form.
All EXERCISES after they are done are in effect
“Professional database” built literally STEP BY STEP.
It is FIRST online course in Poland after which
you have completed YOU WILL RECEIVE A PROFESSIONAL DATABASE !!!
Thanks to this formula, you are able to build an Ms SQL database
“following pattern” FOR EVERY SYSTEM, WHAT YOU NEED ONLY! 

 
Who is this course for?
● for people who already know at least basics of SQL
● for IT students who want to learn STEP-BY-STEP database design
● for database developers who want to additionally practice database solutions

 
I give you opportunity to design a professional database STEP BY STEP:
● lessons are in form of condensed knowledge in form of articles and useful graphics showing step-by-step problem solving (not in form of a video) in same form as entries on this blog
● ready-made SQL files and scripts with detailed comments are attached to lesson, so that you can understand all code blocks without any problems, my observations and remarks are also described
● other courses don’t work because they’re chaotic and incomplete, but you can handle my methods
● time access as well as number and sequence of access to lessons is unlimited
● finally reach for a very extensive knowledge that no other courses in one place offer
● in contrast to very expensive training sessions in room, I also give you personal e-mail support.

 
ATTENTION ! It is very important that all lessons are done consecutively. Subsequent lessons use objects that are created in previous lessons. 

 
✔️ Count of lessons: 27
✔️ Count of additional scripts and files: 20
✔️ Estimated study timei: about 34 hours and 00 minutes
✔️ Time access: unlimited
✔️ Count and sequence of access to lessons: unlimited

 
1. Introduction
  ➡ You will learn what is included in the course.
  ➡ You will known yourself with field of professional database, which you will build in full step by step.
  ➡ You will see what exercises for self-implementation will look like.

2. Preliminary description of database functioning environment
  ➡ You will find out what database will be.
  ➡ You will describe database functioning environment.

3. Description of functioning of database
  ➡ You will learn what the database will be used for.
  ➡ You will describe operation of database.

4. Detailed definition of database function
  ➡ You will learn what functions database will perform.
  ➡ You will describe database functions in detail.

5. Legal conditions of database
  ➡ You will be learn why you should consider legal conditions of database.
  ➡ You will describe legal aspects that need special attention.

6. Specification of database requirements
  ➡ You will be learn what database requirements are.
  ➡ You will describe database requirements.

7. Data structure design and database diagram
  ➡ You will specify the database model.
  ➡ You will provide a database diagram.
  ➡ You will develop type of data collected.
  ➡ You will present data structure.
  ➡ You can describe relationships between data in detail.
  ➡ You will write down technological conditions.
  ➡ You will practice building a database diagram.

8. Data modeling
  ➡ You will learn what data modeling means.
  ➡ You will understand at what stage of project implementation you should use data modeling.
  ➡ You will learn tools for data modeling.

9. Diagram of use cases
  ➡ You will learn what is it a diagram of use case.
  ➡ You will understand what it is for and how it is used.
  ➡ You will practice building a use case diagram.

10. Activity diagram
  ➡ You will learn what an activity diagram is.
  ➡ You will understand what it is used for and how it is used.
  ➡ You will practice building an activity diagram.

11. Entity relationship diagrams
  ➡ You will learn what an entity relationship diagram is.
  ➡ You will understand what it is used for and how it is used.
  ➡ You will practice building entity relationship diagram.

12. Physical data model
  ➡ You will learn what a physical data model is.
  ➡ You will understand what it is used for and how it is used.
  ➡ You will practice building a physical data model.

13. Create database and tables
  ➡ You will create a database.
  ➡ You will implement tables.
  ➡ You are programming master keys.
  ➡ You will write constraints and restrictions on table columns.
  ➡ You will learn how to name objects in database.
  ➡ You will learn how to describe tables and columns.
  ➡ You will prepare first database diagram.

14. Foreign keys and indexes
  ➡ You will create foreign keys, i.e. references between tables.
  ➡ You will create indexes on specific table columns.

15. Creating a database and log table
  ➡ You will learn why database with logs is being created.
  ➡ You will create a database with required tables.

16. Triggers for data operations
  ➡ You will learn what triggers in SQL Server are.
  ➡ You will learn to divide triggers into groups.
  ➡ You will learn about properties of triggers.
  ➡ You will learn about available options related to triggers.
  ➡ You will practice implementation of triggers.

17. Data dictionaries and log analysis
  ➡ You will learn what data dictionary structures are and what they are used for.
  ➡ You will create data dictionaries.
  ➡ You will learn to analyze logs regarding data operations.
  ➡ You will practice creating dictionaries and analyzing logs.

18. Procedures for performing data operations
  ➡ You will learn for what purpose  procedures will be needed.
  ➡ You will learn how to monitor operation of procedures.
  ➡ You will practice implementation of procedures.

19. Inserting sample data
  ➡ You will use routines to insert data.
  ➡ You will insert sample data for next lessons.

20. Dynamic data search
  ➡ You will learn what dynamic queries are and what they are used for.
  ➡ You will learn about dangers of this type of query.
  ➡ You will learn what SQL INJECTION is.
  ➡ You will learn to implement dynamic queries.
  ➡ You will practice implementation of this type of query.

21. Other procedures for supporting processes occurring in database
  ➡ You will implement further, extended procedures.
  ➡ You will consolidate way of monitoring operation of procedures.
  ➡ You practice error handling.
  ➡ You will implement validation of procedure input parameters.
  ➡ You persist implementation of transaction.
  ➡ You practice testing new procedures.

22. Additional functions supporting work of end user of database
  ➡ You will see what solutions are worth using to improve work of end user.
  ➡ You will prepare scripts to improve your work.

23. Ways of searching objects in SSMS
  ➡ You will find helpful queries in search of objects.
  ➡ You will learn to use filtering in SSMS.
  ➡ You will learn about differences in use during above methods of filtering objects.
  ➡ You will learn why these methods will be helpful.

24. View
  ➡ You will learn what is it views.
  ➡ You become familiar with types of views.
  ➡ You will learn how to implement them.

25. Full-Text Search: FTS
  ➡ You will learn what FTS is and what it is for.
  ➡ You will see why you should use it.
  ➡ You will learn to use TFS in practice.

26. Automatic archiving (backup) of the database
  ➡ You will learn what database archiving models are.
  ➡ You will understand why BackUp is so important.
  ➡ You will learn how to do a database backup in practice.
  ➡ You will automate database backup.

27. Additional exercises to be performed + tips
  ➡ You will see what new functionalities can still be implemented.
  ➡ You will practice implementing many new objects.
  ➡ You will learn to expand existing solutions.
  ➡ You will learn valuable tips for each exercise.
  ➡ You will learn to write clear SQL code.

 
#Kurs #Online #MSSQL #SQL #Server #Microsoft #T-SQL #DataBase #SSMS #ManagementStudio 

 
See other database courses:
  ➡ ALL COURSES [PL/EN]

 

Zamów