ms sql database

hi,

i am new to ms sql database.

where i have to start reading learning more about this database and stored proce, funtions rules, syntax etc.
i connected usning microsoft sql server management studio to 3 environments like ST, INT, PT etc .

how to save sessions so that next time when i open microsoft sql server management studio i do not have to click again connect then datanase engine then give password etc.


please advise
LVL 7
gudii9Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Eyeballeth thy article SQL Server Training for multiple answers to your question.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ITSysTechSenior Systems AdministratorCommented:
If you chose under Authentication "Windows Authentication" and you have admin rights on the MSSQL server then you will be able to quickly log in to any server you have.


1.JPG
0
Bill PrewIT / Software Engineering ConsultantCommented:
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

pcelbaCommented:
You should start with queries and commands which are common to all SQL engines. Look at the tutorials available on the net (e.g. https://www.w3schools.com/sql/) and then you may continue with the more specific features which have syntax slightly different.

You have to always connect to SQL Server when starting SSMS. You may make it easier by setting up Windows authentication in SQL Server. Look here how to do it: https://docs.microsoft.com/en-us/sql/relational-databases/security/choose-an-authentication-mode
You don't need to provide any passwords in such case.

When yo start a new query window in SSMS you may save its content into a text file and read it again next time.

To study MS SQL you may search for free ebooks, e.g. here: https://mva.microsoft.com/ebooks# or here: https://info.microsoft.com/Introducing-SQL-Server-2016-eBook.html
0
Pawan KumarDatabase ExpertCommented:
My Myntra is - > Learn Concepts , Write more and more queries and more queries , Solve SQL Puzzles and win it.

I suggest you to start writing queries. The more your write the more you learn and understand how things works in SQL Server. A good place to start writing queries is https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/, here you will get almost 300 puzzles you can solve by writing queries. You can also get multiple solution which is another way to learn things.

You also need to understand the SQL Server concepts. A good place to start is https://msbiskills.com/t-sql/

Once you learn all the above things then you need to go deep into the system and understand how we can improve the performance of the queries and the entire SQL Server.  For that you can refer - https://msbiskills.com/sql-performance-tuning/

I am providing you a good page where you will links of websites world class SQL SERVER authors -  https://msbiskills.com/sql-server-resources/

Good luck with your learning.
0
EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
Q: <how to save sessions so that next time when i open microsoft sql server management studio i do not have to click again connect then datanase engine then give password etc.>

A: try to register your sql server
Registering SQL Server instances for easier management
https://www.mssqltips.com/sqlservertip/1996/registering-sql-server-instances-for-easier-management/
more:
https://docs.microsoft.com/en-us/sql/ssms/register-servers/register-a-connected-server-sql-server-management-studio
--

Sql education:
Free Microsoft training
https://mva.microsoft.com/

--free reading "the source"
SQL Server Books Online
https://technet.microsoft.com/en-us/library/ms130214(v=sql.105).aspx
0
Pawan KumarDatabase ExpertCommented:
Question abandoned
Valid suggestions.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.