Ms SQL Server – e-Book – Professional Databases
DO YOU WANT TO LEARN DATABASES AND SQL ?
If you are interested in databases, you probably do not want to spend a lot of time learning and looking for appropriate solutions as much as I do.
I had to study, read many books, complete dozens of projects to gain knowledge at expert level. Working in profession since 2008, including a managerial position, I have noticed all factors that affect effectiveness of learning and allow me to independently solve many problems in database projects.
Note that what’s on Internet is chaos. There are no courses that, like mine, from very beginning have well-organized and very broad and specific knowledge given on a tray, literally STEP BY STEP.
ARE YOU HUNGRY FOR KNOWLEDGE AND WOULD YOU LIKE TO HAVE READY AND PRACTICAL MATERIALS “ON YOUR HAND” ?
While programming databases, I was constantly looking for specific solutions and possibilities to use SQL more effectively. You would probably also need ready-to-use solutions gathered in one place and available at any time.
As a longtime expert, I noticed what database programmers lacked, they lacked specialist knowledge, and they often did not manage to solve many problems in database projects on their own.
That is why you need to have constant access to ready-made solutions.
LOOKING FOR ADVANCED SOLUTIONS AND DATABASE TOOLS ?
Working with databases on a daily basis, I needed advanced methods that would give me opportunity to work at a higher level. You will probably also need ready-to-use solutions and information on advanced tools in one place, just like me.
Working with programmers and chasing project after project, I needed to constantly increase efficiency of team, so using available tools gave me such an opportunity.
I took this knowledge and prepared for you a free e-Book consisting of 78 pages, because requirements of current employers are very high.
Think to yourself that in 3-4 years you can earn up to PLN 15,000 / month in Poland.
But what if you don’t learn right thing and in an ineffective way?
Who is this e-Book for?
● both for people who are just starting their adventure with databases as well as those who already know SQL well
● for IT students who want to progress towards databases
● for database developers who want to improve their work with databases through advanced tools
✔️ Count of lessons: 14 ✔️ Count of additional scripts and files: 15 ✔️ Count of pages: 81 ✔️ Estimated study time: about 10 hours ✔️ Time access: unlimited 🎁 GIFT – information at the end of e-Book |
 |
1. Installing MsSQL Server 2019
➡ You will learn what version of SQL Server 2019 you can install on your operating system.
➡ You will learn entire SQL Server 2019 installation process.
2. SSMS Development Environment (SQL Server Management Studio)
➡ You will learn how to start a SQL Server server environment.
➡ You become familiar with main areas (elements) of SSMS interface.
3. Data Types
➡ You will learn about all data types supported by SQL Server.
➡ You learn to use basic data types correctly.
➡ You will learn how to format and project data types.
4. Creating (CREATE) and changing (ALTER) tables
➡ You will learn assumptions about creating tables.
➡ You learn to create tables.
➡ You will learn how to change structure of existing tables.
5. Database condurency
➡ You will learn what concurrency is.
➡ You will learn about problems associated with concurrency.
➡ You will learn types of locks related to concurrency.
➡ You will learn about insulation levels.
➡ You will learn how to handle interlocks.
6. UML: Design and modeling of database, models and diagrams
➡ You will learn what UML is.
➡ You will become familiar with many different UML models and diagrams.
➡ You will see how important it is to design and model databases.
7. CURSORS
➡ You will learn what a cursor is.
➡ You will learn pros and cons of using cursors.
➡ You will learn when and in what situations to use cursors.
➡ You will know if the cursor is a good solution.
8. Hierarchic data type: HIERARCHYID
➡ You will become familiar with hierarchical data type.
➡ You will learn about the elements of hierarchical structure.
➡ You will learn what are most common examples of this type of data.
➡ You will learn about the ways of storing hierarchical data.
➡ You will become familiar with properties of this data type.
➡ You will learn indexing strategies of a hierarchical data type.
➡ You will learn about available data extraction methods.
9. Error handling: ERROR MESSAGE, RAISERROR, TRY and CATCH, THROW
➡ You will learn about types of errors in SQL Server.
➡ You will learn what components of errors are.
➡ You will learn how to catch and handle errors.
➡ You will learn differences between types of errors.
10. TRIGGERS
➡ You will learn what triggers are in SQL Server.
➡ You learn to divide triggers into groups.
➡ You will become familiar with properties of triggers.
➡ You will learn about available options related to triggers.
11. Automatic mechanisms (Server Agent): JOBS
➡ You will learn what are “JOBs” in SQL Server.
➡ You will learn about the service (agent) responsible for work of JOBs.
➡ You will learn to create new JOBs step by step.
12. Functions and procedures in CLR code
➡ You will learn what CLR is.
➡ You will learn to integrate functions and procedures written in CLR code with SSMS.
➡ You will learn about additional settings required to use CLR.
13. Data import from a flat file: BULK INSERT
➡ You will learn ability to import data from flat files.
➡ You will learn how to import data from flat files using SQL scripts.
➡ You will learn how to import data from flat files using options in SSMS.
14. Full Text Search: FTS
➡ You will learn what FTS is and what it is for.
➡ You will learn to use FTS in practice.
#Free #Course #Online #MSSQL #SQL #Server #Microsoft #T-SQL #DataBase #SSMS #ManagementStudio
See other database courses:
➡ ALL COURSES [PL/EN]
