Click “SQL Database Development” above,
Set it as “top or star mark” to deliver dry goods in the first time
Hello, I’m Li Yue ~\
Often have small partner to ask me: yue elder brother, before you is how to learn SQL? Is there a quick way to get started? \
I am often too busy to give a systematic answer. Today, I would like to share with you some of my learning experience and methods during the weekend, hoping to be of some help to you.
All things are difficult before they are easy
Yes, when I started learning SQL, I only had the basics taught by my college teachers. Many of the associations between tables, subqueries, stored procedures, and so on are only heard about, but not really used.
Like most people, I started off like a headless chicken and didn’t know where to start. I also look for all kinds of learning materials everywhere. I have downloaded a lot of learning materials, including video tutorials of various databases and e-books. I also bought some physical books of paper versions.
These materials have really helped me a lot. In general, e-books > physical books > video tutorials. Yes, it was books that helped me learn more about databases.
Some of these e-books I have read, the better I have included in my public number menu bar.
I’m not recommending anything here, but I have a habit of collecting good stuff, and these books have helped me a lot.
But there are ways to read, many partners although collected a lot of information, but the learning method may have a bit of a problem, especially like I have eaten some learning methods of loss.
Remember at the beginning, reading always thought finished reading the book, knowledge will all into my mind, I will use SQL. But when I read one or two books, I realized THAT I was just finished. And then I realized that you can’t read roughly anymore, you have to read intensively, you have to write code by hand, even if it’s just tapping on the code in the book.
Yes, it worked, and it worked again and again. In accordance with this method has read the “Microsoft SQL Server 2008 technology insider” of the next two volumes, the SQL Server some operating principles and use methods are careful operation again.
You know, I used to only know some simple ways to use the database, but after reading these basic books, EVERY line of code I write I know how it goes into the database, how it is executed, etc.
There are some things that you really can’t understand better until you know how it works, which is a profound experience after reading these two books.
Practice once is better than watching a thousand times
Sometimes a knowledge point a look will, a written waste, resulting in such a situation is too little practice. \
I remember that when I first started working, I did some data statistics work, and the statistical needs were various every day, which indirectly forced me to write a lot of SQL code every day.
From initial data aggregation (including summary, counting, averaging, etc.) to later accumulation, N consecutive days, cycles, etc. The logic requirements are getting more and more complex, but they can always be solved in SQL code, thanks to the continuous writing every day.
Even now, I write all kinds of SQL logic every day. Whenever I solve a problem with SQL, I feel happy, which is probably a sense of achievement. \
So in addition to reading, usually also to ensure that a frequent write SQL state, let it become a part of you, I think if you can do so, it is not far from learning SQL.
Problems are the ladder to progress
Many friends are at a loss when they encounter problems and wish they could find someone to help them out directly. It’s great to find someone to help you out, but it’s best if you can figure it out and do it yourself. \
As you all know, database installation is a headache for beginners, at least for me at the beginning. Every time to install a computer, the kind of installation is not successful pain I think only experienced partners can understand.
So that the installation of too many times, fumbled out a few doorways, just know an installation but so. Yes, when you’ve stomped on every possible hole, you’ll know the safest way to go.
Similarly, we will encounter various problems when writing SQL, just like the above mentioned loop, do not know how to write? Look up information to imitate, there is no other good way, others can become, why can’t you become?
SQL on different platforms is the same
Many friends often say that they can use SQL of a certain platform, such as SQL Server, but not SQL of other platforms.
In fact, the basic syntax of SQL is the same, but the difference is the underlying data flow principle and some characteristics of each platform.
For example, there is a ceiling function in SQL Server. If you don’t know what the function is, search for the ceiling function directly. For example: Oracle ceiling, which corresponds to the ceil function in Oracle, and MySQL can use both.
Some of the more advanced knowledge points, although written in a large difference, but their principles are generally similar, so if you really know SQL, don’t be afraid of their useless database platform.
Today, share so much temporarily, if it helps you, remember to help forward + like, thank you
I am my brother Yue, and finally I would like to share with you the PDF electronic version of MY SQL two-piece set: "SQL Basics 2nd Edition" and "SQL Advanced 2nd Edition". There are various grammar explanations, a large number of examples and annotations, and so on, very easy to understand, convenient for everyone to follow together to practice. There is a need for readers can download learning, in the following public number "data front" (not this number) back keyword: SQL, on the line data front -- End -- back keyword:1024, to obtain a carefully organized technical dry goods background reply keywords: into the group, take you into the master like clouds of communication group. Do SQL queries always start with a SELECT statement? SQL advanced skills (top) ultra complete collation, MySQL common functionsCopy the code